Introduction to PostgreSQL
49mBeginner2023-07-27
Authors

Sarah Conway Schnurr
Open-Source Tech Evangelist, Software Engineer, Website Developer
Course details
PostgreSQL is one of the world’s most popular database platforms. It’s performant, reliable, and able to be designed for stringent security compliance and availability requirements. If you’ve been curious about whether PostgreSQL is the right database for your needs, this course with instructor Sarah Conway is for anyone from any background—not just developers, but also sales engineers, marketing team members, developer advocates, students, and more—looking for a high-level overview to learn more about PostgreSQL. Sarah explains the basics of PostgreSQL, why it’s relevant as a database today, and how to engage in the community for education, support, development opportunities, careers, commercial or community support. She explains where Postgres can be deployed, what the advantages are to each choice, and where and how to get started configuring Postgres for any application or project.
Skills covered
PostgreSQLDatabase DevelopmentDatabase ManagementLearningOpen SourceSoftware Development
Concepts
0. Introduction
- 01 - Unleashing the power of PostgreSQL - Your journey begins
1. Introducing PostgreSQL
- 02 - Tell me about PostgreSQL
- 03 - Extensions
- 04 - History and recognitions
- 05 - ORDBMS vs. the rest
2. Deploying PostgreSQL
- 06 - Accessing PostgreSQL
- 07 - When, where, and how to deploy Postgres
3. Connecting to PostgreSQL
- 08 - Connecting via CLI
- 09 - Connecting via GUI
4. Working with PostgreSQL
- 10 - Resources and support
- 11 - Contributing to PostgreSQL
Conclusion
- 12 - Next steps
Related courses
- Introducing Entity Framework
- SQL for Exploratory Data Analysis Essential Training
- SQL for Statistics Essential Training
- Learning SQL Programming
- Introduction to SQLite
- Introduction to AR with Unreal and Xcode for Developers
- Introduction to Pen Testing for Cybersecurity Professionals
- Learning ArcGIS Python Scripting (2018)
Related learn paths
- Introduction to Fundamental Skills for Data Work: Data Storage
- Introduction to Fundamental Skills for Data Work: Data Management
- Become a Software Developer
- Data Engineering Foundations Professional Certificate by Astronomer
- Java Foundations Professional Certificate by JetBrains
- Become a Corporate Financial Planning Analyst
- Explore a Career in Database Development
- Become a Java Programmer