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 kategorii: |
Databáze → Microsoft SQL → MS SQL 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:
Tento kurz již není v naší nabídce. Pro více informací nebo máte-li zájem o realizaci nás kontaktujte na skoleni@pcdir.cz nebo telefonu +420 543 533 610.