-
MySQL, Workbench, SQL Language, DDL, DML, DTL, DCL, Python connector, manage, export and import database
What you'll learn:- Learn MySQL database and administration, Explore the SQL language, Python language
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
Overview
