- Automation & ICT / IT
- Database management
- Relationele databases & SQL#B52
Relationele databases & SQL#B52
AMBI studie
Features
- 2 days (14 days)
- Bachelor
- examen
€ 1.113,20 All-in-price
- Customers reward us with a 9,8
- Free cancellation >4 weeks before start course
- Best price guarantee
Book this course
- Customers reward us with a 9,8
- Free cancellation >4 weeks before start course
- Best price guarantee
€ 1.113,20 All-in-price
Book this course
€ 1.113,20 All-in-price
- Dit is gegarandeerd de beste prijs
About this course
The relational database is most commonly used in practice for processing daily transactions. A good conceptual and logical data model is important for effectively capturing and monitoring business data rules by the database management system. We also want to prevent redundancy (duplicate data) and ensure that data is intact and consistent. Finally, the maintenance and management of the database must be well organized by assigning user rights and defining the appropriate data constraints.
This training covers the topics and aspects mentioned above. Database Effective 2-day training, one day a week. You can read up on the material beforehand.
We will discuss;
Exam;
After the training, you will have sufficient knowledge to take the Foundation Level exam for Certified Database Manager or the Databases & SQL Fundamentals exam.
Execution;
The location can be chosen and is often central for participants (we take traffic avoidance into account);
Classroom performance lessons are from 10 a.m. to 4 p.m.
The online version consists of 3 sessions of 105 minutes (09:30 - 15:15), on each class day.
This training covers the topics and aspects mentioned above. Database Effective 2-day training, one day a week. You can read up on the material beforehand.
We will discuss;
- database types: hierarchical, network, relational, object-oriented.
- relational model; primary key, foreign keys, attributes, relations, domain types,
- integrity rules, consistency
- forms of standardization
- ACID
- SQL basics; create, drop, select, join, where, having, group by, nested queries, correlated queries, not in, in, not exists, exists, distict, order by,
- SQL aggregate functions; GDPR, SUM, COUNT, MAX, MIN,
- conceptual model; independent of DBMS high level data modeling,
- logical model; independent of DBMS ; low level data modeling, data types, views,
Exam;
After the training, you will have sufficient knowledge to take the Foundation Level exam for Certified Database Manager or the Databases & SQL Fundamentals exam.
Execution;
The location can be chosen and is often central for participants (we take traffic avoidance into account);
Classroom performance lessons are from 10 a.m. to 4 p.m.
The online version consists of 3 sessions of 105 minutes (09:30 - 15:15), on each class day.
Book this course
- Customers reward us with a 9,8
- Free cancellation >4 weeks before start course
- Best price guarantee
€ 1.113,20 All-in-price
About the training institute
Ambistudie, a trainer for people who work in IT or fiCT and/or want to gain knowledge about the various fields related to IT and ICT.
From project management, Agile working, Scum, Kanban, Business analysis, Requirements Engineering, Systems Engineering, Information analysis, database design, data mart or data warehouse, data lake design, Business Intelligence, Data Mining, Data Science to information planning and policy, business process management, functional management, quality management, Function Point Analysis, information strategy, communication skills, coaching, architectures and design languages such as UML, SysML, BPMN, etc.
Approach is Agile;
Teaching locations are in the larger cities in the Netherlands; Groningen, Leeuwarden, Tilburg, Sittard, Goes, Deventer, Zwolle, Assen, Arnhem, Den Bosch, Utrecht, Amsterdam, Rotterdam, Breda, Terneuzen, The Hague and Alkmaar, but in principle we can teach anywhere. Online is of course always possible.
For classroom courses outside the South Holland region and surrounding areas, there are additional location costs due to arranging teaching locations in your region.
From project management, Agile working, Scum, Kanban, Business analysis, Requirements Engineering, Systems Engineering, Information analysis, database design, data mart or data warehouse, data lake design, Business Intelligence, Data Mining, Data Science to information planning and policy, business process management, functional management, quality management, Function Point Analysis, information strategy, communication skills, coaching, architectures and design languages such as UML, SysML, BPMN, etc.
Approach is Agile;
- We plan agile and tailored to those who register.
- we have affordable courses and exams,
- We are proactively customer-oriented and think along with you.
- We also start from 1 participant.
Teaching locations are in the larger cities in the Netherlands; Groningen, Leeuwarden, Tilburg, Sittard, Goes, Deventer, Zwolle, Assen, Arnhem, Den Bosch, Utrecht, Amsterdam, Rotterdam, Breda, Terneuzen, The Hague and Alkmaar, but in principle we can teach anywhere. Online is of course always possible.
For classroom courses outside the South Holland region and surrounding areas, there are additional location costs due to arranging teaching locations in your region.
Check availability
Datum in consultation
−20%
€ 1.113,20 All-in-price Features
- Institute
- AMBI studie
- Certificate This is the certificate you will receive after completing the course or exam.
- examen
- Level This is solely an indication of the required knowledge level.
- Bachelor
- Contact hour
- Dag
- Rating
- 8,0
- Recommends
- 100%
Book now
| 1× original price | € 920,00 |
|---|---|
| 21% VAT | € 193,20 |
| € 1.113,20 (21% VAT) | |
Datum in consultation
−20%
€ 1.113,20 All-in-price Course
| Date | Datum in consultation |
|---|
- Lead time
- 14 days
Additional options
| | |
| |
Features
- Institute
- AMBI studie
- Certificate This is the certificate you will receive after completing the course or exam.
- examen
- Level This is solely an indication of the required knowledge level.
- Bachelor
- Contact hour
- Dag
- Rating
- 8,0
- Recommends
- 100%
Book now
| 1× original price | € 920,00 |
|---|---|
| 21% VAT | € 193,20 |
| € 1.113,20 (21% VAT) | |
Datum in consultation
€ 1.391,50 All-in-price
Course
| Date | Datum in consultation |
|---|
- Lead time
- 14 days
- Location
- In overleg
Additional options
| | |
| |
Features
- Institute
- AMBI studie
- Certificate This is the certificate you will receive after completing the course or exam.
- examen
- Level This is solely an indication of the required knowledge level.
- Bachelor
- Contact hour
- Dag
- Rating
- 8,0
- Recommends
- 100%
Book now
| 1× original price | € 1.150,00 |
|---|---|
| 21% VAT | € 241,50 |
| € 1.391,50 (21% VAT) | |
Check out what other participants think of this course!
8,0/10
100% of 1 participant recommends!