Postgres Database Installation Setup Guide for Beginners | Postgres Database Configuration Explaine смотреть онлайн

PostgreSQL or Postgres is the most commonly used open-source relational database. It offers features like robustness, reliability, cost-free, etc. PostgreSQL serves as a data warehouse for multiple applications like web apps, mobile apps, etc. It enables us to store enormous and sophisticated data securely. Memento Design pattern defines three roles for objects. PostgreSQL is a powerful, open-source object-relational database system with over 35 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance.

PostgreSQL is used as the primary data store or data warehouse for many web, mobile, geospatial, and analytics applications. PostgreSQL is a traditional RDBMS (relational database management system) SQL database, like Oracle and MySQL.

** Step by Step Guide to Install and setup Postgres Database **
1. Download the installation files from the following website. Appropriate for your operating system. https://www.postgresql.org/download/
2. Click on downloaded file to start postgres db installation. Initially, a "welcome" window will appear; click "Next" to proceed.
3. You can select the components of your choice to install on your computer. We will proceed with the default settings, so just click on the “Next” button.
4. Select a data directory to store your data and click on the “Next” button.
5. Set a password for the Postgres superuser and click on the “Next” button. You must remember it for later use.
6. Whether set the port number or go with the default port number “5432” to connect to a database.
7. The next window will give you choice to select locale or leave them as it is, and click on the “Next” button.
8. The pre-installation summary will tell you which settings will be used for the installation.
9. The setup is ready to install Postgres in your operating system. Just click on the “Next” button to begin the installation.
10. Once the PostgreSQL setup wizard is completed, click on the “Finish” button to close the installation windows.

** Connect Postgres Database with PGAdmin or DBeaver Database tool **
1. Open pgadmin or Dbeaver database tool.
2. In the left pane, create a connection to database by providing database url, port, database name, username, password information.
3. Click connect to connect to database.

** Chapter Timestamps **
0:00 Welcome to Postgres Database Installation Setup and Configuration
0:51 Agenda of this video
1:50 Introduction to Postgres Relational Database System
2:48 Postgres Database Architecture
5:15 Download and Install Dbeaver Database tool
5:36 Connect Dbeaver tool with Postgres Database
8:28 Create new Database connection in Dbeaver tool
10:24 Create Schema and Table in Postgres Database
12:03 Insert data in Table and fetch data using select query
13:15 Summary of Postgres Database Installation

#postgres #postgresdatabase #postgresinstallation

** Tool Download Links **
Download Postgres Database Files https://www.postgresql.org/download/
Download DBeaver Database tool https://dbeaver.io/download/

** CHECK OUT OUR OTHER VIDEOS **
Spring boot project setup: https://youtu.be/bsgA20eJKxs
Spring Boot Microservice with MongoDB Project: https://youtu.be/1HnturOhPhs
Prepare Docker file, Container and Build Image: https://youtu.be/g_pdTzjnuso
Deploy Docker Image AWS Elastic Container Service: https://youtu.be/ZlR5onuwZzw
Run MongoDB in Docker Container: https://youtu.be/r4Yl4SO1BiA

** CHECK OUR PLAYLISTS **
Spring Boot Complete Tutorial https://youtube.com/playlist?list=PL2NZAYdLkYvg_VlNmszrb-Um0wRx5yGDF
Docker Containers Complete Tutorial
https://youtube.com/playlist?list=PL2NZAYdLkYvhZQo2VTVCSug_zVjekNodi
GITHUB Repository Tutorial | Complete Guide to GITHUB for Beginners
https://www.youtube.com/playlist?list=PL2NZAYdLkYvh5inIifHYlpAX10IE3vVGS

** ABOUT OUR CHANNEL **
CodeOneDigest is a youtube channel that produces videos on programming languages, cloud and container technologies, Software design principles, Java frameworks in English and Hindi languages.

Check out our channel here:
https://www.youtube.com/channel/UC9V0QYsWKz_OD2uooCtEtRg
Don’t forget to subscribe!

** OUR WEBSITE **
https://codeonedigest.wordpress.com/

** GET IN TOUCH **
Email us on [email protected]

FOLLOW US ON SOCIAL - LIKE, SHARE & SUBSCRIBE
Get updates or reach out to Get updates on our Social Media Profiles!
Subscribe: https://bit.ly/3NeWQ8U
Youtube: https://www.youtube.com/channel/UC9V0QYsWKz_OD2uooCtEtRg
Twitter: https://twitter.com/codeonedigest
Facebook: https://www.facebook.com/codeonedigest
Instagram: https://www.instagram.com/codeonedigest/
Linkedin: https://www.linkedin.com/in/codeone-digest-10b418255/
Reddit: https://www.reddit.com/user/codeonedigest
Github: https://github.com/codeonedigest
Website: https://codeonedigest.wordpress.com/
Tumblr: https://www.tumblr.com/codeonedigest
Pinterest: https://in.pinterest.com/codeonedigest/