Course Details

Previous Page


MySQL: Using the Data Manipulation and Definition Statements


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



Overview/Description
It’s essential as a database administrator to understand how to use data definition and data manipulation statements in order to manage and modify database objects. In this course, you’ll learn how to use insert, update, and delete statements to manage data within a MySQL database. You’ll also learn how to use DDL statements to create, drop, and alter databases, tables, and views.

Target Audience
Personnel at all levels of an enterprise seeking to attain competency in MySQL

Prerequisites
None

Expected Duration (hours)
2.5

Lesson Objectives

MySQL: Using the Data Manipulation and Definition Statements

  • start the course
  • describe the INSERT, UPDATE and DELETE DML statements to manage data
  • use the INSERT statements to add new data
  • use the UPDATE statements to modify existing data
  • use the DELETE statements to remove existing data
  • use advanced INSERT statements for additional options to add new data
  • use apply advanced UPDATE statements for additional options to modify data
  • view and perform changes to existing records
  • retrieve data by using filters
  • insert and delete data
  • perform a data import to pull the existing data into tables
  • export data to an external file
  • describe the CREATE, ALTER, and DROP DDL statements
  • create a new database with its specific syntax and parameters
  • use Alter and Drop Databases with data definition language for altering and dropping databases
  • create Table Statements and define their properties
  • use Alter and Drop Table with data definition language for altering and dropping tables
  • describe Views to retrieve records from tables or other views
  • create new views
  • use view to retrieve records from tables and other views
  • edit existing Views and create nested Views
  • create advanced views, join statements, and use aggregate functions
  • manage data, and create, alter, and delete databases
  • Course Number:
    df_mysq_a03_it_enus