MySQL Development Training Class | Webucator Database Classes | Webucator

Overview

In this MySQL course, students learn to query a MySQL database using Database Manipulation Language (DML) statements,

Goals

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

Outline

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
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
Building a Result Set from Several
1. Sources
2. UNION
3. Combining Data from Two Tables
4. Using WHERE to Choose Matching
5. Rows
6. INNER JOIN
7. OUTER JOINs
8. Multiple Tables, Fields, Joins, and
9. Ordering
10. SELECT * and USING Columns
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

No cancelation for low enrollment

Certified Microsoft Partner

Registered Education Provider (R.E.P.)

GSA schedule pricing

72,346

Students who have taken Live Online Training

15,155

Organization who trust Webucator for their training needs

100%

Satisfaction guarantee and retake option

8.40

Students rated our MySQL Development Training trainers 8.40 out of 10 based on 18 reviews

I enjoy Webucator's policy that they won't cancel for low enrollment. Being that I was the only student in my class...

Jenni Fischer, CotterWeb Enterprises, Inc.
Mendota Heights MN

Very good class and learned new extended features available in MySQL

Nhon Dao, DB Consulting Group, Inc.
Houston TX

Top quality instruction from the best instructors in the field.

Peter Bachman, A-T Solutions, Inc.
Fairfax VA

I had no prior knowledge about SEO and this class was the perfect way to introduce myself and give me a basic understanding...

Frannie Coggeshall, Argyle Executive Forum
New York NY

More Testimonials

Contact Us or call 1-877-932-8228