Microsoft Sql Server Training Series - 16 Courses - ITU Online
ON SALE 40% OFF

Microsoft Sql Server Training Series – 16 Courses

This SQL Server training series has it all. For years, Microsoft has been the go-to brand for database technology and it remains a top preference among many corporations and individual users alike. This comprehensive training series covers versions 2012 through 2019 of Microsoft SQL Server that are still extensively utilized at present. You will be given an in-depth look into SQL Server administration, database design, analysis services, reporting services, PowerBI and more during this learning program.

Included In This Course

Included In This Course

Total Hours
188 Training Hours
Microsoft Sql Server Training Series – 16 Courses
1,010 On-demand Videos
Closed Caption

Closed Captions

Course Topics
194  Topics
Prep Questions
1,405 Prep Questions
Microsoft Sql Server Training Series – 16 Courses

Certificate of Completion

Course Description

Our Microsoft SQL Server training course takes the hassle and financial burden out of heading back to the classroom. With our comprehensive approach, video instructor led training you’ll learn core concepts and gain essential hands-on experience in a fraction of the time.

Skills Covered in this online course

Microsoft has long been a leader in database technology and continues to be a dominant choice among many companies and users. This extensive online training series covers Microsoft SQL Server versions 2012 through 2019, which are still widely in use today and will give you the essential skills needed. In this training series, you will explore SQL Server administration, database design, analysis services, reporting services, PowerBI, and more. ITU’s SQL Server training is self-paced and covers all essential topics related to technology. You will learn about database security, indexing, query design optimization, data warehousing concepts, reporting services, business intelligence operations, and more. Upon successfully completing our SQL Server training series, you will have a strong understanding of Microsoft SQL Server database types and be able to use it in various professional settings.

This Online Course Training from ITU includes video lectures from industry experts that provide an in-depth look into the world of Microsoft SQL Server. There are also quizzes to help reinforce key concepts; quizzes can be taken multiple times and are all self-paced. The course is constantly updated to ensure the material is relevant and up-to-date with the newest version of Microsoft SQL Server.

What you will learn in the Online Microsoft SQL Server Training Course

Whether you are a beginner or an experienced user, this SQL Server training online course from ITU will give you the knowledge and skills necessary to use Microsoft SQL Server confidently and effectively. You will gain a comprehensive understanding of key topics related to the technology and have an opportunity to apply your newfound knowledge through hands-on labs and quizzes. After completing the course, you can demonstrate your expertise by earning certifications in various areas, such as database security and business intelligence operations. With ITU’s self-paced learning approach, you can progress at your own pace while gaining the confidence and SQL skills necessary to succeed in the Microsoft SQL Server environment. Sign up today and get started!

This bundle includes the following courses:

With over 180 hours of online training, the SQL Server training series is comprehensive and allows you to advance your skills in using the most popular and widely used database system. Join us today for this excellent series.

Frequently Asked Questions About our Microsoft SQL Training Series

What is the comprehensive Microsoft SQL training program?

The comprehensive Microsoft SQL training program is a series of courses designed to provide in-depth knowledge and skills in various aspects of SQL, including Microsoft Business Intelligence (BI), SQL Server administration, and related certifications such as Microsoft 70-461, 70-462, 70-463, 70-464, 70-465, 70-466, 70-467, 70-764, and 70-765. It also covers topics like SQL Big Data and SQL Server Analysis Services (SSAS).

What is Microsoft Business Intelligence (BI)?

Microsoft Business Intelligence (BI) refers to a suite of tools and technologies that enable organizations to gather, store, analyze, and visualize data for making informed business decisions. The comprehensive SQL training program covers various BI components such as SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), and SQL Server Reporting Services (SSRS).

What is SQL Big Data?

SQL Big Data is a term used to describe the integration of SQL technologies with big data platforms and technologies. It allows users to process and analyze large volumes of structured and unstructured data using SQL queries and familiar SQL tools. The comprehensive SQL training program covers the concepts, tools, and techniques related to SQL Big Data processing.

What is SQL Server Analysis Services (SSAS)?

SQL Server Analysis Services (SSAS) is a component of Microsoft SQL Server that enables the creation, deployment, and management of online analytical processing (OLAP) cubes and data mining models. It provides powerful multidimensional data analysis capabilities for business intelligence applications. The training program covers the fundamentals of SSAS and its integration with SQL Server.

What is SQL Server data administration?

SQL Server data administration refers to the management and maintenance of SQL Server databases, including tasks such as database installation, configuration, backup and recovery, performance optimization, and security management. The comprehensive training program covers essential skills and best practices for SQL Server data administration.

How long does the comprehensive Microsoft SQL training program typically take?

The duration of the comprehensive Microsoft SQL training program can vary depending on the specific course or certification track chosen, as well as the individual’s prior knowledge and learning pace. However, on average, completing the entire program may take several months of dedicated study and practice.

What are the prerequisites for the training program?

The prerequisites for the comprehensive Microsoft SQL training program may vary depending on the specific course or certification being pursued. However, a basic understanding of SQL fundamentals and database concepts is recommended. Familiarity with Microsoft Windows operating system and general computer literacy is also beneficial.

Are there any hands-on exercises or projects included in the training program?

Yes, the comprehensive Microsoft SQL training program typically includes hands-on exercises, practical labs, and projects to reinforce the theoretical concepts and provide real-world experience. These exercises and projects may involve working with SQL Server databases, designing and implementing BI solutions, and performing data analysis tasks using SQL tools.

Is it useful to learn about SQL 2012 or SQL 2016?

An absolute yes. Microsoft SQL server is a high end enterprise level database. There are substantial costs associated with large organizations upgrading to newer versions of Microsoft SQL. As such, many corporate environments rely heavily on prior versions of SQL.

Additionally, many of the principles you will learn in this training series are foundations needed to work with any version of Microsoft SQL Server.

Proudly Display
Your Achievement

Upon completion of your training, you’ll receive a personalized certificate of completion to help validate to others your new skills.
Example Certificate

Course Outline

Microsoft SQL Server 2019 - Introduction to Data Analysis Course Content

Module 1 - Query Tools

  •    1.1 Course Introduction

  •    1.2 Intro to Management Studio

  •    1.3 Intro to command-line query tools

Module 2 - Introduction to T-SQL Querying

  •    2.1 Introducing T-SQL

  •    2.2 Understanding Sets

  •    2.3 Understanding the Logical Order of Operations in SELECT statements

Module 3 - Basic SELECT Queries

  •    3.1 Writing Simple SELECT Statements

  •    3.2 Eliminate Duplicates with DISTINCT

  •    3.3 Using Column and Table Aliases

  •    3.4 Write Simple CASE Expressions

Module 4 - Querying Multiple Tables

  •    4.1 Understanding Joins

  •    4.2 Querying with Inner Joins

  •    4.3 Querying with Outer Joins

  •    4.4 Querying with Cross Joins and Self Joins

Module 5 - Sorting and Filtering Data

  •    5.1 Sorting Data

  •    5.2 Filtering Data with Predicates

  •    5.3 Filtering with the TOP and OFFSET-FETCH

  •    5.4 Working with Unknown Values

Module 6 - Introduction to Business Intelligence and Data Modeling

  •    6.1 Introduction to Business Intelligence

  •    6.2 The Microsoft Business Intelligence Platform

  •    6.3 Exploring a Data Warehouse

  •    6.4 Exploring a Data Model

Module 7 - Prepare Data

  •    7.1 Introduction to Power BI

  •    7.2 Get data from various data sources

  •    7.3 Preview source data

Module 8 - Clean, Transform, and Load Data

  •    8.1 Data Transformation Intro

  •    8.2 Transformation Example 1

  •    8.3 Transformation Example 2

  •    8.4 Transformation Example 3

  •    8.5 Transformation Example 4

  •    8.6 Transformation Example 5

  •    8.7 Transformation Example 6

