mysql_optimized
-33%

MySQL for Beginners

MySQL is the most popular open source database. This course is your first step towards gaining a strong foundation and experience in using and administering this open source relational databases. You will gain an understanding of the core concepts and advanced tools and techniques to manage data and administer the MySQL Database.

Enrolment validity: Lifetime

About This Course

MySQL Certification Training trains you the basic and advanced concepts of MYSQL Database with real-world use cases and makes you proficient in creating and managing the MYSQL Databases.

Learning Objectives

Learn the concepts of relational database management systems (RDBMS) as well as core design concepts including table and column design.

Requirements

  • Basic computing knowledge
  • Working knowledge of any command-line program
  • Basic understanding of relational database systems is an added advantage

Target Audience

  • Database Developers
  • Application Developers
  • Database Designers
  • Database Administrators

Curriculum

86 Lessons25h

Concepts, Design, and Installation

Concepts of Table Design
Introducing the Core Concepts of MySQL
Installing and Configuring MySQL on Windows
Getting Started with MySQL Workbench
Connecting to Databases
Configuring the Server Status and Navigation
Creating New Users
Managing Users and Privileges
Core Concepts of an RDBMS
Concepts of Column Design
Understanding Relationships
Practical Exercise

Querying Data

Data Manipulation and Definition Statements

General MySQL Syntax, Advanced Queries & Stored Programs

Advanced Routines, Optimization & DCL

Storage Engines

Advanced Indexing and Maintenance

Transactions, Optimization, Scaling, Backup & Recovery

Performance Monitoring, Database Health and Integrity & Security

GIS, Cloud, and Connectors for MySQL

Project

certificate

7,999.0011,999.00

33% off
Level
Beginner
Duration 25 hours
Lectures
86 lectures
Language
English
Select your currency