DEV Community

SQL 101 Series' Articles

Back to Yujin's Series
SQL 101 | Summary of Most Used SQL Syntax for Data Analysis
Cover image for SQL 101 | Summary of Most Used SQL Syntax for Data Analysis
yujin profile

SQL 101 | Summary of Most Used SQL Syntax for Data Analysis

#tutorial #database #sql #ardenov
1
Comments
2 min read
SQL 101 | Chapter 1: Understanding SQL and Databases
Cover image for SQL 101 | Chapter 1: Understanding SQL and Databases
yujin profile

SQL 101 | Chapter 1: Understanding SQL and Databases

#tutorial #database #sql #ardenov
2
Comments
3 min read
SQL 101 | Chapter 2: Setting Up Your Database Environment
Cover image for SQL 101 | Chapter 2: Setting Up Your Database Environment
yujin profile
Yujin

SQL 101 | Chapter 2: Setting Up Your Database Environment

#tutorial #database #sql #ardenov
Comments
5 min read
SQL 101 | Chapter 3: Mastering Data Retrieval with SELECT Statements
Cover image for SQL 101 | Chapter 3: Mastering Data Retrieval with SELECT Statements
yujin profile
Yujin

SQL 101 | Chapter 3: Mastering Data Retrieval with SELECT Statements

#tutorial #database #sql #ardenov
Comments
7 min read
SQL 101 | Chapter 4: SQL Aliases - Learn How to Improve Query Readability and Maintainability
Cover image for SQL 101 | Chapter 4: SQL Aliases - Learn How to Improve Query Readability and Maintainability
yujin profile

SQL 101 | Chapter 4: SQL Aliases - Learn How to Improve Query Readability and Maintainability

#tutorial #database #sql #ardenov
Comments
4 min read
SQL 101 | Chapter 5: Advanced SQL Filtering - How to Refine Your Queries for Better Data Insights
Cover image for SQL 101 | Chapter 5: Advanced SQL Filtering - How to Refine Your Queries for Better Data Insights
yujin profile

SQL 101 | Chapter 5: Advanced SQL Filtering - How to Refine Your Queries for Better Data Insights

Comments
7 min read
SQL 101 | Chapter 6: Elevating Data Presentation - Advanced Sorting Techniques for Deeper Insights
Cover image for SQL 101 | Chapter 6: Elevating Data Presentation - Advanced Sorting Techniques for Deeper Insights
yujin profile

SQL 101 | Chapter 6: Elevating Data Presentation - Advanced Sorting Techniques for Deeper Insights

#tutorial #database #sql #ardenov
Comments
6 min read
SQL 101 | Chapter 7: Using Joins to Combine and Unify Data
Cover image for SQL 101 | Chapter 7: Using Joins to Combine and Unify Data
yujin profile
Yujin

SQL 101 | Chapter 7: Using Joins to Combine and Unify Data

#tutorial #database #sql #ardenov
Comments
6 min read
SQL 101 | Chapter 8: Using Subqueries for Improved Modularity and Dynamic Calculations
Cover image for SQL 101 | Chapter 8: Using Subqueries for Improved Modularity and Dynamic Calculations
yujin profile

SQL 101 | Chapter 8: Using Subqueries for Improved Modularity and Dynamic Calculations

#tutorial #database #sql #ardenov
6
Comments
3 min read
SQL 101 | Chapter 9: Common Table Expression (CTE)
Cover image for SQL 101 | Chapter 9: Common Table Expression (CTE)
yujin profile

SQL 101 | Chapter 9: Common Table Expression (CTE)

#tutorial #database #sql #ardenov
Comments
5 min read