Description
Learning Goals
● Data Base project. Steps involved:
1. Problem Definition (3 hours)
- User Needs and Data Requirements
- Data Integrity, Accuracy, Redundancy and Availability
- Data Retrieval and Usage
2. Data Collection, using Excel, access (2 hours)
- Data Sources and Collection Methods
- Data Storage
3. Data organizing and processing, use Excel, MS Access (4 hours)
- Handling Missing Data and Duplicates
- Fixing Data Type Issues
- Resolving Inconsistent Data
- Normalizing data
4. Data Analysis, use Excel, MS access, MySQL (3 hours)
- Filtering and sorting data
- Pivot tables
- Using charts
5. Feature Selection, use MySQL (6 hours)
- Structured Query language statement
- Select statement
- Using SQL Joins
6. Communication and Reporting, use MS access (3 hours)
- Create professional quality output with reports
7. Maintenance and Updates (6 hours)
- Backup and Recovery
- Index Optimization and Performance Tuning
- Monitoring and Query Optimization
- Schema updates (insert, update, delete)
- Software updates
- Data Migration
8. Documentation and Knowledge Sharing, use MySQL, MS Word (4 hours)
- Schema, Stored Procedures & Triggers Documentation
- Backup and Recovery Documentation
- Code Comments and README Files
- Training and Workshops
9. Ethical Considerations (3 hours)
- Data privacy and protection
- Security and User Access Control
- Project based closure, security and privileges
