Altinity Quickstart for ClickHouse® | Build Your First App | Training for ClickHouse®

Have questions about ClickHouse®? Get a free consultation with Altinity. Book a call here: https://hubs.la/Q02qr1RZ0 . No marketing BS. no sales talk during the call. Just answers to your questions.

______________________________


About to build your first analytic app on ClickHouse?

Altinity Quickstart for #ClickHouse is for you. The webinar focuses on key skills to build an MVP that shows off the power of ClickHouse: defining tables, loading real data from sources, selecting data out again, and tweaking performance.

Learn more about Altinity Quickstart for ClickHouse: https://altinity.com/events/clickhous...
Want the webinar slides? 👉🏼 https://www.slideshare.net/Altinity/a...

0:00 Introduction
3:56 What ClickHouse Is Not
5:05 ClickHouse stores data in columns
5:45 Data compression
8:09 Install ClickHouse from a build repo
10:10 Install ClickHouse using Docker
12:02 Connecting from the command line
13:23 Connecting to built-in web UI
14:19 Databases and tables
15:27 Handy commands for navigation
21:28 Use input formats to load raw data
26:12 How to update and delete rows
27:48 What happens when you INSERT?
35:29 Time dimensions in queries SELECT
37:56 Drilling into GROUP BY syntax
38:40 Another example
41:57 Process a query with a JOIN
44:07 3 tips for querying data in ClickHouse
47:56 What's going on in MergeTree?
49:34 Optimal table design
52:31 Codecs reduce data
53:39 How to add codecs
54:19 Effect of codec and compression changes
56:56 ClickHouse documentation

#ClickHouseTraining #ClickHouseForBeginners #OpenSourceDatabase #ClickHouseCommunity #ClickHouseTutorial
--------------
Join Altinity Meetups on ClickHouse: https://www.meetup.com/san-francisco-...
Check out more resources on ClickHouse: https://altinity.com/resources/
Visit the Altinity Documentation site: https://docs.altinity.com/
Contribute to Altinity Knowledge Base for ClickHouse: https://kb.altinity.com/
Join the Reddit community for ClickHouse:   / clickhouse  
-------------
More about Altinity! 💡
Site: https://www.altinity.com​
LinkedIn:   / altinity  
Twitter:   / altinitydb  
Slack: https://altinity.com/slack