PostgreSQL is commonly known as Postgres and is is often referred to as a the world's most advanced open source database. In this course, we will go over the basics of the PostgreSQL. We will cover topics ranging from installations, to writing basic queries and retrieving data from tables. We will also explore the logic of join, and a few best practices.
Installation and Configuration Hi. This is Pinal Dave, and welcome to the course of PostgreSQL: Getting Started. This is the very first module, and in this module we will introduce PostgreSQL and learn about various resources related to PostgreSQL. Before we end this module we will install and configure PostgreSQL. Trust me. Installation of PostgreSQL is an extremely easy process. Well, let's start talking about PostgreSQL.
PostgreSQL: Creating and Accessing Database Tables Hi. This is Pinal Dave, and in this module we will discuss about creating and accessing database tables in Postgres. In the last module we learned a brief history of Postgres. Right after that we installed and configured Postgres. Additionally, we also wrote our very first SELECT statement. And in this module we are going to learn about how to create database and database tables. We will also learn how to populate data in table, as well as we will see various options to restore database. We will understand this module with the help of a simple real-world scenario. Let's understand that in the next clip.
PostgreSQL: Data Operations - Select, Update, Delete Hi. This is Pinal Dave, and welcome to Postgres: Data Operations SELECT, UPDATE, and DELETE. In the last module we restored sample database to Postgres. Right after that with the help of pgAdmin III we created table schema. We also exported data from database table and imported it in another table. In this module we are going to take our understanding of Postgres to the next level. We will first understand the basic structure of the SELECT statement, and right after that we will see how we can use the basic structure of the SELECT statement to update, as well as insert data in database tables. We will also see how to delete data from database table. For this we will use again real-world scenarios. The scenario is very simple. We will use the same individuals which we use in the previous module. We have Rahul and Mike. Rahul is senior database administrator, and Mike is junior database administrator. Between them we will recreate various scenarios from the real world. Let's start with our very first scenario.
PostgreSQL: Database Joins Retrieving Data From Multiple Tables Hi. This is Pinal Dave, and welcome to the module of Postgres: Database Joins. In this module we will be focusing on retrieving data from multiple tables. In the last module we explored the basics of the SELECT statement. Right after that we understood how to update and insert data into a table. Right after that we learned how to delete data from a table. Well, SELECT, UPDATE, INSERT, and DELETE are basic fundamental operations of SQL. In this module we are going to learn how to retrieve data from multiple tables. For that first we have to understand the basics of Join. We will be learning various different kinds of joins in this module. First we will explore Inner Join, and right after that we will understand Outer Join. There are three different kinds of Outer Join, Left Outer Join, Right Outer Join, and Full Outer Join. Once we understand Inner and Outer Join, we will further understand Cross Join, which is commonly known as Cartesian Join. Well, just like all other modules we will be learning all these concepts with the help of real-world scenarios. This time the scenario is a little bit different from what we have seen in previous modules. Let's understand that in the next clip.