SQL TutorialLesson 1Free preview

SQL Intro

This lesson is part of SQL · All levels

Summary

SQL (Structured Query Language) is a standard language for managing and manipulating data in relational databases such as MySQL. With SQL we can take, add, modify, delete data, and create a database structure in the form of a table. SQL works by sending a query in the form of a text command to a database server.

Key points

SQL is the standard language for relational databases such as MySQL, PostgreSQL, and SQL Server.
SQL commands are grouped into DML (SELECT, INSERT, UPDATE, DELETE) and DDL (CREATE, ALTER, DROP).
SQL is declarative: we state what data we want, not the steps of processing.
SQL keywords do not distinguish between upper and lower case letters, but table names can be sensitive to upper/lower case letters depending on the system.
MySQL is one of the popular RDBMS systems that fully supports SQL.

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.