Postgres SQL Database

PostgreSQL is a powerful, open-source relational database management system (RDBMS) known for its robustness, extensibility, and standards compliance. It is designed to handle a wide range of workloads, from small single-machine applications to large Internet-facing applications with many concurrent users.

This instructor-led, live training (online or onsite) is aimed at intermediate-level developers and administrators who wish to leverage the latest features and improvements in PostgreSQL 16.

By the end of this training, participants will be able to:

• Understand the architecture and components of PostgreSQL 16.
• Utilize advanced SQL features and PostgreSQL extensions.
• Implement security best practices and access controls.
• Perform database administration tasks, including backup, recovery, and monitoring.
• Optimize database performance through tuning and indexing strategies.
• Utilize PostgreSQL's built-in tools for high availability and replication.
• Integrate PostgreSQL with modern application development frameworks.

Course Outline

• Data Models
• Data Types
• Constraints
• Data Integrity
• Database Design
• Database Normalization
• Database SYS Analysis
• Database ERD Basics
• Database Analysis and Convert to ERD
• Postgres SQL - SQL Fundamentals
• Postgres SQL - SQL Basic Select
• Postgres SQL - SQL Where and Order by
• Postgres SQL - SQL  Grouping
• Postgres SQL - SQL Tables Joins
• Postgres SQL - SQL case when
• Postgres SQL - SQL Set Operators (union-union all,. . .)
• Postgres SQL - SQL  DML
• Postgres SQL - SQL DDL

{mlang}