Week 5 Activity/Practice Session

Introducing topics for Week 5 - 0:00:00 0:06:22
Minor introduction to ORM + Database to be used - SQLite3 - 0:06:22 - 0:09:00
Significance of virtual environment - 0:09:00 - 0:11:19
Why we need persistent storage? - 0:11:19 - 0:13:25
Setting up Venv, installing dependencies and creating files using command prompt - 0:13:25 - 0:44:08
Explanation about SQLAlchemy ORM and Structure of Model - 0:44:08 - 0:51:16
Pythonic way of creating tables using SQLAlchemy - 0:51:16 - 1:29:42
Can use different databases by updating database configuration file - 1:29:42 - 1:49:17
Creating and Manipulating Data objects via CLI and DB browser GUI - 1:49:17 - 2:19:49
Adding new record into database using session - 2:19:49 - 2:29:11
Change data in Record and Update database - 2:29:11 - 2:34:22
Adding mulitple records together in the database - 2:34:22 - 2:37:51
Query Database and retrieve data - 2:37:51 - 2:47:38
General Doubts - 2:47:38 - 2:57:26