MySQL Fundamentals+ Exam
MySQL Fundamentals Course
MySQL Fundamentals course aims to teach students, the basic concepts of MySQL server to prepare them with key skills before undertaking MySQL for Developers course which is essential for attaining Oracle Certified Professional- MySQL 5.6 Developer certification.
A student with basic understanding of databases and command line can easily learn a lot about relational databases and MySQL server during this course.
After completing this course, the student will be able to demonstrate mastery in MySQL server concepts including installation and configuration of MySQL client and server as well as effect use of SQL to configure databases.
This certification is a key requirement for following jobs:
- Database Designer
- Database Administrator
- Web Developer
- Systems Engineer
- Data Analyst
- Support Engineer
Basic Knowledge of database concepts
This course itself has no exam related to it. Only after completing this course and MySQL for Developers course can the students undertake MySQL 5.6 Developer 1Z0-882 exam.
MySQL Fundamentals – Logitrain course material
- Describing the features and benefits of MySQL
- Explaining the basics of relational databases
- Designing an effective database
- Issuing MySQL statements from the command-line client
- Performing database operations by using MySQL Workbench
- Selecting appropriate data types for your database
- Building a database and tables by using SQL
- Modifying the structure of your database
- Creating indexes and keys
- Adding or updating database data
- Querying data with SELECT statements
- Joining data from multiple tables
- Using built-in MySQL functions
- Exporting and importing database data
- Explaining database transactions
- Gaining an understanding on the MySQL Cloud Service
This course is likely to add to the employment related skills of the participants. The skills developed are likely to be used in the course of being an employee or working in a business.
- University Students
- Developers
- Database Administrators
- Database Designers
- Data Analysts
- Support Engineers
- Introduction to MySQL
- MySQL Server and Client
- Database Basics
- Designing Your Database
- Data Types
- Creating Databases and Tables
- Modifying Databases and Tables
- Querying Table Data
- Modifying Table Data
- Functions
- Joining Tables
- Conclusion
“We have helped thousands achieve Cisco Certifications, let us help you”
– Murad Tanvir, Double CCIE #17081
Take the certification exam within 3 months of course / module completion
Take the official certification exam at Logitrain, a local VUE test centre or online
Course material in digital format is included for flexibility and ease of use
Mock test is included in the full-time courses to assist with your preparation
Our trainers are highly skilled with expertise and extensive hands-on experience
Relax, we will beat competitor’s advertised price. Our course has no extra costs
| Location | Type | Duration | Price | Dates | |
|---|---|---|---|---|---|
| Location | Type | Duration | Price | Dates |
The supply of this course/package/program is governed by our terms and conditions. Please read them carefully before enrolling, as enrolment is conditional on acceptance of these terms and conditions. Proposed course dates are given, course runs subject to availability and minimum registrations.
Prepare to get IT job ready in 8 weeks
Trained 15,000+ professionals and counting
Experienced Provider: Operating Since 2004
Trained staff from 2,500+ Australian Businesses
“Fantastic delivery! extremely knowledgeable trainer! great real-world experience with easy examples! convenient location!”
– Spiros L, Senior IT Officer at BOM, Rating: 5/5
“Everything was great, describing technologies in real world examples was fantastic. Logitrain has been a fresh surprise.”
– John D, ICT Manager at Glenvill, Rating: 5/5
“Thanks for a great week! Really enjoyed and feel I picked up a lot. Great Trainer! Will definitely look at further studies here.”
– Steven B, Senior Service Centre Analyst at News Corp Australia, Rating: 5/5
“The trainer was very patient and gave everybody the opportunity to participate. Gots lots of opportunity for hands-on practise”
– Tim S, Solutions Architect at MSC Mobility Solutions, Rating: 5/5
Over 2,500 organisations have relied on Logitrain to be their trusted training partner.
Don’t Wait. Please fill the form now.