Structured Query Language (SQL) is a standardized language used to interact with relational database management systems. SQL is used to interact with the database. Using SQL statements we can define, store and manage database objects. The table is the basic storage structure in a database. Tables are row/column structures in which data can be stored.
SQL is divided into sub-languages. These are the Data Definition Language, Data Manipulation Language, Data Control Language, Transaction Control Language and Data Retrieval statements. Each sub-language consists of a grouping of SQL statements. Given below is a general breakdown of each sub-language and its statements.
| SUB-LANGUAGE |
STATEMENTS |
| Data Definition Language |
CREATE, ALTER, DROP, TRUNCATE, RENAME |
| Data Manipulation Language |
INSERT, UPDATE, DELETE, MERGE |
| Data Control Language |
GRANT, REVOKE |
| Transaction Control Language |
COMMIT, ROLLBACK, SAVEPOINT |
| Data Retrieval |
SELECT |
Mastering SQL involves practice. The more you practice writing SQL statements the better you get. To help you master the art of writing SQL statements, OracleCoach offers a series of sample databases. The databases have been created based on real-world scenarios. Each scenario is self-contained, with table descriptions, sample scripts that can be executed to create the tables on the machine and SQL questions. It is important that you review the data in the tables very carefully so you have a complete understanding of the data. After you have understood the data, you can execute the scripts on the machine and try out the questions. The answers to each question has also been provided. The questions range from simple to complex.
Video Tutorials
 |
SQL Developer Tutorials teach you how to work with :
- SQL Developer tool
- Structured Query Language.
|
Articles in our Structured Query Language Section
Installing SQL Developer
Basic Querying of a Table in Oracle
Restricting Data using a Where clause
SQL Functions in Oracle
Joining Tables in Oracle
Subqueries in Oracle
Take the SQL Quiz
Oracle Tutorials 
| 
| 
