Aqua Q kdb+ Analyst Badge

kdb+ Analyst

£400.00

kdb+ Analyst is a shorter course aimed at end-users who want to learn how to query and analyse data from an existing kdb+ database. This course provides interactive video tutorials covering Select Statements, Table Joins, Adverbs, Attributes and Data Analytics using q.

Category:

Description

Unit 1

Introduction and Getting Started

  • Getting Started
  • Moving Forward

Unit 2

Selects and QSQL

  • Introduction to Selects and QSQL
  • Using Select Statements
  • The Where Clause
  • The By Clause
  • Functional Form
  • Using an IDE
  • Selects and QSQL Conclusion

Unit 3

Keywords, Joins, Adverbs and Attributes

  • Introduction to Keywords, Joins, Adverbs and Attributes
  • Keywords
  • Joins
  • Asof and Window Joins
  • Adverbs
  • Attributes
  • Keywords, Joins, Adverbs and Attributes Conclusion

Unit 4

Data Analysis

  • Introduction to Data Analysis
  • Racking, Aligning and Pivoting
  • Comparing to a Profile
  • Trade Analysis
  • Map-Reduce and Parallelization
  • Data Analysis Conclusion

Unit 5

Self Assessment Quiz

  • Conclusion
  • Kdb+ Analyst Quiz