Unit 3: Structured Query Language(SQL)
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.
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.