Postgresql Tutorial For Data Analysis And Administration

Postgresql Tutorial For Data Analysis And Administration

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

Leave a Reply