Introduction to Course
- Introduction
Introduction to MySQL and Installation
- What is MySQL?
- XAMPP Installation
- MySQL Workbench Installation
MySQL Basics
- Data types in MySQL Part - 1
- Data types in MySQL Part - 2
- Creating Database & Table through PHPMyAdmin
- Creating Database & Table through MySQL Workbench
- Understanding Primary Key, Database Users & their Permissions
- Importing & Exporting Databases
- Introduction to MySQL Queries and SELECT Clause
- Practical session on Insert + Update + Delete
MySQL Advanced
- Mastering Table Storage Engines
- Mastering Table Joining: Part 1
- Mastering Table Joining: Part 2
- Working with Math and Strings: Part 1
- Working with Math and Strings: Part 2
- Working with Group By: Part 1
- Working with Group By: Part 2
- Mastering Sub-queries: Part 1
- Mastering Sub-queries: Part 2
- Transactions and sequences
Mastering PHP
- PHP Basics
- PHP Advanced: Part 1
- PHP Advanced: Part 2
- PHP Advanced: Part 3
- PHP Advanced: Part 4
- PHP Advanced: Part 5
PHP + MySQL : Practical Project
- PHP + MySQL: Basic Project # Part 1
- PHP + MySQL: Basic Project # Part 2
Python Basics + Databased Programming with MySQL
- Introduction to Python Variables
- Python Datatypes
- Creating MySQL Database through Python
- Loading data into tables
- Displaying data in HTML Tables
- Database programming using Python Classes
