Intro to SQL
- Your SQL is not like my SQL
Julien explains which jobs frequently use SQL, and the different SQL skills needed for each: Transactional SQL for software engineers Analytical SQL for data analysts Data Engineering SQL for data engineers
- Practical SQL for Data Analysis
Haki provides an in-depth guide to using SQL for fast and efficient data analysis. He dives into specific tactics including descriptive statistics, subtotals, pivot tables, running and cumulative aggregation, linear regressions, interpolations, and binning.
The Role of SQL in the Data Ecosystem
- Why SQL is beating NoSQL, and what this means for the future of data
Ajar covers: • Part 1: A New Hope - To understand why SQL is making a comeback, let’s start with why it was designed in the first place. • Part 2: NoSQL Strikes Back • Part 3: Return of the SQL • But don’t take our word for it. Take Google’s. • What this means for the future of data: SQL as the universal interface