TR

Advanced SQL Course for PostgreSQL

Course Audience

PG103
2 DAYS

Developers, system administrators, and database administrators who want to specialize in PostgreSQL administration and operations.

Course Prerequsities

Informations that required by participants before course:

  • Participants who will join this course should also have joined PG101, PG201, PG102 courses before or mastered related subjects of these courses.

Course Goals

  • Specializing in PostgreSQL administration
  • Providing solutions to PostgreSQL performance issues
  • Designing efficient database structures for performance

Course Subjects

  • View
  • Foreign Key
  • Transaction
  • Window Functions
  • Inheritance
  • Advanced Data Types
  • Trigger and Stored Procedure with PL/pgSQL
  • Query Planner and Query Analysis
  • Query Performance Optimization