For details of standard term assessment timelines and exam structures, visit our Academics page.
WEEK 1
Introduction to Data and Information Systems, Role of data in organizations, Data vs. information vs. knowledge, Introduction to databases and file systems
WEEK 2
Data Modeling and ER Diagrams, Conceptual, logical, and physical data models, Entities, attributes, relationships, Primary and foreign keys
WEEK 3
Relational Data Model, Tables, schema, and relations, Integrity constraints, Introduction to normalization
WEEK 4
SQL Basics, Introduction to MySQL tool, SELECT, WHERE, ORDER BY, INSERT, UPDATE, DELETE, Filtering and sorting data
WEEK 5
SQL Joins and Aggregation, INNER JOIN, LEFT JOIN, RIGHT JOIN, GROUP BY, HAVING, Subqueries
WEEK 6
Database Design and Normalization, 1NF, 2NF, 3NF, De-normalization, Design for performance
WEEK 7
Data Storage and Indexing, File structures and indexing, In-memory vs. disk-based storage, Basics of data warehousing
WEEK 8
Data Governance and Master Data Management, Data ownership, stewardship, Policies and procedures, Metadata management
WEEK 9
Data Quality and Cleaning, Data accuracy, consistency, completeness, Data cleaning techniques, Tools for preprocessing
WEEK 10
Data Security and Privacy, Database access control, Encryption and anonymization, Compliance: GDPR, HIPAA
WEEK 11
NoSQL and Big Data Introduction, Key-value, document, graph databases,When to use NoSQL, Cloud-based data storage (AWS, GCP intro)
WEEK 12
Project Presentation, Data lakes and lakehouses, Group project presentations, Overall Review of the course learnings
