Postgresql Tutorial For Data Analysis And Administration

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
Section 1: Introduction
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 Database 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
Beginner Developers Curious to Learn PostgreSQL for projects or Job,Beginners who want to learn PostgreSQL for Data Analysis


Homepage

https://www.udemy.com/course/postgresql-tutorial-for-db-administration-and-data-analysis/

Postgresql Tutorial For Data Analysis And Administration Fast Download
Postgresql Tutorial For Data Analysis And Administration Full Download