Install SQL Server 2008, construct high-performance databases, use powerful Transact-SQL statements, create stored procedures and triggers, and execute simple and complex database queries. Set up, configure and maintain SQL Server 2008Build and manage database objects using Transact-SQL statements Create stored procedures and database functionsOptimize user-defined performance, availability, and solid reliabilityImplement security using authentication, encryption, and authorization automated tasks using SQL Server AgentCreate reliable data backups and perform flawless restoresUse new system all the SQL Server 2008 Business Intelligence, development, and administration in detail toolsLearn SQL Server XML technology (SQLXML)