Sams Teach Yourself SQL Server 2005 Express in 24 Hours

Introduction 1



PART I: Introduction to SQL Server

Hour 1 Basic Relational Database Design 7

2 SQL Server Basics 25

3 Getting to Know the SQL Server management Studio 43



PART II Working with Tablies, Views, and Stored Procedures

Hour 4 SQL Server Tables 61

5 Working with Table Relationships 79

6 Getting to Know the SELECT Statement 97

7 Building SQL Statements Based on Multiple Tables 111

8 Modifying Data with Action Queries 127

9 Getting to Know the T-SQL Functions 131

10 Working with SQL Server Views 149

11 Creating Complex Views 161

12 Using T-SQL to Design SQL Server Stored Procedures 177

13 Important Stored Procedure Techniques 195

14 Stored Procedure Special Topics 213

15 ADO.NET and SQL Server 223

16 Using VB to Design SQL Server Stored Procedures 249

17 Visual Basic .NET Special Topics 271

18 Using C# to Design SQL Server Stored Procedures 287

19 C# Special Topics 309

20 DeBugging the Stored Procedures 325



PART III Security and Administration

Hour 21 SQL Server Authentication 349

22 SQL Server Permissions Validation 369

23 Configuring, Maintaining, and Tuning SQL Server 387

24 Performance Monitoring 403



APPENDIX A Using the NorthWind Sample Database File 417



Index 421