- +1 855.488.5327
- customerservice@ituonline.com
- Mon - Fri: 9:00am - 5:00pm ET
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
188 Training Hours
1,010 On-demand Videos
Closed Captions
194 Topics
1,405 Prep Questions
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:
- Introduction to Microsoft Power BI
- Microsoft 70-461: Querying SQL Server 2012
- Microsoft 70-462: Administering SQL Server 2012 Databases
- Microsoft 70-463: Implementing a Data Warehouse with SQL Server 2012
- Microsoft 70-464: Developing Microsoft SQL Server 2012 Databases
- Microsoft 70-465: Designing Database Solutions for Microsoft SQL Server 2012
- Microsoft 70-466: Implementing Data Models & Reports with SQL Server 2012
- Microsoft 70-467: Designing Business Intelligence Solutions with SQL Server 2012
- Microsoft 70-764 SQL 2016 – Administering a SQL Database Infrastructure
- Microsoft 70-765 SQL Server 2016 Provisioning SQL Databases
- Microsoft SQL Server 2019 – Big Data
- Microsoft SQL Server 2019 – Introduction to Data Analysis
- Microsoft SQL Server 2019 – Querying SQL Server
- Microsoft SQL Server 2019 Administration
- Microsoft SQL Server 2019 Analysis Services (SSAS)
- SQL Server 2019 Database Design
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 DisplayYour Achievement
Upon completion of your training, you’ll receive a personalized certificate of completion to help validate to others your new skills.
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-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
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
Your Training Instructors
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 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 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.
$79.00
OR
Subscribe To All-Access
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
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
Master the skills to become a Microsoft Certified Solutions Associate with our 70-462 Administering SQL Server course. Enroll now and start your journey!
In this Microsoft 70-462: Administering SQL Server Databases course you will learn how to perform installation, maintenance, and configuration tasks. This course will also teach you other responsibilities including setting up database systems, making sure those systems operate efficiently, and regularly storing, backing up, and securing data from unauthorized access. This course will provide students with the knowledge and skills to maintain a Microsoft SQL Server 2012 database and focuses on teaching individuals how to use SQL Server 2012 product features and tools related to maintaining a database.
$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.
$49.00
Master JavaScript Fundamentals and build powerful web applications with our comprehensive online training. Start now!
If you’re ready to dive into Java Programming, this JavaScript Fundamentals online training course is for you! You’ll start with the basics and work your way up to advanced levels. Not only will you get a comprehensive introduction to object-oriented programming, but also learn many other core Java features in detail. Don’t miss out on this opportunity – sign up now and make strides in mastering Java today!
I was looking for an online course for Six Sigma as my new boss is a true believer and I wanted to have a better handle of what is Six Sigma. I started looking around and found ITU, and bought the course, and could not be happier. I have no intention of getting certified, but at least now I can speak the jargon and understand what my boss is talking about.
The educators at ituonline.com are highly skilled but could improve their methods of instruction. In the CCNA 200-301 course, there’s a heavy emphasis on oral lectures, and it would be beneficial to include more in-depth visual aids. Annotating labs and graphics could also make the educational journey more effective. On the other hand, the N10-008 course instructor consistently offers top-notch material.
The CompTIA PenTest was an excellent course and the instructor, Chrys, explained the material in a clear and easy way for me to understand and comprehend essential techniques. Highly recommend!
This course is super detailed but not boring, and they give you cool projects to actually practice what you’re learning.