Structured Query language for all RDBMS and PL/SQL

ABOUT THE BOOK:- Structured Query language for all RDBMS and PL/SQL (SQL PL/SQL) book is in-depth treatment of the SQL language for both technical and non-technical users programmers IT Professionals or engineering students who wants to do Oracle certification and want to understand the impact of SQL in computer market. This book offers a conceptual framework for understanding of PL/SQL. It will show you step-by-step how to use SQL and PL/SQL features with many illustrations and realistic examples to clarify SQL and PL/SQL concepts. The book also compares SQL products from leading RDBMS vendors describing their advantages benefits to help you select the right query (SQL Statement) for your application. So user can try them for themselves and gain actual experience in using major database products like Oracle Microsoft SQL Server My SQL SQLLite and MS Access. It has a chapter on “some important questions and answers” which will really help users to increase their knowledge and implement on Data base and also to face interviews. It has also a chapter on “Practice Set doing Oracle certification “which will really help user to increase their knowledge to do Oracle certification. ABOUT THE AUTHOR:- Kriti Sinha is an Oracle certified DBA and IT Professional with 8+ years of work experience on Oracle Microsoft SQL server and PL/SQL along with over 10 + years of experience in Teaching and training to IT professionals for SQL and PL/SQL. She is having Masters of Computer Application along with Oracle Certification for DBA and advanced PL/SQL programming. She is working on database SQL Server and Oracle since last 14 years. She likes reading books and keeps herself busy. CONTENTS:- Acknowledgment and Dedications 11 Chapter 1- Introduction of RDBMS What is RDBMS? 13 1.1 RDBMS 1.2 Table 1.2.1 Max limit for number of column for single table 1.2.2 Properties of the Relational Tables 1.3 Field 1.4 Rows 1.5 Column Chapter 2- Normalization 17 2.1 Types of Normalizatio