SELECT basics - SQLZoo

The example uses a WHERE clause to show the population of 'France'. Note that strings should be in 'single quotes';

sqlzoo.net

Learn SQL - Online SQL Terminal - Practice SQL Querys

Practice SQL querys with an online terminal. Solve SQL query questions using a practice database. Learn and improve your SQL skills.

www.sql-practice.com

SQL 50 - Study Plan - LeetCode

Crack SQL Interview in 50 Qs

leetcode.com

PostgreSQL Exercises

Welcome to PostgreSQL Exercises! This site was born when I noticed that there's a load of material out there to help people learn about SQL, but not a great deal to make it easy to learn by doing. PGExercises provides a series of questions and explanations built on a single, simple dataset. It's designed for use as a partner to a good book or Postgres' excellent documentation.

pgexercises.com

Solve Programming Questions | HackerRank

A special-purpose language designed for managing data held in a relational database.

www.hackerrank.com

SQl Index

Module 1: MySQL Into Query

1. SQL Subdivisions
• Data Definition Language (DDL)
• Data Manipulation Language (DML)
• Data Control Language (DCL)
• Transaction Control Language (TCL)
• Data Query Language (DQL)
2. SELECT FROM
• MySQL SELECT FROM statement
3. SQL ORDER BY
• Using ORDER BY clause to sort the result set by one column example
• Using the ORDER BY clause to sort the result set by multiple columns example
• Using the ORDER BY clause to sort a result set by an expression example
• Using MySQL ORDER BY clause to sort data using a custom list
• MySQL ORDER BY and NULL
4. SQL Where
• Using the WHERE clause with operator example
• Using the WHERE clause with the AND operator
• Using the WHERE clause with OR operator
• Using the WHERE clause with the BETWEEN operator
• Using the WHERE clause with the LIKE operator example
• Using the WHERE clause with the IN operator example
• Using the WHERE clause with NOT IN operator
• Using the WHERE clause with the IS NULL operator
• Using MySQL WHERE clause with comparison operators
• Using MySQL DISTINCT clause
• Using MySQL LIMIT clause
5. SELECT INTO Variable
• MySQL SELECT INTO variable