Advanced PostgreSQL
With Janani Ravi
Liked by 333 users
Duration: 2h 20m
Skill level: Advanced
Released: 4/21/2023
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.
Skills you’ll gain
Earn a sharable certificate
Share what you’ve learned, and be a standout professional in your desired industry with a certificate showcasing your knowledge gained from the course.
LinkedIn Learning
Certificate of Completion
-
Showcase on your LinkedIn profile under “Licenses and Certificate” section
-
Download or print out as PDF to share with others
-
Share as image online to demonstrate your skill
Meet the instructor
Learner reviews
-
Hansif P P
Hansif P P
Associate SDE @ISW Ex-Intern @Intel
-
Nachito Atilano
Nachito Atilano
Notary Signing Agent @ Notorious Notaries | Computer Science Degree
-
Vamsi Nagesh P.
Vamsi Nagesh P.
Data Analyst | Business Analytics | Data Science | Python | SQL | Tableau | PowerBI|Sybase|MS SQL Server
Contents
What’s included
- Practice while you learn 1 exercise file
- Learn on the go Access on tablet and phone