Fundamentals of Database Management System: Learn essential concepts of Database Systems

Designed to provide an insight into the database concepts Key FeaturesBook contains real-time executed commands along with screenshotParallel execution and explanation of Oracle and MySQL Database commandsA Single comprehensive guide for Students, Teachers and ProfessionalsPractical oriented bookDescription 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 learnRelational Database, KeysNormalization of databaseSQL, SQL Queries, SQL joinsAggregate Functions, Oracle and Mysql toolsWho this book is forStudents of Polytechnic Diploma Classes- Computer Science/ Information TechnologyGraduate Students- Computer Science/ CSE / IT/ Computer ApplicationsMaster Class Students-Msc (CS/IT)/ MCA/ M.Phil, M.Tech, M.S.Industry Professionals- Preparing for CertificationsTable of Contents1. Fundamentals of data and Database management system2. Database Architecture and Models3. Relational Database and normalization4. Open source technology & SQL5. Database queries6. SQL operators7. Introduction to database joins 8. Aggregate functions, subqueries and users9. Backup & Recovery10. Database installation 11. Oracle and MYSQL tools12. ExerciseAbout the AuthorDr. 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.