niit logo
  • logo
  • programs PROGRAMS

Data Analytics with Python and SQL

Gain expertise in Data Analysis using SQL & Python programming
Mode Of Delivery

Online Mentor led

25,000/-

( Excluding GST @18% )
Batch Starting From 14 Jun
Mon and Wed 07:30PM to 09:30PM NIIT program batch

25,000/-

( Excluding GST @ 18% )
Batch Starting From 14 Jun
Mon and Wed 07:30PM to 09:30PM NIIT program batch
Develop programs using Python
Use SQL to work with RDBMS
15 weeks program
15 weeks

Develop programs using Python

Use SQL to work with RDBMS

15 weeks program

15 weeks

.

HIGHLIGHTS

Ahead of your peers

Learners will learn to create programs and analyse data using Python. Learners will also learn RDBMS concepts and use SQL to retrieve data 

Top skills you will learn

Analytics using SQL; Programming & Data Analytics using Python

Career Catalyst

Improve critical thinking & problem solving skills. Practice with Real business scenarios.

Who is this program for

Anyone interested can apply for this program

PROGRAMME OVERVIEW

PROGRAMME OVERVIEW

This program will provide you with the programming foundations using the Python language. Whether you're a beginner or have some prior programming experience, this course will equip you with the essential tools to write efficient and effective Python programs. It will also help you develop skills in Relational Database Management Systems (RDBMS).

Python has become a preferred programming language in the world of analytics. Learners will learn to create programs using Python and to analyse data. Learner will also learn RDBMS concepts and use SQL to retrieve or manipulate data.

This program will help Learners as they progress through their academic journey. It will lay the foundation on the programming and data analysis skill that will be of immense value in their academic and professional lives.

 

CURRICULUM

The Program focuses on competency development. It is practice based i.e. learners learn by doing things rather than by watching videos or by attending traditional lectures. Curriculum will cover the following.

  • Learn to represent data in the form of tables in a Relational Database. Create, update, and retrieve data stored in a MySQL (RDBMS) database. Use Structured Query Language (SQL) to perform various operations on the database.
  • Learn to apply problem-solving techniques to decompose a problem into computational steps. Then translate the steps into a program using the Python language.
  • Use the NumPy libraries in Python to perform data analysis. Analysing & visualizing data using Python libraries.
  • A Summative assessment of all content and applications covered in the program

FAQs

  • Anyone interested can join.
  • This program will provide you with the programming foundations using the Python language. Whether you're a beginner or have some prior programming experience, this course will equip you with the essential tools to write efficient and effective Python programs. It will also help you develop skills in Relational Database Management Systems (RDBMS).
  • Learners will learn to create programs using Python and to analyse data. Learner will also learn RDBMS concepts and use SQL to retrieve or manipulate data.
  • This program will help learners as they progress through their academic journey. It will lay the foundation for an important programming and data analysis skill that will be of immense value in their academic and professional lives.
  • Introduction to Analytics using SQL
  • Introduction to Programming using Python
  • Introduction to Data Analytics using Python
  • Case Study

The Course, comprising of 30 Hours of Concept Sessions, is scheduled over a period of 15 weeks for the convenience of Learners to manage their learning along with their formal academic courses. The Learner is expected to assign, in a week, only 4-5 hours of learning effort for:

  • attending concept sessions for 2 hours every week,
  • devoting 2-3 hours to quizzes and assignments.

Learners will acquire knowledge and skills on programming using Python and working with RDBMS to analyse data using Python and SQL. On successful completion of each of the assignments, each learner will be able to:

  • Use SQL to work with RDBMS
  • Develop programs using Python
  • Perform basic data analysis using Python
  • You can read the complete set of Terms and Conditions for this program on the application page

Top