Course Content
Introduction: How to Become a Data Analyst
How to Become a Data Analyst
0/1
Introduction to Basic Data Analysis
06:52
Installing MySQL and create a database for Windows, MacOS, and Linux
How to Installing MySQL and create a database.
0/1
How to Install MySQL and create a database
12:04
SELECT Statement and Where Clause in MySQL
Starting your Data Analysis Properly
0/2
SELECT Statement in MySQL
11:00
Where Clause
12:27
LIMIT` + ALIASING` Group by+ Order By, Having Vs Where in MySQL
LIMIT` + ALIASING`
0/3
Group by+ Order By
10:46
Having Vs Where in MySQL
03:46
LIMIT` + ALIASING`
00:00
JOINS
Joins in MySQL
0/1
JOINS
00:00
Unions in MySQL
Unions in MySQL
0/1
Unions in MySQL
00:00
string functions
string functions
0/3
string functions
00:00
Case Statement
00:00
Subqueries
00:00
Window functions in MySQL
Window functions:- in MySQL
0/1
Window functions:- in MySQL
00:00
Common Table Expressions (CTEs) in MySQL and Temp Tables
Common Table Expressions (CTEs) in MySQL
0/2
Common Table Expressions (CTEs) in MySQL
00:00
Temp Tables
00:00
stored procedures
stored procedures.
0/1
stored procedures.
00:00
Triggers and Events in MySQL
Triggers and Events
0/1
Triggers and Events in MySQL
00:00
Data Cleaning in MySQL
Data Cleaning in MySQL
0/1
Data Cleaning in MySQL
00:00
MSQL EXPLORATORY DATA ANALYSIS
MSQL EXPLORATORY DATA ANALYSIS
0/1
MSQL EXPLORATORY DATA ANALYSIS
00:00
Data Analysis (Excel)
PVT
0/7
Pivot Tables in Excell
00:00
Formulas
00:00
XLOOKUP
00:00
Conditional Formulating
00:00
Charts
00:00
Data Cleaning
00:00
Full Projects with Excel
00:00
Data Analysis (Tableau)
Data Analysis (Tableau)
0/5
Installation
00:00
Calculated Fields
00:00
Visualization
00:00
Joins
00:00
Full Projects
00:00
Data Analysis (Power BI)
Power BI
0/8
Installation
00:00
Power Query
00:00
Manage Relationships
00:00
Drill Down
00:00
Conditional Formatting
00:00
Bins and List
00:00
Visualization
00:00
Full Project
00:00
Data Analysis (Python)
Python
0/15
Installing Jupyter Notebooks
00:00
Variables
00:00
Data Types
00:00
Operators
00:00
If/Else Statements
00:00
For Loops
00:00
While Loops
00:00
Functions
00:00
Converting Data Types
00:00
Building a BMI Calculator
00:00
Automated File Sorter
00:00
Inspecting Web Pages
00:00
Beautifulsoup + Requests
00:00
Find and Find All
00:00
Scraping Data
00:00
Data Analysis (Python Pandas)
Python Pandas
0/8
Reading in Files with Pandas
00:00
Filtering and Ordering
00:00
Indexes
00:00
Group by + Aggregate Functions
00:00
Merging Data Frames
00:00
Creating Visualizations in Pandas
00:00
Data Cleaning
00:00
EDA
00:00
Amazon Web Scrapping Using Python
Amazon Web Scrapping
0/3
Amazon Web Scrapping Using Python
00:00
Automating Crypto API Pull Using Python
00:00
Building a Portfolio Website
00:00
Data Analyst Resume
Data Analyst Resume
0/1
Data Analyst Resume
00:00
Solving SQL Interview Question
Solving SQL Interview Question
0/4
Solving Easy SQL Interview Questions
00:00
Solving SQL Medium Interview Question
00:00
Solving Hard SQL Interview Question
00:00
Solving Very hard SQL Interview Question
00:00
Azure Account Set-Up
Azure Account Set-Up
0/4
Azure Account Set-Up
00:00
Storage Accounts
00:00
SQL Database
00:00
Azure Data Factory
00:00
Amazon web service setup
Amazon web service setup
0/5
Set-up
00:00
S3 BUCKETS
00:00
Amazon Athena
00:00
Glue and Databrew
00:00
Quicksight
00:00
How To Download Your Data Analyst Bootcamp Certification (Congrats!!)
How To Download Your Data Analyst Bootcamp Certification (Congrats!!)
0/1
How To Download Your Data Analyst Bootcamp Certification (Congrats!!)
00:00
Guide to Data Analysis for Beginners
Pause
Play
% buffered
00:00
11:05
Unmute
Mute
Disable captions
Enable captions
Settings
Captions
Disabled
Quality
undefined
Speed
Normal
Captions
Go back to previous menu
Quality
Go back to previous menu
Speed
Go back to previous menu
0.5×
0.75×
Normal
1.25×
1.5×
1.75×
2×
PIP
Exit fullscreen
Enter fullscreen
Play