1. Relational foundations
Model tables, keys, types and constraints.
Home/All Courses/SQL and Relational Database Engineering
— Craskills flagship course · TECH & CAREER
SQL and Relational Database Engineering
Build practical capability from foundations to advanced application in SQL and Relational Database Engineering.
CSDesigned by Craskills Learning and Development Solutions
Contextual learningAdapted to participant roles
Hands-on practiceRelevant workplace situations
9 learning modulesClear, practical architecture
Offline / OnlineFlexible delivery options
CustomisableAligned to organisational goals
About this courseBuilt around the moments
Built around the moments
that matter at work.
A progressive, instructor-led pathway in SQL and Relational Database Engineering. Start at the level matching your prior experience, practise with guided exercises, and develop a reviewed project. Each level is part of the same course; scope, duration and entry assessment are agreed before enrolment.
Designed for
Developersanalysts and computer science studentsWhat you’ll learnCapabilities you can
Capabilities you can
apply immediately.
01Combine tables and safely insert, update and delete records.
02Understand isolation, locks and safe multi-step writes.
03Design a transaction-backed application schema with analytical queries and a tested recovery plan.
Three levels · One courseBuild from foundations
Build from foundations
to advanced practice.
Choose your entry level after an initial skills discussion. Complete the preceding level or demonstrate equivalent skills before progressing. Advanced here means advanced within this pathway, not a guarantee of professional mastery.
Beginner3 modules
Entry guidance: Review the audience requirements above; this level begins with subject foundations.
2. Query fundamentals
Filter, aggregate and sort records; interpret NULL behaviour.
3. Joins and data modification
Combine tables and safely insert, update and delete records.
Progress review: Practical exercise, feedback and a demonstration of the level’s learning outcomes. Duration is agreed for the selected level and audience.
Intermediate3 modules
Entry guidance: Beginner-level skills or equivalent practical experience.
1. Schema design
Normalise business data and plan referential integrity.
2. Analytical SQL
Use subqueries, CTEs and window functions for analytical questions.
3. Transactions and concurrency
Understand isolation, locks and safe multi-step writes.
Progress review: Practical exercise, feedback and a demonstration of the level’s learning outcomes. Duration is agreed for the selected level and audience.
Advanced3 modules
Entry guidance: Intermediate-level skills and the ability to complete applied exercises independently.
1. Query optimisation
Read execution plans and assess indexes against workloads.
2. Database operations
Plan backups, recovery exercises, migrations and least-privilege access.
3. Database capstone
Design a transaction-backed application schema with analytical queries and a tested recovery plan.
Progress review: Practical exercise, feedback and a demonstration of the level’s learning outcomes. Duration is agreed for the selected level and audience.
Learning experienceLess presentation.
Less presentation.
More participation.
Participants work with relevant situations, guided practice, peer discussion, reflection and practical action planning.
Contextual cases
Scenarios and examples connected to participant roles and business reality.
Guided practice
Structured exercises that make new behaviours safer to try and easier to repeat.
Application tools
Frameworks, checklists, templates and action plans designed for use after the course.
Completion credentialCertificate
Certificate
of participation.
Certificate available, subject to the agreed delivery design and participation requirements.
CRASKILLS.Certificate of
Participation
Participation
Delivery optionsRight-sized for your
Right-sized for your
learning objective.
Beginner foundation pathway
Instructor-led • Offline / Online • Customisable
Intermediate applied practitioner pathway
Instructor-led • Offline / Online • Customisable
Advanced project pathway
Instructor-led • Offline / Online • Customisable
Complete three-level learning journey
Instructor-led • Offline / Online • Customisable
Continue building capability
Related courses in this skill area.
Data Literacy for Business Professionals
Read, question and communicate with data.
View course →Power BI for Business Dashboards
From raw data to decision-ready dashboards.
View course →Data Storytelling for Executive Decisions
Turn analysis into action.
View course →Frequently asked questionsUseful answers
Useful answers
before you begin.
Is this course suitable for beginners?+
The beginner level introduces this subject. Review the audience requirements: some technical pathways require programming or mathematics. Intermediate and advanced entry requires equivalent skills or completion of the preceding level.
Can this course be customised for our organisation?+
Yes. Examples, activities, terminology, case situations, duration and outcomes can be contextualised for your industry and participant roles.
Can the course be delivered online and offline?+
Available delivery modes for this course are Offline / Online. The final format is agreed around group size, location and learning objectives.
Will participants receive a certificate?+
Certificate available. Any participation or completion requirements are confirmed in the agreed course proposal.
How can we request a proposal?+
Use the enquiry button and share your audience, preferred dates, location, delivery mode and expected outcomes. The Craskills team will recommend an appropriate design.
— Let’s shape the right experience
Bring this course
to your people.
Share your audience, location, preferred duration, current challenges and expected outcomes.
Request a course proposal →