Rayat Institute of Engineering
& Information Technology
Approved by AICTE, Affiliated to PTU, Jalandhar.
 
RDBMS Lab

RDBMS stands for Relational Database Management System. RDBMS is the basis for SQL, and for all modern database systems like MS SQL Server, IBM DB2, Oracle, MySQL, and Microsoft Access.

A Relational database management system (RDBMS) is a database management system (DBMS) that is based on the relational model as introduced by E. F. Codd.

BTCS 506 RDBMS LAB

Note: This practical will enable students to retrieve data from relational databases using SQL. Students will also learn about triggers, cursors, stored procedures etc.

  1. Introduction to SQL and installation of SQL Server / Oracle.
  2. Data Types, Creating Tables, Retrieval of Rows using Select Statement, Conditional Retrieval of Rows, Alter and Drop Statements.
  3. Working with Null Values, Matching a Pattern from a Table, Ordering the Result of a Query, Aggregate Functions, Grouping the Result of a Query, Update and Delete Statements.
  4. Set Operators, Nested Queries, Joins, Sequences.
  5. Views, Indexes, Database Security and Privileges: Grant and Revoke Commands, Commit and Rollback Commands./
  6. PL/SQL Architecture, Assignments and Expressions, Writing PL/SQL Code, Referencing Non-SQLparameters.
  7. Stored Procedures and Exception Handling.
  8. Triggers and Cursor Management in PL/SQL.
Suggested Tools – MySQL, DB2, Oracle, SQL Server 2012, Postgre SQL, SQL lite



Rayat Institute of Engineering & Information Technology
Railmajra, Near Ropar , Distt. S.B.S Nagar, PIN-144533, Punjab
Email : rieit@rayatbahra.com
Home | Study Programmes | Placement | Facilities | Jobs | Online Grievance Cell | Web Mail | Contact Us
Copyright 2018, RAYAT-BAHRA. All rights reserved. Website designed & maintained by E.D.P. Department.