news.volyx.in

Mastery with SQL: Learn Modern SQL with Postgres (masterywithsql.com)

551 points by nsainsbury · 2677 days ago · 80 comments on HN

Article summary

The article introduces a hands-on course for learning modern SQL with Postgres, covering various topics from basic to advanced levels. The course includes over 150 exercises with solutions and focuses on practical application. It is designed for learners with no prior knowledge or experience, as well as those looking to deepen their understanding of SQL. The course is self-paced and includes HD video and clear audio.

Main themes

  • SQL course
  • Postgres
  • Database management
  • Learning resources
  • Database performance

What commenters say

  • The course should include interactive SQL coding sessions for better practice.
  • Using text type with check constraints is considered a best practice over using varchar in Postgres.
  • The course lacks advanced topics such as query optimizations and performance tuning.
  • The Postgres manual does not unconditionally recommend using text over char or varchar.
  • Providing a Linux installation guide would be beneficial for users.
  • Using Docker to install Postgres can be a convenient option.
  • The course website should offer free samples for users to evaluate the quality and depth of the content.
  • Self-publishing a course allows for more innovation and flexibility compared to using online courseware providers.