PostgreSQL Databases & Python

Course Curriculum

Chapter 1: Introduction

Lecture 1: What you will learn in this class?

Chapter 2: Data Storage and Usage in Python

Lecture 1: Introduction

Lecture 2: Store and read Data in Python with text files

Lecture 3: Store and read Data in Python with excel files: pandas

Lecture 4: What is a Database and what are the use cases?

Lecture 5: What are the different Linux databases?

Lecture 6: Why use databases ?

Chapter 3: PostgreSQL Databases

Lecture 1: Install PostgreSQL on Debian Linux , and start database

Lecture 2: Create and Delete Users

Lecture 3: Create and Delete Databases

Lecture 4: Dump and Restore Databases

Chapter 4: SQL commands

Lecture 1: SQL commands: Introduction

Lecture 2: CREATE/DROP TABLE

Lecture 3: PRIMARY KEY

Lecture 4: INSERT INTO

Lecture 5: SELECT

Lecture 6: UPDATE

Lecture 7: DELETE

Lecture 8: CREATE/DROP INDEX

Lecture 9: SELECT DISTINCT

Lecture 10: ORDER BY

Lecture 11: GROUP BY

Lecture 12: BETWEEN

Lecture 13: JOIN

Lecture 14: LIMIT

Lecture 15: EXISTS

Lecture 16: FOREIGN KEY

Lecture 17: GRANT

Lecture 18: COUNT

Lecture 19: MAX, MIN ,AVG

Lecture 20: SUM

Lecture 21: SQL SUBQUERY

Chapter 5: Databases for Web Hosting

Lecture 1: Introduction

Lecture 2: Install and Setup your LAPP stack ( Linux Apache PostgreSQL Php) on the cloud

Lecture 3: Interacting with the Database

Chapter 6: Python and Postgresql with psycopg2

Lecture 1: Connect to Database with python psycopg2

Lecture 2: Write changes to Database

Lecture 3: Read data from Database

Lecture 4: Passing parameters to SQL queries