Start here if you’re new to SQL. Learn the basics of SQL, retrieve data from an SQL database and build simple reports.
Databases are part of our everyday life, and being able to communicate with them is essential. This course will teach you the basics of SQL, a powerful query language that lets you work with many types of data.
The SQL Basics course starts with simple queries performed on a single table. These exercises will show you how to retrieve exactly what you need. Next, you’ll start working with multiple tables. You will find out about the subtle differences between various joining methods, including INNER JOIN, LEFT JOIN, RIGHT JOIN, and OUTER JOIN.
As you go deeper into the course, you’ll master using the GROUP BY function to create simple reports. You’ll also start investigating subqueries. Finally, you can test your knowledge (and earn your certificate!) in a comprehensive quiz.
Looking to get started in SQL? Give this course a try – the fascinating world of SQL queries is only a click away!
Just a web browser and an Internet connection
Plus, you’ll get to practice your skills on over 129 interactive exercises.
86%
off
Reg. price
$1442
Includes 36 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, 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, 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!
67%
off
Reg. price
$369
Includes 9 courses SQL Basics, SQL Practice Set, SQL JOINs, Standard SQL Functions, Window Functions, How to INSERT, UPDATE, and DELETE Data in SQL, Recursive Queries, Creating Tables in SQL, PostGIS
Bundle price $119
38 hours left at this price!
48%
off
Reg. price
$193
Includes 5 courses SQL Basics, SQL Practice Set, SQL JOINs, Standard SQL Functions, Creating Tables in SQL
Bundle price $99
38 hours left at this price!
47%
off
Reg. price
$187
Includes 5 courses SQL Basics, SQL Practice Set, SQL JOINs, Statistics 101, Introduction to Python for Data Science
Bundle price $99
38 hours left at this price!
Find out what relational databases are and get to know SQL – a language to talk to databases.
0% completed 0 of 6 exercises done
Discover how to select data from a single table.
0% completed 0 of 22 exercises done
Learn how to select data from multiple tables.
0% completed 0 of 13 exercises done
Computations in SQL? Why not? You will learn how to group rows and compute statistics with aggregate functions.
0% completed 0 of 23 exercises done
Learn about various kinds of JOINs to best suit your needs.
0% completed 0 of 22 exercises done
Queries within queries? That's right! Discover how to build and use subqueries.
0% completed 0 of 22 exercises done
Combine query results using set operations like UNION, INTERSECT or MINUS.
0% completed 0 of 12 exercises done
Check your SQL skills.
0% completed 0 of 9 exercises done
