kdb+ and q: Analyze Time Series Data Training Course
kdb+ is an in-memory, column-oriented database and q is its built-in, interpreted vector-based language. In kdb+, tables are columns of vectors and q is used to perform operations on the table data as if it was a list. kdb+ and q are commonly used in high frequency trading and are popular with the major financial institutions, including Goldman Sachs, Morgan Stanley, Merrill Lynch, JP Morgan, etc.
In this instructor-led, live training, participants will learn how to create a time series data application using kdb+ and q.
By the end of this training, participants will be able to:
- Understand the difference between a row-oriented database and a column-oriented database
- Select data, write scripts and create functions to carry out advanced analytics
- Analyze time series data such as stock and commodity exchange data
- Use kdb+'s in-memory capabilities to store, analyze, process and retrieve large data sets at high speed
- Think of functions and data at a higher level than the standard function(arguments) approach common in non-vector languages
- Explore other time-sensitive applications for kdb+, including energy trading, telecommunications, sensor data, log data, and machine and network usage monitoring
Audience
- Developers
- Database engineers
- Data scientists
- Data analysts
Format of the course
- Part lecture, part discussion, exercises and heavy hands-on practice
Course Outline
To request a customized course outline for this training, please contact us.
Requirements
- An understanding of statistics
- Experience in the financial industry is helpful
- An understanding of relational databases
- Some experience with programming is helpful, but not required
Open Training Courses require 5+ participants.
kdb+ and q: Analyze Time Series Data Training Course - Booking
kdb+ and q: Analyze Time Series Data Training Course - Enquiry
kdb+ and q: Analyze Time Series Data - Consultancy Enquiry
Testimonials (5)
All the topics which he covered including examples. And also explained how they are helpful in our daily job.
madduri madduri - Boskalis Singapore Pte Ltd
Course - QGIS for Geographic Information System
I liked Pablo's style, the fact that he covered a lot of subjects from report design , customization with html to implementing simple ML algortithms. Good balance theoretical information / exercices. Pablo really covered all topics i was interested in and gave comprehensive answers to my questions.
Cristian Tudose - SC Automobile Dacia SA
Course - Advanced Data Analysis with TIBCO Spotfire
Actual application of spotfire and all basic functions.
Michael Capili - STMicroelectronics, Inc.
Course - Introduction to Spotfire
The thing I liked the most about the training was the organization and the location
Hamid Tuama - Ability with Innovation General Contracting (DMCC Branch)
Course - ArcGIS for Spatial Analysis
I genuinely enjoyed the lots of labs and practices.
Vivian Feng - Destination Canada
Course - Data Analysis with SQL, Python and Spotfire
Upcoming Courses
Related Courses
ArcGIS for Spatial Analysis
14 HoursThis instructor-led, live training in the Philippines (online or onsite) is aimed at field ecologists and conservation managers who wish to create data spatial projects in ArcGIS.
By the end of this training, participants will be able to:
- Output spatial data as visualizations.
- Conduct geostatics on actual data.
- Implement spatial data analysis, data processing, and mapping with ArcGIS.
- Analyze spatial data for projects in ArcGIS.
ArcGIS with Python Scripting
14 HoursThis instructor-led, live training in the Philippines (online or onsite) is aimed at GIS analysts who wish to automate repetitive tasks in GIS processes.
By the end of this training, participants will be able to:
- Build GIS applications using Python and ArcGIS tools.
- Develop with the ArcGIS package ArcPy, using Python.
- Apply the ArcGIS modules for map automation using object classes in Python.
ArcGIS Pro for Spatial Analysis
14 HoursBy the end of this training, participants will be able to:
- Understanding GIS concepts and spatial data types using the latest version of ArcGIS Pro.
- Investigate the user interface and evaluate the uses
- Explore ArcGIS* Pro and how to utilize online content
- Manage, manipulate and analyze your own data
- Display and share your data in a meaningful and creative way
Note: We will use the latest version of ArcGIS Pro.
ArcMap in ArcGIS
14 HoursThis instructor-led, live training in the Philippines (online or onsite) is aimed at intermediate-level environmental scientists and archaeologists who wish to learn how to use ArcMap in ArcGIS for collecting, organizing, managing, and analyzing geographic information.
By the end of this training, participants will be able to:
- Understand the fundamentals of ArcMap and ArcGIS.
- Collect, organize, manage, and analyze geographic information on the social and archaeological elements.
- Conduct spatial queries for impact evaluation.
ArcGIS Fundamentals
14 HoursThis instructor-led, live training in the Philippines (online or onsite) is aimed at beginner-level professionals who wish to learn the fundamental concepts and tools of ArcGIS.
By the end of this training, participants will be able to:
- Understand the basic concepts of GIS and spatial data.
- Navigate the ArcGIS interface.
- Create and manage spatial data.
- Perform basic spatial analysis.
- Create maps and visualizations.
ArcGIS Enterprise for Technical Support
14 HoursThis instructor-led, live training in the Philippines (online or onsite) is aimed at beginner-level IT support personnel who wish to provide robust support for ArcGIS Enterprise, addressing any anomalies or failures effectively.
By the end of this training, participants will be able to:
- Understand the architecture and components of ArcGIS Enterprise.
- Learn to install, configure, and manage ArcGIS Enterprise.
- Gain skills in troubleshooting and resolving common issues.
- Develop proficiency in monitoring and maintaining ArcGIS Enterprise environments.
- Master the techniques for backup, recovery, and performance optimization.
QGIS for Geographic Information System
21 HoursA geographic information system (GIS) is a system designed to capture, store, manipulate, analyze, manage, and present spatial or geographic data. The acronym GIS is sometimes used for geographic information science (GIScience) to refer to the academic discipline that studies geographic information systems and is a large domain within the broader academic discipline of geoinformatics.
QGIS functions as geographic information system (GIS) software, allowing users to analyze and edit spatial information, in addition to composing and exporting graphical maps. QGIS supports both raster and vector layers; vector data is stored as either point, line, or polygon features. Multiple formats of raster images are supported, and the software can georeference images. To summarize it allows the users to Create, edit, visualise, analyse and publish geospatial information on Windows, Mac, Linux, BSD.
This program, in its first phase, introduces the QGIS interface for general usage. In the second phase, we introduce PyQGIS - the python libraries of QGIS that allows the integration of GIS functionalities in your python code or your python application, so that you may even create your own Python Plugin around a particular GIS functionality.
Data Analysis with SQL, Python and Spotfire
14 HoursIn this instructor-led, live training in the Philippines, participants will learn three different approaches for accessing, analyzing and visualizing data. We start with an introduction to RDMS databases; the focus will be on accessing and querying an Oracle database using the SQL language. Then we look at strategies for accessing an RDMS database programmatically using the Python language. Finally, we look at how to visualize and present data graphically using TIBCO Spotfire.
Format of the Course
Interactive lecture and discussion.
Lots of exercises and practice.
Hands-on implementation in a live-lab environment.
Advanced Data Analysis with TIBCO Spotfire
14 HoursThis instructor-led, live training in the Philippines (online or onsite) is aimed at business analysts who wish to learn advanced Spotfire Analyst techniques for analyzing data.
By the end of this training, participants will be able to:
- Share visualizations among different team members.
- Secure access to software based on roles and access controls.
- Create visualizations such as map charts.
- Integrate statistical computing languages such as R with Spotfire.
Introduction to Spotfire
14 HoursThis instructor-led, live training in the Philippines (online or onsite) is aimed at business analysts and data analysts who wish to learn basic Spotfire Analyst techniques for analyzing data.
By the end of this training, participants will be able to:
- Install and configure TIBCO Spotfire.
- Combine data from different databases.
- Visualize large datasets.
- Create and share complex dashboards.
AI-Driven Data Analysis with TIBCO Spotfire X
14 HoursThis instructor-led, live training in the Philippines (online or onsite) is aimed at business analysts and data analysts who wish to use TIBCO Spotfire X with its artificial intelligence capabilities to visualize, transform, and analyze data.
By the end of this training, participants will be able to:
- Install and configure TIBCO Spotfire X.
- Understand the features and architecture of TIBCO Spotfire X.
- Understand the concepts behind augmented and predictive analytics.
- Learn how to load, process, and visualize data using Spotfire X.
- Create interactive and enhanced data visualizations.
Insurtech: A Practical Introduction for Managers
14 HoursInsurtech (a.k.a Digital Insurance) refers to the convergence of insurance + new technologies. In the field of Insurtech "digital insurers" apply technology innovations to their business and operating models in order to reduce costs, improve the customer experience and enhance the agility of their operations.
In this instructor-led training, participants will gain an understanding of the technologies, methods and mindset needed to bring about a digital transformation within their organizations and in the industry at large. The training is aimed at managers who need to gain a big picture understanding, break down the hype and jargon, and take the first steps in establishing an Insurtech strategy.
By the end of this training, participants will be able to:
- Discuss Insurtech and all its component parts intelligently and systematically
- Identify and demystify the role of each key technology within Insurtech.
- Draft a general strategy for implementing Insurtech within their organization
Audience
- Insurers
- Technologists within the insurance industry
- Insurance stakeholders
- Consultants and business analysts
Format of the course
- Part lecture, part discussion, exercises and case study group activities
Sensu: Beginner to Advanced
14 HoursThis instructor-led, live training in the Philippines (online or onsite) is aimed at devops engineers who wish to create monitoring systems for multi-cloud infrastructures.
By the end of this training, participants will be able to:
- Monitor an enterprise from any cloud.
- Use auto-scaling and real-time visibility to create advanced monitoring systems.
- Authenticate a monitoring system with the Sensu API.
- Share programmed monitoring workflows amongst team members.
Monitoring Your Resources with Munin
7 HoursMunin is an open-source monitoring tool that helps system administrators monitor resources such as servers, workstations, networks, SANs, applications, network devices, etc. It shows resource trends and provides insights into questions such as "what just happened to kill our performance?" It includes visualization tools and is available on various flavors of Linux and FreeBSD.
Format of the Course
- Heavy emphasis on hands-on practice. Most of the concepts are learned through samples, exercises and hands-on development.
Automated Monitoring with Zabbix
14 HoursThis instructor-led, live training in the Philippines (online or onsite) covers the installation, planning and configuration of Zabbix, and focuses on practical implementation and tooling.
By the end of this training, participants will be able to:
- Install and configure Zabbix for monitoring IT infrastructure.
- Set up and manage hosts, items, triggers, and actions within Zabbix.
- Utilize Zabbix's features for data collection, alerting, and reporting.
- Integrate Zabbix with other tools and platforms for enhanced monitoring and automation.