Fundamentals of Database Management System - First Edition 2019

Designed to provide an insight into the database concepts

Key Features

● Book contains real-time executed commands along with screenshot


● Parallel execution and explanation of Oracle and MySQL Database commands


● A Single comprehensive guide for Students, Teachers and Professionals


● Practical oriented book


Description

Book teaches the essentials of DBMS to anyone who wants to become an effective and independent DBMS Master. It covers all the DBMS fundamentals without forgetting few vital advanced topics such as from installation, configuration and monitoring, up to the backup and migration of database covering few database client tools.

What will you learn

● Relational Database,Keys


● Normalization of database


● SQL, SQL Queries, SQL joins


● Aggregate Functions,Oracle and Mysql tools


Who this book is for

● Students of Polytechnic Diploma Classes- Computer Science/ Information Technology


● Graduate Students- Computer Science/ CSE / IT/ Computer Applications


● Master Class Students—Msc (CS/IT)/ MCA/ M.Phil, M.Tech, M.S.


● Industry Professionals- Preparing for Certifications


Table of Contents

1. Fundamentals of data and Database management system

2. Database Architecture and Models

3. Relational Database and normalization

4. Open source technology & SQL

5. Database queries

6. SQL operators

7. Introduction to database joins

8. Aggregate functions, subqueries and users

9. Backup & Recovery

10. Database installation

11. Oracle and MYSQL tools

12. Exercise

About the Author

Dr. Mukesh Negi is an Oracle, IBM, ITIL & Prince2 Certified Engineer with more than sixteen years of experience in multiple Advance and Emerging IT Technologies such as DBMS & Big Data, Cloud Computing, Virtualization, Internet of Things, Artificial Intelligence, Machine Learning, Business Intelligence & Analytics, IT Security etc. In the Education field, He is serving as an Editorial Board Member of many international journals. He has conducted several Faculty Development Programs and serving as a Guest & Visiting Faculty in many reputed University and Colleges in India.Designed to provide an insight into the database concepts

Key Features

● Book contains real-time executed commands along with screenshot


● Parallel execution and explanation of Oracle and MySQL Database commands


● A Single comprehensive guide for Students, Teachers and Professionals


● Practical oriented book


Description

Book teaches the essentials of DBMS to anyone who wants to become an effective and independent DBMS Master. It covers all the DBMS fundamentals without forgetting few vital advanced topics such as from installation, configuration and monitoring, up to the backup and migration of database covering few database client tools.

What will you learn

● Relational Database,Keys


● Normalization of database


● SQL, SQL Queries, SQL joins


● Aggregate Functions,Oracle and Mysql tools


Who this book is for

● Students of Polytechnic Diploma Classes- Computer Science/ Information Technology


● Graduate Students- Computer Science/ CSE / IT/ Computer Applications


● Master Class Students—Msc (CS/IT)/ MCA/ M.Phil, M.Tech, M.S.


● Industry Professionals- Preparing for Certifications


Table of Contents

1. Fundamentals of data and Database management system

2. Database Architecture and Models

3. Relational Database and normalization

4. Open source technology & SQL

5. Database queries

6. SQL operators

7. Introduction to database joins

8. Aggregate functions, subqueries and users

9. Backup & Recovery

10. Database installation

11. Oracle and MYSQL tools

12. Exercise

About the Author

Dr. Mukesh Negi is an Oracle, IBM, ITIL & Prince2 Certified Engineer with more than sixteen years of experience in multiple Advance and Emerging IT Technologies such as DBMS & Big Data, Cloud Computing, Virtualization, Internet of Things, Artificial Intelligence, Machine Learning, Business Intelligence & Analytics, IT Security etc. In the Education field, He is serving as an Editorial Board Member of many international journals. He has conducted several Faculty Development Programs and serving as a Guest & Visiting Faculty in many reputed University and Colleges in India.Designed to provide an insight into the database concepts

Key Features

● Book contains real-time executed commands along with screenshot


● Parallel execution and explanation of Oracle and MySQL Database commands


● A Single comprehensive guide for Students, Teachers and Professionals


● Practical oriented book


Description

Book teaches the essentials of DBMS to anyone who wants to become an effective and independent DBMS Master. It covers all the DBMS fundamentals without forgetting few vital advanced topics such as from installation, configuration and monitoring, up to the backup and migration of database covering few database client tools.

What will you learn

● Relational Database,Keys


● Normalization of database


● SQL, SQL Queries, SQL joins


● Aggregate Functions,Oracle and Mysql tools


Who this book is for

● Students of Polytechnic Diploma Classes- Computer Science/ Information Technology


● Graduate Students- Computer Science/ CSE / IT/ Computer Applications


● Master Class Students—Msc (CS/IT)/ MCA/ M.Phil, M.Tech, M.S.


