Data Analysis with SQL Online Course

Data Analysis with SQL Online Course

SQL is a popular language for extracting, stacking, and querying data from databases. Master SQL to explore, filter, and aggregate almost any raw data into multiple dimensions of valuable input. Level 1 teaches SQL from scratch to let you understand SQL and data analysis and is designed to jumpstart your knowledge of SQL and perform various data analysis tasks. You will learn SQL terminologies, databases, and syntax. You will create and load databases, schemas and tables, analyze data using filtering conditions and search patterns, count distinct values across dataset attributes, group rows, calculate using aggregation functions, and use aliases for columns and tables. Level 2 directly continues from topics explored in Level 1. It covers more advanced SQL tools and capabilities. You will combine data from multiple sources, break complex queries into subqueries, transform and classify data, analyze data with window functions, create views and CTEs, and explore SQL to the core. You will work on quizzes and exercises to practice and sharpen your understanding of the learning objectives. Upon completion, you will comprehensively acquire knowledge about SQL syntax, queries and subqueries, perform data analysis tasks independently, and garner thorough understanding of SQL, and use it in your data visualization and analysis. 

Who should take this course?

This course is ideal for aspiring data analysts, business analysts, database professionals, and anyone who wants to leverage SQL for extracting insights from data. It’s also suited for students, beginners in analytics, and professionals seeking to strengthen their data querying and analysis skills for decision-making.

What you will learn

• Understand SQL terminology and create databases
• Learn to write and practice SQL syntax step by step
• Create and load data into databases, schemas, and tables
• Analyze data using various filtering conditions and search patterns
• Conduct data transformation processes using CASE statements
• Combine data from multiple tables and filter data using subqueries

Course Outline

Course Introduction

• Introduction

Getting Started!

• Welcome to Level 1!
• Our Learning Objectives
• DB Installation

Databases - Terminology

• Overview - Database, DBMS, SQL
• Tables, Columns, Rows
• Primary and Foreign Keys
• Relational Model, ER Diagram
• Schema, Metadata, Data Dictionary
• Null Values
• Indexes
• Partitions

SQL - Creating Databases, Schemas, and Tables

• Overview
• Creating - Database and Schema
• Creating Tables - Introduction
• Creating Tables - Constraints
• Inserting Data
• Update and Delete

SQL - Retrieving Data with Queries

• Overview
• Query Data (SELECT)
• Filtering Conditions (WHERE) – Part 1
• Filtering Conditions (WHERE) – Part 2
• Alias for Tables and Columns
• Searching Patterns (Wildcards)
• Distinct Values (DISTINCT)
• Sorting Rows (ORDER BY)
• Grouping Rows (GROUP BY and HAVING)
• Data-Type Conversions (CAST)
• Database Dictionary

Course Summary – Level 1

• Let's Recap!

Introduction to Level 2

• Introduction

Getting Started with Level 2

• Welcome to Level 2!
• Our Learning Objectives
• Loading the Books Datasets
• Loading the eCommerce Datasets

SQL - Combining Data from Multiple Tables

• Overview
• Union, Intersect, Except
• Cross-Join
• Inner-Join
• Outer-Join

SQL – Subqueries

• Overview
• What Is Subquery?
• Conditional Logic – Single Row
• Conditional Logic – Multiple Rows
• As Inline Views (FROM)

SQL - Conditional Logic (CASE)

• Overview
• Simple CASE - Data Transformation
• Searched CASE – Classification and Binning

SQL - Window Functions

• Overview
• Creating a Window Function
• Sequential Numbers
• Ranking

SQL – Simplify Queries (Views, CTEs)

• Overview
• Virtual Tables (Views)
• Common Table Expressions (CTEs)

Course Summary – Level 2

• Let's Recap