Module 9 - Design a Data Model

  •    9.1 Introduction to Data Modeling

  •    9.2 Model Relationships

  •    9.3 Table Configuration

  •    9.4 Model interface

  •    9.5 Quick Measures

  •    9.6 Many-to-many relationships

  •    9.7 Row-level security

Module 10 - Create Model Calculations using DAX

  •    10.1 DAX context

  •    10.2 Calculated Tables

  •    10.3 Calculated Columns

  •    10.4 Managing Date Tables

  •    10.5 Measures

  •    10.6 Filter Manipulation

  •    10.7 Time Intelligence

Module 11 - Create Reports

  •    11.1 Basic Report Creation

  •    11.2 Example Page 1

  •    11.3 Example Page 2

  •    11.4 Example Page 3

  •    11.5 Report Publishing

  •    11.6 Enhancing Reports

  •    11.7 Drill-Through Pages

  •    11.8 Conditional Formatting

  •    11.9 Buttons and Bookmarks

Module 12 - Create Dashboards

  •    12.1 Dashboard Basics

  •    12.2 Real Time Dashboards

  •    12.3 Enhanced Dashboards

Module 13 - Create Paginated Reports

  •    13.1 Introduction to Power BI Report Builder

  •    13.2 Report Layouts

  •    13.3 Report Data

  •    13.4 Report Tables

Module 14 - Perform Advanced Analytics

  •    14.1 Introduction to Advanced Analytics

  •    14.2 Scatter Chart

  •    14.3 Forecast

  •    14.4 Decomposition Tree

  •    14.5 Key Influencers

Module 15 - Create and Manage Workspaces

  •    15.1 Introduction to Workspaces

  •    15.2 Working with Workspaces and the Portal

Module 16 - Create Power App Visuals

  •    16.1 Introduction to Power Apps Visual

  •    16.2 Creating the App

  •    16.3 Basic Power Apps Concepts

  •    16.4 Refreshing the Report

Module 17 - Analysis Services and Power BI

  •    17.1 Introduction to Analysis Services

  •    17.2 Connecting with Multidimensional Models

  •    17.3 Premium Workspaces and Analysis Services

  •    17.4 Course Wrap Up

Microsoft SQL Server 2019 - Querying SQL Server Course Content

Module 1 - Query Tools

  •    1.1 Course Introduction

  •    1.2 Module 1 Introduction

  •    1.3 Intro to Management Studio

  •    1.4 Intro to command-line query tools

Module 2 - Introduction to T-SQL Querying

  •    2.1 Module 2 Introduction

  •    2.2 Introducing T-SQL

  •    2.3 Understanding Sets

  •    2.4 Understanding the Logical Order of Operations in SELECT statements

Module 3 - Basic SELECT Queries

  •    3.1 Module 3 Introduction

  •    3.2 Writing Simple SELECT Statements

  •    3.3 Eliminate Duplicates with DISTINCT

  •    3.4 Using Column and Table Aliases

  •    3.5 Write Simple CASE Expressions

Module 4 - Querying Multiple Tables

  •    4.1 Module 4 Introduction

  •    4.2 Understanding Joins

  •    4.3 Querying with Inner Joins

  •    4.4 Querying with Outer Joins

  •    4.5 Querying with Cross Joins and Self Joins

Module 5 - Sorting and Filtering Data

  •    5.1 Module 5 Introduction

  •    5.2 Sorting Data

  •    5.3 Filtering Data with Predicates

  •    5.4 Filtering with the TOP and OFFSET-FETCH

  •    5.5 Working with Unknown Values

Module 6 - Working with SQL Server Data Types

  •    6.1 Module 6 Introduction

  •    6.2 Writing Queries that return Date and Time Data

  •    6.3 Writing Queries that use Date and Time Functions

  •    6.4 Writing Queries that return Character Data

  •    6.5 Writing Queries that use Character Functions

Module 7 - Using DML to Modify Data

  •    7.1 Module 7 Introduction

  •    7.2 Inserting Records with DML

  •    7.3 Updating Records Using DML

  •    7.4 Deleting Records Using DML

Module 8 - Using Built-In Functions

  •    8.1 Module 8 Introduction

  •    8.2 Writing Queries with Built-In Functions

  •    8.3 Using Conversion Functions

  •    8.4 Using Logical Functions

  •    8.5 Using Functions to Work with NULL

Module 9 - Grouping and Aggregating Data

  •    9.1 Module 9 Introduction

  •    9.2 Using Aggregate Functions

  •    9.3 Using the GROUP BY Clause

  •    9.4 Filtering Groups with HAVING

Module 10 - Using Subqueries

  •    10.1 Module 10 Introduction

  •    10.2 Writing Self-Contained Subqueries

  •    10.3 Writing Correlated Subqueries

  •    10.4 Using the EXISTS Predicate with Subqueries

Module 11 - Using Table Expressions

  •    11.1 Module 11 Introduction

  •    11.2 Using Views

  •    11.3 Using Inline Table-Valued Functions

  •    11.4 Using Derived Tables

  •    11.5 Using Common Table Expressions

Module 12 - Using Set Operators

  •    12.1 Module 12 Introduction

  •    12.2 Writing Queries with the UNION operator

  •    12.3 Using EXCEPT and INTERSECT

  •    12.4 Using APPLY

Module 13 - Using Window Ranking, Offset, and Aggregate Functions

  •    13.1 Module 13 Introduction

  •    13.2 Creating Windows with OVER

  •    13.3 Exploring Window Functions

Module 14 - Pivoting and Grouping Sets

  •    14.1 Module 14 Introduction

  •    14.2 Writing Queries with PIVOT and UNPIVOT

  •    14.3 Working with Grouping Sets

Module 15 - Implementing Error Handling

  •    15.1 Module Introduction

  •    15.2 Implementing T-SQL error handling

  •    15.3 Implementing structured exception handling

Module 16 - Managing Transactions

  •    16.1 Module 16 Introduction

  •    16.2 Transactions and the Database Engine

  •    16.3 Controlling Transactions

  •    16.4 Course Wrap Up

SQL Server 2019 Database Design Course Content

Module 1 - Designing and Building Tables

  •    1.1 Course Introduction

  •    1.2 Module 1 Introduction

  •    1.3 Introduction to Database Design

  •    1.4 Creating Tables

  •    1.5 Data Types

  •    1.6 Schemas

  •    1.7 Altering Tables

Module 2 - Enforcing Data Integrity

  •    2.1 Module 2 Introduction

  •    2.2 Introduction to Data Integrity

  •    2.3 Data Domain Integrity

  •    2.4 Implementing Data Domain Integrity

  •    2.5 Implementing Entity and Referential Integrity

Module 3 - Indexing

  •    3.1 Module 3 Introduction

  •    3.2 Core Indexing Concepts

  •    3.3 Heaps, Clustered, and Nonclustered Indexes

  •    3.4 Data Types and Indexes

  •    3.5 Single Column and Composite Indexes

Module 4 - Stored Procedures, Functions, and Triggers

  •    4.1 Module 4 Introduction

  •    4.2 Introduction to Database Programming

  •    4.3 Creating Stored Procedures

  •    4.4 Creating User-Defined Functions

  •    4.5 Creating Triggers

Module 5 - Blob and Filestream Data

  •    5.1 Module 5 Introduction

  •    5.2 Introduction to Binary Data

  •    5.3 Considerations for BLOB data

  •    5.4 FILESTREAM Example

  •    5.5 File Table Example

Module 6 - Full-Text Search

  •    6.1 Module 6 Introduction

  •    6.2 Introduction to Full-Text Search

  •    6.3 Full-Text Catalogs

  •    6.4 Full-Text Indexes

  •    6.5 Full-Text Queries

Module 7 - Azure vs On-Prem

  •    7.1 Module 7 Introduction

  •    7.2 SQL Server on Azure VM

  •    7.3 Azure Managed SQL Instance

  •    7.4 Azure SQL Database

  •    7.5 Course Wrap Up

