Checklist

Certification

You will get a certificate on completing this course.

University

This course is not affiliated with any university.

Price

This course costs very less.

Edvicer's Rewards

You can get a cashback of ₹ 100 on buying this course.

The PostgreSQL Document Database

The PostgreSQL Document Database

1425/month
Start anytime
Self paced
English
Course by
PluralsightCourses from Pluralsight
Certificate awarded
Advanced
Login to earn ₹ 100

Limited Time Discount Offers

Save your money with Edvicer. Check out our premium courses with discount offers.

Discount offers - Edvicer

Limited Time Discount Offers

Save your money with Edvicer. Check out our premium courses with discount offers.

Map your Career

Not sure which job profiles this course will open for you? Check out our AI based tool to get a complete personalized career map.

Career Mapper - Edvicer

Map your Career

Not sure which job profiles this course will open for you? Check out our AI based tool to get a complete personalized career map.

Checklist

Certification

You will get a certificate on completing this course.

University

This course is not affiliated with any university.

Price

This course costs very less.

Edvicer's Rewards

You can get a cashback of ₹ 100 on buying this course.

Why should you choose this course?

Description

PostgreSQL is a powerful relational engine - but did you know you can make it just as flexible and exciting as MongoDB, CouchDB, or RethinkDB? With the new jsonb data type, PostgreSQL has the ability to be a full-fledged document data store.

Syllabus

Introduction
PostgreSQL vs Others
Thinking in Documents
JSON and JSONB
Selectors
The Sample Database
JSON Creation Functions
Building Documents from Data
Data Validation
JSON Processing Functions
The Existence Operator
The Containment Operator
Fuzzy Matches
Indexing
JSONB and PLV8
The Document Table
Create Document Table Function
Save Document Function
Update Search Function
Bulk Save
Find by ID Function
Find by Criteria Function
Filter Function
Search Function
Querying Postgres
Save Document
Bulk Save
Find by ID
Find by Criteria
Filter
Getting Set up with Xamarin
Querying Postgres with Npgsql
Save Document
Find by Id
Bulk Save
Find
Filter and Search
Review of the Sample Data
Sample Data Import
Average Album Price
Sales Facts
Album Sales
Co-occurrence
Co-occurrence Function
Co-occurrence Rollup

What others say about this course

FAQs

What is PostgreSQL?

PostgreSQL is a powerful object-relational database system. It is open-source and runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), and Windows. It supports text, images, sounds, and video, and includes programming interfaces for C / C++, Java, Perl, Python, Ruby, Tcl and Open Database Connectivity (ODBC). It is developed by a worldwide team of volunteers and is not an entity of any corporation.

Does Postgres use SQL?

No, it is an advanced version of SQL, which provides support to different functions of SQL like foreign keys, subqueries, triggers, and different user-defined types and functions

What is the difference between MySQL and PostgreSQL?

MySQL is a relational database management system, whereas PostgreSQL is an object-relational database management system. MySQL is not extensible and does not provide the Data Domain Object. PostgresSQL is highly extensible and provides the Data Domain Object.

Is PostgreSQL free to use?

Yes, PostgreSQL is free, and code is available to use for everyone. It allows users to do anything they want with the code, including reselling binaries without the source code; thus, its free for all users, both proprietary and open source.

Is PostgreSQL a NoSQL database?

Yes, PostgreSQL, like many other RDBMS, has added support for JSON data, which is the most popular format for semi-structured data commonly stored in NoSQL systems.

Is PostgreSQL worth learning?

Yes, it offers the following advantages: 1. Open Source DBMS: provides enterprise-class performance and functions among current Open Source DBMS with no end of development possibilities. 2. Diverse Community: there exists a wide variety of communities. 3. Support for Languages: supports languages like PL/pgSQL, PL/Python, PL/Perl, C/C++, and PL/R. 4. ACID and Transaction: supports Atomicity, Consistency, Isolation, Durability (ACID). 5. Diverse indexing techniques: supports techniques like B+ tree index, Generalized Inverted Index (GIN) and GiST(Generalized Search Tree)

What are the top jobs that I can get from learning PostgreSQL?

The top job profiles for PostgreSQL experts are Python Developer with an average salary of INR 4 LPA, Database Administrator with an average salary of INR 7 LPA, and Web developer with an average salary of INR 6 LPA. Get your career map for your skills here.

What can I learn after learning PostgreSQL?

After learning PostgreSQL, the top skills you can learn to open highest number of job profiles for you are MySQL, AWS, and Database Design. The top skills that can get you jobs with highest salaries are Database Design, Linux, and Mongodb

Write your review of The PostgreSQL Document Database

Facebook account of EdvicerLinkedin account of EdvicerInstagram account of Edvicer
Twitter account of EdvicerPinterest account of EdvicerYoutube account of Edvicer