Postgresql Tutorial For Data Analysis And Administration

Learn Basics of PostgreSQL for Database Administration and Data Anlaysis .

What you'll 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
Requirements
Basic understanding of databases
Description
Syllabus of the Course Lecture 1: Introduction and Installation of PostgreSQLLecture 2: Creating First Database and First Table using UI in PostgreSQLLecture 3: PostgreSQL creating a Database using SQL queryLecture 4: Primary Key Constraint and Setting it on already created tableLecture 5: Inserting Records in PostgreSQL using QueriesLecture 6: Updating Records in PostgreSQLLecture 7: Deleting Records in PostgreSQL AND and OR OperatorsLecture 8: Importing an External Database in PostgreSQL from SQL CodeLecture 9: Comparison Operators in PostgreSQL with Where ClauseLecture 10: Comparison and Logical Operators Together in PostgreSQL With Where ClauseLecture 11: Between Operator in PostgreSQL with WHere ClauseLecture 12: IN and NOT IN with Where Clause in PostgreSQLLecture 13: LIKE Operator for Pattern Matching in PostgreSQLSection 2: Multiple Schools Management System Database ExampleLecture 14: Creating Multiple School Management System DB in PostgreSQLLecture 15: Concept of Foreign Key and FK Constraint in PostgreSQLLecture 16: Creating students table with 2 foreign keys in database using PostgresqlLecture 17: Inserting dummy values in tables and testing foreign key constraintLecture 18: Joins in PostgreSQL - Inner, Left, Right, FullSection 3: Deleting or Dropping Databases and ColumnsLecture 19: How to Delete or Drop Database in PostgreSQLLecture 20: Dropping Regular Columns and those with Foreign Key ConstraintSection 4: Stored Procedures or FunctionsLecture 21: Variables in PostgreSQLLecture 22: Functions or Stored Procedures in PostgreSQL - Part 1Lecture 23: Functions or Stored Procedures in PostgreSQL - More ExamplesLecture 24: Views in PostgreSQLSection 5: MiscLecture 25: Aggregate Functions in PostgreSQLLecture 26: GROUP BY in PostgreSQL for Data Analysis

Overview

Section 1: Introduction

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 Database 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

Beginner Developers Curious to Learn PostgreSQL for projects or Job,Beginners who want to learn PostgreSQL for Data Analysis