MYSQL-TOOLS

Comparison of graphical tools for MySQL

Home MySQL Lessons

MySQL Lessons

  • Installing MySQL
    In this lesson of the MySQL tutorial, you will learn...
    1. To install MySQL on different Operating Systems.
    2. To use installation options.
    3. To configure and check the installation.
    4. To consider Non-traditional installation as in building Source Files.

    Installing MySQL is considerably streamlined and usually straightforward when using defaults as shown below.

     

  • Setting up MySQL

    In this lesson of the MySQL tutorial, you will learn...

    1. Various versions of MySQL server.
    2. The MySQL directory structure.
    3. To configure MySQL.
    4. To setup the root password and accounts.

    Once MySQL has been installed, you need to set it up for usage.

  • MySQL Programs and Executables
    In this lesson of the MySQL tutorial, you will learn...
    1. Different types of MySQL programs and executables.
    2. Common options for MySQL executables.
    3. To invoke programs.
    4. To specify options for programs.
    5. To set options and environment variables.
    6. To understand error codes via perror
    7. To display options from files via my_print_defaults
    8. To use 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


How create data source in Visual Studio with data from My SQL tables with FK. more...

'mysql.proc' doesn't exist fixed problem

_

Table 'mysql.proc' doesn't exist. Fix error 1146 Table doesn't exist here...