Data Analysis: Investigate with SQL

Introduction

• Why learn SQL today?
• What you should know
• Solve a crime with SQL

1. Starting the Investigation with SQL Query

• Data analysis: First steps
• SQL core concepts: Data types, tables, columns, and records
• First query: Comments, aliases, and sorting

2. Filter Data for Refined Results

• Adding criteria to SQL queries
• Second query: WHERE clause, operators, date, and texts
• Query composition: More operators for refining results
• Third query: Operators and context understanding

3. Performing Manual Data Analysis

• Logical deduction by observing results
• Crime-solving SQL analysis recap

4. Exploring Related Table Data

• Examining the evidence in related tables
• Fourth query breakdown: BETWEEN operator and date ranges
• Finding supporting evidence to align objectives
• Fifth query breakdown: Using the IN and AND operators

5. Conclusive Analysis for Data-Driven Action

• Solving the case with data-driven insights
• Project: The art of disguise
• Project: Solution walkthrough

Conclusion

• Continue enhancing your SQL data-driven skills