Hacking PostgreSQL: Data Access Methods (edX)

Hacking PostgreSQL: Data Access Methods (edX)
Course Auditing
Categories
Effort
Certification
Languages
General database concepts. Basic SQL knowledge. C programming language. git source control system. Basic algorithms and data structures
Misc

MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Hacking PostgreSQL: Data Access Methods (edX)
Learn the science, engineering practices and hacking techniques of data access – core aspects of information processing in a database. 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.

Class Deals by MOOC List - Click here and see edX's Active Discounts, Deals, and Promo Codes.

MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

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


Course 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.



10
Average: 10 ( 2 votes )

MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Course Auditing
44.00 EUR
General database concepts. Basic SQL knowledge. C programming language. git source control system. Basic algorithms and data structures

MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.