MySQL: General Syntax, Advanced Queries, and Stored Programs

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

Prerequisite
None

Expected Duration
204 minutes

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.

Objective

General MySQL Syntax

  • 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 REPLACE, TRUNCATE, and LOAD DATA

  • use the REPLACE statement
  • use the LOAD DATA statement
  • use the TRUNCATE statement

Use Joins, Subqueries, UNION, and Metadata

  • 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

Practice: Using MySQL Statements

  • recognize data types and general syntax and manage and retrieve data

Create Stored Programs

  • 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

Practice: Utilizing Stored Programs

  • create and use stored programs

MONTHLY SUBSCRIPTION

$129/month
 

ANNUAL SUBSCRIPTION

$1295/year

Multi-license discounts available for Annual and Monthly subscriptions.