What will I learn?

In order to harness the best performance from kdb+ the q language will always be the optimum way to query your data. But there is also now a way to run SQL queries using KX SQL.

The focus of this course is an introduction to using SQL with the KX technology. You will learn how to run basic SQL queries, what SQL language is supported, how to apply parameters, perform pre parsing and see interoperability in action.

Agenda

This course contains a practical introduction to the following topics:

• How to run basic queries with KX SQL?
• SQL language supported
• Table creation, modification and deletion
• Applying parameters
• Pre-parse optimization
• Interoperability

Who is this course suitable for?

Aimed at beginners to KX who wish to use SQL to query their KX data. No prior experience required. Some experience with SQL will be beneficial.

What do I receive for taking this course?

You will receive a KX Certification to state that you have attended and completed the course. This is dependent on completing the end of course Challenge, further details can be found at the end of the course.

Feel free to show off and share your certification on social media or LinkedIn!