MYSQL & PHP training classes     
USACanada UK Ireland International
1 877 849 1850   0808 234 2132   1 800 550 311   +1 678 648 3113
  Home   Contact Us
XML training * MySQL & PHP Training * Tomcat Training * Perl Training
Ajax Training *Dojo Training *Ruby on Rails Training * Groovy Training * Grails Training
HTML, XHTML, & JavaScript Training * Authorware Training * Articulate Training * Live Online Training


* MySQL Training: Introduction to MySQL Databases
* MySQL Training: MySQL Development
* MySQL Training: MySQL Administration
* MySQL Training: Introduction to MySQL Development and Administration
* MySQL Training: MySQL Database Design
* MySQL Training: MySQL Optimization
* MySQL Training: Introduction to SQL Using MySQL

* PHP Training: Introduction to PHP and MySQL
* PHP Training: Advanced PHP
* Building Data-Driven PHP/MySQL Web Sites with Dreamweaver



Please contact us
for GSA pricing.

GSA

Contract #
GS-35F-0307T



Complimentary MySQL or PHP Training Seminar

Organizations in the Atlanta, Georgia area are encouraged to contact Accelebrate® about having a complimentary, one-hour MySQL or PHP training seminar delivered for their developers. Contact us today for more information.



Recent Training Venues

Accelebrate has recently trained for clients in the following cities:

  • Huntsville, Alabama
  • Montgomery / Birmingham, Alabama
  • Anchorage, Alaska
  • Calgary, Alberta
  • Phoenix, Arizona
  • Fayetteville / Little Rock, Arkansas
  • Oakland / San Jose / San Francisco, California
  • Sacramento, California
  • Oceanside / San Diego, California
  • Pasadena / Orange County / Los Angeles, California
  • San Bernardino / Riverside, California
  • Boulder / Colorado Springs / Denver, Colorado
  • Washington, DC
  • Wilmington, Delaware
  • Manchester / London, England
  • DeLand / Orlando, Florida
  • Fort Lauderdale / Miami, Florida
  • Gainesville / Jacksonville, Florida
  • Saint Petersburg / Tampa, Florida
  • Titusville & Melbourne, Florida
  • Alpharetta & Atlanta, Georgia
  • Augusta & Savannah, Georgia
  • Macon & Columbus, Georgia
  • Boise, Idaho
  • Bloomington, Illinois
  • Chicago, Illinois
  • Indianapolis, Indiana
  • Cedar Rapids / Des Moines, Iowa
  • Dublin, Ireland
  • Kingston, Jamaica
  • Wichita, Kansas
  • Paducah / Lexington / Louisville, Kentucky
  • Baton Rouge, Louisiana
  • Valletta, Malta
  • Hagerstown & Frederick, Maryland
  • Greenbelt / Silver Spring / Baltimore, Maryland
  • Boston / Cambridge, Massachusetts
  • Hartford, Connecticut / Springfield, Massachusetts
  • Taunton, Massachusetts / Providence, Rhode Island
  • Ann Arbor / Farmington Hills / Detroit, Michigan
  • Grand Rapids, Michigan
  • Lansing, Michigan
  • Saginaw / Flint / Bay City / Midland, Michigan
  • Saint Paul / Minneapolis, Minnesota
  • Jackson, Mississippi
  • Gulfport / Biloxi, Mississippi
  • St. Louis, Missouri
  • Whiteman Air Force Base / Kansas City, Missouri
  • Lincoln / Omaha, Nebraska
  • Reno and Las Vegas, Nevada
  • Santa Fe / Albuquerque, New Mexico
  • Newark, New Jersey
  • Princeton, New Jersey & Philadelphia, Pennsylvania
  • White Plains / New York City, New York
  • Charlotte, North Carolina
  • Durham / Raleigh, North Carolina
  • Bowling Green / Toledo, Ohio
  • Canton / Akron, Ohio
  • Cincinnati, Ohio
  • Cleveland & Columbus, Ohio
  • Dayton, Ohio
  • Tulsa / Oklahoma City, Oklahoma
  • Toronto, Ontario
  • Portland, Oregon
  • Pittsburgh, Pennsylvania
  • Providence, Rhode Island
  • Edinburgh / Glasgow, Scotland
  • Columbia & Charleston, South Carolina
  • Chattanooga / Knoxville, Tennessee
  • Memphis / Jackson / Nashville, Tennessee
  • College Station and Houston, Texas
  • El Paso, Texas / Ciudad Juarez, Mexico
  • San Antonio / Austin, Texas
  • Wichita Falls & Dallas, Texas
  • Ogden / Salt Lake City, Utah
  • Burlington, Vermont
  • Fairfax / Dulles / McLean / Herndon / Reston, Virginia
  • Richmond / Alexandria / Arlington, Virginia
  • Virginia Beach / Norfolk, Virginia
  • Tacoma / Seattle, Washington
  • Madison / Milwaukee, Wisconsin

 

