Linkedin - Learning Advanced PostgreS...

Description

Course details

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

Files (40)

1. Introduction/1. Advanced features in PostgreSQL.mp49.11 MiB
2. Installing and Setting up PostgreSQL/1. macOS- Install PostgreSQL and PGAdmin 4.mp412.04 MiB
2. Installing and Setting up PostgreSQL/2. macOS- Install and set up PostGIS.mp46.54 MiB
2. Installing and Setting up PostgreSQL/3. Windows- Install PostgreSQL and PGAdmin 4.mp411.03 MiB
2. Installing and Setting up PostgreSQL/4. Windows- Install and set up PostGIS.mp45.67 MiB
3. Working with Geospatial Data/1. Spatial data analysis using PostGIS.mp49.64 MiB
3. Working with Geospatial Data/10. Computing locations within a distance and representing lines on a map.mp49.96 MiB
3. Working with Geospatial Data/11. Importing shapefiles.mp49.98 MiB
3. Working with Geospatial Data/2. The WKT and WKB format.mp42.7 MiB
3. Working with Geospatial Data/3. Geometry and geography data types.mp45.28 MiB
3. Working with Geospatial Data/4. Spatial reference systems.mp44.07 MiB
3. Working with Geospatial Data/5. Creating a table to hold geometry types.mp48.81 MiB
3. Working with Geospatial Data/6. Working with basic geometry types.mp410.77 MiB
3. Working with Geospatial Data/7. Extracting coordinate values computing length and area.mp48.57 MiB
3. Working with Geospatial Data/8. Representing real-world data.mp416.61 MiB
3. Working with Geospatial Data/9. Computing the distance between locations.mp410.32 MiB
4. Performing Full-Text Search Operations/1. Full-text search.mp49.88 MiB
4. Performing Full-Text Search Operations/2. Basic text search using LIKE and ILIKE.mp45.77 MiB
4. Performing Full-Text Search Operations/3. Tsvector and tsquery.mp43.78 MiB
4. Performing Full-Text Search Operations/4. Performing a full-text search using the @@ operator.mp45.51 MiB
4. Performing Full-Text Search Operations/5. Using logical operations in search terms.mp46.32 MiB
4. Performing Full-Text Search Operations/6. Performing a search using a different language.mp47.69 MiB
4. Performing Full-Text Search Operations/7. Controlling search parameters.mp410.95 MiB
4. Performing Full-Text Search Operations/8. Ranking search results.mp49.03 MiB
4. Performing Full-Text Search Operations/9. Creating and using dictionaries.mp48.29 MiB
5. Creating and Managing Triggers/1. Introducing triggers.mp45.74 MiB
5. Creating and Managing Triggers/2. Trigger execution order.mp41.97 MiB
5. Creating and Managing Triggers/3. Creating a row-level after insert trigger.mp410.34 MiB
5. Creating and Managing Triggers/4. Creating a row-level after update trigger.mp49.46 MiB
5. Creating and Managing Triggers/5. Creating a statement-level trigger.mp49.74 MiB
6. Defining and Launching Transactions/1. Transactions and transaction isolation levels.mp49.67 MiB
6. Defining and Launching Transactions/2. Creating and committing transactions.mp46.07 MiB
6. Defining and Launching Transactions/3. Rolling back transactions.mp45.48 MiB
6. Defining and Launching Transactions/4. Rolling back committed transactions.mp44.94 MiB
6. Defining and Launching Transactions/5. Savepoints and rollbacks.mp45.87 MiB
6. Defining and Launching Transactions/6. The read committed isolation level.mp45.62 MiB
6. Defining and Launching Transactions/7. The repeatable read isolation level.mp410.1 MiB
6. Defining and Launching Transactions/8. The serializable isolation level.mp411.82 MiB
7. Conclusion/1. Summary and next steps.mp41.78 MiB
Ex_Files_Advanced_PostgreSQL.zip206.34 KiB

Linkedin - Learning Advanced PostgreSQL

Continue browsing

Description

Files (40)