Sams Teach Yourself SQL Server 2005 Express in 24 Hours

Alison Balter - Collection Sams Teach Yourself in 24 Hours

450 pages, parution le 11/07/2006

Ajouter à une liste

Indisponible

Résumé

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.

Sommaire

Introduction to SQL Server
- Hour 1 Basic relational database design
- Hour 2 SQL Server basics
- Hour 3 Getting to know the SQL Server management studio
Working with Tables, Views, and Stored Procedures
- Hour 4 SQL Server tables
- Hour 5 Working with table relationships
- Hour 6 Getting to know the SELECT statement
- Hour 7 Building SQL statements based on multiple tables
- Hour 8 Modifying data with action queries
- Hour 9 Getting to know the T-SQL functions
- Hour 10 Working with SQL Server views
- Hour 11 Creating complex views
- Hour 12 Using T-SQL to design SQL Server stored procedures
- Hour 13 Important stored procedure techniques
- Hour 14 Stored procedure special topics
- Hour 15 ADO.NET and SQL Server
- Hour 16 Using VB to design SQL Server stored procedures
- Hour 17 Visual Basic .NET special topics
- Hour 18 Using C# to design SQL Server stored procedures
- Hour 19 C# special topics
- Hour 20 Debugging the stored procedures that you write
Security and Administration
- Hour 21 SQL Server authentication
- Hour 22 SQL Server permissions validation
- Hour 23 Configuring, maintaining, and tuning SQL Server
- Hour 24 Performance monitoring
A. Using the NorthWind sample database

Voir tout

Replier

Caractéristiques techniques

	PAPIER
Éditeur(s)	Sams
Auteur(s)	Alison Balter
Collection	Sams Teach Yourself in 24 Hours
Parution	11/07/2006
Nb. de pages	450
Format	17,5 x 23
Couverture	Broché
Poids	750g
Intérieur	Noir et Blanc
EAN13	9780672327414
ISBN13	978-0-672-32741-4