MySQL DBA Training | Arich Infotech – Master Database Administration

MySQL DBA

MySQL DBA

Duration in Hours : 30

Duration in Days: 15

MySQL DBA

Course Code: MYSQLDBA20CS

20 Hours of Theory

10 Hours Lab

Overview of MySQL

Introduction of MySQL
MySQL Features
MySQL Advantage
MySQL Installation
MySQL Data Types
MySQL Variables

User Management

MySQL Create User
MySQL Drop User
MySQL show Users
Change User Password

Databases

MySQL Create Database
MySQL Select Database
MySQL Show Database
MySQL Drop Database

Table & Views

MySQL Create Table
MySQL Drop Table
MySQL Alter Table
MySQL Show Table
MySQL Truncate Table
MySQL Temporary Table
MySQL Copy Table
MySQL Views

MySQL Queries

MySQL Queries
MySQL Constraints
MySQL insert Query
MySQL Update Query
MySQL Delete Query
MySQL Select Query
Insert On Duplicate Key Update

MySQL Indexes

MySQL Create Index
MySQL Drop Index
MySQL show Index
MySQL Clustered Index
MySQL Clustered vs Non-Clustered Index

MySQL Clauses

MySQL Where
MySQL AND
MySQL OR
MySQL LIKE
MySQL Limit
MySQL Order By
MySQL Group By
MySQL Having
MySQL Distinct
MySQL Union
MySQL Union All MySQL Flow Function
MySQL IF()
MySQL IFNULL()
MySQL NULLIF()
MySQL CASE
MySQL IF Statement

MySQL Joins

MySQL Join
MySQL Inner Join
MySQL Outer Join
MySQL Cross Join
MySQL Self Join
MySQL Delete Join
MySQL Union vs Join

MySQL Keys

Primary Key
Foreign Key
Unique Key
Composite Key Aggregate Function
MySQL count()
MySQL sum()
MySQL avg()
MySQL max()
MySQL min()
MySQL first()
MySQL last()
MySQL GROUP_CONCAT()

MySQL Mics

MySQL Comments
MySQL Commands Cheat-Sheet
MySQL Transaction
MySQL Cursor
MySQL Limit
MySQL Stored Function
MySQL Format Function
MySQL Ranking Function
MySQL window Function
MySQL Union
MySQL Varchar
MySQL Enum
MySQL Set
MySQL Decimal
MySQL Cast
MySQL Convert()
MySQL wildcards
MySQL Alias
MySQL Function
MySQL Trigger