This page lists all the lessons part of the graspsql SQL tutorial.
Lessons covering DBMS basic concepts
Table, Columns and Rows : understand what is a database table, what is a row, what is a column.
DBMS and RDBMS : learn what a DBMS is. Learn what can go wrong with a database.
Database Administration : learn what is the role of a database administrator. Learn terms like user rights, granting and revoking rights.
Lessons on how to retrieve information with SQL
SQL SELECT: learn how to retrieve information from a database.
SQL DISTINCT, ORDER BY, COUNT : learn how to eliminates duplicates in the query result, how to count rows and how to order them.
SQL WHERE condition: learn how to filter the rows you are displaying.
Combining conditions in SQL: learn how to write SQL statements containing more than one conditions.
Combining OR and AND in SQL : learn how to OR and AND keywords in the same where clause.
SQL INNER JOIN : combine information from several tables using one query.
SQL OUTER JOIN : learn other types of joins (left outer join, right outer join).
SQL GROUP BY: group lines in a table. This enables you to show total, averages, minimum, maximum averages per group of information.
Lessons on how to update information with SQL
SQL UPDATE : explains how to modify information in a database.
SQL INSERT : explains how to insert information in a database.
SQL INSERT and Auto Increment: learn how to insert a row in a table when one of the column has its values generated automaticaly.
SQL DELETE FROM: learn how to delete rows from a table.
Lessons on how to administer a database with SQL
Create a Table with SQL: learn how to create tables with SQL. Learn about column types.
SQL ALTER TABLE: learn how to add or modify a column, how to change the table name.
Database administration with SQL : learn the syntax of actions related to database administration. Learn how to grant or revoke rights, create or delete a user, modify a password.
Index, Unique Key, Primary Key: understand indexes, unique keys and primary keys. Learn how to create them and what are their differences.
Foreign Key: understand foreign keys and how to add them. Understand the “on delete cascade” statement.