Beginners Data Analysis Bootcamp with SQL 2020
4.1 (81 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
393 students enrolled

Beginners Data Analysis Bootcamp with SQL 2020

Learn the four key pillars of Data Analysis: Databases , Data Modeling , SQL and Data Visualization.
4.1 (81 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
393 students enrolled
Created by Adnan Shaikh
Last updated 5/2020
English
English [Auto-generated]
Current price: $72.99 Original price: $104.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 3.5 hours on-demand video
  • 32 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
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.

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
Expand all 70 lectures 03:38:12
+ Getting Started - Overview and Installation
8 lectures 30:24
Installing MYSQL on Windows
03:59
Installing MYSQL on MAC OS
03:54
Installing MYSQL ON AWS Cloud
05:58
MYSQL Workbench Introduction
03:19
Creating the Sample Database
04:21

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

DBMS
11 questions
+ Data Modeling
13 lectures 27:55
Introduction
02:22
Building Blocks
02:37
Table Structures
02:22
Data Types
02:24
Data Modeling Notations
01:29
One to One Relationships
03:13
One to Many Relationships
02:08
Many to Many Relationships
01:30
Recursive Relationships
01:35
What is Normalization ?
01:25
First Normal Form
02:11
Second Normal Form
02:39
Third Normal Form
02:00
Data Modeling
16 questions
+ Structured Query Language (SQL)
6 lectures 21:58
Introduction
01:08
SQL Command Classification
01:13
Data Definition Language (DDL)
05:05
Data Query Language (DQL) Part1
04:57
Data Query Language (DQL) Part2
05:12
Data Manipulation Language (DML)
04:23

This quiz will test your basic understanding of SQL.

SQL
15 questions
+ Table Joins
5 lectures 18:23
INNER Join
07:36
LEFT Join
04:03
RIGHT Join
01:00
CROSS Join
02:27
SELF Join
03:17

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

Table Joins Quiz
5 questions
+ SET Operators
3 lectures 07:24
Union
03:24
INTERSECTION
03:04
MINUS
00:56

Test your knowledge about the Set operators used in SQL

Set Operators
5 questions
+ Summary & Grouping of Data
4 lectures 07:58
Introduction
01:00
Aggregate Functions
02:01
GROUP BY (Part 1)
03:20
GROUP BY (Part2)
01:37

Test your knowledge about GROUP BY Clause

Summary & Grouping of Data
6 questions
+ SubQueries
3 lectures 05:42
Introduction (Diagram)
01:11
Correlated Subquery
02:22
Non Correlated Subquery
02:09

Will test your knowledge about the different types of subqueries.

SubQueries
3 questions
+ Functions
8 lectures 30:09
String Functions Introduction
00:40
String Functions Part1
03:30
String Functions Part2
03:14
String Functions Part3
04:52
Numeric Functions
03:02
Date Functions Introduction
02:15
Date Functions Part1
06:42
Date Functions Part2
05:54

Test your knowledge about numeric, date and string functions

Functions
10 questions
+ Conditional Logic
1 lecture 03:16
Introduction to Conditional Statement
03:16