SQL for Data Science |
|---|
| Course Outline |
|
| Software Installation |
|
| Useful Reference |
|
| Day | Modules | Sharing |
|---|
| 1 |
- Introduction to SQL and its role in data science
- Understanding relational databases and data organization
- Writing basic SQL queries: SELECT statements
- Filtering and sorting data with SQL WHERE and ORDER BY
- Performing data aggregation with GROUP BY
- Hands-on exercises and practice with real datasets
|
|
| 2 |
- Joining multiple tables with SQL JOIN operations
- Subqueries and derived tables for complex queries
- Introduction to indexing and query optimization. Modifying data with SQL: INSERT,UPDATE, DELETE statements
- Common Table Expressions (CTEs) for complex queries
- Course wrap-up, Q&A, and next steps in the data science journey
|
|