Querying Microsoft SQL Server 2014

This instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2014. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence.

• 1 Month

  Course

• 10

  Class Size

• Beginner

  Course Level

View Details

Administering Microsoft SQL Server

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

• 1 Month

  Course

• 10

  Class Size

• Intermediate

  Course Level

View Details

Implementing a Data Warehouse with Microsoft SQL Server 2014

This course describes how to implement a data warehouse platform to support a BI solution. Students will learn how to create a data warehouse with Microsoft® SQL Server® 2014, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.

• 1 Month

  Course

• 10

  Class Size

• Intermediate

  Course Level

View Details

Developing Microsoft SQL Server 2014 Databases

This instructor-led course introduces SQL Server 2014 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 indexes, concurrency, error handling, and triggers are also covered in this course. Also, this course helps you prepare for the Exam 70-464.

• 1 Month

  Course

• 10

  Class Size

• High

  Course Level

View Details

Designing Solutions for Microsoft SQL Server 2014

The focus of this instructor-led course is on planning and implementing enterprise database infrastructure solutions by using SQL Server 2014 and other Microsoft technologies. It describes how to consolidate SQL Server workloads and how to plan and implement high availability and disaster recovery solutions.

• 1 Month

  Course

• 10

  Class Size

• High

  Course Level

View Details