SQL Server 2008 Core Engine
Czas trwania
20
hours
Lokalizacja
Online
Język
English
Kod
DB-009
Szkolenie dla #uczestników# lub większej liczby osób?
Dostosuj treningi
dla Twoich konkretnych potrzeb
Opis
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.
Po ukończeniu kursu na formularzu Luxoft Training
wydawany jest certyfikat
wydawany jest certyfikat
Cele
- Provide an overview of software development for DBMS SQL Server
- Offer practical experience in working with the new features of the SQL Server 2008.
Grupa docelowa
Software developers.
Warunki wstępne
Knowledge of SQL basics.
Plan działania
- 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.