Instructor-led IT courses across web, mobile, data, design and more.
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…
Many problems in business systems start with the database structure: duplicated data that is changed in one place but not another, reports that pull figures that do not match, or systems where new features are hard to add because the tables were related…
Many modern applications need to store data whose structure changes often or is nested several levels deep, such as product data where each type has different attributes, user profiles or logs from different systems. A NoSQL database such as MongoDB stores…
Many organisations still use Crystal Reports every day for invoices, receipts, sales reports and reports from ERP or accounting software. Common tasks include fixing reports that someone designed long ago, adding conditions users can choose themselves, or…
Exchange Server 2016 and 2019 reached the end of support on 14 October 2025, so organisations that want to keep email on their own servers need to move to Exchange Server Subscription Edition (SE), the only version that still receives regular security updates…
PostgreSQL has become the main database for many organizations, both for new systems and for systems migrated from Oracle, SQL Server or MySQL. Getting it installed and running is only the start. What keeps a system alive is tuning it for the hardware,…
People who can already write some SQL soon meet questions that a plain SELECT and JOIN cannot answer, such as ranking sales within each region, comparing with the previous month, calculating running totals or reading JSON from another system. The result is…
SQL Server is one of the most widely used databases in Thai organisations, behind accounting, sales and internal systems. Anyone starting to work with data needs to create tables, write SQL to pull data into reports and bring Excel data into the system. Yet…
Many organisations keep their data spread across Excel workbooks, CSV files and several databases. Every month end, staff copy, paste and reformat the same reports, figures from different departments do not match, and managers do not see the big picture in…
Most organisations already have data on sales, customers, stock and marketing, but it is spread across many files and systems, Excel reports have to be rebuilt by hand every month, and the charts often miss the business question. Tableau Desktop lets you…
Systems that take in huge volumes of data all the time, such as IoT device readings, usage history, chat messages or online service logs, need a database that writes fast, scales by adding machines and does not go down when one machine fails. Apache Cassandra…
Much of the work in organisations that run Oracle Database involves multi-step data processing, such as payroll calculations, end-of-day closing or moving data between tables. Written as one SQL statement at a time from the application side, this work is…
Once you can build reports in Crystal Reports, real work in an organisation gets harder: aged debtors reports split into day ranges, customer statements with an opening balance and a running balance, target versus actual reports drawn from different data…
Most of an organisation's data lives in databases, yet the people who need it often have to wait for IT to extract it or build a report every time. If you can write SQL, you can pull sales figures, customer lists or statistics yourself, and if you can build…
Many in-house business systems need three things at once: a well-designed central database, web pages where staff can enter and search data, and form-style reports that can be printed or exported to PDF and Excel. Microsoft's stack covers all of this with…
The database is at the heart of an organisation's systems, so a database administrator (DBA) has to keep data available, recoverable when things go wrong, safe from unauthorised access and consistently fast. SQL Server 2025 adds features that help directly…
PostgreSQL has become the first-choice database for modern applications, from backend systems and SaaS products to workloads that keep JSON or vector data alongside relational tables. Yet many developers still treat PostgreSQL as a generic database behind an…
MySQL sits behind a great many systems, from websites and ERP platforms to internal business applications. As those systems grow, administrators need to decide which MySQL release to run, how to configure it to be fast and secure, which backups can genuinely…
Paginated reports that print neatly to a set layout, arrive in executives' inboxes every morning and can be opened in a browser from one central place are still at the heart of reporting in many organisations that run SQL Server. In 2026, though, the platform…
