Skip to content
CYVERRA VERIDIONCYVERRAVeridion
Professional · One-time purchase

Database Management

Design, query and optimise databases: SQL, tables, relationships, joins, indexes, integrity, backup and performance.

ProfessionalHard
40 hours 0 lessons Certificate on completion EN

Level & requirements

ProfessionalHard

Develop specialised, job-ready professional expertise.

Required experience
Solid working experience in the field; ready for specialised, job-ready work.
Prerequisites
None — you can start today.
Career roles this supports
Data AnalystProfessional

Database Management is a professional, project-driven course designed for career-focused learners. Across 40 lessons in 10 modules you build hands-on skills, complete practical exercises, and finish a real project that is assessed against professional standards.

What you will learn

  • Model relational databases
  • Write effective SQL
  • Use joins, indexes and constraints
  • Back up and optimise databases

Curriculum

Database Fundamentals

What a database is · Tables and rows · Primary keys · ACID and transactions

  • Lessons are being published.

SQL

SELECT and WHERE · Ordering and limiting · Aggregation · Modifying data

  • Lessons are being published.

Tables

Designing tables · Data types · Constraints · Default values

  • Lessons are being published.

Relationships

One-to-one and one-to-many · Foreign keys · Many-to-many · Normalisation

  • Lessons are being published.

Queries

Filtering and sorting · Grouping · Subqueries · Query performance

  • Lessons are being published.

Joins

Inner and outer joins · Left, right and full · Self joins · Join pitfalls

  • Lessons are being published.

Indexes

What indexes do · When to index · Composite indexes · Index maintenance

  • Lessons are being published.

Data Integrity

Constraints and rules · Transactions and locking · Handling duplicates · Data quality

  • Lessons are being published.

Backup

Backup strategies · Point-in-time recovery · Restoring · Testing backups

  • Lessons are being published.

Optimization

Reading query plans · Slow queries · Index tuning · Capacity planning

  • Lessons are being published.

Requirements

  • No prior experience required
  • A computer with internet access
  • Commitment to the practical project