1. INTRODUCTION TO QLIK VIEW

• Target Audience
• What You Will Learn in this Course
• Course Logistics
• Notes

2. QLIKVIEW ENVIRONMENT

• QlikView Desktop

3. QLIKVIEW DEVELOPMENT METHODOLOGIES

• Import/Export Sheet and Document Layouts as XML
• Qlik Wholesale Trade (QWT) Project Plan
• Project Plan Review
• SAFE Methodology

4. DEPLOYMENTS

• QlikView Standalone
• QlikView Server
• QlikView Publisher

5. INTRODUCTIONS TO DATA AND SCRIPTING

• Relational Databases
• Other Data Structures
• Comparing Database Structures to QlikView Data Structures
• Data Structures in QlikView
• Data Source Files
• The QWT Primary Data Source
• The QWT Secondary Data Files
• Introduction to Scripting

6. BASIC SCRIPT SYNTAX

• Syntax

7. LOADING DATA FROM THE DATABASE

• Script Generation
• Comments in the Script
• Script Debugging

8. STRUCTURING THE SCRIPT

• Creating Tabs in the Script

9. BASIC DATA MODEL AND TABLE VIEWER

• The Table Viewer
• The System Table
• Document Properties:

10. BASIC DATA TRANSFORMATION

• Load Statement
• Renaming a Field
• Script Expressions
• Loading an XML File
• Renaming Fields Using the Qualify Statement
• Key Fields
• Example Predicament
• How Does this Affect You?
• Loading a Field into a Table Multiple Times
• Using a Record Counter on Key Fields
• Is it Correct?

11. ADDING TEXT DATA

• Employees
• Offices
• Script generation using the File Wizard

12. GENERATING DATA IN THE QLIKVIEW SCRIPT

• Resident Load
• Using Orders to determine Sales Person.
• Include
• Time Functions: Creating a Calendar
• Getting the Highest and Lowest Date from the Orders Table
• Autogenerate tables
• Creating Variables in the Script
• The Master Calendar

13. SCRIPTING CONSIDERATIONS

• Synthetic Key Tables
• Circular References
• Causes of Circular References
• Check the Numbers

14. QLIKVIEW DATA (QVD) FILES

• QVD File Format
• Use of QVD Files
• Creating QVD Files
• Manual Creation of a QVD File in the Script
• Automatic Creation of a QVD File in the Script
• QVD File Script Functions

15. REPORTING BUGS IN QLIKVIEW

16. ADDITIONAL INFORMATION

• Reference Materials
• Data types in QlikView

17. APPENDIX: LAYOUT BASICS FOR DEVELOPERS

• User Friendly Design
• Natural Human Behavior
• Chart and Object Choices in QlikView
• Import/Export Sheet and Document Layouts

18. APPENDIX: The Completed Script

Teradata COURSE CONTENT
What Is Teradata Why For It Is What For It Is
	What is Teradata?
	Teradatav12 & versions
	Teradata History
	Teradata users scalability
	Teradata &other RDBMS
	Teradata warehouse
	Teradata in the Enterprise
	Interview Q&A and Certification queries
Teradata Architecture & It’s Components
	Node Architecture(Shared Architecture)
	SMP Architecture
	MPP Architecture
	Parsing engine(PE) Architecture
	AMP Architecture &uses
	Bynet Benefits &types
	Parallel data extension(PDE)
	Teradata directory program(TDP)
	Call level interface(CLI)
	Trusted parallel application(TPA)
	Virtual processors
	Bynet 0 &Bynet 1
Recovery &Protection Of Data
	What is fall back &where it used
	Why for fall back
	What is Clique
	AMP Clustering
	& types for simultaneous Acces
	Why for locks &how to release
	RAID 1 &RAID 5
	Journals &types
	Virtual Disk Array
	How & where is used  journals
	Q & A about data recovery
Teradata Indexes
	Types of indexes in Teradata
	Hash index
	Join index
	Primary index(unique, non- unique)
	Secondary index(unique, non- unique)
	Skewness
	Keys & indexes (How & why these used)
How To Storage & Retrieval Of Data
	Hash algorithm
	hash
	Hash map
	Hash bucket
	Receiving VDisc
Teradata Sql Quarryman
	SQL  fundamentals
	Data types and literals
	DDL Statements
	DML Statements
	Teradata naming conversing
Teradata Sql Functions & Operations
	String functions
	Format functions
	Cast functions
	Group & Aggregation functions
	Logical operations
	Arithmetic operations
	set operations
	join operations
	conditional expressions
Teradata Join Strategies & Unions
	hash join
	merge join
	nested join
	product join
	inner join
	left & right outer join
	full outer join
Teradata Objects
	Types of tables
	Set tables
	Multi tables
	Volatile tables
	Global temporary tables
	Derived tables
	Views
	Macros
	Stored procedures
	Triggers
Teradata Memory Spaces
	Permanent spaces
	Temporary spaces
	Spool spaces
	Users spaces & PWD
Teradata Transaction Modes
	Batch mode
	BTET mode
	ANSI mode
	How Converted into others
Teradata Performance Tuning On Sql Assistance
	Usage of  PMON
	Explain usage
	Collecting statistics
	SQL tuning
	Various SQL statements
	Real time Issues & resolving
Teradata Utilities & Tools (Import & Export)
	Teradata BTeq scripts
	Overview of BTeq
	Looping stages
	Batches scripts
	Import &export scripts with Examples
	Error handling
	Real time scripts
	Teradata FastLoad
	Types of phages & how to find it
	Advantages & its process
	Limitations of fast load
	Real time scripts
	Teradata MultiLoad
	Overview of Multi load
	Types of phages in MultiLoad
	Advantages & its process
	Limitations of MultiLoad
	Uses various types of operations
	Work on Multi tables
	Real time scripts
	Sample scripts
	Teradata Tpump
	Overview of Tpump
	Limitations of Tpump
	Work on Multi tables
	Real time scripts
	Sample scripts
	Teradata Fast Export
	How to export the data
	Passing parameters
	IN/OUT Modes
	Work on Multi tables
	Real time scripts
	Sample scripts
	Teradata SQL Assistant(Quarryman)
	Teradata performance tuning on scripts