|
|
1 - Course Materials.html
|
HTML
|
409.6 B
|
|
|
1 -Base Tables.mp4
|
MP4
|
35.2 MB
|
|
|
1 -CTEs Select.mp4
|
MP4
|
30 MB
|
|
|
1 -Cluster Introduction.mp4
|
MP4
|
18.6 MB
|
|
|
1 -Coalesce.mp4
|
MP4
|
33.5 MB
|
|
|
1 -Create and Insert into Tables.mp4
|
MP4
|
19.1 MB
|
|
|
1 -Group By.mp4
|
MP4
|
31.5 MB
|
|
|
1 -Inner Join.mp4
|
MP4
|
37.6 MB
|
|
|
1 -Installation Mac OS.mp4
|
MP4
|
21.6 MB
|
|
|
1 -Intergers.mp4
|
MP4
|
38.3 MB
|
|
|
1 -Introduction of Arrays.mp4
|
MP4
|
52.3 MB
|
|
|
1 -Introduction to Apache Superset.mp4
|
MP4
|
42.3 MB
|
|
|
1 -Introduction to ClickHouse.mp4
|
MP4
|
21.6 MB
|
|
|
1 -Introduction.mp4
|
MP4
|
26.6 MB
|
|
|
1 -Select Queries.mp4
|
MP4
|
24.2 MB
|
|
|
1 -Sorting.mp4
|
MP4
|
49.7 MB
|
|
|
1 -Types of Trees in Clickhouse.mp4
|
MP4
|
23.4 MB
|
|
|
1 -Union.mp4
|
MP4
|
20.1 MB
|
|
|
1 -Views.mp4
|
MP4
|
42.6 MB
|
|
|
1 Create Statement.sql
|
SQL
|
614.4 B
|
|
|
1. Between.sql
|
SQL
|
204.8 B
|
|
|
1. CTEs Select.sql
|
SQL
|
307.2 B
|
|
|
1. Coalesce.sql
|
SQL
|
204.8 B
|
|
|
1. Create And Drop.sql
|
SQL
|
102.4 B
|
|
|
1. Dynamic column selection.sql
|
SQL
|
102.4 B
|
|
|
1. Group By.sql
|
SQL
|
307.2 B
|
|
|
1. Inner join.sql
|
SQL
|
409.6 B
|
|
|
1. Introduction And Row Number.sql
|
SQL
|
1.2 KB
|
|
|
1. Introduction of Arrays.sql
|
SQL
|
614.4 B
|
|
|
1. Reading S3 File.sql
|
SQL
|
716.8 B
|
|
|
1. Select in Clickhouse.sql
|
SQL
|
102.4 B
|
|
|
1. Sorting.sql
|
SQL
|
204.8 B
|
|
|
1. Union.sql
|
SQL
|
204.8 B
|
|
|
1.Create Database & Table.sql
|
SQL
|
204.8 B
|
|
|
10 -Collapsing Merge Tree Example.mp4
|
MP4
|
29.8 MB
|
|
|
11 -Versioned Collapsing Merge Tree.mp4
|
MP4
|
23.2 MB
|
|
|
12 -Versioned Collapsing Merge Tree Example.mp4
|
MP4
|
29.4 MB
|
|
|
13 -Data Skipping Index.mp4
|
MP4
|
23.9 MB
|
|
|
14 -Data Skipping Index Example.mp4
|
MP4
|
20.6 MB
|
|
|
15 -Choosing the Merge Tree Table Engine.mp4
|
MP4
|
25.5 MB
|
|
|
16 -When to choose ClickHouse and When NOT.mp4
|
MP4
|
25.8 MB
|
|
|
17 -File Table Engine Example.mp4
|
MP4
|
24.3 MB
|
|
|
18 -Set Table Engine.mp4
|
MP4
|
21 MB
|
|
|
19 -Memory Table Engine.mp4
|
MP4
|
24.5 MB
|
|
|
2 -Aggregate Function With Arrays.mp4
|
MP4
|
21.7 MB
|
|
|
2 -CATS.mp4
|
MP4
|
45.4 MB
|
|
|
2 -CTEs Filters.mp4
|
MP4
|
24 MB
|
|
|
2 -Columnar storage advantages.mp4
|
MP4
|
27.2 MB
|
|
|
2 -Create & Drop Table.mp4
|
MP4
|
15.5 MB
|
|
|
2 -Group By with Having.mp4
|
MP4
|
37.2 MB
|
|
|
2 -Insert into Tables Experiments.mp4
|
MP4
|
23.5 MB
|
|
|
2 -Installation DBeaver Mac OS.mp4
|
MP4
|
14.6 MB
|
|
|
2 -Left Join.mp4
|
MP4
|
32.7 MB
|
|
|
2 -Limit.mp4
|
MP4
|
17.9 MB
|
|
|
2 -Null IF.mp4
|
MP4
|
27.2 MB
|
|
|
2 -String Functions.mp4
|
MP4
|
22.9 MB
|
|
|
2 -Strings.mp4
|
MP4
|
28.9 MB
|
|
|
2 -Union All.mp4
|
MP4
|
13.5 MB
|
|
|
2 -What is Apache Superset.mp4
|
MP4
|
39.4 MB
|
|
|
2 -Why Clustering.mp4
|
MP4
|
16.5 MB
|
|
|
2 -Why it is called Merge Tree.mp4
|
MP4
|
28.7 MB
|
|
|
2 -Why use ClickHouse over other Databases.mp4
|
MP4
|
26.8 MB
|
|
|
2. Aggregate Function With Arrays.sql
|
SQL
|
204.8 B
|
|
|
2. CATS.sql
|
SQL
|
512 B
|
|
|
2. CTEs Filter.sql
|
SQL
|
614.4 B
|
|
|
2. Create and Insert.sql
|
SQL
|
307.2 B
|
|
|
2. Group By With Having.sql
|
SQL
|
409.6 B
|
|
|
2. In.sql
|
SQL
|
204.8 B
|
|
|
2. Left Join.sql
|
SQL
|
307.2 B
|
|
|
2. Nullif.sql
|
SQL
|
307.2 B
|
|
|
2. Rank & Dense Rank Functions.sql
|
SQL
|
1.7 KB
|
|
|
2. Read Csv File.sql
|
SQL
|
409.6 B
|
|
|
2. String Function.sql
|
SQL
|
204.8 B
|
|
|
2. Union All.sql
|
SQL
|
204.8 B
|
|
|
20 -URL Table Engine.mp4
|
MP4
|
32.6 MB
|
|
|
21 -Dictionaries.mp4
|
MP4
|
25.9 MB
|
|
|
22 -Log Engines.mp4
|
MP4
|
18 MB
|
|
|
3 -Aggregating Merge Tree.mp4
|
MP4
|
24.3 MB
|
|
|
3 -Booleans.mp4
|
MP4
|
38.8 MB
|
|
|
3 -CTEs Union All.mp4
|
MP4
|
14.6 MB
|
|
|
3 -Create Table using AWS S3 Parquet Files.mp4
|
MP4
|
34.2 MB
|
|
|
3 -Default Values.mp4
|
MP4
|
22.2 MB
|
|
|
3 -Distinct.mp4
|
MP4
|
20.4 MB
|
|
|
3 -Group By with Where Clause.mp4
|
MP4
|
16.4 MB
|
|
|
3 -Installation with Docker.mp4
|
MP4
|
20 MB
|
|
|
3 -Intersect.mp4
|
MP4
|
17.7 MB
|
|
|
3 -Key Components.mp4
|
MP4
|
19.1 MB
|
|
|
3 -Key Features and Benefits.mp4
|
MP4
|
15.8 MB
|
|
|
3 -Key Features and Capabilities.mp4
|
MP4
|
73.8 MB
|
|
|
3 -Primary Index file.mp4
|
MP4
|
24 MB
|
|
|
3 -Right Join.mp4
|
MP4
|
29.5 MB
|
|
|
3 -Update Records.mp4
|
MP4
|
23.9 MB
|
|
|
3. Aggregate MergeTree.sql
|
SQL
|
307.2 B
|
|
|
3. Aggregates Functions.sql
|
SQL
|
1.1 KB
|
|
|
3. CTEs Union All.sql
|
SQL
|
307.2 B
|
|
|
3. Default values.sql
|
SQL
|
409.6 B
|
|
|
3. Distinct.sql
|
SQL
|
204.8 B
|
|
|
3. Filters With Arrays.sql
|
SQL
|
204.8 B
|
|
|
3. Group by & Where Clause.sql
|
SQL
|
409.6 B
|
|
|
3. Intersect.sql
|
SQL
|
204.8 B
|
|
|
3. Like.sql
|
SQL
|
204.8 B
|
|
|
3. Right Join.sql
|
SQL
|
307.2 B
|
|
|
3. Update.sql
|
SQL
|
204.8 B
|
|
|
3. View.sql
|
SQL
|
204.8 B
|
|
|
4 -Aggregate Functions.mp4
|
MP4
|
17.8 MB
|
|
|
4 -Aggregating Merge Tree Example.mp4
|
MP4
|
55.1 MB
|
|
|
4 -Between.mp4
|
MP4
|
14.5 MB
|
|
|
4 -CTEs Recursive Generate Numbers.mp4
|
MP4
|
13.7 MB
|
|
|
4 -Clickhouse Native Local UI.mp4
|
MP4
|
17.4 MB
|
|
|
4 -Column (Bin) Files.mp4
|
MP4
|
24.2 MB
|
|
|
4 -Create Cluster 4 Machines.mp4
|
MP4
|
36.8 MB
|
|
|
4 -Create Table using CSV File.mp4
|
MP4
|
47.1 MB
|
|
|
4 -Delete Records.mp4
|
MP4
|
23.9 MB
|
|
|
4 -Inner Queries (sub-queries).mp4
|
MP4
|
41.7 MB
|
|
|
4 -Superset vs Other BI Tools.mp4
|
MP4
|
94.2 MB
|
|
|
4 -Why ClickHouse is Fast.mp4
|
MP4
|
22.9 MB
|
|
|
4. Aggregates Function.sql
|
SQL
|
204.8 B
|
|
|
4. CTEs Recursive Generate Numbers.sql
|
SQL
|
102.4 B
|
|
|
4. Delete.sql
|
SQL
|
102.4 B
|
|
|
4. Finding Duplicates.sql
|
SQL
|
819.2 B
|
|
|
4. Nulls Clause.sql
|
SQL
|
614.4 B
|
|
|
4. Subqueries.sql
|
SQL
|
409.6 B
|
|
|
5 -Alias.mp4
|
MP4
|
34 MB
|
|
|
5 -Alter Table.mp4
|
MP4
|
28.9 MB
|
|
|
5 -CTEs Recursive Even Numbers.mp4
|
MP4
|
8.1 MB
|
|
|
5 -Cluster DBeaver Connection.mp4
|
MP4
|
12.1 MB
|
|
|
5 -Dates.mp4
|
MP4
|
43.9 MB
|
|
|
5 -Dynamic Column Selection.mp4
|
MP4
|
27.8 MB
|
|
|
5 -Installing Superset using Docker (Recommended).mp4
|
MP4
|
39.8 MB
|
|
|
5 -Mark Files.mp4
|
MP4
|
20.5 MB
|
|
|
5 -Summing Merge Tree.mp4
|
MP4
|
23.4 MB
|
|
|
5. Alias.sql
|
SQL
|
307.2 B
|
|
|
5. Alter.sql
|
SQL
|
409.6 B
|
|
|
5. CTEs Recursive Even Numbers.sql
|
SQL
|
204.8 B
|
|
|
5. Limit.sql
|
SQL
|
102.4 B
|
|
|
6 -Backend Metadata and Data Folders.mp4
|
MP4
|
39.5 MB
|
|
|
6 -CTEs Recursive Fibonacci Number.mp4
|
MP4
|
12.4 MB
|
|
|
6 -Cluster Queries Create Tables.mp4
|
MP4
|
22.9 MB
|
|
|
6 -Concat.mp4
|
MP4
|
26.4 MB
|
|
|
6 -Creating a Merge Tree table with Partitions.mp4
|
MP4
|
21 MB
|
|
|
6 -IN Examples.mp4
|
MP4
|
17 MB
|
|
|
6 -Installing Superset using Python.mp4
|
MP4
|
40.2 MB
|
|
|
6 -Summing Merge Tree Example.mp4
|
MP4
|
39 MB
|
|
|
6. CTEs Recursive Fibonacci Numbers.sql
|
SQL
|
204.8 B
|
|
|
6. Concat.sql
|
SQL
|
204.8 B
|
|
|
6. Insert With Single quote.sql
|
SQL
|
307.2 B
|
|
|
6. Integer.sql
|
SQL
|
102.4 B
|
|
|
7 -CTEs Recursive Hierarchical.mp4
|
MP4
|
39.6 MB
|
|
|
7 -Like.mp4
|
MP4
|
26.9 MB
|
|
|
7 -Replacing Merge Tree.mp4
|
MP4
|
22 MB
|
|
|
7 -Understanding Superset Architecture.mp4
|
MP4
|
38.1 MB
|
|
|
7 -Users and Roles.mp4
|
MP4
|
29 MB
|
|
|
7. CTEs recursive HIerarchical.sql
|
SQL
|
409.6 B
|
|
|
7. String.sql
|
SQL
|
204.8 B
|
|
|
8 -Navigating the Superset Interface.mp4
|
MP4
|
20.7 MB
|
|
|
8 -Replacing Merge Tree Example.mp4
|
MP4
|
31.7 MB
|
|
|
8. Boolean.sql
|
SQL
|
102.4 B
|
|
|
9 -Collapsing Merge Tree.mp4
|
MP4
|
22.6 MB
|
|
|
9. Date.sql
|
SQL
|
204.8 B
|
|
|
Aggregating Merge Tree.sql
|
SQL
|
1.2 KB
|
|
|
Bonus Resources.txt
|
TXT
|
102.4 B
|
|
|
Cluster Sql Commands.txt
|
TXT
|
409.6 B
|
|
|
Collapsing Merge Tree.sql
|
SQL
|
512 B
|
|
|
DS_Store
|
|
12 KB
|
|
|
Data Skipping Index.sql
|
SQL
|
716.8 B
|
|
|
Dictionaries.sql
|
SQL
|
716.8 B
|
|
|
Docker Commands.txt
|
TXT
|
1.1 KB
|
|
|
File Table Engine.sql
|
SQL
|
307.2 B
|
|
|
Get Bonus Downloads Here.url
|
URL
|
204.8 B
|
|
|
Log Table.sql
|
SQL
|
307.2 B
|
|
|
Memory.sql
|
SQL
|
409.6 B
|
|
|
Replacing Merge Tree.sql
|
SQL
|
512 B
|
|
|
Set Table.sql
|
SQL
|
512 B
|
|
|
URL Table Engine.sql
|
SQL
|
614.4 B
|
|
|
User and Roles.txt
|
TXT
|
409.6 B
|
|
|
Versioned Collapsing Merge Tree.sql
|
SQL
|
512 B
|
|
|
_.DS_Store
|
DS_STORE
|
204.8 B
|
|
|
_1 Create Statement.sql
|
SQL
|
307.2 B
|
|
|
_1. Between.sql
|
SQL
|
204.8 B
|
|
|
_1. CTEs Select.sql
|
SQL
|
204.8 B
|
|
|
_1. Coalesce.sql
|
SQL
|
204.8 B
|
|
|
_1. Create And Drop.sql
|
SQL
|
204.8 B
|
|
|
_1. Dynamic column selection.sql
|
SQL
|
204.8 B
|
|
|
_1. Group By.sql
|
SQL
|
204.8 B
|
|
|
_1. Inner join.sql
|
SQL
|
204.8 B
|
|
|
_1. Introduction And Row Number.sql
|
SQL
|
204.8 B
|
|
|
_1. Introduction of Arrays.sql
|
SQL
|
307.2 B
|
|
|
_1. Reading S3 File.sql
|
SQL
|
204.8 B
|
|
|
_1. Select in Clickhouse.sql
|
SQL
|
204.8 B
|
|
|
_1. Sorting.sql
|
SQL
|
204.8 B
|
|
|
_1. Tables
|
TABLES
|
204.8 B
|
|
|
_1. Union.sql
|
SQL
|
204.8 B
|
|
|
_1.Create Database & Table.sql
|
SQL
|
204.8 B
|
|
|
_10. Advance SQL Function
|
ADVANCE SQL FUNCTION
|
204.8 B
|
|
|
_11. Window Functions
|
WINDOW FUNCTIONS
|
204.8 B
|
|
|
_12. CTEs
|
CTES
|
204.8 B
|
|
|
_13. Arrays
|
ARRAYS
|
204.8 B
|
|
|
_14. Create table
|
CREATE TABLE
|
204.8 B
|
|
|
_15. S3 File
|
S3 FILE
|
204.8 B
|
|
|
_2. Aggregate Function With Arrays.sql
|
SQL
|
204.8 B
|
|
|
_2. CATS.sql
|
SQL
|
204.8 B
|
|
|
_2. CTEs Filter.sql
|
SQL
|
204.8 B
|
|
|
_2. Create and Insert.sql
|
SQL
|
204.8 B
|
|
|
_2. Group By With Having.sql
|
SQL
|
204.8 B
|
|
|
_2. In.sql
|
SQL
|
204.8 B
|
|
|
_2. Left Join.sql
|
SQL
|
204.8 B
|
|
|
_2. Nullif.sql
|
SQL
|
204.8 B
|
|
|
_2. Rank & Dense Rank Functions.sql
|
SQL
|
204.8 B
|
|
|
_2. Read Csv File.sql
|
SQL
|
204.8 B
|
|
|
_2. SQL Fundamentals
|
SQL FUNDAMENTALS
|
204.8 B
|
|
|
_2. String Function.sql
|
SQL
|
204.8 B
|
|
|
_2. Union All.sql
|
SQL
|
204.8 B
|
|
|
_3. Aggregate MergeTree.sql
|
SQL
|
204.8 B
|
|
|
_3. Aggregates Functions.sql
|
SQL
|
204.8 B
|
|
|
_3. CTEs Union All.sql
|
SQL
|
204.8 B
|
|
|
_3. Default values.sql
|
SQL
|
204.8 B
|
|
|
_3. Distinct.sql
|
SQL
|
204.8 B
|
|
|
_3. Filters
|
FILTERS
|
204.8 B
|
|
|
_3. Filters With Arrays.sql
|
SQL
|
307.2 B
|
|
|
_3. Group by & Where Clause.sql
|
SQL
|
204.8 B
|
|
|
_3. Intersect.sql
|
SQL
|
204.8 B
|
|
|
_3. Like.sql
|
SQL
|
204.8 B
|
|
|
_3. Right Join.sql
|
SQL
|
204.8 B
|
|
|
_3. Update.sql
|
SQL
|
204.8 B
|
|
|
_3. View.sql
|
SQL
|
204.8 B
|
|
|
_4. Aggregates Function.sql
|
SQL
|
204.8 B
|
|
|
_4. CTEs Recursive Generate Numbers.sql
|
SQL
|
204.8 B
|
|
|
_4. Delete.sql
|
SQL
|
204.8 B
|
|
|
_4. Finding Duplicates.sql
|
SQL
|
204.8 B
|
|
|
_4. Nulls Clause.sql
|
SQL
|
204.8 B
|
|
|
_4. Sorting
|
SORTING
|
204.8 B
|
|
|
_4. Subqueries.sql
|
SQL
|
204.8 B
|
|
|
_5. Alias.sql
|
SQL
|
204.8 B
|
|
|
_5. Alter.sql
|
SQL
|
204.8 B
|
|
|
_5. CTEs Recursive Even Numbers.sql
|
SQL
|
204.8 B
|
|
|
_5. Group by & having
|
GROUP BY & HAVING
|
204.8 B
|
|
|
_5. Limit.sql
|
SQL
|
204.8 B
|
|
|
_6. CTEs Recursive Fibonacci Numbers.sql
|
SQL
|
204.8 B
|
|
|
_6. Concat.sql
|
SQL
|
204.8 B
|
|
|
_6. DML Operations
|
DML OPERATIONS
|
204.8 B
|
|
|
_6. Insert With Single quote.sql
|
SQL
|
204.8 B
|
|
|
_6. Integer.sql
|
SQL
|
204.8 B
|
|
|
_7. CTEs recursive HIerarchical.sql
|
SQL
|
204.8 B
|
|
|
_7. String.sql
|
SQL
|
204.8 B
|
|
|
_7. Union & Intersect
|
UNION & INTERSECT
|
204.8 B
|
|
|
_8. Boolean.sql
|
SQL
|
204.8 B
|
|
|
_8. Joins & Subqueries
|
JOINS & SUBQUERIES
|
204.8 B
|
|
|
_9. Conditional Function
|
CONDITIONAL FUNCTION
|
204.8 B
|
|
|
_9. Date.sql
|
SQL
|
204.8 B
|
|
|
_Aggregating Merge Tree.sql
|
SQL
|
307.2 B
|
|
|
_Cluster Sql Commands.txt
|
TXT
|
307.2 B
|
|
|
_Collapsing Merge Tree.sql
|
SQL
|
307.2 B
|
|
|
_Commands
|
|
204.8 B
|
|
|
_Data Skipping Index.sql
|
SQL
|
307.2 B
|
|
|
_Dictionaries.sql
|
SQL
|
307.2 B
|
|
|
_Docker Commands.txt
|
TXT
|
307.2 B
|
|
|
_File Table Engine.sql
|
SQL
|
307.2 B
|
|
|
_Log Table.sql
|
SQL
|
307.2 B
|
|
|
_Memory.sql
|
SQL
|
307.2 B
|
|
|
_Replacing Merge Tree.sql
|
SQL
|
307.2 B
|
|
|
_Set Table.sql
|
SQL
|
307.2 B
|
|
|
_URL Table Engine.sql
|
SQL
|
307.2 B
|
|
|
_User and Roles.txt
|
TXT
|
307.2 B
|
|
|
_Versioned Collapsing Merge Tree.sql
|
SQL
|
307.2 B
|
