This tutorial aims to introduce beginners to the topic of relational and non-relational databases and SQL in the context of data analytics using ClickHouse, a fast open-source OLAP DBMS.


❶ What Are Databases?

❷ Intro To SQL Syntax

❸ Table Relationships & Joins

❹ Aggregation, Subqueries, Windows

❺ Creating Tables & Inserting Data

❻ Very Briefly: Integration, Optimization, Configuration

ClickHouse Tutorial Series

clickhouse-mark-4238843745.png

many-to-many.png

one-to-many.png

menu_desc.png

one-to-one.png

截屏2023-02-10 下午1.04.18

answers2@2.db

cartesian_product.png

client

query1

data

s8s1e1

s8s2e1

s8s3e1