Database Management
- The database approach
- Database management systems
- Types of databases
- Personal, workgroup and enterprise databases
- Data redundancy, integrity and independence
Professional materials library
Sample Courses and Materials
Selected course, seminar and professional materials organized by subject.
01
Project Management
Core project-management texts and course material.
02
IT Strategy & Electronic Commerce
Seminars, presentations and worksheets on technology strategy and e-commerce.
Strategic Management of Information TechnologyHTML seminar materialOpen →Executing an E-Commerce StrategyHTML seminar materialOpen →Formulating EC StrategyPresentation • opens in browserOpen →Technology of Electronic CommercePresentation • opens in browserOpen →EC Strategy ImplementationPresentation • opens in browserOpen →E-Commerce Strategy WorksheetWord documentDownload →E-Commerce Architecture WorksheetWord documentDownload →
03
Data & Information Systems
Course topics are summarized here as outlines rather than links to legacy pages.
Database Design
- Requirements and information needs
- Logical organization of data
- Tables, keys and relationships
- Design for reliable use and maintenance
Entity-Relationship Modeling
- Entities and relationships
- Cardinality and existence
- Attributes
- Composite and multivalued attributes
- Conceptual and physical models
Structured Query Language (SQL)
- Purpose and structure of SQL
- Retrieving data
- Filtering and sorting results
- Working with related tables
- Data definition and modification concepts
Oracle
- Oracle as a modern DBMS
- Database objects and organization
- Using SQL in an Oracle environment
- Database administration concepts
Data Warehousing & Business Intelligence
- Operational data versus analytical information
- Data warehouse concepts
- Integrating information from multiple sources
- Supporting analysis and managerial decision-making