The Ultimate Sql Bootcamp – Go Zero To Hero In Sql

The Ultimate Sql Bootcamp – Go Zero To Hero In Sql
Published 3/2025
MP4 | Video: h264, 1920×1080 | Audio: AAC, 44.1 KHz

Become an expert at SQL!

What you’ll learn

Use SQL to query a database

Be confident in putting SQL and PostgreSQL on your resume

Replicate real-world situations and query reports

Use SQL to perform data analysis

Learn to perform GROUP BY statements

Requirements

No prerequisites, you will learn everything from scratch

Description

Overview

Section 1: Introduction to SQL

Lecture 1 Data Types in SQL and MySQL

Lecture 2 SQL Commands and DML, DDL, DQL and DCL

Lecture 3 Practical Example and Summary

Section 2: Filtering and Sorting Data

Lecture 4 Filtering data using WHERE clause and logical operators

Lecture 5 Sorting data using ORDER BY clause

Lecture 6 Practical Examples for Filtering and Sorting

Section 3: Aggregate Function in MySQL

Lecture 7 Using aggregate functions (SUM, AVG, MIN, MAX, COUNT)

Lecture 8 Combining data from multiple tables using JOINs (INNER JOIN, OUTER JOIN, etc.

Lecture 9 Grouping data using GROUP BY clause and Filtering groups using HAVING clause

Lecture 10 Where and Having Clause in SQL with Examples

Lecture 11 Practical Examples with Summary

Section 4: SubQuery, Coalesce, Case/When in MySQL

Lecture 12 Introduction to SubQuery, Types, Syntax & Parameters, Operators

Lecture 13 MySQL SubQueries and Functions

Lecture 14 Syntax and Parameters of MySQL Functions

Lecture 15 My SQL SubQuery with Different Operators, Types Explanation with Examples

Lecture 16 Practical Examples with Summary

Section 5: DB Normalization, (OVER) Clause, (WITH) Clause in MySQL)

Lecture 17 DB Schema, Normalization in SQL, Types of Normal Forms

Lecture 18 Rank Functions & Syntax

Lecture 19 Practical Usage of Rank Functions, OVER and WITH Clause

Section 6: SQL for Data Science

Lecture 20 SQL for Data Science

Section 7: SQL for Data Analytics

Lecture 21 SQL for Data Analytics

Anyone interested in learning more about SQL, PostgreSQL, or SQL for data analysis and data science!