Databases · DBC-02-09

ASP.NET Core with SQL Server and Power BI Report Server

ASP.NET Core with SQL Server and Power BI Report Server is a course in building a complete business system, from designing a SQL Server database and writing T-SQL to building a website with ASP.NET Core Razor Pages and EF Core and producing paginated reports in Report Builder. It suits company IT staff and newcomers building web applications that work with a database.

Updated 9 Oct 2026

From 10,350 THB / person 11,500 −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

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 ASP.NET Core, SQL Server and a report server, and from SQL Server 2025 on-premises reporting is consolidated under Power BI Report Server in place of SSRS.

This course builds a complete business system from start to finish. Learners design a database on SQL Server 2025 using normalisation and DDL, write T-SQL, views and stored procedures, then build a website with ASP.NET Core 10 Razor Pages in Visual Studio 2026, connect it to the database with EF Core 10, add data-management screens and membership, and deploy to IIS. They then build paginated reports in Report Builder, create shared datasets so users can build their own reports, call reports from the website and look after the report server. (3 days, 6 hours per day, 18 hours in total, Beginner - Intermediate level.)

What you’ll gain

Design SQL Server 2025 databases with normalisation and DDL statements
Write T-SQL, views and stored procedures for web pages and reports
Develop web applications with ASP.NET Core 10 Razor Pages in Visual Studio 2026
Build screens to view, add, delete and edit data with EF Core 10
Add membership and user permissions, and deploy the site to IIS
Build paginated reports and shared datasets with Report Builder
Call reports from the website with URL access and the report server REST API
Handle basic report server security and subscriptions

Who this course is for

Company IT staff who build or maintain in-house systems on SQL Server
Newcomers to web development who need to work with databases and reports
Teams still on ASP.NET Web Forms and older SSRS who want to modernise
Anyone who wants to see how a business system is built from database to report

Prerequisites

Some programming experience in any language; experience with C# helps
Familiarity with databases and basic SQL such as SELECT and WHERE
Confident use of Windows and a web browser
A Windows laptop that can run Visual Studio, SQL Server and a report server, with administrator rights

Curriculum

Course Details

This course is the 2026 edition of ASP.NET Core with SQL Server and SSRS, which originally taught ASP.NET 4.0 with SQL Server 2012. It has been rewritten for .NET 10 (LTS), ASP.NET Core 10, Visual Studio 2026, SQL Server 2025 and Power BI Report Server. It runs for 3 days, 6 hours per day (18 hours in total, 09:00-16:00), as lectures with labs built around a sample shop system developed throughout the course. Beginner - Intermediate level.

Day one designs the database and starts the website with Razor Pages, day two builds data-management screens with EF Core 10, membership and IIS deployment, and day three builds paginated reports in Report Builder, calls them from the website and covers report server administration. Labs use the free Developer and Community editions for development and testing; production use requires a valid SQL Server licence. Learners take home the database scripts, source code and report files for every lab.

Day 1 Database Design and a First Website

Section 1: Lab: Setting Up the Tools and the Big Picture

How the database, web application and report server work together
Install SQL Server 2025 Developer Edition and SSMS
Install Visual Studio 2026 Community with the .NET 10 SDK
How ASP.NET Core differs from the older ASP.NET Web Forms
Lab: connect to a sample database and create a first project

Section 2: Designing a Sample Shop Database

Gather requirements from sales, HR and warehouse teams
Draw an ER diagram and define primary and foreign keys
Normalisation to 1NF, 2NF and 3NF to reduce duplicated data
Choose data types that suit Thai text, dates and money
Workshop: design the tables for a sales and stock system

Section 3: Lab: Building the Database with DDL

CREATE TABLE, ALTER TABLE and DROP TABLE
Constraints: PRIMARY KEY, FOREIGN KEY, UNIQUE, CHECK and DEFAULT
Basic indexes on frequently searched tables
Keep database scripts in Git so the database can be rebuilt
Lab: create the shop database with sample data

Section 4: Lab: T-SQL for Web Pages and Reports

Common SELECT, JOIN, GROUP BY and subquery patterns
Create views for sales reports
Stored procedures with parameters
Transactions and error handling with TRY...CATCH
Lab: a stored procedure that records a sale and reduces stock

Section 5: Lab: Getting Started with Razor Pages

The structure of an ASP.NET Core 10 project and Program.cs
Razor pages with a PageModel and OnGet and OnPost handlers
Layouts, partial views and Tag Helpers in place of the old server controls
Routing and passing values between pages
Lab: the home page and menu of the shop system

Day 2 Data Screens and Going Live

Section 6: Lab: Connecting to SQL Server with EF Core 10

Install the EF Core package for SQL Server
Scaffold models from an existing database (database first)
Keep the connection string in appsettings.json and register the DbContext
Call stored procedures and views from EF Core
Lab: list products from the database on a web page

Section 7: Lab: Screens to View, Add, Delete and Edit Data

