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
Course materials
Before self study the course please make sure to read the Student’s Guide to learn how to set up the virtual machine and get instructions on how to perform practices.
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 |
Additional
You can download all course materials in a single archive.