Course description

Ch 1️⃣ - Basics ============== 00:00 - Welcome 03:43 - What is SQL 10:44 - Intro to Course 16:51 - The Basics 33:58 - Comparisons 41:16 - Practice Problem 1 45:21 - Wildcards 48:47 - Alias: AS 51:04 - Practice Problem 2 53:58 - Operations 59:34 - Aggregation 1:06:25 - Practice Problem 3 1:08:42 - NULL Values Skipped - Practice Problem 4 1:10:03 - JOINS 1:20:11 - Order of Execution 1:22:31 - Practice Problem 5 Ch 2️⃣ - Advanced ============== 1:26:14 - Setup PostgreSQL 1:32:43 - IDE Install: VS Code 1:44:03 - Data Types 1:47:29 - Manipulate Tables 1:59:54 - Database Load 2:09:55 - Date Functions 2:20:18 - Problem Problem 6 2:24:54 - CASE Expression 2:30:16 - SubQueries and CTEs 2:42:12 - Practice Problem 7 2:50:02 - UNION Operators 2:54:19 - Practice Problem 8 Ch 3️⃣ - Project ============== 2:58:01 - About the Project 3:02:07 - Create the Repository 3:14:39 - Query 1 - Top Paying Jobs 3:20:31 - Query 2 - Top Paying Job's Skills 3:27:59 - Query 3 - In-Demand Skills 3:34:02 - Query 4 - Top Paying Skills 3:41:25 - Query 5 - Most Optimal Skills 3:53:01 - Share on GitHub 4:05:03 - Share on LinkedIn


What will i learn?

Requirements

  • None

Zversity Team

We are the Zversity Team.

Our goal is to help people with a free platform to learn online. Come and learn on Zversity. We do not charge a fee or anything here. This is a free university made for us all. Happy learning!

Free

Lectures

1

Skill level

Beginner

Expiry period

Lifetime

Certificate

Yes

Related courses