Sql For Newbies: Hands-On Sql With Industry Best Practices
Published 3/2025
MP4 | Video: h264, 1920×1080 | Audio: AAC, 44.1 KHz

Beginner-friendly guide to writing, optimizing, and mastering SQL step by step!

What you’ll learn

Real-World Application & Optimization – Master industry-proven practices to optimize queries, enhance performance, and handle heavy data pipelines efficiently.

Learn in a hands-on onboarding setting, as if we’re working side by side at the office, preparing you to manage upcoming requests.

Master the Fundamentals of SQL – Learn how to write basic SQL queries using SELECT, WHERE, CASE WHEN and ORDER BY to retrieve and filter data effectively.

Perform Data Aggregation & Analysis – Use SQL functions such as GROUP BY, HAVING, SUM(), COUNT(), and AVG() to summarize and analyze data.

Work with Multiple Tables & Optimize Queries – Understand different types of joins, use CTEs, and apply best practices for query optimization.

Requirements

No programming experience needed.

Description

Overview

Section 1: Welcome to SQL Land

Lecture 1 Introduction

Lecture 2 Lecture 2: What’s a Relational Database Anyway?

Lecture 3 Lecture 3: The SQL Toolbox

Section 2: Introduction to Basic Statements

Lecture 4 How To Use SELECT statement

Lecture 5 How To Use WHERE statement

Lecture 6 How To Use CASE WHEN statement

Lecture 7 How To Use ORDER BY statement

Section 3: Intro to Aggregations

Lecture 8 How To Use GROUP BY statement

Lecture 9 How To Use HAVING statement

Section 4: Joining Tables

Lecture 10 Type of Joins

Lecture 11 How To Use INNER JOIN

Lecture 12 How To Use LEFT JOIN

Lecture 13 How To Use RIGHT JOIN

Lecture 14 How To Use FULL OUTER JOIN

Section 5: Common Table Expressions (CTEs)

Lecture 15 Lecture: CTEs And How To Structure A Query

Section 6: Window Functions

Section 7: Building Efficient SQL Pipelines

This course is suitable for absolute beginners who want to learn SQL from scratch. It’s ideal for: Aspiring entry level data analysts, data scientists, or database administrators who want to build a foundation in SQL. Professionals in non-technical roles looking to work with data more effectively. Students or career changers exploring data-related fields.