cookies-icon

Our website uses cookies. By using this website, you agree to their use in accordance with the browser settings. You can modify your browser settings on your own. For more information see our Privacy Policy.

Course

Basic

SQL Basics

Start here if you’re new to SQL. Learn the basics of SQL, retrieve data from an SQL database and build simple reports.

Table of contents

12 free interactive coding challenges

Lifetime access

B042DDD8-A1C9-4053-8AF3-463EB31543B8@2x

limited to this course only

$39

Buy now

Want a better deal?

B042DDD8-A1C9-4053-8AF3-463EB31543B8@2x

Get unlimited lifetime access to all 66 present and future courses

Save $450

Unlimited lifetime access

B042DDD8-A1C9-4053-8AF3-463EB31543B8@2x

to all 66 present and future courses

$149

$599

75% OFF

Buy now
Details
129

Interactive exercises

10 h

Estimated time

333874

Users enrolled

☆☆☆☆☆
★★★★★

22185 ratings

Databases are part of our everyday life, and being able to communicate with them is essential. This course will teach you the basics of SQL, a powerful query language that lets you work with many types of data.

The SQL Basics course starts with simple queries performed on a single table. These exercises will show you how to retrieve exactly what you need. Next, you’ll start working with multiple tables. You will find out about the subtle differences between various joining methods, including INNER JOIN, LEFT JOIN, RIGHT JOIN, and OUTER JOIN.

Cover image for the SQL course for beginners

As you go deeper into the course, you’ll master using the GROUP BY function to create simple reports. You’ll also start investigating subqueries. Finally, you can test your knowledge (and earn your certificate!) in a comprehensive quiz.

Looking to get started in SQL? Give this course a try – the fascinating world of SQL queries is only a click away!

What Do You Need to Take This Course?

Just a web browser and an Internet connection

This Course Will Teach You How To:

  • Retrieve information from a database
  • Build basic reports from scratch
  • Write complex WHERE conditions, using logical operators like AND, OR, and NOT
  • Understand the LIKE, ILIKE, IN, and BETWEEN operators
  • Work with multiple tables
  • Use INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL OUTER JOIN
  • Create simple reports using GROUP BY and aggregate functions
  • Write subqueries and complex instructions
  • Understand SQL set operations: UNION, INTERSECT, and EXCEPT
 

Plus, you’ll get to practice your skills on over 129 interactive exercises.

Who Should Take This Course?

  • Anyone who wants to learn SQL
  • Analysts who use relational databases
  • Students taking courses in relational databases
  • Beginning programmers
  • Business database users who want to improve their skills

Table of contents

Free

Paid content

0%

Course progress

0/129

Exercises completed

1.

A little bit on databases

Find out what relational databases are and get to know SQL – a language to talk to databases.

0/6

Introduction

2.

Selecting from one table

Discover how to select data from a single table.

0/22

See the whole table

Select some columns

Filtering rows

Logic

Text patterns

To be or NULL to be

A little bit of mathematics

Let's practice

3.

Querying more than one table

Learn how to select data from multiple tables.

0/13

How to query more than one table

Creating JOINs

Referencing columns

Let's practice

4.

Aggregation and grouping

Computations in SQL? Why not? You will learn how to group rows and compute statistics with aggregate functions.

0/23

Ordering

Eliminating duplicate results

Aggregation

Grouping

HAVING: filtering and ordering groups

Let's practice

5.

More on JOINs

Learn about various kinds of JOINs to best suit your needs.

0/22

Get to know the data

JOIN revisited

LEFT JOIN

RIGHT JOIN

FULL JOIN

OUTER JOINS

NATURAL JOIN

Aliases for tables

6.

Subqueries

Queries within queries? That's right! Discover how to build and use subqueries.

0/22

Introduction

Very simple subqueries

Subqueries with multiple results

Correlated subqueries

Other subqueries

7.

Set operations

Combine query results using set operations like UNION, INTERSECT or MINUS.

0/12

Introduction

UNION

INTERSECT

EXCEPT

8.

Quiz

Check your SQL skills.

0/9

Quiz

Reviews (54)

Average rating

4.82/5

☆☆☆☆☆
★★★★★

22185 ratings

Details

5 stars

86%

4 stars

12%

3 stars

2%

2 stars

0%

1 stars

0%