MySQL Database Admin -DBA for Beginners

Course Curriculum

Chapter 1: MySQL Installation

Lecture 1: Introduction

Lecture 2: What is SQL

Lecture 3: What is MySQL

Lecture 4: MySQL Download and Installation (Windows)

Lecture 5: What is MySQL Workbench

Lecture 6: MySQL Installation (Mac)

Lecture 7: Installing MySQL Workbench (Mac)

Lecture 8: Basic Database Concepts

Lecture 9: What is a Schema

Lecture 10: Database Schema

Lecture 11: MySQL Data Types

Chapter 2: MySQL Workbench Configuration

Lecture 1: User Accessibility Options

Lecture 2: Preferences Options

Lecture 3: General Editor Preferences

Lecture 4: SQL Editor Preferences

Lecture 5: Administration Preferences

Lecture 6: Modelling Preferences

Lecture 7: Fonts and Colors

Lecture 8: SSH Preferences

Lecture 9: Other Preferences

Lecture 10: MySQL Workbench Home Screen

Chapter 3: Database Modeling

Lecture 1: Introduction to data modelling

Lecture 2: Creating a model – part 1

Lecture 3: Creating a model – part 2

Lecture 4: Basic modeling

Chapter 4: Performing Administrative tasks

Lecture 1: Creating a new MySQL Connection

Lecture 2: Managing Server Connections

Lecture 3: Client Connections

Lecture 4: Checking Server Status

Lecture 5: Administration of users and Priviledges

Lecture 6: Checking Performance Dashboard

Lecture 7: Using MySQL Utilities

Lecture 8: Using Object Browser

Lecture 9: Showing existing databases

Lecture 10: Showing list of tables

Lecture 11: Create a Database

Lecture 12: Create a Table

Lecture 13: Using basic SQL Commands

Lecture 14: Displaying table structure

Lecture 15: Changing Table Structure

Chapter 5: Creating MySQL Objects

Lecture 1: MySQL Naming Convention

Lecture 2: Creating a MySQL Database

Lecture 3: Using IF NOT EXIST DROP

Lecture 4: Creating a Table in MySQL

Lecture 5: Setting up default database

Lecture 6: Using MySQL Comments

Lecture 7: Primary keys

Lecture 8: Foreign keys

Chapter 6: MySQL Statements

Lecture 1: MySQL INSERT Statement

Lecture 2: MySQL SELECT statement

Lecture 3: MySQL UPDATE Statement

Lecture 4: MySQL DELETE Statement

Chapter 7: MySQL Access Privilege System

Lecture 1: MySQL Access Privilege

Lecture 2: What You can not do with MySQL privilege SYSTEM

Lecture 3: Static and Dynamic priviledges

Lecture 4: Applying dynamic priviledges

Lecture 5: Migrating SUPER priviledges

Lecture 6: MySQL Priviledges

Chapter 8: MySQL Backup and Recovery

Lecture 1: Introduction to MySQL Backup and Recovery

Lecture 2: Backup and Recovery Types

Lecture 3: Setting up backup directory with mysqldump

Lecture 4: Export data from MySQL Database

Lecture 5: Export result set of a query

Lecture 6: Backing up databases with mysqldump

Lecture 7: Restore database from backup

Lecture 8: Backing up a single table

Lecture 9: Restoring table from backup

Chapter 9: MySQL Table Joins

Lecture 1: MySQL INNER Join

Lecture 2: MySQL LEFT JOIN

Lecture 3: MySQL RIGHT Join

Lecture 4: MySQL SELF join

Chapter 10: MySQL Views

Lecture 1: MySQL Views

Lecture 2: Creating a MySQL View

Lecture 3: Querying MySQL Views

Lecture 4: Modifying a view

Lecture 5: Dropping a view

Chapter 11: MySQL Stored Procedures

Lecture 1: What are stored procedures

Lecture 2: Creating stored procedure

Lecture 3: Modifying stored procedure

Lecture 4: Creating an advanced stored procedure

Lecture 5: Calling and deleting stored procedures

Chapter 12: MySQL Subqueries

Lecture 1: What is a subquery

Lecture 2: Nested subqueries

Lecture 3: Derived Tables

Chapter 13: MySQL Clauses | Keywords | Some String Functions

Lecture 1: DISTINCT keyword

Lecture 2: GROUP BY Clause

Lecture 3: HAVING clause