Designing Files and Databases That Perform
1Summary
Ask why a report takes ten seconds to generate instead of one, and the answer is almost always buried in how the underlying files were physically organised, not in the software running on top of them. Whether records are laid out consecutively, sequentially, directly or through an index determines how fast a system can retrieve them, how much capacity it needs, and how securely that data can be controlled.
This course from the Arab British Fellowship Training Academy covers physical design in its modern form, built around updated curricula and the current technology used in computer and network systems. Physical design, at its core, is about how data is stored, related and accessed, applying the right organisation method to every type of file, from tables and reports to supporting files, so operations run on high-quality, well-defined and secure data.
2Objectives and target group
Who Should Attend:
- Systems managers at companies and directors of IT departments.
- Employees responsible for managing systems' data and files.
- Computer science institute and faculty students.
By the End of the Course, You'll Know:
- How to control data safety and design physical tables.
- How file organisation methods compare, and how to design files based on how they'll be used and accessed.
- The key elements involved in the day-to-day processes of manipulating files.
3Course Content
Module 1: The IT Foundation Behind File Design
- Core IT concepts and tools, and how IT relates to Information Systems.
- Computer systems and intervening IT systems as the environment files live in.
Module 2: From Systems to Storage
- Management Information Systems (MIS) as the context files serve.
- Storing data: the practical core of physical file and database design.