Database Management System (DBMS) and Oracle are an essential part
of the curriculum for undergraduate and postgraduate courses in
computer science, computer applications, computer science and
engineering, information technology and management. The book is
organised into three parts to introduce theoretical and programming
concepts of DBMS. Part I (Basic Concepts and Oracle SQL) deals with
DBMS basic, software analysis and design, data flow diagrams, ER
models, relational algebra, normal forms, SQL queries, functions,
subqueries, different types of joins, DCL, DDL, DML, object
constraints and security in Oracle. Part II (Application Using
Oracle PL/SQL) explains PL/SQL basics, functions, procedures,
packages, exception handling, triggers, implicit, explicit and
advanced cursors using suitable examples. This part also covers
advanced concepts related to PL/SQL, such as collection, records,
objects, dynamic SQL and performance tuning. Part III (Advanced
Concepts and Technologies) elaborates on advanced database concepts
such as query processing, file organisation, distributed
architecture, backup, recovery, data warehousing, online analytical
processing and data mining concepts and their techniques. New to
the Second Edition The book reorganised into three parts for better
understanding of DBMS concepts. All the existing chapters
thoroughly revised and eight new chapters added. New chapters
discuss Oracle PL/SQL advanced programming concepts, data
warehousing, OLTP, OLAP and data mining concepts. Additional
examples, questions and workouts in each chapter. Key Features
Explains each topic in step-by-step detail. Includes about 300
examples to illustrate concepts. Offers about 400 objective type
questions to test students on key points. Provides about 100
challenging workouts that invite deeper analysis and interpretation
of the subject matter. Teaching Aid Material for all the chapters
is provided on PHI Learning's website, which can be used by
faculties/teachers for delivering lectures. Visit
www.phindia.com/gupta to explore the contents.
General
Is the information for this product incomplete, wrong or inappropriate?
Let us know about it.
Does this product have an incorrect or missing image?
Send us a new image.
Is this product missing categories?
Add more categories.
Review This Product
No reviews yet - be the first to create one!