Learn The Basics of PostgreSQL For Beginners

Learn The Basics of PostgreSQL For Beginners, available at $39.99, has an average rating of 4.3, with 35 lectures, based on 51 reviews, and has 1252 subscribers.

You will learn about 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. This course is ideal for individuals who are Complete beginners, no prior experience is required. or Anyone want to learn PostgreSQL or Anyone want to learn relational databases and and be familiar with SQL syntax. It is particularly useful for Complete beginners, no prior experience is required. or Anyone want to learn PostgreSQL or Anyone want to learn relational databases and and be familiar with SQL syntax.

Enroll now: Learn The Basics of PostgreSQL For Beginners

Summary

Title: Learn The Basics of PostgreSQL For Beginners

Price: $39.99

Average Rating: 4.3

Number of Lectures: 35

Number of Published Lectures: 35

Number of Curriculum Items: 35

Number of Published Curriculum Objects: 35

Original Price: $34.99

Quality Status: approved

Status: Live

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.

Who Should Attend

Complete beginners, no prior experience is required.

Anyone want to learn PostgreSQL

Anyone want to learn relational databases and and be familiar with SQL syntax.

Target Audiences

Complete beginners, no prior experience is required.

Anyone want to learn PostgreSQL

Anyone want to learn relational databases and and be familiar with SQL syntax.

? 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 marketAmazon 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 PostgreSQLdo not hesitate enrolling.

Course Curriculum

Chapter 1: Introduction to PostgreSQL and Cloud Databases

Lecture 1: Introduction to The Course

Lecture 2: What is Relational Databases and PostgreSQL?

Lecture 3: Relational Databases (Article)

Lecture 4: Install PostgreSQL

Lecture 5: pgAdmin

Lecture 6: PostgreSQL (Article)

Lecture 7: PostgreSQL Database on Amazon Web Services (AWS)

Lecture 8: Amazon Web Services – AWS RDS (Article)

Lecture 9: Summary

Chapter 2: Databases, Users and Privileges In PostgreSQL

Lecture 1: Create and Drop Databases in PostgreSQL

Lecture 2: Create Users

Lecture 3: Grant Privileges

Lecture 4: Database Schemas

Lecture 5: Exercise : Create Database, Schema and User

Lecture 6: Summary

Chapter 3: Database Tables, Primary and Foreign Keys In PostgreSQL

Lecture 1: Introduction to The Chapter

Lecture 2: Database Tables

Lecture 3: Data Types

Lecture 4: Primary Keys

Lecture 5: Constraints

Lecture 6: Exercise : Create Tables Employees and Jobs

Lecture 7: Foreign Keys

Lecture 8: Exercise : Create Table Previous Experience

Lecture 9: Import Data Into Database

Lecture 10: Exercise : Import Data (Employees and Cities)

Lecture 11: Entity Relationship Diagram (ERD) – DbVisualizer

Lecture 12: Summary

Lecture 13: The Final Lecture

Chapter 4: Questions and Answers

Lecture 1: Part 1 (Questions 1 to 5)

Lecture 2: Part 2 (Questions 6 to 10)

Lecture 3: Part 3 (Questions 11 to 15)

Lecture 4: PostgreSQL 12 Features

Chapter 5: BONUS SECTION

Lecture 1: BONUS LECTURE : Install SQL Server

Lecture 2: BONUS LECTURE : Management Studio

Lecture 3: BONUS LECTURE : SQL Server Database on Microsoft Azure

Instructors

Ahmad Mohey
Software Developer & DevOps Engineer

Rating Distribution

1 stars: 1 votes

2 stars: 0 votes

3 stars: 8 votes

4 stars: 21 votes

5 stars: 21 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!