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
Includes Official Exam Fee
Take the certification exam within 3 months of course / module completion
100% Money Back Guarantee
Training fee is fully refundable if you are not satisfied with the training
Includes Course Material
Course material in hardcopy is included for you to keep for reference and support
Includes Practise Questions
Practise questions are included to assist you in preparing for the official exam
Highly Skilled Trainers
Our trainers are highly skilled with expertise and extensive hands-on experience
Our Price Beat Guarantee
Relax, we will beat competitor’s advertised price. Our course has no extra costs
DATES, LOCATIONS & PRICES
| Location | Type | Duration | Price | Dates | |
|---|---|---|---|---|---|
| Location | Type | Duration | Price | Dates |
Accreditations
OUR SATISFIED CUSTOMERS
| Approachable and knowledgeable; comfortable surroundings. Logitrain does make IT training easier |
Paul Sinclair Service Desk Analyst 4.8/5 Rating - - 4.8/5 Rating -
I recently followed the ITIL Foundation course at Logitrain. The training, materials and facilities were excellent and I would not hesitate to train with Logitrain again.
Rob Stockey - Senior Engineer - 4.8/5 Rating -
Justin Blackford - Systems Administrator - 4.8/5 Rating -
Thanks for a great week! Really enjoyed and feel I picked up a lot. Great Trainer! Will definitely look at further studies here.
Steven Bell - Senior Service Centre Analyst - 4.8/5 Rating -
Well-presented and able to convey immense knowledge to class. All queries were responded to promptly.
Ivan Ocampo - Senior Network Engineer - 4.8/5 Rating -
Excellent teaching method, easy to understand.
Rajan Anandasivam - Technical Specialist - 4.8/5 Rating -
Logitrain provided a valuable insight into ITIL and enabled me to excel and advance my knowledge through a simple and well organised series of sessions.
Adam Centorrino - Managing Director - 4.8/5 Rating -
Great place to study for certification, knowledgeable persons, excellent customer service. Ready to answer queries on the spot, very helpful.
Ankit Sobti - Network and Systems Administrator - 4.8/5 Rating -
The trainer was very patient and gave everybody the opportunity to participate.
Tim Symonds - Solutions Architect at MSC Mobility Solutions - 4.8/5 Rating -
The trainer explained everything very well. Logitrain was very helpful for me in getting a better overall understanding of CCNA. I previously had studied it 2 years earlier but required revision
Felice Amenta - Senior Service Mangement Officer at Optus 4.8/5 Rating - 4.8/5 Rating -