Data Analysis using 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.

IMPORTANT INFORMATION

We are holding 3 months training on Data Analytics at Tekskillup.

🔍 Dive into Python, SQL, Excel, and the Basics of Power BI with expert instructors guiding you every step of the way.

Physical Location: Enugu

Virtual: Anywhere

Start Date: June 17, 2024

Click here to register: https://tekskillup.com/data-analysis-training-enugu-virtual

Our Instructors are: Chris Awoke & Ifiok Akpan.

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

Course Introduction

Course Introduction

14:52
Overview of Data Analysis

07:13
Overview of Databases

08:49
Tools used by Data Analysts

04:27
Downloadable Files and Important Notes

00:00
Downloading and Installing pgAdmin

06:03
Restoring dvdrental.tar file to pgAdmin

05:45
Restoring CSV datasets to PgAdmin

14:02

Week 2: SQL Statement Fundamentals

Utility File Not Found Resolved!

06:59
SELECT Statement

08:32
SELECT Challenge

05:08
SELECT DISTINCT Statement

04:55
COUNT

06:15
SELECT WHERE Clause – Part 1

05:25
SELECT WHERE Clause – Part 2

06:46
SELECT WHERE Challenge

05:43
ORDER BY Clause

06:36
LIMIT Clause

05:49
BETWEEN Operator

08:45
IN Operator

10:35
LIKE and ILIKE Operator

09:24
Week 2 Quiz

About Course

IMPORTANT INFORMATION

Our Instructors are: Chris Awoke & Ifiok Akpan.

What Will You Learn?

Course Content

Course Introduction

Course Introduction

Overview of Data Analysis

Overview of Databases

Tools used by Data Analysts

Downloadable Files and Important Notes

Downloading and Installing pgAdmin

Restoring dvdrental.tar file to pgAdmin

Restoring CSV datasets to PgAdmin

Week 2: SQL Statement Fundamentals

Utility File Not Found Resolved!

SELECT Statement

SELECT Challenge

SELECT DISTINCT Statement

COUNT

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

Week 2 Quiz

Week 3: GROUP BY Statement

Introduction to GROUP BY Clause

Aggregate Functions

GROUP BY – Part 1

GROUP BY – Part 2

HAVING Clause

GROUP BY Quiz

Assignment on GROUP BY Clause

Solution to Assignment on GROUP BY

Solution to Assignment on HAVING Clause

Week 4: Assessment 1

Assessment Test 1

Solution to Assessment Test 1

Assessment Test 2

Assessment Test 2 Walkthrough

Week 5: Advanced SQL Commands

Working with Timestamps

Timestamp and Extract – Part 2

Mathematical Functions and Operators

String Functions and Operators

Subqueries

Week 6: JOINS

Introduction to JOINS

AS Statement

INNER JOINS – Part 1

INNER JOINs – Part 2

FULL OUTER Joins

Left & Right Outer Joins

UNION Operator

Week 7: Assessment 2

Read Me First

Setting up New Database for New Exercise

Assessment Test 2

Week 8: Final Exams

Final Exams

Project 1

Project Guidelines

ChatGPT – Application to Data Analysis (SQL)

Course Introduction

Downloading Dataset from Kaggle

Converting CSV to SQL

Using Code Interpreter for Data Analysis (Project Based)

Creating Databases and Tables in SQL

Creating Database and Table

SQL Constraints

Using pgAdmin to create Databases & Tables

Foreign Keys in SQL

PostgreSQL with Python

Overview of Python and PostgreSQL

Installing Anaconda and using Jupyter Notebook

Connecting PostgreSQL to Python