PostgreSQL Tutorial for Data Analysis and Administration

Learn Basics of PostgreSQL for Database Administration and Data Anlaysis .

4.05 (10 reviews)
Udemy
platform
English
language
Other
category
PostgreSQL Tutorial for Data Analysis and Administration
44
students
6.5 hours
content
Jun 2020
last update
$19.99
regular price

What you will learn

Using PostgreSQL for Management and Administration of Databases

Creating Databases for Organizations or Applications

Data Analysis using PostgreSQL Queries

Create, Read, Update and Delete Records in a Database

Description

Syllabus of the Course


Lecture 1: Introduction and Installation of PostgreSQL

Lecture 2: Creating First Database and First Table using UI in PostgreSQL

Lecture 3: PostgreSQL creating a Database using SQL query

Lecture 4: Primary Key Constraint and Setting it on already created table

Lecture 5: Inserting Records in PostgreSQL using Queries

Lecture 6: Updating Records in PostgreSQL

Lecture 7: Deleting Records in PostgreSQL AND and OR Operators

Lecture 8: Importing an External Database in PostgreSQL from SQL Code

Lecture 9: Comparison Operators in PostgreSQL with Where Clause

Lecture 10: Comparison and Logical Operators Together in PostgreSQL With Where Clause

Lecture 11: Between Operator in PostgreSQL with WHere Clause

Lecture 12: IN and NOT IN with Where Clause in PostgreSQL

Lecture 13: LIKE Operator for Pattern Matching in PostgreSQL

Section 2: Multiple Schools Management System Database Example

Lecture 14: Creating Multiple School Management System DB in PostgreSQL

Lecture 15: Concept of Foreign Key and FK Constraint in PostgreSQL

Lecture 16: Creating students table with 2 foreign keys in database using Postgresql

Lecture 17: Inserting dummy values in tables and testing foreign key constraint

Lecture 18: Joins in PostgreSQL - Inner, Left, Right, Full

Section 3: Deleting or Dropping Databases and Columns

Lecture 19: How to Delete or Drop Database in PostgreSQL

Lecture 20: Dropping Regular Columns and those with Foreign Key Constraint

Section 4: Stored Procedures or Functions

Lecture 21: Variables in PostgreSQL

Lecture 22: Functions or Stored Procedures in PostgreSQL - Part 1

Lecture 23: Functions or Stored Procedures in PostgreSQL - More Examples

Lecture 24: Views in PostgreSQL

Section 5: Misc

Lecture 25: Aggregate Functions in PostgreSQL

Lecture 26: GROUP BY in PostgreSQL for Data Analysis

Content

Introduction

Introduction and Installation of PostgreSQL
Creating First Database and First Table using UI in PostgreSQL
PostgreSQL creating a Database using SQL query
Primary Key Constraint and Setting it on already created table
Inserting Records in PostgreSQL using Queries
Updating Records in PostgreSQL
Deleting Records in PostgreSQL AND and OR Operators
Importing an External Database in PostgreSQL from SQL Code
Comparison Operators in PostgreSQL with Where Clause
Comparison and Logical Operators Together in PostgreSQL With Where Clause
Between Operator in PostgreSQL with WHere Clause
IN and NOT IN with Where Clause in PostgreSQL
LIKE Operator for Pattern Matching in PostgreSQL

Multiple Schools Management System Database Example

Creating Multiple School Management System DB in PostgreSQL
Concept of Foreign Key and FK Constraint in PostgreSQL
Creating students table with 2 foreign keys in database using Postgresql
Inserting dummy values in tables and testing foreign key constraint
Joins in PostgreSQL - Inner, Left, Right, Full

Deleting or Dropping Database and Columns

How to Delete or Drop Database in PostgreSQL
Dropping Regular Columns and those with Foreign Key Constraint

Stored Procedures or Functions

Variables in PostgreSQL
Functions or Stored Procedures in PostgreSQL - Part 1
Functions or Stored Procedures in PostgreSQL - More Examples
Views in PostgreSQL

Misc

Aggregate Functions in PostgreSQL
GROUP BY in PostgreSQL for Data Analysis

Charts

Price

PostgreSQL Tutorial for Data Analysis and Administration - Price chart

Rating

PostgreSQL Tutorial for Data Analysis and Administration - Ratings chart

Enrollment distribution

PostgreSQL Tutorial for Data Analysis and Administration - Distribution chart
3195970
udemy ID
6/2/2020
course created date
6/20/2020
course indexed date
Bot
course submited by