SQL Advanced in MySQL Training Course

Description

• Type

  Course

• Methodology

  Online

Description

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

About this course

Requirements

Good SQL knowledge.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Fill in your details to get a reply

I agree to the Privacy Policy and the Conditions.

Send

We will only publish your name and question

Emagister S.L. (data controller) will process your data to carry out promotional activities (via email and/or phone), publish reviews, or manage incidents. You can learn about your rights and manage your preferences in the privacy policy.

Request information

We are verifying your question adjusts to our publishing rules. According to your answers, we noticed you might not be elegible to enroll into this course, possibly because of: qualification requirements, location or others. It is important you consult this with the Centre.

Thank you!

We are reviewing your question. We will publish it shortly.

Or do you prefer the center to contact you?

Request information

Reviews

Have you taken this course? Share your opinion

Subjects

• MySQL
• SQL

Course programme

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

Additional information

7 hours (usually 1 day including breaks)

See related categories

• SQL courses
• Distance learning SQL courses
• Oracle sql courses
• Data analysis sql courses
• Sql intermediate courses
• Transact sql courses
• Other Database courses
• Distance learning Other Database courses
• Distance learning Course
• Nobleprog Limited courses