DBA Microsoft SQL Server 2025 is a course in administering SQL Server, from installation, file structure and locking to backup and recovery planning, security, monitoring, automation and high availability with log shipping and Always On. It suits database administrators and anyone starting a career as a DBA on Microsoft SQL Server.
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 with this work, such as ZSTD backup compression, backup to immutable storage, optimized locking, tempdb space governance and TDS 8.0 connection encryption, and raises the limits of the Standard and Express editions.
This course covers SQL Server administration from architecture, installation and database file structure through transactions and locking, backup and restore planning, logins, roles and data protection, monitoring with DMVs, Extended Events and Query Store, automation with SQL Server Agent and data movement, to high availability with log shipping and Always On. It finishes with a workshop on planning ongoing administration and upgrading older versions to SQL Server 2025. (3 days, 6 hours per day, 18 hours in total, Intermediate level.)
Course Details
This course is the 2026 edition of DBA Microsoft SQL Server 2019, updated for SQL Server 2025. It runs for 3 days, 6 hours per day (18 hours in total, 09:00-16:00), as lectures with labs that simulate real incidents. Intermediate level. Day one covers architecture, installation, file structure, locking and backup, day two covers restore, security, monitoring and automation, and day three covers data movement, log shipping, Always On, Query Store and a workshop on administration planning and upgrades. Labs use SQL Server 2025 Developer Edition on Windows and Docker, free for development and testing; production use requires the organisation's own licence. Learners take home T-SQL and PowerShell scripts plus backup and DR plan templates.
Section 1: Lab: SQL Server 2025 Architecture and Installation
Section 2: Database File Structure and Recovery Models
Section 3: Lab: Creating and Managing Databases
Section 4: Lab: Transactions, Locking and Blocking
Section 5: Lab: Planning and Running Backups
Section 6: Lab: Restore and Integrity Checks
Section 7: Lab: Logins, Users and Roles
Section 8: Lab: Data Protection and Auditing
Section 9: Lab: Monitoring SQL Server
Section 10: Lab: Automating Administration
Section 11: Lab: Moving and Importing Data
Section 12: Lab: Log Shipping
Section 13: Always On and Failover Clustering
Section 14: Lab: Query Store, In-Memory OLTP and Graph
Section 15: Workshop: Administration Planning and Upgrades
No public rounds are open right now. Join the waiting list and we will contact you first when the next round opens, or ask us on LINE. Or call 02-570-8449 or 088-807-9770
There are three. Full keeps every transaction in the log until the log is backed up, so you can restore to any point in time; it suits production systems. Bulk-logged is similar but minimally logs bulk operations to keep the log smaller, and is used temporarily during large imports. Simple truncates the log automatically and has no log backups, so you can only restore to the latest backup; it suits test databases or data that can be recreated.
Start by agreeing with the system owner how much data loss is acceptable (RPO) and how quickly the system must be back (RTO), then design full, differential and log backups to match. Use CHECKSUM and backup compression; SQL Server 2025 adds the faster and more effective ZSTD algorithm. Keep copies off the server, for example backup to URL on immutable storage to guard against ransomware, and above all test real restores regularly.
Log shipping copies transaction log backups from the primary server and restores them on a standby server on a schedule. It is simple to set up and available in several editions, but the standby lags by the schedule interval and failover is manual. Always On availability groups send changes continuously in synchronous or asynchronous mode, provide a listener so applications connect to one name, support automatic failover and allow readable secondaries, but they need a cluster and the full feature set requires Enterprise Edition.
It suits database administrators running SQL Server who want to update to the 2025 release, IT administrators responsible for database servers, developers who want to understand what happens behind the scenes, and people starting a DBA career. You should be able to write basic SQL and T-SQL, understand tables and indexes at a basic level, and use Windows Server or Linux.
You will be able to install and configure SQL Server 2025, manage database files and tempdb, resolve locking and deadlock problems, plan backups and point-in-time recovery, manage permissions and protect data with TDE and auditing, monitor with DMVs, Extended Events and Query Store, automate tasks with SQL Server Agent, and set up log shipping and Always On, together with an administration and upgrade plan. Participants who complete the training receive a Certificate of Completion with its own number, which can be verified online.
Yes. It can be run in-house for your team, with examples adapted to your own work, such as planning backup and DR for the systems your team runs, or preparing an upgrade from an older SQL Server version to 2025. You can request a quotation from this page, or contact us on LINE @itgenius or by phone on 02-570-8449.
Articles are published in Thai.
Today's web applications need to respond quickly, feel as smooth as a mobile app and be easy to extend as the system grows. React is one of the most widely used libraries for building user interfaces because it splits a page into reusable components, and it…
As a React app grows, components that simply work are no longer enough. Teams need types that catch mistakes before the code runs, a clear way to manage state, secure login and tests that make changes safe. React 19 and today's tools make all of this much…
Kubernetes is the standard platform for running containerised applications, both in the cloud and in an organisation's own data centre. It lets systems heal themselves when something fails, scale with demand and roll out new versions without downtime. Yet…
