Postgresql Tutorial For Data Analysis And Administration
https://DevCourseWeb.com
Last updated 6/2020
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 3.54 GB | Duration: 6h 30m
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