MYSQL-TOOLS

Comparison of graphical tools for MySQL

Home Уроки MySQL

Уроки MySQL

  • Инсталяция MySQL
    В этом уроке учебника MySQL, вы узнаете ...
    1. Как устанавливать MySQL на различные операционные системы.
    2. Использование параметров при инсталляции.
    3. Конфигурирование инсталляции.

    Процесс инсталляции MySQL значительно усовершенствован и довольно прост.

  • Настройка MySQL
    В этом уроке учебника MySQL, вы изучите...
    1. Различные версии сервера MySQL.
    2. Структуру MySQL каталога.
    3. Как конфигурировать MySQL.
    4. Как изменить пароль пользователя root и других пользователей.

    Сервер MySQL установлен! Прежде использования, вам необходимо его настроить.

  • Программы и утилиты MySQL
    В этом уроке учебника MySQL, вы узнаете ...
    1. Различные типы MySQL программ и исполняемых файлов.
    2. Общие настройки для исполняемых файлов MySQL.
    3. Как запускать программы.
    4. Как задавать опции при запуске программ.
    5. Как установить опции и переменные окружения.
    6. Расшифровка кодов ошибок через perror.
    7. Отображение опций файлов через my_print_defaults
    8. Как использовать MySQL Monitor.
  • User Interfaces MySQL
    In this lesson of the MySQL tutorial, you will learn...
    1. An overview of MySQL user interfaces.
    2. To set up a connection.
    3. About the Query Browser.
    4. About the MySQL Administrator.
    5. About the Migration Toolkit.
    6. About phpMyAdmin.
  • MySQL Monitor
    In this lesson of the MySQL tutorial, you will learn...
    1. To use MySQL command-line Monitor.
    2. To understand various options.
  • Designing Databases
    In this lesson of the MySQL tutorial, you will learn...
    1. To general database concepts.
    2. To use database design principles.
    3. To the basic modeling process.
    4. To normalization forms.

    This lesson serves as a refresher for the core concepts of Database design.

  • Creating Databases and Components
    In this lesson of the MySQL tutorial, you will learn...
    1. To create, use and drop databases.
    2. To create, use and alter tables.
    3. To define columns and constraints for tables.
    4. To create and drop indexes.
    5. To show database, table and index information.

    In this lesson of the MySQL tutorial, we explore management of core storage objects to hold data in MySQL.

  • Identifiers in MySQL
    In this lesson of the MySQL tutorial, you will learn...
    1. To define identifiers in MySQL.
    2. To understand rules and possibilities.
    3. To understand case senstivity on some of the components.
    4. To use special characters in names.
  • Show Database Information
    In this lesson of the MySQL tutorial, you will learn...
    1. Show database, table and index information.
    2. Using INFORMATION-SCHEMA.

    In this lesson of the MySQL tutorial, we learn how to see information about storage elements in MySQL.

  • MySQL Table Types
    In this lesson of the MySQL tutorial, you will learn...
    1. Understand various Table Types (Storage Engines) in MySQL.
    2. Understand motivations, benefits and issues using these different types.
  • Basic Select Statements
    In this lesson of the MySQL tutorial, you will learn...
    1. About the database we'll be using in class.
    2. To comment your SQL code.
    3. To understand SQL syntax.
    4. To select all rows from a table.
    5. To sort record sets.
    6. To filter records.
    7. To use the CASE function to display different values depending on the values of a column or columns.

    The SELECT statement is used to retrieve data from tables. SELECT statements can be used to perform simple tasks such as retrieving records from a single table or complicated tasks such as retrieving data from multiple tables with record grouping and sorting. In this lesson, we will look at several of the more basic ways to retrieve data from a single table.

  • Using Expressions in MySQL Statements
    In this lesson of the MySQL tutorial, you will learn...
    1. Forming Expressions.
    2. Operators.
    3. Different type of functions.
  • Inserting, Updating and Deleting Records in MySQL
    In this lesson of the MySQL tutorial, you will learn...
    1. To insert records into a table.
    2. To replace records in a table.
    3. To insert records, managing duplicates.
    4. To update records in a table.
    5. To delete records from a table.
    6. To delete records using join conditions.
    7. To delete records from joined tables.
    8. To truncate a table.
    9. To use joins with updates.
    10. To use joins with deletes.

    In this lesson of the MySQL tutorial, we will cover MySQL mechanisms to input data into the databases, and update or delete the data as need be.

  • Data Validation in MySQL
    In this lesson of the MySQL tutorial, you will learn...
    1. Different type of MySQL programs and executables.
    2. Managing SQL Modes.
    3. Important SQL Modes.
    4. Strict checking using SQL Mode.
  • Advanced Queries
    In this lesson of the MySQL tutorial, you will learn...
    1. How to use SELECT statements to retrieve calculated values.
    2. To write queries with subqueries.
    3. To select columns from multiple tables with joins.
    4. To select records from multiple tables with unions.
    5. How to work with aggregate functions and grouping.
    6. How to work with SQL's data manipulation functions.
    7. How to use full and outer joins in SELECT, UPDATE, and DELETE statements that link together two or more tables
    8. How to add subqueries to your SELECT, UPDATE, and DELETE statements that retrieve data that can be used by those statements
    9. How to create unions that join together two SELECT statements
    10. How to create and use Views

  • Aggregate Functions and Grouping
    In this lesson of the MySQL tutorial, you will learn...
    1. How to GROUP data elements.
    2. How to aggregate values to generate summary results.
    3. How to filter on grouped results using HAVING.
    4. How to use ROLLUP to generate summary rows.
    5. How to find TOP-n and BOTTOM-n entities.

    The SELECT statement is used to retrieve data from tables. SELECT statements can be used to perform simple tasks such as retrieving records from a single table or complicated tasks such as retrieving data from multiple tables with record grouping and sorting. In this lesson, we will look at several of the more basic ways to retrieve data from a single table.

  • Programming with MySQL
    In this lesson of the MySQL tutorial, you will learn...
    1. How to write functions in MySQL.
    2. How to write Stored Procedures.
    3. How to write Triggers.

    This lesson focuses on the programming aspects of MySQL covering traditional control-structure based code artifacts in MySQL to supplement the regular SQL-based functionality.

  • Managing Transactions in MySQL
    In this lesson of the MySQL tutorial, you will learn...
    1. To understand Transaction Control in MySQL.
    2. To understand data problems.
    3. To use savepoints, commit and rollback.
  • Exporting and Importing Data in MySQL
    In this lesson of the MySQL tutorial, you will learn...
    1. To export Data out of table into a file.
    2. Use field separators and line terminators.
    3. To dump a row in binary form into a file.
    4. Load data from a file into a table.
    5. Create a table from a result set.
    6. Copy data into a table from a result set.
    7. Using the mysqlimport Utility to Import Data
  • Configuring MySQL and Specifying Options
    In this lesson of the MySQL tutorial, you will learn...
    1. To understand configuration options
    2. To understand options behavior and precedence
    3. To set up configuration files
    4. To set options as environment variables
    5. Where the configuration files are located
    6. To use pre-existing Templates
    7. Various options grouping and meanings

    This lesson gives an overview of how MySQL configuration works and what options are available. Some of these configuration options affect performance.

  • Securing MySQL Installation
    In this lesson of the MySQL tutorial, you will learn...
    1. Securing the mysqld Daemon
    2. Securing Your Installation Files
    3. Securing network
    4. Using Encryption and Signatures
    5. Using SSL
    6. Securing Accounts
    7. Limiting User Resources

    In this lesson of the MySQL tutorial, we learn how to secure an MySQL Installation at Operating level. The data-level security (inside of MySQL) is covered in another lesson.

  • Managing Users in MySQL
    In this lesson of the MySQL tutorial, you will learn...
    1. To understand how the Privilege System works in MySQL.
    2. To understand the Privilege Tables and Scopes.
    3. To manage User accounts.
    4. To learn use of GRANT and REVOKE.
    5. To evaluate and set up Privilege Levels.

    Just as in normal life, not all information is intended to be accessible to all individuals. Defying the principles of pure democracy, a MySQL database is often set up to provide selective access where not everyone can view entire data store (let alone alter it).

  • Administering MySQL
    In this lesson of the MySQL tutorial, you will learn...
    1. To start up and shut down the MySQL Server
    2. To view Information about the Server and Databases
    3. To view and kill Threads
    4. To clear System Caches
    5. Various mysqladmin Options

    In this lesson of the MySQL tutorial, we learn about Administration aspects in MySQL.

  • Data Backup and Restore in MySQL
    In this lesson of the MySQL tutorial, you will learn...
    1. To use the mysqldump utility to back up tables in a single or multiple databases.
    2. To use the backup files with mysql monitor to restore databases or tables.
    3. To use various mysqldump Options.
    4. To use binary logs to update restored databases.
    5. To understand InnoDB-specific such as checkpoints.

    In this lesson of the MySQL tutorial, we learn about backup and restore mechanisms available in MySQL.

  • Optimizing Databases and Their Objects
    In this lesson of the MySQL tutorial, you will learn...
    1. To understand optimization basis
    2. To manage Resources

    In this lesson of the MySQL tutorial, we learn how to optimize MySQL databases for performance.

  • Optimizing and Tuning Queries
    In this lesson of the MySQL tutorial, you will learn...
    1. To understand optimization basis
    2. To manage Resources
    3. To optimally use indexes
    4. Advantages and disadvantages of indexing and when you should use indexing.
    5. To effectively tune your queries and learn steps to improve data-related operations.
    6. To use slow query log.

    In this lesson of the MySQL tutorial, we learn about the several steps that you can take to optimize the performance of your SQL statements. By optimizing performance, you're maximizing the speed and efficiency at which those statements are executed.

  • Tuning MySQL for Performance
    In this lesson of the MySQL tutorial, you will learn...
    1. Install tuning, Optimizing MySQL System Variables
    2. Tuning Server Parameters
    3. Tuning Other Factors
    4. System Characteristics and Slowness Elements
    5. Enabling your system's query cache
    6. Compiling and Linking for Speed

    In this lesson of the MySQL tutorial, we learn various elements of tuning an MySQL Installation at Operating level. The query and database optimizations are covered in other lessons.

  • Replication in MySQL
    In this lesson of the MySQL tutorial, you will learn...
    1. Replication concepts and principles
    2. Setting up replication on master and slave servers
    3. Managing replication
    4. Replication settings

    In this lesson of the MySQL tutorial, we learn about the process of database Replication in MySQL.

    Beside performing regular backups of your databases, you can also replicate your databases meaning that you maintain a copy of the database that is kept up-to-date (synchronized) with the original database. If the original database becomes unavailable, the replicated database can continue to provide users immediate access to the same data with a minimal amount of downtime.

    This lesson describes setting up replication on master and slave servers and then managing the replication process.

mysql tools