MySQL school training courses in Dallas, TX (public, in-house or online)

Understand the steps necessary to invoke MySQL client programs

Utilize the general-purpose mysql client program and the MySQL Query Browser graphical user interface (GUI) to run queries and retrieve results

Select the best data type for representing information in MySQL

Manage the structural characteristics of your databases and the tables within your databases

Utilize the SELECT statement to retrieve information from database tables

Utilize expressions...

Full archival course description>>

Install and Upgrade MySQL 5.0 for the most common operating systems

Utilize the MySQL Administrator Graphical User Interface (GUI) to manage a MySQL server

Use the INFORMATION_SCHEMA database to access metadata

Perform the MySQL start and shutdown operations

Configure MySQL server options at runtime

Evaluate data types and character sets for performance issues

Understand data locking concepts and the different levels of locking in MySQL

...

Full archival course description>>

Create a database design using an efficient structure

Be able to extract basic database information using the SELECT command

Be able to troubleshoot syntax and understand typical warnings and errors

Be able to delete or modify a database, and table row data

Grouping query data with Aggregation

Connect data from multiple table rows using JOIN

Perform nested sub-queries

Use of Simple Functions (String, Date, Numerical)




Full archival course description>>

Today’s websites are increasingly dynamic. Pages are no longer static HTML files but instead generated by scripts and database calls. User interfaces are more seamless, with technologies like Ajax replacing traditional page reloads. This course teaches students how to build dynamic websites with Ajax and with Linux, Apache, MySQL, and PHP (LAMP), one of today’s most popular frameworks. Students learn how to set up domain names with DNS, how to structure pages with XHTML and CSS, how to...

Full archival course description>>

In this PHP training course, students will learn to create database-driven websites using PHP and MySQL or the database of their choice. The class also covers SQL basics.

Class Goals
•Learn how PHP works.
•Learn the basic syntax of PHP.
•Learn to create dynamic interactive pages with PHP.
•Learn to manipulate files with PHP.
•Learn to work with arrays in PHP.
•Learn to validate forms with PHP.
•Learn to write functions in PHP.
•Learn to manipulate and m...

Full archival course description>>