Sale!

Microsoft SQL Server Training Series – 16 Courses

$699.00

-

This SQL Server training program is comprehensive. Microsoft has long been the industry standard for database technology and continues to be a top choice for both businesses and individual customers. This lengthy training program covers Microsoft SQL Server versions 2012 through 2019, which are still in wide use right now. During this online session, you’ll get an in-depth look at SQL Server administration, database design, analysis services, reporting services, PowerBI, and more.

  • 188  Training Hours
  • 194  Topics
  • 1,010 On-demand Videos
  • 1,405 Prep Questions
  • Closed Captions
  • Certificate of Completion

Unlock the full potential of Microsoft SQL Server with our cutting-edge training course! Say goodbye to the hassles and financial burdens of traditional classroom learning. Experience a revolutionary approach that combines comprehensive video instruction with hands-on practice, empowering you to master core concepts in record time.

Immerse yourself in a dynamic learning environment led by expert instructors who are passionate about sharing their extensive SQL Server knowledge. Our course is meticulously designed to provide you with a seamless learning experience, whether you’re a beginner or an experienced professional looking to enhance your skills.

By joining our program, you’ll gain a multitude of benefits. First and foremost, you’ll acquire a deep understanding of the fundamental principles of SQL Server. From database creation and management to query optimization and performance tuning, our comprehensive curriculum covers it all. Dive into advanced topics like data warehousing, business intelligence, and high availability to unlock even greater possibilities for your career.

What sets our course apart is the emphasis on hands-on experience. We believe that true mastery comes from practical application. That’s why we provide you with ample opportunities to work on real-world projects, allowing you to apply your newly acquired knowledge in a simulated professional environment. Gain the confidence to tackle any SQL Server challenge that comes your way!

In addition to the extensive training, we offer exclusive exam preparation materials to help you ace your SQL Server certification exams. Our dedicated resources, practice tests, and expert guidance will equip you with the skills and confidence needed to pass with flying colors.

Don’t let time constraints hold you back. Our accelerated learning approach enables you to achieve remarkable results in a fraction of the time it would take in a traditional classroom setting. Say goodbye to long commutes and rigid schedules. With our flexible online platform, you can learn at your own pace, whenever and wherever suits you best.

Invest in your future and unlock a world of opportunities with our Microsoft SQL Server training course. Join us now and embark on a transformative learning journey that will elevate your skills, boost your career prospects, and make you a sought-after SQL Server professional. Your success story starts here!

Skills Covered in this online course

Microsoft has long been a pioneer in database technology and remains a popular option for plenty of businesses and customers. Microsoft SQL Server versions 2012 through 2019 are covered in depth in this thorough online training series, which will provide you with the fundamental knowledge required. You will learn about SQL Server administration, database design, analysis services, reporting services, PowerBI, and more in this training series. Microsoft has long been a leader in database technology and is still a preferred choice for many companies and clients. In-depth coverage of Microsoft SQL Server versions 2012 through 2019 is provided in this comprehensive online training course, which will provide you with the necessary foundational knowledge. In this training series, you will learn about database architecture, analytical services, reporting services, PowerBI, and more.

This online course training includes video lectures from business professionals that give a thorough overview of the Microsoft SQL Server universe. To further solidify key ideas, there are additional multiple-choice, self-paced quizzes available. To keep the content relevant and current with the most recent release of Microsoft SQL Server, the course is regularly updated.

What you will discover in the online training for Microsoft SQL Server

This SQL Server training online course will provide you with the information and abilities required to utilize Microsoft SQL Server competently and successfully, regardless of your level of expertise. Through practical laboratories and quizzes, you’ll learn in-depth information about technology’s most important subjects and have the chance to put it to use. After finishing the course, you can prove your proficiency by obtaining certifications in a number of disciplines, including business intelligence operations and database security. You can advance at your own speed while getting the self-assurance and SQL expertise required to succeed in the Microsoft SQL Server environment with our self-paced learning approach. Register right away to get going!

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

The SQL Server training course is extensive and offers more than 180 hours of online training, allowing you to improve your abilities with the most well-liked and commonly used database system. Come watch this great series with us right now.

Course Outline:

Microsoft SQL Server 2019 – Introduction to Data Analysis

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

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

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)

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

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

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

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 To 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

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 an 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
Configure Elastic Pools
Creating and Configuring 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 for 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

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 Available 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

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

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

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

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

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

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

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 the 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

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 structured series of courses designed to provide in-depth knowledge and practical skills in various aspects of Microsoft SQL. It covers topics such as SQL Server administration, Business Intelligence (BI), SQL Big Data, and related certifications. The program aims to equip individuals with the necessary expertise to work effectively with Microsoft SQL technologies in real-world scenarios.

What is Microsoft Business Intelligence (BI)?

Microsoft Business Intelligence (BI) is a comprehensive suite of tools and technologies that empower organizations to gather, store, analyze, and visualize data for informed decision-making. The comprehensive SQL training program includes components such as SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), and SQL Server Reporting Services (SSRS) that are essential for building and deploying BI solutions.

What is SQL Big Data?

SQL Big Data refers to the integration of SQL technologies with big data platforms and technologies. It enables users to process and analyze vast amounts of structured and unstructured data using SQL queries and familiar SQL tools. The comprehensive SQL training program covers the fundamental concepts, tools, and techniques related to SQL Big Data processing, preparing learners to handle large-scale data analysis challenges.

What are SQL Server Analysis Services (SSAS)?

SQL Server Analysis Services (SSAS) is a key component of Microsoft SQL Server that facilitates the creation, deployment, and management of online analytical processing (OLAP) cubes and data mining models. It empowers users to perform multidimensional data analysis for business intelligence applications. The training program delves into the fundamentals of SSAS and its seamless integration with SQL Server.

What is SQL Server data administration?

SQL Server data administration encompasses the tasks involved in the management and maintenance of SQL Server databases. This includes activities such as database installation, configuration, backup and recovery, performance optimization, and security management. The comprehensive training program equips individuals with essential skills and best practices for effective 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. On average, completing the entire program may require several months of dedicated study and practice. It is important to allocate sufficient time to grasp the concepts thoroughly and gain practical experience.

What are the prerequisites for the training program?

While the prerequisites for the comprehensive Microsoft SQL training program may vary depending on the specific course or certification, having a basic understanding of SQL fundamentals and database concepts is highly recommended. Familiarity with the Microsoft Windows operating system and general computer literacy is also beneficial. Prior experience or knowledge in database management or programming can be advantageous but is not always mandatory.

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. These activities are designed to reinforce theoretical concepts and provide learners with valuable real-world experience. Participants will engage in tasks such as working with SQL Server databases, designing and implementing BI solutions, and performing data analysis using SQL tools. This practical approach enhances understanding and skill development.

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

Absolutely. Learning about SQL 2012 or SQL 2016 is highly beneficial for several reasons. Firstly, many large organizations continue to rely on older versions of Microsoft SQL Server due to the substantial costs associated with upgrading to newer versions. Therefore, understanding these prior versions is valuable for working with existing systems. Secondly, the principles and concepts you learn

Your Training Instructors

Chrys Thorsen

Education and Technology Expert

Chrys 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 35 IT Certifications including Cisco CCSI/CCNP, CISSP, CISA, MCSE/MCITP, and many more. She has also authored 40 published certification textbooks and is currently working on the new CompTIA PenTest+ courseware.

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

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