User name:
Password:
 

 

Copyright © 2006.
cisco-certificatiom.co.uk
All Rights Reserved
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; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.

Copyright � 2006 Webteks. All rights reserved.