PostgreSQL for Developers Course OverviewEnglish - Please note this course is only available in English. Nederlands - Let op: deze training is alleen in het Engels beschikbaar. Français - Veuillez noter que ce cours est uniquement disponible en anglais.This course covers important basic and intermediate level details for developers interacting with PostgreSQL. Delegates will learn technique PostgreSQL for Developers Training Course Course Contents - DAY 1 Course Introduction Administration and course materials Course structure and agenda Delegate and trainer introductions Session 1: ADVANCED SQL LANGUAGE Advanced Datatypes Data Type Conversion Session 2: ENHANCED GROUPING FEATURES Revision of aggregate functions and basic GROUP BY and HAVING clauses ROLLUP extension CUBE extension GROUPING function GROUPING SETS function Session 3: ANALYTICAL QUERIES Ranking functions NTILE and WIDTH_BUCKET functions Analytic aggregates Windowing functions Row and Range specifications FIRST_VALUE and LAST_VALUE LAG and LEAD functions Session 4: RECURSIVE QUERIES The WITH clause Recursive Common Table Expressions Session 5: REGULAR
