PostgreSQL


Request for price


Length: 5.0 day (40 hours)

 

PostgreSQL is a powerful, open-source object-relational database system known for its reliability, data integrity, and advanced features. This course provides a comprehensive introduction to PostgreSQL, covering its core concepts, installation, administration, and SQL query language

  • Database administrators
  • Software developers
  • Data analysts
  • Anyone interested in learning a robust database system

Basic understanding of SQL and database concepts

Start with the customer – find out what they want and give it to them.

Course objectivesCourse outlines

Course objectives

After completing this course, students will be able to:

    • Understand the architecture and features of PostgreSQL
    • Install and configure PostgreSQL
    • Create and manage databases and schemas
    • Write SQL queries to retrieve, insert, update, and delete data
    • Optimize database performance
    • Backup and restore databases
    • Secure PostgreSQL installations

Course outlines

  • Module 1: Introduction to PostgreSQL
    • What is PostgreSQL?
    • Key features and benefits
    • Comparison with other database systems (MySQL, Oracle)
    • PostgreSQL architecture
  • Module 2: Installation and Configuration
    • Installing PostgreSQL on various platforms (Windows, Linux, macOS)
    • Configuring PostgreSQL for optimal performance
    • Setting up user accounts and permissions
    • Creating and managing databases and schemas
  • Module 3: SQL Fundamentals
    • Data types and operators
    • SQL data definition language (DDL): Creating, altering, and dropping tables
    • SQL data manipulation language (DML): Inserting, updating, and deleting data
    • SQL data query language (DQL): Selecting and filtering data
    • SQL data control language (DCL): Granting and revoking privileges
  • Module 4: Advanced SQL
    • Joining tables (INNER JOIN, OUTER JOIN, self-join)
    • Aggregations (COUNT, SUM, AVG, MAX, MIN)
    • Grouping and sorting data
    • Subqueries and common table expressions (CTEs)
    • Window functions
  • Module 5: PostgreSQL Functions and Procedures
    • Creating user-defined functions
    • Creating stored procedures
    • Triggers and rules
  • Module 6: Database Performance Tuning
    • Indexing techniques
    • Query optimization
    • Performance monitoring tools
    • Configuration tuning
  • Module 7: Database Backup and Recovery
    • Physical and logical backups
    • Point-in-time recovery
    • Disaster recovery planning
  • Module 8: Security
    • User authentication and authorization
    • Encryption and data privacy
    • Security best practices

​

Download outlines