Author: Dr. Mukesh NegiPublisher: BPB Publications
ISBN: 9388176626
Category : Computers
Languages : en
Pages : 198
Book Description
Designed to provide an insight into the database concepts 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. 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 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