Introduction to MySQL

Programming relational databases

In this course you'll get hands-on experience with the MySQL open-source relational database system. The course provides exercises that will help you gain familiarity with the MySQL command-line tools, querying using SQL, and data-manipulation actions (inserts, updates, and deletes). The course also provides an introduction to relational data design in MySQL and concludes with coverage of a few intermediate MySQL features, including full-text search, transactions, access control and subqueries.

Course Outline

  • Using the MySQL command-line tools (mysql, mysqladmin, mysqldump)
  • Performing simple queries
  • Inserting, updating, deleting
  • Introduction to relational data design; creating tables using SQL data definition language
  • SQL data types
  • Creating indexes; defining primary keys; autoincrementing IDs
  • Queries on partial matches
  • Aggregate queries (COUNT, MAX, etc.)
  • Querying with joins
  • Database engines (MyISAM, InnoDB, etc.)
  • Returning paginated results
  • Advanced joins
  • Handling date/time values
  • Enumerations
  • Conditionals (IF, ELSE)
  • Subqueries
  • Full-text search
  • Transactions
  • Access control and security

Prerequisites

Basic PC skills and access to a computer (Macintosh, Windows or Linux).

Duration and Format

6 weeks. Taught online. Instructor-led.

CodeLesson courses are available to students 24 hours a day while the course is in session. That means you can participate in the course even if you have a busy daytime schedule or if you're located in a different time zone.

Courses are comprised of online and offline readings, weekly quizzes, online discussion topics, and hands-on coding exercises that are evaluated by the instructor. You can post questions about the coursework at any time and the instructor will provide guidance. You're never stuck on your own.

You can learn more about our course format in our FAQ.

Take this Course!

Add Course

Share with Friends and Colleagues

Support

Follow Us

About Us

CodeLesson Logo
Copyright © 2010-2012, LessonPlex