-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathmkdocs.yml
145 lines (141 loc) · 7.91 KB
/
mkdocs.yml
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
---
site_name: SQL Learning Materials
site_url: https://github.com/Bilbottom/sql-learning-materials/docs/
site_description: SQL scripts that demonstrate various features and concepts.
site_author: Bilbottom
repo_url: https://github.com/Bilbottom/sql-learning-materials/
theme:
name: material
features:
- navigation.instant
- navigation.footer
- navigation.tabs
- content.code.copy
palette:
- accent: default
primary: default
scheme: default
toggle:
icon: material/toggle-switch-off-outline
name: Switch to dark mode
- accent: default
primary: default
scheme: slate
toggle:
icon: material/toggle-switch
name: Switch to light mode
nav:
- Home: index.md
- From Excel to SQL:
- from-excel-to-sql/from-excel-to-sql.md
- Getting Started:
- from-excel-to-sql/getting-started/setting-the-context.md
- from-excel-to-sql/getting-started/sql-syntax.md
- Main Concepts:
- from-excel-to-sql/main-concepts/select-and-from.md
- from-excel-to-sql/main-concepts/where.md
- from-excel-to-sql/main-concepts/order-by.md
- from-excel-to-sql/main-concepts/comments.md
- from-excel-to-sql/main-concepts/top-and-distinct.md
- from-excel-to-sql/main-concepts/data-types.md
- from-excel-to-sql/main-concepts/operators.md
- from-excel-to-sql/main-concepts/conditionals.md
- from-excel-to-sql/main-concepts/date-formatting.md
- from-excel-to-sql/main-concepts/group-by.md
- from-excel-to-sql/main-concepts/rollup.md
- from-excel-to-sql/main-concepts/join.md
- from-excel-to-sql/main-concepts/union.md
- from-excel-to-sql/main-concepts/subqueries.md
- from-excel-to-sql/main-concepts/window-functions.md
- from-excel-to-sql/main-concepts/logical-processing-order.md
- from-excel-to-sql/main-concepts/style-guide.md
- Advanced Concepts:
- from-excel-to-sql/advanced-concepts/advanced-aggregations.md
- from-excel-to-sql/advanced-concepts/correlated-subqueries.md
- from-excel-to-sql/advanced-concepts/recursive-ctes.md
- Everything about joins:
- everything-about-joins/everything-about-joins.md
- Syntax:
- everything-about-joins/syntax/join-fundamentals.md
- everything-about-joins/syntax/more-fundamentals.md
- everything-about-joins/syntax/timestamp-joins.md
- everything-about-joins/syntax/filtering-joins.md
- everything-about-joins/syntax/glue-joins.md
- everything-about-joins/syntax/explosive-joins.md
- everything-about-joins/syntax/sql-92-rant.md
- Under the hood:
- everything-about-joins/under-the-hood/joins-with-an-index.md
- everything-about-joins/under-the-hood/join-order.md
- everything-about-joins/under-the-hood/loop-joins.md
- everything-about-joins/under-the-hood/hash-joins.md
- everything-about-joins/under-the-hood/merge-joins.md
- everything-about-joins/under-the-hood/range-intersection-joins.md
- Challenging SQL problems:
- challenging-sql-problems/challenging-sql-problems.md
- Problems:
- 🟤 Bronze Tier:
- challenging-sql-problems/problems/bronze/temperature-anomaly-detection.md # window functions
- challenging-sql-problems/problems/bronze/outstanding-invoices.md # asof join
- challenging-sql-problems/problems/bronze/personalised-customer-emails.md # string similarity
- challenging-sql-problems/problems/bronze/suspicious-login-activity.md # window functions (gaps and islands)
- challenging-sql-problems/problems/bronze/combining-dimensions.md # asof join, custom axis
- challenging-sql-problems/problems/bronze/customer-churn.md # bit-shifting
- challenging-sql-problems/problems/bronze/fibonacci-sequence.md # recursive CTE
- challenging-sql-problems/problems/bronze/uk-bank-holidays.md # unpivot and unnest
- ⚪ Silver Tier:
- challenging-sql-problems/problems/silver/metric-correlation.md # unpivot, corr
- challenging-sql-problems/problems/silver/funnel-analytics.md # custom axis
- challenging-sql-problems/problems/silver/bannable-login-activity.md # window functions (gaps and islands, range between)
- challenging-sql-problems/problems/silver/bus-routes.md # recursive CTE
- challenging-sql-problems/problems/silver/decoding-datelist-ints.md # recursive CTE, bit-shifting
- challenging-sql-problems/problems/silver/region-precipitation.md # unpivot and rollup
- challenging-sql-problems/problems/silver/predicting-values.md # unpivot, regr, and pivot
- challenging-sql-problems/problems/silver/mandelbrot-set.md # recursive CTE
- challenging-sql-problems/problems/silver/customer-sales-running-totals.md # window functions
- 🟡 Gold Tier:
- challenging-sql-problems/problems/gold/loan-repayment-schedule.md # recursive CTE
- challenging-sql-problems/problems/gold/risk-invasions.md # window functions, recursive CTE, custom axis
- challenging-sql-problems/problems/gold/supply-chain-network.md
- challenging-sql-problems/problems/gold/encoding-datelist-ints.md # window functions (gaps and islands), correlated subquery, custom axis
- challenging-sql-problems/problems/gold/travel-plans.md # recursive CTEs
- Solutions:
- 🟤 Bronze Tier:
- challenging-sql-problems/solutions/bronze/temperature-anomaly-detection.md
- challenging-sql-problems/solutions/bronze/outstanding-invoices.md
- challenging-sql-problems/solutions/bronze/personalised-customer-emails.md
- challenging-sql-problems/solutions/bronze/suspicious-login-activity.md
- challenging-sql-problems/solutions/bronze/combining-dimensions.md
- challenging-sql-problems/solutions/bronze/customer-churn.md
- challenging-sql-problems/solutions/bronze/fibonacci-sequence.md
- challenging-sql-problems/solutions/bronze/uk-bank-holidays.md
- ⚪ Silver Tier:
- challenging-sql-problems/solutions/silver/metric-correlation.md
- challenging-sql-problems/solutions/silver/funnel-analytics.md
- challenging-sql-problems/solutions/silver/bannable-login-activity.md
- challenging-sql-problems/solutions/silver/bus-routes.md
- challenging-sql-problems/solutions/silver/decoding-datelist-ints.md
- challenging-sql-problems/solutions/silver/region-precipitation.md
- challenging-sql-problems/solutions/silver/predicting-values.md
- challenging-sql-problems/solutions/silver/mandelbrot-set.md
- challenging-sql-problems/solutions/silver/customer-sales-running-totals.md
- 🟡 Gold Tier:
- challenging-sql-problems/solutions/gold/loan-repayment-schedule.md
- challenging-sql-problems/solutions/gold/risk-invasions.md
- challenging-sql-problems/solutions/gold/supply-chain-network.md
- challenging-sql-problems/solutions/gold/encoding-datelist-ints.md
- challenging-sql-problems/solutions/gold/travel-plans.md
- challenging-sql-problems/topics.md
markdown_extensions:
- admonition
- callouts # https://github.com/oprypin/markdown-callouts
- mdx_truly_sane_lists # Support nested lists
- pymdownx.details # Support collapsible sections with ???
- pymdownx.snippets
- pymdownx.superfences:
custom_fences:
- { name: mermaid, class: mermaid }
plugins:
- search
- callouts # https://github.com/sondregronas/mkdocs-callouts
- tags:
tags_file: challenging-sql-problems/topics.md