About This Course

In this course, we have covered the basic concepts of databases and relational data, as well as an overview of the SQL language and its history. We have focused on the SQL syntax and how to use it to query data, filter, and sort data, join tables, and modify data. While we have briefly introduced some RDBMS specific features, such as pgAdmin user interface and using SQL in PostgreSQL.

Training Agenda

The following are main topics that be covered in this course:

• Basic concepts of databases and relational data
• Overview of the SQL language and its history
• CREATE DATABASE statement
• SELECT statement syntax and clauses such as WHERE and ORDER BY
• Joins and subqueries
• INSERT, UPDATE, and DELETE statements
• Creating and modifying tables and constraints
• Working with functions and aggregate data
• Using SQL in a specific RDBMS such as PostgreSQL
• Running SQL in pgAdmin
• Running SQL in psql tool