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.
| The course is included in the following category: |
Databáze → Microsoft SQL → MS SQL Microsoft |
Difficulty of the course: Advanced
Course duration: 5 days
Contents of the course:
- 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
Expected knowledge: 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)
.Course dates:
This course is no longer in our offer. For more information or if you are interested in contact us at skoleni@pcdir.cz or phone +420 543 533 610.