Introducing SQL Server

Introducing SQL Server does exactly that; it introduces SQL Server. It concentrates on the core skills professionals need to be successful with SQL Server, using a holistic approach to show how the various parts of SQL Server complement each other. The book is a short and easy read unintimidating yet sure to please. It avoids the overly-deep approach of other "beginner" books on the topic in favor of getting across what really matters in as short a time as possible.

Introducing SQL Server teaches the knowledge and skills needed to begin your journey toward becoming a solid and competent SQL Server professional and database programmer.

Autorentext

Mike McQuillan is a software and database specialist who lives with his wife and daughter in the United Kingdom. Mike is a polyglot programmer who began messing around with computers in the 1980s, firstly with an Atari 800XL and then a Sinclair Spectrum. He took up databases in the 1990s, and quickly fell in love with SQL. He's been working with SQL Server since version 7, and is a SQL Server MCSA. When he's not tinkering with computers, Mike enjoys taking the family on walks around Cheshire with the family pups, Dolly and Bertie.

Zusammenfassung
Introducing SQL Server is a fast and easy introduction to SQL Server and the world of relational databases.

Inhalt

1: What is SQL Server?.-2: Obtaining and Installing SQL Server.-3: Database Basics.-4: Tables.-5: Putting Good Tables Together.-6: Automating Deployment with SQLCMD.-7: NULLs and Table Constraints.-8: Inserts, Updates, and Deletes.-9: Bulk Inserting Data.-10: Creating Data Import Scripts.-11: The SELECT Statement.-12: Joining Tables.-13: Views.-14: Indexes.-15: Transactions.-16: Functions.-17: Table-Valued Functions.-18: Stored Procedures Part 1.-19: Stored Procedures Part 2.-20: Bits and Pieces.-Appendix A: SQL Data Types.-Appendix B: Glossary.- Appendix C: Common SQL Server System Objects.-Appendix D: Exercises<p