SQL Server 2008 Core Engine
Duration
20
hours
Location
Online
Language
English
Code
DB-009
Training for 7-8 or more people?
Customize trainings
for your specific needs
Description
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.
After completing the course, a certificate
is issued on the Luxoft Training form
is issued on the Luxoft Training form
Objectives
- Provide an overview of software development for DBMS SQL Server
- Offer practical experience in working with the new features of the SQL Server 2008.
Target Audience
Software developers.
Prerequisites
Knowledge of SQL basics.
Roadmap
- 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.