This resource covers the
Section 1: Database Fundamentals — 15 Questions- Relational database concepts
- Tables, records and fields
- Primary keys
- Foreign keys
- Relationships
- Entity integrity
- Referential integrity
- Data redundancy
- Data consistency
- Database management systems
Cover:
- Database structures
- Table design
- Relationships
- Appropriate keys
- Data validation
- Normalisation
- Relevant normal forms
- Design scenarios
Cover:
- SELECT
- FROM
- WHERE
- ORDER BY
- INSERT
- UPDATE
- DELETE
- Logical conditions
- Comparison operators
- Query interpretation
Cover:
- Aggregate functions
- GROUP BY
- HAVING
- Joins
- Multiple conditions
- Nested queries where relevant
- Complex database scenarios
Something went wrong, please try again later.
This resource hasn't been reviewed yet
To ensure quality for our reviews, only customers who have purchased this resource can review it
Report this resourceto let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.
£4.99