MySQL for Beginners
Unlock the power of SQL with our comprehensive MySQL course! Get hands-on experience in writing SQL statements and learn how to troubleshoot syntax errors and warnings, modify databases and tables, and group query data with aggregation. Our expert instructors will guide you through the basics of relational databases and show you how to install and use the MySQL server to your advantage. Available in face-to-face and virtual classroom settings for both public and private groups.
per person
Level
Duration
Training Delivery Format
Face-to-face / Virtual Class
per person
Level
Duration
Training Delivery Format
Face-to-face (F2F) / Virtual Class
Class types
Public Class
Private Class
In-House Training
Bespoke
About this course
This course covers the basics of the SQL language as implemented by MySQL. The course is designed to give delegates practical experience in writing SQL statements using MySQL. You will learn to Install the MySQL server, Describe the features and benefits of MySQL, Describe the basics of relational databases.
Upon completing this training you should be able to troubleshoot syntax and understand typical warnings and errors, delete or modify a database and table row data, grouping query data with aggregation and many more.
This MySQL course is available in our face to face classroom or through a live virtual class training. This training is available for a public and private group. It is open for Malaysia and international students.
Who should attend?
New MySQL users who have little or no previous experience understand relational database management systems.
Prerequisites
You need to have basic computer literacy, previous experience with any command-line program and knowledge of database concepts is recommended.
Course Content
Introduction
- Features and Benefits of MySQL
- MySQL Products and Service
- Community vs. Enterprise
- MySQL Certification Program
- MySQL Certification Program
- MySQL Website
- MySQL Architecture
- Install and Start MySQL
Database Basics
- SQL Language and MySQL
- Database Design
- Database Modeling
- Keys
- Normalization
- Data Types
- What is NULL?
- Viewing Database Structure
Database Creation
- Create a New Database Structure
- Creating a Database
- Creating a Table
Basic Queries
- The SELECT Command
- MySQL Query Browser
- Troubleshooting
Database Maintenance
- Delete an Entire Database
- Maintaining Tables
- Maintaining Columns
- Indexes and Constraints
- Data Manipulation
Delete/Modify Table row Data
- The INSERT Command
- The REPLACE Command
- The UPDATE Statement
- The DELETE Command
Functions
- Simple Functions
- Grouping With Functions
Joining Tables
- Combining Multiple Tables
- Inner Joins
- Outer Joins
Exporting/Importing Data
- Exporting Data
- Importing Data
Sub queries
- What is a Sub query?
- Categories of Sub queries
- Sub query Types
- Placing Sub queries
- Other Sub query Uses
- Other Sub query Uses
Supplementary Information
- Creating VIEWs
- Transactions
- Storage Engines
- Retrieving Metadata
Conclusion
- Course Review
- Training and Certification Website
- Course Evaluation
- Thank You!
- QA Session
At this time, this course is available for private class and in-house training only. Please contact us for any inquiries.