SQL for Analysts Training
Level
IntermediateDuration
16h / 2 daysDate
Individually arrangedPrice
Individually arrangedSQL for Analysts Training
Enhance your data analysis skills by leveraging advanced SQL capabilities. Learn how to write more efficient queries, work with large datasets, and optimize your daily analytic work.
What You Will Learn
- How to analyze data using advanced techniques for ordering and comparing records
- How to group and aggregate data in various ways to create readable and complex reports
- How to combine and compare datasets and use subqueries in more flexible ways
- How to create temporary structures, automate queries, and efficiently import/export data
Who is this training for?
Data analysts who already know the basics of SQL and want to move to a higher level-
BI specialists working with large datasets in their everyday tasks
-
Professionals preparing reports, analyses, and summaries based on databases
-
Those who want to increase the efficiency of their queries and data-work
Training Program
-
Window Functions
- ROW_NUMBER()
- RANK()
- DENSE_RANK()
- LAG()
- LEAD()
-
Data Grouping
- ROLLUP
- CUBE
- GROUPING SETS
-
Sets and Data Collections
- UNION / UNION ALL
- EXCEPT
- INTERSECT
- Correlated subqueries
-
Built-in Functions
- Text functions
- Date and time functions
- Math functions
- Converting functions
-
Temporary Data Structures
- Common Table Expressions (CTEs)
- Views
- Temporary tables
-
Performance Optimization
- Functions and procedures
- Dynamic SQL
- Importing and exporting data
- Bulk import
