>
FSD -Pyt Syllabus
// “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”
  • Business Implementation Concept
  • 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!”

Overview on ETL

  • Overview on ETL.

SQL Jobs

  • Inserting, updating, and deleting data
  • Performing advanced queries and joins
  • Handling transactions and error handling

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