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
Testimonials (5)
I like that Kamil adjusted the materail for me and my understand. He really wanted to make sure I understood.
Austin Robertson
Course - MongoDB for Administrators
Learning about indexes with examples, configuring replicaSet with sharding and showing what it looks like underneath. It was also nice to play with aggregations and talk about change streams. Finally I also know what this Oplog is about,
Łukasz - G2A.COM Limited
Course - MongoDB for Developers
Machine Translated
The situation was atypical because an intensive training for developers was to be conducted with non-developers. Lukasz took up this challenge with empathy and a lot of humour. Through his intelligent and flexible manner, he was able to ensure that a concrete learning gain was achieved for everyone. I enjoyed this very much and would gladly take a seminar with Lukasz again.
Christoph - Honda Bank GmbH
Course - MERN Fullstack Development
Los ejemplos claros que presentó el instructor
José Ernesto Cruz Pineda - Datavision digital
Course - SAP ASE for Database Administrators
Tamil was excellent at explaining even the difficult topics in a way that I understood them straight away. The presentation and delivery were both clear and methodical, and the teacher passionate about the subject.