Book description
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.
Table of contents
- Title Page
- Copyright Page
- Contents at a Glance
- Table of Contents
- About the Author
- Dedication
- Acknowledgments
- Tell Us What You Think!
- Introduction
- Part I: Introduction to SQL Server
-
Part II: Working with Tables, Views, and Stored Procedures
- Hour 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
- Part 3: Security and Administration
- Appendix A: Using the NorthWind Sample Database File
- Index
Product information
- Title: Sams Teach Yourself Microsoft SQL Server 2005 Express in 24 Hours
- Author(s):
- Release date: June 2006
- Publisher(s): Sams
- ISBN: 9780672327414
You might also like
book
Microsoft® SQL Server® 2008 Step by Step
Teach yourself SQL Server 2008—one step at a time. Get the practical guidance you need to …
book
Microsoft® SQL Server® 2008 Administrator's Pocket Consultant
Get the practical, pocket-sized guide for IT professionals who need to administer, maintain, and optimize SQL …
book
Microsoft® SQL Server™ 2005 Administrator's Pocket Consultant
Here’s the utterly practical, pocket-sized reference for IT professionals who need to administer, optimize, and maintain …
book
Microsoft® SQL Server 2005: Changing the Paradigm (SQL Server 2005 Public Beta Edition)
Microsoft SQL Server 2005: Changing the Paradigm (SQL Server 2005 Public Beta Edition) will prepare database …