Computers & Internet Books:

Microsoft Sams Teach Yourself SQL Server 2005 Express in 24 Hours

Sorry, this product is not currently available to order

Here are some other products you might consider...

Microsoft Sams Teach Yourself SQL Server 2005 Express in 24 Hours


Mixed media product

Customer rating

Click to share your rating 0 ratings (0.0/5.0 average) Thanks for your vote!

Share this product

Microsoft Sams Teach Yourself SQL Server 2005 Express in 24 Hours by Alison Balter
Sorry, this product is not currently available to order


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. 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, and triggers using T-SQL, VB.NET, and C#. Finally, you will learn how to output SQL Server data to reports, and the Internet.

Table of 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

Author Biography

Alison Balter is the founder of InfoTechnology Partners, Inc., a California-based computer consulting firm. Alison is a highly experienced independent trainer and consultant, specializing in the development of client/server applications using SQL Server, which gives her the practical experience needed to bring real-life examples to this book. During her twenty years in the computer industry, she has trained and consulted with many corporations and government agencies, including Shell Oil, Prudential Insurance and the Archdiocese of Los Angeles. Alison is also the author of over 300 internationally marketed computer training videos.
Release date NZ
October 31st, 2005
Country of Publication
United States
Sams Publishing
Product ID

Customer reviews

Nobody has reviewed this product yet. You could be the first!

Write a Review

Marketplace listings

There are no Marketplace listings available for this product currently.
Already own it? Create a free listing and pay just 9% commission when it sells!

Sell Yours Here

Help & options

  • If you think we've made a mistake or omitted details, please send us your feedback. Send Feedback
  • If you have a question or problem with this product, visit our Help section. Get Help
Filed under...

Buy this and earn 379 Banana Points