What is SQL?

SQL (pronounced “sequel” or “S-Q-L”) is a domain-specific language used for managing and manipulating data in relational databases. It’s the standard language for database operations.

Setting Up a Practice Environment

Using SQLite (Easiest)

SQLite comes pre-installed on most systems. Create a practice database:

sqlite3 practice.db

Using Online SQL Editors

• SQLFiddle
• DB-Fiddle
• SQLite Online

Basic SQL Syntax

SQL statements are case-insensitive but convention uses uppercase for keywords:

SELECT * FROM users WHERE name = 'John';

is the same as:

select * from users where name = 'John';

Next Steps

Ready to learn more? Continue with Creating Tables to start building your database structure.