• MySQL Courses
• Introduction to SQL Training using MySQL
• Advanced MySQL Queries
• MySQL Development Training
• MySQL Administration Training
• MySQL Development and Administration Training
• SQL Database Definition Language (DDL) Training
• Relational Database Design and Data Modeling
• More Courses

• MySQL Courses
• Introduction to SQL Training using MySQL
• Advanced MySQL Queries
• MySQL Development Training
• MySQL Administration Training
• MySQL Development and Administration Training
• SQL Database Definition Language (DDL) Training
• Relational Database Design and Data Modeling
• More Courses

MySQL Development Training

Print  

Goals

1. Create views to reuse SELECT statements
2. Learn data retrieval using SELECT statement.
3. Troubleshoot typical warnings and errors.
4. Change or add data.
5. Understand MySQL data validation.
6. Delete data from tables.
7. Generate aggregated query data using various criteria.
8. Connect data from multiple table rows using various types of JOIN constructs.
9. Use several different types of sub-queries.
10. Extensive coverage of MySQL Functions and expressions.
11. Use expressions in SQL statements for more functional and flexible retrieval.
12. Learn to export and import data.

Outline

1. DML and Data Manipulation Language
   1. DDL and DML Overview
   2. Data Values: Numbers
   3. Data Values: Strings
   4. Working with NULL Values
   5. Bulk Loading of Data
   6. Bulk Data Format
   7. Working with Special Values in Bulk
   8. Data
   9. Adding New Table Rows with INSERT
   10. Copying Rows
   11. UPDATE
   12. REPLACE
   13. Removing Table Rows
   14. Transactions
   15. InnoDB: Using Transactional Processing
   16. Locking Tables
2. Queries and the SELECT Statement
   1. SELECT Syntax Summary
   2. Choosing Data Sources and Destinations
   3. for SELECT
   4. Presentation of Table Data with
   5. SELECT
   6. Being Selective About Which Rows are
   7. Displayed
   8. User-Defined Variables
   9. Expressions and Functions
   10. Control Flow Operators and Functions
   11. Function Names
   12. Comparison Operators and Functions
   13. String Functions
   14. Numeric Operators and Functions
   15. Date and Time Functions
   16. Forcing Data Interpretation
   17. Miscellaneous Functions
3. Building a Result Set from Several Sources
   1. UNION
   2. Combining Data from Two Tables
   3. Using WHERE to Choose Matching
   4. Rows
   5. INNER JOIN
   6. OUTER JOINs
   7. Multiple Tables, Fields, Joins, and
   8. Ordering
   9. SELECT * and USING Columns
4. Advanced SQL Techniques
   1. MySQL Pattern Matching
   2. Multipliers, Anchors, and Grouping
   3. GROUP BY
   4. Aggregates
   5. Subqueries
   6. Subquery Comparisons and Quantifiers
   7. Other Subqueries
   8. Subquery Alternatives and Restrictions
   9. InnoDB Multi-Table Updates and
   10. Deletes
   11. Building a VIEW
   12. Updatable VIEWs

Class Materials

Each student in our Live Online and our Onsite classes receives a comprehensive set of materials, including course notes and all the class examples.

Class Prerequisites

Experience in the following is required for this MySQL class:

• Some knowledge of database concepts.

Experience in the following would be useful for this MySQL class:

• Some knowledge of database modeling.

Preparing for Class

• Onsite: Course Setup
• Live Online: Course Setup | WebEx Setup

---

Training for your Team

Length: 2 Days

• Private Class for your Team
• Online or On-location
• Customizable
• Expert Instructors

Request Onsite Class

---

Training for Yourself

$1,050.00 or 2 vouchers

Upcoming Classes

• Oct 4-5, 2018 10AM-5PM ET
• Nov 1-2, 2018 10AM-5PM ET
• Nov 19-20, 2018 10AM-5PM ET
Dec 27-28, 2018 10AM-5PM ET

See More Classes

Please select a class.

Register Now

• Live Online Training
• For Individuals
• Expert Instructors
• Guaranteed to Run
• 100% Free Re-take Option
• 1-minute Video