Master Data Analytics in SQL & Excel by Great Learning
Learn data analysis with Excel, data preparation, advanced querying, PivotTables, and Explanatory Data Analysis that equips you to solve real-world business challenges.
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
12 Topics
Introduction to Excel
Excel Navigation
Rows Columns & Cells
Basic Math with Excel
Boolean Operations
Cell Referencing
Information Functions
Counting
Filtering & Sorting
Finding & Searching Text
Joining Text
Quiz to test your understanding of excel fundamentals
8 Topics
Basics of Date and Time
Finding Difference Between Dates
Advanced Text Operations
Conditional Operations
Aggregation
Conditional Aggregation
Indexing & Matching
Data handling quiz to test your understanding
7 Topics
Data Cleaning using Functions
Conditional Formatting
Data Validation
Lookup Functions in Excel
Pivot Tables
Data Visualization using Excel
Quiz to test your understanding of Data Cleaning and Analysis
11 Topics
Introduction to Exploratory Data Analysis with Excel
Problem Statement
Data Understanding
Questions & Hypothesis
Data Cleaning & Manipulation
Univariate Analysis
Exploratory Data Analysis- Hands-on- Part 1
Exploratory Data Analysis- Hands-on- Part 2
Exploratory Data Analysis- Hands-on- Part 3
Quick peek into the final insights
Quiz to test your understanding
Master Data Analytics in SQL & Excel
Related SQL Courses
Thank You!
Your review has been submitted successfully.