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.
BCA 4th Semester DBMS (Database Management System) Notes Pdf:
Unit I: Introduction To Database Management System (DBMS) - Database Management System
Unit II: Data Models - Database Management System
Unit III: Relational Model - Database Management System
Unit V: Database Constraints and Relational Database Design - Database Management System
Unit VI: Database Security - Database Management System
Unit VII: Query Processing - Database Management System
Unit VIII: File Organization and Indexing - Database Management System
Unit IX: Crash Recovery - Database Management System
Unit X: Transaction Processing and Concurrency Control - Database Management System
Unit XI: Advanced Database Concepts - Database Management System
0 Comments: