We can't find the internet
Attempting to reconnect
Something went wrong!
Hang in there while we get back on track
Lætitia AVROT: Learning advanced SQL the weird (and hard) way (PGConf.EU 2023)
Learn advanced SQL the fun way! Discover techniques for learning, including reusing code, commenting, and the importance of fun and community guidance.
- Techniques for learning advanced SQL: reusing code, commenting, and focusing on the journey rather than the destination.
- Importance of commenting: it helps to reuse code and understand what you wrote earlier.
- Advent of Code: a yearly code challenge to learn SQL, and it’s a fun way to learn.
- Why use PSQL instead of a GUI tool: PSQL is more efficient, and it’s a great tool for Postgres.
- The importance of fun: when learning and solving problems, it’s essential to enjoy the journey and not to stress about it.
- Do block: a type of loop that can be used instead of gexec.
- Generated columns: they can be used to create auto-generated IDs.
- Regular expressions: they can be used to solve problems, but it’s not necessary to overuse them.
- Efficiency: it’s important when solving problems, but not at the expense of fun.
- Guru and guidance: it’s helpful to have someone to guide you and share their knowledge.
- Failed attempts: it’s okay to failed, and it’s an important part of the learning process.
- History of SQL: it has a long history, and it’s more than just a language.
- The language should be Turing-complete: this allows for creative solutions to problems.
- SQL and programming: they are closely related, and SQL is a part of programming.
- The final goal: it’s not just about solving problems, but about enjoying the journey and learning from it.