// “Explanation with real world examples and Hello World SQL”
- Introduction to Python for Data Science
- Exploring Data with Pandas
- Data Aggregation and Visualization with Pandas
- Recommended Book: Python for Data Analysis" by Wes McKinney
// “Learn how to say "Hello World" to the fascinating world of databases”
Introduction to SQL
- Overview of relational databases and SQL.
- Basic SQL syntax and data types.
- Querying data using SELECT statements.
- Filtering and sorting data with WHERE and ORDER BY clauses.
Manipulating Data with SQL
- Inserting, updating, and deleting data with INSERT, UPDATE, and DELETE statements
- Modifying table structures with ALTER TABLE
- Introduction to table relationships and JOIN operations
Aggregating and Grouping Data
- Using aggregate functions such as COUNT, SUM, AVG, MAX, and MIN
- Grouping data using GROUP BY and HAVING clauses
- Writing subqueries to perform advanced queries
Recommended Book
- SQL Queries for Mere Mortals" by John L. Viescas and Michael J. Hernandez
Student Evaluation Committee - EVALUATION & NOMINATION
// “Unveiling the Data Vault: Building a Foundation for Powerful Analytics”
- Explore the star schema and snowflake schema for efficient data organization and retrieval
- Unpack the process of extracting, transforming, and loading data into your data warehouse
- Learn best practices for designing a data warehouse that empowers insightful analysis
// “Take your data wrangling skills to the next level with advanced techniques”
- Advanced Data Wrangling Techniques
- Time Series Analysis with Pandas
- Advanced Data Visualization with Pandas
- Less python more real world examples
Student Evaluation Committee - EVALUATION & NOMINATION
// “Python Data Wizardry: Get ready for a dynamic fusion of SQL and Python!”
Data Manipulation with SQL in Python
- Inserting, updating, and deleting data using Python and SQL
- Performing advanced queries and joins in Python
- Handling transactions and error handling in SQL operations
ETL - SQL and Python Integration in Projects
- Overview on ETL.
- Integrating SQL databases with Python web frameworks (e.g., Flask, Django)
Recommended Book
- "Python for Data Analysis" by Wes McKinney
// “Building a Foundation for Powerful Analytics”
- Dive into the essential structures and frameworks that shape the field.
- Learn how to apply theoretical knowledge through real-world examples and case studies.
- Master the art of connecting ideas and technologies to streamline processes and enhance outcomes.
Student Evaluation Committee - EVALUATION & NOMINATION
// “Step into the world of data visualization with Power BI and unlock the power of visual storytelling.”
- Power BI Essentials: Introduction to Data Visualization
- Creating Interactive Visualizations in Power BI
- Advanced Visualization Techniques in Power BI
- Recommended book: "Information Dashboard Design: The Effective Visual Communication of Data" by Stephen Few
// “Dive deeper into the art of data storytelling using Power BI.”
- Designing Effective Dashboards in Power BI
- Storytelling with Data in Power BI
- Sharing and Presenting Power BI Visualizations
- Recommended book: "Data Storytelling: The Essential Data Science Skill Everyone Needs" by Mico Yuk
Student Evaluation Committee - EVALUATION & NOMINATION
// “The Final Project.”
During this phase, students start working on their final projects.
The SEF team act as consultants for the following:
- UI/UX
- Features Functionalities and Finalization
- Architecture and Infrastructure
- Code Cleaning and Documentation
- Deployment on AWS (EC2 instances)
- Github and ReadMe Publication
- Data Visualization and project demo
