• Length:
    14 Weeks
  • Effort:
    3–4 hours per week
  • Price:

    FREE
    Add a Verified Certificate for $49 USD

  • Institution
  • Subject:
  • Level:
    Advanced
  • Language:
    English
  • Video Transcript:
    English

Prerequisites

  • General database concepts
  • Basic SQL knowledge
  • C programming language
  • git source control system
  • Basic algorithms and data structures

About this course

This course is about data storage and data processing technologies with examples from PostgreSQL. It is geared toward database core developers, operation systems developers, system architects, and all those who want to understand databases in more detail.

PostgreSQL is considered the most advanced free open-source database engine. It is developed by a community of hackers around the world - some of them are students just like you!

In this course, you will learn how to use PostgreSQL indices, how to change them according to your demands, and how to implement your ideas and give back to the community.

What you'll learn

  • General ideas of data access
  • PostgreSQL source code organization and development lifecycle
  • PostgreSQL data access technologies
  • Data access development trends
Section 1. General purpose algorithms.
Topic 1: Introduction to PostgreSQL. Core concepts and source code structure.
Topic 2: Developer tools. Querying and coding.
Topic 3: B-tree. Idea, implementation, query analysis.

Section 2. Special algorithms to tackle specific problems, including PostgreSQL’s approach.
Topic 4: Paged memory organization.
Topic 5: Write-ahead log. Point-in-time recovery.
Topic 6: Generalized index search tree (GiST).

Section 3. Specific algorithms implemented only in PostgreSQL.
Topic 7: PostgreSQL extensions. cube and smlar.
Topic 8: Full text search. Generalized inverted index (GIN).
Topic 9: PostgreSQL development lifecycle. Mailing lists and commitfests.

Meet your instructors

Andrey Borodin
Associate Professor
Ural Federal University

Pursue a Verified Certificate to highlight the knowledge and skills you gain $49.00

View a PDF of a sample edX certificate
  • Official and Verified

    Receive an instructor-signed certificate with the institution's logo to verify your achievement and increase your job prospects

  • Easily Shareable

    Add the certificate to your CV or resume, or post it directly on LinkedIn

  • Proven Motivator

    Give yourself an additional incentive to complete the course

  • Support our Mission

    EdX, a non-profit, relies on verified certificates to help fund free education for everyone globally

Who can take this course?

Unfortunately, learners from one or more of the following countries or regions will not be able to register for this course: Iran, Cuba and the Crimea region of Ukraine. While edX has sought licenses from the U.S. Office of Foreign Assets Control (OFAC) to offer our courses to learners in these countries and regions, the licenses we have received are not broad enough to allow us to offer this course in all locations. EdX truly regrets that U.S. sanctions prevent us from offering all of our courses to everyone, no matter where they live.