MySQL Fundamentals Ed 2 -

MySQL Fundamentals Ed 2

Duration : 4 Days (32 Hours)

Overview

Course Details

Prerequisites

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

Classroom

Interaction and collaboration
Networking opportunities
Real-time feedback
Personal attention

Onsite

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.

Request Free Demo

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