Unit IV: Relational Database Query Languages

SQL stands for Structured Query Language. It is designed for managing data in a relational database management system (RDBMS). It is pronounced as S-Q-L or sometime See-Qwell.

In this “Relational Database Query Languages – Database Management System” you will learn about the following topics:

Introduction to SQL (Structured Query Language)
Features of SQL
Queries and Sub-Queries
JOIN Operations
SQL INNER JOIN, SQL LEFT JOIN, SQL RIGHT JOIN, SQL FULL JOIN, SQL CROSS JOIN
SET Operations
UNION Operation, UNION ALL Operation, INTERSECT Operation, MINUS (Except) Operation
Data Definition Language (DDL) Command
CREATE, DROP and TRUNCATE, ALTER (ADD, DROP, MODIFY), Comment, RENAME
Data Manipulation Language (DML) Commands
SQL SELECT
Some Keyword used with SQL SELECT
SQL SELECT DISTINCT, SQL SELECT COUNT, SQL SELECT TOP, SQL SELECT RANDOM, SQL SELECT AS, SQL SELECT NULL, SQL ORDER BY Clause
SQL INSERT INTO
SQL UPDATE
SQL DELETE
Some SQL Clauses used with DML Commands
SQL WHERE, SQL BETWEEN AND & NOT BETWEEN AND, SQL IN, NOT IN Clause, SQL LIKE & Wildcard Clause, SQL Group By Clause, SQL HAVING Clause
Stored Procedure
Execute A Stored Procedure
Stored Procedure Execution Types
Query by Example (QBE)

========== Point to Note ==========

This article Relational Database Query Languages – Database Management System is contributed by Rashita Gurung, a student of LA GRANDEE International College.

If you like to contribute, you can mail us BCA Notes, BCA Question Collections, BCA Related Information, and Latest Technology Information at bcanotespu@gmail.com.

See your article appearing on BCA Notes (Pokhara University) main page with your designation and help other BCA Students to excel.

Please write comments if you find anything incorrect, or you want to share more information about the topic discussed above.