PostgreSQL for Everybody Professional Certificate

What you will learn:
- Utilize psql and SQL commands to implement CRUD (Create, Read, Update, and Delete) operations for tables in a PostgreSQL database.
- Identify and utilize the functions of primary, logical, and foreign keys within a database.
- Design and implement data models using both one-to-many and many-to-many relationships within PostgreSQL.
- Learn about data indexes and query optimization for large scale data.
- Understand various SQL and NoSQL database architectures and how high-performance databases work in production environments.

Sort options

Database Design and Basic SQL in PostgreSQL (edX)

This first course in PostgreSQL for Everybody explores the use of SQL in the PostgreSQL environment and introduces SQL techniques and commands. This course also explores data modeling and database relationships, while introducing hands-on assignments to work within PostgreSQL.

JSON and Natural Language Processing in PostgreSQL (edX)

In this third course in PostgreSQL for Everybody, learners will learn how PostgreSQL creates and uses JSON and natural language content. Learners will explore using multiple sources of data and how text is structured within PostgreSQL.

Database Architecture, Scale, and NoSQL with Elasticsearch (edX)

In this fourth and final course in PostgreSQL for Everybody, learners will explore databses architectures, CRUD operations and how ACID requirements are implemented in PostgreSQL. Within this course, you will explore database architecture, PostgreSQL, and various scalable deployment configurations. You will see how PostgreSQL implements basic CRUD operations and [...]

Intermediate PostgreSQL (edX)

This second course in PostgreSQL for Everybody explores a wide range of SQL techniques to aggregate and transact data in PostgreSQL.This course also explores handling, reading, and parsing data with PostgreSQL and working with text in databases with regular expressions. This course covers a wide range of SQL techniques, [...]