Star Wars Sale
 
 

Special Offers see all

Enter to WIN!

Weekly drawing for $100 credit. Subscribe to PowellsBooks.news for a chance to win.
Privacy Policy

More at Powell's


Recently Viewed clear list


Original Essays | June 20, 2014

Lauren Owen: IMG The Other Vampire



It's a wild and thundery night. Inside a ramshackle old manor house, a beautiful young girl lies asleep in bed. At the window, a figure watches... Continue »
  1. $18.90 Sale Hardcover add to wish list

    The Quick

    Lauren Owen 9780812993271

spacer

This item may be
out of stock.

Click on the button below to search for this title in other formats.


Check for Availability
Add to Wishlist

Other titles in the Sams Teach Yourself...in 24 Hours series:

Microsoft(r) Sams Teach Yourself SQL Server(tm) 2005 Express in 24 Hours (Sams Teach Yourself...in 24 Hours)

Microsoft(r) Sams Teach Yourself SQL Server(tm) 2005 Express in 24 Hours (Sams Teach Yourself...in 24 Hours) Cover

 

Synopses & Reviews

Publisher Comments:

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.

Book News Annotation:

The 24 lessons in this beginner's guide demonstrate how to build tables, relationships, views, and stored procedures in SQL Server 2005 express, write T-SQL statements and queries, and ensure only valid users have access to a database. The CD-ROM contains Microsoft Visual Basic 2005 express edition and SQL Server 2005 express edition.
Annotation 2006 Book News, Inc., Portland, OR (booknews.com)

Book News Annotation:

The 24 lessons in this beginner's guide demonstrate how to build tables, relationships, views, and stored procedures in SQL Server 2005 express, write T-SQL statements and queries, and ensure only valid users have access to a database. The CD-ROM contains Microsoft Visual Basic 2005 express edition and SQL Server 2005 express edition. Annotation ©2006 Book News, Inc., Portland, OR (booknews.com)

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

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 

Product Details

ISBN:
9780672327414
Publisher:
Sams
Subject:
Client-server computing
Author:
Balter, Alison
Subject:
Relational databases
Subject:
Database Management - SQL Server
Subject:
Database Management - General
Subject:
Database-SQL
Subject:
Database design
Copyright:
Edition Description:
Trade paper
Series:
Sams Teach Yourself Sams Teach Yourself -- Hours
Publication Date:
June 2006
Binding:
TRADE PAPER
Grade Level:
Professional and scholarly
Language:
English
Illustrations:
Y
Pages:
456
Dimensions:
9.12 x 7 x 1.066 in 739 gr

Related Subjects

Arts and Entertainment » Music » General
Arts and Entertainment » Music » Instruments » Guitar
Computers and Internet » Database » Design
Computers and Internet » Database » SQL
Computers and Internet » Software Engineering » Software Management
Religion » Comparative Religion » General

Microsoft(r) Sams Teach Yourself SQL Server(tm) 2005 Express in 24 Hours (Sams Teach Yourself...in 24 Hours)
0 stars - 0 reviews
$ In Stock
Product details 456 pages Sams - English 9780672327414 Reviews:
spacer
spacer
  • back to top
Follow us on...




Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.