LeanXcale development course

Enhance your SQL Database Skills and and Boost Your Career

Refresh basic knowledge and learn best practices when working with relational databases; discover what's new in LeanXcale, and learn how to develop and administer this database.

JOIN TO THE NEXT COURSES

To make it easier for you to find availability, we offer our courses on different dates and times. Below you can see the upcoming courses and join the one that fits you best!

LeanXcale for Developers

We offer our LeanXcale course on different dates, so if you can't attend the next one, keep an eye out for the next dates!

What will you learn in our course?

How to set-up a local database to develop
Connect a JDBC Client
Database objects intro
- Database
- Schema
- Table
- Index
- Online aggregates
- Trigger & Table functions
- Statistics
- System Tables
Create a CRUD
- Java
- Python
- .Net
How to deal with transactions: Isolation levels
How to insert data efficiently
- How-to-start
- Latency
- Prepared Statement
- Batching
- Parallelism
- Distribution
- Partitioning
- Upserts
- Troubleshooting Poorly Performing Insertion
- Updates and old versions
How to read data optimally
- Distribution
- Partitioning
- Primary Indexes
- Secondary indexes
- Covered indexes
- Memory tables
- On-line aggregates
- Statistics and Sampling
- Troubleshooting Poorly Performing Queries
What is better with LeanXcale
- Insertion for large datasets
- Aggregation
- Scalability
- HA

LUIS MELGAREJO | LEANXCALE training manager & BUSINESS DEVELOPMENT

Skilled, experienced, and highly motivated Business Developer with an outstanding sales experience and product development for Financial Services. Bringing +30 years of experience in several challenging markets and product verticals like Trading, FX, Cards, Domestic and Cross-border payments, most recently helping banks with their ISO 20022 adoption journey.