Working with MySQL Database using Python in Tamil | Advanced Python Programming in Tamil
This video explains and demonstrates how to work with MySQL Database using Python.
It includes data definition, data manipulation and integration of application to the database.
00:00:00 Start
00:00:28 Requirements
00:01:45 - Python-MySQL Connector Installation
00:02:56 Starting MySQL service in XAMPP
00:03:35 Details needed to create Connection
00:03:51 Creating new user account in phpmyadmin
00:05:35 Creating a connection
00:06:53 Cursor
00:08:20 Creating a database
00:10:32 Creating a table
00:14:31 Altering table to set primary key
00:17:02 Dropping a table
00:18:24 Data Manipulation
00:18:44 Inserting single record
00:23:07 Inserting multiple records
00:27:31 Updating record
00:32:43 Deleting record
00:34:41 Retrieving all records
00:35:45 Retrieving single record
00:37:23 Retrieving fields
00:38:44 Retrieving using filters
00:39:02 - using WHERE clause
00:40:37 - using Wildcard characters
00:41:52 - Preventing SQL Injection
00:42:23 Sorting Results
00:43:14 Limiting Results
00:44:39 Joins
00:48:37 - Inner Join
00:49:47 - Left Join
00:50:44 - Right Join
00:52:29 Application
00:52:57 - Creating Database
00:53:17 - Creating Table
00:57:56 - Connecting to Database
00:58:24 - Listing the table and its fields
00:59:47 - Function to get input
01:03:29 - Retrieving records from table
01:05:38 - Menu for data manipulation
01:06:31 - Inserting records
01:13:11 - Updating records
01:18:50 - Deleting records
01:21:32 - Placing DML operations inside functions
01:24:13 End
**********************************************
Happy Learning & Happy Coding
**********************************************
References:
----------------------------------------------
1. Python Installation - https://letussharehere.blogspot.com/2...
2. XAMPP Installation for MySQL - https://letussharehere.blogspot.com/2...
3. MySQL Server Installation - https://letussharehere.blogspot.com/2...
4. Python Programming (All-in-one series - compiled videos based on concepts) Playlist - • All-in-one Video - Python Programming for ...
5. Python Programming (Concept by Concept) Playlist - • Python Programming in Tamil