MMSTECH110: Microsoft Windows SQL Server 2012 -70-461

Overview:

This 5-day instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2012. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. This course helps people prepare for exam 70-461.

Outline:

Module 1: Introduction to Microsoft SQL Server 2012

This module introduces the SQL Server platform and major tools. It discusses editions, versions, tools used to query, documentation sources, and the logical structure of databases.

Lessons

  • Introducing Microsoft SQL Server 2012
  • Getting Started with SQL Server Management Studio

Lab : Working with SQL Server 2012 Tools

  • Working with SQL Server Management Studio
  • Creating and Organizing T-SQL scripts
  • Using Books Online