Kurs: RLPG102 - PostgreSQL for developers

This three-day course contains some of the most basic DBA topics from
the other courses, but the focus is on developing database
applications. Topic includes writing and optimizing SQL queries,
advanced reporting queries, recursive queries, writing and using stored
procedures in SQL and pl/pgsql.

Course Format

This class is 70% theory and 30% labs.The course is held in Swedish or English. Documentation is only provided in English.

Agenda

Day 1:

• Introduction and Architecture
• Creating and Managing Databases
• The Data Dictionary
• Monitoring and Statistics
• Performance and Tuning

Day 2:

• SQL Query Tuning
• Tools: PSQL, PgAdmin and phpPgAdmin
• Stored Procedures
• Triggers
• Using JDBC
• Client Connectivity

Målgruppe

Developers and DBAs who develop, administer and maintain installations of PostgreSQL database server.
Prerequisites: SQL, basic knowledge about database development and administration in any RDBMS.