SQL Tutorials

Learn how to easily select multiple columns from a database table in SQL, or select all columns from a table in one simple query.

Explore data management with our SQL Server Tutorial. From basics to advanced usage, enhance your skills and navigate SQL Server with confidence.

Discover what MySQL is and how to get started in one of the most popular database management systems.

Learn about the SQL QUALIFY clause, an essential yet lesser-known filtering method in SQL. Understand its syntax, uses, and how it differs from other SQL filtering methods.

Learn how DataCamp Workspace optimizes the experience of working with Jupyter notebooks and SQL. Discover how to effortlessly write SQL queries, connect to databases, analyze CSV files, and leverage the power of AI assistance

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.

Learn how to use the SQL COALESCE() function to handle null values, combine columns, and clean up your data with real-world examples and tips.

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.