MySQL: General Syntax, Advanced Queries, and Stored Programs

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

---

Overview/Description
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

Prerequisites
None

Expected Duration (hours)
3.4

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:
df_mysq_a04_it_enus

Expertise Level
Intermediate