Visual C# and ADO.NET Programming - 12 Months Online Access

Problem Domain to Business Solution | taught by Everest Nwosu

Course description

START DEVELOPING BUSINESS-RELATED APPLICATIONS

This is a 9-hours comprehensive project-based course that covers everything required to develop and deploy a fully-functional, data-driven application from Business Needs, Graphic User Interface Design, Complex User Input Validations, ADO.NET Secure Database Programming, Searching Mechanism, Printing Functionality, Payroll Computation, Reporting Facilities, Multiple Document Interface & MenuStrip, Registration & Log In functionality, System Implementation and Deployment.

This is a Beginner's-Level course, and the goal here is to learn some basic C# and ADO.NET programming concepts, using a project-based approach.

By the end of the course, you should be comfortable developing and deploying a basic business applications from Problem domain to Business Solutions.



Everest Nwosu
Everest Nwosu
Software Engineer

Everest is a Software Engineer in the city of London.

Agile Certified, awarded by DSDM Consortium.

MSc Software Engineering awarded by Kingston University, UK

BSc (Hons) Computer Science (1st Class) awarded by Plymouth University, UK



Course Curriculum

Chapter 1 : Introduction
09:43
Lecture 1 : Introduction/Trailer FREE PREVIEW
Lecture 2 : Payroll System Requirement
Lecture 3 : Installation Guide
Hide Content
Chapter 2 : Database Design
11:19
Lecture 4 : Create Database, Tables and Relationship
Hide Content
Chapter 3 : Employee Form Module
145:58
Lecture 5 : Employee Form Design
Lecture 6 : Implicit Validation
Lecture 7 : Explicit Validation FREE PREVIEW
Lecture 8 : Regular Expression - Part 1
Lecture 9 : Regular Expression - Part 2
Lecture 10 : Clear Controls
Lecture 11 : Preview Form - Parameters vs Arguments Part 1
Lecture 12 : Preview Form - Parameters vs Arguments Part 2
Lecture 13 : Introduction to ADO.NET
Lecture 14 : Add Employee Functionality
Lecture 15 - Update Employee Functionality Part 1
Lecture 16 - Update Employee Functionality Part 2
Lecture 17 - Delete Employee's Record
Lecture 18 - Code Review
Hide Content
Chapter 4 : Payroll Calculator Module
164:14
Lecture 19 : Payroll Calculator Form Design
Lecture 20 : DataReader - Retrieve Employee's Record FREE PREVIEW
Lecture 21: Arrays vs List Collection
Lecture 22 : For Loop vs Foreach Loop vs Foreach Method
Lecture 23 : Payment Computation
Lecture 24 : SavingPayRecords - using Parameterized Command
Lecture 25 : Pass-By-Value vs Pass-By-Reference
Lecture 26 : Out vs Ref Keywords
Lecture 27 : Time to Decimal Conversion
Lecture 28 : Linked Label and Digital Timer
Lecture 29 : String vs StringBuider Class FREE PREVIEW
Hide Content
Chapter 5 : Search Functionality
11:23
Lecture 30 : Search PayRecords - StringBuilder Object
Hide Content
Chapter 6 : Printing Functionality
19:23
Lecture 31 : Generate and Print Payslip
Hide Content
Chapter 7 : AboutBox, MDI and MenuStrip
26:08
Lecture 32 : AboutBox - Product Information
Lecture 33 : Mutiple Document Interface (MDI) and Menustrip
Hide Content
Chapter 8 : Reporting Facilities
27:44
Lecture 34 : Reporting Facilities I
Lecture 35 : Reporting Facilities II
Hide Content
Chapter 9 : Log In & Registration Module
72:29
Lecture 36 : Log In and Registration Form Design
Lecture 37 : Add User's Table to Database
Lecture 38 : Complex Password Validation
Lecture 39 : Creating a Class, Object & using Member Variables FREE PREVIEW
Lecture 40 : Constructors - Class Member
Lecture 41 : Properties & Methods - Class Members
Hide Content
Chapter 10 : Stored Procedure
58:47
Lecture 42 : Stored Procedure - spInsertCommand
Lecture 43 : Stored Procedure - spUpdateCommand
Lecture 44 : Stored Procedure - spDeleteCommand
Lecture 45 : Stored Procedure - DataReader
Lecture 46 : Stored Procedure - spAuthorisedUsers
Hide Content
Chapter 11 : Deployment
12:53
Lecture 47 : FormClosing - Exiting Application
Lecture 48 : Payroll System Deployment - using ClickOnce
Hide Content
Resources
Images and Icons
Hide Content