Database Management systems are designed to manage large bodies of information. The management of data involves both the definition of structures for the storage of information and the provision of mechanisms for the manipulation of information. In addition, the database system must provide for the safety of the information stored, despite system crashes or attempts to unauthorized access. If data is to be shared among several users, the system must avoid possible anomalous results.
Database Design is the process of developing data base structures from user requirements for data. It starts with requirements analysis, which identifies user needs for data. It then proceeds by translating these user requirements into first a conceptual, then a physical, data base design. The resulting design must satisfy user needs in terms of completeness, integrity, performance, constraints, and other factors.
In this course you will gain an understanding of both the fundamentals of relational databases and relational database design. It is scheduled to be highly interactive and problems will be solved throughout the class hours. A mini-workshop will be presented in the classroom on the fifth day for the students to get a good understanding of the database design process.
will you learn
- A background on database management
- The ANSI-SCHEMA 3 level architecture
- Understanding the Entity/Relationship Model
- Relational Database Theory
- SQL & SQL Queries
- File Structures, Indexing and Hashing
- Query Processing & Query Optimization
- Crash Recovery
- Concurrency Control/Transaction Processing
- Security and Integrity
- Database Planning & Information Engineering
- Database Analysis
- Logical Design
- Conceptual Design
- Physical Design
- The role of the Database Administrator
This course is targeted towards Data and Database Managers, Information Systems Managers, Programmers, and Designers, Database Administrators, Database Users, Database Internals Programmers and anybody interested in understanding Relational Database Systems from a fundamental perspective.
Onsite Training Class