{"id":1950,"date":"2023-01-05T12:23:15","date_gmt":"2023-01-05T12:23:15","guid":{"rendered":"https:\/\/cyberstudiesinstitute.co.za\/?post_type=product&#038;p=1950"},"modified":"2023-07-18T08:18:27","modified_gmt":"2023-07-18T08:18:27","slug":"microsoft-sql-server-mega-training-series","status":"publish","type":"product","link":"https:\/\/cyberstudiesinstitute.co.za\/index.php\/product\/microsoft-sql-server-mega-training-series\/","title":{"rendered":"Microsoft Sql Server Mega Training Series"},"content":{"rendered":"<h3>Description<\/h3>\n<p>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.<\/p>\n<h3><\/h3>\n<h3><strong>This bundle includes the following courses:<\/strong><\/h3>\n<ul>\n<li>Introduction to Microsoft Power BI<\/li>\n<li>Microsoft 70-461: Querying SQL Server 2012<\/li>\n<li>Microsoft 70-462: Administering SQL Server 2012 Databases<\/li>\n<li>Microsoft 70-463: Implementing a Data Warehouse with SQL Server 2012<\/li>\n<li>Microsoft 70-464: Developing Microsoft SQL Server 2012 Databases<\/li>\n<li>Microsoft 70-465: Designing Database Solutions for Microsoft SQL Server 2012<\/li>\n<li>Microsoft 70-466: Implementing Data Models &amp; Reports with SQL Server 2012<\/li>\n<li>Microsoft 70-467: Designing Business Intelligence Solutions with SQL Server 2012<\/li>\n<li>Microsoft 70-764 SQL 2016 &#8211; Administering a SQL Database Infrastructure<\/li>\n<li>Microsoft 70-765 SQL Server 2016 Provisioning SQL Databases<\/li>\n<li>Microsoft SQL Server 2019 &#8211; Big Data<\/li>\n<li>Microsoft SQL Server 2019 &#8211; Introduction to Data Analysis<\/li>\n<li>Microsoft SQL Server 2019 &#8211; Querying SQL Server<\/li>\n<li>Microsoft SQL Server 2019 Administration<\/li>\n<li>Microsoft SQL Server 2019 Analysis Services (SSAS)<\/li>\n<li>SQL Server 2019 Database Design<\/li>\n<\/ul>\n<h3><\/h3>\n<h3>Enroll Now<\/h3>\n<p>To enroll for the course, simply click on Enroll Now on the bottom of the screen and follow the check out procedure.<\/p>\n<h3><\/h3>\n<h3>Course Outline<\/h3>\n<div id=\"page\" class=\"hfeed site\">\n<div id=\"content\" class=\"site-content\">\n<div class=\"ast-container\">\n<div class=\"elementor elementor-5797 elementor-location-single post-2527 product type-product status-publish has-post-thumbnail product_cat-data-administration product_cat-data-analysis product_cat-development-programming product_cat-hot-deals product_cat-microsoft product_tag-training-series ast-article-single ast-woo-product-no-review desktop-align-left tablet-align-left mobile-align-left first instock virtual sold-individually taxable purchasable product-type-simple product\" data-elementor-type=\"product\" data-elementor-id=\"5797\">\n<section class=\"elementor-section elementor-top-section elementor-element elementor-element-2571fa7 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2571fa7\" data-element_type=\"section\">\n<div class=\"elementor-container elementor-column-gap-no\">\n<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-d43704a\" data-id=\"d43704a\" data-element_type=\"column\">\n<div class=\"elementor-widget-wrap elementor-element-populated\">\n<div class=\"elementor-element elementor-element-882498d elementor-widget elementor-widget-eael-adv-tabs\" data-id=\"882498d\" data-element_type=\"widget\" data-widget_type=\"eael-adv-tabs.default\">\n<div class=\"elementor-widget-container\">\n<div id=\"eael-advance-tabs-882498d\" class=\"eael-advance-tabs eael-tabs-horizontal eael-tab-auto-active\" data-tabid=\"882498d\">\n<div class=\"eael-tabs-content\">\n<div id=\"course-outline-tab\" class=\"clearfix eael-tab-content-item active\" data-title-link=\"course-outline-tab\">\n<div>\n<h2 class=\"elementor-heading-title elementor-size-default\">Microsoft SQL Server 2019 &#8211; Introduction to Data Analysis Course Outline<\/h2>\n<details open=\"\">\n<summary>Module 1 &#8211; Query Tools<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a01.1 Course Introduction<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a01.2 Intro to Management Studio<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a01.3 Intro to command-line query tools<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 2 &#8211; Introduction to T-SQL Querying<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a02.1 Introducing T-SQL<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a02.2 Understanding Sets<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a02.3 Understanding the Logical Order of Operations in SELECT statements<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 3 &#8211; Basic SELECT Queries<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a03.1 Writing Simple SELECT Statements<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a03.2 Eliminate Duplicates with DISTINCT<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a03.3 Using Column and Table Aliases<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a03.4 Write Simple CASE Expressions<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 4 &#8211; Querying Multiple Tables<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a04.1 Understanding Joins<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a04.2 Querying with Inner Joins<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a04.3 Querying with Outer Joins<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a04.4 Querying with Cross Joins and Self Joins<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 5 &#8211; Sorting and Filtering Data<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a05.1 Sorting Data<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a05.2 Filtering Data with Predicates<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a05.3 Filtering with the TOP and OFFSET-FETCH<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a05.4 Working with Unknown Values<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 6 &#8211; Introduction to Business Intelligence and Data Modeling<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a06.1 Introduction to Business Intelligence<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a06.2 The Microsoft Business Intelligence Platform<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a06.3 Exploring a Data Warehouse<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a06.4 Exploring a Data Model<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 7 &#8211; Prepare Data<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a07.1 Introduction to Power BI<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a07.2 Get data from various data sources<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a07.3 Preview source data<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 8 &#8211; Clean, Transform, and Load Data<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a08.1 Data Transformation Intro<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a08.2 Transformation Example 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a08.3 Transformation Example 2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a08.4 Transformation Example 3<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a08.5 Transformation Example 4<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a08.6 Transformation Example 5<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a08.7 Transformation Example 6<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 9 &#8211; Design a Data Model<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a09.1 Introduction to Data Modeling<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a09.2 Model Relationships<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a09.3 Table Configuration<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a09.4 Model interface<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a09.5 Quick Measures<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a09.6 Many-to-many relationships<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a09.7 Row-level security<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 10 &#8211; Create Model Calculations using DAX<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a010.1 DAX context<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a010.2 Calculated Tables<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a010.3 Calculated Columns<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a010.4 Managing Date Tables<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a010.5 Measures<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a010.6 Filter Manipulation<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a010.7 Time Intelligence<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 11 &#8211; Create Reports<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a011.1 Basic Report Creation<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a011.2 Example Page 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a011.3 Example Page 2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a011.4 Example Page 3<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a011.5 Report Publishing<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a011.6 Enhancing Reports<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a011.7 Drill-Through Pages<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a011.8 Conditional Formatting<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a011.9 Buttons and Bookmarks<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 12 &#8211; Create Dashboards<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a012.1 Dashboard Basics<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a012.2 Real Time Dashboards<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a012.3 Enhanced Dashboards<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 13 &#8211; Create Paginated Reports<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a013.1 Introduction to Power BI Report Builder<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a013.2 Report Layouts<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a013.3 Report Data<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a013.4 Report Tables<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 14 &#8211; Perform Advanced Analytics<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a014.1 Introduction to Advanced Analytics<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a014.2 Scatter Chart<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a014.3 Forecast<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a014.4 Decomposition Tree<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a014.5 Key Influencers<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 15 &#8211; Create and Manage Workspaces<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a015.1 Introduction to Workspaces<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a015.2 Working with Workspaces and the Portal<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 16 &#8211; Create Power App Visuals<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a016.1 Introduction to Power Apps Visual<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a016.2 Creating the App<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a016.3 Basic Power Apps Concepts<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a016.4 Refreshing the Report<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 17 &#8211; Analysis Services and Power BI<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a017.1 Introduction to Analysis Services<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a017.2 Connecting with Multidimensional Models<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a017.3 Premium Workspaces and Analysis Services<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a017.4 Course Wrap Up<\/li>\n<\/ul>\n<\/details>\n<\/div>\n<div>\n<h2 class=\"elementor-heading-title elementor-size-default\">Microsoft SQL Server 2019 &#8211; Querying SQL Server Course Outline<\/h2>\n<details open=\"\">\n<summary>Module 1 &#8211; Query Tools<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a01.1 Course Introduction<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a01.2 Module 1 Introduction<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a01.3 Intro to Management Studio<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a01.4 Intro to command-line query tools<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 2 &#8211; Introduction to T-SQL Querying<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a02.1 Module 2 Introduction<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a02.2 Introducing T-SQL<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a02.3 Understanding Sets<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a02.4 Understanding the Logical Order of Operations in SELECT statements<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 3 &#8211; Basic SELECT Queries<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a03.1 Module 3 Introduction<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a03.2 Writing Simple SELECT Statements<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a03.3 Eliminate Duplicates with DISTINCT<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a03.4 Using Column and Table Aliases<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a03.5 Write Simple CASE Expressions<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 4 &#8211; Querying Multiple Tables<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a04.1 Module 4 Introduction<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a04.2 Understanding Joins<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a04.3 Querying with Inner Joins<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a04.4 Querying with Outer Joins<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a04.5 Querying with Cross Joins and Self Joins<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 5 &#8211; Sorting and Filtering Data<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a05.1 Module 5 Introduction<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a05.2 Sorting Data<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a05.3 Filtering Data with Predicates<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a05.4 Filtering with the TOP and OFFSET-FETCH<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a05.5 Working with Unknown Values<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 6 &#8211; Working with SQL Server Data Types<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a06.1 Module 6 Introduction<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a06.2 Writing Queries that return Date and Time Data<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a06.3 Writing Queries that use Date and Time Functions<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a06.4 Writing Queries that return Character Data<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a06.5 Writing Queries that use Character Functions<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 7 &#8211; Using DML to Modify Data<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a07.1 Module 7 Introduction<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a07.2 Inserting Records with DML<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a07.3 Updating Records Using DML<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a07.4 Deleting Records Using DML<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 8 &#8211; Using Built-In Functions<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a08.1 Module 8 Introduction<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a08.2 Writing Queries with Built-In Functions<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a08.3 Using Conversion Functions<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a08.4 Using Logical Functions<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a08.5 Using Functions to Work with NULL<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 9 &#8211; Grouping and Aggregating Data<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a09.1 Module 9 Introduction<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a09.2 Using Aggregate Functions<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a09.3 Using the GROUP BY Clause<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a09.4 Filtering Groups with HAVING<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 10 &#8211; Using Subqueries<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a010.1 Module 10 Introduction<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a010.2 Writing Self-Contained Subqueries<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a010.3 Writing Correlated Subqueries<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a010.4 Using the EXISTS Predicate with Subqueries<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 11 &#8211; Using Table Expressions<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a011.1 Module 11 Introduction<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a011.2 Using Views<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a011.3 Using Inline Table-Valued Functions<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a011.4 Using Derived Tables<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a011.5 Using Common Table Expressions<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 12 &#8211; Using Set Operators<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a012.1 Module 12 Introduction<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a012.2 Writing Queries with the UNION operator<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a012.3 Using EXCEPT and INTERSECT<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a012.4 Using APPLY<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 13 &#8211; Using Window Ranking, Offset, and Aggregate Functions<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a013.1 Module 13 Introduction<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a013.2 Creating Windows with OVER<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a013.3 Exploring Window Functions<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 14 &#8211; Pivoting and Grouping Sets<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a014.1 Module 14 Introduction<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a014.2 Writing Queries with PIVOT and UNPIVOT<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a014.3 Working with Grouping Sets<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 15 &#8211; Implementing Error Handling<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a015.1 Module Introduction<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a015.2 Implementing T-SQL error handling<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a015.3 Implementing structured exception handling<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 16 &#8211; Managing Transactions<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a016.1 Module 16 Introduction<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a016.2 Transactions and the Database Engine<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a016.3 Controlling Transactions<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a016.4 Course Wrap Up<\/li>\n<\/ul>\n<\/details>\n<\/div>\n<div>\n<h2 class=\"elementor-heading-title elementor-size-default\">SQL Server 2019 Database Design Course Outline<\/h2>\n<details open=\"\">\n<summary>Module 1 &#8211; Designing and Building Tables<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a01.1 Course Introduction<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a01.2 Module 1 Introduction<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a01.3 Introduction to Database Design<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a01.4 Creating Tables<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a01.5 Data Types<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a01.6 Schemas<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a01.7 Altering Tables<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 2 &#8211; Enforcing Data Integrity<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a02.1 Module 2 Introduction<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a02.2 Introduction to Data Integrity<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a02.3 Data Domain Integrity<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a02.4 Implementing Data Domain Integrity<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a02.5 Implementing Entity and Referential Integrity<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 3 &#8211; Indexing<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a03.1 Module 3 Introduction<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a03.2 Core Indexing Concepts<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a03.3 Heaps, Clustered, and Nonclustered Indexes<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a03.4 Data Types and Indexes<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a03.5 Single Column and Composite Indexes<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 4 &#8211; Stored Procedures, Functions, and Triggers<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a04.1 Module 4 Introduction<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a04.2 Introduction to Database Programming<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a04.3 Creating Stored Procedures<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a04.4 Creating User-Defined Functions<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a04.5 Creating Triggers<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 5 &#8211; Blob and Filestream Data<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a05.1 Module 5 Introduction<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a05.2 Introduction to Binary Data<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a05.3 Considerations for BLOB data<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a05.4 FILESTREAM Example<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a05.5 File Table Example<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 6 &#8211; Full-Text Search<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a06.1 Module 6 Introduction<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a06.2 Introduction to Full-Text Search<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a06.3 Full-Text Catalogs<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a06.4 Full-Text Indexes<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a06.5 Full-Text Queries<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 7 &#8211; Azure vs On-Prem<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a07.1 Module 7 Introduction<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a07.2 SQL Server on Azure VM<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a07.3 Azure Managed SQL Instance<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a07.4 Azure SQL Database<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a07.5 Course Wrap Up<\/li>\n<\/ul>\n<\/details>\n<\/div>\n<div>\n<h2 class=\"elementor-heading-title elementor-size-default\">Microsoft SQL Server 2019 Analysis Services (SSAS) Course Outline<\/h2>\n<details open=\"\">\n<summary>Module 1 &#8211; Introduction to Business Intelligence and Data Modeling<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a01.1 Course Introduction<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a01.2 Module 1 Introduction<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a01.3 Introduction to Business Intelligence<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a01.4 The Microsoft Business Intelligence Platform<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a01.5 Exploring a Data Warehouse<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a01.6 Exploring a Data Model<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 2 &#8211; Multidimensional Databases<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a02.1 Module 2 Introduction<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a02.2 Introduction to Multidimensional Analysis<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a02.3 Overview of Cube Security<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a02.4 Creating and Configuring a Cube<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a02.5 Data Sources<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a02.6 Data Source Views<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a02.7 Adding a Dimension to a Cube<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 3 &#8211; Cubes and Dimensions<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a03.1 Module 3 Introduction<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a03.2 Dimensions<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a03.3 Attribute Hierarchies and Relationships<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a03.4 Sorting and Grouping Attributes<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a03.5 Slowly Changing Dimensions<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 4 &#8211; Measures and Measure Groups<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a04.1 Module 4 Introduction<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a04.2 Measures<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a04.3 Measure Groups and Relationships<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a04.4 Measure Group Storage<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 5 &#8211; Introduction to MDX<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a05.1 Module 5 Introduction<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a05.2 MDX Fundamentals<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a05.3 Adding Calculations to a Cube<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a05.4 Querying a cube using MDX<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 6 &#8211; Customizing Cube Functionality<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a06.1 Module 6 Introduction<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a06.2 Key Performance Indicators<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a06.3 Actions<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a06.4 Perspectives<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a06.5 Translations<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 7 &#8211; Tabular Data Models<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a07.1 Module 7 Introduction<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a07.2 Introduction to Tabular Data Models<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a07.3 Creating a Tabular Data Model<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a07.4 Configure Relationships and Attributes<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a07.5 Configuring Data Model for an Enterprise BI Solution<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 8 &#8211; Data Analysis Expressions (DAX)<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a08.1 Module 8 Introduction<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a08.2 DAX Fundamentals<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a08.3 Calculated Columns<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a08.4 Relationships<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a08.5 Measures<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a08.6 Time Intelligence<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a08.7 KPI<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a08.8 Parent &#8211; Child Hierarchies<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 9 &#8211; Data Mining<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a09.1 Module 9 Introduction<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a09.2 Overview of Data Mining<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a09.3 Custom Data Mining Solutions<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a09.4 Validating a Data Mining Model<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a09.5 Consuming a Data Mining Model<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a09.6 Course Wrap Up<\/li>\n<\/ul>\n<\/details>\n<\/div>\n<div>\n<h2 class=\"elementor-heading-title elementor-size-default\">Introduction to Microsoft Power BI Course Outline<\/h2>\n<details open=\"\">\n<summary>Module 1 &#8211; Prepare Data<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a01.1 Course Introduction<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a01.2 Module 1 Introduction<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a01.3 Introduction to Power BI<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a01.4 Get data from various data sources<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a01.5 Preview source data<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 2 &#8211; Clean, Transform, and Load Data<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a02.1 Module 2 Introduction<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a02.2 DimEmployee Example<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a02.3 DimEmployeeSalesTerritory Example<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a02.4 DimReseller Example<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a02.5 FactResellersSales Example<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a02.6 ResellerSalesTargets Example<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a02.7 Color Formats Example<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 3 &#8211; Design a Data Model<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a03.1 Module 3 Introduction<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a03.2 Introduction to Data Modeling<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a03.3 Model Relationships<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a03.4 Table Configuration<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a03.5 Model interface<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a03.6 Quick Measures<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a03.7 Many-to-many relationships<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a03.8 Row-level security<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 4 &#8211; Create Model Calculations using DAX<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a04.1 Module 4 Introduction<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a04.2 DAX context<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a04.3 Calculated Tables<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a04.4 Calculated Columns<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a04.5 Managing Date Tables<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a04.6 Measures<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a04.7 Filter Manipulation<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a04.8 Time Intelligence<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 5 &#8211; Create Reports<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a05.1 Module 5 Introduction<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a05.2 Basic Report Creation<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a05.3 Example Page 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a05.4 Example Page 2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a05.5 Example Page 3<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a05.6 Report Publishing<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a05.7 Enhancing Reports<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a05.8 Drill-Through Pages<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a05.9 Conditional Formatting<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a05.10 Buttons and Bookmarks<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 6 &#8211; Create Dashboards<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a06.1 Module 6 Introduction<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a06.2 Dashboard Basics<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a06.3 Real Time Dashboards<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a06.4 Enhanced Dashboards<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 7 &#8211; Create Paginated Reports<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a07.1 Module 7 Introduction<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a07.2 Introduction to Power BI Report Builder<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a07.3 Report Layouts<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a07.4 Report Data<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a07.5 Report Tables<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 8 &#8211; Perform Advanced Analytics<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a08.1 Module 8 Introduction<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a08.2 Introduction to Advanced Analytics<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a08.3 Scatter Chart<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a08.4 Forecast<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a08.5 Decomposition Tree<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a08.6 Key Influencers<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 9 &#8211; Create and Manage Workspaces<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a09.1 Introduction to Workspaces<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a09.2 Working with Workspaces and the Portal<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 10 &#8211; Create Power App Visuals<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a010.1 Module 10 Introduction<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a010.2 Introduction to Power Apps Visual<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a010.3 Creating the App<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a010.4 Basic Power Apps Concepts<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a010.5 Refreshing the Report<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 11 &#8211; Analysis Services and Power BI<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a011.1 Module 11 Introduction<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a011.2 Introduction to Analysis Services<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a011.3 Connecting with Multidimensional Models<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a011.4 Premium Workspaces and Analysis Services<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a011.5 Course Wrap Up<\/li>\n<\/ul>\n<\/details>\n<\/div>\n<div>\n<h2 class=\"elementor-heading-title elementor-size-default\">Microsoft SQL Server 2019 &#8211; Big Data Course Outline<\/h2>\n<details open=\"\">\n<summary>Module 1: What are Big Data Clusters?<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a01.1 Introduction<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a01.2 Linux, PolyBase, and Active Directory<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a01.3 Scenarios<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 2: Big Data Cluster Architecture<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a02.1 Introduction<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a02.2 Docker<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a02.3 Kubernetes<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a02.4 Hadoop and Spark<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a02.5 Components<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a02.6 Endpoints<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 3: Deployment of Big Data Clusters<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a03.1 Introduction<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a03.2 Install Prerequisites<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a03.3 Deploy Kubernetes<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a03.4 Deploy BDC<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a03.5 Monitor and Verify Deployment<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 4: Loading and Querying Data in Big Data Clusters<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a04.1 Introduction<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a04.2 HDFS with Curl<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a04.3 Loading Data with T-SQL<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a04.4 Virtualizing Data<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a04.5 Restoring a Database<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 5: Working with Spark in Big Data Clusters<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a05.1 Introduction<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a05.2 What is Spark<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a05.3 Submitting Spark Jobs<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a05.4 Running Spark Jobs via Notebooks<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a05.5 Transforming CSV<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a05.6 Spark-SQL<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a05.7 Spark to SQL ETL<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 6: Machine Learning on Big Data Clusters<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a06.1 Introduction<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a06.2 Machine Learning Services<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a06.3 Using MLeap<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a06.4 Using Python<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a06.5 Using R<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 7: Create and Consume Big Data Cluster Apps<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a07.1 Introduction<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a07.2 Deploying, Running, Consuming, and Monitoring an App<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a07.3 Python Example &#8211; Deploy with azdata and Monitoring<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a07.4 R Example &#8211; Deploy with VS Code and Consume with Postman<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a07.5 MLeap Example &#8211; Create a yaml file<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a07.6 SSIS Example &#8211; Implement scheduled execution of a DB backup<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 8: Maintenance of Big Data Clusters<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a08.1 Introduction<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a08.2 Monitoring<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a08.3 Managing and Automation<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a08.4 Course Wrap Up<\/li>\n<\/ul>\n<\/details>\n<\/div>\n<div>\n<h2 class=\"elementor-heading-title elementor-size-default\">Microsoft SQL Server 2019 Administration Course Outline<\/h2>\n<details open=\"\">\n<summary>Module 1: Installation<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0SQL Admin Intro<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Installation<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 2: Data Storage<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Introduction to Data Storage with SQL Server<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Managing Storage for System Databases<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Managing Storage for User Databases<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Moving Database Files<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 3: Data Recover<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Intro to Data Recovery<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Understanding SQL Server Recovery Models<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Planning a Backup Strategy<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Backing up Databases and Transaction Logs<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Using SSMS For Backup<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Understanding the Restore Process<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0How to Restore a Database<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Using SSMS For Restore<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0T-SQL Backup and Restore<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Advanced Restore Scenarios<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Introduction to Transferring Data<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Importing and Exporting Table Data<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Copying or Moving a Database<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 4: Monitoring<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Introduction to Monitoring SQL Server<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Dynamic Management Views and Functions<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Server Reports<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0System Performance Monitor<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Tracing SQL Server Workload Activity<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Extended Events<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Database Tuning Advisor<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 5: Security<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Introduction to SQL Server Security<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Managing Server-Level Security<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Managing Database-Level Security<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Row Level Security (RLS) Using Policies<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Database Security Tools<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Contained Database<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Auditing Data Access in SQL Server<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Implementing Transparent Data Encryption<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 6: Maintenance<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Introduction to Maintenance<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Ensuring Database Integrity<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Maintaining Indexes<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Automating Routine Database Maintenance<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Automating SQL Server Management<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Monitoring SQL Server Errors<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Configuring Database Mai<\/li>\n<\/ul>\n<\/details>\n<\/div>\n<div>\n<h2 class=\"elementor-heading-title elementor-size-default\">Microsoft 70-765 SQL Server 2016 Provisioning SQL Databases Course Outline<\/h2>\n<details open=\"\">\n<summary>Module 1: Deploy a Microsoft Azure SQL Database<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Introduction<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Introducing the Azure SQL Database Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Introducing the Azure SQL Database Part 2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Setting Up Azure Lab<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Chose a Service Tier Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Chose a Service Tier Part 2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Create Servers and Databases Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Creating a Azure SQL Server and Database Lab<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Create Servers and Databases Part 2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Create Servers and Databases Part 3<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Connecting SSMS to Azure SQL Lab Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Connecting SSMS to Azure SQL Lab Part 2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Create a Sysadmin Account<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Creating Azure SQL Logins and Users Lab<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Congure Elastic Pools<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Creating and Conguring an Elastic Pool Lab<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 2: Plan for SQL Server Installation<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Plan for an IaaS or On-Premises Deployment Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Plan for an IaaS or On-Premises Deployment Part 2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Select the Appropriate Size for a Virtual Machine<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Plan Storage Pools Based on Performance Requirements Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Plan Storage Pools Based on Performance Requirements Part 2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Evaluate Best Practices for Installation<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Design a Storage Layout for a SQL Server Virtual Machine<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 3: Deploy SQL Server Instances<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Deploy a SQL Server Instance in IaaS and On-Premises<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Restoring AdventureWorks 2016 Database Lab<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Provision an Azure Virtual Machine to Host a SQL Server Instance<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Provisioning an Azure Virtual Machine to Host a SQL Server Lab<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Manually Install SQL Server on an Azure Virtual Machine<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Installing SQL 2016 Lab Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Installing SQL 2016 Lab Part 2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Automate the Deployment of SQL Server Databases<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Exploring Azure SQL Database Automation Lab<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Deploy SQL Server by Using Templates<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Managing JSON Templates Lab<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 4: Deploy SQL Server Databases to Azure Virtual Machines<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Migrate an On-Premises SQL Server Database to an Azure Virtual Machine<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Migrate an On-Premises SQL Server Database to an Azure Virtual Machine Lab Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Migrate an On-Premises SQL Server Database to an Azure Virtual Machine Lab Part 2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Migrate an On-Premises SQL Server Database to an Azure Virtual Machine Lab Part 3<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Migrate an On-Premises SQL Server Database to an Azure Virtual Machine Lab Part 4<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Generate Benchmark Data for Performance Needs<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Generating Benchmark Data Lab Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Generating Benchmark Data Lab Part 2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Perform Performance Tuning on Azure IaaS<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Perform Performance Tuning on Azure IaaS Lab Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Perform Performance Tuning on Azure IaaS Lab Part 2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Support Availability Sets in Azure Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Support Availability Sets in Azure Part 2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Manage High Availability Lab Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Manage High Availability Lab Part 2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Manage High Availability Lab Part 3<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Manage High Availability Lab Part 4<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Manage High Availability Lab Part 5<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 5: Configure Secure Access to Microsoft Azure SQL Databases<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Configure Firewall Rules<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Creating Firewall Rules Lab<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Configure Always Encrypted for Azure SQL Database<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Implementing Always Encrypted Lab<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Configure Cell-Level Encryption<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Cell-Level Encryption Lab<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Configure Dynamic Data Masking<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Dynamic Data Masking Lab<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Configure Transparent Data Encryption (TDE)<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Transparent Data Encryption (TDE) Lab<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 6: Configure SQL Server performance settings<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Configure SQL Performance Settings<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Configuring SQL Performance Settings Lab<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Configure Max Server Memory<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Configuring SQL Memory Lab<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Configure Database Performance Settings<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Configure Database Performance Settings Lab<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Configure Operators and Alerts<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Configure alerts in Azure and On-Premise SQL Server Lab<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 7: Manage SQL Server instances<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Create Databases<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Creating Databases Lab<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Manage Files and File Groups<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Managing Files and File Groups Lab<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Manage System Database Files<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Manage System Database Files Lab<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Configure tempdb<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Configure tempdb Lab<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 8: Manage SQL Storage<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Manage SMB File Shares<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Manage SMB File Shares Lab<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Manage Stretch Databases<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Configure Azure Storage<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Change Service Tiers<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Change Service Tiers Lab Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Review Wait Statistics<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Manage Storage Pools<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Recover from Failed Storage<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Managing Storage Lab Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Managing Storage Lab Part 2<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 9: Perform Database Maintenance<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Monitoring Tools<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Using Monitoring Tools Lab Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Using Monitoring Tools Lab Part 2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Azure Performance Tuning<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Automate Maintenance Tasks<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Update Statistics and Indexes<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Update Statistics and Indexes Lab Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Update Statistics and Indexes Lab Part 2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Verify Database Integrity<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Verify Database Integrity Lab<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Recover from Database Corruption<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Recover from Database Corruption Lab<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Conclusion<\/li>\n<\/ul>\n<\/details>\n<\/div>\n<div>\n<h2 class=\"elementor-heading-title elementor-size-default\">Microsoft 70-764 SQL 2016 &#8211; Administering a SQL Database Infrastructure Course Outline<\/h2>\n<details open=\"\">\n<summary>Module 1: Configure Encryption<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Introduction<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Exam Objectives and Lab Setup<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Restoring AdventureWorks 2016 Database Lab Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Restoring AdventureWorks 2016 Database Lab Part 2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Restoring AdventureWorks 2016 Database Lab Part 3<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Configure Encryption<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Cell-Level Encryption Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Cell-Level Encryption Part 2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Cell-Level Encryption Lab Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Cell-Level Encryption Lab Part 2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Transparent Data Encryption<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Transparent Data Encryption Lab<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Always Encrypted<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Always Encrypted Lab<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Backup Encryption<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Backup Encryption Lab<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Connection Encryption<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Encryption Troubleshooting<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 2: Configure Data Access and Permissions<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Create and Maintain Users<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Create and Maintain Users Lab Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Create and Maintain Users Lab Part 2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Configure and Maintain Custom Roles<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Configure and Maintain Custom Roles Lab<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Manage Database Object Permissions Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Manage Database Object Permissions Part 2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Manage Database Object Permissions Lab Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Manage Database Object Permissions Lab Part 2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Configure User Options for Azure SQL Database<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Configure Row-Level Security<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Configure Dynamic Data Masking<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Configure Dynamic Data Masking Lab<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 3: Configure Auditing<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Manage a SQL Server Audit<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Manage a SQL Server Audit Lab<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Query the SQL Server Audit Log<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Manage an Azure SQL Server Audit<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 4: Develop a Backup Strategy<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Backup Types Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Backup Types Part 2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Manage, Backup, and Restore Databases Lab Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Manage, Backup, and Restore Databases Lab Part 2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Backup Very Large Databases Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Backup Very Large Databases Part 2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Backup Very Large Databases Part 3<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Backup Very Large Databases Part 4<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a04.9 Managing Very Large Databases Lab Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a04.10 Managing Very Large Databases Lab Part 2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a04.11 Managing Very Large Databases Lab Part 3<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Configure Alerting for Failed Backups<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Configure Alerting for Failed Backups Lab Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Configure Alerting for Failed Backups Lab Part 2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Back up Databases to Azure<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Manage Transaction Log Backups<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Configure Database Recovery Models<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Set Database Recovery Model Lab<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Configure Backup Automation<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Configure Backup Automation Lab<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 5: Restore Databases<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Perform Piecemeal Restores<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Restore Databases Lab Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Restore Databases Lab Part 2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Restore Databases Lab Part 3<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Perform Page Recovery<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Perform Point-in-Time Recovery<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Perform Point-in-Time Recovery Lab<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Restore File Groups<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Develop a Plan to Automate and Test Restores<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 6: Manage Database Integrity<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Implement Database Consistency Checks<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Implement Database Consistency Checks Lab<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Identify Database Corruption<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Recover From Database Corruption<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 7: Monitor Database Activity<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Monitor Current Sessions<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Monitor Current Sessions Lab<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Identify Sessions that Cause Blocking Activity<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Identify Sessions that Consume tempdb Resources<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Configure the Data Collector<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 8: Monitor Queries<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Manage the Query Store<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Manage the Query Store Lab<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Configure Extended Events and Trace Events<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Identify Problematic Execution Plans<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 9: Manage Indexes<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Identify and Repair Index Fragmentation<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Identify and Create Missing Indexes<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Identify and Drop Underutilized Indexes<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Manage Existing Columnstore Indexes Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Manage Existing Columnstore Indexes Part 2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Partitioned Tables<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 10: Monitor SQL Server Instances<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Create and Manage Operators<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Create and Manage SQL Agent Alerts<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Configure Policy-Based Management<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Configure Policy-Based Management Lab<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Identify Available Space on Data Volumes<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Identify the Cause of- Manage Performance Degradation<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Identify the Cause of- Manage Performance Degradation Lab Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Identify the Cause of- Manage Performance Degradation Lab Part 2<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 11: Implement Log Shipping<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Configure and Monitor Log Shipping<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Configure and Monitor Log Shipping Lab Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Configure and Monitor Log Shipping Lab Part 2<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 12: Implement Failover Cluster Instances<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Windows Server Failover Cluster<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Manage Shared Disks<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Configure Cluster Shared Volumes<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Configuring WSFC Lab<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 13: Implement Always On Availability Groups<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Database Mirroring<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Create an Availability Group<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Manage Failover<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Configure Read-Only Routing<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Create Distributed Availability Groups<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Configuring Always On Availability Group Lab Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Configuring Always On Availability Group Lab Part 2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Conclusion<\/li>\n<\/ul>\n<\/details>\n<\/div>\n<div>\n<h2 class=\"elementor-heading-title elementor-size-default\">Microsoft 70-467: Designing Business Intelligence Solutions with SQL Server 2012 Course Outline<\/h2>\n<details open=\"\">\n<summary>Module 1: Intro To Business Intelligence<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Introduction<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0The Business Intelligence Solution<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Overview Of Business Intelligence<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0BI And Power Pivot Demo<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0ETL Intro<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Designing Data Warehouses<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Design For Speed<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0BI Semantic Model<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 2: Database Essentials<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Basic Database Objects Demo<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Stored Procedures And Triggers Demo<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Database Clusters Demo<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0SQL Server Management<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Table Triggers<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0DB Config Options<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0DB Backup<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0DB Files And Restore<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 3: Business Intelligence Development<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Using SQL Server Data Tools Demo<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Building An IS Integration Services Package Demo<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Loading Data From Remote Sources Demo<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 4: Business Intelligence Results<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Report Building Intro Setup Demo<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Using Report Builder Demo<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Processing Data From Web Service Demo<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Reporting From Multiple Tables Demo<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Report Function And Matrix Demo<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Interactive Reports Demo<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Sorting Report Data Demo<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 5: Advanced Reporting And Development<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Drill Through Reports<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Data Visualization<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Creating Store Procedure From Scratch<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Memory Optimize Table<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 6: SQL Server Integration Services (SSIS)<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Building Our First Integration Project<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Data Transformation<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Introduction To Big Data<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Transformation Using Store Procedure<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Transformation Using SSIS<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Building Fact Table Using Store Procedure<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Building Fact Table Using SSIS<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 7: SQL Server 2014 New Features<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Backup Enhancements<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Index Enhancements<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Online DB Enhancements<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0BackUp To The Cloud<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Partition Data<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 8: Course Review And Exam Prep<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0BI Review<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0SharePoint Overview<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0SharePoint Demo<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Exam Prep<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Before You Take The Exam<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Conclusion<\/li>\n<\/ul>\n<\/details>\n<\/div>\n<div>\n<h2 class=\"elementor-heading-title elementor-size-default\">Microsoft 70-466: Implementing Data Models &amp; Reports with SQL Server 2012 Course Outline<\/h2>\n<details open=\"\">\n<summary>Module 1: Introduction To Business Intelligence And Data Modeling<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Introduction To Business Intelligence and Data Modeling Part1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Introduction To Business Intelligence and Data Modeling Part2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0The Microsoft Business Intelligence Platform Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0The Microsoft Business Intelligence Platform Part 2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0The Microsoft Business Intelligence Platform Part 3<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0The Microsoft Business Intelligence Platform Part 4<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 2: Implementing Reports The SQL Server Reporting Services<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Implementing Reports the SQL Server Reporting Services Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Implementing Reports the SQL Server Reporting Services Part 2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Implementing Reports the SQL Server Reporting Services Part 3<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Implementing Reports the SQL Server Reporting Services Part 4<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Implementing Reports the SQL Server Reporting Services Part 5<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Implementing Reports the SQL Server Reporting Services Part 6<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Implementing Reports the SQL Server Reporting Services Part 7<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Implementing Reports the SQL Server Reporting Services Part 8<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 3: Supporting Self Service Reporting<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Supporting Self Service Reporting Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Supporting Self Service Reporting Part 2<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 4: Managing Report Execution And Delivery<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Managing Report Execution And Delivery<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Managing Report Execution<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Subscriptions And Data Alerts<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 5: Creating Multidimensional Databases<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Creating Multidimensional Databases<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Creating Data Sources And Data Source Views<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Creating And Browsing a Cube<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 6: Working With Cubes And Dimensions<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Working with Cubes And Dimensions<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Sorting And Grouping Attributes<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 7: Working With Measures And Measure Groups<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Working With Measures and Measure Groups<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 8: Introduction To MDX<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Introduction To MDX<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Adding Calculations To A Cube<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 9: Customizing Cube Functionality<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Customizing Cube Functionality Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Customizing Cube Functionality Part 2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Customizing Cube Functionality Part 3<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 10: Implementing A Tabular Data Model<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Implementing A Tabular Data Model Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Implementing A Tabular Data Model Part 2<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 11: Introduction To DAX<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Introduction to DAX<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Demonstration Making A Tabular Model Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Demonstration Making A Tabular Model Part 2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Using DAX<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 12: Implementing An Analysis Services Tabular Data Model<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Implementing An Analysis Services Tabular Data Model Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Implementing An Analysis Services Tabular Data Model Part 2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Deploying A Tabular Data Model<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 13: SQL Analysis Services<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0SQL Analysis Services Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0SQL Analysis Services Part 2<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 14: Creating Data Visualizations With Power View<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Creating Data Visualizations With Power View<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 15: Supporting Self Service Reporting<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Supporting Self Service Reporting<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 16: Performing Predictive Analysis With Data Mining<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Performing Predictive Analysis With Data Mining<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Using The Data Mining Wizard<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 17: Predictive Analytics<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Predictive Analytics Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Predictive Analytics Part 2<\/li>\n<\/ul>\n<\/details>\n<\/div>\n<div>\n<h2 class=\"elementor-heading-title elementor-size-default\">Microsoft 70-465: Designing Database Solutions for Microsoft SQL Server 2012 Course Outline<\/h2>\n<details open=\"\">\n<summary>Module 1: Designing A Database Server Infrastructure<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Introduction<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Designing A Database Server Infrastructure-Part1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Designing A Database Server Infrastructure-Part2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Designing A Database Server Infrastructure-Part3<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Designing A Database Server Infrastructure-Part4<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Considerations For Database Server Consolidation<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Managing Server Resources<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 2: Designing A Logical Database Scheme<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Designing A Logical Database Scheme-Part1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Designing A Logical Database Scheme-Part2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Designing A Logical Database Scheme-Part3<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Designing A Logical Database Scheme-Part4<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Designing A Logical Database Scheme-Part5<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 3: Designing A Physical Database Implementation<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Designing A Physical Database Implementation-Part1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Designing A Physical Database Implementation-Part2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Designing A Physical Database Implementation-Part3<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 4: Incorporating Data Files Into the Database<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Incorporating Data Files Into The Database-Part1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Incorporating Data Files Into The Database-Part2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Incorporating Data Files Into The Database-Part3<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Incorporating Data Files Into The Database Demo<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Searching Data Files<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Searching Data Files Demo<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 5: Tuning Database Performance<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Tuning Database Performance-Part1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Tuning Database Performance-Part2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Tuning Database Performance-Part3<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Working With Query Plans-Part1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Working With Query Plans-Part2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Working With Query Plans-Part3<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Working With Query Plans-Part4<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 6: Designing Database Security<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Designing Database Security-Part1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Designing Database Security-Part2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Contained Databases<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Protecting Data With Encryption<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 7: Policy Based Management<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Policy Based Management<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Policy Based Management Demo<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 8: Monitoring Server Health<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Monitoring Server Health<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Monitoring Server Health Demo<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 9: Designing Database Backup Solution<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Designing Database Backup Solution-Part1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Designing Database Backup Solution-Part2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Designing Database Backup Solution-Part3<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Designing Database Backup Solution-Part4<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Disaster Recovery Plan-Part1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Disaster Recovery Plan-Part2<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 10: Automating Multi Server Maintenance<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Automating Multi Server Maintenance<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Managing Multiple Servers<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 11: Managing SQL Server With Windows Powershell<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Managing SQL Server WIth Windows Powershell<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Windows Powershell Lab<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 12: Replicating Data<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Replicating Data-Part1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Replicating Data-Part2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Replicating Data-Part3<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 13: Planning High Availability<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Planning High Availability-Part1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Planning High Availability-Part2<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 14: Review of SQL Statements<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Review Of SQL Statements-Part1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Review Of SQL Statements-Part2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Review Of SQL Statements-Part3<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 15: Eleven Rules of Database Design<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Eleven Rules Of Database Design<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Conclusion<\/li>\n<\/ul>\n<\/details>\n<\/div>\n<div>\n<h2 class=\"elementor-heading-title elementor-size-default\">Microsoft 70-464: Developing Microsoft SQL Server 2012 Databases Course Outline<\/h2>\n<details open=\"\">\n<summary>Module 1: SQL 2012 And The 464 Test<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Introduction<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Intro To SQL Server 2012-Part1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Intro To SQL Server 2012-Part2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Management Studio Demo-Part1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Management Studio Demo-Part2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Management Studio Demo-Part3<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Other SQL Server Tools<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 2: Working With Data Types<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Working With Data Types-Part1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Working With Data Types-Part2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Working With Data Types-Part3<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Other Data Types<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 3: Tables<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Tables<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Creating Tables<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 4: Data Constraints<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Data Constraints-Part1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Data Constraints-Part2<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 5: Planning In Indexing<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Planning In Indexing-Part1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Planning In Indexing-Part2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Planning In Indexing-Part3<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Planning In Indexing-Part4<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 6: Table Structures<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Table Structures<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Working With Clustered Indexes<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Clustered Indexes<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Designing Effective Clustered Indexes<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 7: Improving Performance with Non-Clustered Indexes<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Improving Performance With Non-Clustered Indexes-Part1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Improving Performance With Non-Clustered Indexes-Part2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Improving Performance With Non-Clustered Indexes-Part3<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 8: Using Indexes And Execution Plans<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Using Indexes<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Execution Plans-Part1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Execution Plans Demo<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Execution Plans-Part2<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 9: Working with Views<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Working With Views-Part1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Working With Views-Part2<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 10: Designing and Implementing Stored Procedures<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Designing And Implementing Stored Procedures-Part1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Designing And Implementing Stored Procedures-Part2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Designing And Implementing Stored Procedures-Part3<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 11: Merging Data and Passing Tables<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Merging Data And Passing Tables-Part1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Merging Data And Passing Tables-Part2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Merging Data And Passing Tables-Part3<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 12: Designing and Implementing User Functions<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Designing And Implementing User Functions<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 13: Creating Highly Concurrent SQL Server Applications<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Creating Highly Concurrent SQL Server Applications-Part1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Creating Highly Concurrent SQL Server Applications-Part2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Creating Highly Concurrent SQL Server Applications-Part3<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 14: Handling Errors in T-SQL<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Handling Error InT-SQL-Part1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Handling Error InT-SQL-Part2<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 15: Triggers<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Triggers<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 16: Implementing Managed Code<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Implementing Managed Code-Part1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Implementing Managed Code-Part2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Implementing Managed Code-Part3<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Implementing Managed Code-Part4<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 17: Storing XML in SQL<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Storing XML In SQL-Part1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Storing XML In SQL-Part2<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 18: Querying XML<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Querying XML-Part1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Querying XML-Part2<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 19: Working with the Spatial Data<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Working With Spatial Data-Part1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Working With Spatial Data-Part2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Working With Spatial Data-Part3<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Module 20: Working With Full-Text Indexes and Queries<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Working With Full-Text Indexes And Queries-Part1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Working With Full-Text Indexes And Queries-Part2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Working With Full-Text Indexes And Queries-Part3<\/li>\n<\/ul>\n<\/details>\n<\/div>\n<div>\n<h2 class=\"elementor-heading-title elementor-size-default\">Microsoft 70-463: Implementing a Data Warehouse with SQL Server 2012 Course Outline<\/h2>\n<details open=\"\">\n<summary>Lesson 1: Introduction to Data Warehouse<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Introduction<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Introduction To Data Warehouse-Part1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Introduction To Data Warehouse-Part2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Introduction To Data Warehouse-Part3<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Introduction To Data Warehouse-Part4<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Introduction To Data Warehouse-Part5<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Introduction To Data Warehouse-Part6<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Lesson 2: Creating Dimensions and Changing Granularity of Dimensions<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Creating Dimensions And Changing Granularity Of Dimensions-Part1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Creating Dimensions And Changing Granularity Of Dimensions-Part2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Creating Dimensions And Changing Granularity Of Dimensions-Part3<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Creating Dimensions And Changing Granularity Of Dimensions-Part4<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Creating Dimensions And Changing Granularity Of Dimensions-Part5<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Creating Dimensions And Changing Granularity Of Dimensions-Part6<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Lesson 3: Creating Fact Tables and ColumnStore Indexes<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Creating Fact Tables And Column Store Indexes-Part1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Creating Fact Tables And Column Store Indexes-Part2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Creating Fact Tables And Column Store Indexes-Part3<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Creating Fact Tables And Column Store Indexes-Part4<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Creating Fact Tables And Column Store Indexes-Part5<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Lesson 4: Implementing Data Warehouse in SQL Server 2012<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Implementing Data Warehouse-Part1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Implementing Data Warehouse-Part2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Implementing Data Warehouse-Part3<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Implementing Data Warehouse-Part4<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Lesson 5: Working with Integration Services<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Working With Integration Services-Part1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Working With Integration Services-Part2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Working With Integration Services-Part3<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Working With Integration Services-Part4<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Working With Integration Services-Part5<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Working With Integration Services-Part6<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Lesson 6: Managing Control Flow<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Managing Control Flow-Part1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Managing Control Flow-Part2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Managing Control Flow-Part3<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Managing Control Flow-Part4<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Managing Control Flow-Part5<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Lesson 7: Working with Dynamic Variables<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Working With Dynamic Variables-Part1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Working With Dynamic Variables-Part2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Working With Dynamic Variables-Part3<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Working With Dynamic Variables-Part4<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Working With Dynamic Variables-Part5<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Working With Dynamic Variables-Part6<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Working With Dynamic Variables-Part7<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Working With Dynamic Variables-Part8<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Lesson 8: Implementing Data Flow<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Implementing DataFlow-Part1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Implementing DataFlow-Part2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Implementing DataFlow-Part3<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Implementing DataFlow-Part4<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Implementing DataFlow-Part5<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Implementing DataFlow-Part6<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Implementing DataFlow-Part7<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Implementing DataFlow-Part8<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Lesson 9: Managing Data Flow<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Managing DataFlow-Part1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Managing DataFlow-Part2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Managing DataFlow-Part3<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Managing DataFlow-Part4<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Lesson 10: Managing SSIS Package Execution<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Managing SSIS Package Execution-Part1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Managing SSIS Package Execution-Part2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Managing SSIS Package Execution-Part3<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Managing SSIS Package Execution-Part4<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Managing SSIS Package Execution-Part5<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Managing SSIS Package Execution-Part6<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Lesson 11: Debugging and Troubleshooting<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Debugging And Troubleshooting-Part1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Debugging And Troubleshooting-Part2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Debugging And Troubleshooting-Part3<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Debugging And Troubleshooting-Part4<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Lesson 12: Deploying Packages<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Deploying Packages-Part1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Deploying Packages-Part2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Deploying Packages-Part3<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Lesson 13: Securing Packages and Databases<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Securing Packages And Databases-Part1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Securing Packages And Databases-Part2<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Lesson 14: Working with MDS and Windows<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Working With MDS And Windows Azure<\/li>\n<\/ul>\n<\/details>\n<\/div>\n<div>\n<h2 class=\"elementor-heading-title elementor-size-default\">Microsoft 70-461: Querying SQL Server 2012 Course Outline<\/h2>\n<details open=\"\">\n<summary>Lesson 1: Getting Started with SQL Server 2012<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Course Introduction<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Lesson 2: Working with T-SQL<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Creating Queries-Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Creating Queries-Part 2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Creating Queries-Part 3<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Creating Queries-Part 4<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Creating Queries-Part 5<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Constraints-Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Constraints-Part 2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Constraints-Part 3<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Constraints-Part 4<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Constraints-Part 5<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Lesson 3: Writing SELECT Queries<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Select Statement-Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Select Statement-Part 2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Select Statement-Part 3<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Select Statement-Part 4<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Lesson 4: Working with SQL Data Types<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Data Types-Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Data Types-Part 2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Data Types-Part 3<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Data Types-Part 4<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Data Types-Part 5<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Data Types-Part 6<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Data Types-Part 7<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Data Types-Part 8<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Data Types-Part 9<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Data Types-Part 10<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Lesson 5: Sorting and Filtering Data<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Sorting Results-Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Sorting Results-Part 2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Sorting Results-Part 3<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Sorting Results-Part 4<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Sorting Results-Part 5<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Sorting Results-Part 6<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Lesson 6: Querying Data from Multiple Tables<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Tables Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Tables Part 2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Tables Part 3<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Tables Part 4<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Tables Part 5<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Tables Part 6<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Lesson 7: Modifying Data<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Inserting Data-Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Inserting Data-Part 2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Inserting Data-Part 3<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Inserting Data-Part 4<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Inserting Data-Part 5<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Inserting Data-Part 6<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Lesson 8: Working with SQL Server Built-in Functions<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Functions<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Parse<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Logical Functions<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Group By<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Lesson 9: Programming in T-SQL<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Programming-Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Programming-Part 2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Programming-Part 3<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Programming-Part 4<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Programming-Part 5<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Programming-Part 6<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Lesson 10: Implementing Stored Procedures<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Storage Procedures-Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Storage Procedures-Part 2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Dynamic SQL-Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Dynamic SQL-Part 2<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Lesson 11: Working with Subqueries and Table Expressions<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Sub-Queries And Table Expressions-Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Sub-Queries And Table Expressions-Part 2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Sub-Queries And Table Expressions-Part 3<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Sub-Queries And Table Expressions-Part 4<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Lesson 12: Working with Set Operators, Conditional Operators, and Window Functions<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Set Operators-Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Set Operators-Part 2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Window Functions-Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Window Functions-Part 2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0User Defined Functions-Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0User Defined Functions-Part 2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Advanced Analytical Functions<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Lesson 13: Working with PIVOT, UNPIVOT, and Grouping Sets<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Pivot<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Grouping Sets<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Lesson 14: Managing Error Handling and Transactions<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Error Handling-Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Error Handling-Part 2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Manage Transactions-Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Manage Transactions-Part 2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Manage Transactions-Part 3<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Lesson 15: Querying SQL Server System<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0System Databases-Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0System Databases-Part 2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0System Databases-Part 3<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0System Databases-Part 4<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Lesson 16: Optimizing Query Performance<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Query Planning-Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Query Planning-Part 2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Index-Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Index-Part 2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Index-Part 3<\/li>\n<\/ul>\n<\/details>\n<\/div>\n<div>\n<h2 class=\"elementor-heading-title elementor-size-default\">Microsoft 70-462: Administering SQL Server 2012 Databases Course Outline<\/h2>\n<details open=\"\">\n<summary>Lesson 1: Identifying the SQL Server Platform<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Overview<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0DataStorage-Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0DataStorage-Part 2<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Lesson 2: Deploying SQL Server<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Install-Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Install-Part 2<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Lesson 3: Configuring SQL Server<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Configuring-Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Configuring-Part 2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Changing Memory-Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Changing Memory-Part 2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Email-Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Email-Part 2<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Lesson 4: Managing Databases in SQL Server 2012<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0User Databases-Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0User Databases-Part 2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0User Databases-Part 3<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0User Databases-Part 4<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0User Databases-Part 5<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Lesson 5: Managing SQL Server Security<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Setting Security-Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Setting Security-Part 2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Server Roles-Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Server Roles-Part 2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Setting Permissions-Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Setting Permissions-Part 2<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Lesson 6: Implementing Advanced Security Settings<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Querying Data From Multiple Tables-Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Querying Data From Multiple Tables-Part 2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Querying Data From Multiple Tables-Part 3<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Querying Data From Multiple Tables-Part 4<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Querying Data From Multiple Tables-Part 5<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Lesson 7: Applying Encryption and Compression<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Encrypting And Compressing-Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Encrypting And Compressing-Part 2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Encrypting And Compressing-Part 3<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Lesson 8: Working with Indexes and Log Files<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Functions-Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Functions-Part 2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Functions-Part 3<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Functions-Part 4<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Functions-Part 5<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Functions-Part 6<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Lesson 9: Working with Backup and Restore<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Managing Backups-Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Managing Backups-Part 2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Managing Backups-Part 3<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Managing Backups-Part 4<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Managing Backups-Part 5<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Managing Backups-Part 6<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Managing Backups-Part 7<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Lesson 10: Implementing High Availability<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Stored Procedures-Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Stored Procedures-Part 2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Stored Procedures-Part 3<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Stored Procedures-Part 4<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Lesson 11: Optimizing Server Performance<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Managing SQL Performance-Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Managing SQL Performance-Part 2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Managing SQL Performance-Part 3<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Managing SQL Performance-Part 4<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Managing SQL Performance-Part 5<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Managing SQL Performance-Part 6<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Managing SQL Performance-Part 7<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Lesson 12: Troubleshooting Issues and Recovering Databases<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Set Operators-Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Set Operators-Part 2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Set Operators-Part 3<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Set Operators-Part 4<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Set Operators-Part 5<\/li>\n<\/ul>\n<\/details>\n<details open=\"\">\n<summary>Lesson 13: Performing Advanced Database Management Tasks<\/summary>\n<ul class=\"video-list\">\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Managing Database Infrastructures-Part 1<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Managing Database Infrastructures-Part 2<\/li>\n<li><i class=\"fa fa-video\"><\/i>\u00a0\u00a0\u00a0Managing Database Infrastructures-Part 3<\/li>\n<\/ul>\n<\/details>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/section>\n<section class=\"elementor-section elementor-top-section elementor-element elementor-element-6db319d elementor-reverse-mobile elementor-section-stretched elementor-section-content-middle elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6db319d\" data-element_type=\"section\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;,&quot;stretch_section&quot;:&quot;section-stretched&quot;}\">\n<div class=\"elementor-container elementor-column-gap-no\">\n<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-b0fdc82\" data-id=\"b0fdc82\" data-element_type=\"column\">\n<div class=\"elementor-widget-wrap elementor-element-populated\">\n<div class=\"elementor-element elementor-element-ddd663c elementor-widget elementor-widget-image\" data-id=\"ddd663c\" data-element_type=\"widget\" data-widget_type=\"image.default\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/section>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div id=\"chat-widget-container\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p><strong>|\u00a0 Number of Courses: <\/strong>16<br \/>\n<strong>|\u00a0 Training Hours: <\/strong>188<br \/>\n<strong>|\u00a0 Videos: <\/strong>1010<br \/>\n<strong>|\u00a0 Topics: <\/strong>194<br \/>\n<strong>|\u00a0 Course Access:<\/strong> 12 Months Unlimited Access<br \/>\n<strong>|\u00a0 Study Method:<\/strong> Online Video Lessons<br \/>\n<strong>|\u00a0 Course Type:<\/strong> Multiple Certificate Bundle<br \/>\n<strong>|\u00a0 Award:<\/strong> Cyber Studies Institute<br \/>\n<b>|\u00a0 <\/b><b>International Exam:\u00a0<\/b>Yes (Various) (Not included in course fee)<\/p>\n","protected":false},"featured_media":1952,"comment_status":"open","ping_status":"closed","template":"","meta":[],"product_brand":[],"product_cat":[22,38,50,41,52,19,31],"product_tag":[],"class_list":{"0":"post-1950","1":"product","2":"type-product","3":"status-publish","4":"has-post-thumbnail","6":"product_cat-course-bundle","7":"product_cat-data-administration","8":"product_cat-exam_prep","9":"product_cat-it-developing-networking","10":"product_cat-microsoft","11":"product_cat-networking-software","12":"product_cat-development-programming","14":"first","15":"instock","16":"sale","17":"featured","18":"virtual","19":"purchasable","20":"product-type-simple","21":"customify-col"},"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/cyberstudiesinstitute.co.za\/index.php\/wp-json\/wp\/v2\/product\/1950","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cyberstudiesinstitute.co.za\/index.php\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/cyberstudiesinstitute.co.za\/index.php\/wp-json\/wp\/v2\/types\/product"}],"replies":[{"embeddable":true,"href":"https:\/\/cyberstudiesinstitute.co.za\/index.php\/wp-json\/wp\/v2\/comments?post=1950"}],"version-history":[{"count":6,"href":"https:\/\/cyberstudiesinstitute.co.za\/index.php\/wp-json\/wp\/v2\/product\/1950\/revisions"}],"predecessor-version":[{"id":2408,"href":"https:\/\/cyberstudiesinstitute.co.za\/index.php\/wp-json\/wp\/v2\/product\/1950\/revisions\/2408"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/cyberstudiesinstitute.co.za\/index.php\/wp-json\/wp\/v2\/media\/1952"}],"wp:attachment":[{"href":"https:\/\/cyberstudiesinstitute.co.za\/index.php\/wp-json\/wp\/v2\/media?parent=1950"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/cyberstudiesinstitute.co.za\/index.php\/wp-json\/wp\/v2\/product_brand?post=1950"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/cyberstudiesinstitute.co.za\/index.php\/wp-json\/wp\/v2\/product_cat?post=1950"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/cyberstudiesinstitute.co.za\/index.php\/wp-json\/wp\/v2\/product_tag?post=1950"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}