Résumé
It's been five years since Microsoft released a new version of SQL Server-which holds 39% of the Windows database market-and the latest edition of this bestselling beginner's guide gets users up and running on SQL Server 2005. The book covers database concepts, and discusses key topics for new users including the SQL Server Workbench,T-SQL, automated administration tasks, security, and analysis.
L'auteur - Dusan Petkovic
Dusan Petkovic Is a professor in the Department of Computer Science at the Polytechnic in Rosenheim, Germany. He is the author of SQL Server 7: A Beginner's Guide and a frequent contributor to SQL Server magazine.
Sommaire
- I: SQL Server: Basic Concepts
- Database Systems and SQL Server
- SQL Server Management Studio
- II: Transact-SQL Language
- SQL Components
- Data Definition Language
- Simple Queries
- Complex Queries
- Modification of a Table's Contents
- Stored Procedures and User-Defined Functions
- Indices and Query Optimization
- Views
- Systems Catalog
- SQL Server Security
- Triggers
- Transactions
- SQL Server System Environment
- III: SQL Server: System Administration
- Overview of System Administration
- Planning the Installation and Installing SQL Server
- Managing Database and Database Files
- Managing Security
- Backup and Recovery
- Automating Systems Administration Tasks
- Performance and Tuning
- Data Partitioning
- Data Replication
- IV: Microsoft Analysis Services
- Data Warehousing: An Introduction
- Microsoft Analysis Services
- Business Intelligence and SQL
- Microsoft Reporting Services
- V: XML Support
- Overview of XML
- SQL Server 2005 and XML
Caractéristiques techniques
PAPIER | |
Éditeur(s) | Mc Graw Hill |
Auteur(s) | Dusan Petkovic |
Parution | 30/01/2006 |
Nb. de pages | 730 |
Format | 19 x 23 |
Couverture | Broché |
Poids | 1175g |
Intérieur | Noir et Blanc |
EAN13 | 9780072260939 |
ISBN13 | 978-0-07-226093-9 |
Avantages Eyrolles.com
Consultez aussi
- Les meilleures ventes en Graphisme & Photo
- Les meilleures ventes en Informatique
- Les meilleures ventes en Construction
- Les meilleures ventes en Entreprise & Droit
- Les meilleures ventes en Sciences
- Les meilleures ventes en Littérature
- Les meilleures ventes en Arts & Loisirs
- Les meilleures ventes en Vie pratique
- Les meilleures ventes en Voyage et Tourisme
- Les meilleures ventes en BD et Jeunesse