Cours MS 10774 - Querying Microsoft SQL Server 2012
Imprimer RetourObjectif
MS 10774 - Querying Microsoft SQL Server 2012 course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2012. This MS 10774 - Querying Microsoft SQL Server 2012 course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. This MS 10774 - Querying Microsoft SQL Server 2012 course helps people prepare for exam 70-461.
Pré-requis
Before attending this course, students must have:
- Working knowledge of relational databases.
- Basic knowledge of the Microsoft Windows operating system and its core functionality.
Before attending this course, students should have:
- Basic understanding of virtualization technology (Classroom labs utilize virtual machines)
To help you prepare for this class, review the following resources:
- Book: T-SQL Fundamentals for Microsoft SQL Server 2012 and SQL Azure
- MCTS Self Paced Training Kit 70-461
Contenu
- Module 1: Introduction to Microsoft SQL Server 2012
- Module 2: Getting Started with SQL Azure
- Module 3: Introduction to T-SQL Querying
- Module 4: Writing SELECT Queries
- Module 5: Querying Multiple Tables
- Module 6: Sorting and Filtering Data
- Module 7: Working with SQL Server 2012 Data Types
- Module 8: Using Built-In Functions
- Module 9: Grouping and Aggregating Data
- Module 10: Using Subqueries
- Module 11: Using Table Expressions
- Module 12: Using Set Operators
- Module 13: Using Window Ranking, Offset and Aggregate Functions
- Module 14: Pivoting and Grouping Sets
- Module 15: Querying SQL Server Metadata
- Module 16: Executing Stored Procedures
- Module 17: Programming with T-SQL
- Module 18: Implementing Error Handling
- Module 19: Implementing Transactions
- Module 20: Improving Query Performance
Langue du cours
FR
Support de cours
- Supports en sus
Durée
5 jour(s)
Nos cours collectifs
Disponibilité sur demande
Pour toute problématique d'accès ou de situation de handicap merci de contacter nos équipes.