Category
Technologies
SQL Tutorials
Keep up to date with the latest techniques and resources for SQL Server. Our tutorials are full of free SQL Server training tips to help you learn, build, & grow.
Other technologies:
How to Use SQL in pandas Using pandasql Queries
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.
Elena Kosourova
May 11, 2023
MySQL in Python Tutorial: Getting Started
In this tutorial, you'll learn how to install MySQL, create databases, and create tables, along with much more.
Kurtis Pykes
April 14, 2023
Using PostgreSQL in Python
Discover how to create, connect to and manage PostgreSQL databases using Python’s psycopg2 package.
Javier Canales Luna
March 31, 2023
How to Use GROUP BY and HAVING in SQL
An intuitive guide for discovering the two most popular SQL commands to aggregate rows of your dataset
Eugenia Anello
February 21, 2023
SQL Tutorial: How To Write Better Queries
Learn about anti-patterns, execution plans, time complexity, query tuning, and optimization in SQL.
Karlijn Willems
December 19, 2022
COALESCE SQL Function
COALESCE() is one of the handiest functions in SQL. Read this tutorial to learn how to master it.
Travis Tang
October 12, 2022
FORMAT() SQL FUNCTION
FORMAT() is one of the most commonly used functions in SQL. Learn its main applications in this tutorial.
Travis Tang
October 12, 2022
INSERT INTO SQL FUNCTION
INSERT INTO lets you add data to your tables. Learn how to use it in this tutorial.
Travis Tang
October 12, 2022
COUNT() SQL FUNCTION
COUNT() lets you count the number of rows that match certain conditions. Learn how to use it in this tutorial.
Travis Tang
October 12, 2022
DATEDIFF() SQL FUNCTION
DATEDIFF() is one of the most widely used date data manipulation functions in SQL. Master it by reading this tutorial.
Travis Tang
October 12, 2022
SQLAlchemy Tutorial With Examples
Learn to access and run SQL queries on all types of relational databases using Python objects.
Abid Ali Awan
October 4, 2022
SQL Commands Glossary—An Overview of 25 Most Popular SQL Commands
Learn the basics of the 25 most popular SQL commands and how to use them.
Bekhruz Tuychiev
July 29, 2022