Loading...
Skip to Main Content

Course Details

Time: 9AM - 4PM Eastern Time (ET)
Duration: 2 Days

Description:

MySQL is one of the simplest ways for you to store, manipulate and retrieve large amounts of different types of data. Let us show you the core aspects of the language including how to create a MySQL database, write SQL statements and integrate it with programming languages. We'll also show you some handy MySQL tools to make your life easier.

Prerequisites:

None

Web Design Course

Public Class Schedule

We're Here to Help

Don't see the dates you need? Call us at 888.484.2933 or Tell Us What You Need.

Course Outline

  • Database Design
    • what is a database?
    • why use a database?
    • types of databases
  • Introduction to MySQL
    • what is MySQL?
    • history of MySQL
    • main features
  • Queries
    • connecting and disconnecting
    • MySQL syntax
    • reserved words
  • Working with a Database
    • creating the database
    • selecting the database
    • creating and describing tables
    • loading data into a table
    • retrieving data from a table
  • Data Types
    • choosing the right data type
    • numeric types
    • date and time types
    • string types
  • Functions and Operators
    • comparison functions and operators
    • logical operators
    • string functions
    • numeric functions
    • date and time functions
  • Query Examples
    • practical examples
  • Importing and Exporting
    • exporting records, tables and databases
    • importing records, tables and databases
  • MySQL Integration
    • third-party programs
    • PHP
    • ASP
    • Flash

Private training is available for this course.

Call us at 1-888-484-2933 to learn more about our flexible scheduling options or complete our Information Request Form.

Web-based training is super easy to set up and doesn’t require fancy software.

Find a Course