Microsoft SQL Server 2019 Analysis Services (SSAS) Course Content

Module 1 - Introduction to Business Intelligence and Data Modeling

  •    1.1 Course Introduction

  •    1.2 Module 1 Introduction

  •    1.3 Introduction to Business Intelligence

  •    1.4 The Microsoft Business Intelligence Platform

  •    1.5 Exploring a Data Warehouse

  •    1.6 Exploring a Data Model

Module 2 - Multidimensional Databases

  •    2.1 Module 2 Introduction

  •    2.2 Introduction to Multidimensional Analysis

  •    2.3 Overview of Cube Security

  •    2.4 Creating and Configuring a Cube

  •    2.5 Data Sources

  •    2.6 Data Source Views

  •    2.7 Adding a Dimension to a Cube

Module 3 - Cubes and Dimensions

  •    3.1 Module 3 Introduction

  •    3.2 Dimensions

  •    3.3 Attribute Hierarchies and Relationships

  •    3.4 Sorting and Grouping Attributes

  •    3.5 Slowly Changing Dimensions

Module 4 - Measures and Measure Groups

  •    4.1 Module 4 Introduction

  •    4.2 Measures

  •    4.3 Measure Groups and Relationships

  •    4.4 Measure Group Storage

Module 5 - Introduction to MDX

  •    5.1 Module 5 Introduction

  •    5.2 MDX Fundamentals

  •    5.3 Adding Calculations to a Cube

  •    5.4 Querying a cube using MDX

Module 6 - Customizing Cube Functionality

  •    6.1 Module 6 Introduction

  •    6.2 Key Performance Indicators

  •    6.3 Actions

  •    6.4 Perspectives

  •    6.5 Translations

Module 7 - Tabular Data Models

  •    7.1 Module 7 Introduction

  •    7.2 Introduction to Tabular Data Models

  •    7.3 Creating a Tabular Data Model

  •    7.4 Configure Relationships and Attributes

  •    7.5 Configuring Data Model for an Enterprise BI Solution

Module 8 - Data Analysis Expressions (DAX)

  •    8.1 Module 8 Introduction

  •    8.2 DAX Fundamentals

  •    8.3 Calculated Columns

  •    8.4 Relationships

  •    8.5 Measures

  •    8.6 Time Intelligence

  •    8.7 KPI

  •    8.8 Parent - Child Hierarchies

Module 9 - Data Mining

  •    9.1 Module 9 Introduction

  •    9.2 Overview of Data Mining

  •    9.3 Custom Data Mining Solutions

  •    9.4 Validating a Data Mining Model

  •    9.5 Consuming a Data Mining Model

  •    9.6 Course Wrap Up

Introduction to Microsoft Power BI Course Content

Module 1 - Prepare Data

  •    1.1 Course Introduction

  •    1.2 Module 1 Introduction

  •    1.3 Introduction to Power BI

  •    1.4 Get data from various data sources

  •    1.5 Preview source data

Module 2 - Clean, Transform, and Load Data

  •    2.1 Module 2 Introduction

  •    2.2 DimEmployee Example

  •    2.3 DimEmployeeSalesTerritory Example

  •    2.4 DimReseller Example

  •    2.5 FactResellersSales Example

  •    2.6 ResellerSalesTargets Example

  •    2.7 Color Formats Example

Module 3 - Design a Data Model

  •    3.1 Module 3 Introduction

  •    3.2 Introduction to Data Modeling

  •    3.3 Model Relationships

  •    3.4 Table Configuration

  •    3.5 Model interface

  •    3.6 Quick Measures

  •    3.7 Many-to-many relationships

  •    3.8 Row-level security

Module 4 - Create Model Calculations using DAX

  •    4.1 Module 4 Introduction

  •    4.2 DAX context

  •    4.3 Calculated Tables

  •    4.4 Calculated Columns

  •    4.5 Managing Date Tables

  •    4.6 Measures

  •    4.7 Filter Manipulation

  •    4.8 Time Intelligence

Module 5 - Create Reports

  •    5.1 Module 5 Introduction

  •    5.2 Basic Report Creation

  •    5.3 Example Page 1

  •    5.4 Example Page 2

  •    5.5 Example Page 3

  •    5.6 Report Publishing

  •    5.7 Enhancing Reports

  •    5.8 Drill-Through Pages

  •    5.9 Conditional Formatting

  •    5.10 Buttons and Bookmarks

Module 6 - Create Dashboards

  •    6.1 Module 6 Introduction

  •    6.2 Dashboard Basics

  •    6.3 Real Time Dashboards

  •    6.4 Enhanced Dashboards

Module 7 - Create Paginated Reports

  •    7.1 Module 7 Introduction

  •    7.2 Introduction to Power BI Report Builder

  •    7.3 Report Layouts

  •    7.4 Report Data

  •    7.5 Report Tables

Module 8 - Perform Advanced Analytics

  •    8.1 Module 8 Introduction

  •    8.2 Introduction to Advanced Analytics

  •    8.3 Scatter Chart

  •    8.4 Forecast

  •    8.5 Decomposition Tree

  •    8.6 Key Influencers

Module 9 - Create and Manage Workspaces

  •    9.1 Introduction to Workspaces

  •    9.2 Working with Workspaces and the Portal

Module 10 - Create Power App Visuals

  •    10.1 Module 10 Introduction

  •    10.2 Introduction to Power Apps Visual

  •    10.3 Creating the App

  •    10.4 Basic Power Apps Concepts

  •    10.5 Refreshing the Report

Module 11 - Analysis Services and Power BI

  •    11.1 Module 11 Introduction

  •    11.2 Introduction to Analysis Services

  •    11.3 Connecting with Multidimensional Models

  •    11.4 Premium Workspaces and Analysis Services

  •    11.5 Course Wrap Up

Microsoft SQL Server - Big Data Course Content

Module 1: What are Big Data Clusters?

  •    1.1 Introduction

  •    1.2 Linux, PolyBase, and Active Directory

  •    1.3 Scenarios

Module 2: Big Data Cluster Architecture

  •    2.1 Introduction

  •    2.2 Docker

  •    2.3 Kubernetes

  •    2.4 Hadoop and Spark

  •    2.5 Components

  •    2.6 Endpoints

Module 3: Deployment of Big Data Clusters

  •    3.1 Introduction

  •    3.2 Install Prerequisites

  •    3.3 Deploy Kubernetes

  •    3.4 Deploy BDC

  •    3.5 Monitor and Verify Deployment

Module 4: Loading and Querying Data in Big Data Clusters

  •    4.1 Introduction

  •    4.2 HDFS with Curl

  •    4.3 Loading Data with T-SQL

  •    4.4 Virtualizing Data

  •    4.5 Restoring a Database

Module 5: Working with Spark in Big Data Clusters

  •    5.1 Introduction

  •    5.2 What is Spark

  •    5.3 Submitting Spark Jobs

  •    5.4 Running Spark Jobs via Notebooks

  •    5.5 Transforming CSV

  •    5.6 Spark-SQL

  •    5.7 Spark to SQL ETL

Module 6: Machine Learning on Big Data Clusters

  •    6.1 Introduction

  •    6.2 Machine Learning Services

  •    6.3 Using MLeap

  •    6.4 Using Python

  •    6.5 Using R

Module 7: Create and Consume Big Data Cluster Apps

  •    7.1 Introduction

  •    7.2 Deploying, Running, Consuming, and Monitoring an App

  •    7.3 Python Example - Deploy with azdata and Monitoring

  •    7.4 R Example - Deploy with VS Code and Consume with Postman

  •    7.5 MLeap Example - Create a yaml file

  •    7.6 SSIS Example - Implement scheduled execution of a DB backup

Module 8: Maintenance of Big Data Clusters

  •    8.1 Introduction

  •    8.2 Monitoring

  •    8.3 Managing and Automation

  •    8.4 Course Wrap Up

