ClickHouse Fundamentals Certificate for Leandro Sandmann
Add to LinkedIn
Certificate ID:
722091
Authentication Code:
fa6e4
Certified Person Name:
Leandro Sandmann
Trainer Name:
André Pretto
Duration Days:
2
Duration Hours:
14
Course Name:
ClickHouse Fundamentals
Course Date:
6 June 2023 12:00 to 7 June 2023 19:00
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