Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Meditation Personal Transformation Life Purpose Emotional Intelligence Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Google Analytics
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Modeling Data Analysis Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Blogging Freelancing Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Development Software Engineering Ado.Net

Visual C# and ADO.NET Programming

Case Study - Payroll System
Rating: 4.5 out of 54.5 (154 ratings)
16,299 students
Created by Everest Nwosu
Last updated 1/2020
English
30-Day Money-Back Guarantee

What you'll learn

  • By the end of the course, you should be comfortable developing and deploying basic business applications from Problem domain to Business Solutions using C# and ADO (dot) NET.

Course content

11 sections • 51 lectures • 9h 20m total length

  • Preview01:42
  • Payroll System Requirement
    05:40
  • Installation Guide
    02:20

  • Create Database, Tables and Relationship
    11:18

  • Employee Form Design
    17:55
  • Implicit Validation
    09:04
  • Preview15:58
  • Regular Expression - Part 1
    12:19
  • Regular Expression - Part 2
    13:35
  • Clear Controls
    04:28
  • PreviewForm - Parameter vs Argument - Part 1
    13:06
  • Preview11:51
  • Preview04:00
  • Add Functionality
    19:21
  • Preview06:18
  • Update Functionality Part 2
    07:39
  • Delete Employee Records
    06:01
  • Preview04:14

  • Payroll Calculator Form Design Part 1
    10:41
  • Payroll Calculator Form Design Part 2
    13:20
  • Retrieve Employee - DataReader
    14:46
  • Array Vs List Collection
    16:40
  • For Loop vs Foreach Loop vs ForEach Method
    05:42
  • Payroll Computation - Part 1
    15:14
  • Payroll Computation - Part 2
    10:42
  • Saving PayRecords - using Parameterised Command
    15:04
  • Pass-By-Value vs Pass-By-Reference
    17:59
  • Out vs Ref Keywords
    08:03
  • Time to Decimal Conversion
    13:31
  • Linked Label and Digital Timer
    05:31
  • Preview17:59

  • Search Functionality
    11:22

  • Printing Functionality - Payslip
    19:22

  • AboutBox - Product Information
    06:11
  • Multiple Document Interface(MDI) and MenuStrip
    19:55

  • Reporting facilities - Part 1
    13:06
  • Reporting Facilities - Part 2
    14:37

  • LogIn and RegisterUser Form Design
    16:30
  • Registered User's Table
    03:17
  • Complex Password Validation
    19:55
  • Class, Object and Member Variables
    16:55
  • Constructors
    06:37
  • Properties & Methods - Class Member
    09:12

  • Stored Procedure - spInsertCommand
    18:29
  • Stored Procedure - spUpdateCommand
    11:36
  • Stored Procedure - spDeleteCommand
    05:47
  • Stored Procedure - DataReader
    09:32
  • Stored Procedure - spAuthorisedUsers
    13:21

Requirements

  • Little or no programming experience is assume at a beginner level

Description

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.


Who this course is for:

  • Any one interested in developing lightweight data-driven application development using C# programming language.

Instructor

Everest Nwosu
Software Engineer/Programmer
Everest Nwosu
  • 4.5 Instructor Rating
  • 431 Reviews
  • 22,060 Students
  • 2 Courses

My name is Everest Nwosu.

I am an Agile Certified (awarded by DSDM Consortium) Software Engineer and a passionate instructor. 

As a progressive-learner, i have successfully earned two academic degrees :  BSc (Hons) Computer Sc.(1st Class) awarded by Plymouth University, UK  &  MSc Software Engineering(Commendation) awarded by Kingston University, UK).

I have 1.5 decade IT experience, ranging from Field Support IT Engineer to enterprise-level Software Engineering. Ever since, I have been exposed to numerous enterprise Software development using Microsoft technology stack such as Visual C#, Visual C++, Microsoft SQL Server, ASP.NET MVC, ASP.NET Core, Blazor, WCF, LINQ, Entity Framework Core etc. I also embrace open-source technologies while developing modern Web-based applications.

I genuinely enjoy sharing my knowledge with others and that drives my motivation towards teaching.

Outside IT world, I enjoy reading and exploring the fundamental nature of reality.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.