TR

PostgreSQL Course for Developers

Course Audience

PG102
3 DAYS

Developers and software teams who want to use PostgreSQL in their applications.

Course Prerequsities

Informations that required by participants before course:

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

Course Goals

  • Working seamlessly with PostgreSQL during software development
  • Designing the software data model with an understanding of PostgreSQL features

Course Subjects

  • Installing and Managing PostgreSQL
  • Overview of PostgreSQL
  • psql Client
  • pgAdmin III Client
  • PostgreSQL Data Types
  • Sequence Concept
  • Indexes
  • Arrays
  • Advanced SQL Functions
  • Trigger and Stored Procedure with PL/pgSQL
  • Bulk Data Loading