SQL Advanced in MySQL

Book Public Course Now!Get closed/on-site Course Quote!Get distance Course Quote!
ID:
654
Duration: 
8 hours
Tags: MySQL

Overview

This course has been created for people already acquainted with SQL. The course introduces you into secretes common to all SQL databases as well as MySQL specific syntax, functions and features.

Requirements

Good SQL knowledge.

Following Courses

No following Courses Found.

Training Course Outline

DQL (Data Query Language)

Correlation in FROM, WHERE, SELECT and HAVING clauses

Correlation and performance

Using CASE, IF, COALESCE functions

Using variables

Casting and converting

Dealing with NULL, NULL-safe operators

Using regular expression with REGEXP operator

Useful MySQL specific group by functions (GROUP_CONCAT, etc.)

GROUP BY WITH ROLLUP

EXISTS, ALL, ANY

Multitable OUTER JOIN

Rewriting subqueries as joins

DML (Data Modification Language)

Multi-row inserts

INSERT by SELECT

Using subqueries in DML statements

Using variables in DML queries

Locking tables and rows

Updating data in many tables

IGNORE clause

REPLACE clause

DELETE versus TRUNCATE

DDL (Data Definition Language)

Creating tables with select

Temporary tables

Stored Procedures

Short introduction to MySQL stored procedures

 

Training Course Dates

DateTraining OutlineVenuePriceDetails
2010-04-26 09:00 - 17:00SQL Advanced in MySQLNorth Acton, LondonFrom 342 GBP per personCheck Price! >>
2010-06-21 09:00 - 17:00SQL Advanced in MySQLNorth Acton, LondonFrom 342 GBP per personCheck Price! >>
2010-08-16 09:00 - 17:00SQL Advanced in MySQLNorth Acton, LondonFrom 342 GBP per personCheck Price! >>
2010-10-11 09:00 - 17:00SQL Advanced in MySQLNorth Acton, LondonFrom 342 GBP per personCheck Price! >>
2010-12-06 09:00 - 17:00SQL Advanced in MySQLNorth Acton, LondonFrom 342 GBP per personCheck Price! >>