MySql Essential Training

PHP TRAINING CENTER

PART-2
MySQL Essentials

1 - Introducing MySQL

---

1 - Mysql Essential Training introduction
2 - What is MySQL
3 - Important Terminology

2 - Installing the Test Environment

---

4 - Installation overview
5 - setup XAMPP in php on Windows
6 - setup XAMPP in php on a Mac

3 - Configuring MySQL

---

7 - MySQL Command Line Interface on Windows
8 - MySQL Command Line Interface on a Mac

4 - Using the SQL Interactive Demonstrator (SID)

---

9 - SID in mysqsl
10 - Installing SID on Windows
11 - Installing SID on a Mac

5 - Creating a Database

---

12 - how to Creating a database in phpmyadmin
13 - how to Creating a table in phpmyadmin

6 - MySQL Data Types

---

14 - data types in mysql
15 - Numeric types in Mysql
16 - String types in mysql
17 - Large storage types in mysql
18 - date and time types in mysql
19 - Bit type in mysql
20 - Boolean values in mysql
21 - Enumeratino types in mysql

7 - MySQL Functions

---

22 - MySQL functions
23 - mysql String functions
24 - mysql Numeric functions
25 - MYSQL date and time functions
26 - Time zones in MySQL
27 - time zone support in MySQL in Windows
28 - Time zone support in MySQL on a Mac
29 - MYSQL Aggregate functions
30 - MYSQL Full text speech

8 - PHP's MySQLi Interface

---

31 - interfaces in php
32 - Introducing CRUD in MYSQL
33 - database configuration in php
34 - php Prepared statements
35 - Fetching results from database in php
36 - Auto increment IDs

9 - PHP's PDO Interface with MySQL

---

37 - PDO is multi platform
38 - PDO is multi platform
39 - Prepared statements
40 - Fetching results from database
41 - Auto increment IDs