The standard SQL commands to interact with relational databases are CREATE, SELECT, INSERT, UPDATE, DELETE and DROP. These commands can be classified into the following groups based on their nature,
DDL is short name of Data Definition Language, which deals with database schemas and descriptions, of how the data should reside in the database.
DML is short name of Data Manipulation Language which deals with data manipulation and includes most common SQL statements such SELECT, INSERT, UPDATE, DELETE etc, and it is used to store, modify, retrieve, delete and update data in a database.
DCL is short name of Data Control Language which includes commands such as GRANT and mostly concerned with rights, permissions and other controls of the database system.
TCL is short name of Transaction Control Language which deals with a transaction within a database.
Problem | Score | Companies | Time | Status |
---|---|---|---|---|
Performance Improvement | 50 |
|
28:58 | |
Minimum GPA | 50 |
|
34:09 | |
Number of offers | 50 |
|
31:01 | |
Neutral Reviewers | 100 |
|
24:58 | |
Movie Character | 100 |
|
34:59 | |
Short Films | 100 |
|
31:20 |
Problem | Score | Companies | Time | Status |
---|---|---|---|---|
Study Selection | 50 |
|
9:08 | |
Study Update | 50 |
|
17:36 | |
Study Deletion | 50 |
|
11:40 | |
Job Offers 2.0 | 50 |
|
24:13 | |
Actors and their Movies | 100 |
|
38:27 |
Problem | Score | Companies | Time | Status |
---|---|---|---|---|
Town Selection | 50 |
|
7:59 | |
Town Queries | 50 |
|
5:19 | |
Student Query | 50 |
|
7:45 | |
Country Filtration | 50 |
|
6:05 | |
Information Selector | 50 |
|
3:45 | |
Town Of Threes | 50 |
|
8:21 |
Problem | Score | Companies | Time | Status |
---|---|---|---|---|
Firefighter's Average | 50 |
|
10:10 | |
Firefighter's Sum | 50 |
|
6:14 | |
Largest Difference | 50 |
|
13:08 | |
Distance Maximizer | 50 |
|
15:34 | |
Euclid's Distance | 50 |
|
17:11 | |
Big Salary | 50 |
|
19:52 | |
5'th Highest Marks | 50 |
|
22:46 | |
Famous Books | 50 |
|
25:37 | |
Chess Tournament | 50 |
|
28:13 | |
NULL sorting | 50 |
|
22:32 | |
I hate Vowels | 50 |
|
25:07 | |
Birthdays | 50 |
|
16:52 | |
Class Average | 50 |
|
18:28 | |
Tournament 2.0 | 50 |
|
25:14 | |
Job Offer | 50 |
|
22:29 | |
Next And Previous | 50 |
|
21:36 |
Problem | Score | Companies | Time | Status |
---|---|---|---|---|
Conditional Work | 50 |
|
20:52 | |
Role Ordering | 50 |
|
27:18 | |
Role Player | 50 |
|
14:40 | |
Role Counter | 50 |
|
14:28 | |
Vowel Country | 50 |
|
13:53 |
Problem | Score | Companies | Time | Status |
---|---|---|---|---|
Engineers Joined | 50 |
|
24:22 | |
Many Tables | 50 |
|
20:12 | |
Top Performer | 50 |
|
26:49 | |
Low and High Grades | 50 |
|
21:18 | |
Same Countries | 50 |
|
21:10 |