PostgreSQL Tutorial for Beginners 2026 — Day 1 | Database, DBMS, RDBMS & SQL Explained

Hello, what's up, guys? Finally, a brand-new series is going to start on PostgreSQL. And I'm super excited, and I hope you're just as excited too. And I know you must be having a question in your mind The era of AI has arrived, so why should we learn anything? So I would like to tell you that even if AI is giving you queries What guarantee can you provide that the query is absolutely correct? It's the most recent up-to-date query What if it says Postgres and gives MySQL? There are many such things; at the very least, you know the basics. And guys, this is the main reason why, at this time You have to understand this concept of database, backend, and frontend. So that when you use AI, you can determine whether the answer is correct or not. That's why when it comes to the Postgres database So guys, this is the world's most advanced open-source relational database. I will tell you everything in this video Don't worry, guys, in today's video I am going to cover our introduction and installation. And I have kept the introduction in such a way that I will assume That you know nothing, and we will start from the very basics First of all, what is a database? Then what is DBMS? Then what is RDBMS? Then what is a Non-Relational Database Management System? Then what is SQL? What is MySQL? What is PostgreSQL? Once you know these things, it will be very easy for you. Alright, guys, let's get the video started without any delay. But before that, if you haven't subscribed to the channel yet, please do so. And guys, the like target for this video is only 500 likes. So first of all, let's see what a database is? So here you can see what a database is? It is a collection of actual data stored in an organized manner. So what is the simple meaning of this? The simple meaning of this is that you have a lot of data. You have stored it in an organized manner. So what has become your database? Now, if we talk about some examples Like when we talk about collections of data Like the student's record Like when you go to school In school, we have different classes, Section A and Section B. So there are so many students in section A. So they must have kept their records in one place. So that's the collection of data Likewise, user accounts Now it can be any user account of any application Orders in an e-commerce app When you place some orders in an e-commerce app So that is also your data So see what is written here The actual stored data In the database, you hold this Which data is actually stored and kept Simply understand it like this You know the data. Whatever you see is data. You must have heard of a base many times. Like if I give an example of the army So the army has its own base. They have their own barracks. And they have their own base. They have their own bases in different areas. Where they are living together Similarly, when the data is living together In an organized way So you can understand it as a database Data collection Stored in an organized manner This is your database And don't worry, I'll show you the entire life Who do you call a database? And who you can call a database Now what is DBMS? If you see here There is a DB here There is a database here. But we have something called a management system. Now this database was fine But what is this management system? Let's see it here So we can clearly see here That this is a software DBMS That is(Notification) software Which helps you to create Manage and access database This is it See this Database we know Collection of actual data Now the data which you have collected Like Take this data This is my data Now I want a pink color Marker or whatever So I will need something Which one is pink? Do you understand? This is a software With which you can create data You can handle it. And you can access it For now, I want to access it. So here you have to provide a query But this is it Database, actual collection of data DBMS means this is a software system. With which you can Create database You can access it. You can read it. You can do everything. How it helps you In storing data In updating data In deleting data And many other things Example You must finally be thinking Yes, a DBMS is software. Which software The one you are using Is DBMS In broad terms MySQL is your database management system. With which you used to Create database The database has been created. PostgreSQL MongoDB SQLite The database has been created. You must finally be thinking Why I didn't provide an example But why didn't I give it a name? Because it is not there You will create it. In MySQL Let's say you created a database of a student Or When you go to book a movie Movie database E-commerce database Product database We create it With the help of a database management system This is your DBMS Now let's see RDBMS There is no difference. Like DBMS Database management system It is the same. The only difference is This part Relational The only difference is Relational This is an extra word Here you can see RDBMS Is a special type of DBMS Or you can say A DBMS has some subtypes. With which you can Improve it As we said A DBMS is a software system. It's like software. With the help of which you can Create, access, manage, query We saw examples. MySQL, Postgres In detail In depth If we separate it One of them is RDBMS It is a DBMS. It is a software. The only difference is This type of software When data is stored It is stored in the form of Table This is the difference Here we are talking about relationship. Means tables There will be a relationship. When they will create data It will be in the form of a table There will be rows, columns There will be a relationship. That's it When they are creating a database When they are storing data When they are creating In the form of tables In the form of a relationship That's your RDBMS Stored data in tables Arranged in rows and columns Uses relationship between tables What are the key features? It uses SQL Oh my God What is SQL? I will tell you Relationship support between tables Has primary keys and foreign keys Transaction You will receive many things So you know If you Different Common property If you separate it You will get RDBMS And the second one Non-relational database management system What is MongoDB I didn't put it here Because we are looking at Postgres But I told you If you separate it further You will get RDBMS And non-RDBMS What is happening When you store data in tables Non-relational database management system You must have heard the name. That's MongoDB Key-value pairs You store data in a database. I mean database data I hope you know now Database and DBMS Now you know RDBMS Let's go further Example User table This is ID and name absorbs This is the table of orders User ID links to order User ID Has relationship with user table That relationship What makes it between the tables You can't see See here Relationship between tables That relationship Create our database management system Relational database management system Simple Let's move on. Finally I showed you SQL The key feature is SQL What is SQL? MySQL PostgreSQL What is SQL? Structured Query Language Hold this When you want to talk to a database It has a language. SQL The language of databases When we create a website HTML We display content using HTML We perform styling through SQL CSS JavaScript is a programming language. It is used in the frontend Now it is used in the backend. MongoDB SQL is a language. Hold this Used to communicate with databases Like insert data Read, update, delete SQL is not a database software. It is a language. Keep this in mind It is not a programming language. It is a language. Through which you communicate With database I want to insert data You will use SQL Finally, what is PostgreSQL? See What is this? SQL is here I don't need to say PostgreSQL is a software Through which you can create, manage, and access databases It is advanced. Open source See It is advanced. Open source It uses SQL to manage relational databases. It is important for you It uses SQL See It is a software. What is it? It is a software. It has a language. To create a database PostgreSQL It requires the assistance of SQL So that it can query Simple PostgreSQL is a software We will use this language To create a database Create tables Insert data This is PostgreSQL It is a powerful database system. For storing and organizing Structured information This is it I think You have understood everything. PostgreSQL Whenever we talk about databases Today we know It is a software. It uses the SQL language To create a database We call it RDBMS Because it stores data In the form of tables We have a relationship. That's why it falls under DBMS only PostgreSQL is a DBMS software If you want to go further You can call it RDBMS Simple For you Tell me in the comment section Where does PostgreSQL fit? Where is it? Is it a DBMS? Or RDBMS Non-relational database management system Where does it fit? Let's go to the next slide. It is a special kind of database software. We have the first database. Then DBMS If there is no database, what will you do with the software? Who will you manage? It is like If there is no food, you call for food. Bring food Database The data itself DBMS Software to manage databases What is it? What is RDBMS? It is a software for managing databases. With relational table PostgreSQL is a specific RDBMS Alright A simple example Excel vs PostgreSQL You can use Excel as a database. Why Let me tell you Both Store data in rows and columns Both store data in rows and columns But PostgreSQL adds relationship Between tables It is different. It establishes a relationship between tables. Excel Microsoft Excel Excel Rows Columns Basically Columns Records Columns Fields PostgreSQL Between tables We have a relationship. You can see In yellow What is it? It is yours Rows You can see a specific field. It is You can see a specific field. It is What do we call it? We call it Simple column You can call it field. This is yours Row This These are your columns I don't need to say Complete Rows and columns What do we call it? Let me tell you This is your table When you use PostgreSQL We store data there In the form of table This is your table Let me show you. By the way Excel Same Columns It is not a technique. PostgreSQL When we talk about columns Their type is common. When we talk about names So in this film, you'll see, you'll only see the name It also falls within a string data type. Next, we will look at data types It happened right here. When we talk about age A is a number, so here You will see that a similar data type What is the column that is Holds it tightly, keeping it close to himself If only we could see it then I'm looking at the first row. This is your first row. If we take the data from the first row If we look here, I can see it The type is different. Van again Binod again 23 Van Record means numbers as well I can't even write this, what kind of name is this? You're not getting it, are you? I'm just trying to tell you something, and you're not even listening. That's all. So, Gais, this was your introduction to PostgreSQL SQL And I told you already that I'll also show you the installation, but I think To fully understand the basics And if you had even better examples To explain this Please make sure to let me know by commenting I will be very sorry. And I hope that finally These were the keywords for the database SQL DBMS And your DB What all this was about will finally become clear today will be If you understand the basics If it doesn't seem so for you You will go first, for the first time So, this is all you need to learn for today. It is very important. For the video today How did he do it in the system? I'll make a ser with the friends. And we have an at-like subscriber You haven't subscribed yet Please do give me a like, I'll see you in the next video. The cow that gave milk, I thought, was very helpful.