MySQL Training

MySQL is the most popular Open Source Relational SQL Database Management System. MySQL is one of the best RDBMS being used for developing various web-based software applications. MySQL is developed, marketed and supported by MySQL AB, which is a Swedish company. This tutorial will give you a quick start to MySQL and make you comfortable with MySQL programming.

Prerequisites

Before you start doing practice with various types of examples given in this tutorial, it is being assumed that you are already aware about what a database is, especially an RDBMS and what is a computer programming language.

Practice Material, Certification, Resume & Interview Guidance are included in this MySQL Course.

MySQL Training

  PLAN A PLAN B
Course Includes MySQL MySQL
Aurora DB
Course Duration 4 Weeks 5 Weeks
Completely Real-time, Practical Check-Symbol-for-Yes Check-Symbol-for-Yes
Mock Interviews, Case Studies Check-Symbol-for-Yes Check-Symbol-for-Yes
SQL Basics and Query Writing Croos-symbol-for-Yes Check-Symbol-for-Yes
Normal Forms, Joins, Queries Croos-symbol-for-Yes Croos-symbol-for-Yes
MySQL Server, Agent Architecture Check-Symbol-for-Yes Check-Symbol-for-Yes
Aurora MySQL database (DB) Check-Symbol-for-Yes
Total Course Fee (Payable in installments) INR 15,000
USD 225
INR 18,000
USD 270

Trainer: Sai Phanindra T

S No Timings (IST) Start Date Register
Schedules for MySQL Training
1 4 PM - 5 PM June 1st Register
2 8 AM - 10 AM (W) July 18th Register
 

MySQL Training Course Contents:

Chapter 1 – Getting Started with MySQL and Installing MySQL

  • MySQL Overview
  • Basics of Relational Databases
  • Entities and Relationships
  • SQL Language and MySQL
  • SQL data definition language and data
  • manipulation language
  • MySQL Client/Server Model
  • MySQL Connectors
  • Installation of the MySQL server
  • Starting and stopping MySQL server
  • Using the MySQL client
  • MySQL Workbench

Chapter 2 - Designing Your Database and Understand Data Types

  • Database Modeling
  • Keys and Normalization
  • Database Design
  • Viewing and Evaluating a Database
  • Data Types and Database Design
  • Numeric, Temporal and String Data Types
  • Character Set and Collation Support
  • Data Type Considerations
  • Meaning of NULL

Chapter 3: Creating Databases and Tables

  • Creating a Database
  • Creating a Table
  • Showing How a Table Was Created
  • Table Options
  • Column Options
  • Indexes, Keys, and Constraints
  • Deleting database and tables
  • Creating New Table Using an Existing Table
  • Creating a Temporary Table
  • Copying an Existing Table Structure
  • Adding, removing and modifying table columns and indexes

Chapter 4: Querying and Modifying Table Data

  • The SELECT Statement
  • Creating Views
  • Querying Data from an Application
  • Exporting and Importing a Delimited File
  • Troubleshooting: Authorization Levels
  • Manipulating Data and inserting records
  • Replacing and updating existing records
  • Deleting records
  • Exporting and importing a script
  • Multistatement Transactions
  • Modifying Data from an Application

Chapter 5 - Joining Tables and Functions

  • Querying Multiple Tables
  • Joining Tables with SELECT
  • Inner Joins & Outer Joins
  • Table Name Aliases
  • Using & String Functions
  • Date and time functions
  • Numeric & Aggregate Functions
  • Spaces in Function Names

Chapter 6 – MySQL Architecture and Administration Basics

  • Architectural Overview
  • Understand how MySQL Transmits Data
  • MySQL Processes Requests
  • Understand how MySQL Stores Data
  • MySQL uses Memory
  • Tablespaces, Redo and Undo Logs
  • Plug-in Interface

Chapter 7 - Configuring & Monitoring MySQL Server

  • Server Configuration Options
  • Option Files and System Variables
  • Launching Multiple Servers on the Same Host
  • Monitoring Tools & Techniques
  • MySQL Enterprise Audit & Monitor
  • Monitoring User Activity

Chapter 8 - User Management

  • Creating and Modifying User Accounts
  • Configuring Passwords
  • Authentication Plug-Ins
  • Granting Permissions & Grant Tables

Chapter 9 - Security

  • Understanding Security Risks
  • Network Security & Secure Connections
  • Password & Operating System Security

Chapter 10 - Backup Tools & Technique

  • Understanding Backups & Backup Techniques
  • Creating a Backup Strategy
  • MySQL Backup Tools
  • Raw Backup Methods

Chapter 11 - Percona Server

  • Percona Overview
  • Percona Server Installation
  • Percona XtraBackup Installation
  • Percona Features
  • Configuration of XtraBackup
  • Taking Full Backup
  • Taking Incremental Backups
  • Restoring / Recovering Full Backups and Incremental
  • Partial Backups
  • XtraBackup Installation on MySQL Server

Chapter 12 - Performance Tuning - Partitioning

  • Overview of Partitioning in MySQL
  • Partitioning Types
  • RANGE Partitioning
  • LIST Partitioning
  • HASH Partitioning
  • KEY Partitioning

Chapter 13 - Replication

  • Overview Replication
  • Master-Slave Configuration
  • Master-Master Configuration
  • Replication trouble shooting / errors

Chapter 14 - Performance Tuning

  • MyISAM Key Cache
  • InnoDB PT Parameters
  • InnoDB Startup Options.
  • Restrictions on InnoDB Tables
  • The InnoDB Buffer Pool
  • Optimization [ About Constraints ]
  • Index Management
  • About Locking & Issues
  • Locking Methods, Table Locks, Deadlock
  • Events
  • Creating, Altering, Monitoring, Dropping Events

Chapter 15 - MariaDB Server Installation

  • Features of MariaDB
  • Differences of MariaDB and MySQL
  • System databases

Chapter 16 - AZURE Cloud for DBA’s

  • Introduction of Cloud Computing
  • What is IAAS, PAAS & SAAS
  • Installing MySQL Server in Azure
  • Accessing MySQL from Azure Cloud
  • MySQL Connecting from On-premises to Azure Cloud
 
 

SQL Server MySQL Training - Highlights :

  • Completely Practical and Real-time
  • Suitable for Starters + Working Professionals
  • Session wise Handouts and Tasks + Solutions
  • TWO Real-time Case Studies, One Project
  • Interview Preparation & MOCK Interviews
 
 
  • End-End Database Design & Implementation
  • Detailed SQL Server Architecture, DB Design
  • Query Tuning, Stored Procedures, Linked Servers
  • In-Memory, New Features of SQL Server 2017
  • Azure SQL Database Programming, Sharding
  • In-Memory Tables and Azure Performance Insights
 
Register Today  Other Popular Courses: SQL DBA Training, MSBI Training, SSIS Training, SSAS Training, SSRS Training [+] More Courses

Job-Oriented Real-time Training @ SQL School Training Institute - Trainer: Mr. Sai Phanindra T [ 13+ Yrs of Technical Expertise, Microsoft Certified Trainer ]

 
 
 
 
 
24x7 LIVE Online Server (Lab) with Real-time Databases. Course includes ONE Real-time Project. Register Today