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
- 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
- Joining Tables
“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 vendor certification exam at the Logitrain training center
Course material in hardcopy is included. Full-time classroom courses include meals
Mock tests included in full-time courses for 3 months from course completion
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
Find out why we are the leading choice to help boost your career
|Approachable and knowledgeable; comfortable surroundings. Logitrain does make IT training easier|
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.
Thanks for a great week! Really enjoyed and feel I picked up a lot. Great Trainer! Will definitely look at further studies here.
Well-presented and able to convey immense knowledge to class. All queries were responded to promptly.
Excellent teaching method, easy to understand.
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.
Great place to study for certification, knowledgeable persons, excellent customer service. Ready to answer queries on the spot, very helpful.
The trainer was very patient and gave everybody the opportunity to participate.
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
Over 1000 organisations have relied on Logitrain to be their trusted training partner.
Dont’ Wait. Fill the form for a free no-obligation information session with our course specialists.