Microsoft SQL Server 2019 Administration
Microsoft SQL Server 2019 - Big Data
Microsoft SQL Server 2019 Analysis Services (SSAS)
Microsoft SQL Server 2019 - Querying SQL Server
Microsoft SQL Server 2019 - Introduction to Data Analysis
SQL Server 2019 Database Design
Microsoft SQL Server 2019 Administration
Microsoft SQL Server 2019 Administration
- Module 1: Installation
- Module 2: Data Storage
- Module 3: Data Recover
- Module 4: Monitoring
- Module 5: Security
- Module 6: Maintenance
Course Information
- Total Course Video Hours: 6 Hrs 24 Min
- Total Videos: 41
Microsoft SQL Server 2019 - Big Data
Microsoft SQL Server 2019 – Big Data
- Module 1: What are Big Data Clusters?
- Module 2: Big Data Cluster Architecture
- Module 3: Deployment of Big Data Clusters
- Module 4: Loading and Querying Data in Big Data Clusters
- Module 5: Working with Spark in Big Data Clusters
- Module 6: Machine Learning on Big Data Clusters
- Module 7: Create and Consume Big Data Cluster Apps
- Module 8: Maintenance of Big Data Clusters
Course Information
- Total Course Video Hours: 7 Hrs 6 Min
- Total Videos: 41
Microsoft SQL Server 2019 Analysis Services (SSAS)
Microsoft SQL Server 2019 Analysis Services (SSAS)
- Module 1 – Introduction to Business Intelligence and Data Modeling
- Module 2 – Multidimensional Databases
- Module 3 – Cubes and Dimensions
- Module 4 – Measures and Measure Groups
- Module 5 – Introduction to MDX
- Module 6 – Customizing Cube Functionality
- Module 7 – Tabular Data Models
- Module 8 – Data Analysis Expressions (DAX)
- Module 9 – Data Mining
Course Information
- Total Course Video Hours: 8 Hrs 56 Min
- Total Videos: 50
Microsoft SQL Server 2019 - Querying SQL Server
Microsoft SQL Server 2019 – Querying SQL Server
- Module 1 – Query Tools
- Module 2 – Introduction to T-SQL Querying
- Module 3 – Basic SELECT Queries
- Module 4 – Querying Multiple Tables
- Module 5 – Sorting and Filtering Data
- Module 6 – Working with SQL Server Data Types
- Module 7 – Using DML to Modify Data
- Module 8 – Using Built-In Functions
- Module 9 – Grouping and Aggregating Data
- Module 10 – Using Subqueries
- Module 11 – Using Table Expressions
- Module 12 – Using Set Operators
- Module 13 – Using Window Ranking, Offset, and Aggregate Functions
- Module 14 – Pivoting and Grouping Sets
- Module 15 – Implementing Error Handling
- Module 16 – Managing Transactions
Course Information
- Total Course Video Hours: 10 Hrs 5 Min
- Total Videos: 67
Microsoft SQL Server 2019 - Introduction to Data Analysis
Microsoft SQL Server 2019 – Introduction to Data Analysis
- Module 1 – Query Tools
- Module 2 – Introduction to T-SQL Querying
- Module 3 – Basic SELECT Queries
- Module 4 – Querying Multiple Tables
- Module 5 – Sorting and Filtering Data
- Module 6 – Introduction to Business Intelligence and Data Modeling
- Module 7 – Prepare Data
- Module 8 – Clean, Transform, and Load Data
- Module 9 – Design a Data Model
- Module 10 – Create Model Calculations using DAX
- Module 11 – Create Reports
- Module 12 – Create
- Module 13 – Create Paginated Reports
- Module 14 – Perform Advanced Analytics
- Module 15 – Create and Manage Workspaces
- Module 16 – Create Power App Visuals
- Module 17 – Analysis Services and Power BI
Course Information
- Total Course Video Hours: 13 Hrs 58 Min
- Total Videos: 77
SQL Server 2019 Database Design
SQL Server 2019 Database Design
- Module 1 – Designing and Building Tables
- Module 2 – Enforcing Data Integrity
- Module 3 – Indexing
- Module 4 – Stored Procedures, Functions, and Triggers
- Module 5 – Blob and Filestream Data
- Module 6 – Full-Text Search
- Module 7 – Azure vs On-Prem
Course Information
- Total Course Video Hours: 6 Hrs 22 Min
- Total Videos: 37
- SQL Admin Intro
- Installation
- Introduction to Data Storage with SQL Server
- Managing Storage for System Databases
- Managing Storage for User Databases
- Moving Database Files
- Intro to Data Recovery
- Understanding SQL Server Recovery Models
- Planning a Backup Strategy
- Backing up Databases and Transaction Logs
- Using SSMS For Backup
- Understanding the Restore Process
- How to Restore a Database
- Using SSMS For Restore
- T-SQL Backup and Restore
- Advanced Restore Scenarios
- Introduction to Transferring Data
- Importing and Exporting Table Data
- Copying or Moving a Database
- Introduction to Monitoring SQL Server
- Dynamic Management Views and Functions
- Server Reports
- System Performance Monitor
- Tracing SQL Server Workload Activity
- Extended Events
- Database Tuning Advisor
- Introduction to SQL Server Security
- Managing Server-Level Security
- Managing Database-Level Security
- Row Level Security (RLS) Using Policies
- Database Security Tools
- Contained Database
- Auditing Data Access in SQL Server
- Implementing Transparent Data Encryption
- Introduction to Maintenance
- Ensuring Database Integrity
- Maintaining Indexes
- Automating Routine Database Maintenance
- Automating SQL Server Management
- Monitoring SQL Server Errors
- Configuring Database Mai
- Total Course Video Hours: 6 Hrs 24 Min
- Total Videos: 41
- 1.1 Course Introduction
- 1.2 Module 1 Introduction
- 1.3 Introduction to Business Intelligence
- 1.4 The Microsoft Business Intelligence Platform
- 1.5 Exploring a Data Warehouse
- 1.6 Exploring a Data Model
- 2.1 Module 2 Introduction
- 2.2 Introduction to Multidimensional Analysis
- 2.3 Overview of Cube Security
- 2.4 Creating and Configuring a Cube
- 2.5 Data Sources
- 2.6 Data Source Views
- 2.7 Adding a Dimension to a Cube
- 3.1 Module 3 Introduction
- 3.2 Dimensions
- 3.3 Attribute Hierarchies and Relationships
- 3.4 Sorting and Grouping Attributes
- 3.5 Slowly Changing Dimensions
- 4.1 Module 4 Introduction
- 4.2 Measures
- 4.3 Measure Groups and Relationships
- 4.4 Measure Group Storage
- 5.1 Module 5 Introduction
- 5.2 MDX Fundamentals
- 5.3 Adding Calculations to a Cube
- 5.4 Querying a cube using MDX
- 6.1 Module 6 Introduction
- 6.2 Key Performance Indicators
- 6.3 Actions
- 6.4 Perspectives
- 6.5 Translations
- 7.1 Module 7 Introduction
- 7.2 Introduction to Tabular Data Models
- 7.3 Creating a Tabular Data Model
- 7.4 Configure Relationships and Attributes
- 7.5 Configuring Data Model for an Enterprise BI Solution
- 8.1 Module 8 Introduction
- 8.2 DAX Fundamentals
- 8.3 Calculated Columns
- 8.4 Relationships
- 8.5 Measures
- 8.6 Time Intelligence
- 8.7 KPI
- 8.8 Parent – Child Hierarchies
- 9.1 Module 9 Introduction
- 9.2 Overview of Data Mining
- 9.3 Custom Data Mining Solutions
- 9.4 Validating a Data Mining Model
- 9.5 Consuming a Data Mining Model
- 9.6 Course Wrap Up
- Total Course Video Hours: 8 Hrs 56 Min
- Total Videos: 50
- 1.1 Course Introduction
- 1.2 Module 1 Introduction
- 1.3 Intro to Management Studio
- 1.4 Intro to command-line query tools
- 2.1 Module 2 Introduction
- 2.2 Introducing T-SQL
- 2.3 Understanding Sets
- 2.4 Understanding the Logical Order of Operations in SELECT statements
- 3.1 Module 3 Introduction
- 3.2 Writing Simple SELECT Statements
- 3.3 Eliminate Duplicates with DISTINCT
- 3.4 Using Column and Table Aliases
- 3.5 Write Simple CASE Expressions
- 4.1 Module 4 Introduction
- 4.2 Understanding Joins
- 4.3 Querying with Inner Joins
- 4.4 Querying with Outer Joins
- 4.5 Querying with Cross Joins and Self Joins
- 5.1 Module 5 Introduction
- 5.2 Sorting Data
- 5.3 Filtering Data with Predicates
- 5.4 Filtering with the TOP and OFFSET-FETCH
- 5.5 Working with Unknown Values
- 6.1 Module 6 Introduction
- 6.2 Writing Queries that return Date and Time Data
- 6.3 Writing Queries that use Date and Time Functions
- 6.4 Writing Queries that return Character Data
- 6.5 Writing Queries that use Character Functions
- 7.1 Module 7 Introduction
- 7.2 Inserting Records with DML
- 7.3 Updating Records Using DML
- 7.4 Deleting Records Using DML
- 8.1 Module 8 Introduction
- 8.2 Writing Queries with Built-In Functions
- 8.3 Using Conversion Functions
- 8.4 Using Logical Functions
- 8.5 Using Functions to Work with NULL
- 9.1 Module 9 Introduction
- 9.2 Using Aggregate Functions
- 9.3 Using the GROUP BY Clause
- 9.4 Filtering Groups with HAVING
- 10.1 Module 10 Introduction
- 10.2 Writing Self-Contained Subqueries
- 10.3 Writing Correlated Subqueries
- 10.4 Using the EXISTS Predicate with Subqueries
- 11.1 Module 11 Introduction
- 11.2 Using Views
- 11.3 Using Inline Table-Valued Functions
- 11.4 Using Derived Tables
- 11.5 Using Common Table Expressions
- 12.1 Module 12 Introduction
- 12.2 Writing Queries with the UNION operator
- 12.3 Using EXCEPT and INTERSECT
- 12.4 Using APPLY
- 13.1 Module 13 Introduction
- 13.2 Creating Windows with OVER
- 13.3 Exploring Window Functions
- 14.1 Module 14 Introduction
- 14.2 Writing Queries with PIVOT and UNPIVOT
- 14.3 Working with Grouping Sets
- 15.1 Module Introduction
- 15.2 Implementing T-SQL error handling
- 15.3 Implementing structured exception handling
- 16.1 Module 16 Introduction
- 16.2 Transactions and the Database Engine
- 16.3 Controlling Transactions
- 16.4 Course Wrap Up
- Total Course Video Hours: 10 Hrs 5 Min
- Total Videos: 67
- 1.1 Course Introduction
- 1.2 Intro to Management Studio
- 1.3 Intro to command-line query tools
- 2.1 Introducing T-SQL
- 2.2 Understanding Sets
- 2.3 Understanding the Logical Order of Operations in SELECT statements
- 3.1 Writing Simple SELECT Statements
- 3.2 Eliminate Duplicates with DISTINCT
- 3.3 Using Column and Table Aliases
- 3.4 Write Simple CASE Expressions
- 4.1 Understanding Joins
- 4.2 Querying with Inner Joins
- 4.3 Querying with Outer Joins
- 4.4 Querying with Cross Joins and Self Joins
- 5.1 Sorting Data
- 5.2 Filtering Data with Predicates
- 5.3 Filtering with the TOP and OFFSET-FETCH
- 5.4 Working with Unknown Values
- 6.1 Introduction to Business Intelligence
- 6.2 The Microsoft Business Intelligence Platform
- 6.3 Exploring a Data Warehouse
- 6.4 Exploring a Data Model
- 7.1 Introduction to Power BI
- 7.2 Get data from various data sources
- 7.3 Preview source data
- 8.1 Data Transformation Intro
- 8.2 Transformation Example 1
- 8.3 Transformation Example 2
- 8.4 Transformation Example 3
- 8.5 Transformation Example 4
- 8.6 Transformation Example 5
- 8.7 Transformation Example 6
- 9.1 Introduction to Data Modeling
- 9.2 Model Relationships
- 9.3 Table Configuration
- 9.4 Model interface
- 9.5 Quick Measures
- 9.6 Many-to-many relationships
- 9.7 Row-level security
- 10.1 DAX context
- 10.2 Calculated Tables
- 10.3 Calculated Columns
- 10.4 Managing Date Tables
- 10.5 Measures
- 10.6 Filter Manipulation
- 10.7 Time Intelligence
- 11.1 Basic Report Creation
- 11.2 Example Page 1
- 11.3 Example Page 2
- 11.4 Example Page 3
- 11.5 Report Publishing
- 11.6 Enhancing Reports
- 11.7 Drill-Through Pages
- 11.8 Conditional Formatting
- 11.9 Buttons and Bookmarks
- 12.1 Dashboard Basics
- 12.2 Real Time Dashboards
- 12.3 Enhanced Dashboards
- 13.1 Introduction to Power BI Report Builder
- 13.2 Report Layouts
- 13.3 Report Data
- 13.4 Report Tables
- 14.1 Introduction to Advanced Analytics
- 14.2 Scatter Chart
- 14.3 Forecast
- 14.4 Decomposition Tree
- 14.5 Key Influencers
- 15.1 Introduction to Workspaces
- 15.2 Working with Workspaces and the Portal
- 16.1 Introduction to Power Apps Visual
- 16.2 Creating the App
- 16.3 Basic Power Apps Concepts
- 16.4 Refreshing the Report
- 17.1 Introduction to Analysis Services
- 17.2 Connecting with Multidimensional Models
- 17.3 Premium Workspaces and Analysis Services
- 17.4 Course Wrap Up
- Total Course Video Hours: 13 Hrs 58 Min
- Total Videos: 77
- Total Course Video Hours: 6 Hrs 22 Min
- Total Videos: 37