MySQL Administration

MySQL Administration

MySQL Administration

1 Star2 Stars3 Stars4 Stars5 Stars (4 votes, average: 3.00 out of 5)
Loading...Loading...

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

    MySQL Product, MySQL Services and Support MySQL Resources, Example Databases.
  2. MySQL Server and Client

    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

    Basics of relational databases, SQL language and MySQL.
  4. Database Designs

    Database Modelling, Keys, Normalization.
  5. Table Data Types

    Data types, Numeric data types, Temporal data types, Character string data types, The meaning of null.
  6. Database and Table Creation

    Database structure Creation, Database Creation, Table Creation.
  7. Basic Queries

    The select statement, MySQL workbench for SQL Development, Troubleshooting.
  8. Database and Table Maintenance

    Deleting an entire database, Maintaining tables, Maintaing columns, Indexes and constraints.
  9. Table Data Manipulation

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

    Simple Functions, Grouping with functions.
  11. Joining Tables

    Combining multiple tables, Inner joins, Outer joins.
  12. Table Queries

    What is a subquery, Categories of subqueries, Subquery types, Placing subqueries, Other subquery uses, Converting subqueries to joins.
  13. Exporting and Importing Data

    Exporting data, Importing data.
  14. MySQL GUIs

    MySQL enterprise monitor, MySQL workbench.
  15. Supplemental Information

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

    Couse review, MySQL training and certification, Course evalutation, Thank you!, QA session.
Enquiry Now