Opis
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 StudentsMsc (CS/IT)/ MCA/ M.Phil, M.Tech, M.S.
Industry Professionals- Preparing for Certifications
Table of Contents
Fundamentals of data and Database management system
Database Architecture and Models
Relational Database and normalization
Open source technology & SQL
Database queries
SQL operators
Introduction to database joins
Aggregate functions, subqueries and users
Backup & Recovery
Database installation
Oracle and MYSQL tools
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.
