All language subtitles for Introduction To PostgreSQL.en_US

In this particular lecture.

Let's go ahead and let's have a brief introduction to PostgreSQL.

So what exactly is PostgreSQL or PostgreSQL.

So PostgreSQL or Postgres is a powerful open source relational database management system.

So let's dissect this statement.

So Postgres is powerful meaning that using Postgres you could build some really complex web applications.

And Postgres as a database management system could support those applications.

Well, therefore it's a powerful system.

It's open source, meaning that it's actually free to use.

And it's a relational database management system.

That means it supports tables and allows us to have relationship between those database tables.

Now remember that PostgreSQL is not a database, it's actually a database management system.

So it's essentially like a software which allows us to create and manage databases.

However, to keep things simple, we say that Postgres is a database.

It's a popular choice for small scale applications to large scale projects.

So if you are a startup which wants to build a small application for its users, you could use Postgres.

And if you want to build large scale, enterprise level production apps in that particular case as well,

you could go ahead and make use of the Postgres database.

So no matter what kind of a software you're building, if you're building small scale applications or

a large enterprise application, Postgres suits all needs.

Postgres is open source, meaning the source code for Postgres is available for free and it can be widely

used, modified and distributed.

So you could also create your very own flavor of Postgres database management system, and you could

distribute it and also use it in your very own projects as well.

The next thing about Postgres is that it's an object relational database.

So what exactly do we mean by an object relational database.

So a traditional database only supports simple data types like integers, strings, numbers, floats,

etc. that means you could go ahead and store integer values, strings, floating point numbers, so

on and so forth.

However, in an object relational database system, you could also go ahead and create your very own

complex data types as well.

Or you could basically go ahead and have user defined data types, and then you could save the data

of those types into your database.

So essentially in an object relational database management system you could go ahead and save objects

as well.

Now along with this object relational databases also include the ability to have object oriented programming

features such as classes, encapsulation and inheritance.

Now such object relational databases are specifically useful when dealing with apps which have a complex

data structure and relationships.

So that means if you are building a modern application wherein you need to go ahead and have some really

complex objects, and you also need to establish a relation between those particular objects.

In that particular case, you could go ahead and make use of Postgres, and on top of it, you could

also go ahead and make use of the Structured Query language whenever you have to manipulate that data.

So I hope this kind of gave you an idea about what exactly Postgres is and what are its different features.

So in order to understand Postgres in a much more better way, let's download and install Postgres on

our machine.

So in the next lecture let's go ahead and let's learn how to install Postgres on a windows machine.

And in the lecture next to that one let's learn how to set it up on a mac.

So thank you very much for watching and I'll see you in the next one.