Dr. Madhavi Vaidya - RDBMS In-Depth: Mastering SQL and PL/SQL Concepts, Database Design, ACID Transactions, and Practice Real Implementation of RDBM (English Edition)
Here you can read online Dr. Madhavi Vaidya - RDBMS In-Depth: Mastering SQL and PL/SQL Concepts, Database Design, ACID Transactions, and Practice Real Implementation of RDBM (English Edition) full text of the book (entire story) in english for free. Download pdf and epub, get meaning, cover and reviews about this ebook. year: 2021, publisher: BPB Publications, genre: Computer. Description of the work, (preface) as well as reviews are available. Best literature library LitArk.com created for fans of good reading and offers a wide selection of genres:
Romance novel
Science fiction
Adventure
Detective
Science
History
Home and family
Prose
Art
Politics
Computer
Non-fiction
Religion
Business
Children
Humor
Choose a favorite category and find really read worthwhile books. Enjoy immersion in the world of imagination, feel the emotions of the characters or learn something new for yourself, make an fascinating discovery.
- Book:RDBMS In-Depth: Mastering SQL and PL/SQL Concepts, Database Design, ACID Transactions, and Practice Real Implementation of RDBM (English Edition)
- Author:
- Publisher:BPB Publications
- Genre:
- Year:2021
- Rating:3 / 5
- Favourites:Add to favourites
- Your mark:
RDBMS In-Depth: Mastering SQL and PL/SQL Concepts, Database Design, ACID Transactions, and Practice Real Implementation of RDBM (English Edition): summary, description and annotation
We offer to read an annotation, description, summary or preface (depends on what the author of the book "RDBMS In-Depth: Mastering SQL and PL/SQL Concepts, Database Design, ACID Transactions, and Practice Real Implementation of RDBM (English Edition)" wrote himself). If you haven't found the necessary information about the book — write in the comments, we will try to find it.
Understanding and implementing the database management systems concepts in SQL and PL/SQLKey FeaturesPractice 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 Oracles 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.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.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?
About the Author
Dr. Madhavi Vaidya is an experienced and qualified Assistant Professor with a demonstrated history of working in the education management industry . Skilled in programming languages like C, Python, SQL, Oracle Database,
Dr. Madhavi has understanding and knowledge of Data Analytics, Information Retrieval, Software Engineering and Project Management.
She has strong education professional with a Master of Computer Applications and Doctor of Philosophy in the subject of Computer Science and Engineering. One of the key areas of her research is Big Data analytics using Hadoop-MapReduce and various Big Data technologies.
She is a Content Writer @Udemy and various other online courses are in her credit including BPB publications.
Ample research papers are in her credit, presented and published in various National and International conference along with research chapters and articles in ACM, IEEE, Elsevier and Developer IQ magazine.
Reviewing articles and research papers- Acting as a reviewer for the journals like IEEE Access, ASSA, IGI Global and many other prestigious journals.
LinkedIn Profile: https://www.linkedin.com/in/dr-madhavi-v-01882327
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 Oracles 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.What you will learn
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?
About the Author
Dr. Madhavi Vaidya is an experienced and qualified Assistant Professor with a demonstrated history of working in the education management industry . Skilled in programming languages like C, Python, SQL, Oracle Database,
Dr. Madhavi has understanding and knowledge of Data Analytics, Information Retrieval, Software Engineering and Project Management.
She has strong education professional with a Master of Computer Applications and Doctor of Philosophy in the subject of Computer Science and Engineering. One of the key areas of her research is Big Data analytics using Hadoop-MapReduce and various Big Data technologies.
She is a Content Writer @Udemy and various other online courses are in her credit including BPB publications.
Ample research papers are in her credit, presented and published in various National and International conference along with research chapters and articles in ACM, IEEE, Elsevier and Developer IQ magazine.
Reviewing articles and research papers- Acting as a reviewer for the journals like IEEE Access, ASSA, IGI Global and many other prestigious journals.
LinkedIn Profile: https://www.linkedin.com/in/dr-madhavi-v-01882327
Dr. Madhavi Vaidya: author's other books
Who wrote RDBMS In-Depth: Mastering SQL and PL/SQL Concepts, Database Design, ACID Transactions, and Practice Real Implementation of RDBM (English Edition)? Find out the surname, the name of the author of the book and a list of all author's works by series.
Alex Bolenok
Kevin Kline
Kevin Kline
Kevin Kline
Jan L. Harrington
Elvis C. Foster
Sandeep Chanda
Ramez Elmasri
Merida Johns
RDBMS In-Depth: Mastering SQL and PL/SQL Concepts, Database Design, ACID Transactions, and Practice Real Implementation of RDBM (English Edition) — read online for free the complete book (whole text) full work
Below is the text of the book, divided by pages. System saving the place of the last page read, allows you to conveniently read the book "RDBMS In-Depth: Mastering SQL and PL/SQL Concepts, Database Design, ACID Transactions, and Practice Real Implementation of RDBM (English Edition)" online for free, without having to search again every time where you left off. Put a bookmark, and you can go to the page where you finished reading at any time.
Light
Font size:
↓
↑
Reset
Interval:
↓
↑
Bookmark:
Make
RDBMS
In-Depth
Mastering SQL and PL/SQL Concepts,
Database Design, ACID Transactions, and
Practice Real Implementation of RDBMS
Dr. Madhavi Vaidya
www.bpbonline.com
FIRST EDITION 2021
Copyright BPB Publications, India
ISBN: 978-81-94837-701
All Rights Reserved. No part of this publication may be reproduced, distributed or transmitted in any form or by any means or stored in a database or retrieval system, without the prior written permission of the publisher with the exception to the program listings which may be entered, stored and executed in a computer system, but they can not be reproduced by the means of publication, photocopy, recording, or by any electronic and mechanical means.
LIMITS OF LIABILITY AND DISCLAIMER OF WARRANTY
The information contained in this book is true to correct and the best of authors and publishers knowledge. The author has made every effort to ensure the accuracy of these publications, but publisher cannot be held responsible for any loss or damage arising from any information in this book.
All trademarks referred to in the book are acknowledged as properties of their respective owners but BPB Publications cannot guarantee the accuracy of this information.
Distributors:
BPB PUBLICATIONS
20, Ansari Road, Darya Ganj
New Delhi-110002
Ph: 23254990/23254991
MICRO MEDIA
Shop No. 5, Mahendra Chambers,
DN Rd. Next to Capital Cinema,
V.T. (C.S.T.) Station, MUMBAI-400
Ph: 22078296/22078297
DECCAN AGENCIES
4-3-329, Bank Street,
Hyderabad-500195
Ph: 24756967/24756400
BPB BOOK CENTRE
Old Lajpat Rai Market,
Delhi-110006
Ph: 23861747
Published by Manish Jain for BPB Publications, Ansari Road, Darya Ganj, New Delhi-110002 and Printed by him at Repro India Ltd, Mumbai
www.bpbonline.com
Dedicated to
All my students to whom I taught
this subject in classroom
About the Author
Dr. Madhavi Vaidya is an experienced and qualified Assistant Professor with a demonstrated history of working in the education management industry for skilled-in programming languages like C, Python, SQL, Oracle Database. She has understanding and knowledge of Data Analytics, Information Retrieval, Software Engineering and Project Management.
She has strong education professional with a Master of Computer Applications and Doctor of Philosophy in the subject of Computer Science and Engineering. One of the key areas of her research is Big Data analytics using Hadoop-MapReduce and various Big Data technologies.
She is a Content Writer @Udemy and various other online courses are in her credit including BPB Publications.
Ample research papers are in her credit, presented and published in various National and International conference along with research chapters and articles in ACM, IEEE, Elsevier and Developer IQ magazine.
About the Reviewers
Prateek Chandra is currently working as a Senior Consultant and a data architect in IQVIA, A Human Data Science Company. In his capacity, he is Technical lead and responsible for leading the new initiative and guide the team for project completion. His key expertise involves both SQL(Oracle, Sybase, SQL Server) and NoSQL (MongoDB,Cassandra) databases. He is a core member of product/tools team, which is required to create automation in order to reduce the manual touch point for patient safety in Pharmacovigilance domain.
Prateek Chandra, alumni of JUIT Waknaghat, with over years of multi-domain experience(Healthcare, Pharma, Banking etc) was Assistant Vice President in CITI bank and played a key role in Cloud migration of the database. He was the owner of multiple application built on top of Capital Markets data-Mart. He was also part of United Health Group and HCL technologies in various capacities. Being part of these organisations helped him to gain a deep understanding of DWBI and other technologies.
Mainak Bagchi currently working as Technical Architect and departmental Head in Capital Numbers Infotech Pvt. Ltd. and presently I am engaged with Python and relevant technical stack including django, flask, automation, ETL also expertise in AWS and various RDBMS and NoSQL. Proficient in designing numerous solutions based on Restful, Multi tenant and PaaS architecture.
I am having years of IT experience. After completing my graduation in Science from University of Calcutta, joined DoE conducted post graduate advance diploma in 2001. Successfully completing PGADCA started my career journey on year 2004 and worked for Sify Technlogies as senior software engineer and HCL technlogies as lead engineer. Worked in more than projects in in various roles and responsibilities. Thales Top series product development, DHL redprairie web enablement ect are enterprise level product where my name is attached with.
Acknowledgement
I owe my gratitude to many people who have helped me in writing this book on Relational Database Management Systems In-Depth and I hope this book will help all the readers and students of this subject in learning and gaining more knowledge on Databases.
I would also like to thank my students who have helped me in this journey & helped me to understand their queries and questions which were of immense help for me in writing this book and setting the necessary tone required.
I would also thank my son, Mihir and Husband, Arun, for their support and patience and their immeasurable patience which has allowed me to increase my knowledge and further my research. Last but not the least, I would like to thank my Mother and my sisters for their encouragement, blessings and support in times of need.
Lastly, I would like to thank Mr. Mainak and Mr. Prateek Chandra who have helped me in reviewing the book and gave me some wise insights. Special thanks to BPB Publication to publishing this book.
Preface
Google has given the definition of Database as A database is an organized collection of structured information, or data, typically stored electronically in a computer system. Google defines database as a structured set of data held in a computer, especially one that is accessible in various ways. When we speak about databases, it is something very huge which allows us to store any type of data; when we talk about different types of storage formats or related technologies. We live in an era where data is the most valuable asset and its being put at heart of every decision-making process. Despite of the explosion of NoSQL in the recent years, SQL is still a great analytical query language that has become the universal interface for data analysis.
Light
Font size:
↓
↑
Reset
Interval:
↓
↑
Bookmark:
Make
Similar books «RDBMS In-Depth: Mastering SQL and PL/SQL Concepts, Database Design, ACID Transactions, and Practice Real Implementation of RDBM (English Edition)»
Look at similar books to RDBMS In-Depth: Mastering SQL and PL/SQL Concepts, Database Design, ACID Transactions, and Practice Real Implementation of RDBM (English Edition). We have selected literature similar in name and meaning in the hope of providing readers with more options to find new, interesting, not yet read works.
Alex Bolenok
Kevin Kline
Kevin Kline
Kevin Kline
Jan L. Harrington
Elvis C. Foster
Sandeep Chanda
Ramez Elmasri
Merida Johns
Reviews about «RDBMS In-Depth: Mastering SQL and PL/SQL Concepts, Database Design, ACID Transactions, and Practice Real Implementation of RDBM (English Edition)»
Discussion, reviews of the book RDBMS In-Depth: Mastering SQL and PL/SQL Concepts, Database Design, ACID Transactions, and Practice Real Implementation of RDBM (English Edition) and just readers' own opinions. Leave your comments, write what you think about the work, its meaning or the main characters. Specify what exactly you liked and what you didn't like, and why you think so.