Basic SQL and Reporting with SSRS
Basic SQL and Reporting with SSRS is a course in writing SQL on SQL Server 2025, from SELECT, joins, functions and grouping to subqueries and views, then turning the results into paginated reports with Report Builder on Power BI Report Server. It suits IT staff, system administrators and anyone who reports from a database, and you leave able to build and publish reports yourself.
- Duration30 hours · 5 days
- FormatOnsite / live online
- Next roundOn request
- CertificateIncluded
Course overview
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 paginated reports, you can publish printable reports with date pickers that managers and other departments open in a web browser at any time.
This course starts with relational database basics on SQL Server 2025 and practises SQL from SELECT, filtering, joins, functions, grouping, subqueries, views and CTEs to safe data changes and stored procedures for reports. You then turn those queries into paginated (RDL) reports with Report Builder and publish them on Power BI Report Server, the on-premises reporting platform of the current SQL Server, which uses the same reports as SSRS. The course ends with a workshop that builds a sales report set from the query to the web portal (5 days, 6 hours per day, 30 hours in total, Beginner to Intermediate level).
What you’ll gain
- Understand relational database structure, primary keys, foreign keys and indexes on SQL Server 2025
- Write SELECT statements with conditions, sorting and NULL handling
- Query multiple tables with joins, use built-in functions, and group and summarise data
- Write subqueries, views and CTEs, and insert, update and delete data safely
- Build paginated reports with grouping, matrices, parameters, charts and drill-through in Report Builder
- Publish reports to a report server and assign user permissions
Who this course is for
- IT staff and system administrators who extract data and build reports from SQL Server
- Analysts and business staff who want to build their own reports without waiting for IT
- Teachers, lecturers and students who want SQL and reporting skills used in organisations
- Administrators of existing SSRS reports preparing to move to Power BI Report Server
Prerequisites
- Confident with a Windows computer and the internet
- No programming or database experience needed
- Experience of tables or summaries in Excel will help
- Able to install software on your own computer, or have Administrator rights from your organisation
Curriculum
Course Details
This is the 2026 edition of the Basic SQL and Reporting with SSRS course. It runs for 5 days, 6 hours per day (30 hours in total, 09:00-16:00), as lectures with a lab in every topic, at Beginner to Intermediate level. The SQL content moves from SQL Server 2016 to SQL Server 2025 and adds transactions and stored procedures for reports. The reporting part follows Microsoft's change to consolidate on-premises reporting under Power BI Report Server from SQL Server 2025, using Report Builder to create RDL reports that work on both SSRS and Power BI Report Server. Learners take home a sample database, SQL scripts for every lab and sample report files.
Day 1 Databases and the SELECT Statement
Section 1: Lab: Relational Databases and SQL Server 2025
- Tables, rows, columns and relationships between tables
- How primary keys, foreign keys and indexes keep data correct and fast to search
- SQL Server 2025 editions: Express, Developer, Standard and Enterprise
- Lab: connect with SSMS and explore a sample sales database
Section 2: Lab: Writing Simple SELECT Statements
- Selecting the columns you need, and why to avoid SELECT *
- Column and table aliases, and DISTINCT to remove duplicates
- Calculated columns and joining text with CONCAT and the || operator
- CASE expressions to turn codes into readable words
- Lab: list products with their price after discount
Section 3: Lab: Filtering and Sorting Data
- WHERE with comparison operators, AND, OR and NOT
- IN, BETWEEN and LIKE for common conditions
- ORDER BY on several columns, TOP and OFFSET-FETCH for paging
- Lab: find sales by date range, branch and product group
Section 4: Lab: Data Types and NULL Values
- Numeric, text, nvarchar for Thai and date and time types
- What NULL means and comparing with IS NULL
- Replacing missing values with ISNULL and COALESCE
- Lab: find customers with no contact details and show a readable placeholder
Day 2 Joins, Functions and Summarising Data
Section 5: Lab: Querying Multiple Tables with Joins
- INNER JOIN and choosing the columns that link tables
- LEFT, RIGHT and FULL OUTER JOIN for rows without a match
- CROSS JOIN and self joins, such as employees and their managers
- Lab: sales lines with customer, product and salesperson names
Section 6: Lab: Text and Date Functions
- LEFT, SUBSTRING, TRIM, REPLACE and LEN for working with text
- DATEADD, DATEDIFF, EOMONTH and DATETRUNC for period-based reports
- Checking data patterns with REGEXP_LIKE in SQL Server 2025
- Lab: extract the branch code from document numbers and calculate debt age
Section 7: Lab: Converting Data and Checking Values
- CAST, CONVERT and TRY_CONVERT when data is not clean
- IIF, CHOOSE and NULLIF for short conditions
- Formatting numbers and dates in the query or leaving it to the report
- Lab: prepare sales data ready for reporting
Section 8: Lab: Grouping and Summarising Data
- Aggregate functions COUNT, SUM, AVG, MIN and MAX
- GROUP BY on several levels and filtering totals with HAVING
- How WHERE and HAVING differ and when to use each
- Lab: monthly sales totals by branch and product group
Day 3 Nested Queries, Views and Changing Data
Section 9: Lab: Subqueries and EXISTS
- Self-contained subqueries that return one or many values
- Correlated subqueries that refer to the outer query
- EXISTS and NOT EXISTS compared with IN
- Lab: find customers who have not ordered in the latest quarter
Section 10: Lab: Views, Derived Tables and CTEs
- Derived tables and common table expressions (CTEs) for readable queries
- Views that store frequently used queries for several reports
- Inline table-valued functions that take parameters
- Lab: create a sales view for reporting
Section 11: Lab: Inserting, Updating and Deleting Data Safely
- INSERT one or many rows, and INSERT from a SELECT
- UPDATE and DELETE, always checking the WHERE clause first
- Automatic numbering with IDENTITY and SEQUENCE
- Transactions with BEGIN TRANSACTION, COMMIT and ROLLBACK
- Lab: change prices for a whole product group and undo it if something is wrong
Section 12: Lab: Stored Procedures for Reports
- Creating stored procedures that take parameters such as date range and branch
- How parameters help prevent SQL injection
- Read-only permissions for the account that reports use to read data
- Lab: a sales-by-date-range stored procedure ready for a report
Day 4 The Report Server and Paginated Reports
Section 13: Microsoft Reporting Today
- How paginated (RDL) reports differ from interactive Power BI reports
- SQL Server 2025 consolidates on-premises reporting under Power BI Report Server
- SSRS 2022 is the final release, and RDL reports run on both platforms
- Report server components: the web portal, web service and report server database
Section 14: Lab: Installing the Report Server and Report Builder
- Installing Power BI Report Server Developer edition
- Setting up the report server database and URLs with Report Server Configuration Manager
- Backing up the encryption key from day one
- Lab: install Microsoft Report Builder and open the web portal for the first time
Section 15: Lab: Building a First Table Report
- Data sources and datasets from a view or stored procedure
- A table data region with number, date and currency formatting
- Page header, page footer, page numbers and paper size for printing
- Lab: a printable daily sales report exported to PDF
Section 16: Lab: Grouping, Matrices and Expressions
- Row groups with subtotals and grand totals
- A matrix for cross-tab reports, such as branch by month
- Expressions and calculated fields with Sum, Count and IIf
- Lab: sales by branch and month with values below target highlighted
Day 5 Interactive Reports, Publishing and Workshop
Section 17: Lab: Parameters and Filters
- Single-value and multi-value report parameters with defaults
- Available values from a dataset and cascading parameters
- Passing parameters to a stored procedure compared with filtering in the report
- Lab: a report where users choose the branch and date range
Section 18: Lab: Charts and Drilling into Data
- Choosing the right chart: column, line and pie
- Data bars and indicators inside a table
- Drilldown with toggle visibility and drill-through to a detail report
- Lab: a sales summary that drills through to each individual invoice
Section 19: Lab: Deploying and Managing Reports on the Server
- Saving reports to the web portal and organising folders
- Shared data sources and stored connection credentials
- Assigning viewer permissions with role-based security
- Exporting to PDF and Excel, and an overview of email subscriptions
- Lab: publish a report set with permissions by department
Section 20: Workshop: A Sales Report Set from Query to Web Portal
- Designing views and stored procedures from a management brief
- Building a summary report with parameters, charts and drill-through
- Deploying to the report server and testing with users at several levels
- Workshop: present the report set and a go-live checklist
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
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
Instructors
Frequently asked questions
What is the difference between INNER JOIN and LEFT OUTER JOIN?
INNER JOIN returns only rows that have a match in both tables, while LEFT OUTER JOIN returns every row from the left table and fills the right table's columns with NULL when there is no match. For example, to list every customer with their purchases, including customers who have never bought anything, use a LEFT JOIN from the customer table to the sales table and use COALESCE to show 0 instead of NULL.
What is the difference between WHERE and HAVING in SQL?
WHERE filters rows before grouping, while HAVING filters the results after GROUP BY, so it can use aggregate functions such as SUM or COUNT. For example, use WHERE to keep only this year's sales, then HAVING with SUM of sales to show only branches whose total exceeds the target. Filter with WHERE as much as possible first, because it reduces the rows to group and makes the query faster.
Can I still use SSRS, or do I need to move to Power BI Report Server?
Yes. Microsoft states that SSRS 2022 is supported until 11 January 2033, but no new versions of SSRS will be released. From SQL Server 2025, on-premises reporting is consolidated under Power BI Report Server, which is available with SQL Server 2025 Standard and Enterprise licences and supports the same RDL reports as SSRS. The reports you build in this course therefore work on both platforms, and the course points out the differences to know when planning a migration.
What are the steps to build a report from a database with Report Builder?
Start by preparing a query or view that returns the data the report needs. In Report Builder, create a data source that connects to SQL Server, create a dataset from the query or a stored procedure, then add a table or matrix, group the data, add totals and format numbers and dates. Add parameters so users can choose the data range, test with Run, save the report to the report server's web portal and assign viewer permissions. Users then open the report in a web browser and can export it to PDF or Excel.
Who is the Basic SQL and Reporting with SSRS course for, and what should I know beforehand?
It suits IT staff, system administrators, analysts and business staff who extract data and build reports from SQL Server, as well as teachers, lecturers and students. You do not need programming or database experience, only confidence with a computer and the ability to install software on your own machine. If you want advanced queries or in-depth report server administration, continue with the Microsoft SQL Server 2025 Database Queries course and the SSRS and Power BI Report Server with Report Builder course.
Can the Basic SQL and Reporting with SSRS 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 a database structure similar to your organisation's system or reports that follow the forms your department already uses. You can request a quotation from this page, or contact us on LINE @itgenius or by phone on 02-570-8449.
Related articles
Articles are published in Thai.