Empowering Self-Service Data Warehouse Access with SQL

This course is best for data consumers or practitioners who want to have finer-grained control over the data entering their analysis (BI) tools. Analysts will learn how to use the Structured Query Language (SQL) to access, combine, filter, summarize, and export data from relational databases. Participants will learn how to find the data they need by interpreting Entity Relationship Diagrams (ERD) models of database structure. This course will include a discussion of potential issues that users may encounter when dealing with data warehouses, such as data duplication, missing values, and choosing the right table. Overall, learners will be empowered to shift common data exploration, pre-processing, and integrity management out of BI tools and into the data warehouse, gaining efficiency with large datasets and supporting ongoing data integrity at its source.

Key skills covered in this course: 

• Relational Database Fundamentals
• Structured Query Language (SQL) 
• Data Integrity Management
• ETL Basics and Best Practices 

Upon successful completion of the course, learner outcomes include: 

• Find desired data by interpreting Entity Relationship Diagrams (ERDs)
• Increase data processing speed by using SQL to combine, filter, and summarize very large datasets before loading them into BI tools
• Shift data pre-processing from the BI tool to the SQL database in order to increase processing efficiency and improve self-service dashboard experience
• Screen for common data integrity issues before exporting the data to improve accuracy and build trust in the common data source
• Automate data updates by writing efficient and schedulable SQL queries

Potential learners:

• Analysts
• Database Administrators
• Data Scientists
• Reporting Specialists