About This Course
This class covers important Intermediate and Advanced-level details for developers interacting with PostgreSQL. The course begins with the overall database architecture, followed by details about crucial features like MVCC or locking, and what consequences that has on applications or maintenance. The course also discusses how to analyze execution plans of queries, indexing options, and other tips and tricks related to performance and database tuning. This course is suitable for both database administrators and application developers using Java, PHP, Python, perl, .Net or any other client languages.