Microsoft SQL Server Courses

• M10774 - Querying Microsoft SQL Server 2012
  
  This 4-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.
  Detailed course description and dates »

• M10775 - Administering Microsoft SQL Server 2012 Databases
  
  This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2012. The course focuses on teaching individuals how to use SQL Server 2012 product features and tools related to maintaining databases.
  Detailed course description and dates »

• M10776 - Developing Microsoft SQL Server 2012 Databases
  
  This 5-day instructor-led course introduces SQL Server 2012 and describes logical table design, indexing and query plans. It also focusses on the creation of database objects including views, stored procedures, along with parameters, and functions. Other common aspects of procedure coding, such as transactions, concurrency, error handling, triggers, and SQL CLR.
  Detailed course description and dates »

• M10777 - Implementing a Data Warehouse with Microsoft SQL Server 2012
  
  This 5-day instructor-led course describes how to implement a BI platform to support information worker analytics. Students will learn how to create a data warehouse with SQL Server 2012, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services. Some of the exercises in this course are SQL Azure enabled.
  Detailed course description and dates »

• M10778 - Implementing BI, Data Models and Reports with Microsoft SQL Server 2012
  
  This 5-day instructor-led course describes how to empower information workers through self-service analytics and reporting. Students will learn how to implement PowerPivot and tabular data models, create and deliver rich data visualizations with Power View and SQL Server Reporting Services, and discover business insights by using data mining.
  Detailed course description and dates »

• M20465 - Designing Database Solution for Microsoft SQL Server 2012
  
  This 4-day instructor-led course describes the process of designing a SQL Server 2012 database. Students will learn how to plan a server infrastructure, plan a database schema, plan storage, and database and server configurations to help them to create high performance, secure, scalable, and highly available databases by using SQL Server 2012.
  Detailed course description and dates »

• M20467 - Designing Business Intelligence Solutions with Microsoft SQL Server 2012
  
  This 4-day instructor-led course describes the process of designing a BI solution that is based on Microsoft SQL Server 2012 and other Microsoft BI technologies.
  Detailed course description and dates »

• M2778 - Writing Queries Using Microsoft SQL Server 2008 Transact-SQL
  
  This three-day instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008.
  Detailed course description and dates »

• M6231 - Maintaining a Microsoft SQL Server 2008 R2 database
  
  This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 R2. The course focuses on teaching individuals how to use SQL Server 2008 R2 product features and tools related to maintaining a databases.
  Detailed course description and dates »

• M6232 - Implementing a Microsoft SQL Server 2008 R2 Database
  
  This five-day instructor-led course provides students with the knowledge and skills to implement a Microsoft SQL Server 2008 R2 database. The course focuses on teaching individuals how to use SQL Server 2008 R2 product features and tools related to implementing a database.
  Detailed course description and dates »

• M6234 - Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services
  
  This three-day instructor-led course provides students with the knowledge and skills to implement a Microsoft SQL Server 2008 database. The course focuses on teaching individuals how to use SQL Server 2008 product features and tools related to implementing a database.
  Detailed course description and dates »

• M6235 - Implementing and Maintaining Microsoft SQL Server 2008 Integration Services
  
  This three-day instructor-led course teaches students how to implement an Integration Services solution in an organization. The course discusses how to develop, deploy, and manage Integration Services packages.
  Detailed course description and dates »

• M6236 - Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services
  
  This three-day instructor-led course teaches students how to implement a Reporting Services solution in an organization. The course discusses how to use the Reporting Services development tools to create reports, and how to use the Reporting Services management and administrative tools to manage a Reporting Services solution.
  Detailed course description and dates »

• DB-DESIGN - Design and Database Modelling
  
  This two-day instructor-led course provides the knowledge needed for the design and modelling of databases, independent on database platform. Graduates will get acquainted with the procedure of relational database design and analysis, normalization, by designing ER database diagrams, an implementation of databases and SQL basics.
  Detailed course description and dates »

Recommended sequence of trainings