Udemy - Mastering ClickHouse - High-Performance Analytics at Scale

Files:

• Get Bonus Downloads Here.url (0.2 KB)
~Get Your Files Here ! 1 - Introduction
• 1 -Introduction to ClickHouse.mp4 (21.6 MB)
• 2 -Why use ClickHouse over other Databases.mp4 (26.8 MB)
• 3 -Key Features and Benefits.mp4 (15.8 MB)
• 4 -Why ClickHouse is Fast.mp4 (22.9 MB)
10 - Joins and subqueries
• 1 -Inner Join.mp4 (37.6 MB)
• 2 -Left Join.mp4 (32.7 MB)
• 3 -Right Join.mp4 (29.5 MB)
• 4 -Inner Queries (sub-queries).mp4 (41.7 MB)
11 - Union & Intersect
• 1 -Union.mp4 (20.1 MB)
• 2 -Union All.mp4 (13.5 MB)
• 3 -Intersect.mp4 (17.7 MB)
12 - DML Operations
• 1 -Create and Insert into Tables.mp4 (19.1 MB)
• 2 -Insert into Tables Experiments.mp4 (23.5 MB)
• 3 -Update Records.mp4 (23.9 MB)
• 4 -Delete Records.mp4 (23.9 MB)
• 5 -Alter Table.mp4 (28.9 MB)
13 - Advanced SQL Features
• 1 -Views.mp4 (42.6 MB)
• 2 -CATS.mp4 (45.4 MB)
• 3 -Create Table using AWS S3 Parquet Files.mp4 (34.2 MB)
• 4 -Create Table using CSV File.mp4 (47.1 MB)
• 5 -Dynamic Column Selection.mp4 (27.8 MB)
• 6 -Backend Metadata and Data Folders.mp4 (39.5 MB)
14 - Common Table Expressions (CTEs)
• 1 -CTEs Select.mp4 (30.0 MB)
• 2 -CTEs Filters.mp4 (24.0 MB)
• 3 -CTEs Union All.mp4 (14.6 MB)
• 4 -CTEs Recursive Generate Numbers.mp4 (13.7 MB)
• 5 -CTEs Recursive Even Numbers.mp4 (8.1 MB)
• 6 -CTEs Recursive Fibonacci Number.mp4 (12.4 MB)
• 7 -CTEs Recursive Hierarchical.mp4 (39.6 MB)
15 - Arrays
• 1 -Introduction of Arrays.mp4 (52.3 MB)
• 2 -Aggregate Function With Arrays.mp4 (21.7 MB)
16 - MergeTree Family Tree Engines
• 1 -Types of Trees in Clickhouse.mp4 (23.4 MB)
• 10 -Collapsing Merge Tree Example.mp4 (29.8 MB)
• 11 -Versioned Collapsing Merge Tree.mp4 (23.2 MB)
• 12 -Versioned Collapsing Merge Tree Example.mp4 (29.4 MB)
• 13 -Data Skipping Index.mp4 (23.9 MB)
• 14 -Data Skipping Index Example.mp4 (20.6 MB)
• 15 -Choosing the Merge Tree Table Engine.mp4 (25.5 MB)
• 16 -When to choose ClickHouse and When NOT.mp4 (25.8 MB)
• 17 -File Table Engine Example.mp4 (24.3 MB)
• 18 -Set Table Engine.mp4 (21.0 MB)
• 19 -Memory Table Engine.mp4 (24.5 MB)
• 2 -Columnar storage advantages.mp4 (27.2 MB)
• 20 -URL Table Engine.mp4 (32.6 MB)
• 21 -Dictionaries.mp4 (25.9 MB)
• 22 -Log Engines.mp4 (18.0 MB)
• 3 -Aggregating Merge Tree.mp4 (24.3 MB)
• 4 -Aggregating Merge Tree Example.mp4 (55.1 MB)
• 5 -Summing Merge Tree.mp4 (23.4 MB)
• 6 -Summing Merge Tree Example.mp4 (39.0 MB)
• 7 -Replacing Merge Tree.mp4 (22.0 MB)
• 8 -Replacing Merge Tree Example.mp4 (31.7 MB)
• 9 -Collapsing Merge Tree.mp4 (22.6 MB)
17 - Clickhouse Cluster
• 1 -Cluster Introduction.mp4 (18.6 MB)
• 2 -Why Clustering.mp4 (16.5 MB)
• 3 -Key Components.mp4 (19.1 MB)
• 4 -Create Cluster 4 Machines.mp4 (36.8 MB)
• 5 -Cluster DBeaver Connection.mp4 (12.1 MB)
• 6 -Cluster Queries Create Tables.mp4 (22.9 MB)
• 7 -Users and Roles.mp4 (29.0 MB)
18 - Apache Superset Dashboard with ClickHouse
• 1 -Introduction to Apache Superset.mp4 (42.3 MB)
• 2 -What is Apache Superset.mp4 (39.4 MB)
• 3 -Key Features and Capabilities.mp4 (73.8 MB)
• 4 -Superset vs Other BI Tools.mp4 (94.2 MB)
• 5 -Installing Superset using Docker (Recommended).mp4 (39.8 MB)
• 6 -Installing Superset using Python.mp4 (40.2 MB)
• 7 -Understanding Superset Architecture.mp4 (38.1 MB)
• 8 -Navigating the Superset Interface.mp4 (20.7 MB)
2 - Installation and Setup
• 1 -Installation Mac OS.mp4 (21.6 MB)
• 2 -Installation DBeaver Mac OS.mp4 (14.6 MB)
• 3 -Installation with Docker.mp4 (20.0 MB)
• 4 -Clickhouse Native Local UI.mp4 (17.4 MB)
3 - Tables
• 1 - Course Materials.html (0.4 KB)
• 1 -Base Tables.mp4 (35.2 MB)
• 2 -Create & Drop Table.mp4 (15.5 MB)
Commands 1. Tables
• 1 Create Statement.sql (0.6 KB)
10. Advance SQL Function
• 1. Dynamic column selection.sql (0.1 KB)
• 2. CATS.sql (0.5 KB)
• 3. View.sql (0.2 KB)
11. Window Functions
• 1. Introduction And Row Number.sql (1.2 KB)
• 2. Rank & Dense Rank Functions.sql (1.7 KB)
• 3. Aggregates Functions.sql (1.1 KB)
• 4. Finding Duplicates.sql (0.8 KB)
12. CTEs
• 1. CTEs Select.sql (0.3 KB)
• 2. CTEs Filter.sql (0.6 KB)
• 3. CTEs Union All.sql (0.3 KB)
• 4. CTEs Recursive Generate Numbers.sql (0.1 KB)
• 5. CTEs Recursive Even Numbers.sql (0.2 KB)
• 6. CTEs Recursive Fibonacci Numbers.sql (0.2 KB)
• 7. CTEs recursive HIerarchical.sql (0.4 KB)
13. Arrays
• 1. Introduction of Arrays.sql (0.6 KB)
• 2. Aggregate Function With Arrays.sql (0.2 KB)
• 3. Filters With Arrays.sql (0.2 KB)
14. Create table
• 1.Create Database & Table.sql (0.2 KB)
• 2. Read Csv File.sql (0.4 KB)
• 3. Aggregate MergeTree.sql (0.3 KB)
15. S3 File
• 1. Reading S3 F