MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch

Genre: eLearning | Language: English + .VTT | Duration: 5.5 hour | Size: 4.41 GB

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

Requirements

Just computer coding savvy is enough the course is from basic to advanced covering the MySQL, SQL, and Python

Description

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

Who this course is for:

Anyone who is interested in learning mysql database skills and python scripting