Уроки MySQL

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

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

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

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

1. Различные типы MySQL программ и исполняемых файлов.
2. Общие настройки для исполняемых файлов MySQL.
3. Как запускать программы.
4. Как задавать опции при запуске программ.
5. Как установить опции и переменные окружения.
6. Расшифровка кодов ошибок через perror.
7. Отображение опций файлов через my_print_defaults
8. Как использовать MySQL Monitor.

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.

1. To use MySQL command-line Monitor.
2. To understand various options.

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.

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.

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.

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.

1. Understand various Table Types (Storage Engines) in MySQL.
2. Understand motivations, benefits and issues using these different types.

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.

1. Forming Expressions.
2. Operators.
3. Different type of functions.

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.

1. Different type of MySQL programs and executables.
2. Managing SQL Modes.
3. Important SQL Modes.
4. Strict checking using SQL Mode.

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

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.

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.

1. To understand Transaction Control in MySQL.
2. To understand data problems.
3. To use savepoints, commit and rollback.

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

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.

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.

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).

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.

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.

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.

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.

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.

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.