Sams Teach Yourself Microsoft SQL Server 2005 Express in 24 Hours

Overview

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 ...

See more details below
(Book & CD-ROM)
$31.49
BN.com price
(Save 10%)$34.99 List Price

Pick Up In Store

Reserve and pick up in 60 minutes at your local store

Other sellers (Other Format)
  • All (20) from $1.99   
  • New (3) from $86.63   
  • Used (17) from $1.99   
Sams Teach Yourself SQL Server 2005 Express in 24 Hours

Available on NOOK devices and apps  
  • NOOK Devices
  • Samsung Galaxy Tab 4 NOOK 7.0
  • Samsung Galaxy Tab 4 NOOK 10.1
  • NOOK HD Tablet
  • NOOK HD+ Tablet
  • NOOK eReaders
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK for PC
  • NOOK for Mac

Want a NOOK? Explore Now

NOOK Book (eBook)
$15.49
BN.com price
(Save 44%)$27.99 List Price

Overview

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.
Read More Show Less

Product Details

  • ISBN-13: 9780672327414
  • Publisher: Sams
  • Publication date: 6/30/2006
  • Series: Sams Teach Yourself Series
  • Edition description: Book & CD-ROM
  • Pages: 436
  • Sales rank: 1,472,512
  • Product dimensions: 7.00 (w) x 9.12 (h) x 1.06 (d)

Meet the Author

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.
Read More Show Less

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

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)