Data Management using SQL

In recent years, data and analytics have become integral part of Business and Business Intelligence. Database Management is a crucial function in the “Age of Data”. Database Management using tools like SQL has now become one of the most important skillset companies are looking for among prospective candidates for hiring. Be it a role of Data Analyst or a role of Data Scientist or even a role of Business Analyst – SQL is required in the day-to-day job. But there are not enough number of resources with this skill for business analysis. So, SQL can help students to gain a competitive advantage in the job market. In this course, we try to develop a curriculum which is mix of theory and applications. SQL is easy to understand and crucial for business analytics. This course will introduce multiple “real” datasets (business and non-business) to play with SQL functions and achieve business objectives. For this course, students are not expected to have any prior coding experience.

Back

Lecture NameDownload
Course OutlineData Management using SQL-Course Outline-2022-2023.pdf
Dataset 1 - Data Loading and Managementdatabase1.sql
Dataset 2 - Data Loading and Management Data2.zip
Dataset 3 - Data Loading and Management Data3.zip
Dataset 4 - Data Loading and Management Data4.csv
Dataset 5 - Data Loading and Management Data5.zip
Dataset 6 - Data Loading and Management Data6.csv
Dataset 7 - Data Loading and Management Data7.csv