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

Implementing Data Models and Reports with SQL Server 2014

The focus of this instructor-led course is on creating managed enterprise BI solutions. It describes how to implement multidimensional and tabular data models, deliver reports with Microsoft® SQL Server® Reporting Services, create dashboards with Microsoft SharePoint Server PerformancePoint Services, and discover business insights by using data mining.

• 1 Month

  Course

• 10

  Class Size

• High

  Course Level

View Details

Designing Business Intelligence Solutions with Microsoft SQL Server 2014

This instructor-led course teaches students how to implement self-service Business Intelligence (BI) and Big Data analysis solutions using the Microsoft data platform. The course discusses the rationale for self-service BI, and describes how to use Microsoft SQL Server Reporting Services, Microsoft Excel, Microsoft SharePoint Server, and Microsoft Office 365 Power BI to create self-service data models and reports. The course then goes on to describe how to use Windows Azure HDInsight to perform Big Data analysis.

• 1 Month

  Course

• 10

  Class Size

• High

  Course Level

View Details