Database Fundamentals

U wilt de basisprincipes achter (relationele) databases begrijpen. Zowel de concepten achter database management systemen (DBMS) als de structurering en opslag van gegevens in een database. En natuurlijk het opvragen en bewerken van gegevens.

Onderwerpen die onder andere aan bod komen zijn relationele database concepten, de elementen in een database management systeem, tabellen, queries, database relaties, het bewerken van gegevens met behulp van SQL en nog veel meer.
 
De training is niet gekoppeld aan een specifieke database maar behandeld algemene concepten.

Uw resultaat

U bent bekent met de basisprincipes achter (relationele) databases. Tevens heeft u basiskennis van SQL.

Doelgroep

Ontwikkelaars / support engineers die zich de basisprincipes van databases eigen willen maken.

Inhoud training

De training is opgebouwd uit twee lessen:

Database Systems and Relational Databases

• Recognize the differences between a database and a DBMS
• Recognize the different types of database users
• Identify the requirements of a good database
• Match the database architecture with its correct description
• Match the database model with its correct description
• Recognize the features of databases and DBMS
• Describe database models and database architectures
• Describe the features and recognize the types of relational databases
• Recognize how to model the database
• Describe how to outline a relationship database schema
• Describe the concept of referential integrity
• Recognize how to normalize the relations
• Describe relational database concepts
• Recognize the constructs in a relationship database schema
• Normalize database tables

Management of Relational Database Data

• Match each relational algebra operation with its correct description
• Recognize what the different SQL statements do
• Recognize the different relational algebra operations
• Recognize how to use SQL statements for queries and manipulation
• Recognize characteristics of transaction processing and concurrency control
• Recognize how a transaction works in a DBMS and describe the ANSI/ISO transaction model
• Recognize concurrency problems
• Recognize the fundamentals of locking
• Describe advanced locking techniques
• Recognize security concepts in a relational database
• Describe transaction processing and concurrency control
• Describe concurrency control with locking
• Describe security concepts in a relational database