What will you learn in our course?

• How to set-up a local database to develop

• Connect a JDBC Client

• Administrate
  • Start/Stop
  • Backup///Restore
  • Monitoring
  • Add//remove nodes
  • Move partitions
  • Disaster Recovery

• Security
  • User Management
  • Encryption
    • In-transit
    • At-rest

• 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

• Troubleshooting
  • Running out of memory (where)
  • Running out of disk space (where)
  • Inefficient writes (refer how to write efficiently):
    • Collocation of client application with database manager (same datacenter).
    • Connecting/disconnecting continuously (per query or transaction).
    • Non prepared statements.
    • Non batching for loading
    • Single threaded application.
  • Slow queries (refer how to read efficiently)
    • Slow access to large tables (database stats not run after loading or massive updates or update across long time).
    • Increasingly slower historic table access (bidimensional partitioning).
    • Only one kvds is used (no partitioned table)
    • Some kvds are more used than others (not even partitioning across kdvs)
    • Full scan (lack of index)
    • Expensive recurrent analytical aggregate queries (online aggregates).
    • Covered indexes
    • Global indexes
  • Problems with transactionality

• What is better with LeanXcale
  • Insertion for large datasets
  • Aggregation
  • Scalability
  • HA

Skilled, experienced, and highly motivated Business Developer with an outstanding product development experience 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.

Unlock new career oportunities!