Microsoft SQL Server 2019 Administration Course Content

Module 1: Installation

  •    SQL Admin Intro

  •    Installation

Module 2: Data Storage

  •    Introduction to Data Storage with SQL Server

  •    Managing Storage for System Databases

  •    Managing Storage for User Databases

  •    Moving Database Files

Module 3: Data Recover

  •    Intro to Data Recovery

  •    Understanding SQL Server Recovery Models

  •    Planning a Backup Strategy

  •    Backing up Databases and Transaction Logs

  •    Using SSMS For Backup

  •    Understanding the Restore Process

  •    How to Restore a Database

  •    Using SSMS For Restore

  •    T-SQL Backup and Restore

  •    Advanced Restore Scenarios

  •    Introduction to Transferring Data

  •    Importing and Exporting Table Data

  •    Copying or Moving a Database

Module 4: Monitoring

  •    Introduction to Monitoring SQL Server

  •    Dynamic Management Views and Functions

  •    Server Reports

  •    System Performance Monitor

  •    Tracing SQL Server Workload Activity

  •    Extended Events

  •    Database Tuning Advisor

Module 5: Security

  •    Introduction to SQL Server Security

  •    Managing Server-Level Security

  •    Managing Database-Level Security

  •    Row Level Security (RLS) Using Policies

  •    Database Security Tools

  •    Contained Database

  •    Auditing Data Access in SQL Server

  •    Implementing Transparent Data Encryption

Module 6: Maintenance

  •    Introduction to Maintenance

  •    Ensuring Database Integrity

  •    Maintaining Indexes

  •    Automating Routine Database Maintenance

  •    Automating SQL Server Management

  •    Monitoring SQL Server Errors

  •    Configuring Database Mai

Microsoft 70-765 SQL Server 2016 Provisioning SQL Databases Course Content

Module 1: Deploy a Microsoft Azure SQL Database

  •    Introduction

  •    Introducing the Azure SQL Database Part 1

  •    Introducing the Azure SQL Database Part 2

  •    Setting Up Azure Lab

  •    Chose a Service Tier Part 1

  •    Chose a Service Tier Part 2

  •    Create Servers and Databases Part 1

  •    Creating a Azure SQL Server and Database Lab

  •    Create Servers and Databases Part 2

  •    Create Servers and Databases Part 3

  •    Connecting SSMS to Azure SQL Lab Part 1

  •    Connecting SSMS to Azure SQL Lab Part 2

  •    Create a Sysadmin Account

  •    Creating Azure SQL Logins and Users Lab

  •    Congure Elastic Pools

  •    Creating and Conguring an Elastic Pool Lab

Module 2: Plan for SQL Server Installation

  •    Plan for an IaaS or On-Premises Deployment Part 1

  •    Plan for an IaaS or On-Premises Deployment Part 2

  •    Select the Appropriate Size for a Virtual Machine

  •    Plan Storage Pools Based on Performance Requirements Part 1

  •    Plan Storage Pools Based on Performance Requirements Part 2

  •    Evaluate Best Practices for Installation

  •    Design a Storage Layout for a SQL Server Virtual Machine

Module 3: Deploy SQL Server Instances

  •    Deploy a SQL Server Instance in IaaS and On-Premises

  •    Restoring AdventureWorks 2016 Database Lab

  •    Provision an Azure Virtual Machine to Host a SQL Server Instance

  •    Provisioning an Azure Virtual Machine to Host a SQL Server Lab

  •    Manually Install SQL Server on an Azure Virtual Machine

  •    Installing SQL 2016 Lab Part 1

  •    Installing SQL 2016 Lab Part 2

  •    Automate the Deployment of SQL Server Databases

  •    Exploring Azure SQL Database Automation Lab

  •    Deploy SQL Server by Using Templates

  •    Managing JSON Templates Lab

Module 4: Deploy SQL Server Databases to Azure Virtual Machines

  •    Migrate an On-Premises SQL Server Database to an Azure Virtual Machine

  •    Migrate an On-Premises SQL Server Database to an Azure Virtual Machine Lab Part 1

  •    Migrate an On-Premises SQL Server Database to an Azure Virtual Machine Lab Part 2

  •    Migrate an On-Premises SQL Server Database to an Azure Virtual Machine Lab Part 3

  •    Migrate an On-Premises SQL Server Database to an Azure Virtual Machine Lab Part 4

  •    Generate Benchmark Data for Performance Needs

  •    Generating Benchmark Data Lab Part 1

  •    Generating Benchmark Data Lab Part 2

  •    Perform Performance Tuning on Azure IaaS

  •    Perform Performance Tuning on Azure IaaS Lab Part 1

  •    Perform Performance Tuning on Azure IaaS Lab Part 2

  •    Support Availability Sets in Azure Part 1

  •    Support Availability Sets in Azure Part 2

  •    Manage High Availability Lab Part 1

  •    Manage High Availability Lab Part 2

  •    Manage High Availability Lab Part 3

  •    Manage High Availability Lab Part 4

  •    Manage High Availability Lab Part 5

Module 5: Configure Secure Access to Microsoft Azure SQL Databases

  •    Configure Firewall Rules

  •    Creating Firewall Rules Lab

  •    Configure Always Encrypted for Azure SQL Database

  •    Implementing Always Encrypted Lab

  •    Configure Cell-Level Encryption

  •    Cell-Level Encryption Lab

  •    Configure Dynamic Data Masking

  •    Dynamic Data Masking Lab

  •    Configure Transparent Data Encryption (TDE)

  •    Transparent Data Encryption (TDE) Lab

Module 6: Configure SQL Server performance settings

  •    Configure SQL Performance Settings

  •    Configuring SQL Performance Settings Lab

  •    Configure Max Server Memory

  •    Configuring SQL Memory Lab

  •    Configure Database Performance Settings

  •    Configure Database Performance Settings Lab

  •    Configure Operators and Alerts

  •    Configure alerts in Azure and On-Premise SQL Server Lab

Module 7: Manage SQL Server instances

  •    Create Databases

  •    Creating Databases Lab

  •    Manage Files and File Groups

  •    Managing Files and File Groups Lab

  •    Manage System Database Files

  •    Manage System Database Files Lab

  •    Configure tempdb

  •    Configure tempdb Lab

Module 8: Manage SQL Storage

  •    Manage SMB File Shares

  •    Manage SMB File Shares Lab

  •    Manage Stretch Databases

  •    Configure Azure Storage

  •    Change Service Tiers

  •    Change Service Tiers Lab Part 1

  •    Review Wait Statistics

  •    Manage Storage Pools

  •    Recover from Failed Storage

  •    Managing Storage Lab Part 1

  •    Managing Storage Lab Part 2

Module 9: Perform Database Maintenance

  •    Monitoring Tools

  •    Using Monitoring Tools Lab Part 1

  •    Using Monitoring Tools Lab Part 2

  •    Azure Performance Tuning

  •    Automate Maintenance Tasks

  •    Update Statistics and Indexes

  •    Update Statistics and Indexes Lab Part 1

  •    Update Statistics and Indexes Lab Part 2

  •    Verify Database Integrity

  •    Verify Database Integrity Lab

  •    Recover from Database Corruption

  •    Recover from Database Corruption Lab

  •    Conclusion

Microsoft 70-764 SQL 2016 - Administering a SQL Database Infrastructure Course Content

Module 1: Configure Encryption

  •    Introduction

  •    Exam Objectives and Lab Setup

  •    Restoring AdventureWorks 2016 Database Lab Part 1

  •    Restoring AdventureWorks 2016 Database Lab Part 2

  •    Restoring AdventureWorks 2016 Database Lab Part 3

  •    Configure Encryption

  •    Cell-Level Encryption Part 1

  •    Cell-Level Encryption Part 2

  •    Cell-Level Encryption Lab Part 1

  •    Cell-Level Encryption Lab Part 2

  •    Transparent Data Encryption

  •    Transparent Data Encryption Lab

  •    Always Encrypted

  •    Always Encrypted Lab

  •    Backup Encryption

  •    Backup Encryption Lab

  •    Connection Encryption

  •    Encryption Troubleshooting

