MySQL Quickstart Fundamentals - Self-Study Course

MySQL Quickstart Fundamentals - Self-Study Course

Oracle University
Logo Oracle University
Provider rating: starstar_borderstar_borderstar_borderstar_border 2 Oracle University has an average rating of 2 (out of 1 reviews)

Need more information? Get more details on the site of the provider.

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
M…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: .

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
MySQL Architecture
  • My SQL Architecture Overview
  • Storage Engine Concept
  • Locks
  • MySQL Architecure Summary
MySQL Server
  • My SQL Binary Distributions
  • MySQL Source Distributions
  • Loading Time Zone Tables
  • MySQL and Windows
  • MySQL and Linux
  • Improve MySQL Installation Security
Configuring MySQL Server
  • MySQL Configuration
  • Option Files
  • Dynamic Server Variables
  • SQL Mode
  • Log and Status Files
  • Binary Log
Schema Design
  • Database Modeling
  • Normalization
  • Denormalization
  • Data Types
  • Partitioning
Metadata Data and NEW_PERFORMANCE Schema
  • Metadata Access Methods
  • The INFORMATION_SCHEMA and MySQLDatabases
  • New PERFORMANCE_Schema
  • Using SHOW and DESCRIBE
  • The mysqlshow Client
Introduction to Storage Engines
  • Storage Engine Overview
  • MyISAM, InnoDB, and MEMORY Storage Engines
  • Other Storage Engines
  • Choosing Appropriate Storage Engines
  • Using Multiple Storage Engines
  • Storage Engine Comparison Chart
MySQL Clients and Administrative Tools for MySQL
  • Overview of Administrative Clients
  • Invoking MySQL Client Programs
  • Using the Mysql Client
  • The mysqladmin Client
  • MySQL Administration tools
Backup and Recovery Concepts and Tools
  • Backup Recovery Concept
  • Row and Statement level Logging
  • Types of Backups
  • Backup Tools
  • Data Recovery
Replication
  • 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

There are no reviews yet.

    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.