MySQL Fundamentals Training
In today's web development marketplace, you need strong MySQL skills to stay competitive.
Our full-day, instructor-led MySQL database training will show you how to quickly and efficiently set up and administer a MySQL database. Using real-world exercises, you'll become proficient in running SQL queries against the server and in customizing a SQL database using the tools in the MySQL distribution.
The MySQL Server
The MySQL server is the engine behind the database, storing and serving data (such as Web pages), authenticating users, handling SQL requests, managing log files and so on. In this opening section of the MySQL training course, you will learn how to:
The MySQL Administrator
This section of the MySQL training class gets you up and running with the MySQL Administrator, a user-friendly tool for remotely managing the MySQL server. You'll learn how to use the Administrator to:
The Query Browser
The MySQL Query Browser enables you to connect to one or more database servers, test various SQL queries, and view results returned by the server. After this session of the MySQL training class, you will know how to:
Structured Query Language (SQL) in MySQL
SQL is the industry-standard language for interacting with relational databases. Using SQL statements, you can connect to a data source, query and sort records, join tables from other sources, and much more. This critical training session examines the SQL language in the context of MySQL. Ultimately, you will be able to:
The MySQL Migration Toolkit
You can migrate your data quickly to MySQL from Oracle, Microsoft SQL Server, and Microsoft Access by using the Migration Toolkit. After finishing this session of our MySQL training, you will have the skills to:
MySQL training offered at four locations::