ratings
This PostgreSQL training course is ideal for those looking to migrate to PostgreSQL This PostgreSQL training course was designed for specifically for developers with SQL knowledge and experience and focuses on the features and functionality that are specific to PostgreSQL.
Unlimited Duration
March 11, 2021
This “skills-centric” course is about 50% hands-on lab and 50% lecture, designed to train you in the most current, effective techniques with the soundest industry practices. In this course you will learn about:
· Installing & managing PostgreSQL
· Overview of PostgreSQL database
· Using the psql client
· Understanding PostgreSQL data types
· Understanding sequences
· Creating & managing indexes
· Using COPY to load data
· Working with Array Values
· Advanced SQL Functions
· Writing triggers & stored procedures with PL/pgSQL
· Using the PostgreSQL query optimizer
· Improving query performance
Course Curriculum
- Using Common Table Expressions (CTE) 00:00:00
- Using Window Functions 00:00:00
- Using Regular Expressions 00:00:00
- Using Recursive Queries 00:00:00
- Analyzing & optimizing queries 00:00:00
- Viewing execution plans with EXPLAIN 00:00:00
- Understanding PostgreSQL query operators 00:00:00
Course Reviews
Students
