/plushcap/analysis/fivetran/sql-essentials-part-1

SQL Essentials: Part 1

What's this blog post about?

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


By Matt Makai. 2021-2024.