MySQL Training: Introduction to SQL Using MySQL Training
Print This Outline
E-mail This Outline
Get A Quote
Course Number: 648
Duration: 2 days
view class outline

SQL Using MySQL Training Overview

Accelebrate's Introduction to SQL using MySQL course is designed for students new to writing SQL queries using MySQL.

Location and Pricing

Most Accelebrate courses are taught on-site at our clients' locations worldwide for groups of 3 or more attendees and are customized to their specific needs. Please visit our client list to see organizations for whom we have recently delivered training. To receive a customized proposal and price quote, please contact us.

In addition, some courses are available as live, online classes for individuals.  To see a schedule of online courses, please visit http://www.accelebrate.com/online_training/xml_html_js.htm.

SQL Using MySQL Training Prerequisites

Experience in basic computer literacy with previous experience with command-line programs and some knowledge of database concepts is required. Some knowledge of data retrieval and reporting would be beneficial.

Hands-on/Lecture Ratio

This MySQL training class is 65% hands-on, 35% lecture, with the longest lecture segments lasting for 20 minutes. Students "learn by doing," with immediate opportunities to apply the material they learn to real-world problems.

SQL Using MySQL Training Materials

All MySQL training students receive

Software Needed on Each Student PC

  • MySQL 5.0 or later (class can be adapted for earlier versions upon request)
  • If you have purchased this course, please contact us for additional setup instructions

SQL Using MySQL Training Objectives

  • Understand how MySQL works
  • Learn to use SQL to output reports with MySQL
  • Learn to modify MySQL data with SQL
  • Learn to create a simple MySQL database
  • Learn to create simple work with Views and Stored Procedures in MySQL
  • Learn to create tables in MySQL

Note: MySQL training students interested in learning how to use MySQL to build database-driven Web sites are also encouraged to consider our PHP Training: Introduction to PHP and MySQL.

SQL Using MySQL Training Outline

  • Relational Database Basics
    • Brief History of SQL
    • Relational Databases
      • Tables
      • Rows
      • Columns
      • Relationships
      • Datatypes
      • Primary Keys
      • Foreign Keys
      • Relational Database Management System
    • Popular Databases
      • Commercial Databases
      • Popular Open Source Databases
      • Valid Object References
    • SQL Statements
      • Database Manipulation Language (DML)
      • Database Definition Language (DDL)
      • Database Control Language (DCL)
  • Simple SELECTs
    • Introduction to the Northwind Database
    • Some Basics
      • Comments
      • Whitespace and Semi-colons
      • Case Sensitivity
    • SELECTing All Columns in All Rows
    • Exploring the Tables
    • SELECTing Specific Columns
    • SELECTing Specific Columns
    • Sorting Records
      • Sorting By a Single Column
      • Sorting By Multiple Columns
      • Sorting By Column Position
      • Ascending and Descending Sorts
    • Sorting Results
    • The WHERE Clause and Operator Symbols
      • Checking for Equality
      • Checking for Inequality
      • Checking for Greater or Less Than
      • Checking for NULL
      • WHERE and ORDER BY
    • Using the WHERE clause to check for equality or inequality
    • Using the WHERE clause to check for greater or less than
    • Checking for NULL
    • Using WHERE and ORDER BY Together
    • The WHERE Clause and Operator Words
      • The BETWEEN Operator
      • The IN Operator
      • The LIKE Operator
      • The NOT Operator
    • More SELECTs with WHERE
    • Checking Multiple Conditions
      • AND
      • OR
      • Order of Evaluation
    • Writing SELECTs with Multiple Conditions
  • Advanced SELECTs
    • Calculated Fields
      • Concatenation
      • Mathematical Calculations
      • Aliases
    • Calculating Fields
    • Aggregate Functions and Grouping
      • Aggregate Functions
      • Grouping Data
      • Selecting Distinct Records
    • Working with Aggregate Functions
    • Built-in Data Manipulation Functions
      • Common Math Functions
      • Common String Functions
      • Common Date Functions
    • Data Manipulation Functions
  • Subqueries, Joins and Unions
    • Subqueries
    • Subqueries
    • Joins
      • Table Aliases
      • Multi-table Joins
    • Using Joins
    • Outer Joins
    • Unions
      • UNION ALL
      • UNION Rules
    • Working with Unions
  • Conditional Processing with CASE
    • Using CASE
    • Working with CASE
  • Inserting, Updating and Deleting Records
    • INSERT
    • Inserting Records
    • UPDATE
    • DELETE
    • Updating and Deleting Records
  • Creating and Modifying Tables
    • Data Types
    • Creating Tables
      • NULL Values
      • Primary Keys
      • Foreign Keys
    • Creating Tables
    • Adding and Dropping Columns
    • Renaming Tables
      • SQL Server
      • Oracle and MySQL
    • Dropping Tables
  • Views
    • Creating Views
    • Dropping Views
    • Benefits of Views
    • Creating a View
  • Stored Procedures
    • Creating Stored Procedures
    • Dropping Stored Procedures
    • Creating a Stored Procedure
    • Benefits of Stored Procedures
  • Conclusion
 
