Learning Oracle SQL And PL / SQL : A Simplified Guide

By Rajeeb C. Chatterjee more
828 Views
Selling Price : ₹249.38
MRP : ₹350.00
You will save : ₹100.63 after 29% Discount

Enter your email id to read this ebook
Submit

Save extra with 3 Offers

Get ₹ 50

Instant Cashback on the purchase of ₹ 400 or above
SAFE5 Already Applied

NEW35

Get Flat 35% Off on your First Order

Product Specifications

Publisher PHI Learning All Information Technology books by PHI Learning
ISBN 9788120345423
Author: Rajeeb C. Chatterjee
Number of Pages 398
Available
Available in all digital devices
  • Snapshot
  • About the book
  • Sample book
Learning Oracle SQL And PL / SQL : A Simplified Guide - Page 1 Learning Oracle SQL And PL / SQL : A Simplified Guide - Page 2 Learning Oracle SQL And PL / SQL : A Simplified Guide - Page 3 Learning Oracle SQL And PL / SQL : A Simplified Guide - Page 4 Learning Oracle SQL And PL / SQL : A Simplified Guide - Page 5

Learning Oracle SQL And PL / SQL : A Simplified Guide by Rajeeb C. Chatterjee
Book Summary:

The book offers a systematic knowledge of Oracle SQL and PL/SQL to help students exploit the capabilities of the database in an effective and efficient manner. The book follows a step-by-step approach to the subject using real-world cases, examples and exercises in order to make it an easy, interesting and complete self-study guide.

The book can be used for practical classes on Oracle version 8.0 onwards. The availability of an authorized Oracle database in conjunction with the book is sufficient to learn Oracle commands and syntaxes. It is designed to address the need of the laboratory classes on Oracle for the students of Computer Science, Information Technology and Computer Applications.

The book will also be useful to professionals and academics alike for conducting training programmes on Oracle database.

Audience of the Book :
This book Useful for CSE & IT Engineering Student
Table of Contents:

Preface

1. Introduction

2. Create Table Structure

3. Alter Table Structure

4. Insert a Row

5. Update Rows

6. Delete Rows

7. Query from Tables

8. Built-in Number Functions

9. Built-in Character Functions

10. Built-in Date Functions

11. Built-in Conversion Functions

12. Built-in Group Functions

13. Subquery

14. Advanced Join Methods

15. View

16. Sequence

17. Index

18. Synonym

19. Security

20. System Tables

21. SQL*Plus

22. Introduction to PL/SQL

23. Control Structures

24. Procedure

25. Function

26. Package

27. Trigger

28. Cursor

29. Introduction to Oracle Architecture

Answers to Revision Exercises

Index

x

Sold Just Now! 🔥

Ramesh Purchased Legal Aspects Of Business, just now!