Beginning SQL Server 2005 Express for Developers

From Novice to professional

Robin Dewson - Collection The Expert's Voice in .NET

450 pages, parution le 07/03/2007

Ajouter à une liste

Indisponible

Résumé

Beginning SQL Server 2005 Express for Developers: From Novice to Professional

Assuming neither database nor programming background, Beginning SQL Server 2005 Express for Developers introduces all the fundamental database administration and SQL programming features of SQL Server 2005 Express Edition, the free relational database management system from Microsoft that provides a major subset of full SQL Server 2005 functionality.

This book is a comprehensive guide that covers installing and configuring SQL Server 2005 Express; creating, backing up, and restoring databases; creating tables, then querying and manipulating them with T-SQL; coding stored procedures and triggers, and using Reporting Services to deliver information to end users. Detailed, clear, and highly readable, this book will make you a competent and confident database administrator and programmer.

This is the clearest and most comprehensive introduction to SQL Server 2005 Express.
The book assumes no prior experience with databases, SQL, or programming.
You'll learn about both database administration and T-SQL programming.
The book covers SQL Server Management Studio and Reporting Services.

L'auteur - Robin Dewson

Robin Dewson - Robin Dewson: Robin has been hooked on programming ever since he bought his first computer in 1980, a Sinclair ZX80. His first main application of his own was a Visual FoxPro application that could be used to run a Fantasy League system. It was at this point he met up with a great help in his PC development life, Jon Silver at Step One Technologies, where in return for training, he helped Jon with some other Visual FoxPro applications. From there, realizing that the market place for Visual FoxPro was limited, he decided to learn Visual Basic and SQL Server. Starting out with SQL Server 6.5, he soon moved to SQL Server 7 and Visual Basic 5 and became involved in developing several applications for clients both in the UK and the US. From there he moved to SQL Server 2000 and Visual Basic 6. Robin currently is consulting at Lehman Brothers in London, where he has been for nearly 5 years, using Visual Basic 6 and Sybase on a trading system called Kojak. Robin is also the author of Beginning SQL Server 2000 Programming.

Sommaire

SQL Server 2005 Express Overview and Installation
SQL Server Management Studio Express
Database Design and Creation
Security
Defining Tables
Creating Indexes and Database Diagramming
Database Backup, Recovery, and Maintenance
Working with the Data
Building a View
Stored Procedures
T-SQL Essentials
Advanced T-SQL
Triggers
SQL Server 2005 Reporting Services

Voir tout

Replier

Caractéristiques techniques

	PAPIER
Éditeur(s)	Apress
Auteur(s)	Robin Dewson
Collection	The Expert's Voice in .NET
Parution	07/03/2007
Nb. de pages	450
Format	18 x 23
Couverture	Broché
Poids	740g
Intérieur	Noir et Blanc
EAN13	9781590597200
ISBN13	978-1-59059-720-0