SQL

PostgreSQL

My best experience with SQL data bases have been PostGres by far. It is open source, works splendidly and is fast and simple to learn and use and has a lot of awesome functionality.

Data Warehousing

SQL is a language that is used a lot in the data anlaytics space. Especially important for Data Engineering.

dbt

dbt is a framework for applying data engineering and data modelling to the analytics and data platform workflow.

Links

Thoughts

• There are two types of people in business, those who know SQL and those who do not. Be the former.
•  Common Table Expression (CTE) using the WITH clause. A CTE is a temporary result set that you can reference within a SELECT, INSERT, UPDATE, or DELETE statement. Here’s a breakdown of what the code does: