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.

Basic

Track

SQL Practice in PostgreSQL

Review and consolidate your SQL skills with tons of interactive exercises! In this learning path, you’ll practice SQL JOINs, aggregation with GROUP BY and HAVING, and subqueries (including correlated subqueries).

Start for free

20 free interactive coding challenges

2

Interactive courses

10 h

Estimated time

24

Users enrolled

☆☆☆☆☆
★★★★★

0 ratings

If you know the basics of SQL and want to keep your coding skills up-to-date, this learning path is for you. These SQL skills can be used with PostgreSQL, MySQL, Oracle, SQL Server, and SQLite database engines. Scroll down for details.

SQL is the most universal database language. Despite the recent explosion of NoSQL, SQL is becoming the preferred interface for data analysis. Whether you’re a student, a business professional, or an SQL enthusiast who’s simply eager to sharpen your skills, there’s always room for improvement.

The SQL Practice path will test your basic SQL knowledge and show you where you need to improve. With plenty of real-world examples and challenging exercises, you’ll brush up your SQL coding skills before you know it. Preparing for an interview? Completing this learning path will help you nail it!

Click “Start for free” and try it yourself!

What's in it for me?

  • Logical, interactive practice exercises. We’ll start with the easier exercises, then work towards the more challenging ones.
  • Learn by doing. Get hands-on practice with our real code editor, real data sets, and real-life problem-solving.
  • Online certification. After successfully completing the course, you will receive a certificate that you can publish on your LinkedIn profile.
  • 30-day money-back guarantee. If you're not satisfied with this course, tell us within 30 days of purchase and you’ll get a full refund.
  • Trusted support system. Every course comes with access to our resource base, student2student support, mentor2student support, and technical support. You can also join our learning community and participate in on-task discussions.
  • Hints and more. If you get stuck, you can use the included exercise hints. Or use the Discuss tab to ask questions and share insights with other members of the LearnSQL community. You can also drop us a line at contact@learnsql.com and we'll be more than happy to help!

Objectives:

  • Review topics that frequently challenge SQL beginners:
    • SELECT statements and the WHERE clause.
    • SQL joins (INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN, multiple JOIN, self-JOIN, non-equi JOIN).
    • Aggregation with GROUP BY and HAVING.
    • SQL subqueries (including correlated subqueries).

Who should take this learning path?

  • People who want to solidify their understanding of SQL.
  • Anyone preparing for a job interview involving SQL.
  • People who love a challenge.
  • Students preparing for a SQL test or exam.
  • You!

Requirements:

  • A web browser
  • An internet connection
  • Basic knowledge of SQL (e.g. you’ve completed our SQL Basics course)

Track courses

1 0%
93

Coding challenges

☆☆☆☆☆
★★★★★

1 ratings

Basic

PostgreSQL JOINs

Consolidate your knowledge of operating on two or more data tables in PostgreSQL database. This online practice set consists of 93 interactive exercises and will help you polish your SQL joining skills.

Details
2 0%
88

Coding challenges

☆☆☆☆☆
★★★★★

1 ratings

Basic

SQL Practice Set in PostgreSQL

This online practice set consists of 88 interactive exercises. You will practice using simple statements and clauses, like SELECT or JOIN, as well as more advanced concepts, such as subqueries.

Details

Reviews (0)

Average rating

3.5 / 5

☆☆☆☆☆
★★★★★

0 ratings

Details

5 stars

0%

4 stars

0%

3 stars

0%

2 stars

0%

1 stars

0%