Enjoying the preview?
This is the free first lesson. Get full access — request a demo or sign in.
PostgreSQL
How to most effectively utilize PostgreSQL.Preview the first lesson free — get full access to all 3 lessons.
Advanced Provider : Kati Gordon 3 Lessons · 6m in Arabic, German, English, Spanish, French, Portuguese, Chinese
Course Description
Postgre is an open-source object-relational database system that uses and extends the SQL language by combining it with features that store and scale some of the most complicated data workloads. In this module, you’ll learn about the characteristics of Postgre and how to download and install PgAdmin. PostgreSQL is known for being reliable and having a strong architecture. Through this module, you’ll learn how to utilize it and why it’s helpful. This module includes an overview of the PgAdmin interface as well as how to load a sample database.
What You'll Learn
- Understand what PostgreSQL is and how it works as an open-source object-relational database system
- Identify the characteristics of PostgreSQL, including its reliability and strong architecture
- Download and install PgAdmin and get acquainted with its interface
- Load a sample database within PgAdmin
- Explore indexes in PostgreSQL
Key Takeaways
- PostgreSQL is an open-source object-relational database system that uses and extends the SQL language.
- PostgreSQL combines SQL with features that store and scale some of the most complicated data workloads.
- PostgreSQL is known for being reliable and having a strong architecture.
- The module covers an overview of the PgAdmin interface and how to load a sample database.
Frequently Asked Questions
What is PostgreSQL?
PostgreSQL is an open-source object-relational database system that uses and extends the SQL language by combining it with features that store and scale some of the most complicated data workloads.
What will this module teach me?
This module teaches what PostgreSQL is and how it works, the characteristics of PostgreSQL, how to download and install PgAdmin, an overview of the PgAdmin interface, and how to load a sample database.
Why is PostgreSQL useful?
PostgreSQL is known for being reliable and having a strong architecture, and the module covers how to utilize it and why it is helpful.
What topics do the lessons cover?
The lessons cover the characteristics of PostgreSQL, installing PgAdmin, and indexes in PostgreSQL.
What skills does this course cover?
The course covers skills including Database Programming, Database Software, OpenPGP, PL/pgSQL, PostGIS, and PostgreSQL.
