On February 28 at 1:00 PM UTC the platform will be unavailable for a few minutes due to planned maintenance break.

Description

These days, relational databases are an essential part of virtually every application. Whether you chat with your friends, browse your bank account history or look for an interesting book in an e-store – you can be almost sure that the information you get comes from a database of one kind or another. In this course, you will learn SQL – a powerful query language used for communication with relational databases. More precisely, you will find out how to retrieve data from a database in various situations.

 

We will start off with simple queries for single tables and you will get to know how to retrieve exactly what you need. We'll then go on to work with multiple tables and join their contents together. You will also master creating simple reports using GROUP BY and aggregation. You will find out about the subtle changes between various joining methods: INNER JOIN, LEFT JOIN, RIGHT JOIN and OUTER JOIN. We'll also introduce subqueries in our course. Finally, you'll have a chance to test your knowledge in a comprehensive quiz.

Does this sound like the right type of course for you? Give it a try – the fascinating world of SQL queries is just a click away!

What are the requirements?

Just a web browser

What am I going to get from this course?

  • complete over 100 interactive exercises in 7 course parts
  • learn SQL basics and basic SQL syntax
  • create SQL queries
  • write simple one-table queries
  • write complex WHERE conditions, using logical operators like AND, OR, NOT
  • get to know operators LIKE, ILIKE, IN, BETWEEN
  • work with multiple tables
  • use INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN
  • create simple reports with GROUP BY and aggregate functions
  • create complex instructions with subqueries
  • apply set operations: unions, intersections and differences

Who is the target audience?

  • Students taking courses in relation databases
  • Analysts dealing with relational databases
  • Beginner developers
  • Hobbyist programmers
  • Anyone who wants to review their SQL knowledge.

Table of contents

A little bit on databases

A little bit on databases

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

0% completed (6 of exercises done)

More Less
Try for free
Selecting from one table

Selecting from one table

Discover how to select data from a single table.

0% completed (22 of exercises done)

More Less
Try for free

See the whole table

A little bit of mathematics

Querying more than one table

Querying more than one table

Learn how to select data from multiple tables.

0% completed (13 of exercises done)

More Less
Try for free
Aggregation and grouping

Aggregation and grouping

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

0% completed (23 of exercises done)

More Less
Buy this course

HAVING: filtering and ordering groups

More on JOINs

More on JOINs

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

0% completed (22 of exercises done)

More Less
Buy this course
Subqueries

Subqueries

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

0% completed (22 of exercises done)

More Less
Buy this course
Set operations

Set operations

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

0% completed (12 of exercises done)

More Less
Buy this course
Quiz

Quiz

Check your SQL skills.

0% completed (9 of exercises done)

More Less
Buy this course

Reviews

Average rating

4.7/593.67088607594937 (316)

Details

5 Stars 77 %
4 Stars 18 %
3 Stars 3 %
2 Stars 1 %
1 Stars 1 %
    0