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.

Covers database concepts, and discusses key topics including the SQL Server Workbench, T-SQL, automated administration tasks, security, and analysis.

306