Advanced Database Management System
Are you learning about advance database management system? There is a list of all topics which covering full syllabus. Chose a topic to learn more about DBMS.
Relational Database Design
Database design and implementation
Structured Query Language
Advanced Features Of DBMS
Distributed Databases
Emerging trends & examples of database architecture
Parallel and Distributed Databases
Data Mining
Object-oriented database systems
Advanced Transaction Processing
- Relational database
- Characteristics Of Relations
- Relational Constraints
- Relational Database Schemas
- Operations on relations
- Relational Algebra Operations
- The Project operation
- Set theoritic operations
- The JOIN operation
- The Entity – Relationship Model
- Entity and attributes
- Pitfalls In Relational Database Design
- Normalization
- The Process of Normalization
- First Normal Form (1NF)
- Boyce.Codd Normal Form (BCNF)
- Structured Query Language
- SQL Statement
- Creating and dropping tables in SQL
- The SQL select statement
- SQL select distinct statement
- The AND & OR Operators
- The ORDER BY Keyword
- THE INSERT INTO Syntax
- The UPDATE Statement
- The DELETE Statement
- The TOP Clause
- The LIKE Operator
- SQL wildcards
- The IN Operator
- The BETWEEN Operator
- SQL Alias
- Outer Join
- The MAX( ) function
- The UCASE() Function
- The SUM( ) Function
- Transaction
- Transaction Properties
- Transaction Management with SQL
- Types of transaction log records
- Concurrency control
- Deadlocks
- Concurrency Control with time stamping methods
- Optimistic Concurrency Control
- Database Recovery Management
- Security and Integrity Violations
- Authorization and Views
- Integrity constraints
- Encryption
- Data warehouse
- Contrasting OLTP and Data Warehousing Environments
- Data warehouses architectures
- Logical versus physical design in data warehouses
- Data warehouse Schema
- Data warehousing objects
- Logical and Physical Design of data warehouse
- Introduction To Data Mining
- Data Mining Uses
- Data Mining Functions
- Data Mining Technologies
- Digital libraries
- Emerging Database Models
- Multimedia Database
- Temporal Databases
- Designing Temporal Databases
- Logical design of temporal databases
- Conceptual design of temporal databases
- Temporal databases implementation
- Temporal DBMS implementation
- Implementing Algebraic Operators Page
- Database on the world wide web
- Geographic Information Systems
- Geographic information systems data operation
- Example of a Geographic Information Systems-Arc-Info
- Genome Data Management
- Characteristics of biological data
- Human Genome
- PostgreSQL
- Functions of POSTGRESQL
- Reliability on POSTGRESQL
- open source software
- Parallel Database Architectures
- Parallel Query Evaluation
- Parallelizing Individual Operations
- Parallel Query Optimization
- Introduction To Distributed Databases
- Distributed DBMS Architectures
- Storing Data in Distributed DBMS
- Distributed Catalog Management
- Updating Distributed Data
- Distributed Concurrency Control
- Distributed Recovery
- Two-Phase Commit Revisited
- Three-Phase Commit
- Object-oriented database systems
- New Data Types
- Abstract data type
- Methods of an ADT
- Structured data types
- Manipulating Data of Structured Types
- Objects and Refrence Types
- Inheritance
- Design for an ORDBMS
- Challeges in Implementing an ORDBMS
- OODBMS
- Object Query Language
- Compare RDBMS with ORDBMS
- OODBMS; Advantages & Disadvantages