Databases · DBC-17

Microsoft SQL Server 2025 Database Basic

Microsoft SQL Server 2025 Database Basic is a hands-on foundation course in the current SQL Server release, from installing it and using SSMS to creating databases, tables and constraints, writing SELECT queries and joins, building views, stored procedures and triggers, and importing and exporting data with Excel. It suits beginners, students, teachers and IT staff who need to work with databases.

Updated 9 Oct 2026

From 7,110 THB / person 7,900 −10% excl. VAT 7% · group rates available

Corporate training quote Join the waiting list

PDFDownload the course outline

Duration18 hours · 3 days
FormatOnsite / live online
Next roundOn request
CertificateIncluded

Course overview

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 books and examples still rely on the 2017 release, which has left mainstream support, and on tools that have since been retired.

This course lays the foundations of Microsoft SQL Server 2025: relational database concepts, installing Developer or Express Edition and using the latest SQL Server Management Studio, creating databases, tables and constraints, inserting, updating and deleting data, and writing SELECT queries with WHERE, ORDER BY, GROUP BY, UNION and every type of join. Learners use built-in functions, including the regular expression functions added in 2025, build views, stored procedures, functions and triggers, handle errors with TRY...CATCH, and import and export data with Excel, CSV and MySQL.

What you’ll gain

Understand relational database concepts and install SQL Server 2025 and SSMS yourself
Create, alter and drop databases and tables, with constraints and relationships
Insert, update and delete data safely using transactions
Write SELECT queries that filter, sort, group and combine data from several tables with joins
Build views, stored procedures, functions and triggers, and handle errors
Import and export data with Excel, CSV and other databases

Who this course is for

Beginners who need to work with SQL Server databases
Students, teachers and lecturers who teach or run projects involving databases
IT teams, system administrators and developers who write SQL in their daily work
Excel users who want to move data into a database and build their own reports

Prerequisites

Basic computer skills such as copying, pasting and creating files and folders
Comfortable using Windows (macOS users can run SQL Server in Docker)
Some experience of Excel or a database helps, but no prior SQL is required
A laptop with permission to install software

Curriculum

Course Details

This course is the 2026 edition of Microsoft SQL Server Database Basic, rewritten for SQL Server 2025 and current tools. It runs for 3 days, 6 hours per day (18 hours in total, 09:00-16:00), as lectures with labs on a sample sales database. Beginner level. Day one covers installing SQL Server and creating databases, tables and constraints. Day two covers SELECT, built-in functions, grouping and joins. Day three covers stored procedures, functions, triggers, error handling, and importing and exporting data. This is a foundation course; learners who want to go deeper into CTEs, window functions and execution plans can continue with Microsoft SQL Server 2025 Database Queries. Learners take home the SQL scripts for every lab and the sample database.

Day 1 SQL Server 2025, Databases and Tables

Section 1: Databases and SQL Server 2025

Relational databases (RDBMS): tables, rows, columns and keys
SQL Server 2025 editions: Express, Standard, Enterprise and Developer
SQL Server on Windows, Linux and Docker, and an overview of Azure SQL in the cloud
What SQL and T-SQL are used for
Lab: explore a sample database and sketch the relationships between its tables

Section 2: Lab: Installing SQL Server 2025 and SSMS

Installing Developer or Express Edition and choosing the features you need
Authentication mode, the sa account and setting a secure password
Installing the latest SQL Server Management Studio, Object Explorer and the Query Editor
The macOS option: running SQL Server in Docker and connecting with VS Code
Lab: install SQL Server and connect to it from your own laptop

Section 3: Lab: Creating and Managing Databases and Tables

CREATE, ALTER and DROP DATABASE with both T-SQL and the GUI
Problems when dropping a database that is in use, and how to solve them
Common data types: int, decimal, nvarchar, date, datetime2 and bit
CREATE, ALTER and DROP TABLE, and writing comments in scripts
Lab: create the database and the customer, product and order tables

Section 4: Lab: Constraints and Table Relationships

Primary keys, IDENTITY and SEQUENCE
Foreign keys and the effect of ON DELETE and ON UPDATE
UNIQUE, CHECK, DEFAULT and NOT NULL
Basic normalisation and good table design
Lab: link the sales tables with foreign keys and test the constraints

Section 5: Lab: Inserting, Updating and Deleting Data (DML)

Multi-row INSERT and INSERT ... SELECT
UPDATE and DELETE with the right WHERE clause
BEGIN TRANSACTION, COMMIT and ROLLBACK for safe changes
The OUTPUT clause for seeing inserted, updated or deleted values
Lab: load sample data and change prices for a whole category in a way you can undo

Day 2 Querying with SELECT, Functions and Joins

Section 6: Lab: SELECT, WHERE and ORDER BY

Choosing columns, aliases and calculations in SELECT
Filtering with comparison operators, AND, OR, IN, BETWEEN and LIKE
Handling NULL with IS NULL, ISNULL and COALESCE
Sorting with ORDER BY and paging with TOP and OFFSET FETCH
Lab: find customers and products that meet business conditions

Section 7: Lab: Built-in Functions

