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 der Kategorie zugeordnet: |
Databáze → Microsoft SQL → MS SQL 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:
Das ist natürlich nicht mehr in unserem Angebot. Für weitere Informationen oder wenn Sie Interesse an der Durchführung kontaktieren Sie uns unter skoleni@pcdir.cz oder Telefon +420 543 533 610.