subject
Intro

edX: Hacking PostgreSQL: Data Access Methods

 with  Andrey Borodin

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.

Syllabus

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.

0 Student
reviews
Cost Free Online Course
Pace Self Paced
Subject Databases
Provider edX
Language English
Hours 3-4 hours a week
Calendar 14 weeks long

Disclosure: To support our site, Class Central may be compensated by some course providers.

+ Add to My Courses
FAQ View All
What are MOOCs?
MOOCs stand for Massive Open Online Courses. These are free online courses from universities around the world (eg. Stanford Harvard MIT) offered to anyone with an internet connection.
How do I register?
To register for a course, click on "Go to Class" button on the course page. This will take you to the providers website where you can register for the course.
How do these MOOCs or free online courses work?
MOOCs are designed for an online audience, teaching primarily through short (5-20 min.) pre recorded video lectures, that you watch on weekly schedule when convenient for you.  They also have student discussion forums, homework/assignments, and online quizzes or exams.

0 reviews for edX's Hacking PostgreSQL: Data Access Methods

Write a review

Class Central

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free