Beginners Data Analysis Bootcamp with SQL

Learn the four key pillars of Data Analysis:  Databases , Data Modeling , SQL and Data Visualization.

This course will teach you the four building blocks of data analysis in a very structured way.

* We will first learn about databases and database management systems with the focus of data accessibility. Our preferred DBMS will be MYSQL.

* We will then learn the foundation of Data modeling for relational DBMS and gain knowledge about how data is related and how the design of data models help in capturing business use cases.

* We will take a deep dive in learning SQL; from writing simple scripts to advance analytical functions to gain insight.

* The last section will focus on data visualization and we will use Tableau software as our data visualization tool with many examples to showcase our story telling skills.

By taking this course you will gain experience in designing data solutions which will make you more marketable and competitive in the job market.

I will try my best to keep this course up to date by adding more relevant lectures and lab exercises.

• Course Introduction
• Introduction to Databases
• MYSQL Windows Install
• MYSQL Macos Install
• MYSQL Cloud Install
• MYSQL GUI INTRO
• Create Database and Load Data
• Introduction to Data Modeling Part1
• Introduction to Data Modeling Part2
• Introduction to SQL
• DDL
• DML
• DQL1
• DQL2
• Inner Join
• Left Join
• Right Join
• Cross Join
• Self Join
• Intersect
• Minus
• Union
• Introduction to Aggregate Functions
• Groupby Part1
• Groupby Part2
• Introduction to Subqueries
• Date Functions Introduction
• Date Functions Part1
• Date Functions Part2
• Numeric Functions
• Introduction to String Functions
• Conditional Statements
• Introduction to Window Functions
• Window Aggregate Function Part1
• Window Aggregate Function Part2
• Window Ranking Function
• Window Positional Function
• Introduction to Data Visualization
• Tableau Software and Datasets
• BAR Chart Visualization
• Line Charts
• Histogram
• Scatter Plot
• PIE Chart