Course Outline


  • 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


Summary and Next Steps


  • An understanding of relational databases
  • Experience with SQL


  • Developers
  • IT professionals
  14 Hours

Related Courses

Data Management

  35 hours

Pivotal Greenplum for Developers

  21 hours

MarkLogic Server

  14 hours

SAP ASE for Database Administrators

  28 hours

Access Intermediate

  14 hours

Access VBA

  21 hours

Access Advanced

  21 hours

Microsoft Access - download the data

  14 hours

Access - Data Base Designing

  21 hours

SQL in Microsoft Access

  14 hours

VBA For Access & Excel

  21 hours

FARM (FastAPI, React, and MongoDB) Full Stack Development

  14 hours

MERN Fullstack Development

  14 hours

MongoDB for Analysts

  14 hours

MongoDB for Administrators

  14 hours