What you will learn

Using SQL SELECT to retrieve table columns

Filtering data using WHERE clause

Summarizing data with MAX, MIN, SUM

Returning unique values with SQL SELECT

Combining conditions with AND, OR, NOT

Sorting results by multiple columns

Sorting data with ORDER BY clause

Using aggregate functions like AVG, COUNT

Filtering for NULL and value ranges

Course content

This course is perfect for beginners ready to explore the world of SQL. Whether you're just starting out in database management or aiming to use SQL for your application development projects,…

This course is perfect for beginners ready to explore the world of SQL. Whether you're just starting out in database management or aiming to use SQL for your application development projects, this course covers the essentials. You'll quickly learn how to leverage the full potential of SQL, from querying and managing data to seamlessly integrating it into real-world applications. By the end of the course, you'll have the confidence and skills to solve practical problems with SQL and enhance your development process.

Retrieving Individual Columns

Retrieving Multiple Columns

Retrieving All Columns

Retrieving Distinct Rows

Limiting Results

Challenge: Find the Population of the Countries

Challenge: Find All Countries

Challenge: Find All Countries With Their IDs

Challenge: Find Country Capitals

Challenge: Find the Regions in Which All Countries Are Located

Sorting Data

Challenge: Population Sort

Sorting by Multiple Columns

Challenge: Dual-Sort Query

Specifying Sort Direction

Challenge: Sort the Countries by Region and Capital

Challenge: Sort Capitals in Descending Order

Challenge: Sort Countries in Ascending Order

Challenge: Find Countries, Their IDs, and Their Populations

Challenge: Find Countries, IDs, Populations, Regions, and Sort Them

Challenge: Find All Continents and Sort Them in Ascending Order

Using the WHERE Clause

Challenge: North America Population Sort

The WHERE Clause Operators

Challenge: Population Threshold Query

Checking for a Range of Values

Checking for NO Value

Using the AND Operator

Challenge: Europe Region Sort

Using the OR operator

Challenge: America Regions Filter

Using the NOT Operator

Challenge: Non-Europe Capitals Sort

The AVG() Function

Challenge: Surface Area Selection

The COUNT() Function

Challenge: Continental Count

The MAX() Function

The MIN() Function

Challenge: Large Surface Area Average

The SUM() Function

Boost your Tech Skills!

with up to 55% off

What you'll get with our subscription:

500+ Top-Rated coursesCompletion certificatesPersonalized study tracks40+ hands-on real-world projects

Your subscription also includes 500+ courses:

TEST E2E PROGRESS SQL

Description

test sql course e2e new task ui

TEST SQL COURSE E2E

This course is for you if you are new to SQL, you want to quickly learn how to get the most out of SQL and you want to learn how to use SQL in your own application development.

Introduction to SQL

Explore the essentials of SQL — from querying data to integrating it into real-world applications. Whether you're just starting out in database management or aiming to use SQL for your application development projects, this course covers the essentials. You'll quickly learn how to leverage the full potential of SQL, from querying and managing data to seamlessly integrating it into real-world applications. By the end of the course, you'll have the confidence and skills to solve practical problems with SQL and enhance your development process.

Intermediate SQL

This course is perfect for those who already have a basic understanding of SQL and want to delve into more advanced concepts to craft more powerful queries. Throughout the course, you will become familiar with data grouping and filtering grouped data. You will also learn how to work with multiple tables simultaneously, including how to combine them. Additionally, you will explore different types of table joins and how to apply them in practice.

Introduction to SQL

This course offers an easy-to-follow introduction to the basics of SQL databases and the Structured Query Language (SQL). Through engaging video lessons and thoughtfully crafted exercises, you’ll explore essential concepts step by step. Each topic is explained in detail and paired with hands-on practice to ensure you not only understand but also retain what you’ve learned.

QNA TEST COURSE

TEST QNA COURSE FOR TESTING CHAT IMPROVEMENTS

TEST E2E PROGRESS SQL

Description

test sql course e2e new task ui

TEST SQL COURSE E2E

This course is for you if you are new to SQL, you want to quickly learn how to get the most out of SQL and you want to learn how to use SQL in your own application development.

Introduction to SQL

Explore the essentials of SQL — from querying data to integrating it into real-world applications. Whether you're just starting out in database management or aiming to use SQL for your application development projects, this course covers the essentials. You'll quickly learn how to leverage the full potential of SQL, from querying and managing data to seamlessly integrating it into real-world applications. By the end of the course, you'll have the confidence and skills to solve practical problems with SQL and enhance your development process.

Intermediate SQL

This course is perfect for those who already have a basic understanding of SQL and want to delve into more advanced concepts to craft more powerful queries. Throughout the course, you will become familiar with data grouping and filtering grouped data. You will also learn how to work with multiple tables simultaneously, including how to combine them. Additionally, you will explore different types of table joins and how to apply them in practice.

Introduction to SQL

This course offers an easy-to-follow introduction to the basics of SQL databases and the Structured Query Language (SQL). Through engaging video lessons and thoughtfully crafted exercises, you’ll explore essential concepts step by step. Each topic is explained in detail and paired with hands-on practice to ensure you not only understand but also retain what you’ve learned.

