Mysql Introduction
  • 1.1 MySQL introduction
  • 1.2 MySQL - install on Windows
  • 1.3 MySQL Shell
  • 1.4 MySQL Server
  • 1.5 MySQL Workbench - Part 1
  • 1.6 MySQL Workbench - Part 2
SQL Language
  • 2.1 SQL introduction
  • 2.2 SQL Data types
  • 2.3 DDL - Data Definition Language
  • 2.4 DML - Data Manipulation Language
  • 2.5 DCL - Data Control Language
  • 2.6 DTL - Data Transaction Language
  • 2.7 Primary key - Foregin key
  • 2.8 SQL Joins
  • 2.9 SQL Views
  • 2.10 Stored programs - Triggers
  • 2.11 Stored programs - Stored procedures
MySQL Connector for Python
  • 3.1 MySQL connector for Python
  • 3.2 Connecting to MySQL Using ConnectorPython
Python Language
  • 1.1 Python - introduction
  • 1.2 Install python on windows
  • 1.4 Understanding Python language
  • 1.5 Python coding style PEP8
  • 2.1 Data types - Strings and numbers
  • 2.2 Comments and docstrings
  • 2.3 Control flow statements
  • 2.4 Data structures - Lists and Tuples
  • 3.1 functions
  • 3.5 Modules and Packages - I
  • 3.6 Modules and Packages - II
  • 4.1 Python Classes
  • 4.2 Classes - inheritance - multiple inheritance
  • 4.3 Classes - Method Resolution Order (MRO) - multiple inheritance
  • 5.1 File read write IO operations
  • 7.1 Standard libraries