Skip to Main Content

MySQL  (EWSQ101)

Time: 9am - 4pm
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:

Students must have experience with HTML

This course is currently available in another city, on demand or for private classes only. Call us at 888.484.2933 to learn more about our flexible scheduling options or complete our Information Request Form and we will contact you to arrange a class date that is suitable to your availability.

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.

© 2017 Eliquo, Inc. All rights reserved.

Back to Top