String functions: LEFT, SUBSTRING, REPLACE, TRIM, CONCAT and the || operator
Date functions: GETDATE, DATEADD, DATEDIFF, EOMONTH and FORMAT
Converting types with CAST, CONVERT and TRY_CONVERT
Checking and fixing data patterns with REGEXP_LIKE and REGEXP_REPLACE in SQL Server 2025
Lab: clean customer phone numbers and email addresses, then format the output with CASE

Section 8: Lab: Grouping and Combining Results

Aggregate functions: COUNT, SUM, AVG, MIN and MAX
GROUP BY and filtering groups with HAVING
How UNION and UNION ALL differ
EXCEPT and INTERSECT for comparing two data sets
Lab: summarise monthly sales and find customers with no orders

Section 9: Lab: Every Type of Join

INNER JOIN and joining several tables
LEFT, RIGHT and FULL OUTER JOIN
CROSS JOIN and SELF JOIN
Common mistakes, such as duplicate rows from joining on the wrong column
Lab: an order report with customer, product and salesperson names

Section 10: Lab: Views, Derived Tables and Temporary Tables

Creating and using views to store frequently used queries
Derived tables in the FROM clause
How temp tables (#) and table variables differ
Choosing the right option for the job
Lab: a sales summary view for the reporting team

Day 3 Programming in the Database and Moving Data

Section 11: Lab: Stored Procedures and Preventing SQL Injection

Creating, altering and executing stored procedures
Input parameters, default values and optional parameters
Output parameters and return values
How SQL injection happens and why parameters help prevent it
Lab: procedures that search and add orders and return the new IDENTITY value with SCOPE_IDENTITY

Section 12: Lab: User-Defined Functions

Built-in functions versus user-defined functions
Scalar functions that return a single value
Inline table-valued functions that return a result set
Choosing between functions, views and stored procedures
Lab: a discount function and a function returning sales for a date range

Section 13: Lab: Triggers, Error Handling and Cursors

AFTER and INSTEAD OF triggers with the inserted and deleted tables
ALTER and DROP TRIGGER, and performance considerations
TRY...CATCH, THROW and transactions in stored procedures
How cursors work, and when to use a set-based approach instead
Lab: a trigger that logs price changes and a procedure that rolls back on error

Section 14: Lab: Importing and Exporting Data

The SQL Server Import and Export Wizard with Excel and flat files
Selecting only the data you need with a query during import and export
BULK INSERT and bcp for large CSV files
Moving data between SQL Server databases and importing from MySQL through ODBC
Lab: import a customer list from Excel and export a multi-table report to files

Section 15: Workshop: A Sales Database from Start to Finish

Designing tables and relationships from a business brief
Creating tables and constraints and loading starting data from files
Writing views and stored procedures for the reports users need
Basic backup and restore with SSMS
Presenting the result and planning the next learning steps

Schedule & training options

For individuals — public rounds

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

Join the waiting list Ask about rounds

For organisations — in-house / private

Tailor the content to your team’s tools and projects
Your dates, at your office or live online
Quotation with tax ID for procurement

Corporate training quote

Instructors

Sanitwong KamonpakornInstructor

Frequently asked questions

What is a stored procedure, and how does it help prevent SQL injection?

A stored procedure is a saved set of T-SQL statements that you run again with EXEC. It accepts input parameters and can return values through output parameters or a return value. When an application passes user input as parameters rather than building SQL strings itself, the input is treated as data rather than executed as code, which greatly reduces the risk of SQL injection. If the procedure itself builds dynamic SQL, it should still use sp_executesql with parameters.

What is the difference between INNER JOIN and LEFT OUTER JOIN?

An INNER JOIN returns only rows with matching values in both tables. A LEFT OUTER JOIN returns every row from the left table and fills the right-hand columns with NULL where there is no match. To list all customers, including those who have never ordered, use a LEFT JOIN from customers to orders. RIGHT and FULL OUTER JOIN work the same way but keep the right-hand rows or both sides.

How do you import data from Excel into SQL Server?

In SQL Server Management Studio, right-click the target database and choose Tasks, then Import Data, to open the SQL Server Import and Export Wizard. Choose Microsoft Excel as the source, select the file and sheet, pick an existing destination table or create a new one, check the column mappings and data types, then run the import. For large or regular imports, saving the data as CSV and loading it with BULK INSERT or bcp is faster and easier to repeat.

Who is the Microsoft SQL Server 2025 Database Basic course for, and what should I know beforehand?

It suits beginners, students, teachers, IT staff and Excel users who are starting to work with SQL Server databases. No prior SQL is required. You need basic computer skills, to be comfortable with Windows and a laptop on which you can install software. macOS users can run SQL Server in Docker.

What will I be able to do after the Microsoft SQL Server 2025 Database Basic course?

You will be able to install and configure SQL Server 2025 and SSMS yourself, create databases, tables and constraints, change data safely with transactions, write SELECT queries with WHERE, ORDER BY, GROUP BY and the various joins, build views, stored procedures, functions and triggers, handle errors, and import and export data with Excel, CSV and MySQL. Participants receive a Certificate of Completion.

Can the Microsoft SQL Server 2025 Database Basic course be run in-house for our team?

Yes. It can be run in-house for your team, with examples adapted to your own work, such as practising queries on table structures similar to the systems you already use. 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.