When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.
Learn The Basics of PostgreSQL For Beginners
The practical guide to learn the basics of PostgreSQL and pgAdmin for beginners.
This Course Includes
udemy
4.3 (52 reviews )
2h 56m 
english
Online - Self Paced
professional certificate
Udemy
About Learn The Basics of PostgreSQL For Beginners
Welcome to
Learn The Basics of PostgreSQL
course, The practical guide to learn the basics of PostgreSQL and pgAdmin.
PostgreSQL is a powerful, open source object-relational database system
with over 30 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance.
Learning PostgreSQL is one of the best ways to boost your career!
As it is getting popular each day and many giant companies are using PostgreSQL as a relational database. This course will
start with you from zero level experience in PostgreSQL
and relational databases
, starting to level up as we are going through the course.
explaining all the questions you maybe asking yourself such as
What is a PostgreSQL? what is relational database? what is a cloud database?
This course will
guide you how to install PostgreSQL on a local machine step by step
and even how to
create your own cloud databases
on the one of the most required cloud services providers in the market...
Amazon Web Services (AWS).
You will learn what is meant by concepts like
DBaaS and
Amazon Relational Database Service (RDS)
Some of the points we will be covering :
How to
install the PostgreSQL.
How to
install and use pgAdmin.
Create databases with PostgreSQL.
Understand
what is schema and how to create a schema
.
How
create tables using SQL script.
How to create tables using pgAdmin.
Use
different datatypes
available in PostgreSQL.
How to create views.
Understand what does
DBaaS mean.
You will learn how to
create users to access your database based on specific permissions you gave them.
How to
create different constraints.
Create primary keys in PostgreSQL.
Create foreign keys in PostgreSQL.
How to
import a bulk of data
in and out of your database.
Generate
Entity Relationship Diagram (ERD)
using another powerful tool called
DbVisualizer.
Give your CV a huge boost by learning PostgreSQL...do not hesitate enrolling.
What You Will Learn?
- Install PostgreSQL and pgAdmin. .
- Understand basics of cloud databases. .
- Understand basics of PostgreSQL. .
- Create PostgreSQL database instances on Amazon Web Services (AWS). .
- Connect pgAdmin to cloud database (AWS). .
- Create PostgreSQL databases and schemas. .
- Create and manage users in PostgreSQL. .
- Create tables using SQL script. .
- Create tables using pgAdmin. .
- Learn about different data types available in PostgreSQL. .
- Understand Constraints and how to apply them. .
- Create primary keys and foreign keys. .
- Design relational databases and create relationships between tables in PostgreSQL. .
- Generate Entity Relationship Diagram (ERD). .
- Import and Export Data using pgAdmin. .
- Using a powerful tool called DbVisualizer. .
- How to grant privileges in PostgreSQL. Show moreShow less.