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
Download Links
