Complete Database Mastery With Microsoft SQL Server & PLSQL
in Database Administration, Data Manag...About this course
Set up your learning environment and review foundational concepts for SQL Server and SQL across all levels.
Before We Begin
1 Parts
- 0:05 Hr
Global Implementations
5 Min
Prerequisites & Environment Setup
2 Parts
- 1:00 Hr
Microsoft SQL Server & PL/SQL Environment Setup Guide
15 Min
Prerequisites for Complete Database Mastery with Microsoft SQL Server & PL/SQL
45 Min
Chapter 1: RDBMS Fundamentals and SQL Basics
3 Parts
- 2:30 Hr
RDBMS Concepts
45 Min
Basic SQL Queries
60 Min
Exercise: Basic Query Practice
45 Min
Chapter 2: Table Design and Data Manipulation
3 Parts
- 2:30 Hr
Creating Tables
45 Min
Data Operations
60 Min
Exercise: Design a Normalized Relational Schema
45 Min
Chapter 3: Joins, Aggregates, and Views
3 Parts
- 2:45 Hr
Joins
60 Min
Aggregates and Views
60 Min
Exercise: Joins and Views Practice
45 Min
Assignment 1
2 Parts
- 0:45 Hr
Build a Retail Sales Reporting System
45 Min
Submit your Assignment here
Submit your Assignment here
Min Grade: 40
Chapter 4: Subqueries, Set Operations, and SQL Basics
3 Parts
- 2:45 Hr
Subqueries and Set Operations
60 Min
SQL Introduction
60 Min
Exercise: Subquery and SQL Practice
45 Min
Chapter 5: Complex Queries and Window Functions
3 Parts
- 2:45 Hr
Advanced Joins and CTEs
60 Min
Window Functions
60 Min
Exercise: Complex Query Practice
45 Min
Chapter 6: Stored Procedures and Temporary Tables
3 Parts
- 2:45 Hr
Stored Procedures
60 Min
Temporary Tables
60 Min
Exercise: Stored Procedure Practice
45 Min
Assignment 2
2 Parts
- 0:45 Hr
Automate Daily Reports with Reusable Logic
45 Min
Submit your Assignment here
Submit your Assignment here
Min Grade: 40
Chapter 7: Functions, Triggers, and SQL Programming
3 Parts
- 2:45 Hr
User-Defined Functions
60 Min
Triggers and SQL
60 Min
Exercise: Function and Trigger Practice
45 Min
Chapter 8: Dynamic SQL and Advanced SQL
3 Parts
- 3:00 Hr
Dynamic SQL
60 Min
Advanced SQL
60 Min
Exercise: Build a Dynamic Query for Filtering Data
60 Min
Chapter 9: Performance Tuning and Indexing
3 Parts
- 3:00 Hr
Query Optimization
60 Min
Advanced Indexing
60 Min
Exercise: Tuning and Indexing Practice
60 Min
Assignment 3
2 Parts
- 0:45 Hr
Secure a Multi-Department Data Warehouse
45 Min
Submit your Assignment here
Submit your Assignment here
Min Grade: 40
Chapter 10: Security and Transactions
3 Parts
- 2:45 Hr
Database Security
60 Min
Transactions and Locking
60 Min
Exercise: Implement a Safe Transaction Block
45 Min
Chapter 11: Data Warehousing and Integration
3 Parts
- 3:00 Hr
Data Warehouse Design
60 Min
BI and ML Integration
60 Min
Exercise: Connect and Visualize Data in Power BI
60 Min
Chapter 12: Scalability and High Availability
3 Parts
- 3:00 Hr
Table Partitioning
60 Min
High Availability
60 Min
Exercise: Partition a Large Table by Range
60 Min
Capstone Project 1
2 Parts
- 50:00 Hr
Secure Financial Transaction System
3000 Min
Submit Your Project here
Submit Your Project
Min Grade: 40
Capstone Project 2
2 Parts
- 50:00 Hr
Data Warehouse for Retail Analytics
3000 Min
Submit Your Project here
Submit Your Project
Min Grade: 40
No Reviews Yet