Module 2: Configure Data Access and Permissions

  •    Create and Maintain Users

  •    Create and Maintain Users Lab Part 1

  •    Create and Maintain Users Lab Part 2

  •    Configure and Maintain Custom Roles

  •    Configure and Maintain Custom Roles Lab

  •    Manage Database Object Permissions Part 1

  •    Manage Database Object Permissions Part 2

  •    Manage Database Object Permissions Lab Part 1

  •    Manage Database Object Permissions Lab Part 2

  •    Configure User Options for Azure SQL Database

  •    Configure Row-Level Security

  •    Configure Dynamic Data Masking

  •    Configure Dynamic Data Masking Lab

Module 3: Configure Auditing

  •    Manage a SQL Server Audit

  •    Manage a SQL Server Audit Lab

  •    Query the SQL Server Audit Log

  •    Manage an Azure SQL Server Audit

Module 4: Develop a Backup Strategy

  •    Backup Types Part 1

  •    Backup Types Part 2

  •    Manage, Backup, and Restore Databases Lab Part 1

  •    Manage, Backup, and Restore Databases Lab Part 2

  •    Backup Very Large Databases Part 1

  •    Backup Very Large Databases Part 2

  •    Backup Very Large Databases Part 3

  •    Backup Very Large Databases Part 4

  •    4.9 Managing Very Large Databases Lab Part 1

  •    4.10 Managing Very Large Databases Lab Part 2

  •    4.11 Managing Very Large Databases Lab Part 3

  •    Configure Alerting for Failed Backups

  •    Configure Alerting for Failed Backups Lab Part 1

  •    Configure Alerting for Failed Backups Lab Part 2

  •    Back up Databases to Azure

  •    Manage Transaction Log Backups

  •    Configure Database Recovery Models

  •    Set Database Recovery Model Lab

  •    Configure Backup Automation

  •    Configure Backup Automation Lab

Module 5: Restore Databases

  •    Perform Piecemeal Restores

  •    Restore Databases Lab Part 1

  •    Restore Databases Lab Part 2

  •    Restore Databases Lab Part 3

  •    Perform Page Recovery

  •    Perform Point-in-Time Recovery

  •    Perform Point-in-Time Recovery Lab

  •    Restore File Groups

  •    Develop a Plan to Automate and Test Restores

Module 6: Manage Database Integrity

  •    Implement Database Consistency Checks

  •    Implement Database Consistency Checks Lab

  •    Identify Database Corruption

  •    Recover From Database Corruption

Module 7: Monitor Database Activity

  •    Monitor Current Sessions

  •    Monitor Current Sessions Lab

  •    Identify Sessions that Cause Blocking Activity

  •    Identify Sessions that Consume tempdb Resources

  •    Configure the Data Collector

Module 8: Monitor Queries

  •    Manage the Query Store

  •    Manage the Query Store Lab

  •    Configure Extended Events and Trace Events

  •    Identify Problematic Execution Plans

Module 9: Manage Indexes

  •    Identify and Repair Index Fragmentation

  •    Identify and Create Missing Indexes

  •    Identify and Drop Underutilized Indexes

  •    Manage Existing Columnstore Indexes Part 1

  •    Manage Existing Columnstore Indexes Part 2

  •    Partitioned Tables

Module 10: Monitor SQL Server Instances

  •    Create and Manage Operators

  •    Create and Manage SQL Agent Alerts

  •    Configure Policy-Based Management

  •    Configure Policy-Based Management Lab

  •    Identify Available Space on Data Volumes

  •    Identify the Cause of- Manage Performance Degradation

  •    Identify the Cause of- Manage Performance Degradation Lab Part 1

  •    Identify the Cause of- Manage Performance Degradation Lab Part 2

Module 11: Implement Log Shipping

  •    Configure and Monitor Log Shipping

  •    Configure and Monitor Log Shipping Lab Part 1

  •    Configure and Monitor Log Shipping Lab Part 2

Module 12: Implement Failover Cluster Instances

  •    Windows Server Failover Cluster

  •    Manage Shared Disks

  •    Configure Cluster Shared Volumes

  •    Configuring WSFC Lab

Module 13: Implement Always On Availability Groups

  •    Database Mirroring

  •    Create an Availability Group

  •    Manage Failover

  •    Configure Read-Only Routing

  •    Create Distributed Availability Groups

  •    Configuring Always On Availability Group Lab Part 1

  •    Configuring Always On Availability Group Lab Part 2

  •    Conclusion

Microsoft 70-467: Designing Business Intelligence Solutions with SQL Server 2012 Course Content

Module 1: Intro To Business Intelligence

  •    Introduction

  •    The Business Intelligence Solution

  •    Overview Of Business Intelligence

  •    BI And Power Pivot Demo

  •    ETL Intro

  •    Designing Data Warehouses

  •    Design For Speed

  •    BI Semantic Model

Module 2: Database Essentials

  •    Basic Database Objects Demo

  •    Stored Procedures And Triggers Demo

  •    Database Clusters Demo

  •    SQL Server Management

  •    Table Triggers

  •    DB Config Options

  •    DB Backup

  •    DB Files And Restore

Module 3: Business Intelligence Development

  •    Using SQL Server Data Tools Demo

  •    Building An IS Integration Services Package Demo

  •    Loading Data From Remote Sources Demo

Module 4: Business Intelligence Results

  •    Report Building Intro Setup Demo

  •    Using Report Builder Demo

  •    Processing Data From Web Service Demo

  •    Reporting From Multiple Tables Demo

  •    Report Function And Matrix Demo

  •    Interactive Reports Demo

  •    Sorting Report Data Demo

Module 5: Advanced Reporting And Development

  •    Drill Through Reports

  •    Data Visualization

  •    Creating Store Procedure From Scratch

  •    Memory Optimize Table

Module 6: SQL Server Integration Services (SSIS)

  •    Building Our First Integration Project

  •    Data Transformation

  •    Introduction To Big Data

  •    Transformation Using Store Procedure

  •    Transformation Using SSIS

  •    Building Fact Table Using Store Procedure

  •    Building Fact Table Using SSIS

Module 7: SQL Server 2014 New Features

  •    Backup Enhancements

  •    Index Enhancements

  •    Online DB Enhancements

  •    BackUp To The Cloud

  •    Partition Data

Module 8: Course Review And Exam Prep

  •    BI Review

  •    SharePoint Overview

  •    SharePoint Demo

  •    Exam Prep

  •    Before You Take The Exam

  •    Conclusion

Microsoft 70-466: Implementing Data Models & Reports with SQL Server 2012 Course Content

Module 1: Introduction To Business Intelligence And Data Modeling

  •    Introduction To Business Intelligence and Data Modeling Part1

  •    Introduction To Business Intelligence and Data Modeling Part2

  •    The Microsoft Business Intelligence Platform Part 1

  •    The Microsoft Business Intelligence Platform Part 2

  •    The Microsoft Business Intelligence Platform Part 3

  •    The Microsoft Business Intelligence Platform Part 4

Module 2: Implementing Reports The SQL Server Reporting Services

  •    Implementing Reports the SQL Server Reporting Services Part 1

  •    Implementing Reports the SQL Server Reporting Services Part 2

  •    Implementing Reports the SQL Server Reporting Services Part 3

  •    Implementing Reports the SQL Server Reporting Services Part 4

  •    Implementing Reports the SQL Server Reporting Services Part 5

  •    Implementing Reports the SQL Server Reporting Services Part 6

  •    Implementing Reports the SQL Server Reporting Services Part 7

  •    Implementing Reports the SQL Server Reporting Services Part 8

Module 3: Supporting Self Service Reporting

  •    Supporting Self Service Reporting Part 1

  •    Supporting Self Service Reporting Part 2

