Breza Software Engineering - Breza Erp, Breza Gas, Oracle partner, Trening centar, IT resenja, IT Outsourcing

The MySQL for Developers course is the foundation course for developers planning on designing and implementing

applications that make use of MySQL. This course covers essential SQL statements for data design, querying, and

programming. In addition, it will prepare students for the MySQL Developer certification.

Students who can benefit from this course:Developers who want to create applications using MySQLStudents wishing to

prepare for the MySQL Developer Certification Exams

Having attended the MySQL for Beginners course or some experience with Relational Databases and SQL

MySQL for Beginners (SQL-4401)

Understand the steps necessary to invoke MySQL client programs

Utilize the general-purpose mysql client program and the MySQL Query Browser graphical user interface (GUI) to run queries and Select the best data type for representing information in MySQL

Manage the structural characteristics of your databases and the tables within your databases

Utilize the SELECT statement to retrieve information from database tables

Utilize expressions in SQL statements to retrieve more detailed information

Utilize SQL statements to modify the contents of database tables

Write join expressions in your SQL statements to obtain information from multiple tables

Utilize subqueries in your SQL statements

Create views utilizing SELECT statements to produce virtual tables of specific data

Perform bulk data import and export operations

Create user defined variables, prepared statements and stored routines

Create and manage triggers

Use the INFORMATION_SCHEMA database to access metadata

Debug MySQL applications

Configure and Optimize MySQL

MySQL Overview, Products and Services

MySQL Enterprise Services

Supported Operating Services

MySQL Certification Program

Training Curriculum Paths

MySQL Website

Installing MySQL and the World Database

MySQL General Architecture

How MySQL Uses Disk Space

How MySQL Uses Memory

Invoking Client Programs

Using Option Files

The MySQL Client

MySQL Query Browser

MySQL Connectors

Third-Party APIs

The SELECT Statement

Aggregating Query Results

Using UNION

SQL Modes

Handling Missing or Invalid Data Values

Interpreting Error Messages

SQL Comparisons

Functions in SQL Expressions

Comments in SQL Statements

Data Type Overview

Numeric Data Types

Character String Data Types

Binary String Data Types

Temporal Data Types

NULLs

Metadata Access Methods

The INFORMATION_SCHEMA Database/Schema

Using SHOW and DESCRIBE

The mysqlshow Command

Database Properties

Good Design Practices

Identifiers

Creating Databases

Altering Databases

Dropping Databases

Creating Tables

Table Properties

Column Options

Creating Tables Based on Existing Tables

Altering Tables

Dropping Tables

Foreign Keys

The INSERT Statement

The DELETE Statement

The UPDATE Statement

The REPLACE Statement

INSERT with ON DUPLICATE KEY UPDATE

The TRUNCATE TABLE Statement

What is a Transaction?

Transaction Commands

Isolation Levels

Locking

What is a Join?

Joining Tables in SQL

Basic Join Syntax

Inner Joins

Outer Joins

Other Types of Joins

Joins in UPDATE and DELETE statements

Types of Subqueries

Table Subquery Operators

Correlated and Non-Correlated Subqueries

Converting Subqueries to Joins

What Are Views?

Creating Views

Updatable Views

Managing Views

Obtaining View Metadata

Why Use Prepared Statements?

Using Prepared Statements from the mysql Client

Preparing a Statement

Executing a Prepared Statement

Deallocating a Prepared Statement

Exporting and Importing Data

Exporting and Importing Data Using SQL

Exporting and Importing Data Using MySQL Client Programs

Import Data with the SOURCE Command

What is a Stored Routine?

Creating, Executing and Deleting Stored Routines

Compound Statements

Assign Variables

Parameter Declarations

Flow Control Statements

Declare and Use Handlers

Cursors

What are Triggers?

Delete Triggers

Restrictions on Triggers

SQL Parser and Storage Engine Tiers

Storage Engines and MySQL

The MyISAM Storage Engine

The InnoDB Storage Engine

The MEMORY Storage Engine

Other Storage Engines

Overview of Optimization Principles

Using Indexes for Optimization

Using EXPLAIN to Analyze Queries

Query Rewriting Techniques

Optimizing Queries by Limiting Output

Using Summary Tables

Optimizing Updates

Choosing Appropriate Storage Engines TOPIC22 Conclusion