SQL Programming

Go to Problems

SQL Commands

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 - Data Definition Language

DDL is short name of Data Definition Language, which deals with database schemas and descriptions, of how the data should reside in the database.

  • CREATE - create a new table, view for a table or other object in the database
  • ALTER - modifies an existing database object, such as a table
  • DROP - deletes an entire table, a view of a table or other objects in the database
  • TRUNCATE - remove all records from a table, including all spaces allocated for the records are removed
  • COMMENT - add comments to the data dictionary
  • RENAME - rename an object

 

DML - Data Manipulation Language

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.

  • SELECT - retrieves records from one or more tables
  • INSERT - creates a record
  • UPDATE - modifies records
  • DELETE - deletes records
  • MERGE - UPSERT operation (insert or update)
  • CALL - call a PL/SQL or Java subprogram
  • EXPLAIN PLAN - interpretation of the data access path
  • LOCK TABLE - concurrency control

 

DCL - Data Control Language

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.

  • GRANT (Grant privilige(s) to user)
  • REVOKE (Remove granted privilige(s) from a user)

 

TCL - Transaction Control Language

TCL is short name of Transaction Control Language which deals with a transaction within a database.

 

  • COMMIT - commits a transaction
  • ROLLBACK - rollback a transaction in case of any error occurs
  • SAVEPOINT - to rollback the transaction making points within groups
  • SET TRANSACTION - specify characteristics of the transaction

Serious about Learning Databases ?

Learn this and a lot more with Scaler Academy's industry vetted curriculum.
Sql joins
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
Sql sub queries
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
Basic select
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
Aggregation
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
Advanced select
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
Basic join
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