SQL Courses Derby
SQL Courses Derby
November 7, 2026 Comments Off on SQL Courses DerbySQL Courses Derby
Live 1-on-1 online SQL training in English. Flexible scheduling, start anytime from Derby.
Enquire NowSQL Training in Derby — Online & Flexible
Derby is a major engineering and manufacturing city, home to Rolls-Royce and a cluster of advanced engineering organisations. The city’s strong industrial base and growing digital sector are driving demand for technology and IT skills as organisations invest in automation, data, and digital transformation.
School of IT offers live, 1-on-1 online SQL training in English. All sessions are delivered by an experienced trainer via MS Teams or Google Meet, with flexible scheduling so you can build your skills around your existing commitments from Derby.
SQL Fundamentals
Learn SQL from scratch — SELECT statements, filtering, sorting, joins, aggregations, and working with real databases. The fastest way to start querying data professionally.
- ✓SQL SELECT, WHERE, ORDER BY, and LIMIT
- ✓Filtering with AND, OR, NOT, LIKE, IN, and BETWEEN
- ✓Aggregate functions — SUM, COUNT, AVG, MIN, MAX, and GROUP BY
- ✓Joins — INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN
- ✓Subqueries, aliases, and working with multiple tables
Intermediate SQL
Go beyond the basics — window functions, CTEs, stored procedures, views, indexes, and advanced query optimisation for professional data work.
- ✓Window functions — ROW_NUMBER, RANK, LAG, LEAD, and OVER
- ✓Common Table Expressions (CTEs) and recursive queries
- ✓Stored procedures, functions, and triggers
- ✓Views, indexes, and query performance optimisation
- ✓Working with dates, strings, and NULL values in SQL
SQL for Data Analysis
Use SQL for professional data analysis — business intelligence queries, reporting, cohort analysis, funnel analysis, and connecting SQL to Excel and Power BI.
- ✓Business intelligence queries — KPIs, trends, and segmentation
- ✓Cohort analysis, retention analysis, and funnel queries
- ✓Pivot tables and cross-tabulation in SQL
- ✓Connecting SQL databases to Excel and Power BI
- ✓Writing clean, maintainable analytical SQL for business reporting
Database Design & Administration
Design and manage relational databases — normalisation, ER diagrams, keys, constraints, transactions, user management, and backup and recovery.
- ✓Database design — normalisation, ER diagrams, and schema design
- ✓Primary keys, foreign keys, constraints, and referential integrity
- ✓Transactions, ACID properties, and concurrency control
- ✓User management, permissions, and database security
- ✓Backup, recovery, and performance monitoring
Advanced SQL & Query Optimisation
Master advanced SQL — query execution plans, index strategies, partitioning, advanced analytics, and working with large-scale data systems.
- ✓Query execution plans — understanding and optimising SQL performance
- ✓Index strategies — clustered, non-clustered, covering, and composite indexes
- ✓Table partitioning and large-scale data management
- ✓Advanced analytics — time series, running totals, and statistical queries
- ✓Working with JSON, XML, and semi-structured data in SQL
SQL Master Programme
The complete SQL education — fundamentals, intermediate techniques, data analysis, database design, and advanced query optimisation in one comprehensive programme.
- ✓SQL fundamentals — SELECT, joins, aggregations, and subqueries
- ✓Intermediate SQL — window functions, CTEs, stored procedures, and views
- ✓SQL for data analysis — business intelligence, cohort analysis, and reporting
- ✓Database design — normalisation, keys, constraints, and administration
- ✓Advanced SQL — query optimisation, indexes, partitioning, and large-scale data
What You Will Learn
- ✓Write SQL queries from scratch — SELECT, JOIN, GROUP BY, and subqueries
- ✓Use window functions, CTEs, and advanced SQL for professional analytics
- ✓Design normalised relational databases with ER diagrams and proper schema structure
- ✓Optimise slow queries using execution plans, indexes, and query rewriting
- ✓Connect SQL databases to Excel and Power BI for business reporting
- ✓Manage database users, permissions, backups, and recovery
- ✓Work with large-scale data using partitioning and performance techniques
- ✓Apply SQL for business intelligence, cohort analysis, and KPI reporting
Compare SQL Courses
| Course | Price | Duration | Level |
|---|---|---|---|
| SQL Fundamentals | £549 | 10h | Beginner |
| Intermediate SQL | £599 | 10h | Intermediate |
| SQL for Data Analysis | £749 | 10h | Intermediate |
| Database Design & Administration | £849 | 20h | Intermediate |
| Advanced SQL & Query Optimisation | £849 | 20h | Advanced |
| SQL Master Programme | £1,249 | 40h | Advanced |
SQL Courses Derby — FAQs
Yes — all our SQL courses are delivered 100% online via MS Teams or Google Meet. You study from Derby with an experienced data trainer at a time that suits you. No fixed class times and no commuting required.
If you are new to SQL, start with SQL Fundamentals (10 hours, £549) — it teaches you to write real queries from day one. If you already know the basics, go straight to Intermediate SQL or SQL for Data Analysis depending on your goals. The Master Programme (40 hours, £1,249) covers the complete SQL journey.
We teach standard SQL that works across all major databases — MySQL, PostgreSQL, SQL Server, and SQLite. We will work with whichever database you use or plan to use at work. If you are unsure, we will recommend the most relevant one for your situation.
The Fundamentals and Intermediate courses are each 10 hours. Database Design and Advanced SQL are each 20 hours. The Master Programme is 40 hours. All are 1-on-1 with flexible scheduling from Derby.
SQL courses start at £549 for SQL Fundamentals, ranging up to £1,249 for the Master Programme. All prices are in GBP.
SQL is consistently one of the most in-demand skills for data analyst, business analyst, data engineer, and software developer roles across the UK. In Derby, virtually every organisation that works with data needs people who can query it — making SQL one of the highest-return skills you can add to your professional toolkit.
Start Your SQL Training Today
Live 1-on-1 online instruction in English. Flexible scheduling. Start anytime from Derby.
Enquire Now →
