Querying Microsoft SQL Server 2012

Referenz	MS10774
Kategorie	Systems
Datum	Von  Montag, 17. Dezember 2012 bis Freitag, 21. Dezember 2012
Kurszeiten	9h00-12h00 et 14h00-17h30
Sprecher
Sprache	Unterricht : Französisch   Literatur : Französisch
Ort	LANexpert Lausanne Av. de Provence 4 - 1007 Lausanne Tel: +41 21 623 92 40 Fax: +41 21 623 92 45
Preis (CHF)	3'950.00
Bereit ?

Beschreibung

This 5-day instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2012. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. This course helps people prepare for exam 70-461.

Publikum

This course is intended for Database Administrators, Database Developers, and Business Intelligence professionals. The course will very likely be well attended by SQL power users who aren’t necessarily database-focused or plan on taking the exam; namely, report writers, business analysts and client application developers.

Voraussetzungen

Before attending this course, students must have: Working knowledge of relational databases. Basic knowledge of the Microsoft Windows operating system and its core functionality. Before attending this course, students should have: Basic understanding of virtualization technology (Classroom labs utilize virtual machines) To help you prepare for this class, review the following resources: Book: T-SQL Fundamentals for Microsoft SQL Server 2012 and SQL Azure MCTS Self Paced Training Kit 70-461

Ziele

1. Write SELECT queries
2. Query multiple tables
3. Use built-in functions
4. Use subqueries
5. Execute stored procedures
6. Use set operators
7. Implement error handling
8. Implement transactions
9. Use table expressions
10. Sort and filter data
11. Use window ranking, offset and aggregate functions
12. Query SQL Server metadata
13. Program with T-SQL
14. Improve query performance

Programm

The complete program is available here