SQL Server Practical Manual Industrial SQL Database Practical Manual
Official Philosophy: Open the software, open the Softwell Notebook, and perform the practical.
20 Matching Lab Practicals
Action Flow Manual
No Theory / Only Practical
Softwell Training Template
Softwell Digital Practical Notebook
[check] Open -> Click -> Select -> Download -> Test -> Complete
NO THEORY * ONLY PRACTICAL
P01
Softwell Digital Practical Manual
Practical 01 - Install SQL Server and SSMS
Philosophy: Open the software, open the Softwell manual, and perform the practical.
SQL ServerDatabaseReportsHistorian
Software: SQL Server Express / Standard and SQL Server Management Studio Setup: Engineering laptop, local SQL instance, sample production and alarm dataset
01
STEP 01
Open SQL Server Express / Standard and SQL Server Management Studio and load the training project for SQL Server Practical Manual.
v
02
STEP 02
Create or open the practical object for Install SQL Server and SSMS.
v
03
STEP 03
Configure the required tags, parameters, blocks or screen objects for this SQL Server reporting workflow.
v
04
STEP 04
Run compile, simulation, runtime or online monitoring as applicable and verify the practical behavior.
v
05
STEP 05
Save the work, record the result and tick Practical Install SQL Server and SSMS as complete.
Expected Result
Install SQL Server and SSMS is completed, verified and documented inside the SQL Server Practical Manual workflow.
P02
Softwell Digital Practical Manual
Practical 02 - Create Training Database
Philosophy: Open the software, open the Softwell manual, and perform the practical.
SQL ServerDatabaseReportsHistorian
Software: SQL Server Express / Standard and SQL Server Management Studio Setup: Engineering laptop, local SQL instance, sample production and alarm dataset
01
STEP 01
Open SQL Server Express / Standard and SQL Server Management Studio and load the training project for SQL Server Practical Manual.
v
02
STEP 02
Create or open the practical object for Create Training Database.
v
03
STEP 03
Configure the required tags, parameters, blocks or screen objects for this SQL Server reporting workflow.
v
04
STEP 04
Run compile, simulation, runtime or online monitoring as applicable and verify the practical behavior.
v
05
STEP 05
Save the work, record the result and tick Practical Create Training Database as complete.
Expected Result
Create Training Database is completed, verified and documented inside the SQL Server Practical Manual workflow.
P03
Softwell Digital Practical Manual
Practical 03 - Create Production Table
Philosophy: Open the software, open the Softwell manual, and perform the practical.
SQL ServerDatabaseReportsHistorian
Software: SQL Server Express / Standard and SQL Server Management Studio Setup: Engineering laptop, local SQL instance, sample production and alarm dataset
01
STEP 01
Open SQL Server Express / Standard and SQL Server Management Studio and load the training project for SQL Server Practical Manual.
v
02
STEP 02
Create or open the practical object for Create Production Table.
v
03
STEP 03
Configure the required tags, parameters, blocks or screen objects for this SQL Server reporting workflow.
v
04
STEP 04
Run compile, simulation, runtime or online monitoring as applicable and verify the practical behavior.
v
05
STEP 05
Save the work, record the result and tick Practical Create Production Table as complete.
Expected Result
Create Production Table is completed, verified and documented inside the SQL Server Practical Manual workflow.
P04
Softwell Digital Practical Manual
Practical 04 - Create Alarm History Table
Philosophy: Open the software, open the Softwell manual, and perform the practical.
SQL ServerDatabaseReportsHistorian
Software: SQL Server Express / Standard and SQL Server Management Studio Setup: Engineering laptop, local SQL instance, sample production and alarm dataset
01
STEP 01
Open SQL Server Express / Standard and SQL Server Management Studio and load the training project for SQL Server Practical Manual.
v
02
STEP 02
Create or open the practical object for Create Alarm History Table.
v
03
STEP 03
Configure the required tags, parameters, blocks or screen objects for this SQL Server reporting workflow.
v
04
STEP 04
Run compile, simulation, runtime or online monitoring as applicable and verify the practical behavior.
v
05
STEP 05
Save the work, record the result and tick Practical Create Alarm History Table as complete.
Expected Result
Create Alarm History Table is completed, verified and documented inside the SQL Server Practical Manual workflow.
P05
Softwell Digital Practical Manual
Practical 05 - Insert Manual Test Records
Philosophy: Open the software, open the Softwell manual, and perform the practical.
SQL ServerDatabaseReportsHistorian
Software: SQL Server Express / Standard and SQL Server Management Studio Setup: Engineering laptop, local SQL instance, sample production and alarm dataset
01
STEP 01
Open SQL Server Express / Standard and SQL Server Management Studio and load the training project for SQL Server Practical Manual.
v
02
STEP 02
Create or open the practical object for Insert Manual Test Records.
v
03
STEP 03
Configure the required tags, parameters, blocks or screen objects for this SQL Server reporting workflow.
v
04
STEP 04
Run compile, simulation, runtime or online monitoring as applicable and verify the practical behavior.
v
05
STEP 05
Save the work, record the result and tick Practical Insert Manual Test Records as complete.
Expected Result
Insert Manual Test Records is completed, verified and documented inside the SQL Server Practical Manual workflow.
P06
Softwell Digital Practical Manual
Practical 06 - Import CSV Data
Philosophy: Open the software, open the Softwell manual, and perform the practical.
SQL ServerDatabaseReportsHistorian
Software: SQL Server Express / Standard and SQL Server Management Studio Setup: Engineering laptop, local SQL instance, sample production and alarm dataset
01
STEP 01
Open SQL Server Express / Standard and SQL Server Management Studio and load the training project for SQL Server Practical Manual.
v
02
STEP 02
Create or open the practical object for Import CSV Data.
v
03
STEP 03
Configure the required tags, parameters, blocks or screen objects for this SQL Server reporting workflow.
v
04
STEP 04
Run compile, simulation, runtime or online monitoring as applicable and verify the practical behavior.
v
05
STEP 05
Save the work, record the result and tick Practical Import CSV Data as complete.
Expected Result
Import CSV Data is completed, verified and documented inside the SQL Server Practical Manual workflow.
P07
Softwell Digital Practical Manual
Practical 07 - Create Shift Report View
Philosophy: Open the software, open the Softwell manual, and perform the practical.
SQL ServerDatabaseReportsHistorian
Software: SQL Server Express / Standard and SQL Server Management Studio Setup: Engineering laptop, local SQL instance, sample production and alarm dataset
01
STEP 01
Open SQL Server Express / Standard and SQL Server Management Studio and load the training project for SQL Server Practical Manual.
v
02
STEP 02
Create or open the practical object for Create Shift Report View.
v
03
STEP 03
Configure the required tags, parameters, blocks or screen objects for this SQL Server reporting workflow.
v
04
STEP 04
Run compile, simulation, runtime or online monitoring as applicable and verify the practical behavior.
v
05
STEP 05
Save the work, record the result and tick Practical Create Shift Report View as complete.
Expected Result
Create Shift Report View is completed, verified and documented inside the SQL Server Practical Manual workflow.
P08
Softwell Digital Practical Manual
Practical 08 - Daily Summary Query
Philosophy: Open the software, open the Softwell manual, and perform the practical.
SQL ServerDatabaseReportsHistorian
Software: SQL Server Express / Standard and SQL Server Management Studio Setup: Engineering laptop, local SQL instance, sample production and alarm dataset
01
STEP 01
Open SQL Server Express / Standard and SQL Server Management Studio and load the training project for SQL Server Practical Manual.
v
02
STEP 02
Create or open the practical object for Daily Summary Query.
v
03
STEP 03
Configure the required tags, parameters, blocks or screen objects for this SQL Server reporting workflow.
v
04
STEP 04
Run compile, simulation, runtime or online monitoring as applicable and verify the practical behavior.
v
05
STEP 05
Save the work, record the result and tick Practical Daily Summary Query as complete.
Expected Result
Daily Summary Query is completed, verified and documented inside the SQL Server Practical Manual workflow.
P09
Softwell Digital Practical Manual
Practical 09 - Alarm History Query
Philosophy: Open the software, open the Softwell manual, and perform the practical.
SQL ServerDatabaseReportsHistorian
Software: SQL Server Express / Standard and SQL Server Management Studio Setup: Engineering laptop, local SQL instance, sample production and alarm dataset
01
STEP 01
Open SQL Server Express / Standard and SQL Server Management Studio and load the training project for SQL Server Practical Manual.
v
02
STEP 02
Create or open the practical object for Alarm History Query.
v
03
STEP 03
Configure the required tags, parameters, blocks or screen objects for this SQL Server reporting workflow.
v
04
STEP 04
Run compile, simulation, runtime or online monitoring as applicable and verify the practical behavior.
v
05
STEP 05
Save the work, record the result and tick Practical Alarm History Query as complete.
Expected Result
Alarm History Query is completed, verified and documented inside the SQL Server Practical Manual workflow.
P10
Softwell Digital Practical Manual
Practical 10 - Energy Report Table
Philosophy: Open the software, open the Softwell manual, and perform the practical.
SQL ServerDatabaseReportsHistorian
Software: SQL Server Express / Standard and SQL Server Management Studio Setup: Engineering laptop, local SQL instance, sample production and alarm dataset
01
STEP 01
Open SQL Server Express / Standard and SQL Server Management Studio and load the training project for SQL Server Practical Manual.
v
02
STEP 02
Create or open the practical object for Energy Report Table.
v
03
STEP 03
Configure the required tags, parameters, blocks or screen objects for this SQL Server reporting workflow.
v
04
STEP 04
Run compile, simulation, runtime or online monitoring as applicable and verify the practical behavior.
v
05
STEP 05
Save the work, record the result and tick Practical Energy Report Table as complete.
Expected Result
Energy Report Table is completed, verified and documented inside the SQL Server Practical Manual workflow.
P11
Softwell Digital Practical Manual
Practical 11 - Stored Procedure Report
Philosophy: Open the software, open the Softwell manual, and perform the practical.
SQL ServerDatabaseReportsHistorian
Software: SQL Server Express / Standard and SQL Server Management Studio Setup: Engineering laptop, local SQL instance, sample production and alarm dataset
01
STEP 01
Open SQL Server Express / Standard and SQL Server Management Studio and load the training project for SQL Server Practical Manual.
v
02
STEP 02
Create or open the practical object for Stored Procedure Report.
v
03
STEP 03
Configure the required tags, parameters, blocks or screen objects for this SQL Server reporting workflow.
v
04
STEP 04
Run compile, simulation, runtime or online monitoring as applicable and verify the practical behavior.
v
05
STEP 05
Save the work, record the result and tick Practical Stored Procedure Report as complete.
Expected Result
Stored Procedure Report is completed, verified and documented inside the SQL Server Practical Manual workflow.
P12
Softwell Digital Practical Manual
Practical 12 - Batch Report Query
Philosophy: Open the software, open the Softwell manual, and perform the practical.
SQL ServerDatabaseReportsHistorian
Software: SQL Server Express / Standard and SQL Server Management Studio Setup: Engineering laptop, local SQL instance, sample production and alarm dataset
01
STEP 01
Open SQL Server Express / Standard and SQL Server Management Studio and load the training project for SQL Server Practical Manual.
v
02
STEP 02
Create or open the practical object for Batch Report Query.
v
03
STEP 03
Configure the required tags, parameters, blocks or screen objects for this SQL Server reporting workflow.
v
04
STEP 04
Run compile, simulation, runtime or online monitoring as applicable and verify the practical behavior.
v
05
STEP 05
Save the work, record the result and tick Practical Batch Report Query as complete.
Expected Result
Batch Report Query is completed, verified and documented inside the SQL Server Practical Manual workflow.
P13
Softwell Digital Practical Manual
Practical 13 - Export Report to CSV
Philosophy: Open the software, open the Softwell manual, and perform the practical.
SQL ServerDatabaseReportsHistorian
Software: SQL Server Express / Standard and SQL Server Management Studio Setup: Engineering laptop, local SQL instance, sample production and alarm dataset
01
STEP 01
Open SQL Server Express / Standard and SQL Server Management Studio and load the training project for SQL Server Practical Manual.
v
02
STEP 02
Create or open the practical object for Export Report to CSV.
v
03
STEP 03
Configure the required tags, parameters, blocks or screen objects for this SQL Server reporting workflow.
v
04
STEP 04
Run compile, simulation, runtime or online monitoring as applicable and verify the practical behavior.
v
05
STEP 05
Save the work, record the result and tick Practical Export Report to CSV as complete.
Expected Result
Export Report to CSV is completed, verified and documented inside the SQL Server Practical Manual workflow.
P14
Softwell Digital Practical Manual
Practical 14 - Excel SQL Connection
Philosophy: Open the software, open the Softwell manual, and perform the practical.
SQL ServerDatabaseReportsHistorian
Software: SQL Server Express / Standard and SQL Server Management Studio Setup: Engineering laptop, local SQL instance, sample production and alarm dataset
01
STEP 01
Open SQL Server Express / Standard and SQL Server Management Studio and load the training project for SQL Server Practical Manual.
v
02
STEP 02
Create or open the practical object for Excel SQL Connection.
v
03
STEP 03
Configure the required tags, parameters, blocks or screen objects for this SQL Server reporting workflow.
v
04
STEP 04
Run compile, simulation, runtime or online monitoring as applicable and verify the practical behavior.
v
05
STEP 05
Save the work, record the result and tick Practical Excel SQL Connection as complete.
Expected Result
Excel SQL Connection is completed, verified and documented inside the SQL Server Practical Manual workflow.
P15
Softwell Digital Practical Manual
Practical 15 - PDF Report Preparation
Philosophy: Open the software, open the Softwell manual, and perform the practical.
SQL ServerDatabaseReportsHistorian
Software: SQL Server Express / Standard and SQL Server Management Studio Setup: Engineering laptop, local SQL instance, sample production and alarm dataset
01
STEP 01
Open SQL Server Express / Standard and SQL Server Management Studio and load the training project for SQL Server Practical Manual.
v
02
STEP 02
Create or open the practical object for PDF Report Preparation.
v
03
STEP 03
Configure the required tags, parameters, blocks or screen objects for this SQL Server reporting workflow.
v
04
STEP 04
Run compile, simulation, runtime or online monitoring as applicable and verify the practical behavior.
v
05
STEP 05
Save the work, record the result and tick Practical PDF Report Preparation as complete.
Expected Result
PDF Report Preparation is completed, verified and documented inside the SQL Server Practical Manual workflow.
P16
Softwell Digital Practical Manual
Practical 16 - Schedule Auto Report
Philosophy: Open the software, open the Softwell manual, and perform the practical.
SQL ServerDatabaseReportsHistorian
Software: SQL Server Express / Standard and SQL Server Management Studio Setup: Engineering laptop, local SQL instance, sample production and alarm dataset
01
STEP 01
Open SQL Server Express / Standard and SQL Server Management Studio and load the training project for SQL Server Practical Manual.
v
02
STEP 02
Create or open the practical object for Schedule Auto Report.
v
03
STEP 03
Configure the required tags, parameters, blocks or screen objects for this SQL Server reporting workflow.
v
04
STEP 04
Run compile, simulation, runtime or online monitoring as applicable and verify the practical behavior.
v
05
STEP 05
Save the work, record the result and tick Practical Schedule Auto Report as complete.
Expected Result
Schedule Auto Report is completed, verified and documented inside the SQL Server Practical Manual workflow.
P17
Softwell Digital Practical Manual
Practical 17 - Database Backup
Philosophy: Open the software, open the Softwell manual, and perform the practical.
SQL ServerDatabaseReportsHistorian
Software: SQL Server Express / Standard and SQL Server Management Studio Setup: Engineering laptop, local SQL instance, sample production and alarm dataset
01
STEP 01
Open SQL Server Express / Standard and SQL Server Management Studio and load the training project for SQL Server Practical Manual.
v
02
STEP 02
Create or open the practical object for Database Backup.
v
03
STEP 03
Configure the required tags, parameters, blocks or screen objects for this SQL Server reporting workflow.
v
04
STEP 04
Run compile, simulation, runtime or online monitoring as applicable and verify the practical behavior.
v
05
STEP 05
Save the work, record the result and tick Practical Database Backup as complete.
Expected Result
Database Backup is completed, verified and documented inside the SQL Server Practical Manual workflow.
P18
Softwell Digital Practical Manual
Practical 18 - Database Restore Test
Philosophy: Open the software, open the Softwell manual, and perform the practical.
SQL ServerDatabaseReportsHistorian
Software: SQL Server Express / Standard and SQL Server Management Studio Setup: Engineering laptop, local SQL instance, sample production and alarm dataset
01
STEP 01
Open SQL Server Express / Standard and SQL Server Management Studio and load the training project for SQL Server Practical Manual.
v
02
STEP 02
Create or open the practical object for Database Restore Test.
v
03
STEP 03
Configure the required tags, parameters, blocks or screen objects for this SQL Server reporting workflow.
v
04
STEP 04
Run compile, simulation, runtime or online monitoring as applicable and verify the practical behavior.
v
05
STEP 05
Save the work, record the result and tick Practical Database Restore Test as complete.
Expected Result
Database Restore Test is completed, verified and documented inside the SQL Server Practical Manual workflow.
P19
Softwell Digital Practical Manual
Practical 19 - Read Only User Permission
Philosophy: Open the software, open the Softwell manual, and perform the practical.
SQL ServerDatabaseReportsHistorian
Software: SQL Server Express / Standard and SQL Server Management Studio Setup: Engineering laptop, local SQL instance, sample production and alarm dataset
01
STEP 01
Open SQL Server Express / Standard and SQL Server Management Studio and load the training project for SQL Server Practical Manual.
v
02
STEP 02
Create or open the practical object for Read Only User Permission.
v
03
STEP 03
Configure the required tags, parameters, blocks or screen objects for this SQL Server reporting workflow.
v
04
STEP 04
Run compile, simulation, runtime or online monitoring as applicable and verify the practical behavior.
v
05
STEP 05
Save the work, record the result and tick Practical Read Only User Permission as complete.
Expected Result
Read Only User Permission is completed, verified and documented inside the SQL Server Practical Manual workflow.
P20
Softwell Digital Practical Manual
Practical 20 - Final SQL Server Project
Philosophy: Open the software, open the Softwell manual, and perform the practical.
SQL ServerDatabaseReportsHistorian
Software: SQL Server Express / Standard and SQL Server Management Studio Setup: Engineering laptop, local SQL instance, sample production and alarm dataset
01
STEP 01
Open SQL Server Express / Standard and SQL Server Management Studio and load the training project for SQL Server Practical Manual.
v
02
STEP 02
Create or open the practical object for Final SQL Server Project.
v
03
STEP 03
Configure the required tags, parameters, blocks or screen objects for this SQL Server reporting workflow.
v
04
STEP 04
Run compile, simulation, runtime or online monitoring as applicable and verify the practical behavior.
v
05
STEP 05
Save the work, record the result and tick Practical Final SQL Server Project as complete.
Expected Result
Final SQL Server Project is completed, verified and documented inside the SQL Server Practical Manual workflow.
