Matillion Fundamentals
An ideal training course for getting started with Matillion: create your first cloud data integration workflows, orchestrate processing and manipulate your datasets without coding.
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
