We can host this training at your preferred location. Contact us!
Upcoming Training
21 April 2021
4 Days
Here is your chance to learn how this powerful relational database management system can make your life easier and more fun! This class covers all the basics and will get you on your way, with a solid foundation. This instructor led, hands-on class covers the fundamentals of SQL and relational databases, using MySQL[tm] as a teaching tool.
Learn To:
Install the MySQL server
Describe the features and benefits of MySQL
Describe the basics of relational databases
Install the MySQL server
Describe the features and benefits of MySQL
Describe the basics of relational databases
Target Audience
Database Administrators
Database Designers
Administrator
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
Upcoming Trainings
Join our public courses in our Istanbul, London and Ankara facilities. Private class trainings will be organized at the location of your preference, according to your schedule.