Within this course, you’ll learn about how PostgreSQL creates and uses inverted indexes for JSON and natural language content. We will use various sources of data for our databases, including access to an online API and spidering its data and storing the data in a JSON column in PostgreSQL. Students will explore how full-text inverted indexes are structured. Students will build their own inverted indexes and then make use of PostgreSQL built-in capabilities to support full-text indexes.
Overview
Syllabus
- Natural Language
- In this first week, we introduce you to the course and its main focus: text and JSON.
- Inverted Indexes with PostgreSQL
- In this week, we'll look at GIN-based inverted indexes and ts_vector() and ts_query() functions.
- Python and PostgreSQL
- This week is all about connecting and comparing Python and PostgreSQL.
- JSON and PostgreSQL
- In this final week, we'll focus primarily on JSON and its functions.
Taught by
Charles Russell Severance
Tags
Related Courses
Related articles
-
10 Best Python Courses for 2024: Charming the Snake
-
100+ Free Courses to Learn JavaScript, React, Node
-
10 Best JavaScript Courses for 2024: Create Interactive Websites
-
1800+ Coursera Courses That Are Still Completely FREE
-
250 Top FREE Coursera Courses of All Time
-
Massive List of MOOC-based Microcredentials
Reviews
5.0 rating, based on 1 Class Central review
4.6 rating at Coursera based on 125 ratings
-
الدورة جيدة جدا يجب أيضا مراعات قراءة أي مقالة او كتاب وتحديد الهدف من ذلك حتى لو كان منهج دراسي معين فلذلك هناك فرق في الأشخاص المتدربين او الأشخاص المدربين ومراعات الدرجة التثقيفية أي ثقافة كل شخص موجود ضمن الدورة حتى يتسنى للمدرب توصيل أي معلومة بصورة سلسة ومضمونة في نجاح المتدرب
