• Print
  • Share
Microsoft SQL Server 2005 Programming For Dummies (0470128593) cover image

Microsoft SQL Server 2005 Programming For Dummies

ISBN: 978-0-470-12859-6
416 pages
April 2007
How to read this e-book on:
Adobe e-books are read using Adobe Digital Editions. Install Adobe Digital Editions on your PC in order to read or transfer your e-book.

Part I: Get Started Using the SQL Server 2005 Development Environment.

Chapter 1: The Joy of SQL Server 2005 Programming.

Chapter 2: Understanding Database Fundamentals.

Chapter 3: Getting to Know the SQL Server Toolset.

Part II: Retrieving Data Using Transact-SQL.

Chapter 4: Retrieving Data Using the SELECT Statement.

Chapter 5: Creating Joins.

Chapter 6: Creating Advanced Queries.

Chapter 7: Manipulating Data.

Part III: Creating Databases and Database Objects with Transact-SQL.

Chapter 8: Designing, Creating, and Altering Database Objects.

Chapter 9: Designing, Creating, and Changing Tables.

Chapter 10: Applying Constraints.

Chapter 11: Creating Views.

Chapter 12: Using Stored Procedures.

Chapter 13: Using Triggers.

Chapter 14: Creating Functions.

Chapter 15: Creating Indexes.

Chapter 16: Handling Errors Using TRY . . . CATCH.

Part IV: Programming SQL Server Security.

Chapter 17: Adding Logins and Users.

Chapter 18: Creating Database-Level Security.

Chapter 19: Securing Data Using Encryption.

Part V: Beyond Transact-SQL Programming.

Chapter 20: Working with XML.

Chapter 21: Working with the Common Language Runtime.

Chapter 22: Using Visual Studio 2005.

Chapter 23: Working with SQL Server Management Objects.

Part VI: The Part of Tens.

Chapter 24: Ten Tips to Program Like a Pro.

Chapter 25: Ten Sources for More Information on SQL Server 2005.


  • Print
  • Share