MENU
Vorwort
Kurse
Querying Microsoft® SQL Server® 2012
Interesse für den Kurs

Querying Microsoft® SQL Server® 2012 (MOC10774)

This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2012. This course maps to the skills and knowledge measured by Microsoft Exam 70-461, and in conjunction with on-the-job experience, can help prepare you for the exam.

Der Kurs ist den Kategorien zugeordnet: Microsoft Official Course
DatabázeMicrosoft SQLMS SQL 2012/2014
Microsoft

Kursstufe: Fortgeschritten

Course duration: 5 days

Kursinhalt:

  • Introduction to Microsoft SQL Server 2012
  • Getting Started with SQL Azure
  • Introduction to T-SQL Quer
  • Writing SELECT Queries
  • Querying Multiple Tables
  • Sorting and Filtering Data
  • Working with SQL Server 2012 Data Types
  • Using Built-In Functions
  • Grouping and Aggregating Data
  • Using Subqueries
  • Using Table Expressions
  • Using Set Operators
  • Using Window Ranking, Offset, and Aggregate Functions
  • Pivoting and Grouping Sets
  • Querying SQL Server Metadata
  • Executing Stored Procedures
  • Programming with T-SQL
  • Implementing Error Handling
  • Implementing Transactions
  • Improving Query Performance

Erforderliche Kenntnisse: Working knowledge of relational databases. Basic knowledge of the Microsoft Windows operating system and its core functionality. Basic understanding of virtualization technology (Classroom labs utilize virtual machines)

.

Kurstermine:

22.10. 26.10.2018 Brno
25 450 CZK (Ohne MwSt.)
05.11. 09.11.2018 Bratislava
990 EUR (Ohne MwSt.)
19.11. 23.11.2018 Brno 25 450 CZK (Ohne MwSt.) Bestellen
19.11. 23.11.2018 Praha
25 450 CZK (Ohne MwSt.)
19.11. 23.11.2018 Košice 990 EUR (Ohne MwSt.) Bestellen
19.11. 23.11.2018 Ostrava 25 450 CZK (Ohne MwSt.) Bestellen
26.11. 30.11.2018 Bratislava 990 EUR (Ohne MwSt.) Bestellen
10.12. 14.12.2018 Ostrava 25 450 CZK (Ohne MwSt.) Bestellen
10.12. 14.12.2018 Brno 25 450 CZK (Ohne MwSt.) Bestellen
17.12. 21.12.2018 Košice 990 EUR (Ohne MwSt.) Bestellen
17.12. 21.12.2018 Bratislava 990 EUR (Ohne MwSt.) Bestellen
17.12. 21.12.2018 Praha 25 450 CZK (Ohne MwSt.) Bestellen
07.01. 11.01.2019 Bratislava 990 EUR (Ohne MwSt.) Bestellen
07.01. 11.01.2019 Praha 25 450 CZK (Ohne MwSt.) Bestellen
07.01. 11.01.2019 Brno 25 450 CZK (Ohne MwSt.) Bestellen