Welcome to Lecture 39 of the course "Database Management Systems" by Prof. Partha Pratim Das.
Full Course: https://study.iitm.ac.in/ds/course_pages/BSCS2001.html
Video Overview
In this lecture, we demonstrate application development using Python and PostgreSQL. You’ll learn how to use the psycopg2 module to connect to a PostgreSQL database, execute SQL queries, and manage transactions with commit and rollback. We cover both backend data access and frontend GUI aspects, showing how Python can seamlessly interact with data. The session concludes with an introduction to frameworks like Flask, which simplify web application development and enable rapid deployment of database-driven applications.
About IIT Madras' online Bachelor of Science programme
IIT Madras offers four-year BS programmes that aim to provide quality education to all, irrespective of age, educational background, or location. The BS programme has multiple levels, which provide flexibility to students to exit at any of these levels. Depending on the courses completed and credits earned, the learner can receive a Foundation Certificate from IITM CODE (Centre for Outreach and Digital Education), Diploma(s) from IIT Madras, or BSc/BS Degrees from IIT Madras.
For more details, Visit: https://www.iitm.ac.in/academics/study-at-iitm/non-campus-bs-programmes
#DatabaseManagementSystems #DBMS #Python #PostgreSQL #psycopg2 #SQL #ApplicationDevelopment #WebDevelopment #Flask #Databases #DatabaseDesign #IITMadras #OnlineBSc #DataManagement #Programming #Backend #Frontend #GUI #WebFramework #DataAccess #DatabaseConnectivity #SoftwareDevelopment #FullStackDevelopment #PythonProgramming #PostgreSQLDatabase