ClickHouse crash course. Conquer big data with ease

Learn how to use one of the most powerful open source OLAP database on the market. Put new life in your big data.
Free tutorial
Rating: 4.2 out of 5 (199 ratings)
5,709 students
English
ClickHouse Installation
ClickHouse Best Practices
ClickHouse Main Features
Column Oriented Databases Pros and Cons

Requirements

  • Basic Knowledge of SQL
  • Basic Knowledge of Docker
  • Basic Knowledge of Bash

Description

Has your data grown too much?

Do you have to wait forever to get even simple answers from your system?

Do you just want to explore your data in real time while it’s actually relevant and not 30 minutes later when nobody cares anymore?

Do you want your dev team to work on features and not on the infrastructure?


Then you’ve come to the right place. ClickHouse is a new technology that addresses all of the pain points above.


ClickHouse was designed to be very, very fast. And it is.


What is more, it’s extremely rigid, and it fails only in extreme circumstances.

Put ease of installation and maintenance on top, and you get nearly ideal solution for most OLAP use cases.


How can I help?

Together we’ll explore main functionality of ClickHouse, and we will develop tools and skills to incorporate and manage this database in existing and future systems.


We are going to have lots of fun along the way, because technology should be fun, and with the tools like ClickHouse it is.


Some of the topics we’ll cover:

  • ClickHouse Installation

  • External dictionaries

  • Arrays

  • Sampling

  • Aggregation

  • Cluster Configuration


You'll find lots of code snippets and supplementary material inside the course to help you master even the hardest topics.


At the end of the course, you’ll be able to confidently use ClickHouse in production.

You’ll get familiar with the main features and quirks of the database, as well as some edge cases you might encounter


Is it for me?

If you are an IT pro with specific OLAP needs, or just a DEVOPs looking for a new great technology, then my answer is yes.

All you need is basic knowledge of SQL and Docker

ClickHouse will make the rest a breeze.


Can't wait to see you inside!

Who this course is for:

  • Entry and mid-level IT pros searching for great OLAP solution
  • System architects seeking scalable big data solution

Course content

5 sections11 lectures1h 7m total length
  • CH and Column Oriented DBs overview
    02:50

Instructor

Software Developer and Fitness Geek
Viktor Dashkov
  • 4.2 Instructor Rating
  • 199 Reviews
  • 5,707 Students
  • 1 Course

I'm doing hackathons, marathons, and cool tech presentations when I'm not working as a software developer.


I have to deal with big data on a daily basis, and I am very fortunate to work with incredible people who found some amazing solutions to the problems common in the world of big data


I can't wait to share some of the secrets with you.