Exploring Data Analytics with Python and SQL

Acquire foundational skills and do better in academics. Exit Profile

Data analysis through programming and working with Students will acquire knowledge and skills on programming
databases are foundational digital skills that any using Python and working with RDBMS to analyse data using
undergraduate student must acquire. It will help students Python and SQL. On successful completion of each of the
develop critical thinking and decision-making skills, which assignments, each learner will be able to:
can be useful in various fields of study.

Gain distinctive knowledge and skills in the most in- » Use SQL to work with RDBMS
demand foundational areas. Completing this course will » Develop programs using Python
help you learn programming using Python and database » Perform basic data analysis using Python
concepts and their implementation.

Program Outline & Highlights Who Should Attend?

This program will provide you with the programming This program is open to any students who have starting their
foundations using the Python language. Whether you're college education across disciplines. Here are the pre-
a beginner or have some prior programming experience, requisites to joining this program:
this course will equip you with the essential tools to write » Communicate in English
efficient and effective Python programs. It will also help » Work comfortably using your Laptop with audio and a
you develop skills in Relational Database Management webcam enabled
Systems (RDBMS). » Use common productivity tools and the Internet
» Attend the virtual live sessions as per schedule
Python has become a preferred programming language
» Dedicated time each week to complete quiz, hands-on
in the world of analytics. Students will learn to create
work, and refactor them based on feedback
programs using Python and to analyse data. Student will
also learn RDBMS concepts and use SQL to retrieve or
manipulate data. StackRoute Learning Cycle

This program will help students as they progress through StackRoute courses
their academic journey. It will lay the foundation on the emphasize self-learning
programming and data analysis skill that will be of facilitated by personalized
immense value in their academic and professional lives. coaching, mentoring,
Program duration – 15 weeks review, feedback &
deliberate practice. The course is practice based i.e., learners
This program is scheduled over 15 weeks to make it learn by doing things rather than by watching videos or by
convenient for students to take it up. In each week, attending traditional lectures.
learners must spend 4-5 hours of learning effort to:

» Attend a concept session for up to 2 hours. The Program focuses on competency development. Each
» Spend 2-3 hours to complete a concept quiz, practice course has a collection of "learning sprints." Each sprint in
assignments, and correct them based on feedback. the digital literacy series of programs typically requires 6-8
» Submit the assignments and do a debrief (digitally or hours of learning effort. Each learning sprint is mapped to a
virtually) of the solution. distinct task that will introduce the concepts and its
implementation to perform that task effectively.

© NIIT 2023-24 Final Draft For Internal use only Page 1 of 2

Program Coverage – Learning Sprints

Students will learn the concepts, practice its implementation, submit for review, and
refactor their solution based on the feedback received. We believe skilling happens
through this process of making mistakes, dealing with consequences, receiving feedback,
and refactoring to improve. The course focuses on competency development.

The program consists of the following courses.

Course Name Brief Description

1. Introduction to Analytics Learn to represent data in the form of tables in a Relational Database. Create, update,
using SQL and retrieve data stored in a MySQL (RDBMS) database. Use Structured Query
Language (SQL) to perform various operations on the database.

2. Introduction to Learn to apply problem-solving techniques to decompose a problem into

Programming using computational steps. Then translate the steps into a program using the Python
Python language.

3. Introduction to Data Use the NumPy libraries in Python to perform data analysis. Analysing & visualizing
Analytics using Python data using Python libraries.
4. Case Study A Summative assessment

About StackRoute™ - an incubated venture from NIIT

NIIT Limited is an Indian multinational skills and talent development corporation headquartered in Gurugram, India. The
company was set up in 1981 to help the nascent IT industry overcome its human resource challenges. Established in August
2015, StackRoute® is an NIIT-incubated venture. StackRoute runs immersive bootcamp programs that deliver job-ready
professionals with deep skills. Our distinctive implementation of mastery learning combined with personalized tutoring
allows us to guarantee learning outcomes. Our graduates confidently take on challenging assignments in the context of
digital transformation. Several large global IT organizations, Global Incubation Centers, Product Engineering teams, and
Universities trust StackRoute programs to transform their own employees' or students' digital skills. As a digital talent
transformation partner, StackRoute programs transform over 20,000 professionals in India each year. In the USA,
StackRoute Learning Inc., an NIIT-owned company, partners with educational institutions across North America to offer
University-branded online bootcamp programs to students who wish to upskill or reskill for better employment. In its 21
years in China, NIIT China has worked with over 100 Chinese universities.

© NIIT 2022-23 Final Draft - For Internal use only Page 2 of 2