MySQL for Beginners Training in New Zealand

Required Prerequisites:

• Basic computer literacy is required

Suggested Prerequisites:

• Previous experience with any command-line program
• Knowledge of database concepts

• Understand the features and benefits of MySQL
• Install and start the MySQL server
• Understand the basics of relational databases
• Understand the SQL and MySQL languages
• Understand Data/Column types with regard to efficient database design
• View a database design structure and content
• Create a database design using an efficient structure
• Extract basic database information using the SELECT command
• Troubleshoot syntax and understand typical warnings and errors
• Delete or modify a database, and table row data
• Group query data with aggregation
• Connect data from multiple table rows using JOIN
• Perform nested sub-queries
• Use simple functions (String, Date, Numerical)
• Describe MySQL connectors, their major features and differences
• Understand MySQL storage engines, transactions and features of the common engines

Introduction 

• MySQL Product
• MySQL Services and Support
• MySQL Resources
• Example Databases

MySQL Server and Client

• The client/server model overview
• Communication protocols
• Connectors and MySQL
• The LAMP Stack
• Installation of the MySQL server
• MySQL Server and Client Startup

Database Basics

• Basics of Relational Databases
• SQL Language and MySQL

Database Design

• Database Modeling
• Keys
• Normalization

Table Data Types

• Data Types
• Numeric Data Types
• Temporal Data Types
• Character String Data Types
• The Meaning of Null

Database and Table Creation

• Database Structure Creation
• Database Creation
• Table Creation

Basic Queries

• The SELECT Statement
• MySQL Workbench for SQL Development
• Troubleshooting

Database and Table Maintenance

• Deleting an Entire Database
• Maintaining Tables
• Maintaining Columns
• Indexes and Constraints

Table Data Manipulation

• Delete/Modify Table Row Data
• The INSERT Statement
• The REPLACE Statement
• The UPDATE Statement
• The DELETE Statement

Functions

• Simple Functions
• Grouping with Functions

Joining Tables

• Combining Multiple Tables
• Inner Joins
• Outer Joins

Table Queries

• What is a Subquery
• Categories of Subqueries
• Subquery Types
• Placing Subqueries
• Other Subquery Uses
• Converting Subqueries to Joins

Exporting and Importing Data

• Exporting Data
• Importing Data

MySQL GUIs

• MySQL Enterprise Monitor
• MySQL Workbench

Supplemental Information

• Creating Views
• Transaction
• Storage Engines
• Retrieving Metadata
• Performance Schema
• MySQL Enterprise Backup

Conclusion

• Course Review
• MySQL Training and Certification
• Course Evaluation
• Thank You!
• QA Session