SQL Server


  • SQL Server Database Administration

    Database Administration Fundamentals

    About this course

    This Training course helps you prepare for Microsoft Technology Associate Exam 98-364, and build an understanding of these topics: Core Database Concepts, Creating Database Objects, Manipulating Data, Data Storage, and Administering a Database. This course leverages the same content as found in the Microsoft Official Academic Course (MOAC) for this exam.
  • Querying Microsoft SQL Server

    Learn basic Transact- SQL queries for SQL Server 2012/ 2014

    Course Overview

    In this course, you will learn the technical skills required to write basic Transact-SQL (T-SQL) queries for Microsoft SQL Server. This is the foundational course for all SQL server related disciplines: database administration, database development and business intelligence. Tools and skills you will learn include: SQL Server Management Studio, T-SQL, SELECT statements in querying multiple tables, data types, data sorting and filtering, data manipulation language (DML), grouping and aggregating data, table expressions, set operators, window functions, T-SQL programming, error handlers, and transaction management in SQL Server. This course is designed for customers interested in learning SQL Server 2012 or SQL Server 2012/2014. It covers the new features of SQL Server 2012/2014 as well as the important capabilities across the SQL Server data platform. This course incorporates material from the Official Microsoft Learning Product 20461: Querying Microsoft SQL Server 2012/2014. It covers the skills and knowledge measured by Exam 70-461 and along with on-the-job experience, helps you prepare for the exam.

  • Administering Microsoft SQL Server Databases

    Learn to administer and maintain Microsoft SQL Server 2012/ 2014 databases

    Course Overview

    This course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2012/ 2014 database. The course focuses on teaching individuals how to use SQL Server 2012/ 2014 product features and tools related to maintaining a database. Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform. This course incorporates material from the Official Microsoft Learning Product 20764: Administering a SQL Database Infrastructure

  • Designing Business Intelligence Solutions with Microsoft SQL Server 2012/ 2014

    Course Overview

    This 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. Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.

  • Implementing a Data Warehouse with Microsoft SQL Server (Coming Soon)

    Discover how to implement a data warehouse platform with SQL Server 2012 or 2014

    Course Overview

    In this course, you will learn how to implement a data warehouse platform to support a business intelligence (BI) solution. You will discover how to create a data warehouse, implement extract, transform, and load (ETL) with SQL Server Integration Services (SSIS), and validate and cleanse data with SQL Server Data Quality Services (DQS) and SQL Server Master Data Services. This course is designed for customers interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features of SQL Server 2014 as well as the important capabilities across the SQL Server data platform. This course incorporates material from the Official Microsoft Learning Product 20463: Implementing a Data Warehouse with Microsoft SQL Server 2014. It covers the skills and knowledge measured by Exam 70-463 and along with on-the-job experience, helps you prepare for the exam.