Learn ClickHouse - A Fast Open-Source OLAP DBMS Год выпуска: 2024 Производитель: Udemy Сайт производителя: https://www.udemy.com/course/learn-clickhouse/ Автор: Vijay Anand Ramakrishnan Продолжительность: ~5h13m Тип раздаваемого материала: Видеоурок Язык: Английский Описание: Learn ClickHouse®, the fastest and the most powerful database that can easily handle Petabytes of data! ClickHouse is an Open-Source columnar data store developed by ClickHouse Inc. Some of the highlights of this course are All lectures have been designed from the ground up to make the complex topics easy to understand 300+ SQL examples demonstrated in the video lectures Precise and informative video lectures 200 + Quiz questions and counting Assignments Covers a wide range of topics in ClickHouse After completing this course, you will be able to Install and work with ClickHouse Query the data using ClickHouse SQL Understand the internals of the MergeTree family of table engines and variants of this engine Know the different special engines and Integrations with external data sources Learn about Data replication and Sharding in ClickHouse Administer and manage a ClickHouse server This course will provide you with solid practical Skills in ClickHouse and it can be used as learning material for the ClickHouse® certifications. The instructor is an experienced ClickHouse professional and has authored a book on ClickHouse and conducted multiple live training sessions in ClickHouse.
Содержание
00:38 05:38 06:16 06:25 ClickHouse in a Docker environment 03:11 Connecting to a ClickHouse Server 03:40 ClickHouse in Kubernetes (Optional) 08:43 DBeaver (Optional) 03:04 Loading an Example dataset (Optional) 02:52 Conclusion 01:02 Introduction to ClickHouse 12 вопросов 03:27 ClickHouse SQL 4 вопросов ClickHouse SQL - Data Definition Language 03:38 ClickHouse SQL - Data Query Language 02:56 DQL 3 вопросов ClickHouse SQL - Data Manipulation Language 04:32 DML 5 вопросов ClickHouse SQL - Data Definition Language - Part 2 03:15 DDL 4 вопросов ClickHouse SQL - Working with Views 04:46 ClickHouse Views 3 вопросов ClickHouse SQL - Joins and Unions 05:26 Joins and Unions 4 вопросов ClickHouse SQL - Introduction 00:12 Operators 03:48 ClickHouse Operators 2 вопросов ClickHouse Data Types 01:22 Numeric Data Types 04:41 Numeric Data types 3 вопросов String Data Types 02:47 String Data types 3 вопросов Date and Datetime 03:18 Date/DateTime 4 вопросов Arrays and Tuples 02:56 Arrays and Tuples 3 вопросов Nested Data Type 02:17 Nested Data Type 2 вопросов Data Types for Low Cardinal Data 04:26 Enumerated and LowCardinality data types 3 вопросов Geo Data Types 03:02 Geo Data Types 3 вопросов Map Data Type 01:46 Map data type 2 вопросов Exercise - Data Types 04:40 ClickHouse SQL 7 вопросов Introduction 00:29 Introduction 01:33 Why it is called MergeTree? 03:29 Data Part Merges in MergeTree 03:24 Data Directory of a MergeTree table 03:31 Primary Index file 01:52 Column (Bin) Files 04:31 Mark Files 05:54 Primary Key and ORDER BY key 02:36 Syntax for Creating a MergeTree table and settings 06:08 Creating a MergeTree table with Partitions 03:33 Operations on Partitions 06:59 MergeTree Engine 15 вопросов MergeTree Family of Table Engines 00:14 Introduction 01:01 ReplacingMergeTree 08:22 ReplacingMergeTree Engine 6 вопросов SummingMergeTree 04:27 SummingMergeTree 3 вопросов AggregatingMergeTree 06:22 AggregatingMergeTree 4 вопросов CollapsingMergeTree 07:03 CollapsingMergeTree 5 вопросов VersionedCollapsingMergeTree 03:22 VersionedCollapsingMergeTree 4 вопросов Data Skipping Index 11:11 Data Skipping Index 8 вопросов Choosing the MergeTree Table Engine 03:08 MergeTree Family of Engines 5 вопросов Special and Log Table Engines in ClickHouse 00:19 Introduction 00:56 File Table Engine 02:57 File Engine 3 вопросов Merge Table Engine 02:50 Merge Table Engine 3 вопросов Set Table Engine 02:31 Set Engine 3 вопросов Memory Table Engine 02:29 Memory Engine 2 вопросов Buffer Table Engine 03:42 Buffer Engine 3 вопросов GenerateRandom Table Engine 02:12 GenerateRandom Engine 2 вопросов URL Table Engine 02:18 URL Engine 4 вопросов Dictionaries 06:20 Log Engines 05:42 Log Family 3 вопросов TinyLog Engine 2 вопросов Log Engine 2 вопросов StripeLog Engine 2 вопросов Multi-node ClickHouse Setup 00:15 Introduction 01:10 Data Replication in ClickHouse 11:20 Data Replication in ClickHouse 6 вопросов Data Sharding with Distributed Table Engine 10:44 Sharding 6 вопросов Replicating the Sharded data 06:16 External Data sources 00:12 Introduction 00:44 MySQL 02:31 Integrating with MySQL 3 вопросов PostgreSQL 02:34 PostgreSQL table engine 2 вопросов MongoDB 02:16 MongoDB table engine 5 вопросов Apache Kafka 05:52 Apache Kafka table engine 5 вопросов Role Based Access Control 04:16 User Management 04:28 ClickHouse User Management 5 вопросов Roles 03:17 ClickHouse User Roles 4 вопросов Settings Profile 02:17 ClickHouse Settings Profile 3 вопросов Quotas 02:21 ClickHouse Quotas 3 вопросов RBAC Example 06:32 Configuring and Administering a ClickHouse server 00:15 Configuring the ClickHouse Server 02:54 System Tables 08:46 System tables 3 вопросов ClickHouse Backups 05:36 Backups in ClickHouse 5 вопросов clickhouse-local 02:00 clickhouse-local 2 вопросов clickhouse-benchmark 02:01 clickhouse-benchmark 2 вопросов Congratulations 01:56
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You can download files in this forum
![[Quote]](./templates/default/images/lang/en/icon_quote.gif "Reply with quote"){kind=icon}
![[Profile]](./templates/default/images/lang/en/icon_profile.gif "View user's profile"){kind=icon}
![[PM]](./templates/default/images/lang/en/icon_pm.gif "Send private message"){kind=icon}
