SQL

1. 7.Row Level Functions

1.1. String Func.

1.2. Numeric Func.

1.3. Date & Time Func.

1.4. Null Func.

1.5. Case Statement

2. 8.Aggregation & Analytical Functions

2.1. Aggregate Func.

2.2. Window Basics

2.3. Window Aggregate Func.

2.4. Window Ranking Func.

2.5. Window Value Func.

3. 9.Advanced SQL Techniques

3.1. Subqueries

3.2. Common Table Expressions(CTE)

3.2.1. CTE Basics

3.2.2. Non-Recursive

3.2.3. Recursive

3.2.4. CTE vs Subqueries

3.3. Views

3.4. CTAS Table & Temp Tables

3.5. Stored Procedure

3.6. Triggers

4. 10.Performance Optimization

4.1. Indexes

4.2. Partitions

4.3. Performance Tips

5. 11.AI & SQL

5.1. Generate SQL Code

5.2. Explain SQL Code

5.3. Understand & Learn SQL Concepts

5.4. Styling Code & Comments

5.5. Create Code Documentation

5.6. Explaining Error Messages

5.7. Find Bugs & Fixing Errors

5.8. Translating Queries b/w Diff Databases

5.9. Generating Sample Data

5.10. Optimizing Performance

6. 12.SQL Projects

7. 1. Introduction

7.1. What is SQL?

7.2. Why learn SQL?

7.3. What is Database & Types?

7.4. SQL Commands

7.5. Setup Your Environment

8. 2.Query Data

8.1. SELECT

8.2. FROM

8.3. WHERE

8.4. ORDER BY

8.5. GROUP BY

8.6. HAVING

8.7. DISTINCT

8.8. TOP

8.9. Query Order & Execution

9. 3.DDL(Data Definition Language)

9.1. CREATE

9.2. ALTER

9.3. DROP

10. 4.DML(Data Manipulation Language)

10.1. INSERT

10.2. UPDATE

10.3. DELETE

11. 5.Filtering Data

11.1. Logical Operators

11.1.1. AND

11.1.2. OR

11.1.3. NOT

11.2. Comparison Operators

11.2.1. =, !=, <, <=, >, >=

11.3. BETWEEN

11.4. IN

11.5. LIKE

12. 6.Combining Data

12.1. JOINS

12.1.1. Basic Joins

12.1.2. Advanced Joins

12.1.3. How To Choose The Right Join

12.1.4. How To Join Multiple Tables

12.2. SET Operators

12.2.1. UNION

12.2.2. UNION ALL

12.2.3. EXCEPT

12.2.4. INTERSECT