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.
Filter Courses within "PostgreSQL for Everybody Professional Certificate" (Click to filter)
Database Design and Basic SQL in PostgreSQL (edX) EdX
University of Michigan,MichiganX

Database Design and Basic SQL in PostgreSQL (edX)

Discover the essentials of Database Design and Basic SQL with our beginner-friendly course on PostgreSQL. Designed for those new to databases, this course will guide you through data modeling, understanding database relationships, and applying SQL techniques within the powerful PostgreSQL environment. Start your journey towards becoming a proficient database administrator today!

Self Paced
Self-Paced
Intermediate PostgreSQL (edX) EdX
University of Michigan,MichiganX

Intermediate PostgreSQL (edX)

Dive deeper into the world of PostgreSQL with our Intermediate PostgreSQL course. This comprehensive program is designed for those who have a foundational understanding of PostgreSQL and are eager to master advanced SQL techniques such as aggregation, transactions, and working with text using regular expressions. Whether you're looking to refine your database management skills or advance in your career, this course offers valuable insights into handling CSV files and optimizing data operations.

Self Paced
Self-Paced
Database Architecture, Scale, and NoSQL with Elasticsearch (edX) EdX
University of Michigan,MichiganX

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

Dive into the world of databases with this advanced course on Database Architecture, Scale, and NoSQL with Elasticsearch. Learn how to architect robust database systems, understand scalability options, and explore NoSQL solutions like Elasticsearch. This course is perfect for those looking to deepen their knowledge in PostgreSQL, CRUD operations, ACID requirements, and more.

Self Paced
Self-Paced
Page 1