About the Book
Digital Management System - Complete Practical Approach provides a complete guide to the practical implementations of DBMS concepts including SQL, Oracle, Oracle Administration and PL/SQL development. This book assumes no prior knowledge of the reader on the subject. It is very useful for B.E., B.Tech, BCA, PGDCA,PGDIT, MCA, B.Sc.(CSE/IT), M.Sc.(CSE/IT)M.I.T.,MBA , and M.Tech curriculum of all universities, computer institutes and DOEACC students of O, A & B levels.This book is also very useful for campus interviews and competitive examinations, which require extensive Oracle, SQL or DBMS practical knowledege. A large number of examples, practical questions, objective questions, FAQs are available in this book, which are very useful in universities and job-oriented examinations of various reputed companies.This book covers the following topics in detail:Foundation of Computers, Introduction to SQL, SQL Commands, SQL Functions, Relations, Various type of SQL queries, PL/SQL Cursors, Triggers, Procedure, Package, Customized Functions, Collections, DBA commands etc.Table Of Contents :0. Foundation of Computer1. Introduction2. Getting Started3. Alter,View and Index4. SQL *Plus Functions5. Normalization 6. Relations, Join, Reports7. Introduction to PL/SQL8. Cursors9. Trigger10. Subprograms : Procedure and Functions11. Packages12. Oracle Utilites13. Oracle Forms14. Oracle Report15. Objects & Basic Database AdministrationFAQ (Frequently Asked Questions)Competitive Questions Asked by Reputed Companies Like Infosys, Satyam, HCL, TCS, Oracle, Peoplesoft, Baan etc , AppendixBibliographyIndexAbout Author :Sharad Maheshwari has completed his M.Sc. (Comp. Sc.), Masters in Information Technology and is now pursuing M.Tech. He has more than four years of experience in the fields of Information Technology and Academics. He has an excellent track record of having worked at eminent institutions in Noida and Greater Noida where he has taught B.Tech, MCA, BCAM courses like 'C' Language, Visual Basic, Oracle, HTML, Web Technology, DBMS, Information Systems, E-Commerce, Java, Foundations of Information Technology etc. Presenlty, he is employed as Lecturer in Computer Science Department at an eminent engineering institute in Greater Noida.Ruchin Jain has completed his M.C.A. and is pursuing M.Tech. He has more than five years of experience in the field of IT industry and Academics. He has an excellent track record of having worked at eminent companies like HCL Infosystems and ASAP Solutions on Java Servlets and EJB in Noida. He has done his primary education in Florida (U.S.A.) Presently, he is employed as Lecturer in MCA Department at IEC College of Engineering & Technology, Greater Noida where he is teaching courses like Data Structure and 'C', OOPs, Design Analysis & Algorithms, C++, Java, Oracle, HTML and Web Technology.