SQL basics and relational DBMS 

introduction

• General information about databases
• Relational databases

Database design

• First, second and third normal forms

Database language SQL

Basic components of an SQL application

• Literals, delimiters, names and reserved words
• Data types and predicates
• Aggregate functions in SQL
• Scalar functions and operators
• Date functions and string functions
• System functions

Data definition in SQL

• Create a database with CREATE DATABASE
• Create a table with CREATE TABLE
• UNIQUE clause
• PRIMARY KEY clause
• FOREIGN KEY clause
• CHECK condition
• Change the table structure with ALTER TABLE
• Delete the objects
• Rule definition for value ranges
• Referential integrity

Simple query with SQL

• Basic form of the SELECT statement
• WHERE, ORDER BY and HAVING clauses
• LIKE, IN and BETWEEN operators
• Simple subqueries
• Operators ANY, ALL and EXIST
• GROUP BY clause
• Aggregate functions (MIN, MAX, SUM, AVG, COUNT)

Complex queries with SQL

• Natural join
• Equijoin, thetajoin and outer join
• Cartesian product

Change the table contents with SQL

• INSERT, UPDATE and DELETE statement

Views with SQL

Indexes with SQL

SQL security concept

• Instructions GRANT and REVOKE

SQL extensions and database procedures

• Introduction to SQL extensions