Data
SQL
90 people are learning this skill right now!
SQL stands for Structured Query Language. It is the standard language used to manipulate and query data in relational databases.
Learn SQL with the Practica AI Coach
The Practica AI Coach helps you improve in SQL by using your current work challenges as opportunities to improve. The AI Coach will ask you questions, instruct you on concepts and tactics, and give you feedback as you make progress.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 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
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 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
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 AnalysisThis 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 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.
Related Skills
- ROI for Data Work
- MLOps Platforms
- Prioritization for Data Work
- Structuring Data Teams
- Effective Dashboards
- Machine Learning
- Data Science Career Ladders
- Data Engineering
- Neural Networks
- Analytics
- Analysis Documentation
- Data Infrastructure
- Cohort Analysis
- Data Tools
- ETL
- Data Soft Skills
- Data Dictionary
- Data Governance
- Data Roadmaps
- Event Data
- Personalization
- OCR
- Data Warehouse
- Deep Learning
- Sampling Algorithms
- Data Intuition
- Linear Regressions
- Data Cleaning