So far, you have learnt how to perform basic data analysis using Python and Excel. You have also learnt that it is risky to manage data from different files and that it may lead to inconsistency. An organisation cannot track its business activities efficiently by maintaining a large number of files. Hence, databases are used for accessing and managing data efficiently. A software known as Database Management System (DBMS) is used widely in the industry to analyse data easily.

In this session

You will be introduced to the basic concepts of a data warehouse, star schema, OLAP (Online Analytical Processing), OLTP (Online Transactional Processing), SETL (Select, Extraction, Transformation, and Loading), constraints and ERD (Entity Relationship Diagrams).

People you will hear from in this session

Subject Matter Expert

Chandrashekar Ramanathan

Professor & Dean (Academics), IIIT-B

The International Institute of Information Technology, Bengaluru – popularly known as IIIT Bangalore – is a premier graduate school in India. Founded in 1999, it offers Integrated M.Tech., M.Tech., M.S. (Research) and PhD programs in the field of Information Technology.

Deepak Singh

Group Product Manager, Flipkart

Report an error