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: 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: altinity.com/events/clickhous...
Want the webinar slides? 👉🏼 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: www.meetup.com/san-francisco-...
Check out more resources on ClickHouse: altinity.com/resources/
Visit the Altinity Documentation site: docs.altinity.com/
Contribute to Altinity Knowledge Base for ClickHouse: kb.altinity.com/
Join the Reddit community for ClickHouse: / clickhouse
-------------
More about Altinity! 💡
Site: www.altinity.com​
LinkedIn: / altinity
Twitter: / altinitydb
Slack: altinity.com/slack

[@Altinity]

Want to be the smartest ClickHouse developer in the room? Then sign up to our newsletter to get ClickHouse tips and tricks straight to your inbox.
Sign up here: hubs.ly/Q02pp8vh0

[@mayankjha5307]

Nice presentation, but a bit abstract. It would help if you would have included snapshots of results for each of the queries, especially for the ClickHouse specific stuff like any()

[@lassejacobs3270]

Useful video, thank you for putting this together.

[@Algoritmik]

Great video. Any chance to have slides?

[@Altinity]

We are thrilled to hear your feedback! We just made the slides available on our website here: altinity.com/presentations/altinity-quickstart-for-clickhouse-build-your-first-app-2. Please let us know if we can help you with anything else :0