MySQL (MS311)

This course provides students with a comprehensive overview of MySQL. Students will be able to install, run, tune, create and use databases. Basics of database applications will also be covered so that the student will have the tools to create database backed websites. MySQL is an open source relational database that is free for most uses. It has wide platform support and can be quickly deployed. MySQL has become a standard for small and medium sized organizations, as it is affordable, reliable, and fast.

Applicable Job Roles: web programmers, web application developers, and database administrator.

Outline
Week 1: Introducing MySQL
  • Understand what a relational database is
  • Compare MySQL with other relational databases
  • Understand the role of MySQL in industry
Week 2: Database Design
  • Understand data structure and entities
  • Be able to model data and build relationships
  • Know how to normalize a database
Week 3: Installing MySQL
  • Understand the MySQL open source license
  • Be able to troubleshoot common installation issues
  • Learn how to use the MySQL command line
  • Effectively use MySQL security
Week 4: MySQL Specific Syntax
  • Be able to use column types effectively
  • Know how to use special commands to effciently use MySQL
  • Be able to pinpoint problems and understand performance tuning
Week 5: Database Application Architecture
  • Understand basic client/server and 3-tier architectures
  • Understand concepts of data processing
  • Understand object/relational modeling for MySQL
  • Design an application model
Week 6: Basics of Database Programming for MySQL
  • Identify languages that support MySQL
  • Understand the CGI specification
  • Know how to initiate and terminate a database connection
  • Create simple dynamically generated HTML
Prerequisites
MS300 Intro to Database Design (or previous formal training with database design)
One of the SQL courses (MS303, MS304, MS302 or MS301) (or basic knowledge of SQL)
Knowledge of HTML is helpful.
Requirements
  • Database access to a server with MySQL -OR- Windows/Mac/Linux/Unix machine with latest production version of MySQL (free download)

Books:
Suggested Book: Mysql Tutorial

Additional information:

Your place in the course is confirmed by your payment. Introductory courses are intended for students with no experience in the subject matter and are seeking beginner level training.

Refund Policy: Please read our Terms and Refund Policy before registering for this course.

Additional Cost: Book and software might be required for the course. Read the Requirements and Book section for more information. Course fee does not include the book and software cost .

How eClasses Work:Instructors post lectures (text-based, no video or audio), reading selections, and hands-on assignments once a week in the online classroom. Students can discuss the assignments with the instructor and amongst themselves in the classroom area. This format has no set meeting time, which allows students to attend class at a time most convenient to them, yet still provides logically organized communication between class participants. Students can apply for the completion certificate after finishing the class.

Student CenterStudent Center
Cart is empty
MySQL
Price: $220.00
Item No.: MS311
Instructor: Katharine Osborne
CEUs: 3
Duration: 6 weeks
Open Courses:
Start Date: May 28, 2013
(Register by: May 31, 2013 )
 
Start Date: Jun 10, 2013
(Register by: Jun 13, 2013 )
 
Start Date: Jul 22, 2013
(Register by: Jul 25, 2013 )
 
Start Date: Aug 19, 2013
(Register by: Aug 22, 2013 )
 
Start Date: Sep 16, 2013
(Register by: Sep 19, 2013 )
 
Start Date: Oct 14, 2013
(Register by: Oct 17, 2013 )
 
Start Date: Nov 11, 2013
(Register by: Nov 14, 2013 )
 
Instructor's ProfileInstructor
Katharine Osborne has been a web developer since 1996, and a Unix administrator since 1995. She has been building database backed web applications since 1998 using MySQL, Perl, and PHP. Her teaching experience encompasses ecommerce, web development, programming, and database subjects at the University level. She now owns a web development consultancy helping small businesses establish and improve their web presence.
Before you register for this class, please read the Outline, Prerequisites, Requirements, Books, and Refund Policy sections carefully.
Send to friend
: *
: *
: *
 
We would like to recommend these
Completion Certificate - MySQL (C.MS311)
Introduction to SQL (Using MySQL) (MS304)
Introduction to Database Design (MS300)
Introduction to Apache Administration (B118)
Shopping Cart Using PHP and MySQL (P104)
 

Testimonials

Rating
No testimonial available!