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
  • 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

What is included with the MySQL Fundamentals Course?
Logitrain course includes official certification exam fee.

Includes Official Exam Fee

Take the certification exam within 3 months of course / module completion

Logitrain is an Authorized Pearson VUE Test Center.

Authorized Test Center

Take the official vendor certification exam at the Logitrain training center

Logitrain courses, programs and packages includes course material.

Includes Books & Meals

Sit through the entire course if you do not pass on first attempt. Full-time courses only

Logitrain courses, packages and programs includes sample practise questions.

Includes Mock & Test Questions

Mock tests included in full-time courses for 3 months from course completion

Logitrain full-time course includes course retake, if you do not pass the official certification exam.

Includes Course Retake

Sit through the entire course again to clear any doubts. Included in full-time courses

Logitrain courses include price beat guarantee.

Our Price Beat Guarantee

Relax, we will beat competitor’s advertised price. Our course has no extra costs

DATES, LOCATIONS & PRICES

Logitrain Live Online Training Banner


LocationTypeDurationPriceDates
LocationTypeDurationPriceDates

Accreditations

OUR SATISFIED CUSTOMERS

CALL ME
+

Learn More

  • This field is for validation purposes and should be left unchanged.