Explore

PostgreSQL Tutorial for Data Analysis and Administration

6.5 hours on-demand video

$ 12.99

Save Course

Go to Course

Brief Introduction

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

Requirements

Requirements
Basic understanding of databases

Recommended for you

SQL Masterclass: SQL for Data Analytics

SQL course covering basic to advanced SQL topics for SQL Database ( PostgreSQL ). Elucidates SQL Database for beginners 6 Reasons why you should choose this SQL course...

Save Course

Google BigQuery & PostgreSQL : Big Query for Data Analysis

Become BigQuery expert by mastering Google BigQuery for data analysis. Cover all SQL qureies in PostgeSQL & Big Query 6 Reasons why you should choose this PostgreSQL and BigQuery course...

Save Course

A Complete Guide to ArcGIS: 4 in 1

Learn various ArcGIS services and common issues to make web maps using data in your geodatabase   Contents and Overview x....

Save Course

PostgreSQL Tutorial for Data Analysis and Administration

Learn Basics of PostgreSQL for Database Administration and Data Anlaysis . Syllabus of the Course Lecture 1: Introduction and Installation of PostgreSQL...

Save Course