Introduction to SQL and PL/SQL

Introduction to SQL and PL/SQL provides a complete guide to the practical implementations of DBMS concepts including SQL and PL/SQL edvelopment. This book assumes no prior knowledge of the reader about 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 knowledge. A large number of examples, practical questions, objective questions. FAQs are also 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 types of SQL Queries
• PL/SQL, Cursors
• Triggers and Procedures

About the Authors

Sharad Maheshwari : Sharad Maheshwari has completed his M.Sc. (Comp. Sc.), Master in Information Technology and is now pursuing M.Tech. He has more than four years of experience in the field of Information Technology and Academics. He has an excellent track record of having worked at eminent institute in Noida and Greater Noida where he has an taught B.Tech., MCA, BCAM courses like 'C' Language, Visual Basic, Oracle, HTML, Web Technology, DBMS, Information Systems, E-Commerce, Java and Foundation of Information Technology. Presently, he is employed as a Lecturer in Computer Science Department at an eminent engineering institute in Greater Noida.

Ruchin Jain : Ruchin Jain has completed his M.C.A. and is now pusuing 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 obtained his primary education in Florida (U.S.A.). Presently, he is employed as a 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.