• No products in the cart.

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.

PRIVATE
Course Access

Unlimited Duration

Last Updated

March 11, 2021

Students Enrolled

Total Reviews

Posted by
Certification

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

        • Numeric data types 00:00:00
        • Character types 00:00:00
        • Binary data types 00:00:00
        • Date & time values 00:00:00
        • Boolean values 00:00:00
        • Array types 00:00:00
        • Other data types 00:00:00
          • Understanding PostgreSQL indexes 00:00:00
          • Partial indexes 00:00:00
          • Indexes on expressions 00:00:00
            • 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
            • Variables in procedures 00:00:00
            • Performing loop operations 00:00:00
            • The PERFORM and EXECUTE statements 00:00:00
            • Triggers in PostgreSQL 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

            Profile Photo
            ashar hafeez
            0
            61

            Students

            About Instructor

            Pak

            Course Events

            [wplms_eventon_events]

            More Courses by Insturctor

            © 2021 Ernesto.  All rights reserved.  
            X