PirateBay Download | linkedin learning advanced postgresql

linkedin learning advanced postgresql

Type:: Other
Files:: 40
Size:: 307.1 MB
Uploaded On:: Jan. 26, 2024, 4:15 p.m.
Added By:: abdenna
Seeders:: 0
Leechers:: 0
Info Hash:: 61D1EEAA74E6B42C72F83525006928A5D1EED53B

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

Get This Torrent

1. Introduction/1. Advanced features in PostgreSQL.mp4 9.1 MB
2. Installing and Setting up PostgreSQL/1. macOS- Install PostgreSQL and PGAdmin 4.mp4 12.0 MB
2. Installing and Setting up PostgreSQL/2. macOS- Install and set up PostGIS.mp4 6.5 MB
2. Installing and Setting up PostgreSQL/3. Windows- Install PostgreSQL and PGAdmin 4.mp4 11.0 MB
2. Installing and Setting up PostgreSQL/4. Windows- Install and set up PostGIS.mp4 5.7 MB
3. Working with Geospatial Data/1. Spatial data analysis using PostGIS.mp4 9.6 MB
3. Working with Geospatial Data/10. Computing locations within a distance and representing lines on a map.mp4 10.0 MB
3. Working with Geospatial Data/11. Importing shapefiles.mp4 10.0 MB
3. Working with Geospatial Data/2. The WKT and WKB format.mp4 2.7 MB
3. Working with Geospatial Data/3. Geometry and geography data types.mp4 5.3 MB
3. Working with Geospatial Data/4. Spatial reference systems.mp4 4.1 MB
3. Working with Geospatial Data/5. Creating a table to hold geometry types.mp4 8.8 MB
3. Working with Geospatial Data/6. Working with basic geometry types.mp4 10.8 MB
3. Working with Geospatial Data/7. Extracting coordinate values computing length and area.mp4 8.6 MB
3. Working with Geospatial Data/8. Representing real-world data.mp4 16.6 MB
3. Working with Geospatial Data/9. Computing the distance between locations.mp4 10.3 MB
4. Performing Full-Text Search Operations/1. Full-text search.mp4 9.9 MB
4. Performing Full-Text Search Operations/2. Basic text search using LIKE and ILIKE.mp4 5.8 MB
4. Performing Full-Text Search Operations/3. Tsvector and tsquery.mp4 3.8 MB
4. Performing Full-Text Search Operations/4. Performing a full-text search using the @@ operator.mp4 5.5 MB
4. Performing Full-Text Search Operations/5. Using logical operations in search terms.mp4 6.3 MB
4. Performing Full-Text Search Operations/6. Performing a search using a different language.mp4 7.7 MB
4. Performing Full-Text Search Operations/7. Controlling search parameters.mp4 10.9 MB
4. Performing Full-Text Search Operations/8. Ranking search results.mp4 9.0 MB
4. Performing Full-Text Search Operations/9. Creating and using dictionaries.mp4 8.3 MB
5. Creating and Managing Triggers/1. Introducing triggers.mp4 5.7 MB
5. Creating and Managing Triggers/2. Trigger execution order.mp4 2.0 MB
5. Creating and Managing Triggers/3. Creating a row-level after insert trigger.mp4 10.3 MB
5. Creating and Managing Triggers/4. Creating a row-level after update trigger.mp4 9.5 MB
5. Creating and Managing Triggers/5. Creating a statement-level trigger.mp4 9.7 MB
6. Defining and Launching Transactions/1. Transactions and transaction isolation levels.mp4 9.7 MB
6. Defining and Launching Transactions/2. Creating and committing transactions.mp4 6.1 MB
6. Defining and Launching Transactions/3. Rolling back transactions.mp4 5.5 MB
6. Defining and Launching Transactions/4. Rolling back committed transactions.mp4 4.9 MB
6. Defining and Launching Transactions/5. Savepoints and rollbacks.mp4 5.9 MB
6. Defining and Launching Transactions/6. The read committed isolation level.mp4 5.6 MB
6. Defining and Launching Transactions/7. The repeatable read isolation level.mp4 10.1 MB
6. Defining and Launching Transactions/8. The serializable isolation level.mp4 11.8 MB
7. Conclusion/1. Summary and next steps.mp4 1.8 MB
Ex_Files_Advanced_PostgreSQL.zip 206.3 KB

Details for: Linkedin - Learning Advanced PostgreSQL

linkedin learning advanced postgresql

Similar Posts: