Learn SQL Using PostgreSQL: From Zero to Hero

Source: https://www.udemy.com/course/postgresql-from-zero-to-hero/

What you’ll learn

• Perform sophisticated queries
• Join tables together
• Use Group By to answer questions on aggregated date
• Create and modifying tables
• Create indexes to improve search speed
• Put in constraints to keep data clean
• Use pgAdmin tool
• Learn recursive queries
• How views make accessing data simpler
• Subqueries
• Sequences to auto increment fields
• Common Table Expressions
• Conditional Expressions
• Window Functions
• How to handle date and time data
• SQL Functions
• Transactions and Concurrency Control
• PL/pgSQL Functions
• Triggers
• Composite Data Types
• Array Data Types

Requirements

• Basic computer skills.
• Ability to install software on system.
• Computer that can run PostgreSQL ( I will show you how to install ).

It’s not my rip