Advanced PostgreSQL

Focused View

Janani Ravi

2:20:16

81 View

01 - Introduction

01 - Advanced features in PostgreSQL.mp4

04:46

02 - 1. Installing and Setting up PostgreSQL

01 - macOS Install PostgreSQL and PGAdmin 4.mp4

05:36

02 - macOS Install and set up PostGIS.mp4

02:30

03 - Windows Install PostgreSQL and PGAdmin 4.mp4

04:06

04 - Windows Install and set up PostGIS.mp4

02:09

03 - 2. Working with Geospatial Data

01 - Spatial data analysis using PostGIS.mp4

05:44

02 - The WKT and WKB format.mp4

01:39

03 - Geometry and geography data types.mp4

03:07

04 - Spatial reference systems.mp4

02:30

05 - Creating a table to hold geometry types.mp4

03:06

06 - Working with basic geometry types.mp4

04:12

07 - Extracting coordinate values, computing length, and area.mp4

03:51

08 - Representing real-world data.mp4

04:56

09 - Computing the distance between locations.mp4

03:22

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

03:17

11 - Importing shapefiles.mp4

04:16

04 - 3. Performing Full-Text Search Operations

01 - Full-text search.mp4

05:30

02 - Basic text search using LIKE and ILIKE.mp4

02:27

03 - Tsvector and tsquery.mp4

01:56

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

02:41

05 - Using logical operations in search terms.mp4

02:48

06 - Performing a search using a different language.mp4

03:11

07 - Controlling search parameters.mp4

05:03

08 - Ranking search results.mp4

04:11

09 - Creating and using dictionaries.mp4

04:17

05 - 4. Creating and Managing Triggers

01 - Introducing triggers.mp4

03:23

02 - Trigger execution order.mp4

01:14

03 - Creating a row-level, after insert trigger.mp4

04:54

04 - Creating a row-level, after update trigger.mp4

04:35

05 - Creating a statement-level trigger.mp4

04:42

06 - 5. Defining and Launching Transactions

01 - Transactions and transaction isolation levels.mp4

05:44

02 - Creating and committing transactions.mp4

02:48

03 - Rolling back transactions.mp4

02:28

04 - Rolling back committed transactions.mp4

02:15

05 - Savepoints and rollbacks.mp4

02:36

06 - The read committed isolation level.mp4

02:50

07 - The repeatable read isolation level.mp4

04:50

08 - The serializable isolation level.mp4

05:37

07 - Conclusion

01 - Summary and next steps.mp4

01:09

Description

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

PostgreSQL

Janani Ravi

Instructor's Courses

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.