Skills you will learn!
Curriculum

2 Topics
Introduction to Data Analytics
Phases of Data Analytics Project

16 Topics
Introduction to Databases and DBMS
Types of DBMS
More on DBMS
Keys in RDBMS
Types of Commands in SQL - DDL and DML
Types of Commands - Demonstration
More SQL Commands
Filtering and Operators - Demonstration
Operators and Pattern Matching - Demonstration
Group By Having and Order By Clause
Aggregate Functions - Demonstration
Normalization in RDBMS
Coding Exercise on Filtering and Operators - Beginner
Coding Exercise on Operators and Pattern Matching - Beginner
Coding Exercise on Aggregate Functions - Beginner
Quiz to test your understanding of SQL Basics

10 Topics
Alias and Joins in SQL
Joins Demonstration
Subquery in SQL
Subqueries - Demonstration
Window Functions Concepts
Window Functions Hands-on
Coding Exercise on SQL Joins - Beginner
Coding Exercise on SQL - Beginner
Coding Exercise on SQL - Advanced
Quiz to test your understanding of SQL Advance concepts

5 Topics
Case Study Introduction
Business Context and Problem Definition
How to approach the solution?
SQL Workbench Data Understanding
SQL Workbench Data Preprocessing

  Write a Review

Master Data Analytics in SQL

Go to Paid Course