Module 4: Managing Report Execution And Delivery

  •    Managing Report Execution And Delivery

  •    Managing Report Execution

  •    Subscriptions And Data Alerts

Module 5: Creating Multidimensional Databases

  •    Creating Multidimensional Databases

  •    Creating Data Sources And Data Source Views

  •    Creating And Browsing a Cube

Module 6: Working With Cubes And Dimensions

  •    Working with Cubes And Dimensions

  •    Sorting And Grouping Attributes

Module 7: Working With Measures And Measure Groups

  •    Working With Measures and Measure Groups

Module 8: Introduction To MDX

  •    Introduction To MDX

  •    Adding Calculations To A Cube

Module 9: Customizing Cube Functionality

  •    Customizing Cube Functionality Part 1

  •    Customizing Cube Functionality Part 2

  •    Customizing Cube Functionality Part 3

Module 10: Implementing A Tabular Data Model

  •    Implementing A Tabular Data Model Part 1

  •    Implementing A Tabular Data Model Part 2

Module 11: Introduction To DAX

  •    Introduction to DAX

  •    Demonstration Making A Tabular Model Part 1

  •    Demonstration Making A Tabular Model Part 2

  •    Using DAX

Module 12: Implementing An Analysis Services Tabular Data Model

  •    Implementing An Analysis Services Tabular Data Model Part 1

  •    Implementing An Analysis Services Tabular Data Model Part 2

  •    Deploying A Tabular Data Model

Module 13: SQL Analysis Services

  •    SQL Analysis Services Part 1

  •    SQL Analysis Services Part 2

Module 14: Creating Data Visualizations With Power View

  •    Creating Data Visualizations With Power View

Module 15: Supporting Self Service Reporting

  •    Supporting Self Service Reporting

Module 16: Performing Predictive Analysis With Data Mining

  •    Performing Predictive Analysis With Data Mining

  •    Using The Data Mining Wizard

Module 17: Predictive Analytics

  •    Predictive Analytics Part 1

  •    Predictive Analytics Part 2

Microsoft 70-465: Designing Database Solutions for Microsoft SQL Server 2012 Course Content

Module 1: Designing A Database Server Infrastructure

  •    Introduction

  •    Designing A Database Server Infrastructure-Part1

  •    Designing A Database Server Infrastructure-Part2

  •    Designing A Database Server Infrastructure-Part3

  •    Designing A Database Server Infrastructure-Part4

  •    Considerations For Database Server Consolidation

  •    Managing Server Resources

Module 2: Designing A Logical Database Scheme

  •    Designing A Logical Database Scheme-Part1

  •    Designing A Logical Database Scheme-Part2

  •    Designing A Logical Database Scheme-Part3

  •    Designing A Logical Database Scheme-Part4

  •    Designing A Logical Database Scheme-Part5

Module 3: Designing A Physical Database Implementation

  •    Designing A Physical Database Implementation-Part1

  •    Designing A Physical Database Implementation-Part2

  •    Designing A Physical Database Implementation-Part3

Module 4: Incorporating Data Files Into the Database

  •    Incorporating Data Files Into The Database-Part1

  •    Incorporating Data Files Into The Database-Part2

  •    Incorporating Data Files Into The Database-Part3

  •    Incorporating Data Files Into The Database Demo

  •    Searching Data Files

  •    Searching Data Files Demo

Module 5: Tuning Database Performance

  •    Tuning Database Performance-Part1

  •    Tuning Database Performance-Part2

  •    Tuning Database Performance-Part3

  •    Working With Query Plans-Part1

  •    Working With Query Plans-Part2

  •    Working With Query Plans-Part3

  •    Working With Query Plans-Part4

Module 6: Designing Database Security

  •    Designing Database Security-Part1

  •    Designing Database Security-Part2

  •    Contained Databases

  •    Protecting Data With Encryption

Module 7: Policy Based Management

  •    Policy Based Management

  •    Policy Based Management Demo

Module 8: Monitoring Server Health

  •    Monitoring Server Health

  •    Monitoring Server Health Demo

Module 9: Designing Database Backup Solution

  •    Designing Database Backup Solution-Part1

  •    Designing Database Backup Solution-Part2

  •    Designing Database Backup Solution-Part3

  •    Designing Database Backup Solution-Part4

  •    Disaster Recovery Plan-Part1

  •    Disaster Recovery Plan-Part2

Module 10: Automating Multi Server Maintenance

  •    Automating Multi Server Maintenance

  •    Managing Multiple Servers

Module 11: Managing SQL Server With Windows Powershell

  •    Managing SQL Server WIth Windows Powershell

  •    Windows Powershell Lab

Module 12: Replicating Data

  •    Replicating Data-Part1

  •    Replicating Data-Part2

  •    Replicating Data-Part3

Module 13: Planning High Availability

  •    Planning High Availability-Part1

  •    Planning High Availability-Part2

Module 14: Review of SQL Statements

  •    Review Of SQL Statements-Part1

  •    Review Of SQL Statements-Part2

  •    Review Of SQL Statements-Part3

Module 15: Eleven Rules of Database Design

  •    Eleven Rules Of Database Design

  •    Conclusion

Microsoft 70-464: Developing Microsoft SQL Server 2012 Databases Course Content

Module 1: SQL 2012 And The 464 Test

  •    Introduction

  •    Intro To SQL Server 2012-Part1

  •    Intro To SQL Server 2012-Part2

  •    Management Studio Demo-Part1

  •    Management Studio Demo-Part2

  •    Management Studio Demo-Part3

  •    Other SQL Server Tools

Module 2: Working With Data Types

  •    Working With Data Types-Part1

  •    Working With Data Types-Part2

  •    Working With Data Types-Part3

  •    Other Data Types

Module 3: Tables

  •    Tables

  •    Creating Tables

Module 4: Data Constraints

  •    Data Constraints-Part1

  •    Data Constraints-Part2

Module 5: Planning In Indexing

  •    Planning In Indexing-Part1

  •    Planning In Indexing-Part2

  •    Planning In Indexing-Part3

  •    Planning In Indexing-Part4

Module 6: Table Structures

  •    Table Structures

  •    Working With Clustered Indexes

  •    Clustered Indexes

  •    Designing Effective Clustered Indexes

Module 7: Improving Performance with Non-Clustered Indexes

  •    Improving Performance With Non-Clustered Indexes-Part1

  •    Improving Performance With Non-Clustered Indexes-Part2

  •    Improving Performance With Non-Clustered Indexes-Part3

Module 8: Using Indexes And Execution Plans

  •    Using Indexes

  •    Execution Plans-Part1

  •    Execution Plans Demo

  •    Execution Plans-Part2

Module 9: Working with Views

  •    Working With Views-Part1

  •    Working With Views-Part2

Module 10: Designing and Implementing Stored Procedures

  •    Designing And Implementing Stored Procedures-Part1

  •    Designing And Implementing Stored Procedures-Part2

  •    Designing And Implementing Stored Procedures-Part3

Module 11: Merging Data and Passing Tables

  •    Merging Data And Passing Tables-Part1

  •    Merging Data And Passing Tables-Part2

  •    Merging Data And Passing Tables-Part3

Module 12: Designing and Implementing User Functions

  •    Designing And Implementing User Functions

Module 13: Creating Highly Concurrent SQL Server Applications

  •    Creating Highly Concurrent SQL Server Applications-Part1

  •    Creating Highly Concurrent SQL Server Applications-Part2

  •    Creating Highly Concurrent SQL Server Applications-Part3

Module 14: Handling Errors in T-SQL

  •    Handling Error InT-SQL-Part1

  •    Handling Error InT-SQL-Part2

Module 15: Triggers

  •    Triggers

Module 16: Implementing Managed Code

  •    Implementing Managed Code-Part1

  •    Implementing Managed Code-Part2

  •    Implementing Managed Code-Part3

  •    Implementing Managed Code-Part4

