SQL Lessons

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.

 
Share on: