SQL and PostgreSQL: The Complete Developer's Guide
Taught By: Stephen Grider
This course introduced me to both SQL and PostgreSQL. The first half centered around learning SQL syntax and how to write a variety of queries, including those that make use of unions, views, groupings, and aggregations. In the second half of the course, we wrote a couple simple web applications to access, display, and alter in the information stored in PostgreSQL databases.
Skills Learned:
- How to write a variety of SQL queries.
- How to write and use database migrations.
- Created web apps that accessed and interacted with Postgres databases.