|
Teach Yourself SQL Server 2005 Express in 24 Hours Starter Kit
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.
CONTENTS:
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
|
