Learn MYSQL Administration

Become MYSQL Administrator by understand the basic concepts related to MySQL Administration.

Audience

This reference has been prepared for the beginners to help them understand the basics to advanced concepts related to MySQL languages.

Overview

MySQL is the most popular Open Source Relational SQL database management system. MySQL is one of the best RDBMS (relational database management system) being used for developing web-based software applications.

This course will give you quick start with MySQL and make you comfortable with MySQL programming.

Prerequisites

Before you start doing practice with various types of examples given in this reference, I’m making an assumption that you are already aware about what is database, especially RDBMS (relational database management system) and what is a computer programming language.

Lessons

1

Introduction

Lesson : 1 | Duration 1.5 hours

  • MySQL Product, MySQL Services and Support MySQL Resources, Example Databases
2

MySQL Server and Client

Lesson : 2 | Duration 1.5 hours

  • The client/server model overview, Communication protocols, Connectors and MySQL, The LAMP stack, Installation of the MySQL server, MySQL server and client startup
3

Database Basics

Lesson : 3 | Duration 1.5 hours

  • Basics of relational databases, SQL language and MySQL
4

Database Designs

Lesson : 4 | Duration 1.5 hours

  • Database Modelling, Keys, Normalization
5

Table Data Types

Lesson : 5 | Duration 1.5 hours

  • Data types, Numeric data types, Temporal data types, Character string data types, The meaning of null
6

Database and Table Creation

Lesson : 6 | Duration 1.5 hours

  • Database structure Creation, Database Creation, Table Creation
7

Basic Queries

Lesson : 7 | Duration 1.5 hours

  • The select statement, MySQL workbench for SQL Development, Troubleshooting
8

Database and Table Maintenance

Lesson : 8 | Duration 1.5 hours

  • Deleting an entire database, Maintaining tables, Maintaing columns, Indexes and constraints
9

Table Data Manipulation

Lesson : 9 | Duration 1.5 hours

  • Delete/Modify table row data, The INSERT statement, The REPLACE statement, The UPDATE statement, The DELETE statement
10

Functions

Lesson : 10 | Duration 1.5 hours

  • Simple Functions, Grouping with functions
11

Joining Tables

Lesson : 11 | Duration 1.5 hours

  • Combining multiple tables, Inner joins, Outer joins
12

Table Queries

Lesson : 12 | Duration 1.5 hours

  • What is a subquery, Categories of subqueries, Subquery types, Placing subqueries, Other subquery uses, Converting subqueries to joins
13

Exporting and Importing Data

Lesson : 13 | Duration 1.5 hours

  • Exporting data, Importing data
14

MySQL GUIs

Lesson : 14 | Duration 1.5 hours

  • MySQL enterprise monitor, MySQL workbench
15

Supplemental Information

Lesson : 15 | Duration 1.5 hours

  • Creating views, Transaction, Storage engines, Retrieving metadata, Performance scheme, MySQL enterprise backup
16

Conclusion

Lesson : 16 | Duration 1.5 hours

  • Couse review, MySQL training and certification, Course evalutation, Thank you!, QA session
Do you have questions? Get in touch.
Contact us
Refer & Earn
Talk to Expert Drop us your enquiry
Talk to Expert