MySQL as a Datastore


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level


Overview/Description
Most web applications use a back end database for data storage, querying and retrieval. In this course you'll learn how to configure and manage MySQL databases and tables.

Target Audience
Developers and system administrators interested in gaining insight as to how LAMP stack components interact together to provide web solutions

Prerequisites
None

Expected Duration (hours)
0.9

Lesson Objectives

MySQL as a Datastore

  • start the course
  • recognize how MySQL is commonly used as a backend data store for web applications
  • list common permissions related to MySQL objects
  • use a variety of methods to create MySQL users
  • grant MySQL permissions to support a web application
  • establish MySQL database and table storage
  • populate MySQL with data
  • choose the appropriate query language syntax to extract MySQL data
  • retrieve MySQL data using a query
  • define MySQL logging details
  • view MySQL stats
  • determine how to apply MySQL best practices
  • perform common MySQL configuration and management tasks

    • Course Number:
    sd_aweb_a03_it_enus

    Expertise Level
    Intermediate