NhacVibe
Ảnh bìa python programming complete unit 5 | database programming | btech python programming unit 5 | btech

python programming complete unit 5 | database programming | btech python programming unit 5 | btech

NS lectures · 25,4 N lượt xem · 14 thg 4, 2023

Mô tả

MY INSTAGRAM ID:
  / ns.lectures  

UNIT - 5 TOPICS:
00:35 - What is database
04:43 - various types of databases
09:33 - database challenges
11:09 - Database management system(DBMS)
11:56 - Structured query language(sql), sql commands, sql operations
14:44 - difference between in-memory DBMS and persistent DBMS
15:39 - DDL, DML, DQL commands
17:51 - OFFSET, ORDER BY, FILTER BY Clauses in SQL
21:53- SQLITE Constraints(NOT NULL, DEFAULT, UNIQUE, PRIMARY KEY Constraints)
27:09 - Constructors and types of python constructors
30:21 - Relational database
30:59 - Benefits of python for Database programming
31:38 - Module attributes for DB-API
32:06 - Database parameter style
33:29 - Cursor objects, cursor object attributes, cursor object methods
35:12 - Database API( sqlite and features of sqlite)
38:26 - sqlite3 CRUD Operations (creating database, students table, employees table and read , update , delete data from database)
01:03:15 - PostgreSQL and MySQL CRUD operations
01:04:47 - connection ( ) function, connection ( ) function methods and attributes
01:05:48 - ORM , advantages and disadvantages of ORM
01:10:18 - SQLAlchemy and SQLAlchemy CRUD Operations

PYTHON PORGRAMMING COMPLETE SUBJECT PLAYLIST:
   • introduction to python programming | featu...  

PYTHON STUDY MATERIAL:
https://drive.google.com/file/d/1_hr4...

python programming important questions pdf:
https://drive.google.com/file/d/1xr27...


#python#pythonprogramming#btechpython#btechpythonprogramming#btech#pythonun