Natural Language-Lectures
Welcome to the Course!
()
Help Us Learn More About You
Syllabus
Allocating Rows to Blocks in PostgreSQL
()
Index Implementation Details
()
Building an Inverted Index with SQL
()
Demonstration: SQL Inverse Index
()
Building a Natural Language Index with SQL
()
Demonstration: SQL Natural Language Index
()
Natural Language-Assignments
Each Course Uses a Different Database
How Assignments Work
Connecting to Your Database Server
Natural Language-Bonus
Bonus: Office Hours - Seoul, South Korea
()
Bonus: Office Hours - Portland, Oregon, USA
()
Inverted Indexes with PostgreSQL-Lectures
A GIN-based Inverted Index with PostgreSQL
()
Demonstration: GIN-based inverted index
()
Building a Natural Language Index in PostgreSQL
()
Demonstration: Fulltext tsquery and tsvector Functions
()
Demonstration: Building a GIN / tsvector Index
()
Inverted Indexes with PostgreSQL-Assignments
Assessment Philosophy
Inverted Indexes with PostgreSQL-Bonus
Office Hours - Washington, DC, USA
()
Office Hours, Amsterdam, Netherlands
()
Python and PostgreSQL-Lectures
Lecture: PostgreSQL and Python
()
Demonstration Python and PostgreSQL simple.py
()
Demonstration loadbook.py
()
Lecture: Mail Archive
()
Demonstration: Mail Archive 1/3
()
Demonstration: Mail Archive 2/3
()
Lecture: Ranking Search Results with PostgreSQL
()
Demonstration: Mail Archive 3/3
()
Python and PostgreSQL-Assignments
How Python Assignments Work
Python and PostgreSQL on PythonAnywhere
Python and PostgreSQL-Bonus
Office Hours: Zagreb, Croatia
()
Office Hours, Orlando, Florida, USA
()
JSON and PostgreSQL-Lectures
Lecture: JavaScript Object Notation
()
Douglas Crockford and JSON
Interview: Douglas Crockford - JSON
()
Lecture: Python and JSON
()
Lecture: PostgreSQL and JSON
()
Demonstration: Music Tracks and JSON
()
Lecture: Using a JSON API
()
Demonstration: Star Wars API 1/2
()
Demonstration: Star Wars API 2/2
()
JSON and PostgreSQL-Wrap Up
Course Wrap Up
()
Post-Course Survey
JSON and PostgreSQL-Bonus
Office Hours, London, England
()
Office Hours - Montreal, Quebec, Canada (at PyCon)
()