Categories

There are currently no items in your shopping cart.

User Panel

Forgot your password?.

Advanced Guide for MySQL Database

Video Introducing this tutorial


Introduction to the course :
1.1 Introduction to MySQL
1.2 Prerequisites

Course :
2.2 RDBMS and Its Terminology
3.1 DDL in MySQL part-1
3.2 DDL in MySQL part-2
3.3 DML in MySQL Part-1
3.4 DML in MySQL part-2
3.5 DML in MySQL part-3
3.6 LIMIT and ORDER BY in MySQL
3.7 Group By in MySqL
4.1 MySQL Aliases
4.2 Union Operator
4.3 Joins in MySQL
4.4 Constraints in MySQL- Part 1
4.5 Constraints in MySQL- Part 2
5.1 Logical and Comparison Operators
5.2 Conditions in MySQL
5.3 COMMIT, SAVEPOINT and ROLLBACK
5.4 LIKE in MySQL
5.5 RLIKE in MySQL
6.1 Views in MySQL
6.2 Subqueries
6.3 Scalar and Row Subqueries
6.4 Column and Table Subqueries
6.5 Subqueries with different Conditions
7.1 Stored Procedure in MySQL
7.2 Stored Procedure Variables
7.3 Stored Procedure Parameters
7.4 Conditions on Stored Procedures
8.1 Triggers in MySQL
8.2 Creating Triggers
8.3 Managing Triggers
8.4 Events in MySQL
8.5 Creating MySQL Events
8.6 Managing MySQL Events
9.1 Aggregate Function in MySQL
9.2 Join with Aggregate Function
9.3 String Function in MySQL
9.4 Date and Time Function
9.5 Control Flow Function
10.1 MySQL Administration
10.2 Create User and Change Passwords for Accounts
10.3 Granting Privilleges To Accounts
10.4 Revoking Privilleges From Users
10.5 More MySQL Admin Commands
11.1 Clone Tables in MySQL
11.2 Temporary Table in MySQL
11.3 How to Backup and Restore Databases