Learn PostgreSQL From Beginner to Intermediate

categories: Technology, Science & Productivity

Data

Technology

Data Analysis

SDG 4: Quality Education

SDG 8: Decent Work and Economic Growth

SDG 9: Industry, Innovation and Infrastructure

By the end of this course, you will be able to

What's meant by a database, how it works, the different database types and differences between them, and what is the importance of the database.
Exploring the Relational Database Management Systems (RDMS), coding SQL, categorizing SQL commands into groups, and exploring what commands each category contains.
Creating a database from scratch with tables and users, controlling database users' privileges. Then, inserting, updating, deleting, and retrieving data from a table.

Course details

2 h 15 m/40 lessons
Last updated: 9/11/2022
1 learning resources
Course completion certificate

Course Content

Free lessons

Course Introduction

2 Minutes

Introduction to Database

3 Minutes

Relational VS Non-Relational Databases

3 Minutes

Relational Database Management Systems (RDBMS)

2 Minutes

1. Getting Started

Course Introduction

2 Minutes

Introduction to Database

3 Minutes

Relational VS Non-Relational Databases

3 Minutes

Relational Database Management Systems (RDBMS)

2 Minutes

Introduction to SQL

4 Minutes

2. Necessary Software (Download/Installation)

Important Note

PostgreSQL Download and Installation

2 Minutes

How to Initiate PostgreSQL in Command Prompt

2 Minutes

Ubuntu Download and Installation

2 Minutes

PostgreSQL Package in Ubuntu

1 Minutes

3. SQL | Data Definition Language

Create Database

3 Minutes

Create table

5 Minutes

Create User

4 Minutes

SQL Constraints

2 Minutes

Data Types in PostgreSQL

4 Minutes

Practice Test 1

7 Minutes

DROP

3 Minutes

Drop User

1 Minutes

TRUNCATE

2 Minutes

10.

ALTER

8 Minutes

4. SQL | Data Control Language

GRANT

5 Minutes

REVOKE

4 Minutes

Practice Test 2

3 Minutes

5. SQL | Data Manipulation Language

INSERT

7 Minutes

DELETE

2 Minutes

DROP - TRUNCATE - DELETE Summary

1 Minutes

UPDATE

3 Minutes

SELECT

3 Minutes

Practice Test 3

2 Minutes

ALIAS

1 Minutes

Operators

1 Minutes

Comparison Operators

1 Minutes

10.

Aggregate Functions

4 Minutes

11.

DISTINCT

1 Minutes

12.

LIMIT

1 Minutes

13.

GROUP BY and HAVING

3 Minutes

14.

JOINS INTUITION

1 Minutes

15.

INNER JOIN

5 Minutes

16.

OUTER JOIN (Left, Right and Full)

4 Minutes

17.

CREATE VIEW

3 Minutes

learning resources

About this course

Data analysis requires working with a large amount of data and performing manipulation on it. If you are interested in data science and want to pursue a career in it, SQL is listed as one of the most in-demand skills in the skill set for data analyst roles, it is an easy-to-learn and robust programming language. Therefore, this course was prepared to help you learn more about SQL coding, its principles from the beginning, how it works, and its different types.

Course requirements and prerequisites

There are no requirements for this course. Your interest in the topic and your commitment to learning are all you need to achieve the utmost benefit from this course.