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.
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!
86%
off
Reg. price
$1512
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, Introduction to Python for Data Science, How to Read and Write CSV Files in Python, How to Read and Write JSON Files in Python, Lists and Functions in R, Data Manipulation in R, 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, How to Read and Write Excel Files in Python
Bundle price $199
38 hours left at this price!
72%
off
Reg. price
$324
Includes 8 courses SQL Basics in PostgreSQL, PostgreSQL JOINs, SQL Practice Set in PostgreSQL, Window Functions in PostgreSQL, Creating Basic SQL Reports in PostgreSQL, Recursive Queries in PostgreSQL, Writing User-Defined Functions in PostgreSQL, PostGIS
Bundle price $89
38 hours left at this price!
Review the fundamentals of SQL. Practice using SELECT and WHERE to filter data.
0% completed 0 of 9 exercises done
Test your knowledge of GROUP BY and ORDER BY clauses.
0% completed 0 of 11 exercises done
Practice using JOIN, LEFT JOIN, and non-equi JOIN. Check your skills of working with multiple tables.
0% completed 0 of 32 exercises done
Verify your knowledge of subqueries. Practice simple and correlated subqueries.
0% completed 0 of 15 exercises done
Practice your SQL skills. Write SQL queries which combine SELECT, WHERE, JOIN, GROUP BY, HAVING, ORDER BY and subqueries.
0% completed 0 of 21 exercises done
