Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
コース概要
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
要求
Good SQL knowledge.
7 時間
お客様の声 (5)
フィリップはとても親切で、SQL のコンセプトを説明する彼のスタイルは傑出していました。彼が私たちに情報を提供し、このコースの一部ではなかった質問に答えてくれたのが気に入りました。
Stefan
コース - SQL in SQL Server
Machine Translated
analytical functions
khusboo dassani - Tech Northwest Skillnet
コース - SQL Advanced
The training materials.
Mona Dobre - DB Global Technology
コース - SQL Advanced level for Analysts
They way the instructor teaches is very informative and effective especially on the 2nd day when topics are a bit advanced.
Aynanie Kiram - Aarki, Inc.
コース - SQL DATABASE MANAGEMENT AND DESIGN - Bespoke
The course built lesson to lesson, and the pacing was a big deal for me.
