ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Platform
2
1
Db2 on (IBM)Cloud
3
2
MySQL (container on local)
4
3SQL Lite
5
4
PostgreSQL (Heroku)
6
5Snowflake
7
6
Oracle Cloud Free
8
7
CockroachDB Serverless
9
8
SingleStore Free Tier
10
9
Dealer's choice
11
12
Task Category
13
1
Changing Data (DML, etc)
14
2
Defining Objects (DDL, etc)
15
3
Querying Data (DQL, etc)
16
4
Controlling access to Data (DCL, etc)
17
5
Managing Transactions (TCL, locking, isolation levels, etc)
18
19
20
Task
21
Changing Data (DML, etc)
22
1Insert
23
2Update
24
3Delete
25
4Merge/Upsert
26
5
Load/import data from csv
27
6
Export data to csv
28
29
30
Defining Objects (DDL, etc)
roll again or do the closest analog if not possilbe for a platform
31
1Create table
32
2Create index
33
3
Create function or expression based index
34
4
Cluster a table
35
5Alter table
36
6
Alter largish table with minimal outage
37
7Drop table
38
8
Drop all objects in a schema
39
9Create view
40
10
Create Materialized table/view
41
11
Create Constraint
42
12
Create Trigger
43
13
Use Temporary table
44
14
Create a stored procdure
45
15
Create a function
46
16
Create a table function
47
48
Querying Data (DQL, etc)
49
1select *
50
2
Six or more where conditions
51
3
Join six or more tables
52
4CTE
53
5
Subquery in the SELECT clause
54
6
Subquery in the FROM clause
55
7
Subquery in the WHERE clause
56
8
Group by two or more columns/values
57
9
OLAP/ Window function
58
10
Lateral join / Table Function
59
11
Execute a script of multiple sql statements
60
12
Apply scalar function in the SELECT clause
61
13
Apply scalar function in the WHERE clause
62
14
Apply scalar function in a GROUP BY
63
15
Write the same join three different ways
64
16Full Outer join
65
17
left or right inner join
66
18
Use HAVING with GROUP BY
67
19
Write a correlated subquery
68
20
Use an aggrgate function
69
21
Date/time math
70
22
Write a poorly written or slow query and optimize for it
71
23
Generate access plan for a query
72
24
Write two queries to do the same thing, and compare their performance
73
74
Controlling access to Data (DCL, etc)
75
1
Grant a permission and show that it works
76
2
Revoke a permission and show that it works
77
3
Grant a user the ability to connect and show that it works
78
4
Revoke connection permission from a user and show that it works
79
5
Grant a permission to a group of users and show that it works
80
6
Revoke a permission from a group of users and show that it works
81
7
Delete a user and see what happens to objects they own
82
83
Managing Transactions (TCL, locking, isolation levels, etc)
84
1
Turn off autocommit
85
2
rollback a transaction
86
3
create a transaction with at least three statements in it
87
4
demonstrate what a lock wait looks like
88
5
demonstrate what a deadlock looks like
89
6
Demonstrate the differences between two isolation levels
90
91
Model Database (which depends on the dbms platform roll)
92
Sakila
https://dev.mysql.com/doc/sakila/en/
93
Db2 Sample database
94
Chinook
https://github.com/lerocha/chinook-database
95
GSDB
https://www.ibm.com/docs/en/data-studio/4.1.1?topic=database-download-gsdb-sample-data
96
Snowflake Sample data
97
98
Chaos
(if impossible, must roll again)
99
1
Use GUIs in every situation where possible
100
2
Use command line in every situation where possible