Join for Free

Python Exercises

C++ Exercises

Java Exercises

C Exercises

Python

HTML/CSS

JavaScript

SQL

C Programming

C++

Java

DSA

Explore Projects
Get started with projects and learn to build real-world applications
Create a new project
Start from a blank playground and build anything you want
GUIDED PROJECTS
View all
Simple Dice RollerBeginner
Build this classic game piece by piece by solving interactive problems
Rock, Paper, Scissors GameBeginner
Build this classic game piece by piece by solving interactive problems
Classic Snake GameBeginner
Build a classic Snake game with increasing difficulty levels
Temperature ForecasterIntermediate
Create an app to display daily temperatures using real web API data
AI Projects with PromptsIntermediate
Create an AI project using prompts and learn how to build with AI
Expense TrackerBeginner
Track your expenses and manage your budget effectively
COMMUNITY PROJECTS
Wall of Inspiration
Monthly Challenge

7-day free trial. Start Now!

Enroll for FREE
(You should have done this 2 weeks ago)

With this course, you will:

  • Learn SQL
  • Practice with coding exerises
  • Earn a professional certificate
Fi Coin

Average Salary (US)

$81,000

Fi Box

Prerequisites

None

Fi Coin

Average Salary (US)

$81,000

Fi Box

Prerequisites

None

7-day free trial. Start Now!

Enroll for FREE
(You should have done this 2 weeks ago)
Course Hero Image
Course

Learn SQL Basics

Learn SQL, a standard data management language to manage, manipulate, and analyze large datasets.

  • Level: Beginner

  • Duration: 1 month

  • Type: Interactive

  • Language: English

  • Practice Problems: 60+

  • message-question

    Quizzes: 30+

Course Content

Chapter 1:

Introduction to SQL

1.1Getting Started1.2SQL SELECT
Chapter 2:

Filter Records

2.1Filtering in SQL2.2SELECT WHERE2.3AND, OR, and NOT2.4IN and BETWEEN2.5LIKE2.6Wildcards2.7LIMIT2.8Recap: Filter Records
Chapter 3:

SQL Aggregate Functions

3.1SQL Aggregate Functions3.2MIN() and MAX()3.3COUNT()3.4SUM() and AVG()3.5Recap: SQL Aggregate Functions
Chapter 4:

Organize Records

4.1Organizing in SQL4.2ORDER BY4.3GROUP BY4.4HAVING4.5SQL CASE4.6Recap: Organize Records
Chapter 5:

SQL JOINs

5.1SQL JOINs5.2INNER JOIN5.3LEFT JOIN5.4RIGHT JOIN5.5FULL JOIN5.6Recap: SQL JOINs
Chapter 6:

Subquery

6.1Subquery6.2Recap: SQL Subquery
Chapter 7:

Insert, Update & Delete

7.1INSERT INTO7.2UPDATE7.3DELETE FROM7.4Recap: Insert, Update, and Delete
Chapter 8:

Working With Tables

8.1Working With Tables8.2CREATE TABLE8.3ALTER TABLE8.4DROP TABLE8.5Recap: Working With Tables
Chapter 9:

Constraints

9.1Constraints9.2NOT NULL Constraint9.3UNIQUE Constraint9.4PRIMARY KEY9.5FOREIGN KEY9.6Recap: Constraints
Chapter 10:

SQL Window Functions

10.1SQL Window Functions10.2Aggregate Window Functions10.3Ranking Window Functions10.4Analytic Window Functions10.5Recap: SQL Window Functions
Chapter 11:

Additional Topics

11.1SQL Views11.2SQL Commands11.3What's next?
SQL Certification

CERTIFICATE OF COMPLETION

This is to certify that

Jane Doe

has successfully completed the course

Learn SQL Basics

Date of Issue:

Certification Code:

SIGNATURE

Founder, Chief Executive Officer

Programiz

Get SQL certified

Get your skills verified with our certification.

Showcase your expertise on LinkedIn and stand out from the crowd. Impress your potential employers.

CERTIFICATE OF COMPLETION

This is to certify that

Jane Doe

has successfully completed the course

Learn SQL Basics

Date of Issue:

Certification Code:

SIGNATURE

Founder, Chief Executive Officer

Programiz

JOB OPPORTUNITYCOMING LATER THIS YEAR

Receive job opportunities from top companies

Upon completion of the learning path, you will receive job opportunities from top countries around the world.

Start this Course

Don't just read questions

Solve practice problems in real-time

Select people based on their country.

Consider the following table:

People

namecountry
Kylie MinogueAustralia
Sean BeanUK
Samuel L. JacksonUSA

Task: Retrieve the records of those people who live in the UK.

Expected Output

The output of the query will be:

namecountry
Sean BeanUK

Input
sensAI Explanationpowered by OpenAI

Apologies! Unable to fetch data at the moment. Please try again later.

Learn Python by Doing

Build hands-on projects that mirror real developer challenges. Apply what you learn immediately — so you can learn by doing, not just watching.

Hands on Learning
Smiling career coach at desk

Looking to break into tech?

Landing your first job is difficult - but you don't have to go at it by yourself.

Meet our career coaches who will help you craft your learning journey, master the right skills, and confidently launch your career in tech.

What our students say

Tanya Giterman
“I explored Programiz PRO and I instantly loved the way SQL was taught. I finished the course quickly and became a star in my bootcamp class. I also got a job because of Programiz PRO.”

Tanya GitermanUSA

What our students say

Tanya Giterman
“I explored Programiz PRO and I instantly loved the way SQL was taught. I finished the course quickly and became a star in my bootcamp class. I also got a job because of Programiz PRO.”

Tanya GitermanUSA

Astro Ben
“Programiz is an incredible learning tool. The assignments help me master each concept. I’ve recommended it to my wife and students. It's an invaluable resource for anyone looking to improve coding skills!”

Astro BenKenya

Elijah Oseni
“I appreciate how you guys simplified the explanations, went step by step through every concept, and didn't try to overcomplicate things. It is ideal for anyone who values a hands-on approach to learn coding.”

Elijah OseniUganda

Courses similar to this

Courses similar to this

Loading...Loading...

Join 1,000,000+ learners
turning skills into tech careers

Start your career in tech