RDBMS In-Depth Dr. Madhavi Vaidya
(ebook)
(audiobook)
(audiobook)
- Autor:
- Dr. Madhavi Vaidya
- Wydawnictwo:
- BPB Publications
- Ocena:
- Stron:
- 296
- Dostępne formaty:
-
ePubMobi
Zostało Ci
na świąteczne zamówienie
opcje wysyłki »
Opis
książki
:
RDBMS In-Depth
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 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. 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.
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. 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
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
BPB Publications - inne książki
Dzięki opcji "Druk na żądanie" do sprzedaży wracają tytuły Grupy Helion, które cieszyły sie dużym zainteresowaniem, a których nakład został wyprzedany.
Dla naszych Czytelników wydrukowaliśmy dodatkową pulę egzemplarzy w technice druku cyfrowego.
Co powinieneś wiedzieć o usłudze "Druk na żądanie":
- usługa obejmuje tylko widoczną poniżej listę tytułów, którą na bieżąco aktualizujemy;
- cena książki może być wyższa od początkowej ceny detalicznej, co jest spowodowane kosztami druku cyfrowego (wyższymi niż koszty tradycyjnego druku offsetowego). Obowiązująca cena jest zawsze podawana na stronie WWW książki;
- zawartość książki wraz z dodatkami (płyta CD, DVD) odpowiada jej pierwotnemu wydaniu i jest w pełni komplementarna;
- usługa nie obejmuje książek w kolorze.
Masz pytanie o konkretny tytuł? Napisz do nas: sklep@helion.pl
Proszę wybrać ocenę!
Proszę wpisać opinię!
Książka drukowana
Proszę czekać...
Oceny i opinie klientów: RDBMS In-Depth Dr. Madhavi Vaidya (0) Weryfikacja opinii następuję na podstawie historii zamówień na koncie Użytkownika umieszczającego opinię. Użytkownik mógł otrzymać punkty za opublikowanie opinii uprawniające do uzyskania rabatu w ramach Programu Punktowego.