Hands-On SQL: Building Data Products in Dremio
1h 27mBeginner2025-03-28
Authors
Dremio
Course details
Looking to get up and running with SQL in Dremio? In this course, designed for data analysts and Dremio practitioners, learn how to use SQL within the free version Dremio for analytics and start building data products like a pro. Explore the essentials of SQL, how to leverage SQL as a data analysis, and how to create data products in Dremio. Along the way, gather insights on how to successfully execute SQL against a data product.
Skills covered
SQLDatabase AdministrationDatabase DevelopmentDatabase ManagementData AnalysisProgramming LanguagesData ScienceBusiness Analysis and StrategyBusiness Software and ToolsOpen SourceSoftware DevelopmentOne-Off
Concepts
0. Introduction
- 01 - What is SQL
- 02 - Why use SQL
1. Data Products in Dremio
- 03 - Get started with Dremio
- 04 - Adding data sources
- 05 - Create a data product
2. Executing SQL with Data Products
- 06 - LIMIT clause
- 07 - WHERE clause
- 08 - ORDER BY clause
- 09 - Inline calculations and transformations
- 10 - CASE statements
- 11 - Joins
- 12 - Aggregations
- 13 - GROUP BY and HAVING clauses
- 14 - DATE and TIME
- 15 - Connecting to PowerBI
Conclusion
- 16 - Conclusion