mca Syllabus

Database Management System Lab
Code: CS 592
Contacts: 3P
Credits: 2

Structured Query Language
1. Creating Database

• Creating a Database
• Creating a Table
• Specifying Relational Data Types
• Specifying Constraints
• Creating Indexes

2. Table and Record Handling

• INSERT statement
• Using SELECT and INSERT together
• DELETE, UPDATE, TRUNCATE statements
• DROP, ALTER statements

3. Retrieving Data from a Database

• The SELECT statement
• Using the WHERE clause
• Using Logical Operators in the WHERE clause
• Using IN, BETWEEN, LIKE , ORDER BY, GROUP BY and HAVING

Clause

• Using Aggregate Functions
• Combining Tables Using JOINS
• Subqueries

4. Database Management

• Creating Views
• Creating Column Aliases
• Creating Database Users
• Using GRANT and REVOKE

Cursors in Oracle PL / SQL
Writing Oracle PL / SQL Stored Procedures