Header Ads Widget

Top Billboard Ads

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.

Relational Database Query Languages – Database Management System

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:

Post a Comment

0 Comments