SQL
Intro to SQL
Roadmap to Learn SQLArif provides a list of the key concepts that you'll need to learn to learn SQL, along with the order to learn them in.
Your SQL is not like my SQLJulien 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
SQL Tutorials
The SQL Tutorial for Data AnalysisThis SQL tutorial explains what SQL is and will take you through the basic functions, including SELECT, LIMIT, WHERE, etc.
Advanced SQL
Practical SQL for Data AnalysisHaki 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.
Learning SQL 201: Optimizing Queries, Regardless of PlatformRandy's article is all about speed: common strategies for making queries go faster.
The Role of SQL in the Data Ecosystem
Why SQL is beating NoSQL, and what this means for the future of dataAjar 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
