| 1. Advanced features in PostgreSQL.mp4 | 9.1 MB | ||
| 1. Full-text search.mp4 | 9.9 MB | ||
| 1. Introducing triggers.mp4 | 5.7 MB | ||
| 1. Spatial data analysis using PostGIS.mp4 | 9.6 MB | ||
| 1. Summary and next steps.mp4 | 1.8 MB | ||
| 1. Transactions and transaction isolation levels.mp4 | 9.7 MB | ||
| 1. macOS- Install PostgreSQL and PGAdmin 4.mp4 | 12 MB | ||
| 10. Computing locations within a distance and representing lines on a map.mp4 | 10 MB | ||
| 11. Importing shapefiles.mp4 | 10 MB | ||
| 2. Basic text search using LIKE and ILIKE.mp4 | 5.8 MB | ||
| 2. Creating and committing transactions.mp4 | 6.1 MB | ||
| 2. The WKT and WKB format.mp4 | 2.7 MB | ||
| 2. Trigger execution order.mp4 | 2 MB | ||
| 2. macOS- Install and set up PostGIS.mp4 | 6.5 MB | ||
| 3. Creating a row-level after insert trigger.mp4 | 10.3 MB | ||
| 3. Geometry and geography data types.mp4 | 5.3 MB | ||
| 3. Rolling back transactions.mp4 | 5.5 MB | ||
| 3. Tsvector and tsquery.mp4 | 3.8 MB | ||
| 3. Windows- Install PostgreSQL and PGAdmin 4.mp4 | 11 MB | ||
| 4. Creating a row-level after update trigger.mp4 | 9.5 MB | ||
| 4. Performing a full-text search using the @@ operator.mp4 | 5.5 MB | ||
| 4. Rolling back committed transactions.mp4 | 4.9 MB | ||
| 4. Spatial reference systems.mp4 | 4.1 MB | ||
| 4. Windows- Install and set up PostGIS.mp4 | 5.7 MB | ||
| 5. Creating a statement-level trigger.mp4 | 9.7 MB | ||
| 5. Creating a table to hold geometry types.mp4 | 8.8 MB | ||
| 5. Savepoints and rollbacks.mp4 | 5.9 MB | ||
| 5. Using logical operations in search terms.mp4 | 6.3 MB | ||
| 6. Performing a search using a different language.mp4 | 7.7 MB | ||
| 6. The read committed isolation level.mp4 | 5.6 MB | ||
| 6. Working with basic geometry types.mp4 | 10.8 MB | ||
| 7. Controlling search parameters.mp4 | 10.9 MB | ||
| 7. Extracting coordinate values computing length and area.mp4 | 8.6 MB | ||
| 7. The repeatable read isolation level.mp4 | 10.1 MB | ||
| 8. Ranking search results.mp4 | 9 MB | ||
| 8. Representing real-world data.mp4 | 16.6 MB | ||
| 8. The serializable isolation level.mp4 | 11.8 MB | ||
| 9. Computing the distance between locations.mp4 | 10.3 MB | ||
| 9. Creating and using dictionaries.mp4 | 8.3 MB | ||
| Ex_Files_Advanced_PostgreSQL.zip | 206.3 KB | ||
| ▲ 40 total files | |||
Quote:
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.
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 2.7 GB | freecoursewb | 1 week | 0 | 0 | |
| 2 GB | freecoursewb | 2 weeks | 0 | 0 | |
| 1.5 GB | freecoursewb | 3 weeks | 0 | 0 | |
| 1.4 GB | freecoursewb | 1 month | 4 | 2 | |
|
Linkedin - AWS Certified Advanced Networking Specialty ANS-C01 Cert Prep Posted by
xHOBBiTx in Other
|
3 GB | xHOBBiTx | 5 months | 16 | 6 |
All Comments