Class Schedule
Here you can find the tentative schedule of the lab (which might change as the semester progresses).
The slides and other required material will be uploaded here before each lab. It is advised that you carry your laptops to every lab for hands-on learning.
Lab
IntroductionIn the first lab we introduced the general lab expectations and an overall plan of what we will cover throughout the semester during lab sessions. We introduced the outline of Project 1 and its deliverables. We also setup the required infrastructure for the project.
Lab
ER ModellingIn our second lab discussed about the ER model.
Lab
SQL SetupIn the third lab we will discuss about basic SQL setup, data cleaning and transforming schema to Database tables.
Lab
Connecting Front-End with MySQL DBIn the fourth lab we will discuss how to connect the back-end/DB to a simple front-end UI.
Lab
SQL + Project DiscussionIn the fifth lab we will discuss about WA4 in brief. The rest of the lab will be an open-session for project-related questions (w.r.t. PA1.2)
Lab
PA1.2 DemoIn the sixth lab each of you demonstrated your submissions for PA1.2
Lab
PA1.3 DiscussionIn the seventh lab we discussed issues and clarified questions for PA1.3.
Lab
PA1.3 DiscussionIn the this lab we discussed issues and clarified questions for PA1.3.
Lab
SQL Hands-on TestIn the this lab we did the SQL Hands-on Test (Bonus).