MySQL Development Training
Print
In this MySQL course, students learn to query a MySQL database using Database Manipulation Language (DML) statements.
Location
Public Classes: Delivered live online via WebEx and guaranteed to run . Join from anywhere!
Private Classes: Delivered at your offices , or any other location of your choice.
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
- DDL and DML Overview
- Data Values: Numbers
- Data Values: Strings
- Working with NULL Values
- Bulk Loading of Data
- Bulk Data Format
- Working with Special Values in Bulk
- Data
- Adding New Table Rows with INSERT
- Copying Rows
- UPDATE
- REPLACE
- Removing Table Rows
- Transactions
- InnoDB: Using Transactional Processing
- Locking Tables
- Queries and the SELECT Statement
- SELECT Syntax Summary
- Choosing Data Sources and Destinations
- for SELECT
- Presentation of Table Data with
- SELECT
- Being Selective About Which Rows are
- Displayed
- User-Defined Variables
- Expressions and Functions
- Control Flow Operators and Functions
- Function Names
- Comparison Operators and Functions
- String Functions
- Numeric Operators and Functions
- Date and Time Functions
- Forcing Data Interpretation
- Miscellaneous Functions
- Building a Result Set from Several Sources
- UNION
- Combining Data from Two Tables
- Using WHERE to Choose Matching
- Rows
- INNER JOIN
- OUTER JOINs
- Multiple Tables, Fields, Joins, and
- Ordering
- SELECT * and USING Columns
- Advanced SQL Techniques
- MySQL Pattern Matching
- Multipliers, Anchors, and Grouping
- GROUP BY
- Aggregates
- Subqueries
- Subquery Comparisons and Quantifiers
- Other Subqueries
- Subquery Alternatives and Restrictions
- InnoDB Multi-Table Updates and
- Deletes
- Building a VIEW
- 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.