AcademyX Computer Training Logo (800) 716-4324
info@academyx.com
company catalog schedule discounts register contact

Training Links

Course Catalog

Student FAQ

ETP-Funded Training

Register

MySQL Fundamentals Training

In today's web development marketplace, you need strong MySQL skills to stay competitive.

Designed specifically as a web back end, MySQL databases power many of today's high-traffic websites, such as YouTube, Facebook, Flickr, and Yahoo. If you're trying to stay up-to-date with the stack of open-source applications known as LAMP (Linux, Apache, MySQL, and HP/Python/Perl), you'll want to include MySQL in your programming toolkit.

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:

  • Choose from the various installation options
  • Determine where key fields reside within a folder
  • Plan the best configuration for a deployment

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:

  • Remotely configure the MySQL server
  • Administer users and set privilege levels
  • Define a database schema, add table structures, and set key constraints
  • Optimize the database and perform backups

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:

  • Install and use the Query Browser
  • Connect to a data source
  • Execute test queries against a database server
  • Monitor and evaluate the results of your queries

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:

  • Create, update or delete records
  • Select and sort records
  • Join data from related tables
  • Perform calculations, such as sales by department, on groups of data
  • Design triggers that execute automatically when data is changed
  • Use stored procedures that store your SQL statements within functions
  • Create transactions that, for example, decrement inventory and increment sales

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:

  • Set up and use the migration wizard
  • Configure the type of migration you want to set up
  • Map the source and target databases
  • Define how schemas and tables should be imported
  • Manually configure objects that did not import properly

Prerequisites:

  • Experience with at least one other database

MySQL training offered at four locations::

Newsletter subscribers can win $100 credit!