SQL Server 2008 Core Engine

The SQL Server 2008 Core Engine course is aimed at a broad IT audience that wants to learn how to develop and administer DBMS. Our course covers basic and advanced topics related to Transact-SQL programming, including DML/DDL features, stored procedures, triggers, indexes, functions, usage of xml, transactions, concurrency as well as monitoring and administration features.

• Provide an overview of software development for DBMS SQL Server
• Offer practical experience in working with the new features of the SQL Server 2008.

• DML features of Transact-SQL;
• SQL Server Architecture;
• Development of database objects: tables, views, stored procedures, functions etc.;
• Indexes and optimization;
• CLR (.NET) Integration;
• XML;
• Service Broker;
• Security in an SQL Server;
• Administratino (backup, restore);
• Audit;
• Monitoring.