Company
Date Published
Jan. 16, 2020
Author
Michael O'Toole
Word count
1595
Language
English
Hacker News points
None

Summary

This article provides an introduction to some basic but essential SQL functions, assuming the reader has a basic knowledge of SQL. It covers topics such as understanding the order of operations in SQL statements, aliasing tables for readability and usability, using Common Table Expressions (CTEs) for cleaner code reuse and readability, and making better JOINs with concepts like NATURAL JOIN and USING keyword. The article emphasizes that these beginner concepts have many nuances that are not necessarily evident to casual users of SQL, and understanding them can significantly improve one's SQL game.