Learn – MySQL Server, Python Language and DB Administration
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
- Anyone who is interested in learning mysql database skills and python scripting