Course Code: vscsqlsbspk
Duration: 28 hours
Overview:

This course is divided into 3 main sections and is made up of a mixture of presentations and practical exercises.

  1. C# Language in Visual Studio 2022
  2. C# Object Orientation
  3. C# and SQL Server 2019
Course Outline:

Day 1: 

C#  Language in Visual Studio 2022

Module 1. Introduction to Visual Basic 2022

  • The Object-Oriented Programming
  • The Visual Studio 2022 IDE
  • Creating a new Application
  • Using the Help System

Module 2. The Microsoft .NET Framework

  • The .NET Framework Classes
  • Executing the Code
  • Common Language Runtime
  • Code Loading and Execution
  • Application Isolation
  • Security
  • Interoperability
  • Exception Handling

Module 3. The Visual Basic 2022 Language

  • Data Types
  • Storing Variables
  • Using Methods
  • Making Decisions
  • Working with Data Structures
  • Using Arrays, Enumerations and Collections
  • Creating console applications
  • Understanding the structure of console application

Exercises

 

Day 2:

Module 4. Building Windows Applications

  • Winforms vs WPF
  • Console vs WPF vs Other types of projects
  • Project creation
  • Project Structure and Code management
  • Setting up source control (GitHub) and pushing source to GIT
  • Responding to Events
  • Creating the Toolbar
  • Creating the Status Bar
  • Using Multiple Forms
  • OpenFileDialog and SaveDialog controls
  • PrintDialog and FolderBrowserDialog controls
  • Understanding Menu Features
  • Creating Menus
  • Context Menus
  • Understanding different controls and their uses
  • Radio button, checkbox, textbox, text block and dropdown
  • Listview vs listbox
  • Datagrid
  • Binding collections to controls

 

C# Object Orientation

Module 5. Building Objects

  • Understanding Objects
  • Encapsulation
  • Methods and Properties
  • Managing Events
  • Building Classes
  • Using Constructors
  • Managing Inheritance
  • Understanding class

 

Module 6. Advanced Language Constructs

  • Using Lambda Expressions
  • Using Async and Wait
  • Using Iterators

Exercises

 

Days 3:

Module 7. Exception Handling and Debugging

  • Handling Exceptions
  • Try, Catch, Finally
  • The Throw Keyword
  • The Exit Try Statement
  • Using Exit Try Statement
  • Using Exception Properties
  • Logging Errors
  • crea

Module 8. Parallel Programming Using Tasks and Threads

  • Launching Parallel Tasks
  • Transforming Sequential Code to Parallel Code
  • Parallelizing Loops
  • Specifying the Desired Degree of Parallelism
  • Creating and Managing Tasks

 

C#  and Sql Server 2019

Module 9. Database Programming with Sql Server 2019 and ADO.NET

  • The ADO.NET architecture
  • The Connection class
  • The Command and DataReader Classes
  • The ExecuteReader(), ExecuteScalar(), ExecuteNonQuery() methods
  • Using Parameterized Commands
  • Calling Stored Procedure
  • Managing Transactions

Module 10. Data Components and the DataSet

  • Building a Data Access Component
  • Managing Disconnected Data
  • The DataSet Class
  • The DataAdapter Class: Filling a DataSet, working with Multiple Tables and Relationships
  • The DataView Class

Exercises

 

Day 4:

Module 11. Using Data Binding

  • Basic Data Binding
  • Data Source Controls
  • The SqlDataSource
  • Inserting, Updating, Deleting and Selecting records
  • Connecting Data from DB to WPF application
  • CRUD from WPF directly on the database
  • Database query
  • Writing dynamic queries based on controls
  • SQL tricks and tips
  • SQL best practices
  • Visual studio hotkeys, tricks and tips
  • Building a custom application from scratch
  • Using UI controls like mahhapps to build modern UI
  • Creating WPF project templates
  • Desktop notification
  • Using windows tasker and other components

Module 12: WPF and SQL

Module 13: WPF example application

Exercises