Fundamentals of Database Management System

Name: Fundamentals of Database Management System | Learn essential concepts of database systems
Brand: De Gruyter
Price: 14.49 EUR
Availability: OnlineOnly

Learn essential concepts of database systems

Dr. Mukesh Chandra Negi(Autor*in)

De Gruyter (Verlag)

1. Auflage

Erschienen am 15. Januar 2019

176 Seiten

E-Book

ePUB mit Adobe-DRM

Systemvoraussetzungen

978-93-89328-00-4 (ISBN)

14,49 €inkl. 7% MwSt.

Systemvoraussetzungen

für ePUB mit Adobe-DRM

E-Book Einzellizenz

Als Download verfügbar

Beschreibung

Weitere Details

Weitere Ausgaben

Inhalt

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

Systemvoraussetzungen

Als PDF speichern Als Link merken