MySQL Fundamentals Ed 2

Duration : 4 Days (32 Hours)

MySQL Fundamentals Ed 2 Course Overview:

The MySQL Fundamentals Ed 2 certification is a recognized industry credential confirming proficiency in utilizing and administering MySQL, a prevalent open-source relational database management system. This certification encompasses fundamental skills such as database design, data querying and modification, and data integrity and security. It validates expertise in MySQL architecture, data and table types, and establishing server connections. Industries globally rely on this certification as a standard to gauge the competence of IT professionals in managing relational databases, facilitating essential tasks like data extraction, business intelligence, and web application development.

Intended Audience:

  • IT professionals seeking an understanding of MySQL
  • Database administrators needing MySQL proficiency
  • Software engineers working with MySQL databases
  • Web developers requiring MySQL database integration
  • Individuals looking to learn SQL and database management
  • Individuals preparing for MySQL certification exam

Learning Objectives of MySQL Fundamentals Ed 2:

The learning objectives of the MySQL Fundamentals Ed 2 course encompass enabling students to comprehend and master the fundamental concepts of the MySQL Relational Database Management System. The course aims to establish a foundational knowledge of utilizing SQL to interact with the MySQL database management system. It seeks to provide insight into diverse operations such as database creation, deletion, querying, syntax, data types, operators, and more. Additionally, the course’s focus extends to imparting knowledge about data normalization, table relationships, and joins. Ultimately, the course aspires to equip students with the skills necessary to effectively manage and troubleshoot potential programming challenges.

 Module 1: Introduction to MySQL

  • Course Goals
  • Course Lesson Map
  • Classroom Environment
  • MySQL Overview
  • MySQL Community Resources
  • How an instance of MySQL Cloud Service differs from having an on-premises instance
  • MySQL Courses and Certification

 Module 2: MySQL Server and Client

  • MySQL Client/Server Model
  • MySQL Connectors
  • Installation of the MySQL server
  • Starting and stopping the MySQL server
  • Using the mysql client
  • MySQL Workbench

 Module 3: Querying Table Data

  • The SELECT Statement
  • Query Data From An Application
  • Troubleshooting Problems

 Module 4: Data Types

  • Data Types as Part of Database Design
  • Numeric Data Types
  • Temporal Data Type
  • String Data Types
  • Character Set and Collation Support
  • Data Type Considerations
  • The Meaning Of NULL

 Module 5: Functions

  • Functions in MySQL Expressions
  • Using Functions
  • String Functions
  • Date And Time Functions
  • Numeric Functions
  • Aggregate Functions
  • Spaces in Function Names
  • RANK Window Functions

 Module 6: Joins and Unions

  • Querying Multiple Tables
  • Joining Tables with SELECT
  • Inner Joins
  • Outer Joins
  • Table Name Aliases
  • Combining Multiple Queries with UNION

 Module 7: Subqueries

  • Nesting Queries
  • Writing Simple Subqueries
  • Writing Complex Subqueries

 Module 8: Creating Databases and Tables

  • Creating a Database
  • Creating a Table
  • Showing How a Table Was Created
  • Column Options
  • Table Options
  • Copying an Existing Table Structure
  • Confirming the Creation of a New Table
  • Copying an Existing Table Structure
  • Creating a Temporary Table
  • Indexes, Keys, and Constraints

 Module 9: Modifying Databases and Tables

  • Deleting Databases and Tables
  • Adding, Removing and Modifying Table Columns
  • Adding, Removing and Modifying Indexes and Constraints

 Module 10: Modifying Table Data

  • Manipulating Data
  • Inserting Records
  • Replacing Existing Records
  • Updating Existing Records
  • Deleting Records
  • Exporting and Importing A Script
  • Multistatement Transactions
  • Modifying Data From An Application

 Module 11: Securing Your Database

  • Layers of Security
  • Creating Users
  • Creating Roles
  • Assigning Privileges to Users And/Or Roles
  • Creating Views to Control Access

 Module 12: Backing Up Your Database

  • Importance Of Backups
  • Creating a Backup
  • Options for Backup
  • Restoring a Backup

 Module 13: JSON

  • JSON Use Cases
  • Retrieving Data From JSON Columns
  • Creating a JSON Column
  • Inserting Data Into a JSON Column
  • Updating a JSON Column

 Module 14: Conclusion

  • Course Goals
  • MySQL Curriculum Path
  • MySQL Resources
  • Evaluation
  • Final Q&A

MySQL Fundamentals Ed 2 Course Prerequisites:

  • Basic knowledge of relational databases
  • Familiarity with database theory
  • Understanding of simple data types
  • Ability to use SQL to access & manage data
  • Experience with MySQL command line client
  • Knowledge of JavaScript is beneficial but not necessary
  • Basic understanding of networking protocols.

Discover the perfect fit for your learning journey

Choose Learning Modality

Live Online

  • Convenience
  • Cost-effective
  • Self-paced learning
  • Scalability


  • Interaction and collaboration
  • Networking opportunities
  • Real-time feedback
  • Personal attention


  • Familiar environment
  • Confidentiality
  • Team building
  • Immediate application

Training Exclusives

This course comes with following benefits:

  • Practice Labs.
  • Get Trained by Certified Trainers.
  • Access to the recordings of your class sessions for 90 days.
  • Digital courseware
  • Experience 24*7 learner support.

Got more questions? We’re all ears and ready to assist!

Request More Details

Please enable JavaScript in your browser to complete this form.

Subscribe to our Newsletter

Please enable JavaScript in your browser to complete this form.