● Industry Professionals- Preparing for Certifications


Table of Contents

1. Fundamentals of data and Database management system

2. Database Architecture and Models

3. Relational Database and normalization

4. Open source technology & SQL

5. Database queries

6. SQL operators

7. Introduction to database joins

8. Aggregate functions, subqueries and users

9. Backup & Recovery

10. Database installation

11. Oracle and MYSQL tools

12. Exercise

About the Author

Dr. Mukesh Negi is an Oracle, IBM, ITIL & Prince2 Certified Engineer with more than sixteen years of experience in multiple Advance and Emerging IT Technologies such as DBMS & Big Data, Cloud Computing, Virtualization, Internet of Things, Artificial Intelligence, Machine Learning, Business Intelligence & Analytics, IT Security etc. In the Education field, He is serving as an Editorial Board Member of many international journals. He has conducted several Faculty Development Programs and serving as a Guest & Visiting Faculty in many reputed University and Colleges in India.Designed to provide an insight into the database concepts

Key Features

● Book contains real-time executed commands along with screenshot


● Parallel execution and explanation of Oracle and MySQL Database commands


● A Single comprehensive guide for Students, Teachers and Professionals


● Practical oriented book


Description

Book teaches the essentials of DBMS to anyone who wants to become an effective and independent DBMS Master. It covers all the DBMS fundamentals without forgetting few vital advanced topics such as from installation, configuration and monitoring, up to the backup and migration of database covering few database client tools.

What will you learn

● Relational Database,Keys


● Normalization of database


● SQL, SQL Queries, SQL joins


● Aggregate Functions,Oracle and Mysql tools


Who this book is for

● Students of Polytechnic Diploma Classes- Computer Science/ Information Technology


● Graduate Students- Computer Science/ CSE / IT/ Computer Applications


● Master Class Students—Msc (CS/IT)/ MCA/ M.Phil, M.Tech, M.S.


● Industry Professionals- Preparing for Certifications


Table of Contents

1. Fundamentals of data and Database management system

2. Database Architecture and Models

3. Relational Database and normalization

4. Open source technology & SQL

5. Database queries

6. SQL operators

7. Introduction to database joins

8. Aggregate functions, subqueries and users

9. Backup & Recovery

10. Database installation

11. Oracle and MYSQL tools

12. Exercise

About the Author

Dr. Mukesh Negi is an Oracle, IBM, ITIL & Prince2 Certified Engineer with more than sixteen years of experience in multiple Advance and Emerging IT Technologies such as DBMS & Big Data, Cloud Computing, Virtualization, Internet of Things, Artificial Intelligence, Machine Learning, Business Intelligence & Analytics, IT Security etc. In the Education field, He is serving as an Editorial Board Member of many international journals. He has conducted several Faculty Development Programs and serving as a Guest & Visiting Faculty in many reputed University and Colleges in India.Designed to provide an insight into the database concepts

Key Features

● Book contains real-time executed commands along with screenshot


● Parallel execution and explanation of Oracle and MySQL Database commands


● A Single comprehensive guide for Students, Teachers and Professionals


● Practical oriented book


Description

Book teaches the essentials of DBMS to anyone who wants to become an effective and independent DBMS Master. It covers all the DBMS fundamentals without forgetting few vital advanced topics such as from installation, configuration and monitoring, up to the backup and migration of database covering few database client tools.

What will you learn

● Relational Database,Keys


● Normalization of database


● SQL, SQL Queries, SQL joins


● Aggregate Functions,Oracle and Mysql tools


Who this book is for

● Students of Polytechnic Diploma Classes- Computer Science/ Information Technology


● Graduate Students- Computer Science/ CSE / IT/ Computer Applications


● Master Class Students—Msc (CS/IT)/ MCA/ M.Phil, M.Tech, M.S.


● Industry Professionals- Preparing for Certifications


Table of Contents

1. Fundamentals of data and Database management system

2. Database Architecture and Models

3. Relational Database and normalization

4. Open source technology & SQL

5. Database queries

6. SQL operators

7. Introduction to database joins

8. Aggregate functions, subqueries and users

9. Backup & Recovery

10. Database installation

11. Oracle and MYSQL tools

12. Exercise

About the Author

Dr. Mukesh Negi is an Oracle, IBM, ITIL & Prince2 Certified Engineer with more than sixteen years of experience in multiple Advance and Emerging IT Technologies such as DBMS & Big Data, Cloud Computing, Virtualization, Internet of Things, Artificial Intelligence, Machine Learning, Business Intelligence & Analytics, IT Security etc. In the Education field, He is serving as an Editorial Board Member of many international journals. He has conducted several Faculty Development Programs and serving as a Guest & Visiting Faculty in many reputed University and Colleges in India.