Course Outline

Introduction

  • ClickHouse vs MySQL vs Oracle
  • Overview of ClickHouse features and architecture

Understanding Column-Oriented Databases

Getting Started

  • Setting up the environment
  • Installing ClickHouse
  • Connecting to the database

Managing Users and Roles

  • Role-Based Access Control (RBAC)
  • XML vs SQL configuration
  • Users, roles, and privileges

Working with the ClickHouse Database

  • SQL syntax, functions, and operators
  • Creating and modifying tables
  • Loading data
  • Creating a schema
  • Running analytic queries
  • Using views, indexes, and arrays

Administering the ClickHouse Database

  • Replication and sharding
  • Resource utilization
  • Backing up and restoring data
  • Optimizing performance

Integrating ClickHouse with External Systems

  • ODBC and JDBC
  • HDFS, Amazon S3, and EmbeddedRocksDB
  • MySQL, PostgreSQL, SQLite, and Hive
  • MongoDB and RabbitMQ
  • Apache Kafka

Troubleshooting

Summary and Next Steps

Requirements

  • An understanding of relational databases
  • Experience with SQL

Audience

  • Developers
  • IT professionals
  14 Hours
 

Number of participants


Starts

Ends


Dates are subject to availability and take place between 09:30 and 16:30.
Open Training Courses require 5+ participants.

Testimonials (4)

Related Courses

Related Categories