Databases; ontwerp & rapportage met SQL.173 Add to favorites

The relational database is an important factor in managing data in an organization. Also in Business Intelligence where Multi-dimensional databases, Data marts and Data warehouses play a role, knowledge of this relational model is important. Data management according to DAMA DM-Bok focuses on good management of meta data, master data and reference data. Some attention is also paid to this in the course.

What are we going to do in this course?

• Creating conceptual data models to support business processes, this concerns online Transaction Processing Databases (OLTP)
• Identify business rules that apply to data and information
• Converting a conceptual data model into a logical data model
• Convert business rules into information rules, or constraints, and implement them in the models
• Consider how to implement information rules if they cannot be specified in the conceptual and logical data models
• Review SQL basics and then convert reporting questions into queries
• Pay attention to query performance, see how to optimize it
• Prepare for the advanced exam by working through practice exam questions that will provide more in-depth knowledge on the various topics
• Investment training: see cost specifications, additional are material costs. If you always want to be able to start, choose a start guarantee.

Contents:
- Principles of databases,
- Database models,
- introduction Data Management - Body of Knowledge.
- identifying business rules
- OLTP systems and features,
- Conceptual data modeling/information modeling.
- the relational model,
- relational DBMS and integrity,
- basic principles of SQL (DML, DDL, DCL)
- How SQL and Queries Work
- Nested queries
- Correlated queries.
- Forms of Joining tables
- Double Negation in SQL
- From question to Query.
- From Query to Questioning.
- Query Analysis
- online tools for SQL

Target audience:
database administrators, helpdesk employees, functional administrators, application administrators, system developers, programmers who want to use Embedded SQL, etc. In short, those who want to know more about databases, the relational model and SQL.

Level & prior knowledge:
HBO level of thinking is expected. Affinity with SQL and tables is expected. This is an HBO/Post-HBO level course.

Exam:
Exam consists of 30 multiple choice questions, is open book, and takes a maximum of 2 hours. With 17 questions or more, one passes and the candidate receives the certificate "Advanced Certificate in Applying Database Management, Analysis & Design" from The Business & IT Exams Association (Bitexa). If due to circumstances you do not pass the exam: a resit is free.

Start and follow-up planning
Agile in consultation, (or fixed data/schedule if purchased as an option, with this fixed schedule option your course is guaranteed to start).