|
Microsoft SQL Server 2005 Programming for Dummies
* What the book covers: Microsoft SQL Server 2005 Programming For Dummies shows developers how to program databases in SQL Sever 2005 with Transact-SQL (the basic programming language found in SQL Server) and with SQL Server 2005's extended programming functionality: SQL - XML (SQL Server's Extensible Markup Language), SQL-CLR (SQL Server's .NET language
capabilities), and SQL-SMO (SQL Management Objects). All this programming functionality lets users construct, populate, secure, and utilize databases. This book walks readers through the SQL Server components that allow users to create programming code in SQL Server 2005. It then covers the methods used to create databases and database objects in those databases; how to get in and out of databases and database objects; and the methods and concepts needed to secure databases and the data contained in them. It then moves on to coverage of how to use Transact-SQL statements to extend the basic functionality of queries and how to use the extended programming functionality in SQL Server 2005 to take advantage of the database's newer programming languages: SQL - XML (SQL Server's Extensible Markup Language), SQL-CLR (SQL Server's .NET language capabilities), and SQL-SMO (SQL Management Objects).
* Series features: Microsoft SQL Server 2005 Programming For Dummies is written in the friendly, humorous, and easy-to-understand style that is the hallmark of the For Dummies brand.
Introduction.
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.
Index.
|