QNA TEST COURSE

TEST QNA COURSE FOR TESTING CHAT IMPROVEMENTS

Why People Choose Codefinity

Web Developer

Kwizera Mugisha

The teaching methodology at Codefinity is excellent, and I particularly appreciate how it has prepared me to handle real-world coding problems. Currently, I am delving into Node.js and eagerly anticipate building full-stack projects that integrate all the knowledge I have gained.

Senior Business Analyst

Sherry Barnes-Fox

My first course was 4 hours, I did it in a few days, "nugget-style". The instructions are very clear and easy to understand. There is even a hint to help you get the answer. I love the learning style that is used, it engages me.

Accounts Payable Specialist

Bill Wagner

I have really liked the browser-based lessons that allow me to code within the lesson. The RUN button allows me to test the code I write before submitting for a grade.

IT Support Specialist

Daniel Chinea

I have gained a lot of practical and logical thinking skills, along with patience for myself and confidence in myself that I can learn programming. Years ago, I would have never thought that I could learn programming in any way, shape or form, and I was able to obtain these certifications and skills with Codefinity.

Technology Project Manager

Steve Bruening

The learning was progressive and made it easy to follow along and make progress. I could feel my skills increasing and building on each other as the course went along.

Project Manager

Stephanie Chan

As I went through the first course of the Python track, I liked the way the course was lay out (in easy and digestible modules) with little exercises at the end of each concept.

Step-by-Step to Stellar Results

Solve Real‑World Coding Tasks

Interactive coding environment

Jump into our interactive environment: write and run your code with real‑time feedback and success metrics—learn by doing at every step.

Get On‑Demand Guidance

AI‑powered support

Leverage the built‑in AI assistant to explain errors, suggest fixes, or answer any question about your code—so you stay productive and never get stuck.

Lock In Your Learning

Knowledge check

Wrap up each module with a quick quiz that delivers instant feedback, tracks your progress, and ensures you’ve mastered key concepts.

Show Off Your Skills

Celebrate success

Earn your industry‑recognized certificate upon completion and share it on LinkedIn with one click—let your network see what you can do.

Full catalog access

One subscription opens up this course and our entire catalog of projects and skills.

Features:

500+ Top-Rated coursesCutting-edge AI Copilot

Personalized study tracks40+ hands-on real-world projects

Without cancellation, before the selected discounted intro plan ends, I accept that Codefinity will automatically charge $79 every 3 months until I cancel. Learn more about cancellation and refund policy in Subscription Terms.

Try Codefinity with confidence – 30-day money-back guarantee included

To welcome you to Codefinity, we're offering up to 64% off on our courses. Plus, we have a 30-day money-back guarantee, so you can try us out risk-free.We truly look forward to welcoming you to our platform and are committed to making your learning experience easy, interactive, and fun.

Frequently Asked Questions

How do I get access to the platform?

While you can study with Codefinity on any device, we strongly recommend using a computer or laptop to optimize your learning experience.

What if I have questions while learning?

All our courses feature an integrated AI assistant, ready to assist you with any questions you may have during your studies and help you solve any problems.

Is a tech degree necessary for learning?

No, you don't need any previous experience to start learning. Our courses are designed for beginners, so you can easily start your journey in the tech industry

Still have questions?

Write your question here

Introduction to SQL

Course for Beginner Level

What you will learn

Course content

Your subscription also includes 500+ courses:

TEST E2E PROGRESS SQL

test sql course e2e new task ui

TEST SQL COURSE E2E

Introduction to SQL

Intermediate SQL

Introduction to SQL

QNA TEST COURSE

TEST E2E PROGRESS SQL

test sql course e2e new task ui

TEST SQL COURSE E2E

Introduction to SQL

Intermediate SQL

Introduction to SQL

QNA TEST COURSE

Why People Choose Codefinity

Step-by-Step to Stellar Results

Trusted by Employees of Leading Companies
and Students from Top Universities

Instantly access 500+ courses

Full catalog access

Try Codefinity with confidence – 30-day money-back guarantee included

Frequently Asked Questions

Still have questions?

Introduction to SQL

Course for Beginner Level

What you will learn

Course content

Your subscription also includes 500+ courses:

TEST E2E PROGRESS SQL

test sql course e2e new task ui

TEST SQL COURSE E2E

Introduction to SQL

Intermediate SQL

Introduction to SQL

QNA TEST COURSE

TEST E2E PROGRESS SQL

test sql course e2e new task ui

TEST SQL COURSE E2E

Introduction to SQL

Intermediate SQL

Introduction to SQL

QNA TEST COURSE

Why People Choose Codefinity

Step-by-Step to Stellar Results

Trusted by Employees of Leading Companies and Students from Top Universities

Instantly access 500+ courses

Full catalog access

Try Codefinity with confidence – 30-day money-back guarantee included

Frequently Asked Questions

Still have questions?

Trusted by Employees of Leading Companies
and Students from Top Universities