Scribd
Upload
27 views2 pages

Rdbms Index

The document outlines a comprehensive guide for database management tasks, including creating tables, managing databases, and executing various SQL queries. It also covers advanced topics such as PL-SQL blocks, stored procedures, cursors, and triggers. Each section provides specific actions to be performed, ensuring a thorough understanding of database operations.

Uploaded by

SAHIL PATIL
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
27 views2 pages

Rdbms Index

The document outlines a comprehensive guide for database management tasks, including creating tables, managing databases, and executing various SQL queries. It also covers advanced topics such as PL-SQL blocks, stored procedures, cursors, and triggers. Each section provides specific actions to be performed, ensuring a thorough understanding of database operations.

Uploaded by

SAHIL PATIL
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

INDEX

Sr. Title Page No Date Sign


No
1 Create the tables with appropriate
constraints.
2 Perform the following:
 Viewing all existing databases
 Creating a database
 Viewing all Tables in a Database
 Creating Tables (with and
without Constraints)
 Inserting/Updating/Deleting
Records in table.
 Saving (commit) and Undoing
(rollback)

3 Perform the following:


 Altering a table
 Dropping/Truncating/Renaming
Tables
 Granting and Revoking
Permissions
4 Perform the following:
 Simple Queries
 Simple Queries with Aggregate
Functions.
 Queries with Aggregate functions
(group by and having clause)

5 Queries Involving:
 Date Functions
 String Functions
 Math Functions
6 Creating queries on Joins
Creating Sub Queries
7 Creating Views and Index

8 PL-SQL Block on Branching Statement

9 PL-SQL Block on Looping Statement

10 Stored Procedure, Cursors and Triggers


 Creating stored procedure with
and without parameters
 Creating Cursor
 Creating Triggers

You might also like