SQL Tutorials

Unleash the power of SQL within pandas and learn when and how to use SQL queries in pandas using the pandasql library for seamless integration.

COALESCE() is one of the handiest functions in SQL. Read this tutorial to learn how to master it.

FORMAT() is one of the most commonly used functions in SQL. Learn its main applications in this tutorial.

INSERT INTO lets you add data to your tables. Learn how to use it in this tutorial.

COUNT() lets you count the number of rows that match certain conditions. Learn how to use it in this tutorial.

DATEDIFF() is one of the most widely used date data manipulation functions in SQL. Master it by reading this tutorial.

Learn to access and run SQL queries on all types of relational databases using Python objects.

Learn the basics of the 25 most popular SQL commands and how to use them.

Use LIKE to filter SQL records on specific string matches. This tutorial teaches you to use wildcards, NOT, LOWER, UPPER, and CASE WHEN with LIKE.

If you are looking to get started with SQL, we’ve got you covered. In this SQL tutorial, we will introduce you to SQL queries - a powerful tool that enables us to work with the data stored in a database. You will see how to write SQL queries, learn about

Discover how to execute Python and R in SQL and unlock powerful new machine learning possibilities for your databases.

Learn easy and effective ways to run SQL queries in Python and R for data analysis and database management.