- Type Learning
- Level Foundational
SQL for Data Analysis - Advanced Course Completion Badge
Issued by
Lumify Work Australia
Authorized by
Lumify Group
Earners of the Lumify Work SQL for Data Analysis - Advanced course badge have completed instructor-led training in using Structured Query Language (SQL). They have learned sophisticated techniques for querying databases and manipulating result sets such as reshaping data by pivoting and unpivoting, writing complex queries, using recursive techniques to query hierarchical data, and using user-defined functions to create table-valued functions.
- Type Learning
- Level Foundational
Skills
- Reshape and manipulate SQL result sets
- Reshape data by pivoting and unpivoting
- Use recursive techniques to create date dimension tables
- Use recursive techniques to query hierarchical data
- Use sophisticated techniques for querying SQL databases
- Write complex queries using subqueries, temporary tables, and common table expressions
- Write more efficient SQL code