This book is a comprehensive, clear and gentle introduction to all fundamental aspects of SQL Server 2005 Express and the T-SQL database language. It assumes no prior experience in databases or programming and is ideal for any new SQL Server Express user, whatever their use of SQL Server Express. SQL Server 2005 Express Edition is a free relational database management system from Microsoft and provides a major subset of full SQL Server 2005 functionality. Many users learn on SQL Server 2005 Express Edition and then move on to SQL Server 2005. Users can also develop significant real-world solutions in SQL Server 2005 Express Edition and then migrate them to the full version. In fact, for small databases and organizations, the Express Edition is often adequate on its own to support business needs and its user base is rapidly growing.

Autorentext
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.

Klappentext

SQL Server 2005 Express Edition is a free relational database management system from Microsoft and provides a major subset of full SQL Server 2005 functionality. Many users learn on SQL Server 2005 Express Edition and then move on to SQL Server 2005. This book is a comprehensive, clear and gentle introduction to all fundamental aspects of SQL Server 2005 Express and the T-SQL database language. It is highly readable yet technically thorough. The book assumes no prior experience in databases or programming and is ideal for any new SQL Server Express user, whatever their use of SQL Server Express.

Zusammenfassung

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.

Inhalt
SQL Server 2005 Express Overview and Installation.- SQL Server Management Studio Express.- Database Design and Creation.- Security.- Defining Tables.- Creating Indexes and Database Diagramming.- Database Backup, Recovery, and Maintenance.- Working with the Data.- Building a View.- Stored Procedures.- T-SQL Essentials.- Advanced T-SQL.- Triggers.- SQL Server 2005 Reporting Services.