Microsoft SQL server 2005 : a beginner'sguide
by
Petković, Dušan.
Title
:
Microsoft SQL server 2005 : a beginner'sguide
Author
:
Petković, Dušan.
ISBN
:
9780072260939
9781283172257
Personal Author
:
Petković, Dušan.
Publication Information
:
Emeryville, Calif. : McGraw-Hill/Osborne, ©2006.
Physical Description
:
1 online resource (xxix, 704 pages) : illustrations.
Series
:
Essential skills for database professionals
Essential skills for database professionals.
General Note
:
Title from title screen.
Includes index.
Contents
:
pt. 1. SQL Server: basic concepts. Database systems and SQL Server -- SQL Server management studio -- pt. 2. 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 -- System catalog -- SQL Server security -- Triggers -- Transactions -- SQL Server system environment -- pt. 3. SQL Server: system administration. Overview of system administration -- Planning the installation and installing SQL Server -- Managing databases and database files -- Managing security -- Backup and recovery -- Automating system administration tasks -- Performance and tuning -- Data partitioning -- Data replication -- pt. 4. Microsoft analysis services. Data warehousing: an introduction -- Microsoft analysis services -- Business intelligence and SQL -- Microsoft reporting services -- pt. 5. XML support. Overview of XML -- SQL Server 2005 and XML.
Abstract
:
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.
Title Subject
:
SQL server.
Subject Term
:
Client/server computing.
Database management.
Electronic Access
: