Free coursebeginner Registration open

Introduction to Database Management

A practical foundation in relational databases, SQL, data modelling, integrity, transactions, security, performance and reliable data operations.

Provider
AISynapseBiz
Instructor
Self-paced · no live professor
Duration
6 weeks · 18+ hours video · self-paced
Certificate
Course Certificate

Choose an offering

Delivery
Recorded / self-paced
Schedule
Self-paced · 6 weeks · finish whenever you are ready
Timezone
UTC
Dates
Rolling
Course overview

About this course

A professional beginner course in database management for analysts, developers and business professionals. Learners progress from relational concepts and data modelling to SQL, joins, constraints, normalization, transactions, indexing, security, backups, analytics-ready design and operational reliability. The course focuses on reasoning about data structures as well as writing correct queries, with original AISynapse lessons, checkpoint questions and AI-graded applied work every week.

Learning outcomes

Design clear relational schemas; identify entities, attributes, primary keys and foreign keys; write SELECT, filter, aggregate and join queries; apply constraints and normalization to improve integrity; explain transactions and ACID properties; understand indexes and query performance; design role-based access and safe database practices; plan backup and recovery; distinguish OLTP and analytical workloads; build and justify a small professional database design.

Prerequisites

  • ▸No database experience is required.
  • ▸Basic computer literacy is sufficient.
  • ▸Familiarity with spreadsheets is helpful but not necessary.

Weekly outline

  • ▸Week 1: Relational Foundations and SQL
  • ▸Week 2: Aggregation, Business Questions and Joins
  • ▸Week 3: Integrity, Constraints and Normalisation
  • ▸Week 4: Transactions, Concurrency and Performance
  • ▸Week 5: Security, Backup, Recovery and Reliability
  • ▸Week 6: Analytics Pipelines and Professional Database Capstone
Structured weekly sequence

Curriculum

Open a week to inspect its lessons and applied focus. The current foundation pathway contains only the six active curriculum weeks; historical versions remain preserved privately for existing learner progress.

01

Week 1

Relational Foundations and SQL

13 lessons3 checkpoints1 applied assignment

Learn relational thinking, keys, relationships and schemas while building a practical foundation in SELECT, filtering, ordering and readable SQL.

Applied work for this week

Complete the learning path and submit the applied task to AI SYNAPSE REVIEW.

  1. 01Week 1: Database Concepts and Relational Models
  2. 01Why databases exist / Tables rows and columns
  3. 02Entities and attributes / Primary keys
  4. 03Foreign keys / Relationships
  5. 04One-to-one relationships / One-to-many relationships
  6. 05Many-to-many relationships / Schemas and metadata
  7. 06Relational thinking versus spreadsheets / Designing a simple business database
  8. 07SELECT and FROM / Choosing columns
  9. 08Aliases / WHERE filters
  10. 09Comparison operators / Boolean logic
  11. 10NULL semantics / ORDER BY
  12. 11LIMIT and result inspection / DISTINCT
  13. 12Calculated columns / Writing readable SQL
02

Week 2

Aggregation, Business Questions and Joins

13 lessons3 checkpoints1 applied assignment

Answer business questions with aggregation, CASE logic, dates and KPIs, then combine related tables correctly with joins.

Applied work for this week

Complete the learning path and submit the applied task to AI SYNAPSE REVIEW.

  1. 01Week 2: SQL Foundations
  2. 01COUNT SUM AVG MIN MAX / GROUP BY
  3. 02HAVING / Conditional aggregation
  4. 03CASE expressions / Dates and periods
  5. 04String functions / Numeric functions
  6. 05NULL-safe calculations / Ratios and KPIs
  7. 06Building summary tables / Checking aggregate accuracy
  8. 07Why joins matter / INNER JOIN
  9. 08LEFT JOIN / RIGHT and FULL JOIN concepts
  10. 09Joining on keys / Many-to-many bridge tables
  11. 10Multiple joins / Self joins conceptually
  12. 11Duplicate rows after joins / Missing matches
  13. 12Join debugging / Building a customer-order view
03

Week 3

Integrity, Constraints and Normalisation

13 lessons3 checkpoints1 applied assignment

Design trustworthy schemas using constraints, referential integrity, sound keys and normalization while understanding practical trade-offs.

Applied work for this week

Complete the learning path and submit the applied task to AI SYNAPSE REVIEW.

  1. 01Week 3: Relationships and Joins
  2. 01NOT NULL / UNIQUE
  3. 02Primary key constraints / Foreign key constraints
  4. 03CHECK constraints / Default values
  5. 04Referential integrity / Insert and update failures
  6. 05Cascade behaviour / Natural versus surrogate keys
  7. 06Data validation strategy / Designing trustworthy tables
  8. 07Why normalization matters / Functional dependency intuition
  9. 08First normal form / Second normal form
  10. 09Third normal form / Repeating groups
  11. 10Update anomalies / Insert anomalies
  12. 11Delete anomalies / Denormalization trade-offs
  13. 12Operational versus reporting models / Normalizing a messy dataset
04

Week 4

Transactions, Concurrency and Performance

13 lessons3 checkpoints1 applied assignment

Understand ACID, concurrent updates, safe transactions, indexes, query plans and the practical foundations of database performance.

Applied work for this week

Complete the learning path and submit the applied task to AI SYNAPSE REVIEW.

  1. 01Week 4: Normalization and Data Quality
  2. 01What a transaction is / Atomicity
  3. 02Consistency / Isolation
  4. 03Durability / COMMIT and ROLLBACK
  5. 04Concurrent users / Dirty reads intuition
  6. 05Non-repeatable reads intuition / Lost updates
  7. 06Isolation levels conceptually / Designing safe financial updates
  8. 07Why indexes exist / B-tree intuition
  9. 08Indexing keys / Composite indexes
  10. 09Selectivity / Indexes and writes
  11. 10Reading query plans conceptually / Full table scans
  12. 11Filtering and sorting performance / Join performance
  13. 12Over-indexing / Practical tuning workflow
05

Week 5

Security, Backup, Recovery and Reliability

13 lessons3 checkpoints1 applied assignment

Apply least privilege, parameterized access, audit controls, backup/recovery concepts, availability planning and safe change management.

Applied work for this week

Complete the learning path and submit the applied task to AI SYNAPSE REVIEW.

  1. 01Least privilege / Users and roles
  2. 01Week 5: Transactions, Security and Backups
  3. 02GRANT and REVOKE concepts / Application versus admin access
  4. 03Row-level security concept / Protecting sensitive columns
  5. 04Secrets and credentials / SQL injection
  6. 05Parameterized queries / Audit logging
  7. 06Data retention / Security review checklist
  8. 07Why backups fail in practice / Full and incremental backup concepts
  9. 08Point-in-time recovery / Recovery objectives
  10. 09RPO and RTO / Replication concepts
  11. 10High availability / Monitoring storage and connections
  12. 11Migration safety / Change management
  13. 12Testing restores / Incident recovery plan
06

Week 6

Analytics Pipelines and Professional Database Capstone

13 lessons3 checkpoints1 applied assignment

Connect operational databases to analytics concepts, warehouses and data pipelines, then design and present a professional database solution.

Applied work for this week

Complete the learning path and submit the applied task to AI SYNAPSE REVIEW.

  1. 01Week 6: Professional Database Project
  2. 01OLTP versus OLAP / Operational schemas
  3. 02Star schema intuition / Facts and dimensions
  4. 03ETL and ELT / Staging layers
  5. 04Data quality checks / Slowly changing dimensions intuition
  6. 05Materialized views concept / Data marts
  7. 06Lineage and documentation / Designing analytics-ready data
  8. 07Clarify requirements / Identify entities
  9. 08Define keys / Model relationships
  10. 09Normalize core tables / Write core SQL queries
  11. 10Add integrity constraints / Plan indexes
  12. 11Define roles and access / Plan backup and recovery
  13. 12Document assumptions / Present the database solution
Programme evidence

What the learner studies and is assessed on

This summary shows the complete learning and assessment trail used for course completion. Certificate eligibility is created only after the required weekly work, knowledge checks and applied assessments are completed. For this free course, the verified certificate is an optional paid add-on available at the end.

