
DBMS Lab Manual
Description
Alles über E-Books | Antworten auf Fragen rund um E-Books, Kopierschutz und Dateiformate finden Sie in unserem Info- & Hilfebereich.
The Structured Query Language (SQL) is a computer language for accessing and manipulating databases.
The fundamental concept is to think of the data as being stored in one or more tables. When a request is made to retrieve data from these tables, which is called a "query", the resultant output is also presented in as table.
There are many different versions of the SQL language, but to be in compliance with the ANSI SQL '92 Standard, they must use and support the same major keywords in a similar manner (such as SELECT, UPDATE, DELETE, INSERT, WHERE, and others.
This manual is specially written for Students who are interested in understanding Structured Query Language and PL-SQL concepts in the Computer Engineering and Information technology field and wants to gain enhance knowledge about power of SQL Language in Relational Database Management System Development.
The manual covers practical point of view in all aspects of SQL and PL/SQL including DDL, DML,DCL sublanguages, also there are practices for Views, Group by, Having Clause. All PL-SQL concepts like Condition and Loop Structures, Functions and Procedures, Cursor, Triggers, Locks are illustrated using best examples.
More details
Content
- Intro
- DBMS LAB MANUAL
- Copyright © 2012 Jitendra Patel
- Practical 1: Create synonyms, sequence and index.
- Dropping a synonym
- What is an Index?
- Create an Index
- Drop an Index
- Practical 2: Create, alter and update views
- Creating a VIEW
- Updating a VIEW
- Dropping a VIEW
- Practical 3: Create PL/SQL programmes using cursors, control structures, exception handling.
- Conditional Statements in PL/SQL
- Iterative Statements in PL/SQL
- 1) Simple Loop
- 2) While Loop
- 3) FOR Loop
- 1) What is Exception Handling?
- 2) Structure of Exception Handling.
- 3) Types of Exception.
- a) Named System Exceptions
- b) Unnamed System Exceptions
- c) User-defined Exceptions
- RAISE_APPLICATION_ERROR ( )
- Practical 4: Create simple triggers.
- What is a Trigger?
- Syntax of Triggers
- After Statement-Level Trigger
- Before Row-Level Trigger
- Practical 5: Create package using procedure and functions.
- Stored Procedures
- What is a Stored Procedure?
- How to execute a Stored Procedure?
- Functions
- What is a Function in PL/SQL?
- How to execute a PL/SQL Function?
- Parameters in Procedure and Functions
- How to pass parameters to Procedures and Functions in PL/SQL ?
- Practical 6: Create users, Grant and revoke privileges.
- CREATING A USER
- SQL GRANT Command
- SQL REVOKE Command:
- Privileges and Roles:
- Creating Roles:
- Practical 7: Practice on Normalizations
- Exercise:
System requirements
File format: ePUB
Copy protection: Adobe-DRM (Digital Rights Management)
System requirements:
- Computer (Windows; MacOS X; Linux): Install the free reader Adobe Digital Editions prior to download (see eBook Help).
- Tablet/smartphone (Android; iOS): Install the free app Adobe Digital Editions or the app PocketBook before downloading (see eBook Help).
- E-reader: Bookeen, Kobo, Pocketbook, Sony, Tolino and many more (not Kindle).
The file format ePub works well for novels and non-fiction books – i.e., „flowing” text without complex layout. On an e-reader or smartphone, line and page breaks automatically adjust to fit the small displays.
This eBook uses Adobe-DRM, a „hard” copy protection. If the necessary requirements are not met, unfortunately you will not be able to open the eBook. You will therefore need to prepare your reading hardware before downloading.
Please note: We strongly recommend that you authorise using your personal Adobe ID after installation of any reading software.
For more information, see our ebook Help page.