SQL
Master the basics of SQL language to query, manipulate and optimize your relational data, using practical, step-by-step case studies.
Purpose(3)
Developing efficient loading scripts : Master the Qlik scripting language to import, transform and structure your data according to best practices.
Building an optimized data model : Learn how to manage relationships, merge tables and create a reference calendar to guarantee high-performance analyses.
Applying professional development standards : Use variables, organize your scripts, comment on your code and implement maintenance techniques for sustainable, scalable applications.
Content
Development methodology
Data loading techniques
Best practices for data loading
Reference calendar
Optimization 1 table merge
Optimization 2 advanced integration
Linking tables and performance
Integration of complex expressions
Advanced set analysis
Data storage and optimization
Prerequisites(1)
Duration 2,5 jours
Qlik Sense Developer
This course comprises 10 modules, 9 lasting 1 hour 45 minutes and one lasting 3 hours 30 minutes. You'll learn how to write loading scripts, create efficient data models, use variables, optimize performance and automate data management. All materials are provided via our learning platform.
References : FQSD25
