Sams, 2006. — 456 p. — ISBN10: 0-672-32741-4 ; ISBN13: 978-0-672-32741-4.
Written with clarity and a down-to-earth approach, Sams Teach Yourself SQL Server 2005 Express in 24 Hours covers the basics of Microsoft's latest version of SQL Server. Expert author Alison Balter takes you from basic concepts to an intermediate level in 24 one-hour lessons. You will learn all of the basic tasks necessary for the administration of SQL Server 2005. You will also learn how to write and fully utilize:
SQL Server stored procedures
Functions
Triggers using T-SQL, VB.NET, and C#
You will also learn how to output SQL Server data to reports and the Internet. Sams Teach Yourself SQL Server 2005 Express in 24 Hours is a well-organized, authoritative introduction that will quickly have you up and running with SQL Server 2005.
Introduction to SQL ServerHour 1. Basic Relational Database Design
Hour 2. SQL Server Basics
Hour 3. Getting to Know the SQL Server Management Studio
Working with Tables, Views, and Stored ProceduresHour 4. SQL Server Tables
Hour 5. Working with Table Relationships
Hour 6. Getting to Know the SELECT Statement
Hour 7. Building SQL Statements Based on Multiple Tables
Hour 8. Modifying Data with Action Queries
Hour 9. Getting to Know the T-SQL Functions
Hour 10. Working with SQL Server Views
Hour 11. Creating Complex Views
Hour 12. Using T-SQL to Design SQL Server Stored Procedures
Hour 13. Important Stored Procedure Techniques
Hour 14. Stored Procedure Special Topics
Hour 15. ADO.NET and SQL Server
Hour 16. Using VB to Design SQL Server Stored Procedures
Hour 17. Visual Basic .NET Special Topics
Hour 18. Using C# to Design SQL Server Stored Procedures
Hour 19. C# Special Topics
Hour 20. Debugging the Stored Procedures That You Write
Security and AdministrationHour 21. SQL Server Authentication
Hour 22. SQL Server Permissions Validation
Hour 23. Configuring, Maintaining, and Tuning SQL Server
Hour 24. Performance Monitoring