Cours MS 10774 - Querying Microsoft SQL Server 2012

Imprimer Retour

Objectif

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

Conditions générales de vente

Pour toute problématique d'accès ou de situation de handicap merci de contacter nos équipes.