Hacking PostgreSQL: Data Access Methods

Course
en
English
42 h
This content is rated 0 out of 5
Source
  • From www.youtube.fr
Conditions
  • Self-paced
  • Free Access
  • Fee-based Certificate
More info
  • 14 Sequences
  • Advanced Level

Their employees are learning daily with Edflex

  • Safran
  • Air France
  • TotalEnergies
  • Generali
Learn more

Course details

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.

Prerequisite

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

Instructors

Andrey Borodin
Associate Professor
Ural Federal University

Platform

Harvard University, the Massachusetts Institute of Technology, and the University of California, Berkeley, are just some of the schools that you have at your fingertips with EdX. Through massive open online courses (MOOCs) from the world's best universities, you can develop your knowledge in literature, math, history, food and nutrition, and more. These online classes are taught by highly-regarded experts in the field. If you take a class on computer science through Harvard, you may be taught by David J. Malan, a senior lecturer on computer science at Harvard University for the School of Engineering and Applied Sciences. But there's not just one professor - you have access to the entire teaching staff, allowing you to receive feedback on assignments straight from the experts. Pursue a Verified Certificate to document your achievements and use your coursework for job and school applications, promotions, and more. EdX also works with top universities to conduct research, allowing them to learn more about learning. Using their findings, edX is able to provide students with the best and most effective courses, constantly enhancing the student experience.

This content is rated 4.5 out of 5
(no review)
This content is rated 4.5 out of 5
(no review)
Complete this resource to write a review