What you will learn

• Basic concepts of databases and relational databases such as table, record, field, relation, primary key or secondary key.

• Use of the SELECT command with the WHERE clause and various tools such as IN, BETWEEN or LIKE to query databases using string and range patterns.

• The SQL commands for creating, changing and deleting tables and databases: CREATE, ALTER and DROP and to modify tables: INSERT, UPDATE and DELETE.

• How to group, summarize and sort with ORDER BY, GROUP BY, SUM, AVG, MAX or MIN and how to make queries from several tables with JOIN and UNION