Instructor-led IT courses across web, mobile, data, design and more.
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…
Systems built on SQL Server often slow down as data and users grow. Many teams respond by adding CPU or RAM, or by creating every index that is suggested, without knowing the real cause, so costs rise and the problem keeps coming back. Effective tuning starts…
Blazor lets C# developers build interactive web pages using the same language on the front end and the back end, and Blazor WebAssembly runs .NET code directly in the browser. Paired with MongoDB, which stores flexible documents, it makes web applications…
Many teams can already write DAX, yet they still meet measures that return wrong figures when a slicer changes, totals that do not match the sum of their rows, formulas so long that nobody dares to edit them, and reports that slow down as the data grows. The…
Once you can build reports in Power BI, the next questions are usually about figures that do not exist in the data directly, such as profit per line, year-to-date sales, a comparison with last year or a product ranking. The answer is DAX (Data Analysis…
Before you can build a dashboard, most data has to be prepared. Excel files have multi-level headers, monthly figures sit in columns, product names are spelt inconsistently and data from several systems has to be brought together. Fixing this by hand every…
The data in an Oracle database is often the heart of an organisation's systems, yet many sites still have backups that have never been test-restored, do not know whether they can roll data back to before a mistake, and have no clear procedure for when a disk…
