Become a SQL master – even if you’ve never coded before. Learn all the necessary tools to freely and efficiently work with any type of data. Start from the basics, then discover advanced SQL functions and features.Start learning
101 free interactive coding challenges
This learning path is for people who have no experience in IT and want to start their adventure with SQL. You’ll learn the basic and advanced features of this language. When you’ve completed this track, you’ll be able to efficiently work with databases and analyze data. Scroll down for details.
Don't have any IT experience and want to learn SQL? This learning path is for you! Data is everywhere. It’s the basis for almost every kind of business – banks, online services, taxi companies, stores, you name it. If you want to have an advantage over the competition, you need to know how to use data. To use data, you need SQL.
Maybe you dream of working as a database administrator or data analyst. Master SQL with the SQL from A to Z learning path. Don't waste time looking for other courses; this path has everything you need in one place. It will guide you through the entire learning process, from the very basics to the advanced features of modern SQL.
What's in it for me?
Who should take this learning path?
While doing the SQL From A to Z learning path, you can practice your knowledge with our SQL Practice track. You can also develop your skills and add new tools to your arsenal by continuing to the SQL Reporting learning path.
Gaining insight from collected data plays an important role in today's information-driven world. During this online course, you'll practically learn how to write basic SQL queries to find answers to your business questions in the PostgreSQL database. No previous IT experience required.
Learn how to use common PostgreSQL functions to process various types of data with ease. Soon, you'll be able to modify textual data, perform calculations, round numbers up or down, change date and time formats, and even adjust time zone info!
A data manipulation language (DML) helps you retrieve, store, modify, and delete data in a database. In this online course, you'll learn how to use PostgreSQL INSERT, UPDATE, and DELETE DML commands to control the information inside.
Gain competitive skills in SQL by learning how to create SQL reports in the PostgreSQL database! This online course consists of 97 interactive exercises; after you complete them all, you'll be able to track and analyze the performance of your metrics. The skills you acquire here can be applied to any industry.
A window function is an advanced SQL concept that enables you to maximize efficiency and minimize the complexity of queries that analyze partitions (windows), subgroups or sections of a data set. In this online course, you'll learn how to build complex aggregations with PostgreSQL window functions: OVER, RANK, PARTITION BY. Note: This is the only online course on PostgreSQL window functions you can find on the Internet.
In this online course, you will master PostgreSQL recursive queries, also known as WITH clauses, and common table expressions (CTEs).
Take your PostgreSQL skills to the next level by learning how to write your own functions.
Learn how to work with maps in SQL
Would you like to work smoothly and efficiently in PostgreSQL? Do you want to be able to create more complex queries? You need ROLLUP, CUBE and GROUPING SETS for this! Learn all about GROUP BY extension clauses in PostgreSQL.