Home » Course Catalog » Online Training Course Objectives and Outline
PHP and MySQL Series: SQL and MySQL
Product Code: phps05 Time: 4.0 hour(s) CEUs: Available

Summary:

After taking this course, the learner will be able to create databases and tables, and sort and retrieve data using SQL and MySQL.

Objectives:

  • Choose column types and other column properties
  • Create databases and tables
  • Insert records, select, update and delete data
  • Use conditionals and functions


Topics:

  • MySQL
  • Choosing column types
  • Choosing other column properties
  • Using mysql client
  • Creating databases and tables
  • Inserting records
  • Selecting data
  • Using conditionals
  • Using LIKE and NOT LIKE
  • Sorting and limiting query results
  • Updating and deleting data
  • Using text and numeric functions
  • Formatting date and time functions

Technical Requirements:

P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Cookies enabled; Sound card with speakers or headphones strongly recommended.



Return To Top

Training Courses | e-Learning Edge | Training Course Certifications | Training Course Sign-up
Student Center | Learning Resources | Free Courses | Privacy Policy | Contact e-Learning Center

Hot Topics
IT Courses
MS Certs
Web Design
MS Office
Programming
Business
Networking
VS .NET
Personal
Full Catalog

Christian Website

Member of the Better Business Bureau Better Business Bureau
Member since 2002
Subscribe today as a member to our I.T. department and capitalize on free courses and 20% discount on our laptop computers.

Combo Packs... »

Save even more when you sign up for a combination package. Our BEST values EVER!

Read More

© 1599-2009 SK Max. All rights reserved.

General IT Web Design Microsoft Certs


Desktop Computing Business Skills Personal Skills


Combo Packages Business Videos

Articles

Features

Benefits

FAQs

e-Learning Links

e-Learning Forum

Certification Info

Other Resources

Home PageContact InformationSearch the Site
HomeOur Course Cataloge-Learning EdgeStudent Centere-ResourcesCorporate Information