PostgreSQL: From Zero to Hero [Free Course]

Master one of the great open source databases.
Instructed by: Will Bunker | Subject: Development, Databases

Description

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.

Outcome

1. Perform sophisticated queries
2. Join tables together
3. Use Group By to answer questions on aggregated date
4. Create tables
5. Create indexes
6. Alter tables
7. Put in constraints to keep data clean
8. Use pgAdmin tool

Take This Course

Course Info

• 58 Lectures
• 3.5 Hours
• Language: English
• Subject: Development, Databases
• Instructed by: Will Bunker
• Last updated on October 2017
• Platform: Udemy