Visual Basic SQL Case Study - Samples Tracking System VB.net and SQL

SQL Case Study - Samples Tracking System VB.net and SQL

Catalog: Visual Basic
Short name: Upgrade - STS - VB.net and SQL
Course start date: 2023-02-24
Paystack

Description

This course focuses on developing the Samples Tracking System (STS) utilising the.Net framework's VB.Net programming language and SQL Server database.

In-depth work on database design, UI development, coding, unit testing, and system testing for the app will all be done as part of this practical project.


Participants will work with VB.Net, ADO.Net, and SQL Server by the end of the course.

• Create forms, controls, menus, etc.

• In SQL Server, create databases, tables, constraints, stored procedures, etc.

• Unit testing, debugging, and VB.Net code

• Work on data objects for ADO.Net.


The course has an Advanced difficulty level, and programming and database skills are prerequisites. Knowing will be advantageous. SQL fundamentals, VB.Net, and the Net foundation.

( Duration-: 3h 5m)

Sections

General
0 activities

Intro to Samples Tracking System
Tables Creation
Functions Creation
Menu and Entity
Products and Transactions
Running Balance Report
Transfer of Samples
Entity Part 1
Entity Part 2
Entity Part 3
Products
Populating Data
Transactions Report
Transactions Report Continue
Get Running Balance Function
Stored Process
Stored Process Continue
More on Stored Process
Manufacturing Process
Transfer Process
Transfer Process Continue
Course Certificate

Secure Video
21
Certificate
1
Cost: 5000