It's Autumn! Prices fall like leaves! - hours only!Up to 80% off on all courses and bundles.-Close

This exercise set is designed for users who already know how to write basic PostgreSQL queries. It will also be of interest to anyone who wants some online practice to polish or refresh their knowledge of writing queries in PostgreSQL. Keep reading for more details!

What does it take to master a skill? There are several different requirements, but one aspect they have in common is that they require practice. It's no different from writing code. The theory is one thing, but the real fun starts when you work with it for online practice or apply it in a real-world scenario.

So, whether you're a beginner taking your first steps towards writing SQL queries in PostgreSQL or a specialist who wants to refresh your SQL skills through practice, this exercise set will check your knowledge level and show you what you still need to catch up on.

There is always room for development, and today is your chance to complete an exercise or two and ultimately polish your SQL toolkit!

This Exercise Set Includes:

  • simple SELECT queries,
  • aggregate functions (COUNT, SUM, AVG),
  • grouping and ordering results,
  • JOINs (querying from multiple tables, self joins, LEFT JOINs, RIGHT JOINs, and NON-EQUI JOINs), and
  • subqueries (simple subqueries, subqueries with multiple results, correlated subqueries, and subqueries in the FROM and SELECT clauses).
In the end, you'll have to complete a challenge that tests your knowledge of the entire course material!

What's in it for Me?

  • 88 interactive exercises. Learn at your own pace, from any location and at any time. Work through hands-on exercises to help you retain what you have learned so far.
  • Lifetime access to the course. When you purchase the online course, you'll get instant personal access to all of its content forever.
  • Online certificate. After you successfully finish all of the exercises in the online course, you'll receive a downloadable PDF certificate to showcase your accomplishment.
  • 30-day money-back guarantee. If you're not satisfied with the quality of the online course, you can get a refund within 30 days of your purchase.
  • Exercise hints. You can take advantage of ready-made hints for every exercise, or ask questions and share insights with other members of the Vertabelo Academy community through the Discuss tab. You can also drop us a line at academy@vertabelo.com, and we'll be more than happy to answer!

What Are the Requirements?

Learn How to:

  • Use SELECT and WHERE to filter data.
  • Aggregate and group data using clauses.
  • Join multiple tables.
  • Work with complicated subqueries.
  • Use PostgreSQL functions in practice.

Who Should Take This Course?

  • Analysts who use relational databases
  • Students taking courses involving relational databases
  • Beginning programmers interested in PostgreSQL
  • Business database users who want to improve their querying skills
  • Anyone who has finished the SQL Basics in PostgreSQL course or has equivalent knowledge
  • Anyone who wants some online practice for writing PostgreSQL queries
    Start for free
    Gift this course

    Bundle deals

    87%
    off

    Reg. price
    $1551

    One to Rule 'Em All

    Includes 41 courses Python Basics. Part 1, Python Basics. Part 2, Python Basics. Part 3, Python Data Structures in Practice, Built-in Algorithms in Python, Working with Strings in Python, SQL Basics, SQL Practice Set, SQL JOINs, Standard SQL Functions, Creating Basic SQL Reports, Window Functions, Revenue Trend Analysis in SQL, How to INSERT, UPDATE, and DELETE Data in SQL, Recursive Queries, Creating Tables in SQL, Introduction to R, Tidyverse, Data Visualization 101, Statistics 101, SQL Basics in MS SQL Server, How to Insert, Update, or Delete Data in MS SQL Server, Common Functions in MS SQL Server, Revenue Trend Analysis in SQL Server, Creating Basic SQL Reports in SQL Server, Window Functions in MS SQL Server, Recursive Queries in MS SQL Server, GROUP BY Extensions in MS SQL Server, How to Read and Write CSV Files in Python, Introduction to Python for Data Science, How to Read and Write JSON Files in Python, Lists and Functions in R, Data Manipulation in R, Creating Basic SQL Reports in PostgreSQL, SQL Basics in PostgreSQL, PostgreSQL JOINs, SQL Practice Set in PostgreSQL, Window Functions in PostgreSQL, Recursive Queries in PostgreSQL, Writing User-Defined Functions in PostgreSQL, PostGIS

    Bundle price $199

    37 hours left at this price!

    Table of contents

    Progress: 0% completed 0 of 88 exercises done

    1. Warm up: Selecting from one table

    Review the fundamentals of SQL. Practice using SELECT and WHERE to filter data.

    More details Less
    Start now

    0% completed 0 of 9 exercises done

    2. Aggregation and grouping

    Test your knowledge of GROUP BY and ORDER BY clauses.

    More details Less
    Start now

    0% completed 0 of 11 exercises done

    3. JOINs

    Practice using JOIN, LEFT JOIN, and non-equi JOIN. Check your skills of working with multiple tables.

    More details Less
    Start now

    0% completed 0 of 32 exercises done

    4. Subqueries

    Verify your knowledge of subqueries. Practice simple and correlated subqueries.

    More details Less
    Start now

    0% completed 0 of 15 exercises done

    5. SQL Challenge

    Practice your SQL skills. Write SQL queries which combine SELECT, WHERE, JOIN, GROUP BY, HAVING, ORDER BY and subqueries.

    More details Less
    Start now

    0% completed 0 of 21 exercises done

    Reviews

    Average rating

    5/5100.0 (1)

    Details

    5 Stars 100%
    4 Stars 0%
    3 Stars 0%
    2 Stars 0%
    1 Stars 0%
      Load more reviews

      Comments

      0