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.
| Lecture Name | Download |
|---|---|
| Course Outline | Data Management using SQL-Course Outline-2022-2023.pdf |
| Dataset 1 - Data Loading and Management | database1.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 |