Snowflake + Tableau best practices
Learn how to exploit the full potential of Snowflake with Tableau by applying best practices in modeling, query optimization and visualization.
Purpose(3)
Understanding the basics of relational databases : Identify the key structures, relationships and principles of the relational model.
Writing and structuring efficient SQL queries : Formulate simple and complex queries to extract and manipulate data.
Optimize performance and guarantee data integrity : Apply best practices for writing high-performance queries and managing transactions.
Content
Introduction to SQL
Database creation and management
Basic selection query
Aggregation and grouping functions
Multi-table queries and joins
Subqueries and Advanced Operations
Data and Transaction Management
Query Optimization and Performance
Prerequisites
None
Duration 2 jours
SQL
This course comprises 8 modules spread over two days. It is aimed at beginners to intermediates wishing to learn how to write efficient SQL queries, understand the logic of relational databases, and optimize their performance.
References : FS25
