My Account
Log in Registration
All
Cart
Highlights
Fiction Books
Non-Fiction Books
Children's Books
Rare Books
Music
DVD & Blu-Ray
Video Games
Category
Wishlists
Cart
All
Free Shipping in the UK
Trustpilot
Proud to be B-Corp

Microsoft Sams Teach Yourself SQL Server 2005 Express in 24 Hours Alison Balter

Microsoft Sams Teach Yourself SQL Server 2005 Express in 24 Hours By Alison Balter

Microsoft Sams Teach Yourself SQL Server 2005 Express in 24 Hours by Alison Balter

Reviews:
£4.00
New RRP £24.50
Condition - Very Good
Only 3 left
Very Good

Summary

Covers the basics of Microsoft's SQL Server. This book includes coverage from basic concepts to an intermediate level in 24 one-hour lessons. It helps you learn the basic tasks necessary for the administration of SQL Server 2005. It shows how to write and utilize: SQL Server stored procedures; functions; and, triggers using T-SQL, VB.NET, and C#.

Microsoft Sams Teach Yourself SQL Server 2005 Express in 24 Hours Summary

Microsoft Sams Teach Yourself SQL Server 2005 Express in 24 Hours by Alison Balter

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.

About Alison Balter

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.

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

Additional information

GOR002372463
9780672327414
0672327414
Microsoft Sams Teach Yourself SQL Server 2005 Express in 24 Hours by Alison Balter
Alison Balter
Used - Very Good
Hardback
Pearson Education (US)
20060629
456
N/A
Book picture is for illustrative purposes only, actual binding, cover or edition may vary.
This is a used book - there is no escaping the fact it has been read by someone else and it will show signs of wear and previous use. Overall we expect it to be in very good condition, but if you are not entirely satisfied please get in touch with us

Customer Reviews - Microsoft Sams Teach Yourself SQL Server 2005 Express in 24 Hours