DataDesk
All topics
ALTER, DROP & views — practice · DataDesk
DataDesk
How it works
Scenarios
Practice
For trainers
Pricing
Log in
Start free
SQL
ALTER, DROP & views
Change table structure and save queries as views.
0
/ 20 solved
All levels
Basic (7)
Intermediate (8)
Advanced (5)
All
To do
Solved
1
Add a column
Basic
2
Add a column with a default
Basic
3
Drop a column
Basic
4
Rename a column
Basic
5
Rename a table
Basic
6
Drop a table
Basic
7
Your first view
Basic
8
Change a column's type
Intermediate
9
Make a column required
Intermediate
10
Set a default later
Intermediate
11
Add and fill a column
Intermediate
12
View with a join
Intermediate
13
Aggregated view
Intermediate
14
Replace a view
Intermediate
15
Drop a column safely
Intermediate
16
Add a primary key later
Advanced
17
Split a full name
Advanced
18
Rebuild a table with a new column order
Advanced
19
View of department KPIs
Interview
Advanced
20
Views stay up to date
Advanced