|
Provided by: NobleProg - IT training courses SQL Advanced in MySQLSQL |
 |
Training
Provided by NobleProg - IT training courses
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.
|
|
||||||||||||||||||||
SQL Advanced in MySQL
DDL (Data Definition Language)
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 expresion with REGEXP operator
Usefull MySQL specific group by functions (GROUP_CONCAT, etc.)
GROUP BY WITH ROLLUP
EXISTS, ALL, ANY
Multitable OUTER JOIN
Reqriting 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
About The Training Provider: NobleProg - IT training courses
NobleProg - IT training courses - NobleProg specializes in bespoke computer and management training courses.
NobleProg provides computer training courses in the following areas:
* Drupal
* Java
* Linux
* MySQL
* OpenOffice
* Oracle
* PHP
* Project Management
* SVN and CVS
* UML
* Web Application Testing
* CSS
* VBA
* BPM
* SOA
* LPI (We are...
