MySQL as a Datastore

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