PostgreSQL Tutorial for Data Analysis and Administration | Other It & Software Online Course by Udemy

It & Software Online Course by Udemy, On Sale Here

Learn Basics of PostgreSQL for Database Administration and Data Anlaysis.

An excellent training about Other It & Software

PostgreSQL Tutorial for Data Analysis and Administration

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

Udemy is the leading global marketplace for learning and instruction

By connecting students all over the world to the best instructors, Udemy is helping individuals reach their goals and pursue their dreams.

Study anytime, anywhere.

START HERE

Education Provider	Udemy

---