MySQL: General Syntax, Advanced Queries, and Stored Programs

Target Audience
Expected Duration
Lesson Objectives
Course Number
Expertise Level

As a MySQL Database Developer, you need to understand the overall general syntax in order to obtain the correct information and provide information in the code, such as comments. Creating programs that can be stored on the server and executed multiple times is also essential. In this course, you'll learn about the general syntax of MySQL, including comments, identifiers, and data types. The course also covers how to handle advanced queries and data management, as well as how to create and use stored programs.

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


Expected Duration (hours)

Lesson Objectives

MySQL: General Syntax, Advanced Queries, and Stored Programs

  • start the course
  • describe identifiers including case sensitivity, qualified names, aliases, and use of reserved words
  • identify the properties of different data types and their appropriate usage
  • use expressions and common functions for all data types
  • use comments within MySQL syntax
  • describe the purpose and use of prepared statements
  • use prepared statements
  • use the REPLACE statement
  • use the LOAD DATA statement
  • use the TRUNCATE statement
  • recognize how to define join statements in your queries to combine records from multiple tables
  • create an inner join statement to see how result sets are affected by an inner join
  • create an inner join statement to see how result sets are affected by an outer join
  • simulate a full join type by combining joins
  • describe how to use subqueries to query data
  • write subqueries to query data
  • use the UNION clause to query data
  • use various methods to obtain metadata for database objects
  • recognize data types and general syntax and manage and retrieve data
  • use stored procedures to construct reusable code to perform a variety of administrative tasks in your databases
  • recognize the code and syntax to create a new stored procedure
  • use input parameters to allow dynamic values to pass each time the procedure is called
  • create new records by using the INSERT statement in a procedure
  • use loop structures in MySQL
  • use events to schedule repetitive tasks in a database
  • create and use triggers to generate an automated response to a modification
  • create and use stored programs
  • Course Number:

    Expertise Level