Beginning SQL Server 2005 Express for Developers: From Novice to Professional

Front Cover
Apress, Apr 30, 2007 - Computers - 464 pages

Assuming neither database nor programming background, Beginning SQL Server 2005 Express for Developers introduces all the fundamental database administration and SQL programming features of SQL Server 2005 Express Edition, the free relational database management system from Microsoft that provides a major subset of full SQL Server 2005 functionality.

This book is a comprehensive guide that covers installing and configuring SQL Server 2005 Express, creating, backing up, and restoring databases, creating tables, then querying and manipulating them with T-SQL, coding stored procedures and triggers, and using Reporting Services to deliver information to end users. Detailed, clear, and highly readable, this book will make you a competent and confident database administrator and programmer.

  • This is the clearest and most comprehensive introduction to SQL Server 2005 Express.
  • The book assumes no prior experience with databases, SQL, or programming.
  • Youll learn about both database administration and T-SQL programming.
  • The book covers SQL Server Management Studio and Reporting Services.
 

What people are saying - Write a review

We haven't found any reviews in the usual places.

Contents

Figure 13 Registration page
7
Figure 17 Authentication choices
11
SQL Server Management Studio
21
Figure 234 SAC tool selection
41
Database Design and Creation
45
Figure 35 Foreign keys in same table
62
Figure 39 General settings in the New Database screen
68
Figure 316 Failed database deletion
81
Figure 73 Database backup options
175
4 This code replicates the Truncate the Transaction Log option
186
Figure 719Where to store the script
205
Figure 721 Generating the script
206
Working with the Data
209
Building a View
267
Stored Procedures
291
TSQL Essentials
313

Security
85
Figure 44 Creating a new login
87
Figure 419 Schemas applied
100
Figure 422 Assigning AJMason to db_owner
102
Defining Tables
105
Creating Indexes and Database
137
Figure 614 Tables with relationships built so far
161
Database Backup Recovery and
167
Advanced TSQL
351
Triggers
373
SQL Server 2005 Reporting Services
395
Type ApressFinancial Reports in the Name text box as shown
402
Figure 145 Design the Query window
404
Glossary of Terms
415
Copyright

Other editions - View all

Common terms and phrases

Popular passages

Page 16 - Install but do not configure the server Setup will install the report server and configure it to use the default values. The report server is usable as soon as Setup is finished. A Secure Socket Layer (SSL) certificate is not installed on this computer. Microsoft recommends that you use SSL in most Reporting Services installations. Help Figure 1-11.
Page 16 - SQL collations (used for compatibility with previous versions of SQL Server) Binary order based on code point comparison, for use with the 850 (Multilingual...

About the author (2007)

Robin Dewson has been hooked on programming ever since he bought his first computer, a Sinclair ZX80, in 1980. He has been working with SQL Server since version 6.5 and Visual Basic since version 5. Robin is a consultant mainly in the city of London, where he has been for nearly eight years. He also has been developing a rugby-related website as well as maintaining his own site at Fat-Belly.com.

Bibliographic information