kdb+ Analyst


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.



Introduction and Getting Started

  • Getting Started
  • Moving Forward

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

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

Data Analysis

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

Self Assessment Quiz

  • Conclusion
  • Kdb+ Analyst Quiz