Menu Close

RDBMS In-Depth

RDBMS In-Depth
  • Author: Dr. Madhavi Vaidya
  • Publisher: BPB Publications
  • ISBN: 9788194837701
  • Page: 296
  • View: 105

Understanding and implementing the database management systems concepts in SQL and PL/SQL Ê KEY FEATURESÊÊ _ Practice SQL concepts by writing queries and perform your own data visualization and analysis. _ Gain insights on Entity ...

Understanding and implementing the database management systems concepts in SQL and PL/SQL KEY FEATURES ● Practice SQL concepts by writing queries and perform your own data visualization and analysis. ● Gain insights on Entity Relationship Model and how to implement in your business environment. ● Series of question banks and case-studies to develop strong hold on RDBMS concepts. DESCRIPTION Relational Database Management Systems In-Depth brings the fundamental concepts of database management systems to you in more elaborated learning with conceptual clarity of RDBMS. This book brings an extensive coverage of theoretical concepts on types of databases, concepts of relational database management systems, normalization and many more. You will explore exemplification of Entity Relational Model concepts that would teach the readers to design accurate business systems. Backed with a series of examples, you can practice the fundamental concepts of RDBMS and SQL queries including Oracle’s SQL queries, MySQL and SQL Server. In addition to the illustration of concepts on SQL, there is an implementation of crucial business rules using PL/SQL based stored procedures and database triggers.Finally, by the end of this book there is a mention of the useful data oriented technologies like Big Data, Data Lake etc and the crucial role played by such techniques in the current data driven decisions. Throughout the book, you will come across key learnings and key terms that will help you to understand and revise the concepts learned. Along with this, you will also come across questions and case studies by the end of every chapter to prepare for job interviews and certifications. WHAT YOU WILL LEARN ● Depiction of Entity Relationship Model with various business case studies. ● Illustration of the normalization concept to make the database stronger and consistent. ● Designing the successful client-server applications using PL/SQL concepts. ● Learning the concepts of OODBS and Database Design with Normalization and Relationships. ● Knowing various techniques regarding Big Data technologies like Hadoop, MapReduce and MongoDB. WHO THIS BOOK IS FOR This book is meant for academicians, students, developers and administrators including beginners and readers experienced in some other programming languages and database systems. TABLE OF CONTENTS 1. Database Systems Architecture 2. Database Management System Models 3. Relational query languages 4. Relational Database Design 5. Query Processing and Optimization 6. Transaction Processing 7. Implementation Techniques 8. SQL Concepts 9. PL/SQL Concepts 10. Collections in PL/SQL 11. What Next?


More Books:

RDBMS In-Depth
Language: en
Pages: 296
Authors: Dr. Madhavi Vaidya
Categories: Computers
Type: BOOK - Published: 2021-02-25 - Publisher: BPB Publications

Understanding and implementing the database management systems concepts in SQL and PL/SQL KEY FEATURES ● Practice SQL concepts by writing queries and perform your own data visualization and analysis. ● Gain insights on Entity Relationship Model and how to implement in your business environment. ● Series of question banks and
Graph Databases
Language: en
Pages: 238
Authors: Ian Robinson, Jim Webber, Emil Eifrem
Categories: Computers
Type: BOOK - Published: 2015-06-10 - Publisher: "O'Reilly Media, Inc."

Discover how graph databases can help you manage and query highly connected data. With this practical book, you’ll learn how to design and implement a graph database that brings the power of graphs to bear on a broad range of problem domains. Whether you want to speed up your response
Unix Relational Database Management
Language: en
Pages: 99
Authors: Judith R. Davis
Categories: Computers
Type: BOOK - Published: 1993 - Publisher:

Books about Unix Relational Database Management
Relational Database Design and Implementation
Language: en
Pages: 712
Authors: Jan L. Harrington
Categories: Computers
Type: BOOK - Published: 2016-05-06 - Publisher: Morgan Kaufmann

" Relational Database Design and Implementation: Clearly Explained, Fourth Edition, " provides the conceptual and practical information necessary to develop a database design and management scheme that ensures data accuracy and user satisfaction while optimizing performance. Database systems underlie the large majority of business information systems. Most of those in
RDBMS Relational Database Management System A Complete Guide - 2020 Edition
Language: en
Pages: 314
Authors: Gerardus Blokdyk
Categories: Computers
Type: BOOK - Published: 2019-10-23 - Publisher: 5starcooks

What is the big RDBMS relational database management system idea? How much are sponsors, customers, partners, stakeholders involved in RDBMS relational database management system? In other words, what are the risks, if RDBMS relational database management system does not deliver successfully? What is your RDBMS relational database management system quality