MySQL for Developers - Ratio

MySQL for Developers

Database Development - 4 Days

MySQL for Developers will be useful for anyone who wants to truly master SQL using MySQL. The course covers relational database design, implementation of a database design, and the skills necessary to use a MySQL database as a backend to an application. Along with SQL query skills, the attendee will also learn about query optimization and importing and exporting data.

Hands-on activities are included designed to reinforce the content delivered in the course. A step-by-step document is provided to guide in the creation of a Windows VM configured to support the hands-on activities.

MySQL for Developers Objectives

Relational Database Design: Create a relational database schema then implement that design in MySQL.
SQL Queries: Covers both basic and advanced SQL queries. Understanding table joins and aliases creating grouping based queries using aggregate functions.
Data Manipulation: Work with INSERT UPDATE DELETE and TRUNCATE commands. Discover how to handle duplicate data. Understand handling transaction based commands.
SQL Programming: Data types operators and flow control statements. Using set operators and sub-queries. Accessing MySQL using Python.
Accessing Metadata: Get information about your schema structure and database objects using the SHOW commands and the INFORMATION_SCHEMA tables.
MySQL Objects: Create and use Views Functions Stored Procedures and Triggers.
Query Optimization: Covers analyzing queries indexing and understanding query plans in order to create efficient queries.
Export and Import Data: Move data into and out of your MySQL database.

Need Assistance Finding the Right Training Solution

Our Consultants are here to assist you

Arrange a consultation

Key Point of Training Programs

We have different work process to go step by step for complete our working process in effective way.

MySQL for Developers Prerequisites

No prior knowledge of MySQL or SQL is assumed.
MySQL for Developers Format

In-Person

Online
MySQL for Developers Outline

Module 1: Introduction to Relational Databases

Why a Relational Database?
Relational Database Management Systems
MySQL Community and Workbench
Module 2: Modeling a Relational Database

What is the Relational Model?
The Entity-Relationship Model
Designing the Database Schema
Module 3: SQL Language

About SQL
Basic Query Syntax
Querying with MySQL Workbench
Module 4: Implementing Database Design

Reviewing the Database Design
Creating a Database
Creating Tables
Creating Indexes
Module 5: Data Modification

Modifying Data
Handling Duplicate Values and Rows
Handling Transactions
Module 6: Advanced Queries

Table Joins and Aliases
Grouping and Aggregating
Set Operations
Sub-queries and Derived Tables
Module 7: Data Types and Variables

Data Types
Variables
Data Type Conversion
Module 8: Flow Control and Iteration

Operators
Decision Making
Iteration
Module 9: Viewing Data

Views
Functions
Accessing Metadata
Module 10: SQL Programming

Stored Procedures
Triggers
MySQL and Python
Module 11: Query Optimization

Optimization
Optimizing SQL Queries
EXPLAIN ANALYZE
Module 12: Importing and Exporting Data

Importing Data
Exporting Data
MySQL Workbench Wizard