DataDesk
All topics
CREATE TABLE & data types — practice · DataDesk
DataDesk
How it works
Scenarios
Practice
For trainers
Pricing
Log in
Start free
SQL
CREATE TABLE & data types
Design tables with the right columns and types.
0
/ 20 solved
All levels
Basic (7)
Intermediate (8)
Advanced (5)
All
To do
Solved
1
Your first table
Basic
2
Products with prices
Basic
3
Student records
Basic
4
Events with a timestamp
Basic
5
Library books
Basic
6
Column order matters
Basic
7
Shift timings
Basic
8
Pick the right types
Intermediate
9
Only if it doesn't exist
Intermediate
10
Replace an old table
Intermediate
11
Quoted column names
Intermediate
12
Copy a table's structure (no rows)
Intermediate
13
Create a table from a query
Intermediate
14
Summary table
Intermediate
15
Two related tables
Intermediate
16
Computed (generated) column
Advanced
17
Directory from a join
Advanced
18
Top customers snapshot
Advanced
19
Backup before a risky change
Interview
Advanced
20
Lookup table with values
Advanced