MySQL school training courses in Chicago, IL (public, in-house or online)

MySQL Introduction will allow you to work with databases by identifying the fundamental concepts of databases, creating a preliminary database design, applying normalization techniques, and familiarizing yourself with relational database management systems. Using various SQL commands, indexes, and views, you can work with and modify data efficiently within a database.
Our classes are all instructor-led, hands-on learning. Each student has their own computer and is given a student manual with...

Full archival course description>>

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