This Course will enable students to
LTPC 0021
Populate and query a database using SQL DDL/DML Commands
Declare and enforce integrity constraints on a database
Writing Queries using advanced concepts of SQL
Programming PL/SQL including procedures, functions, cursors and triggers
Course Outcomes:
At the end of the course the student will be able to:
Utilize SQL to execute queries for creating database and performing data manipulation operations
Examine integrity constraints to build efficient databases
Apply Queries using Advanced Concepts of SQL
Build PL/SQL programs including stored procedures, functions, cursors and triggers
List of Exercises:
1. Creation, altering and droping of tables and inserting rows into a table (use constraints while creating tables) examples using SELECT command. Download Now
2. Queries (along with sub Queries) using ANY, ALL, IN, EXISTS, NOTEXISTS, UNION, INTERSET, Constraints. Example:- Select the roll number and name of the student who secured fourth rank in the class.