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

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.

 

Osoby które kupowały "Fundamentals of Database Management System", wybierały także:

• Cisco CCNA 200-301. Kurs video. Administrowanie bezpieczeÅ„stwem sieci. Część 3 665,00 zÅ‚, (39,90 zÅ‚ -94%)
• Cisco CCNA 200-301. Kurs video. Administrowanie urzÄ…dzeniami Cisco. Część 2 665,00 zÅ‚, (39,90 zÅ‚ -94%)
• Cisco CCNA 200-301. Kurs video. Podstawy sieci komputerowych i konfiguracji. Część 1 665,00 zÅ‚, (39,90 zÅ‚ -94%)
• Impact of P2P and Free Distribution on Book Sales 427,14 zÅ‚, (29,90 zÅ‚ -93%)
• Cisco CCNP Enterprise 350-401 ENCOR. Kurs video. Programowanie i automatyzacja sieci 443,33 zÅ‚, (39,90 zÅ‚ -91%)

• 
• 
• 
• 
• 

Spis treści

Fundamentals of Database Management System eBook -- spis treści

• Cover
• Fundamentals of Database Management System
• Copyright
• Acknowledgement
• Preface
• Table of Contents
• toc.xhtml
• 1.1 What is Data?
• 1.2 Types of Data
• 1.3 What is a Database?
• 1.4 What is a Database Management System (DBMS)?
• 1.5 Advantages of Database
• 1.6 Disadvantages of DBMS
• 2. Database Architecture and Models
• 2.1 Database Architecture
• 2.2 Two-Tier architecture
• 2.3 Three Tier Architecture
• 2.4 Data Flow from External to Internal World
• 2.5 Database Models
• 3. Relational Databases and Normalization
• Database Keys and Constraints
• 3.1 Keys
• 3.2 Need of Key
• 3.3 Constraints
• 3.4 Super Key
• 3.5 Candidate Key
• 3.6 Composite Key
• 3.7 Primary Key
• 3.8 Foreign Key
• 3.9 Unique constraint
• 3.10 Not null constraint
• 3.11 Default Constraint
• 3.12 Check Constraint
• 3.13 Database Design (Normalization Rules)
• 4. Open Source Terminology and Introduction to SQL (Structure Query Language)
• 4.1 About Oracle, MySQL and Open Source Technology
• 4.2 Introduction to SQL (Structured Query Language)
• 4.2.1 DDL: Data Definition Language
• 4.2.2 DML: Data Manipulation Language
• 4.2.3 TCL: Transaction Control Language
• 4.2.4 DCL: Data Control Language
• 4.3 Data Types
• 5. Database Queries
• 5.1 Structured Query Language (SQL)
• SQL Operators
• 6.1 SQL Operators
• 6.1.1 Arithmetic Operators
• 6.1.2 Character Operators
• 6.1.3 Comparison Operators
• 6.1.4 Logical Operators
• 6.1.5 Set Operators
• 7. Introduction to Database Joins
• 7.1 SQL Joins
• 7.1.1 Inner Join (Also called SIMPLE JOIN)
• 7.1.2 Left Outer Join (Also called LEFT JOIN)
• 7.1.3 Right Outer Join (Also called RIGHT JOIN)
• 7.1.4 Full Outer Join (Also called FULL JOIN)
• 7.1.5 Inner Join (Simple Join)
• 7.1.6 Left Outer Join (Left Join)
• 7.1.7 Right Outer Join (Also called Right Join)
• 7.1.8 Full Outer Join (Also called Full Join)
• 8. Aggregate functions, Subqueries and Users
• 8.1 Aggregate Functions
• 8.2 SQL Sub Queries
• 8.3 Database Users
• 9. Backup & Recovery
• 9.1 Tablespace, Datafiles, and Control Files
• 9.2 Oracle SQL Loader
• 9.3 Database Backup and Recovery
• 9.4 Recycle Bin
• 9.5 MYSQL
• 9.6 High Availability Configuration (Clustering, Load Balancing & Failover)
• 10. Database Installation
• 10.1 MySQL 5.7 Installation
• 10.2 Oracle Express Edition Installation
• 10.3 Remote Database Server Connectivity
• 10.4 Oracle SQL PLUS Utility
• 11. Oracle and MySQL Tools
• 11.1 SQL Developer (Oracle)
• 11.2 MySQL Client Tool (Workbench)
• 11.3 Working with MySQL Workbench
• 11.4 DBeaver (Client for Oracle, MySQL, and Other Databases as well)
• 12. Exercise
• 12.1 SQL Exercise
• 12.2 Abbreviations