Master Data Analytics in SQL by Great Learning
Unlock the power of SQL with this data analytics course! Dive into database essentials, explore advanced SQL techniques, and gain hands-on experience by solving real world problems.
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
Master Data Analytics in SQL
Related SQL Courses
Thank You!
Your review has been submitted successfully.