MySQL Quickstart Fundamentals - Self-Study Course
Starting dates and places
This product does not have fixed starting dates and/or places.
Description
With the MySQL Quickstart Fundamentals Course, students will learn about core MySQL Server Technologies, including, how to perform basic installation, navigate to system and data file locations, use administration and performance management tools, understand Client Server configuration and networking and more.
Learn To:- Intall and start MySQL
- Identify the MySQL Architecture
- Grasp the basic understanding of Relational Databases
- Gain familiarity with Administrative Tools for MySQL
Audience
- Developer
- Database Administrators
Course Topics Introduction to MySQL
- MySQL Course Overview
- MySQL Products and Service
- MySQL Community Edition vs. MySQL Enterprise Edition
- MySQL Product Releases
Frequently asked questions
There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.
With the MySQL Quickstart Fundamentals Course, students will learn about core MySQL Server Technologies, including, how to perform basic installation, navigate to system and data file locations, use administration and performance management tools, understand Client Server configuration and networking and more.
Learn To:- Intall and start MySQL
- Identify the MySQL Architecture
- Grasp the basic understanding of Relational Databases
- Gain familiarity with Administrative Tools for MySQL
Audience
- Developer
- Database Administrators
Course Topics Introduction to MySQL
- MySQL Course Overview
- MySQL Products and Service
- MySQL Community Edition vs. MySQL Enterprise Edition
- MySQL Product Releases
- My SQL Architecture Overview
- Storage Engine Concept
- Locks
- MySQL Architecure Summary
- My SQL Binary Distributions
- MySQL Source Distributions
- Loading Time Zone Tables
- MySQL and Windows
- MySQL and Linux
- Improve MySQL Installation Security
- MySQL Configuration
- Option Files
- Dynamic Server Variables
- SQL Mode
- Log and Status Files
- Binary Log
- Database Modeling
- Normalization
- Denormalization
- Data Types
- Partitioning
- Metadata Access Methods
- The INFORMATION_SCHEMA and MySQLDatabases
- New PERFORMANCE_Schema
- Using SHOW and DESCRIBE
- The mysqlshow Client
- Storage Engine Overview
- MyISAM, InnoDB, and MEMORY Storage Engines
- Other Storage Engines
- Choosing Appropriate Storage Engines
- Using Multiple Storage Engines
- Storage Engine Comparison Chart
- Overview of Administrative Clients
- Invoking MySQL Client Programs
- Using the Mysql Client
- The mysqladmin Client
- MySQL Administration tools
- Backup Recovery Concept
- Row and Statement level Logging
- Types of Backups
- Backup Tools
- Data Recovery
- MySQL Replication in Action on the Web
- Designing for High Availability
- MySQL Replication Overview
- MySQL Replication features
- Getting started with Replication
Course Objectives
- Understand the features and benefits of MySQL
- Gain the experience to install and start the MySQL server
- Understand the basics of Relational Databases
- Acquire the ability to use Data/Column types with regard to efficient database design
- View a database design structure/content
- Understand MySQL storage engines, transactions and features of the common engines
- Gain familiarity with Administration Tools for MySQL
- Gain understanding of the Backup Recovery concepts
- Introduction to High Availability
Share your review
Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.