Print This OutlineE-mail This OutlineGet A Quote

Java® and all Java-based marks are trademarks or registered trademarks of Sun Microsystems, Inc. in the U.S. and other countries.

MySQL™ and all MySQL-based marks are trademarks or registered trademarks of Sun Microsystems, Inc. or its subsidiaries in the U.S. and other countries.
Accelebrate®
Comes to You!


Accelebrate's courses are taught exclusively on-site at your location for groups of 3 or more attendees, anywhere worldwide.

Don't settle for a "one size fits all" public class! Have Accelebrate come to your site and deliver exactly the training you want, for less than the cost of a public class.

For pricing and to learn more, please call us at +1 877 849 1850, fill out our information request form, or email us at info@accelebrate.com today.
 
Accelebrate E-Newsletter


Get the latest Web development news delivered to your email box once a month!

VB.NET, C#, ASP, & ASP.NET Training * Java Training * SQL Server Training
Adobe Training * PHP Training * XML Training * Perl Training

“Accelebrate,” “Accelerated Learning Celebrated Results,” and the Accelebrate logo are registered trademarks of Accelebrate, Inc. All other product names and trademarks are property of their respective owners. Course outline content may mirror or be derived from the book that each student receives with the course. Otherwise, all content is copyright © 2003- by Accelebrate, Inc. of Atlanta, Georgia, USA. To contact us, please use the contact form, email info@accelebrate.com us, or call 1 877 849 1850 in the US and Canada, 0808 234 2132 in the UK, 1 800 550 311 in Ireland, or +1 678 648 3113 from all other locations.

Recent client sites: Birmingham, AL | Phoenix, AZ | Los Angeles, CA | Sacramento, CA | San Diego, CA | San Francisco, CA | San Jose, CA | Denver, CO | Washington, DC | Jacksonville, FL | Miami, FL | Orlando, FL | Tampa, FL | Atlanta, GA | Chicago, IL | Indianapolis, IN | Boston, MA | Baltimore, MD | Detroit, MI | Minneapolis, MN | Kansas City, MO | Saint Louis, MO | Charlotte, NC | Raleigh, NC | Albuquerque, NM | Las Vegas, NV | New York City, NY | Cincinnati, OH | Cleveland, OH | Columbus, OH | Dayton, OH | Oklahoma City, OK | Toronto, ON | Portland, OR | Philadelphia, PA | Pittsburgh, PA | Memphis, TN | Nashville, TN | Austin, TX | Dallas, TX | Houston, TX | San Antonio, TX | Salt Lake City, UT | Seattle, WA | Dublin, Ireland | London, UK
About Accelebrate IT Training VB.NET, C#, and ASP.NET Training Java, Struts, and JSP Training Adobe Training Microsoft SQL Server Training XML Training, PHP Training, Perl Training, and Other Courses Database and Reporting Training