The Advanced QlikView Developer Bootcamp

Course Curriculum

Chapter 1: Introduction

Lecture 1: Course Intro

Lecture 2: Course Curriculum Overview

Lecture 3: For HELP: Join Private Slack Channel

Chapter 2: Github: Data Set, Challenges, Solution QVWs

Lecture 1: 2.1: Course Approach and Github

Lecture 2: 2.2: Approach – Challenges and Solutions

Chapter 3: QlikView Data Modelling

Lecture 1: 3.0 Chapter Goals

Lecture 2: 3.1: Understanding Data Modelling (Part 1)

Lecture 3: 3.1: Understanding Data Modelling (Part 2)

Lecture 4: 3.1: Understanding Data Modelling (Part 3)

Lecture 5: 3.2: Conceptual Aside – Data Modelling

Lecture 6: 3.3: Types of Data Models

Lecture 7: 3.4: Conceptual Aside – Star Schema

Lecture 8: 3.5: Demo – Star Schema

Lecture 9: 3.6: Conceptual Aside – Snowflake Schema

Lecture 10: 3.7: Demo – Snowflake Schema

Lecture 11: 3.8: Concatenated Fact Tables

Lecture 12: 3:9: Demo – Concatenated Fact Table

Lecture 13: 3.10: Our Advice

Lecture 14: 3.11: Challenge – Simplify the Data Model

Lecture 15: 3.12: Solution – Simplify the Data Model

Chapter 4: Mapping Load, ApplyMap and Map using

Lecture 1: 4.0: Chapter Goals

Lecture 2: 4.1: Understanding Mapping Load

Lecture 3: 4.2: Understanding ApplyMap( )

Lecture 4: 4.3: MapSubString( )

Lecture 5: 4.4: Map Using

Lecture 6: 4.5a: Challenge

Lecture 7: 4.5a: Solution

Lecture 8: 4.5b: Challenge

Lecture 9: 4.5b: Solution

Chapter 5: Resident Load vs. Preceding Load

Lecture 1: 5:0: Chapter Goals

Lecture 2: 5:1: Understanding Script Execution

Lecture 3: 5.2: Understanding Resident Load

Lecture 4: 5.3: Understanding Preceding Load

Lecture 5: 5.4: Further Reading (Cost of Preceding Load)

Lecture 6: 5.5: Difference between WHERE and HAVING clause

Lecture 7: 5.6: How to implement HAVING clause in QlikView

Lecture 8: 5.7: Challenge – Resident vs Preceding Load

Lecture 9: 5.8: Challenge – Source Files (QVW, QVS and QVD)

Lecture 10: 5.8: Solution – Resident vs Preceding Load

Chapter 6: Synthetic Keys and Link Table

Lecture 1: 6.0: Chapter Goals

Lecture 2: 6.1: Introduction to Synthetic Keys and Link Table

Lecture 3: 6.2: Link Table Deep Dive

Lecture 4: 6.3: Creating Link Table – I

Lecture 5: 6.4: Creating Link Table – II

Lecture 6: 6.5: Challenge – Synthetic Table to Link Table

Lecture 7: 6.6: Solution – Synthetic Table to Link Table

Lecture 8: 6.7 Chapter Summary

Chapter 7: Incremental Reload

Lecture 1: 7.0: Chapter Goals

Lecture 2: 7.1: Understanding Incremental Reload

Lecture 3: 7.2: Incremental Reload Architecture

Lecture 4: 7.3 Incremental Reload: Inserts – Part I

Lecture 5: 7.3 Incremental Reload: Inserts – Part II

Lecture 6: 7.3 Incremental Reload: Inserts – Part III

Lecture 7: 7.3 Incremental Reload: Inserts – Part IV

Lecture 8: 7.4: Incremental Reload – Insert and Update – Part I

Lecture 9: 7.4: Incremental Reload – Insert and Update – Part II

Lecture 10: 7.5: Challenge Incremental load – Insert and Update

Lecture 11: 7.6: Solution – Incremental load – Insert and Update

Lecture 12: 7.7: Incremental Reload – Insert, Update and Delete – Part I

Lecture 13: 7.7: Incremental Reload – Insert, Update and Delete – Part II

Lecture 14: 7.8: Challenge – Incremental load – Insert, Update and Delete

Lecture 15: 7.9: Solution – Incremental load – Insert, Update and Delete

Lecture 16: 7.10: Chapter Summary

Chapter 8: QlikView Joins Deep Dive

Lecture 1: 8.0: Chapter Goals

Lecture 2: 8.1: Associative Join and Explicit ANSI Style Joins

Lecture 3: 8.2: Outer Join

Lecture 4: 8.3: Inner Join

Lecture 5: 8.4: Left Join

Lecture 6: 8.5: Right Join

Lecture 7: 8.6: Cartesian Product

Chapter 9: Introduction to Master Calendar

Lecture 1: 9.0: Chapter Goals

Lecture 2: 9.1: Master Calendar Fundamentals

Lecture 3: 9.2: Steps to Create Master Calendar

Lecture 4: 9.3 Challenge – Master Calendar

Lecture 5: 9.4: Solution – Master Calendar

Lecture 6: 9.5 Chapter Summary

Chapter 10: Folder Structure, Script Configuration & Variable Naming Convention

Lecture 1: 10.0 Chapter Goals

Lecture 2: 10.1: Application Folder Structure

Lecture 3: 10.2 QlikView and Source Control

Lecture 4: 10.3: Script Tab Layout

Lecture 5: 10.4: Script Global Config File

Lecture 6: 10.5: Variable Naming Convention