CACS 255 Database Management System Lab -BCA 4th Semester 2022

Lab #1 Installation of Oracle 11g Express Edition R2 on Windows and verification using sqlplus Utility

Lab #2 Installing and Using SQL Developer as client tool and activating HR account.

Lab #3 Exploring HR Schema, and performing basic queries using SELECT statement

Lab #4 Use WHERE clause and Operators ( Arithmetic Operator, Comparison Operator, AND, OR, IN, BETWEEN, LIKE)

Lab #5 Grouping Records using GROUP BY clause, aggregate functions (SUM, MIN, MAX, COUNT, AVG, STDDEV) and HAVING clause

Lab #6 Performing JOINS (natural join, INNER JOIN, LEFT OUTER JOIN, RIGHT JOIN, FULL OUTER JOIN)

Lab #7 Using Sub Queries, SET Operations ( UNION, INTERSECT, MINUS)

Lab #8 Implementing DDL statements ( CREATE, ALTER, DROP tables, SEQUENCES, INDEXES)

Lab #9 Implementing DML statements (INSERT, UPDATE, DELETE)

Lab #10 Creating VIEWS and Using them

Lab #11 PL/SQL – variables, if-else, nested-if, data types, cursors

Lab #12 PL/SQL – Functions, Stored Procedures

Lab #13 PL/SQL – Triggers

Lab #14 DCL- Creating ROLE, USER and assigning privileges through ROLE to USER and Revoking privileges (GRANT and REVOKE).

Lab #15 Backup and Restore (expdb, impdb) using DATA PUMP

Lab #16 Query Processing and Optimization (Tuning) and Role of Indexes.

Lab #17 Using RMAN (Recovery Manager) for recovery management (MOUNT, NOMOUNT, ARCHIVELOG, NONARCHIVELOG modes of database )

Lab #18 TCL- Transaction Control Language ( Locking Protocols Implementation)

Lab #19 Querying the DATA DICTIONARY

Lab #20 Using PHP to Access the Oracle Database (Building a simple CRUD Operation) – Implementing a 3-tier application architecture

Leave a Reply

Releated

IT 306 Software Project Management

Course Objectives The module aims to provide an overview of the roles, responsibilities and management methods of thesoftware project manager. The course intended to teach students how to develop approaches and styles ofmanagement for software projects. Course Description Software Project Basics, Tools and Techniques, Estimation, Project Schedules, Reviews, Softwarerequirements, Design and Programming, Software Testing, Using […]