SQL

Structured Query Language (SQL) is a standardized programming language that is used to manage relational databases and perform various operations on the data in them.

Attribute Name

Description

SFIA Skills

Attribute Name

Description

SFIA Skills

MySQL - Lvl 1

Knows basic SQL syntax, can select data from the table and apply basic filters

DENG

MySQL - Lvl 2

Understands joins, can describe the difference between inner vs left outer vs right outer vs full outer vs cross joins and apply them correctly.
Can create and update tables, basic understanding of transactions.

DENG

MySQL - Lvl 3

Able to write complex SQL queries including aggregation with group by clause and limiting output based on aggregated values.
Understands the use case for self-join and sub-queries in where clause and/or join statement. Familiar with views / materialized views and the purpose them.

DENG

MySQL - Lvl 4

Understands difference between OLTP and OLAP and when/where each should be used. Familiar with CTEs and temporary tables. Basic understanding what the indecies are for, not how they exactly work though. Familiar with stored procedures and functions and use case for each.

DENG

MySQL - Lvl 5

Understands and effectively applies analytical and window functions, able to produce complex reports, familiar with pivoting. Able to work with complex structured data types like XML and JSON. Familiar with query execution plans, how to read them and what affects it. Able to identify potential future bottlenecks, although not always be able to come up with optimal solution.

DENG

MySQL - Lvl 6

Understands and able to use safely triggers and cursors, without deteriorating the query performance. Can resolve potential bottlenecks and fine tune the query to improve performance applying different techniques using query execution plan, statistics, etc.

DENG

 

 

Â