Kdb+ Fundamentals

Kdb+ Fundamentals is an introductory kdb+ course perfect for learning about kdb+ and the principles of vector programming. This three-day training course is ideal for those with limited or zero experience with kdb+. By the end of this kdb+ training course  you  will be fully able to use kdb+ to manage data from multiple data sources and interact with both in-memory and on-disk kdb+ installations.

Day 1
The BasicsAn introduction to q. Starting sessions, defining variables, performing basic logic and arithmetic operations.
Data TypesDetailed overview of all q data types and appropriate usage.
ListsFundamental data structure of kdb+ upon which all advanced structures are based.
FunctionsIn-built and user-defined functions.
Dictionaries & AssociationsMap type structures used for storing static, lookup or rule type information.
Execution ControlConditional statements, loops, protected evaluation and debugging.
Basic AdverbsProviding useful iterative and looping behaviour.
Day 2
TablesAn introduction to q. Starting sessions, defining variables, performing basic logic and arithmetic operations.
Keyed TablesMore sophisticated class of table.
qSQLAn introduction to SQL like syntax in q.
Advanced Table Accessq centric methods for table access, analysis and manipulation.
Basic Table JoinsIn-built functions for combining tables.
Day 3
Amend/ApplyThe q operators ‘.’ and ‘@’ in relation to manipulating data in place.
Basic Web InterfaceA short look at the kdb+ web interface.
Importing/Exporting DataA detailed look at importing data from CSV files and various other formats.
Basic On-Disk kdb+Basic overview for persisting and querying tables on disk.
IPCA basic introduction to inter-process communication. Opening connections, synch/asynch messaging between q instances.
ODBCODBC as tool to connect between kdb+ and other database technologies.
Language InterfacesInterfacing with Java, C#, C/C++ etc.