Basic of database with terminologies and data types in MySQL.
Data Definition and Manipulation using SQL.
Union, Joins and Constraints in MySQL.
Operators, Keywords and Transactions in MySQL.
MySQL Views and Nested Queries.
Stored Procedure in MySQL.
Triggers and Events in MySQL.
Functions in MySQL
10 sections • 49 lectures • 7h 25m total length
DDL in MySQL part-1
DDL in MySQL part-2
DML in MySQL Part-1
DML in MySQl part-2
DML in MySQl part-3
LIMIT and ORDER BY in MySQL
Group By inMySql
Joins in MySQL
Constraints in MySQL
Logical and Comparison Operators
Conditions in MySQL
COMMIT, SAVEPOINT and ROLLBACK
LIKE in MySQL
RLIKE in MySQL
Views in MySQL
Scalar and Row Subqueries
Column and Table Subqueries
Subqueries with different Conditions
Stored Procedure in MySQL
Stored Procedure Variables
Stored Procedure Parameters
Conditions on Stored Procedures
Triggers in MySQL
Events in MySQL
Creating MySQL Events
Managing MySQL Events
Aggregate Function in MySQL
Join with Aggregate Function
String Function in MySQL
Date and Time Function
Control Flow Function
Create User and Change Passwords for Accounts
Granting Privilleges To Accounts
Revoking Privilleges From Users
More MySQL Admin Commands
Clone Tables in MySQL
Temporary Table in MySQL
How to Backup and Restore Databases
Basic knowledge of Linux and Windows.
Basic knowledge of Programming.
Having strong approach would be an added advantage.
In this MySQL Certification Training from Easylearning.guru, you’ll learn MySQL - a most popular Open Source Relational database management system. This course is intended for analysts, developers, designers, administrators or anyone new to the SQL programming language as well as MySQL database. Towards the end of the MySQL Online Course, you will have knowledge about:
Features and benefits of MySQL
Basics of relational databases
How to design an effective database
How to build a database and tables by using SQL Modify or delete database entities
Querying data with SELECT command
How to join data from multiple tables
Performing nested subqueries
Using Built-in MySQL functions
How to improve database performance by taking advantage of MySQL stored procedure
Easylearning guru is a leading provider of professional certification courses. We offers training from best experts in the industry to meet the unique learning needs. We are the pioneer's in online education and training, and aims to offer our professionals flexible & an integrated model of training to meet their needs & requirements.