Database Management
- The database approach and DBMS fundamentals
- Personal, shared, workgroup and enterprise databases
- Data redundancy, integrity and independence
- Core DBMS components
Area 03
Data & Information Systems
Database management, SQL, Oracle, data modeling, systems analysis, data warehousing and business intelligence.
From fundamentals to business intelligence
The recovered archive contains a substantial instructional collection devoted to database systems. It includes database-management fundamentals, development methods, entity-relationship modeling, SQL, Oracle references and later material on data warehousing and business intelligence.
This part of the rebuilt site turns that directory of legacy files into a navigable subject area, while preserving the original source documents for historical and educational reference.
Course outline
The legacy data-systems links have been removed. The principal topics from the recovered course materials are summarized below.
Database Design
- Identify information requirements
- Organize data into logical structures
- Define tables, keys and relationships
- Design for consistency, maintenance and use
Entity-Relationship Modeling
- Entities and relationships
- Cardinality and existence
- Attributes and composite attributes
- Conceptual and physical data models
Structured Query Language (SQL)
- SQL structure and purpose
- Retrieval, filtering and sorting
- Working across related tables
- Data definition and modification concepts
Oracle
- Oracle as an enterprise DBMS
- Database objects and organization
- SQL in the Oracle environment
- Administration and development concepts
Data Warehousing & Business Intelligence
- Operational data versus analytical information
- Data warehouse architecture
- Integration of multiple data sources
- Business intelligence and decision support