Duration
2 days
1. Introduction
- 1. Welcome
- 2. Introduction to Database Design
- 3. Relational Database overview
- 4. PostgreSQL Overview
- 5. MySQL vs PostgreSQL
- 2. Getting Started with PostgreSQL
- 1. Install PostgreSQL
- 2. Install pgAdmin
- 3. Install Northwind Database
- 3. Simple Selection in SQL
- 1. Select All Data From a Table
- 2. Select Specific Fields
- 3. Select Distinct Values
- 4. Count Results
- 5. WHERE Selection for Text Fields
- 6. Combining Fields in SELECT
- 7. WHERE Selection for Numeric Fields
- 8. WHERE with Date Fields
- 9. WHERE Using Logical AND Operator
- 10. WHERE Using Logical OR Operator
- 11. WHERE Using Logical NOT Operator
- 12. WHERE Combining AND, OR, and NOT
- 13. Using BETWEEN and IN
- 4. Intermediate SELECT Statements
- 1. ORDER BY
- 2. Using MIN and MAX Functions
- 3. Using AVG and SUM
- 4. LIKE to Match Patterns
- 5. Renaming Columns With Alias
- 6. LIMIT to Control Number of Records Returned
- 7. NULL Values
- 5. PostgreSQL Joins
- 1. Intro to Joins
- 2. Inner Join for Two Tables
- 3. Inner Join for Multiple Tables
- 4. Left Joins
- 5. Right Joins
- 6. Full Joins
- 7. Self Joins
- 6. Group By, Unions & Subqueries
- 1. Group By
- 2. Use HAVING to Filter Groups
- 3. Union
- 4. Subquery Using EXISTS
- 5. Subquery Using ANY and ALL
- 6. IN Using Subquery
- 7. PostgreSQL DML (INSERT, UPDATE & DELETE)
- 1. INSERT INTO
- 2. UPDATE
- 3. DELETE
- 4. SELECT INTO
- 5. INSERT INTO SELECT
- 8. PostgreSQL DDL (CREATE, ALTER , DROP)
- 1. CREATE DATABASE
- 2. DROP DATABASE
- 3. CREATE TABLE
- 4. ALTER TABLE
- 5. CREATE INDEX
- 6. DROP INDEX
- 7. DROP TABLE
- 9. Table Constraints
- 1. NOT NULL Constraint
- 2. UNIQUE Constraint
- 3. PRIMARY KEY Constraint
- 4. FOREIGN KEY Constraint
- 5. CHECK Constraint
- 6. DEFAULT Constraint
- 10. PHP & Postgres CRUD Web App
- 1. Application UI
- 2. Connect PHP with PostgreSQL
- 3. Select and Display data
- 4. Adding Data
- 5. Update Data
- 6. Delete Data
- 7. Final Touch to the Application
- 11. Conclusion
- 1. QA
- 2. Useful References and Books
Programme scope, delivery arrangements and suitability are confirmed during enquiry.