DEV1
Basic Server-Side Application Development for PostgreSQL 12
About the course
Duration: 4 days
Prerequisites:
- SQL fundamentals
- experience with any procedural programming language
- basic knowledge of Unix OS
Skills to be gained:
- general information about PostgreSQL architecture
- working with the main database objects: tables, indexes, views
- programming in SQL and PL/pgSQL on the server side
- using the main data types, including records and arrays
- setting up client-server communication
Student guide
When using the course for self-study, check out the Student’s Guide to learn how to set up the virtual machine and do practical assignments.
Topics
| Introduction | course materials | ||
| Basic tools | |||
| 1. | Installation and management; psql | course materials | |
| Architecture | |||
| 2. | A general overview of PostgreSQL | course materials | |
| 3. | Isolation and MVCC | course materials | |
| 4. | Buffer cache and WAL | course materials | |
| Data organization | |||
| 5. | Logical structure | course materials | |
| 6. | Physical structure | course materials | |
| Bookstore application | |||
| 7. | Application schema and interface | course materials | |
| SQL | |||
| 8. | Functions | course materials | |
| 9. | Procedures | course materials | |
| 10. | Composite types | course materials | |
| PL/pgSQL | |||
| 11. | Overview and programming structures | course materials | |
| 12. | Executing queries | course materials | |
| 13. | Cursors | course materials | |
| 14. | Dynamic commands | course materials | |
| 15. | Arrays | course materials | |
| 16. | Error handling | course materials | |
| 17. | Triggers | course materials | |
| 18. | Debugging | course materials | |
| Access control | |||
| 19. | Access control overview | course materials | |
| Backup | |||
| 20. | Logical backup | course materials |
You can download all course materials in a single archive.