Module 17: Storing XML in SQL

  •    Storing XML In SQL-Part1

  •    Storing XML In SQL-Part2

Module 18: Querying XML

  •    Querying XML-Part1

  •    Querying XML-Part2

Module 19: Working with the Spatial Data

  •    Working With Spatial Data-Part1

  •    Working With Spatial Data-Part2

  •    Working With Spatial Data-Part3

Module 20: Working With Full-Text Indexes and Queries

  •    Working With Full-Text Indexes And Queries-Part1

  •    Working With Full-Text Indexes And Queries-Part2

  •    Working With Full-Text Indexes And Queries-Part3

Microsoft 70-461: Querying SQL Server 2012 Course Content

Lesson 1: Getting Started with SQL Server 2012

  •    Course Introduction

Lesson 2: Working with T-SQL

  •    Creating Queries-Part 1

  •    Creating Queries-Part 2

  •    Creating Queries-Part 3

  •    Creating Queries-Part 4

  •    Creating Queries-Part 5

  •    Constraints-Part 1

  •    Constraints-Part 2

  •    Constraints-Part 3

  •    Constraints-Part 4

  •    Constraints-Part 5

Lesson 3: Writing SELECT Queries

  •    Select Statement-Part 1

  •    Select Statement-Part 2

  •    Select Statement-Part 3

  •    Select Statement-Part 4

Lesson 4: Working with SQL Data Types

  •    Data Types-Part 1

  •    Data Types-Part 2

  •    Data Types-Part 3

  •    Data Types-Part 4

  •    Data Types-Part 5

  •    Data Types-Part 6

  •    Data Types-Part 7

  •    Data Types-Part 8

  •    Data Types-Part 9

  •    Data Types-Part 10

Lesson 5: Sorting and Filtering Data

  •    Sorting Results-Part 1

  •    Sorting Results-Part 2

  •    Sorting Results-Part 3

  •    Sorting Results-Part 4

  •    Sorting Results-Part 5

  •    Sorting Results-Part 6

Lesson 6: Querying Data from Multiple Tables

  •    Tables Part 1

  •    Tables Part 2

  •    Tables Part 3

  •    Tables Part 4

  •    Tables Part 5

  •    Tables Part 6

Lesson 7: Modifying Data

  •    Inserting Data-Part 1

  •    Inserting Data-Part 2

  •    Inserting Data-Part 3

  •    Inserting Data-Part 4

  •    Inserting Data-Part 5

  •    Inserting Data-Part 6

Lesson 8: Working with SQL Server Built-in Functions

  •    Functions

  •    Parse

  •    Logical Functions

  •    Group By

Lesson 9: Programming in T-SQL

  •    Programming-Part 1

  •    Programming-Part 2

  •    Programming-Part 3

  •    Programming-Part 4

  •    Programming-Part 5

  •    Programming-Part 6

Lesson 10: Implementing Stored Procedures

  •    Storage Procedures-Part 1

  •    Storage Procedures-Part 2

  •    Dynamic SQL-Part 1

  •    Dynamic SQL-Part 2

Lesson 11: Working with Subqueries and Table Expressions

  •    Sub-Queries And Table Expressions-Part 1

  •    Sub-Queries And Table Expressions-Part 2

  •    Sub-Queries And Table Expressions-Part 3

  •    Sub-Queries And Table Expressions-Part 4

Lesson 12: Working with Set Operators, Conditional Operators, and Window Functions

  •    Set Operators-Part 1

  •    Set Operators-Part 2

  •    Window Functions-Part 1

  •    Window Functions-Part 2

  •    User Defined Functions-Part 1

  •    User Defined Functions-Part 2

  •    Advanced Analytical Functions

Lesson 13: Working with PIVOT, UNPIVOT, and Grouping Sets

  •    Pivot

  •    Grouping Sets

Lesson 14: Managing Error Handling and Transactions

  •    Error Handling-Part 1

  •    Error Handling-Part 2

  •    Manage Transactions-Part 1

  •    Manage Transactions-Part 2

  •    Manage Transactions-Part 3

Lesson 15: Querying SQL Server System

  •    System Databases-Part 1

  •    System Databases-Part 2

  •    System Databases-Part 3

  •    System Databases-Part 4

Lesson 16: Optimizing Query Performance

  •    Query Planning-Part 1

  •    Query Planning-Part 2

  •    Index-Part 1

  •    Index-Part 2

  •    Index-Part 3

Microsoft 70-462: Administering SQL Server 2012 Databases Course Content

Lesson 1: Identifying the SQL Server Platform

  •    Overview

  •    DataStorage-Part 1

  •    DataStorage-Part 2

Lesson 2: Deploying SQL Server

  •    Install-Part 1

  •    Install-Part 2

Lesson 3: Configuring SQL Server

  •    Configuring-Part 1

  •    Configuring-Part 2

  •    Changing Memory-Part 1

  •    Changing Memory-Part 2

  •    Email-Part 1

  •    Email-Part 2

Lesson 4: Managing Databases in SQL Server 2012

  •    User Databases-Part 1

  •    User Databases-Part 2

  •    User Databases-Part 3

  •    User Databases-Part 4

  •    User Databases-Part 5

Lesson 5: Managing SQL Server Security

  •    Setting Security-Part 1

  •    Setting Security-Part 2

  •    Server Roles-Part 1

  •    Server Roles-Part 2

  •    Setting Permissions-Part 1

  •    Setting Permissions-Part 2

Lesson 6: Implementing Advanced Security Settings

  •    Querying Data From Multiple Tables-Part 1

  •    Querying Data From Multiple Tables-Part 2

  •    Querying Data From Multiple Tables-Part 3

  •    Querying Data From Multiple Tables-Part 4

  •    Querying Data From Multiple Tables-Part 5

Lesson 7: Applying Encryption and Compression

  •    Encrypting And Compressing-Part 1

  •    Encrypting And Compressing-Part 2

  •    Encrypting And Compressing-Part 3

Lesson 8: Working with Indexes and Log Files

  •    Functions-Part 1

  •    Functions-Part 2

  •    Functions-Part 3

  •    Functions-Part 4

  •    Functions-Part 5

  •    Functions-Part 6

Lesson 9: Working with Backup and Restore

  •    Managing Backups-Part 1

  •    Managing Backups-Part 2

  •    Managing Backups-Part 3

  •    Managing Backups-Part 4

  •    Managing Backups-Part 5

  •    Managing Backups-Part 6

  •    Managing Backups-Part 7

Lesson 10: Implementing High Availability

  •    Stored Procedures-Part 1

  •    Stored Procedures-Part 2

  •    Stored Procedures-Part 3

  •    Stored Procedures-Part 4

Lesson 11: Optimizing Server Performance

  •    Managing SQL Performance-Part 1

  •    Managing SQL Performance-Part 2

  •    Managing SQL Performance-Part 3

  •    Managing SQL Performance-Part 4

  •    Managing SQL Performance-Part 5

  •    Managing SQL Performance-Part 6

  •    Managing SQL Performance-Part 7

Lesson 12: Troubleshooting Issues and Recovering Databases

  •    Set Operators-Part 1

  •    Set Operators-Part 2

  •    Set Operators-Part 3

  •    Set Operators-Part 4

  •    Set Operators-Part 5

Lesson 13: Performing Advanced Database Management Tasks

  •    Managing Database Infrastructures-Part 1

  •    Managing Database Infrastructures-Part 2

  •    Managing Database Infrastructures-Part 3

Microsoft 70-463: Implementing a Data Warehouse with SQL Server 2012 Course Content

Lesson 1: Introduction to Data Warehouse

  •    Introduction

  •    Introduction To Data Warehouse-Part1

  •    Introduction To Data Warehouse-Part2

  •    Introduction To Data Warehouse-Part3

  •    Introduction To Data Warehouse-Part4

  •    Introduction To Data Warehouse-Part5

  •    Introduction To Data Warehouse-Part6