What the learner will be able to do

  • ✓Design clear relational schemas; identify entities, attributes, primary keys and foreign keys; write SELECT, filter, aggregate and join queries; apply constraints and normalization to improve integrity; explain transactions and ACID properties; understand indexes and query performance; design role-based access and safe database practices; plan backup and recovery; distinguish OLTP and analytical workloads; build and justify a small professional database design.

Material examined

  1. Week 1: Relational Foundations and SQLWeek 1: Database Concepts and Relational Models, Why databases exist / Tables rows and columns, Entities and attributes / Primary keys, Foreign keys / Relationships, One-to-one relationships / One-to-many relationships, Many-to-many relationships / Schemas and metadata, Relational thinking versus spreadsheets / Designing a simple business database, SELECT and FROM / Choosing columns, Aliases / WHERE filters, Comparison operators / Boolean logic, NULL semantics / ORDER BY, LIMIT and result inspection / DISTINCT, Calculated columns / Writing readable SQLLesson material · practical work · knowledge quiz
  2. Week 2: Aggregation, Business Questions and JoinsWeek 2: SQL Foundations, COUNT SUM AVG MIN MAX / GROUP BY, HAVING / Conditional aggregation, CASE expressions / Dates and periods, String functions / Numeric functions, NULL-safe calculations / Ratios and KPIs, Building summary tables / Checking aggregate accuracy, Why joins matter / INNER JOIN, LEFT JOIN / RIGHT and FULL JOIN concepts, Joining on keys / Many-to-many bridge tables, Multiple joins / Self joins conceptually, Duplicate rows after joins / Missing matches, Join debugging / Building a customer-order viewLesson material · practical work · knowledge quiz
  3. Week 3: Integrity, Constraints and NormalisationWeek 3: Relationships and Joins, NOT NULL / UNIQUE, Primary key constraints / Foreign key constraints, CHECK constraints / Default values, Referential integrity / Insert and update failures, Cascade behaviour / Natural versus surrogate keys, Data validation strategy / Designing trustworthy tables, Why normalization matters / Functional dependency intuition, First normal form / Second normal form, Third normal form / Repeating groups, Update anomalies / Insert anomalies, Delete anomalies / Denormalization trade-offs, Operational versus reporting models / Normalizing a messy datasetLesson material · practical work · knowledge quiz
  4. Week 4: Transactions, Concurrency and PerformanceWeek 4: Normalization and Data Quality, What a transaction is / Atomicity, Consistency / Isolation, Durability / COMMIT and ROLLBACK, Concurrent users / Dirty reads intuition, Non-repeatable reads intuition / Lost updates, Isolation levels conceptually / Designing safe financial updates, Why indexes exist / B-tree intuition, Indexing keys / Composite indexes, Selectivity / Indexes and writes, Reading query plans conceptually / Full table scans, Filtering and sorting performance / Join performance, Over-indexing / Practical tuning workflowLesson material · practical work · knowledge quiz
  5. Week 5: Security, Backup, Recovery and ReliabilityLeast privilege / Users and roles, Week 5: Transactions, Security and Backups, GRANT and REVOKE concepts / Application versus admin access, Row-level security concept / Protecting sensitive columns, Secrets and credentials / SQL injection, Parameterized queries / Audit logging, Data retention / Security review checklist, Why backups fail in practice / Full and incremental backup concepts, Point-in-time recovery / Recovery objectives, RPO and RTO / Replication concepts, High availability / Monitoring storage and connections, Migration safety / Change management, Testing restores / Incident recovery planLesson material · practical work · knowledge quiz
  6. Week 6: Analytics Pipelines and Professional Database CapstoneWeek 6: Professional Database Project, OLTP versus OLAP / Operational schemas, Star schema intuition / Facts and dimensions, ETL and ELT / Staging layers, Data quality checks / Slowly changing dimensions intuition, Materialized views concept / Data marts, Lineage and documentation / Designing analytics-ready data, Clarify requirements / Identify entities, Define keys / Model relationships, Normalize core tables / Write core SQL queries, Add integrity constraints / Plan indexes, Define roles and access / Plan backup and recovery, Document assumptions / Present the database solutionLesson material · practical work · knowledge quiz · final project