Microsoft SQL Server trainingen


# Querying Microsoft SQL Server 2012 – [70-461] – 5 Days

This 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.

Prerequisites (Voorkennis)

Working knowledge of relational databases.
Basic knowledge of the Microsoft Windows operating system and its core functionality.


# Administering Microsoft SQL Server 2012 Databases – [70-462] – 5 Days

This instructor-led SQL Server 2012 training course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2012 database. The course focuses on teaching individuals how to use SQL Server 2012 product features and tools related to maintaining a database.

Prerequisites (Voorkennis)

In addition to their professional experience, students who attend this training should already have the following technical knowledge:

  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Working knowledge of Transact-SQL.
  • Working knowledge of relational databases.
  • Some experience with database design.
  • Students who attend this training can meet the prerequisites by attending the following courses, or obtaining equivalent knowledge and skills over Querying Microsoft® SQL Server 2012

# Implementing a Data Warehouse with Microsoft SQL Server 2012 – [70-463] – 5 Days

This 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.

Prerequisites (Voorkennis)

In addition to their professional experience, students who attend this training should have technical knowledge equivalent to the following course:

  • Writing Queries with Microsoft SQL Server Transact-SQL

# Developing Microsoft SQL Server 2012 Databases – [70-464] – 5 Days

This instructor-led course introduces SQL Server2012 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 are also covered in this course.

Prerequisites (Voorkennis)

Students who attend this training can meet the prerequisites by attending the following course:

  • Querying Microsoft® SQL Server® 2012

# Designing Database Solutions for Microsoft SQL Server 2012 – [70-465] – 5 Days

This course describes how to design and monitor high performance, highly available data solutions with SQL Server 2012. This course focuses on creating plans and designs for database structure, storage, objects, and servers. Students will have the opportunity to practices hands-on skills and design tasks in a virtual lab environment and will learn about topics such as data compression, high availability, data migration, security, and scalability.

Prerequisites (Voorkennis)

  • Querying Microsoft SQL Server 2012
  • Administering a Microsoft SQL Server 2012 Database
  • Developing Microsoft SQL Server 2012 Databases with Microsoft SQL Server 2012

Voor meer info: k.kumi@itandct.com
Tel: 020-7792013