Unit IV: Relational Database Query Languages | BCA 4th Semester Database Management System (DBMS) Notes Pdf

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:

1. Introduction to SQL (Structured Query Language)
2. Features of SQL
3. Queries and Sub-Queries
4. JOIN Operations
5. SQL INNER JOIN, SQL LEFT JOIN, SQL RIGHT JOIN, SQL FULL JOIN, SQL CROSS JOIN
6. SET Operations
7. UNION Operation, UNION ALL Operation, INTERSECT Operation, MINUS (Except) Operation
8. Data Definition Language (DDL) Command
9. CREATE, DROP and TRUNCATE, ALTER (ADD, DROP, MODIFY), Comment, RENAME
10. Data Manipulation Language (DML) Commands
11. SQL SELECT
12. Some Keyword used with SQL SELECT
13. SQL SELECT DISTINCT, SQL SELECT COUNT, SQL SELECT TOP, SQL SELECT RANDOM, SQL SELECT AS, SQL SELECT NULL, SQL ORDER BY Clause
14. SQL INSERT INTO
15. SQL UPDATE
16. SQL DELETE
17. Some SQL Clauses used with DML Commands
18. SQL WHERE, SQL BETWEEN AND & NOT BETWEEN AND, SQL IN, NOT IN Clause, SQL LIKE & Wildcard Clause, SQL Group By Clause, SQL HAVING Clause
19. Stored Procedure
20. Execute A Stored Procedure
21. Stored Procedure Execution Types
22. 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 [email protected].

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.

BCA 4th Semester Database Management System (DBMS) Notes Pdf:

• Unit I: Introduction To Database Management System (DBMS)
• Unit II: Data Models
• Unit III: Relational Model
• Unit V: Database Constraints and Relational Database Design
• Unit VI: Database Security
• Unit VII: Query Processing
• Unit VIII: File Organization and Indexing
• Unit IX: Crash Recovery
• Unit X: Transaction Processing and Concurrency Control
• Unit XI: Advanced Database Concepts