Data Analysis using SQL

Categories: Data Analysis, SQL

About Course

This course will make you SQL query expert it’s a Data Analysis (SQL focused) and, You’ll learn the skills you need to retrieve insightful data from a database. There are many test your self quizzes distributed over the course with detailed solutions so you to practice more and more . After completing this course and all of it’s quizzes and the Final exam, you will be comfortable with using SQL & PostgreSQL in data analysis and data science by SQL Challenges and Final Exam and more.

Use SQL to insert data into a table.
Use SQL to Query & retrieve data from databases.
Use SQL to Sort records after retrieving from databases.
Use SQL to Group data by specific conditions.
Use SQL to Filter data by using where clause.
How & when to use Joins types in SQL.
How to create and deal with Sub-queries in SQL.
How to create and deal with common table expression in SQL.
Use SQL to perform data analysis of real world databases

Course Content

Introduction

Course Introduction

06:14
Overview of Data Analysis

07:14
Overview of Databases

08:49
Tools used by Data Analysts

04:28
Downloadable Files and Important Notes

00:00
Downloading and Installing pgAdmin

14:57
Loading Data (dvdrental.tar) to pgAdmin

05:45
Utility File not Found Resolved

06:58

SQL Statement Fundamentals

SELECT Statement

08:32
SELECT Statement Challenge

05:09
SELECT DISTINCT Clause

04:55
COUNT Function

06:15
SELECT WHERE Clause – Part 1

05:26
SELECT WHERE Clause – Part 2

06:46
SELECT WHERE Challenge

05:43
ORDER BY Clause

06:36
LIMIT Clause

05:49
BETWEEN Operator

08:44
IN Operator

10:36
LIKE and ILIKE Operator

09:24

GROUPBY Statement

Assessment 1

JOINS

Advanced SQL Commands

Assessment 2

Student Ratings & Reviews

No Review Yet

Data Analysis using SQL

About Course

Related

What Will You Learn?

Course Content

Introduction

Course Introduction

Overview of Data Analysis

Overview of Databases

Tools used by Data Analysts

Downloadable Files and Important Notes

Downloading and Installing pgAdmin

Loading Data (dvdrental.tar) to pgAdmin

Utility File not Found Resolved

SQL Statement Fundamentals

SELECT Statement

SELECT Statement Challenge

SELECT DISTINCT Clause

COUNT Function

SELECT WHERE Clause – Part 1

SELECT WHERE Clause – Part 2

SELECT WHERE Challenge

ORDER BY Clause

LIMIT Clause

BETWEEN Operator

IN Operator

LIKE and ILIKE Operator

GROUPBY Statement

Assessment 1

JOINS

Advanced SQL Commands

Assessment 2

Services

Company

We accept all major credit cards for fast and easy payment

Let's Connect

Contact us

Quick Links