Learn SQL for Data Analysis

Author

✍ Faik Erkam Minsin  

Code

• Scripted on: SQL Server 19.0.1

Topics and Documents

Basics:

• Creating Tables
• Select and From
• Where
• Group By and Order By

Intermediate:

• Inner and Outer Joins
• Unions
• Case
• Having
• Update and Delete
• Aliasing
• Partition By

Advance:

• Temp Tables
• String Functions
• Stored Procedures
• Subqueries

Resource