| Sign in | Sitemap | Feedback
Go To AppexTech

MySql Database Training

1 Hour Daily

Duration:- ... Months

MySQL is the world's most popular open source client-server database. In this three-day, hands-on course, attendees learn the fundamentals of writing MySQL queries and of administering the MySQL database.

MySQL Training Objectives

All attendees will learn to:

  1. To learn how to properly set up and configure MySQL
  2. To master creating and querying databases in MySQL
  3. To learn how to administer and secure a MySQL database
  4. To discover how to write applications that integrate with MySQL databases

MySQL Training Outline

  1. MySQL Basics
    1. Installing MySQL
      1. Installing on Linux
      2. Configuring Your System
      3. Checking Your System Works
      4. Setting the Root Password
      5. Deleting Anonymous Accounts
      6. Creating an Account for Basic Use
      7. Quick Tour
        1. MySQL Directory Structure
        2. Overview of Executables
        3. Overview of User Interfaces
        4. Quick Introduction to the MySQL Monitor
  2. Designing and Creating Databases with MySQL
    1. Database Design Crash Course
      1. Database Concepts and Terminology
      2. Database Design Principles
      3. Normalization
    2. Creating Databases, Tables, and Indexes
      1. Case Sensitivity
      2. Identifiers in MySQL
      3. Creating a Database
      4. Selecting a Database
      5. Creating Tables
      6. Column and Data Types in MySQL
      7. Creating Indexes
      8. Deleting Databases, Tables, and Indexes
      9. Altering Existing Table Structures
  3. Writing SQL Queries
    1. Simple SELECTs
      1. Introduction to the Northwind Database
      2. Some Basics
      3. SELECTing All Columns in All Rows
      4. SELECTing Specific Columns
      5. Sorting Records
      6. The WHERE Clause and Operator Symbols
      7. The WHERE Clause and Operator Words
      8. Checking Multiple Conditions
    2. Advanced SELECTs
      1. Calculated Fields
      2. Aggregate Functions and Grouping
      3. Built-in Data Manipulation Functions
    3. Subqueries, Joins, and Unions
      1. Subqueries
      2. Joins
      3. Unions
    4. Inserting, Updating and Deleting Records
      1. Using INSERT
      2. Using UPDATE
      3. Using DELETE
    5. Using MySQL Built-In Functions with SELECT
      1. Operators
      2. Control Flow Functions
      3. String Functions
      4. Numeric Functions
      5. Date and Time Functions
      6. Cast Functions
      7. Other Functions
      8. Functions for Use with GROUP BY Clauses
  4. MySQL Table Types and Transactions
    1. Understanding MySQL's Table Types
      1. ISAM Tables
      2. MyISAM Tables
      3. InnoDB Tables
      4. BerkeleyDB (BDB) Tables
      5. MERGE Tables
      6. HEAP Tables
    2. Using Transactions with InnoDB Tables
      1. What Are Transactions? Using Transactions in MySQL
      2. The InnoDB Transaction Model
  5. Administering MySQL
    1. Managing User Privileges
      1. Creating User Accounts with GRANT and REVOKE
      2. Privilege Levels
      3. Evaluating Privileges
      4. Using the REVOKE Statement
      5. Understanding the Privilege Tables
    2. Configuring MySQL
      1. Setting MySQL Configuration Options
      2. Setting InnoDB Configuration Options
      3. Multi-Install Configuration Options
      4. Configuring for Internationalization
    3. Administering Your Database
      1. Starting Up and Shutting Down the MySQL Server
      2. Getting Information about the Server and Databases
      3. Setting Variables
      4. Killing Threads
      5. Clearing Caches
      6. Understanding the Log Files
      7. mysqladmin Option
    4. Backup and Disaster Recovery
      1. Backing Up and Restoring Your Database
      2. Testing Your Backup
      3. Checking and Repairing Tables
    5. Securing Your MySQL Installation
      1. How the Privilege System Works in Practice
      2. Securing Accounts
      3. Securing Your Installation Files
      4. Filtering User Data
      5. Other Tips
    6. Replicating Your Database
      1. Replication Principles
      2. Setting Up and Configuring for Replication
      3. Advanced Topologies
      4. The Future of MySQL Replication
  6. Optimizing MySQL
    1. Optimizing Your MySQL Server Configuration
      1. Compiling and Linking for Speed
      2. Tuning Server Parameters
      3. Tuning Other Factors
    2. Optimizing Your Database
      1. What's Slow in MySQL Databases? Making the Right Design Choices
      2. Indexing for Optimization
      3. ANALYZE TABLE
      4. Using OPTIMIZE TABLE
    3. Optimizing Your Queries
      1. Finding Slow Queries
      2. Benchmarking Your Queries
      3. Using the Slow Query Log
      4. Using EXPLAIN to See How Queries Are Executed
      5. Understanding MySQL's Built-In Query Optimization
      6. Optimization Tips

Open Source Technology