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.

20 hours
English
Online

duration: 20 hours
location: Online
Language: English
Code: DB-009
price: € 240 *

Available sessions

To be determined

Training for 7-8 or more people?
Customize trainings for your specific needs

Description

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.