MENU
Úvod
Kurzy
Querying Microsoft® SQL Server® 2012
zájem o kurz

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.

Kurz je zařazen v kategoriích: Microsoft Official Course
DatabázeMicrosoft SQLMS SQL 2012/2014
Microsoft

Náročnost kurzu: pokročilý

Délka kurzu: 5 dní

Náplň kurzu:

  • 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

Předpokládané znalosti: 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)

.

Termíny kurzu:

01.10. 05.10.2018 Praha
25 450 Kč (bez DPH)
01.10. 05.10.2018 Brno
25 450 Kč (bez DPH)
08.10. 12.10.2018 Bratislava
1 010 EUR (bez DPH)
22.10. 26.10.2018 Brno 25 450 Kč (bez DPH) objednat
05.11. 09.11.2018 Bratislava 1 010 EUR (bez DPH) objednat
19.11. 23.11.2018 Brno 25 450 Kč (bez DPH) objednat
19.11. 23.11.2018 Praha 25 450 Kč (bez DPH) objednat
19.11. 23.11.2018 Košice 1 010 EUR (bez DPH) objednat
19.11. 23.11.2018 Ostrava 25 450 Kč (bez DPH) objednat
26.11. 30.11.2018 Bratislava 1 010 EUR (bez DPH) objednat
10.12. 14.12.2018 Brno 25 450 Kč (bez DPH) objednat
10.12. 14.12.2018 Ostrava 25 450 Kč (bez DPH) objednat
17.12. 21.12.2018 Bratislava 1 010 EUR (bez DPH) objednat
17.12. 21.12.2018 Praha 25 450 Kč (bez DPH) objednat
17.12. 21.12.2018 Košice 1 010 EUR (bez DPH) objednat
07.01. 11.01.2019 Praha 25 450 Kč (bez DPH) objednat
07.01. 11.01.2019 Bratislava 1 010 EUR (bez DPH) objednat
07.01. 11.01.2019 Brno 25 450 Kč (bez DPH) objednat