Learn - MySQL Server, Python Language and DB Administration

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

MySQL, Workbench, SQL Language, DDL, DML, DTL, DCL, Python connector, manage, export and import database

Url: View Details

What you will learn

• Learn MySQL database and administration, Explore the SQL language, Python language

Rating: 3.85

Level: All Levels

Duration: 5.5 hours

Instructor: Kaushik Vadali