Do I care about data types? | Easy SQL Selects Part 3

Description:
Sign up for DUTC Weekly: https://mailchi.mp/dutc/ytweekly

LinkedIn: https://www.linkedin.com/company/do-n-t-use-this-code/
Website: https://www.dontusethiscode.com/index.html
Upcoming events: learning.dutc.io
Looking for training? Contact info@dutc.io

This is part of the Confident Queries & Stronger SQL - Easy Selects for Complex Analysis series.

In this segment, we cover simple select, limit, distinct, order by, group by, and where vs. having.

“SQL: good enough for 1986. Good enough for 2022.”
—Let’s bring our SQL knowledge into the modern era!


Do you…
- need to be able to write select statements to query SQL databases?
- need to know how to avoid common mistakes when writing SQL statements?
- struggle to remember the differences between the various join types?
- want to see what modern SQL dialects have to offer?

If so, join us!

In this series, we review how to construct simple select queries with group by and join clauses. We discuss the underlying design of SQL, and how this influences our select statement—e.g., when and why do we use a where clause vs a having clause? We cover common extensions to select, such as the ability to union, intersect and subtract (except) query results. Finally, we discuss basic dynamic mechanisms (e.g., prepared statements, string interpolation, and dynamic SQL), their use, and their fundamental limitations.

Disclaimer: This series will include PostgreSQL specific features & functionality that may not be present in other database products like MariaDB, MySQL, or SQLite.