Lesson 2: Creating Dimensions and Changing Granularity of Dimensions

  •    Creating Dimensions And Changing Granularity Of Dimensions-Part1

  •    Creating Dimensions And Changing Granularity Of Dimensions-Part2

  •    Creating Dimensions And Changing Granularity Of Dimensions-Part3

  •    Creating Dimensions And Changing Granularity Of Dimensions-Part4

  •    Creating Dimensions And Changing Granularity Of Dimensions-Part5

  •    Creating Dimensions And Changing Granularity Of Dimensions-Part6

Lesson 3: Creating Fact Tables and ColumnStore Indexes

  •    Creating Fact Tables And Column Store Indexes-Part1

  •    Creating Fact Tables And Column Store Indexes-Part2

  •    Creating Fact Tables And Column Store Indexes-Part3

  •    Creating Fact Tables And Column Store Indexes-Part4

  •    Creating Fact Tables And Column Store Indexes-Part5

Lesson 4: Implementing Data Warehouse in SQL Server 2012

  •    Implementing Data Warehouse-Part1

  •    Implementing Data Warehouse-Part2

  •    Implementing Data Warehouse-Part3

  •    Implementing Data Warehouse-Part4

Lesson 5: Working with Integration Services

  •    Working With Integration Services-Part1

  •    Working With Integration Services-Part2

  •    Working With Integration Services-Part3

  •    Working With Integration Services-Part4

  •    Working With Integration Services-Part5

  •    Working With Integration Services-Part6

Lesson 6: Managing Control Flow

  •    Managing Control Flow-Part1

  •    Managing Control Flow-Part2

  •    Managing Control Flow-Part3

  •    Managing Control Flow-Part4

  •    Managing Control Flow-Part5

Lesson 7: Working with Dynamic Variables

  •    Working With Dynamic Variables-Part1

  •    Working With Dynamic Variables-Part2

  •    Working With Dynamic Variables-Part3

  •    Working With Dynamic Variables-Part4

  •    Working With Dynamic Variables-Part5

  •    Working With Dynamic Variables-Part6

  •    Working With Dynamic Variables-Part7

  •    Working With Dynamic Variables-Part8

Lesson 8: Implementing Data Flow

  •    Implementing DataFlow-Part1

  •    Implementing DataFlow-Part2

  •    Implementing DataFlow-Part3

  •    Implementing DataFlow-Part4

  •    Implementing DataFlow-Part5

  •    Implementing DataFlow-Part6

  •    Implementing DataFlow-Part7

  •    Implementing DataFlow-Part8

Lesson 9: Managing Data Flow

  •    Managing DataFlow-Part1

  •    Managing DataFlow-Part2

  •    Managing DataFlow-Part3

  •    Managing DataFlow-Part4

Lesson 10: Managing SSIS Package Execution

  •    Managing SSIS Package Execution-Part1

  •    Managing SSIS Package Execution-Part2

  •    Managing SSIS Package Execution-Part3

  •    Managing SSIS Package Execution-Part4

  •    Managing SSIS Package Execution-Part5

  •    Managing SSIS Package Execution-Part6

Lesson 11: Debugging and Troubleshooting

  •    Debugging And Troubleshooting-Part1

  •    Debugging And Troubleshooting-Part2

  •    Debugging And Troubleshooting-Part3

  •    Debugging And Troubleshooting-Part4

Lesson 12: Deploying Packages

  •    Deploying Packages-Part1

  •    Deploying Packages-Part2

  •    Deploying Packages-Part3

Lesson 13: Securing Packages and Databases

  •    Securing Packages And Databases-Part1

  •    Securing Packages And Databases-Part2

Lesson 14: Working with MDS and Windows

  •    Working With MDS And Windows Azure

Add a review
Currently, we are not accepting new reviews
4.8
Based on 78 reviews
1-5 of 78 reviews
  1. Smooth delivery and easy access to LMS. Good to see that the LMS offers progress tracking. Would be great if badges were offered on completion of courses to share via Credly to future employers.

Your Training Instructors

Chrys Thorsen

Chrys Thorsen

Education and Technology Expert

Chrys Thorsen is an education and technology expert who specializes in enterprise-level IT infrastructure consulting and certified training-of-trainers. In her career, she has garnered over 50 IT Certifications including CISSP, CISA, CEHv12, PenTest+, CompTIA CNVP, Cisco CCSI/CCNP, Microsoft Cloud and on-premises technologies, VMware vSphere, and many more. She has also authored 40 published certification textbooks, and over 35 full-length IT certification video courses.

When not working in the United States, Chrys spends her time abroad capacity-building IT literacy in developing nations in Sub-Saharan Africa. Her client list has included: the US Federal Government, the Republic of Zambia Ministry of Health, Cavendish University Zambia, Accenture, JP Morgan Chase, the US Centers for Disease Control and Prevention, the Elizabeth Glaser Pediatric AIDS Foundation (EGPAF), Hughes Aircraft, Microsoft, and many more.

Chrys lives by, and is fond of repeating, her professional creed:

“The only true measure of success for any project or training is results on the ground. Everything else is just noise.” “I teach what I deploy; I deploy what I teach.”

Rafiq Wayani

Rafiq Wayani

Project Management Instructor

Rafiq has extensive experience including more than 20 years in IT as a Systems Architect, Software Engineer, DBA, and Project Manager. He has instructed in a variety of technical areas and has designed and implemented network and information systems. Bringing nearly 30 years of advanced IT experience to each course and adding his unique perspective and “real world” tips, Rafiq has a knack for making complex topics easy to understand.

James Ring-Howell

James Ring-Howell

Microsoft Certified Trainer | Microsoft Certified Developer | Database Expert

James is a full-stack developer with over 40 years of experience. He has developed applications across all major industries and for Fortune 100 companies as well as local small businesses. James has also been teaching technology courses for over 20 years. In addition to his extensive background in technology, he has also worked as a professional opera singer.

Microsoft Sql Server Training Series - 16 Courses
 

$47.40

OR

Subscribe To All-Access
Lock In $14.99 / Month Forever

Gain access to this training and all our other courses, offering over 2,500 hours of content, with our cost-effective monthly subscription. No obligations. Cancel anytime.

$49.00 $14.99 Monthly

Microsoft Sql Server Training Series – 16 Courses

ON SALE 40% OFF
Microsoft SQL Mega Bundle Training Series
Microsoft Sql Server Training Series – 16 Courses
Additional Options to Access This Training
This training is also part of our extensive training library containing over 225 courses, 12,000+ videos and over 19,000 practice test questions.

Monthly All-Access Subscription
7 Days Free - $39.00 / month

A great option at an affordable monthly price.

Annual All-Access Subscription
$229 / year

A discounted price when paying for your All Access library on an annual basis.

Lifetime All-Access Library
$379 One time payment

Exceptional Value. Pay once, never have to buy IT training again.

Related Courses

$49.00

Learn Python programming with ITU Online. Get hands-on experience with real-world projects and become proficient in Python. Enroll now!

Python, which has been around for nearly three decades, is one of the most widely used programming languages in existence. This Python programming course is particularly helpful to data scientists and machine learning professionals, Python stands out due to its ease-of-use – it’s no wonder that universities now make it their go-to language when teaching coding.

Add To Cart

$49.00

Become a Microsoft SQL Server expert with our Microsoft 70-461: Querying SQL Server online training. Enroll now and advance your SQL skills today!

In this Microsoft 70-461: Querying SQL Server course you will learn the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2012 which is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence.

Add To Cart

$49.00

Master SQL fundamentals with our Oracle 12c OCP 1Z0-061 course. Learn SQL queries, data manipulation, and database objects. Enroll now!

Oracle Database 12c: SQL Fundamentals provides a multitude of advantages from the re-engineered Oracle Database for Cloud computing. The architecture ensures hardware and software efficiency, superior performance, manageability benefits that lead to quick and effortless cloud provisioning.

Add To Cart