Welcome to the PDF Resources section of the intro_to_SQL repository! Here you will find a curated, step-by-step collection of comprehensive notes, cheat sheets, and practical guides designed to take you from SQL fundamentals to advanced database optimization and AI integration.
| # | File Name | Description & Key Topics |
|---|---|---|
| 01 | 01_SQL_Introduction.pdf | Database Basics, RDBMS Architecture, SQL vs NoSQL, Basic Concepts. |
| 02 | 02_Query_Data_SELECT.pdf | SELECT statement syntax, Aliases, Column Operations, Basic Queries. |
| 03 | 03_Data_Definition_DDL.pdf | Schema management: CREATE, ALTER, DROP, TRUNCATE, Constraints (PK, FK, Unique). |
| 04 | 04_Data_Manipulation_DML.pdf | Data management: INSERT, UPDATE, DELETE, Transactional control basics. |
| 05 | 05_Filtering_Data.pdf | Advanced filtering using WHERE, LIKE, IN, BETWEEN, AND/OR/NOT, handling NULLs. |
| 06 | 06_JOINS_and_SET.pdf | Relational Data Linking: INNER, LEFT, RIGHT, FULL, CROSS JOIN, plus UNION, INTERSECT. |
| 07 | 07_Row_Level_Functions.pdf | Scalar functions: String manipulation, Date/Time formatting, Math functions, CASE WHEN. |
| 08 | 08_Aggregation_Analytical_Functions.pdf | Grouping with GROUP BY & HAVING, Window Functions (ROW_NUMBER, RANK, LEAD/LAG). |
| 09 | 09_Advanced_SQL_Techniques.pdf | Subqueries, CTEs (Common Table Expressions), Recursive Queries, Views & Indexes. |
| 10 | 10_Performance_Optimization.pdf | Execution Plans, Index Tuning, Query Refactoring, Bottleneck Removal. |
| -- | 10_SQL_30_Performance_Tips.pdf | Quick-reference cheat sheet with 30 actionable tips for faster SQL queries. |
| 11 | 11_AI_and_SQL.pdf | Integrating LLMs with Databases, Text-to-SQL workflows, AI-driven Query Optimization. |
| 12 | 12_SQL_Projects.pdf | End-to-end practical SQL implementation projects and problem sets. |
| -- | 12_SQL_Projects_Data_Analytics.pdf | Real-world Business Intelligence (BI) and Data Analytics case studies. |
| -- | 12_SQL_Projects_ETL.pdf | Building Data Pipelines, Data Transformation, and Staging workflows. |
- Sequential Learning: If you are new to SQL, start from
01_SQL_Introduction.pdfand follow the numerical order. - Project-Based Practice: Jump straight to module
12to test your skills on realistic Analytics and ETL scenarios. - Quick Optimization Reference: Keep
10_SQL_30_Performance_Tips.pdfhandy when writing production-level queries.
Happy Querying! 🚀