Create CRUD pages with Visual Studio scaffolding
Adapt the screens to each department's real work
Search, filter and page through data
Drop-down lists for related data such as categories and suppliers
Lab: product and employee management pages

Section 8: Forms, Validation and State Management

Model binding and data annotations for validation
Show error messages in the browser and on the server
When to use session, TempData and cookies
Protect against CSRF with the anti-forgery tokens forms provide
Lab: a sales entry form with a shopping basket

Section 9: Lab: Membership and User Permissions

Add ASP.NET Core Identity to the web application
Sign-in, sign-out and user account management
Roles and page-level authorisation
Show each department only its own menu items
Lab: separate permissions for administrators, sales staff and warehouse staff

Section 10: Lab: Deploying to IIS

Install IIS and the ASP.NET Core Hosting Bundle
Publish from Visual Studio and configure the application pool
Per-environment settings and keeping secrets safe
Database permissions for the app, and logs for troubleshooting
Lab: run the shop system on a server in the local network

Day 3 Reporting with Power BI Report Server

Section 11: Lab: SSRS and Power BI Report Server in 2026

SQL Server 2025 consolidates on-premises reporting under Power BI Report Server
The support lifetime of SSRS 2022, and RDL reports that run on both platforms
Install Power BI Report Server in developer mode and set up the report server database
The web portal, folders and backing up the encryption key
Lab: open the web portal and prepare report folders for each department

Section 12: Lab: Building Paginated Reports in Report Builder

Data sources and datasets from views and stored procedures
Tables with grouping and subtotals, and matrices
Charts and indicators for management reports
Parameters and drillthrough to detail reports
Lab: a print-ready monthly sales report by branch

Section 13: Lab: Shared Datasets and Self-Service Reporting

Create shared data sources and shared datasets on the report server
Let business users build their own reports and charts in Report Builder
Export to PDF, Excel and Word
Grant users rights to create reports in their own folders
Lab: sales staff build their own report from a shared dataset

Section 14: Lab: Calling Reports from an ASP.NET Core Site

URL access for opening reports with parameters and output formats
Add report links to web pages according to the user's permissions
Call the report server REST API from C# with HttpClient
Download a report as PDF straight from the website
Lab: a button that prints a sales summary from the order page

Section 15: Workshop: Report Server Administration and the Complete System

Role-based security at folder and report level
Subscriptions that email reports on a schedule
Back up and restore the report server database and encryption key
Workshop: a sales system with data-entry screens and a full set of reports, then present the result

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 are Razor Pages in ASP.NET Core, and how do they differ from Web Forms and MVC?

Razor Pages is an ASP.NET Core model that organises code by page: each page has a cshtml file for the markup paired with a PageModel class with handlers such as OnGet and OnPost. It feels familiar to Web Forms developers but has no ViewState or old-style server controls. MVC instead splits code into controllers, models and views. Razor Pages therefore suits straightforward form-based, data-management sites well.

Can SSRS still be used, or should we move to Power BI Report Server?

From SQL Server 2025, Microsoft consolidates on-premises reporting under Power BI Report Server and will release no new versions of SSRS. SSRS 2022 is the final version and is supported until 11 January 2033. RDL reports built with Report Builder run on both platforms, so existing systems can carry on for a while, but new systems should be planned on Power BI Report Server, which comes with SQL Server 2025 Standard and Enterprise licences.

What are the steps to connect ASP.NET Core to SQL Server with Entity Framework Core?

Install the EF Core package for SQL Server, then create model classes and a DbContext, either by hand or by scaffolding them from an existing database. Add the connection string to appsettings.json and register the DbContext in Program.cs. If you design from code, create or update the database with migrations, then use the DbContext in your pages to display, add, delete and edit data.

Who is the ASP.NET Core with SQL Server and Power BI Report Server course for, and what should I know beforehand?

It suits company IT staff who build or maintain systems on SQL Server, newcomers to web development who work with databases and reports, and teams still on Web Forms and older SSRS. You should have some programming experience and know basic SQL; experience with C# will help you keep pace.

What will I be able to do after the ASP.NET Core with SQL Server and Power BI Report Server course?

You will be able to design SQL Server 2025 databases with normalisation and DDL, write T-SQL and stored procedures, build websites with ASP.NET Core 10 Razor Pages and EF Core 10, add membership and deploy to IIS, build paginated reports and shared datasets in Report Builder, call reports from the website and handle basic report server administration. Participants who complete the training receive a Certificate of Completion with its own number, which can be verified online.

Which tools are used on the ASP.NET Core with SQL Server and Power BI Report Server course?

The course uses Visual Studio 2026 Community with the .NET 10 SDK to build ASP.NET Core sites in C#, SQL Server 2025 Developer Edition with SSMS and EF Core 10 for the database, IIS with the ASP.NET Core Hosting Bundle for deployment, and Power BI Report Server in developer mode with Microsoft Report Builder for reports. These tools are free for development and testing.

Articles are published in Thai.