Microsoft SQL Server 2019 - Introduction to Data Analysis
Microsoft SQL Server 2019 - Querying SQL Server
Microsoft SQL Server 2019 Administration
Microsoft SQL Server 2019 Analysis Services (SSAS)
SQL Server 2019 Database Design
Microsoft SQL Server 2019 - Big Data
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
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 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 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
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
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