Responsive image

Database Management System - DBMS for BCA

Unit 3: SQL(14 hrs.)

Data Types - Data Definition commands: CREATE, ALTER, DROP - Adding Constraints in SQL.

Basic SQL Queries: INSERT, SELECT, DELETE, UPDATE - Substring Comparison using LIKE Operator, BETWEEN operator - Ordering of Rows - SQL Set Operations UNION, EXCEPT, INTERSECT.

Complex Queries: Comparison involving NULL and Three-valued Logic, Nested Queries, EXISTS and UNIQUE Functions, Renaming of Attributes and Joining of Tables, Aggregate Functions, Grouping - Managing Views.