SQL is a standard language used for Relational Database Systems (RDBMS). It enables the users to create, update, read, and delete relational databases as well as tables.
In this article, we will look more into Introduction to SQL according to the GATE Syllabus for (Computer Science Engineering) CSE. We will read ahead to find out more about it.
Table of Contents
- Introduction to SQL
- SQL Commands
- Joins in SQL
- Constraints in SQL
- SQL MCQs
- Difference Between Commands in SQL
Introduction to SQL
SQL is an abbreviation for the term Structure Query Language. It is a type of database query language (DQL) that is primarily used for storing data and managing it in the Relational DBMS. This language was the first commercial language introduced for the Relational model of the database by E. F Codd. Today, about all the RDBMS, such as MySql, Infomix, Oracle, MS Access, Sybase, etc., use SQL as their standard DQL. The SQL language is mainly used to perform all the types of data operations in an RDBMS.
SQL Commands
DDL- Data Definition Language
- CREATE Statement in SQL
- TRUNCATE Statement in SQL
- DROP Statement in SQL
- ALTER Statement in SQL
- COMMENT in SQL
- RENAME in SQL
DCL – Data Control Language
DML- Data Manipulation Language
DQL- Data Query Language
Joins in SQL
| Cartesian Join in SQL | Left Join in SQL |
| Equi Join in SQL | Right (Outer) Join in SQL |
| Full Join in SQL | Self Join in SQL |
Constraints in SQL
SQL MCQs
Difference Between Commands in SQL
Keep learning and stay tuned to get the latest updates on GATE Exam along with GATE Eligibility Criteria, GATE 2023, GATE Admit Card, GATE Syllabus, GATE Previous Year Question Paper, and more.
Also Explore,
