Home > Store > Data > SQL Server

larger cover

Add To My Wish List

Register your product to gain access to bonus material or receive a coupon.

Sams Teach Yourself SQL Server 2005 Express in 24 Hours

eBook (Adobe DRM)

  • Your Price: $22.39
  • List Price: $27.99
  • About Adobe DRM eBooks
  • This eBook requires the free Adobe® Digital Editions software.

    Before downloading this DRM-encrypted PDF, be sure to:


    • Install the free Adobe Digital Editions software on your machine. Adobe Digital Editions only works on Macintosh and Windows, and requires the Adobe Flash Player. Please see the official system requirements.
    • Authorize your copy of Adobe Digital Editions using your Adobe ID (select AdobeID as the eBook vendor). If you don't already have an Adobe ID, you can create one here.
  • Description
  • Sample Content
  • Updates
  • Copyright 2006
  • Dimensions: 7" x 9-1/8"
  • Pages: 448
  • Edition: 1st
  • eBook (Adobe DRM)
  • ISBN-10: 0-7686-6692-9
  • ISBN-13: 978-0-7686-6692-2

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

                 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 

FREE

ONE MONTH ACCESS!

WITH PURCHASE


Get unlimited 30-day access to thousands of Books & Training Videos about technology, professional development and digital media If you continue your subscription after your 30-day trial, you can receive 30% off a monthly subscription to the Safari Library for up to 12 months.