Description
AdventureWorks Sales Project is a hands-on project focused on solving practical trainings needs. Throughout the training, students will build complete SQL demos using real-world scenarios and datasets. At the completion of training, students will have developed tangible demos for work portfolios as well as improved technical skillsets in SQL and enhanced conceptional understandings of data science.
Benefits
• Tangible demos for work portfolios
• Technical skillsets in SELECT, ORDER BY, WHERE, Aggregate Functions, GROUP BY, Joins, and Subqueries
• Conceptual understandings of querying data, sorting and filtering queries, aggregating data, combining tables, and nesting queries
• Self paced trainings
• Continuous learning resources
Topics
1. Querying data using SELECT, DISTINCT, and CAST
2. Sorting and filtering queries using ORDER BY and WHERE
3. Aggregating data using COUNT, SUM, AVG, MAX/MIN, and GROUP BY
4. Combining tables using INNER JOIN, LEFT/RIGHT JOIN, and FULL JOIN
5. Nesting queries using Subqueries
Deliverables
• Download to 1 Scenario (PDF), 1 Dataset (MS Excel), 1 Database (SQLite), and 1 Demo (Google Colab)
Requirements
• Google Colab
Policies
• Cancellation Policy – Ineligible for exchange or refund
