PostgreSQL: From Zero to Hero
Master one of the great open source databases.
Created by Will Bunker | 3.5 hours on-demand video
PostgreSQL: From Zero to Hero. Learning SQL was one of the most valuable skills I learned while building Match. We had one of the largest instances of Microsoft SQL Server in the 90s with millions of records to keep the site running. The better we got at SQL, the better we could make the site work for our users and answers sophisticated questions about our users.
What You’ll Learn
- Basic selection statements
- Joining multiple tables together
- Grouping records to get aggregate data
- Inserting, updating and deleting records
- Creating tables and indexes
- Constraining data input using field and table constraints