Improve your experience. We are very sorry but this website does not support Internet Explorer. We recommend using a different browser that is supported such as Google Chrome or Mozilla Firefox.
PostgreSQL is a powerful, open-source object-relational database management system that emphasizes extensibility, data integrity, and high performance. Its versatility and robust feature set make it an ideal choice for developers working on projects of all sizes, from small-scale applications to enterprise-level systems. By learning PostgreSQL, developers can tap into its advanced capabilities, such as full-text search, spatial data support, and customizable data types, allowing them to create efficient and scalable solutions tailored to their unique needs.
PostgreSQL for Database Developers is a three-day hands-on course that explores the fundamentals of database management, covering everything from installation and management to advanced SQL functions. Designed for beginners and enthusiasts alike, this course will equip you with the knowledge and skills required to effectively harness the power of PostgreSQL in today's data-driven landscape.
Throughout the course you’ll be immersed in a variety of essential topics, such as understanding data types, creating and managing indexes, working with array values, and optimizing queries for improved performance. You’ll gain valuable hands-on experience with real-world exercises, including the use of the psql client, writing triggers and stored procedures with PL/pgSQL, and exploring advanced SQL functions like Common Table Expressions (CTE), Window Functions, and Recursive Queries. You’ll exit this course with a solid foundation in PostgreSQL, enabling you to confidently navigate and manage your databases with ease and efficiency.
Lesson 1. Installing & Managing PostgreSQL
Lesson 2. Overview of PostgreSQL Database
Lesson 3. Using the psql client
Lesson 4. Understanding PostgreSQL data types
Lesson 5. Understanding sequences
Lesson 6. Creating & managing indexes
Lesson 7. Using COPY to load data
Lesson 8. Working with Array Values
Lesson 9. Advanced SQL Functions
Lesson 10. Writing triggers & stored procedures with PL/pgSQL
Lesson 11. Using the PostgreSQL query optimizer
Lesson 12. Improving query performance
Lesson 13. Wrap Up & Additional Resources