This course contains below:

1. MySQL – 19 lectures and 3+hrs duration

2. Python Language – 16 lectures and 2.5 hrs duration

————————————————————————–

Course 1 – MySQL

Topic Duration (hh:mm:ss)

1.1 MySQL introduction 00:08:13

1.2 MySQL – install on Windows 00:11:22

1.3 MySQL Shell 00:06:55

1.4 MySQL Server 00:02:53

1.5 MySQL Workbench – Part 1 00:12:17

1.6 MySQL Workbench – Part 2 00:09:52

2.1 SQL introduction 00:06:34

2.2 SQL Data types 00:09:15

2.3 DDL – Data Definition Language 00:07:02

2.4 DML – Data Manipulation Language 00:11:36

2.5 DCL – Data Control Language 00:05:22

2.6 DTL – Data Transaction Language 00:10:32

2.7 Primary key – Foreign key 00:13:09

2.8 SQL Joins 00:09:37

2.9 SQL Views 00:13:11

2.10 Stored programs – Triggers 00:10:03

2.11 Stored programs – Stored procedures 00:08:34

3.1 MySQL Connector for Python 00:05:00

3.2 Connecting to MySQL Using ConnectorPython 00:17:49

—————————————————-

Course 2 – Python Language

1.1 Python – introduction 00:09:55

1.2 Install Python on Windows 00:04:48

1.4 Understanding Python language 00:10:19

1.5 Python coding style PEP8 00:08:31

2.1 Data types – Strings and numbers 00:10:21

2.2 Comments and docstrings 00:03:43

2.3 Control flow statements 00:08:50

2.4 Data structures – Lists and Tuples 00:11:00

3.1 Functions 00:11:27

3.5 Modules and Packages – I 00:10:08

3.6 Modules and Packages – II 00:08:05

4.1 Classes 00:08:54

4.2 Classes – inheritance – multiple inheritance 00:09:49

4.3 Classes – Method Resolution Order (MRO) – multiple inheritance 00:07:33

7.1 Standard libraries 00:05:14

5.1 File read write IO operations 00:12:03