COURSE OUTLINE

I. Learning PostgreSQL 13

II. Database commands

a.      Opening a session

b.      Controlling a session

III. DDL and DML SQL commands

a.      Creating a database

b.      Create a table

c.      Data Types

d.      Table constraints

e.      Insert command

f.       Delete command

g.      Update command

h.      Drop table and database

IV. Customizing queries

a.      Single-row functions

b.      Selection and projection

c.      Viewing data with constraints

d.      Nullables

e.      Controlling default values

f.       Column Labels

g.      Comments

h.      Ranges

i.        Logical expressions

j.        Regular expressions

k.      Case Clause

l.        Distinct and Limit rows

V. Aggregates

a.      Multiple row functions

b.      Using group by

c.      Using Having

VI. Joining tables

a.      Table and column references

b.      Reference keys

c.      Non-equijoins

d.      Self-joins

e.      Joins

f.       Cross join

g.      Natural join

VII. Numbering rows

a.      OIDs

b.      Sequences

c.      Ordering rows

VIII.  Advance Selects

a.      UNION, EXCEPT, and INTERSECT

b.      Subqueries

c.      Update with from

d.      Inserting using Select

e.      Creating tables using Select

IX. Transactions and Locks

a.      Transactions

b.      Locking

c.      Deadlocks

X. Table Management

a.      Temporary tables

b.      Alter Table

c.      Views

d.      Indexes

XI. PL/SQL

a.      Store Functions

b.      Stored Procedure

c.      Triggers