SQL & Database Administration

Course overview

A practical, project-based programme that takes learners from SQL fundamentals to advanced querying and core database administration. Students learn how to retrieve and analyse data, design normalised relational schemas, manage users and permissions, optimise database performance, perform backups and recovery, and automate routine database operations using PostgreSQL and Microsoft SQL Server.

Who it's for: Data analysts, software developers, database professionals, IT support staff, system administrators and technology professionals who work with relational databases or want to build practical SQL and database administration skills.

What you will learn

• Understand relational database concepts and architecture
• Write SQL queries to retrieve, filter and analyse data
• Use joins, subqueries, CTEs and window functions effectively
• Perform data aggregation and business-focused analysis
• Design normalised relational database schemas
• Create tables, relationships, constraints and indexes
• Write views, functions and stored procedures
• Understand database transactions and concurrency
• Identify and troubleshoot slow-running queries
• Apply indexing and query optimisation techniques
• Manage database users, roles and permissions
• Implement database backup and recovery strategies
• Apply fundamental database security practices
• Automate routine database administration tasks
• Work confidently with PostgreSQL and Microsoft SQL Server

Curriculum

Prerequisites

• • Basic computer literacy
• • No prior SQL experience required
• • Basic understanding of spreadsheets is helpful but not required