MySQL Database Administration

  1. Home
  2. MySQL Database Administration

MySQL Database Administration

MySQL is the world's most popular open-source database. It includes InnoDB, making it a fully integrated, transaction-safe, ACID-compliant database. In addition, MySQL Replication allows you to deliver high performance and scalable applications.

MySQL professionals need to know:

  • The layout of an installed server
  • Client and server executables and their options
  • Running and evaluating queries
  • Database design and structure
  • Securing MySQL with privileges and roles

 

All Courses Idea

Installation and Setup

  • Introduction
  • Databases, SQL and MySQL
  • Relational Database Management System (RDMS)
  • MySQL Installation for Windows
  • MySQL Workbench Overview
  • Create Database

Data Definition Language

  • Introduction
  • Data Types
  • Primary and Foreign Keys
  • Modifying Tables: Adding and Removing Columns
  • Deleting Tables
  • Truncating Tables

Alter Table

  • Introduction
  • Creating Test Database
  • Add and Remove Primary Key
  • Add and Remove Foreign Key
  • Add Unique Constraint
  • Change Column Name
  • Change Column Data Type

Data Manipulation Language

  • Introduction
  • Inserting Data Into Tables
  • Updating Data in Tables
  • Deleting Data from Tables

Selecting from a Table

  • Introduction
  • Select Statement
  • Where Clause
  • Using Inequality Symbols
  • Null Values
  • In, Not In
  • Between
  • Like
  • Order By
  • Distinct
  • Limit
  • Column Name Alias

Selecting From Multiple Tables

  • Introduction
  • What Are Joins?
  • Inner Join
  • Left Join
  • Right Join
  • Joining more than Two Tables

Database Design

  • Introduction
  • Normalization - What is it?
  • 1st. Normal Form (1NF)
  • 2nd. Normal Form (2NF)
  • 3rd. Normal Form (3NF)
  • Relationships
  • Relationships - One to One
  • Relationships - One to Many
  • Relationships - Many to Many
  • Constraints

Aggregate Functions

  • Section Introduction
  • What are Aggregate Functions
  • Count
  • Sum
  • Min and Max
  • Average
  • Grouping Data
  • Having Clause

Sub-queries

  • Introduction
  • What Are Subqueries
  • Non-Correlated Subqueries
  • Correlated Subqueries

MySQL Functions - String Functions and Date Functions

  • Section Introduction
  • What Are MySQL Functions?
  • Concatenation
  • Substrings
  • Upper and Lower Case
  • Date Function
  • Month Function
  • Year Function

Basic knowledge of relational database concepts and understanding of how to execute Linux/ Unix commands.

Courses List