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.