Cover image for Sams Teach Yourself Microsoft SQL Server 2005 Express in 24 Hours

Sams Teach Yourself Microsoft SQL Server 2005 Express in 24 Hours

Author Alison Balter
Release Date: 2006/06/01
ISBN: 0672327414
Topic:
0%
39
Chapters
0-1
Hours read
0k
Total Words
    Start Reading Now    
       Add to Wishlist       
View table of contents

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

    1. Title Page
    2. Copyright Page
    3. Contents at a Glance
    4. Table of Contents
    5. About the Author
    6. Dedication
    7. Acknowledgments
    8. Tell Us What You Think!
    9. Introduction
    10. Part I: Introduction to SQL Server
      1. Hour 1 Basic Relational Database Design
      2. Hour 2 SQL Server Basics
      3. Hour 3 Getting to Know the SQL Server Management Studio
    11. Part II: Working with Tables, Views, and Stored Procedures
      1. Hour 4 SQL Server Tables
      2. Hour 5 Working with Table Relationships
      3. Hour 6 Getting to Know the SELECT Statement
      4. Hour 7 Building SQL Statements Based on Multiple Tables
      5. Hour 8 Modifying Data with Action Queries
      6. Hour 9 Getting to Know the T-SQL Functions
      7. Hour 10 Working with SQL Server Views
      8. Hour 11 Creating Complex Views
      9. Hour 12 Using T-SQL to Design SQL Server Stored Procedures
      10. Hour 13 Important Stored Procedure Techniques
      11. Hour 14 Stored Procedure Special Topics
      12. Hour 15 ADO.NET and SQL Server
      13. Hour 16 Using VB to Design SQL Server Stored Procedures
      14. Hour 17 Visual Basic .NET Special Topics
      15. Hour 18 Using C# to Design SQL Server Stored Procedures
      16. Hour 19 C# Special Topics
      17. Hour 20 Debugging the Stored Procedures That You Write
    12. Part 3: Security and Administration
      1. Hour 21 SQL Server Authentication
      2. Hour 22 SQL Server Permissions Validation
      3. Hour 23 Configuring, Maintaining, and Tuning SQL Server
      4. Hour 24 Performance Monitoring
    13. Appendix A: Using the NorthWind Sample Database File
    14. Index
    18.119.107.96