MySQL

Database
5 Hours -
Number of Students
-
+
Date: Time:

Introduction to MySQL with phpMyAdmin

  • Database Fundamentals
  • Database Tables
  • Primary Keys
  • Data Types
  • Relational Databases
  • Foreign Keys
  • Database Normalization
  • Using mysqlimport & mysqldump
  • The SELECT Statement
  • Combining Multiple Tables
  • Joining Tables with SELECT
  • Comma-Separated Joins
  • Inner Joins
  • Outer Joins
  • Importing and Exporting Data

MySQL with phpMyAdmin - Level 2

  • Deleting databases and tables
  • Copying an existing table structure
  • Adding, removing and modifying table columns
  • Manipulating Table Row Data
  • The INSERT Statement
  • The REPLACE Statement
  • The UPDATE Statement
  • The DELETE Statement
  • Using Functions
  • String Functions
  • Numeric Functions
  • Aggregate Functions
Request Now
Name:
Email:
Phone:
Address:
Unit:

Course Customization

Our goal is to make sure the class meets your objectives. We will gladly change course topics to best suit the classroom situation.


Disclaimer

All of our outlines are treated as guides to help steer the training session. There is no guarantee that all the topics listed will be covered in the time allowed. The amount of material covered is based on the skill level of the attendees.

Map
Powered by Google Maps

No Additinal Charges Apply

Chicago IL, Bensenville, Cicero, Des Plaines, Elmwood Park, Evanston, Forest Park, Franklin Park, Glencoe, Glenview, Golf, Kenilworth, Lincolnwood, Melrose Park, Morton Grove, Mount Prospect, Niles, Northbrook, Oak Park, Park Ridge, River Forest, River Grove, Schiller Park, Skokie, Techny, Wilmette, Winnetka, Wood Dale.


$75 Travel Charge Applies

Addison, Algonquin, Aurora, Barrington, Bartlett, Batavia, Bedford Park, Bellwood, Berkeley, Berwyn, Bloomingdale, Bolingbrook, Bridgeview, Broadview, Brookfield, Buffalo Grove, Burbank, Calumet City, Carol Stream, Cary, Chicago Heights, Chicago Ridge, Clarendon Hills, Crystal Lake, Darien, Deerfield, Downers Grove, Dundee, East Chicago, Elgin, Elmhurst, Evergreen Park, Fox Lake, Fox River Grove, Fox Valley, Frankfort, Gary, Geneva,Glen Ellyn, Glendale Heights, Glenwood, Grayslake, Great Lakes, Gurnee, Hammond, Hanover Park, Harvey, Harwood Heights, Hickory Hills, Highland, Highland Park, Highwood, Hines, Hinsdale, Hoffman Estates, Itasca, Joliet, La Grange, Lake Bluff, Lake Forest, Lake Villa, Lake Zurich, Libertyville, Lincolnshire, Mchenry, Mokena, Mundelein, Naperville, North Chicago, Oak Brook, Oak Lawn, Orland Park, Oswego, Palatine, Palos Heights, Plainfield, Pleasant Prairie, Prospect Heights, Riverdale, Riverside, Rolling Meadows, Romeoville, Roselle, Schaumburg, Stone Park, Streamwood, Sugar Grove, Tinley Park, University Park, Vernon Hills, Villa Park, Warrenville, Waukegan, West Chicago, Westchester, Wheaton, Wheeling, Willowbrook, Woodridge, Zion.


Contact Us for a Quote

We able to serve nearby major cities Rockford, IL, Springfield, IL, Milwaukee, WI, Madison WI, Indianapolis IN as well as all major cities in the US. Charges will be based on the duration of travel and travel expenses.