P01
Softwell Digital Practical Manual
Practical 01 - Install SQL Server Express
Philosophy: Open the software, open the Softwell manual, and perform the practical.
SQL ReportingDatabaseReportsAutomation
Software: SQL Server Express / SQL Server Management Studio
Setup: Engineering laptop, sample production and alarm dataset
01
STEP 01Install SQL Server Express and SQL Server Management Studio on the engineering laptop.
v
02
STEP 02Open SQL Server Management Studio and connect to the local SQL instance.
v
03
STEP 03Confirm the server name, authentication mode and connection status.
v
04
STEP 04Create a folder named D:\Softwell_Training\SQL_Reporting for scripts and exports.
v
Expected Result
SQL Server is installed, SSMS opens correctly, and the local SQL instance is ready for reporting work.
Talk to Automation Advisor
Get expert guidance for course selection, corporate training, project support and practical learning path.
Course GuidanceSelect the correct PLC SCADA, corporate, online or Industry 4.0 path.
Batch SupportGet schedule, duration, mode and prerequisite guidance.
Project AdviceDiscuss plant, automation, reporting or training requirement.
P02
Softwell Digital Practical Manual
Practical 02 - Create Training Database
Philosophy: Open the software, open the Softwell manual, and perform the practical.
SQL ReportingDatabaseReportsAutomation
Software: SQL Server Express / SQL Server Management Studio
Setup: Engineering laptop, sample production and alarm dataset
01
STEP 01In SSMS, right-click Databases and select New Database.
v
02
STEP 02Database name: Softwell_Reports.
v
03
STEP 03Keep default file locations unless your trainer gives a project server path.
v
04
STEP 04Click OK and refresh the database list.
v
Expected Result
Database Softwell_Reports is created and ready for table design.
Skills & Tools You Will Learn
Important automation skills are arranged for job-level, project-level and Industry 4.0 learning.
PLC ProgrammingLadder, SCL/ST, hardware, I/O mapping and troubleshooting.
SCADA / HMITags, screens, alarms, trends, scripts and reporting.
Industry 4.0 ToolsOPC UA, SQL Server, Python, dashboards and Excel/PDF reports.
P03
Softwell Digital Practical Manual
Practical 03 - Create Production Table
Philosophy: Open the software, open the Softwell manual, and perform the practical.
SQL ReportingDatabaseReportsAutomation
Software: SQL Server Express / SQL Server Management Studio
Setup: Engineering laptop, sample production and alarm dataset
01
STEP 01Open a new query window on Softwell_Reports.
v
02
STEP 02Create table ProductionLog with columns ID, TimeStamp, MachineName, BatchNo, GoodCount, RejectCount and SpeedRPM.
v
03
STEP 03Execute the CREATE TABLE query.
v
04
STEP 04Refresh Tables and confirm dbo.ProductionLog exists.
v
Expected Result
ProductionLog table is available with the required reporting columns.
P04
Softwell Digital Practical Manual
Practical 04 - Create Alarm History Table
Philosophy: Open the software, open the Softwell manual, and perform the practical.
SQL ReportingDatabaseReportsAutomation
Software: SQL Server Express / SQL Server Management Studio
Setup: Engineering laptop, sample production and alarm dataset
01
STEP 01Create table AlarmHistory with ID, TimeStamp, AlarmCode, AlarmText, Status and AcknowledgeUser.
v
02
STEP 02Set ID as an identity primary key.
v
03
STEP 03Execute the query and refresh Tables.
v
04
STEP 04Insert one test alarm record manually using an INSERT query.
v
Expected Result
AlarmHistory table stores timestamped alarm records correctly.
Why Choose Softwell Automation
Learn automation with practical examples, industrial troubleshooting approach and complete IT/OT learning path.
Industry Experienced TrainerReal plant examples and project based training.
Hands-on LearningPLC logic, SCADA, VFD, communication and reporting practice.
Flexible ModesOnline, classroom, corporate and in-plant options.
P05
Softwell Digital Practical Manual
Practical 05 - Insert Manual Test Records
Philosophy: Open the software, open the Softwell manual, and perform the practical.
SQL ReportingDatabaseReportsAutomation
Software: SQL Server Express / SQL Server Management Studio
Setup: Engineering laptop, sample production and alarm dataset
01
STEP 01Prepare five INSERT statements for ProductionLog.
v
02
STEP 02Use different machine names, batch numbers and count values.
v
03
STEP 03Execute the script and confirm no SQL errors.
v
04
STEP 04Run SELECT * FROM ProductionLog ORDER BY TimeStamp DESC.
v
Expected Result
Manual production records are inserted and visible in the report table.
Course Contents / Curriculum
The curriculum follows a practical sequence from fundamentals to project integration.
Level 01Basic PLC, wiring, addressing and ladder logic.
Level 02Advanced PLC, networking, SCADA and diagnostics.
Level 03OPC UA, SQL, Python, reports and IT/OT integration.
P06
Softwell Digital Practical Manual
Practical 06 - Import CSV Data
Philosophy: Open the software, open the Softwell manual, and perform the practical.
SQL ReportingDatabaseReportsAutomation
Software: SQL Server Express / SQL Server Management Studio
Setup: Engineering laptop, sample production and alarm dataset
01
STEP 01Create a CSV file with production columns matching ProductionLog.
v
02
STEP 02Use Import Flat File or BULK INSERT to load the CSV into SQL.
v
03
STEP 03Map CSV columns to table columns carefully.
v
04
STEP 04Run a SELECT query after import.
v
Expected Result
CSV production data is imported into SQL without missing rows.
Frequently Asked Questions About SQL Reporting Manual Database Reporting Practical Manual
Who can join this training?
Students, freshers, working engineers, maintenance teams and corporate plant engineers can join based on their requirement.
Is practical training included?
Yes. The training is focused on PLC, SCADA, HMI, VFD, communication, troubleshooting and project based practice.
Can I request online or corporate training?
Yes. Softwell Automation provides classroom, online, corporate and in-plant training options.
P07
Softwell Digital Practical Manual
Practical 07 - Create Shift Report View
Philosophy: Open the software, open the Softwell manual, and perform the practical.
SQL ReportingDatabaseReportsAutomation
Software: SQL Server Express / SQL Server Management Studio
Setup: Engineering laptop, sample production and alarm dataset
01
STEP 01Create a SQL view named vw_ShiftProduction.
v
02
STEP 02Group production by MachineName, BatchNo and shift date.
v
03
STEP 03Calculate TotalGood, TotalReject and TotalProduction.
v
04
STEP 04Execute the CREATE VIEW query.
v
Expected Result
Shift production view summarizes raw production data into report-ready rows.
P08
Softwell Digital Practical Manual
Practical 08 - Daily Summary Query
Philosophy: Open the software, open the Softwell manual, and perform the practical.
SQL ReportingDatabaseReportsAutomation
Software: SQL Server Express / SQL Server Management Studio
Setup: Engineering laptop, sample production and alarm dataset
01
STEP 01Write a query for today's production records.
v
02
STEP 02Use SUM for GoodCount and RejectCount.
v
03
STEP 03Calculate rejection percentage using a safe divide-by-zero expression.
v
04
STEP 04Order the result by machine name.
v
Expected Result
Daily summary query produces machine-wise production totals and rejection percentage.
P09
Softwell Digital Practical Manual
Practical 09 - Alarm History Report Query
Philosophy: Open the software, open the Softwell manual, and perform the practical.
SQL ReportingDatabaseReportsAutomation
Software: SQL Server Express / SQL Server Management Studio
Setup: Engineering laptop, sample production and alarm dataset
01
STEP 01Write a query for alarms between two timestamps.
v
02
STEP 02Filter AlarmHistory by TimeStamp range.
v
03
STEP 03Sort by TimeStamp descending.
v
04
STEP 04Show AlarmCode, AlarmText, Status and AcknowledgeUser.
v
Expected Result
Alarm report query lists filtered alarm history with acknowledgement details.
P10
Softwell Digital Practical Manual
Practical 10 - Energy Report Table
Philosophy: Open the software, open the Softwell manual, and perform the practical.
SQL ReportingDatabaseReportsAutomation
Software: SQL Server Express / SQL Server Management Studio
Setup: Engineering laptop, sample production and alarm dataset
01
STEP 01Create EnergyLog table with TimeStamp, MeterName, kWh and DemandKW.
v
02
STEP 02Insert sample energy records for at least two meters.
v
03
STEP 03Write a query to show total kWh per meter.
v
04
STEP 04Add date filtering to the query.
v
Expected Result
Energy report table and query calculate meter-wise consumption.
P11
Softwell Digital Practical Manual
Practical 11 - Stored Procedure Report
Philosophy: Open the software, open the Softwell manual, and perform the practical.
SQL ReportingDatabaseReportsAutomation
Software: SQL Server Express / SQL Server Management Studio
Setup: Engineering laptop, sample production and alarm dataset
01
STEP 01Create stored procedure sp_DailyProductionReport.
v
02
STEP 02Add parameters @FromTime and @ToTime.
v
03
STEP 03Use the parameters in the WHERE clause.
v
04
STEP 04Execute the stored procedure with sample dates.
v
Expected Result
Stored procedure generates reusable production report output for any date range.
P12
Softwell Digital Practical Manual
Practical 12 - Batch Report
Philosophy: Open the software, open the Softwell manual, and perform the practical.
SQL ReportingDatabaseReportsAutomation
Software: SQL Server Express / SQL Server Management Studio
Setup: Engineering laptop, sample production and alarm dataset
01
STEP 01Write a query filtered by BatchNo.
v
02
STEP 02Join production and alarm data by time window if sample data allows.
v
03
STEP 03Show batch counts, rejects and related alarms.
v
04
STEP 04Save the query as batch-report.sql.
v
Expected Result
Batch report displays production and quality data for selected batches.
P13
Softwell Digital Practical Manual
Practical 13 - Export Report to CSV
Philosophy: Open the software, open the Softwell manual, and perform the practical.
SQL ReportingDatabaseReportsAutomation
Software: SQL Server Express / SQL Server Management Studio
Setup: Engineering laptop, sample production and alarm dataset
01
STEP 01Run the daily summary query in SSMS.
v
02
STEP 02Use Save Results As or SQLCMD export method.
v
03
STEP 03Save output as DailyProductionReport.csv.
v
04
STEP 04Open the CSV in Excel and verify headings and rows.
v
Expected Result
SQL report output exports cleanly to CSV for Excel use.
P14
Softwell Digital Practical Manual
Practical 14 - Excel Report Connection
Philosophy: Open the software, open the Softwell manual, and perform the practical.
SQL ReportingDatabaseReportsAutomation
Software: SQL Server Express / SQL Server Management Studio
Setup: Engineering laptop, sample production and alarm dataset
01
STEP 01Open Excel and use Get Data from SQL Server.
v
02
STEP 02Connect to the local SQL instance and Softwell_Reports database.
v
03
STEP 03Select vw_ShiftProduction or a report query.
v
04
STEP 04Load the result into a worksheet.
v
Expected Result
Excel is connected to SQL and can refresh reporting data.
P15
Softwell Digital Practical Manual
Practical 15 - PDF Report Preparation
Philosophy: Open the software, open the Softwell manual, and perform the practical.
SQL ReportingDatabaseReportsAutomation
Software: SQL Server Express / SQL Server Management Studio
Setup: Engineering laptop, sample production and alarm dataset
01
STEP 01Format the Excel report with title, date range and totals.
v
02
STEP 02Set print area and page orientation.
v
03
STEP 03Export the Excel sheet as PDF.
v
04
STEP 04Open the PDF and verify layout, headings and totals.
v
Expected Result
SQL report is converted into a readable PDF report.
P16
Softwell Digital Practical Manual
Practical 16 - Schedule Auto Report
Philosophy: Open the software, open the Softwell manual, and perform the practical.
SQL ReportingDatabaseReportsAutomation
Software: SQL Server Express / SQL Server Management Studio
Setup: Engineering laptop, sample production and alarm dataset
01
STEP 01Create a batch file or PowerShell script to run a saved SQL export.
v
02
STEP 02Test the script manually from Command Prompt or PowerShell.
v
03
STEP 03Open Windows Task Scheduler.
v
04
STEP 04Create a daily task for the report script.
v
Expected Result
Report export runs automatically through a scheduled task.
P17
Softwell Digital Practical Manual
Practical 17 - Database Backup
Philosophy: Open the software, open the Softwell manual, and perform the practical.
SQL ReportingDatabaseReportsAutomation
Software: SQL Server Express / SQL Server Management Studio
Setup: Engineering laptop, sample production and alarm dataset
01
STEP 01Right-click Softwell_Reports and choose Tasks > Back Up.
v
02
STEP 02Select Full backup type.
v
03
STEP 03Save backup as Softwell_Reports.bak.
v
04
STEP 04Run the backup and confirm success.
v
Expected Result
Database backup file is created for reporting project safety.
P18
Softwell Digital Practical Manual
Practical 18 - Database Restore Test
Philosophy: Open the software, open the Softwell manual, and perform the practical.
SQL ReportingDatabaseReportsAutomation
Software: SQL Server Express / SQL Server Management Studio
Setup: Engineering laptop, sample production and alarm dataset
01
STEP 01Create a restore test database named Softwell_Reports_Test.
v
02
STEP 02Restore from Softwell_Reports.bak.
v
03
STEP 03Check Tables, Views and Stored Procedures after restore.
v
04
STEP 04Run one report query from the restored database.
v
Expected Result
Backup file restores successfully and reports run from restored data.
P19
Softwell Digital Practical Manual
Practical 19 - User Permission Setup
Philosophy: Open the software, open the Softwell manual, and perform the practical.
SQL ReportingDatabaseReportsAutomation
Software: SQL Server Express / SQL Server Management Studio
Setup: Engineering laptop, sample production and alarm dataset
01
STEP 01Create a SQL login or database user for report reading.
v
02
STEP 02Assign read-only permission to report tables and views.
v
03
STEP 03Test login access from SSMS.
v
04
STEP 04Confirm the user can SELECT report data.
v
Expected Result
Report user has safe read-only access for reporting.
P20
Softwell Digital Practical Manual
Practical 20 - Final SQL Reporting Project
Philosophy: Open the software, open the Softwell manual, and perform the practical.
SQL ReportingDatabaseReportsAutomation
Software: SQL Server Express / SQL Server Management Studio
Setup: Engineering laptop, sample production and alarm dataset
01
STEP 01Prepare production, alarm and energy tables.
v
02
STEP 02Create required views and stored procedures.
v
03
STEP 03Export one CSV report and one PDF report.
v
04
STEP 04Schedule one automated report task.
v
Expected Result
Complete SQL reporting workflow is ready with tables, queries, exports, automation and backup.
