Books
Madhavi Vaidya

RDBMS In-Depth: Mastering SQL and PL/SQL Concepts, Database Design, ACID Transactions, and Practice Real Implementation of RDBM (English Edition)

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.
327 printed pages
Copyright owner
BPB Publications
Original publication
2021
Have you already read it? How did you like it?
👍👎

Quotes

  • DDaudalagidhas quotedlast year
    An entity-relationship model is data driven. The model implies processes but does not clarify the processes.
  • DDaudalagidhas quotedlast year
    Used with data flow diagrams under structured approach, an entity-relationship model gives the analyst an alternative logical view of the system. If a great deal is known about the data, but not much about the processes, an entity-relationship diagram is an excellent start point for modelling the system.
  • DDaudalagidhas quotedlast year
    Armstrong’s Axioms are a set of rules, that when applied repeatedly, generates a closure of functional dependencies. The functional dependency (FD) is a relationship between two attributes, typically between the primary key and other non-key attributes within a table.
fb2epub
Drag & drop your files (not more than 5 at once)