Beginners Data Analysis Bootcamp With Sql

  1. Home
  2. Database-management
  3. Beginners Data Analysis Bootcamp With Sql

Tags: Database Management , Data Modeling

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

Last updated 2022-01-10 | 4.2

- Understand the foundation of data analysis and explain the key areas of database
- modeling
- visualization and insight.
- Be able to understand and create data models in relational database environment
- Be able to write simple to complex SQL queries in a production environment

What you'll learn

Understand the foundation of data analysis and explain the key areas of database
modeling
visualization and insight.
Be able to understand and create data models in relational database environment
Be able to write simple to complex SQL queries in a production environment
Create compelling data visualizations for professional projects
Be able to use MYSQL database to interact with data and gain insight

* Requirements

* No previous programming language experience is required.
* You will need a working computer with any operating system installed on it (Windows
* Mac or Linux).
* You don't need to buy any additional software we will install MYSQL and Tableau software which will be free of cost.

Description

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.

In my 20 years of consulting experience nearly all IT project have elements of data analysis that is needed where basic SQL and data visualization skills are needed to produce key insights. This course will give you the necessary foundations needed to perform data analysis in your project.

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

Who this course is for:

  • Anyone interested in learning data analysis from ground up using the four keys areas that is database , data modeling , data insight and data visualization for their current or future job needs.
  • Anyone looking to switch careers to focus more on data related jobs
  • Developers who want to learn SQL and Data modeling for their current projects
  • Business analysts who want to better understand their data requirements for key applications
  • Students who want to learn new skills for academic purposes
  • Anyone curious to learn about data and be able to tell a story and gain insight

Course content

12 sections • 80 lectures

Introduction 4 lectures

Introduction Preview 02:41

Instructor Background Preview 00:29

Learning Road Map Preview 01:10

Why take this course? Preview 00:43

Getting Started - Overview and Installation 9 lectures

What are Database ? Preview 04:07

What is Database Management System (DBMS) ? Preview 03:31

Introduction to MYSQL database Preview 01:15

Installing MYSQL on Windows Preview 03:59

Installing MYSQL on MAC OS Preview 03:54

Installing MYSQL ON AWS Cloud Preview 05:58

MYSQL Workbench Introduction Preview 03:19

Creating the Sample Database Preview 04:21

DBMS

This quiz will be based on the information you have learnt about DBMS and MYSQL

Data Modeling 14 lectures

Introduction Preview 02:22

Building Blocks Preview 02:37

Table Structures Preview 02:22

Data Types Preview 02:24

Data Modeling Notations Preview 01:29

One to One Relationships Preview 03:13

One to Many Relationships Preview 02:08

Many to Many Relationships Preview 01:30

Recursive Relationships Preview 01:35

What is Normalization ? Preview 01:25

First Normal Form Preview 02:11

Second Normal Form Preview 02:39

Third Normal Form Preview 02:00

Data Modeling

Structured Query Language (SQL) 7 lectures

Introduction Preview 01:08

SQL Command Classification Preview 01:13

Data Definition Language (DDL) Preview 05:05

Data Query Language (DQL) Part1 Preview 04:57

Data Query Language (DQL) Part2 Preview 05:12

Data Manipulation Language (DML) Preview 04:23

SQL

This quiz will test your basic understanding of SQL.

Table Joins 6 lectures

INNER Join Preview 07:36

LEFT Join Preview 04:03

RIGHT Join Preview 01:00

CROSS Join Preview 02:27

SELF Join Preview 03:17

Table Joins Quiz

The quiz will test your knowledge about the different types of table joins.

SET Operators 4 lectures

Union Preview 03:24

INTERSECTION Preview 03:04

MINUS Preview 00:56

Set Operators

Test your knowledge about the Set operators used in SQL

Summary & Grouping of Data 5 lectures

Introduction Preview 01:00

Aggregate Functions Preview 02:01

GROUP BY (Part 1) Preview 03:20

GROUP BY (Part2) Preview 01:37

Summary & Grouping of Data

Test your knowledge about GROUP BY Clause

SubQueries 4 lectures

Introduction (Diagram) Preview 01:11

Correlated Subquery Preview 02:22

Non Correlated Subquery Preview 02:09

SubQueries

Will test your knowledge about the different types of subqueries.

Functions 9 lectures

String Functions Introduction Preview 00:40

String Functions Part1 Preview 03:30

String Functions Part2 Preview 03:14

String Functions Part3 Preview 04:52

Numeric Functions Preview 03:02

Date Functions Introduction Preview 02:15

Date Functions Part1 Preview 06:42

Date Functions Part2 Preview 05:54

Functions

Test your knowledge about numeric, date and string functions

Conditional Logic 1 lectures

Introduction to Conditional Statement Preview 03:16

Analytical Window Functions 7 lectures

Introduction to Window Functions Preview 01:36

Window Functions Components Preview 02:15

Aggregate Functions Part1 Preview 05:57

Aggregate Functions Part2 Preview 07:41

Positional Functions Preview 02:26

Rank Functions Preview 06:15

Analytical Window Functions

Test your knowledge of the analytical functions in SQL

Data Visualization 10 lectures

Introduction Preview 01:47

Types of Data Preview 02:17

Visualization Categories Preview 01:14

Installing Tableau with Data Preview 04:02

Bar Chart Preview 07:47

Line Chart Preview 03:20

Histogram Preview 05:58

Scatter Plot Preview 04:53

Pie Chart Preview 02:32

Data Visualization

Test your knowledge about different data visualizations that can be used.