Search Our Program
Advances in our capability to generate and collect information coupled with decreasing disk‐space prices are pushing us toward a world centered around data management. Databases are at the heart of modern commercial application development. Their use extends beyond this to many other environments and domains where large amounts of data must be stored for efficient update and retrieval. The purpose of this course is to provide a comprehensive introduction to the use of database management systems for applications.
To be able to use Database Management Systems (DBMSs) successfully, one has to understand the concepts on which they are based.
The aims of this course are to :
- familiarise you with the basic concepts underlying a DBMS;
- show how they are realized in specific systems such as the PostgreSQL DBMS;
- give you some hands-on experience in using a DBMS.
- Fundamental Database Concepts
- The Entity Relationship (= ER) Model (the most common approach to conceptual database design)
- The Relational Data Model – Relations – Integrity Constraints (keys, foreign keys, etc.)
- Logical Database Design (ER to relational schemas)
- Relational Algebra (an algebraic query language for the relational model)
- SQL: Querying and Manipulating Data :
- SQL Data Definition Language
- Single Block Queries
- baseJoins and Outer Joins
- Transaction Management and Concurrency Control
- Database Access from a Programming Language: JDBC
- Data Storage and Indexing :
- File Organisation and Indexes
- Tree-structured Indexing: B+-trees
- Hash-based Indexing
Outbound Activities Aimed At Improving:
Query Evaluation :
- Evaluation of Relational Operators
- Query Optimisation
- Physical Database Design
- Post training program
WHO SHOULD ATTEND
Audience for the Training
- Business managers and their staff who need to understand the concepts of data modeling, so they can participate actively in partnership with IT staff in data modeling sessions that draw on their business expertise.
- IT managers, data administrators and systems development staff who also need to understand the concepts of data modeling to participate with business managers and staff in data modeling sessions, and so enable the IT staff to draw on their systems development expertise in a design partnership with the business experts.
- Others interested
- Face To Face
- Role playing
- Post session assessment
- Video presentation
- Case study
5 working days