Home Courses Instructor Labs

Beginners Data Analysis Bootcamp with SQL

(34 Ratings) 2497 Students Enrolled
Created By Jerry Ahern Last Updated Tue, 17-Mar-2020 English
  • Course Duration
    4 Hours
  • Mode of Training
    Self-Paced
  • Lessons
    68 Lessons
  • Validity
    Life Time
$ 129.99 $ 9.99 92% off 100% Money Back Guarantee
12k+ satisfied learners Read Reviews
What Will I Learn?
  • Understand the foundation of Data Analysis and explain the key areas such as Databases, Modelling, Visualization and insight.
  • Learn how to write SQL queries from simple to complex in a production environment
  • Learn how to understand and create data models in relational database environment
  • Create data visualization for professional projects
  • Learn to use MySQL database to interact with data and gain insight

Requirements
  • Basic SQL knowledge (optional)
+ View More
Description

In this course, you will be learning the four building blocks of Data Analysis such as Databases, Data Modelling, SQL and Data Modelling in a structured and detailed manner.

Initially, we will be learning about the databases and DBMS with the focus on data accessibility. In this courses we use SQL databases for practice. In this course, we will be deeply learning about the foundation of Data Modelling for relational DBMS. Then we will be learning SQL from writing simple scripts to advanced analytical functions to gain insight.

Finally, we will be focusing on data visualization and with the Tableau Software as our data visualization tool we showcase our story telling skills.

This course is for someone who is interested to learn Data Analysis with the learning of four key areas database, data modelling, sql and data visualization. and for developers who want to learn SQL and Data Modelling for their current projects.


Curriculum For This Course
68 Lessons 4 Hours
  • Learning Road Map 00:01:10 Preview
  • Why take this course? 00:00:43 Preview
  • What are Database ? 00:04:07 Preview
  • What is Database Management System ? 00:04:27
  • Introduction to MYSQL database 00:01:16
  • Installing MYSQL on Windows 00:04:00
  • Installing MYSQL on MAC OS 00:03:55
  • Installing MYSQL ON AWS Cloud 00:05:58
  • MYSQL Workbench Introduction 00:03:19
  • Creating the Sample Database 00:04:21
  • Introduction 00:02:23 Preview
  • Building Blocks 00:02:38
  • Table Structures 00:02:22
  • Data Types 00:02:25
  • Data Modeling Notations 00:01:29
  • One to One Relationships 00:03:14
  • One to Many Relationships 00:02:09
  • Many to Many Relationships 00:01:31
  • Recursive Relationships 00:01:35
  • What is Normalization ? 00:01:25
  • First Normal Form 00:02:12
  • Second Normal Form 00:02:39
  • Third Normal Form 00:02:01
  • Introduction 00:01:09 Preview
  • SQL Command Classification 00:01:14
  • Data Definition Language (DDL) 00:05:05
  • Data Query Language (DQL) Part1 00:04:57
  • Data Query Language (DQL) Part2 00:05:12
  • Data Manipulation Language (DML) 00:04:24
  • INNER Join 00:07:37
  • LEFT Join 00:04:04
  • RIGHT Join 00:01:01
  • CROSS Join 00:02:28
  • SELF Join 00:03:18
  • Union 00:03:24
  • INTERSECTION 00:03:05
  • MINUS 00:00:57
  • Introduction 00:01:00
  • Aggregate Functions 00:02:02
  • GROUP BY (Part 1) 00:03:20
  • GROUP BY (Part2) 00:01:37
  • Introduction (Diagram) 00:01:12
  • Correlated Subquery 00:02:23
  • Non Correlated Subquery 00:02:10
  • String Functions Introduction 00:00:41
  • String Functions Part1 00:03:30
  • String Functions Part2 00:03:15
  • String Functions Part3 00:04:53
  • Numeric Functions 00:03:02
  • Date Functions Introduction 00:02:16
  • Date Functions Part1 00:06:43
  • Date Functions Part2 00:05:54
  • Introduction to Conditional Statement 00:03:17
  • Introduction to Window Functions 00:01:37
  • Window Functions Components 00:02:16
  • Aggregate Functions Part1 00:05:57
  • Aggregate Functions Part2 00:07:42
  • Positional Functions 00:02:27
  • Rank Functions 00:06:15
  • Introduction 00:01:47
  • Types of Data 00:02:18
  • Visualization Categories 00:01:15
  • Installing Tableau with Data 00:04:02
  • Bar Chart 00:07:48
  • Line Chart 00:03:20
  • Histogram 00:05:58
  • Scatter Plot 00:04:54
  • Pie Chart 00:02:32

Beginners Data Analysis Bootcamp with SQL