Book a Demo Free Trial
Book a Demo Free Trial
Back

kdb Products

Overview
KDB.AI
kdb+
kdb Insights
kdb Insights Enterprise

Capabilities

Anomaly Detection
kdb+ Time Series Database
Liquidity Management
PyKX Python Interoperability
The Data Timehouse
Vector Database Explained

Services & Support

Services
Software Support

Back

Financial Services

Quant Research
Trading Analytics

Industry & IoT

Automotive
Energy & Utilities
Healthcare & Life Sciences
Manufacturing
Telco

Back

Learn

Overview
Featured Courses
KX Academy
KX University Partnerships
Connect
KX Community
Community Events
Developer Blog
Build
Download
Documentation
Support

Back

Blog
Brochures
Customer Success Stories
Developer Blog
KX Community
Resource Center
Webinars
Videos
Whitepapers

Back

About Us

Overview
News Room

Partner with Us

KX Partner Network
Find a Partner
Partner Signup

Join Us

Careers
Events

Connect with Us

Contact Us
Demo Request

...

Agenda

  • Introduction to Queries -qSQL
    • Data
  • Choosing data from a table - select
    • Syntax
    • Virtual columns
    • Queries with specified return - the select clause
      • Querying with aggregations
    • Queries with constraints - the where clause
    • Queries with grouping - the by clause
      • Temporal arithmetic
  • Extracting data from tables - exec
  • Updating/modifying table data - update
  • Remove data from table - delete
  • Using fby to avoid nested queries

back to courses list
Course Details
Duration 40 min
Type q/kdb+
Level Beginner
Sign In and Start
Forgot Password?
New user?

OR

Main Office Contacts

AMERICAS
Tel: +1 (212) 447 6700
EMEA
Tel: +44 (0)28 3025 2242
APAC
Tel: +65 65921960
ANZ
Tel: +61 (0)2 9236 5700

Useful Information
Resources
Popular Links
Follow Us
©2023 KX. All Rights Reserved.
KX® and kdb+ are registered trademarks of KX Systems, Inc., a subsidiary of FD Technologies plc.
Privacy Policy
Export Statement
Sitemap
feedback