PostgreSQL Tutorial for Data Analysis and Administration
Learn Basics of PostgreSQL for Database Administration and Data Anlaysis .
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
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
Who Should Attend!
- Beginner Developers Curious to Learn PostgreSQL for projects or Job
- Beginners who want to learn PostgreSQL for Data Analysis