Advanced PostgreSQL

سرفصل های دوره

PostgreSQL is a powerful, open-source, object-relational database system. It’s popular around the world, given its strong reputation for reliability, feature robustness, and performance. In this course, Janani Ravi dives into advanced topics in PostgreSQL. After showing how to install and set up PostgreSQL, Janani shows you how to work with geospatial data, which allows you to specify geographic objects such as locations, lines, and polygons, all on a geographic map, and also supports location-based queries like distance computation and area computation. Next, learn about performing full-text search operations, and how to work with triggers, which let you set up an automated execution of a function when a certain type of operation is performed. Finally, Janani explores transactions, which allow you to bundle multiple steps into a single, all-or-nothing operation.

01 - Introduction

01 - Advanced features in PostgreSQL

02 - 1. Installing and Setting up PostgreSQL

01 - macOS Install PostgreSQL and PGAdmin 4

02 - macOS Install and set up PostGIS

03 - Windows Install PostgreSQL and PGAdmin 4

04 - Windows Install and set up PostGIS

03 - 2. Working with Geospatial Data

01 - Spatial data analysis using PostGIS

02 - The WKT and WKB format

03 - Geometry and geography data types

04 - Spatial reference systems

05 - Creating a table to hold geometry types

06 - Working with basic geometry types

07 - Extracting coordinate values, computing length, and area

08 - Representing real-world data

09 - Computing the distance between locations

10 - Computing locations within a distance and representing lines on a map

11 - Importing shapefiles

04 - 3. Performing Full-Text Search Operations

01 - Full-text search

02 - Basic text search using LIKE and ILIKE

03 - Tsvector and tsquery

04 - Performing a full-text search using the @@ operator

05 - Using logical operations in search terms

06 - Performing a search using a different language

07 - Controlling search parameters

08 - Ranking search results

09 - Creating and using dictionaries

05 - 4. Creating and Managing Triggers

01 - Introducing triggers

02 - Trigger execution order

03 - Creating a row-level, after insert trigger

04 - Creating a row-level, after update trigger

05 - Creating a statement-level trigger

06 - 5. Defining and Launching Transactions

01 - Transactions and transaction isolation levels

02 - Creating and committing transactions

03 - Rolling back transactions

04 - Rolling back committed transactions

05 - Savepoints and rollbacks

06 - The read committed isolation level

07 - The repeatable read isolation level

08 - The serializable isolation level

07 - Conclusion

01 - Summary and next steps

189,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: LinkedIn Learning (Lynda)