SQL Essentials: Part 1
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.
Company
Fivetran
Date published
Jan. 16, 2020
Author(s)
Michael O'Toole
Word count
1595
Hacker News points
None found.
Language
English