Đầu trang

Danh sách Khóa học > Mysql Database Server

  • Mysql Database Server

Thời lượng 48 giờ / Học phí 3,500,000

Mysql là một trong những ứng dụng mã mở miễn phí tốt nhất hiện nay, là hệ quản trị cơ sở dữ liệu ưu việt nhất.

Từ phiên bản 5.0 trở đi đã hổ trợ Store Procedure, Trigger, Transaction.., vì thế tại sao phải tốn nhiều chi phí cho các hệ cơ sở dữ liệu khác, trong khi Mysql miễn phí và nhiều tính năng tương tự.

Nội dung chương trình

  • MySQL Basics

    • Installing MySQL

      • Installing on Linux

      • Configuring Your System

      • Checking Your System Works

      • Setting the Root Password

      • Creating an Account for Basic Use

      • Quick Tour

        • MySQL Directory Structure

        • Overview of Executables

        • Overview of User Interfaces

        • Quick Introduction to the MySQL Monitor

  • Designing and Creating Databases with MySQL

    • Database Design Crash Course

      • Database Concepts and Terminology

      • Database Design Principles

      • Normalization

    • Creating Databases, Tables, and Indexes

      • Case Sensitivity

      • Identifiers in MySQL

      • Creating a Database

      • Selecting a Database

      • Creating Tables

      • Column and Data Types in MySQL

      • Creating Indexes

      • Deleting Databases, Tables, and Indexes

      • Altering Existing Table Structures

  • Writing SQL Queries

    • Simple SELECTs

      • Introduction to the Northwind Database

      • Some Basics

      • SELECTing All Columns in All Rows

      • SELECTing Specific Columns

      • Sorting Records

      • The WHERE Clause and Operator Symbols

      • The WHERE Clause and Operator Words

      • Checking Multiple Conditions

    • Advanced SELECTs

      • Calculated Fields

      • Aggregate Functions and Grouping

      • Built-in Data Manipulation Functions

    • Subqueries, Joins, and Unions

      • Subqueries

      • Joins

      • Unions

    • Inserting, Updating and Deleting Records

      • Using INSERT

      • Using UPDATE

      • Using DELETE

    • Using MySQL Built-In Functions with SELECT

      • Operators

      • Control Flow Functions

      • String Functions

      • Numeric Functions

      • Date and Time Functions

      • Cast Functions

      • Other Functions

      • Functions for Use with GROUP BY Clauses

  • MySQL Table Types and Transactions

    • Understanding MySQL's Table Types

      • ISAM Tables

      • MyISAM Tables

      • InnoDB Tables

      • BerkeleyDB (BDB) Tables

      • MERGE Tables

      • HEAP Tables

    • Using Transactions with InnoDB Tables

      • What Are Transactions? Using Transactions in MySQL

      • The InnoDB Transaction Model

  • Administering MySQL

    • Managing User Privileges

      • Creating User Accounts with GRANT and REVOKE

      • Privilege Levels

      • Evaluating Privileges

      • Using the REVOKE Statement

      • Understanding the Privilege Tables

    • Configuring MySQL

      • Setting MySQL Configuration Options

      • Setting InnoDB Configuration Options

      • Multi-Install Configuration Options

      • Configuring for Internationalization

    • Administering Your Database

      • Starting Up and Shutting Down the MySQL Server

      • Getting Information about the Server and Databases

      • Setting Variables

      • Killing Threads

      • Clearing Caches

      • Understanding the Log Files

      • mysqladmin Option

    • Backup and Disaster Recovery

      • Backing Up and Restoring Your Database

      • Testing Your Backup

      • Checking and Repairing Tables

    • Securing Your MySQL Installation

      • How the Privilege System Works in Practice

      • Securing Accounts

      • Securing Your Installation Files

      • Filtering User Data

      • Other Tips

  • Setup and configure MySQL Clustering

    • Clustering for your Database

      • Cluster Principles

      • High available solution

      • Setting Up and Configuring for Clustering

      • Advanced Topologies

      • The Future of MySQL Clustering

  • Setup and configure MySQL Clustering

    • Replicating Your Database

      • Replication Principles

      • Setting Up and Configuring for Replication

      • Advanced Topologies

      • The Future of MySQL Replication

  • Optimizing MySQL

    • Optimizing Your MySQL Server Configuration

      • Compiling and Linking for Speed

      • Tuning Server Parameters

      • Tuning Other Factors

    • Optimizing Your Database

      • What's Slow in MySQL Databases? Making the Right Design Choices

      • Indexing for Optimization

      • ANALYZE TABLE

      • Using OPTIMIZE TABLE

    • Optimizing Your Queries

      • Finding Slow Queries

      • Benchmarking Your Queries

      • Using the Slow Query Log

      • Using EXPLAIN to See How Queries Are Executed

      • Understanding MySQL's Built-In Query Optimization

      • Optimization Tips

  • Backup & Restore MySQL database:

  • Backup & Restore MySQL database and  Replication

  • Backup & Restore MySQL Clustering

Bonus

  • Backup solutions

  • Using MRTG with Mysql