SQL
Intro to SQL
SQL is a programming language used to manage and manipulate relational databases. It is widely used in the tech industry and is essential for data-driven decision making.
- Roadmap to Learn SQL
Arif 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 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
SQL Tutorials
SQL tutorials are available for beginners and advanced users. These tutorials cover the basics of SQL syntax and commands, as well as more complex topics such as database design and optimization.
- The SQL Tutorial for Data Analysis
This SQL tutorial explains what SQL is and will take you through the basic functions, including SELECT, LIMIT, WHERE, etc.
Advanced SQL
Advanced SQL topics include subqueries, joins, and stored procedures. These concepts are important for optimizing database performance and creating complex data models.
- 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.
- Learning SQL 201: Optimizing Queries, Regardless of Platform
Randy's article is all about speed: common strategies for making queries go faster.
The Role of SQL in the Data Ecosystem
SQL plays a crucial role in the data ecosystem, allowing businesses to store, retrieve, and analyze large amounts of data. It is often used in conjunction with other technologies such as data warehousing and business intelligence tools. Understanding SQL is essential for anyone working with data in a professional context.
- 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