SQL Server 2008 Core Engine

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.
Durată
20 ore
Tipul de curs
Pe net
Limba
Engleză
Articol
DB-009
Durată
20 ore
Locație
Pe net
Limba
Engleză
Cod
DB-009
Training pentru 7-8 sau mai multe persoane? Personalizați antrenamentele pentru nevoile dumneavoastră specifice
SQL Server 2008 Core Engine
Durată
20 ore
Locație
Online
Limba
English
Cod
DB-009
€ 240 *
Training pentru 7-8 sau mai multe persoane? Personalizați antrenamentele pentru nevoile dumneavoastră specifice

Descriere

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.
certificat
După finalizarea cursului, se eliberează un certificat
în formularul Luxoft Training

Obiective

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

Public țintă

Software developers.

Cerințe preliminare

Knowledge of SQL basics.

Foaia de parcurs

  • 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.
Mai ai întrebări?
Conectați-văcu noi