Instructor-led IT courses across web, mobile, data, design and more.
Many organisations still have data spread across ERP systems, application databases, Excel files and CSV files that must be combined every day for reporting and the data warehouse. This work often starts as scripts or manual copying, which break easily,…
Many business systems keep critical logic in SQL Server: saving orders, deducting stock, calculating commissions and running reports that applications call every day. Stored procedures written without standards often ignore errors and leave data half-written…
Power Query makes data preparation in Power BI easy to start with clicks, but once data comes from many files with different layouts, from APIs or in larger volumes, click-built queries tend to break when a file changes, refresh too slowly or fail to refresh…
Many Power BI reports start quickly, but as data grows the totals stop adding up, slicers fail to filter, dozens of near-identical measures pile up and files become so large that refreshes crawl. Most of these problems are not caused by DAX formulas. They…
Many organisations still build executive reports by exporting data from an Oracle-based ERP into Excel, then cleaning it, writing formulas, summarising, charting and emailing the result by hand every week. With many tables, dozens of columns each and millions…
Most organisations have data spread across many systems: operational databases, daily export files and real-time event data. Meanwhile, business and AI teams need data that is clean, trustworthy and ready to use quickly. The usual problems are pipelines built…
Many organisations still keep a data warehouse for reporting apart from a data lake for raw files, and pull data from their core systems with nightly batch ETL. The result is data stored twice, numbers that do not match, slow answers to questions that need…
When an organisation's key systems run on PostgreSQL, getting it installed is not enough. The team needs to know why the database slows down, whether data can be restored to the moment before an incident, and how service carries on when the primary server…
In 2026 PostgreSQL is the main database of many organisations, both in newly built systems and in systems migrated from Oracle, SQL Server or MySQL. Reporting teams therefore need to pull data from PostgreSQL directly, yet many still wait for IT to send them…
Many system replacement projects fail or slip, not because the new system does not work, but because the legacy data never makes it across. Data built up over many years tends to be inconsistent, full of duplicates and values that no longer mean anything to…
Many business analysts and system analysts have to wait for the development team or a DBA to pull data every time they need to check a problem case. The cycle is slow, and the data that comes back often does not answer the real question. Yet writing SQL well…
The most common problem in system projects is not badly written code but misunderstanding the data from the start. Requirement documents written as plain text, which do not say where each piece of data is stored, what it relates to or which business rules…
Many organisations want staff to ask questions of their databases in plain language instead of waiting for the data team to write SQL every time. Today's LLMs write SQL far better than before, but once they are connected to a real database the same problems…
Much of an organisation's sales, customer and usage data now lives in cloud data warehouses such as Google BigQuery, yet the people who need those numbers to make decisions still wait for the data team to pull them, or download them into Excel until the…
Many organisations still build reports by copying data out of several systems into Excel every week and passing the files around by email. The numbers never quite match, managers wait for their reports, and the people who make them spend their time on…
Semantic search and RAG have become features many organizations want in their applications, but adding a separate vector database means keeping data in sync across two systems, managing access control twice and taking on more operational work. For teams…
Systems wired together with direct point-to-point calls turn into a tangle as services multiply, and when a downstream system goes down the data goes with it. Apache Kafka solves this by acting as a durable central hub for events, so producers and consumers…
Many organizations already own BI tools such as Power BI or Tableau, yet still struggle with data preparation: pulling data from several systems by hand, cleaning it in Excel, and constantly finding that numbers do not match between reports. This course fills…
Business decisions today depend on both the accuracy and the speed of data. Organizations that can turn massive raw data into business insight faster gain a competitive edge. Microsoft Power BI is a business intelligence and analytics platform consistently…
Many organisations want every department to look at dashboards built on the same data, but are held back by per-user licence costs, data that must stay on their own servers, or a mix of databases their current tools cannot all connect to. Apache Superset is…
Redis is the in-memory database behind a great many systems, handling caching, sessions, job queues, real-time counters and leaderboards. Because it keeps data in RAM it responds extremely fast, but once it reaches production, operations teams often run into…
Modern applications store data as JSON documents whose structure can change, and users expect to type a search for products, articles or customers and get relevant results immediately, even with typos or different wording. Searching with LIKE in a typical…
SQL is still the most important basic skill for anyone who works with data, whether developer, data analyst or system administrator. MariaDB is a widely used open source database that runs websites, business systems and many systems migrated from MySQL. Yet…
MariaDB is an open source database that many organisations rely on for their websites and business systems. Yet many servers still run on installation defaults, with no tested restores, no standby replica and no idea which queries slow the system down. As…
