This course aims to teach beginners the fundamentals of C# programming language and how to use it to create real applications, including a database management system. The course covers topics such as basic syntax, data types, control structures, object-oriented programming concepts, collections, LINQ, file handling, and database connectivity. The teaching method includes detailed explanations, code examples, and a hands-on project. This course is intended for individuals who are new to programming and want to learn C# from scratch.
Overview
Syllabus
Intro
Visual Studio Setup
System
Visual Studio Environment
Namespace
Class Basics
Main Function
Void
Main Arguments
WriteLine
Console Methods
Receive User Input
Variables
Data Types
Casting
Formatting Output
String Functions
Format
Escape Characters
Verbatim Strings
Arrays
For Loop
Function Basics
Foreach
If / Else / Else If
Ternary Operator
Switch
While
Do While
Random
Exception Handling
StringBuilder
Functions
Access Specifier
Out Parameter
Pass By Reference
Passing Unknown Number of Parameters
Method Overloading
DateTime / TimeSpan
Enumerated Types
Classes / Objects
Constructor
Static
This
Structs
Nullable Types
Basic Setter / Getter
Getters / Setters Properties
Public / Private / Protected
Constants
Readonly
Inheritance
Virtual
Inner Class
Override Method
Abstract Classes / Methods
Polymorphism
Interfaces
Complex OOP Example
Warriors Fight to the Death
ArrayList
Dictionaries
Queues
Stacks
Generics
Delegates
Lambda
Where
Select
Range
Zip
Aggregate
Average
All
Any
Distinct
Except
Intersect
IEnumerator
Operator Overloading
Anonymous Types
LINQ
Threads
Directory Functions
File I/O
FileStreams
StreamWriter / StreamReader
BinaryWriter / BinaryReader
Serialization
XmlSerializer
Installing SQL Server
Connecting SQL Server to Visual Studio
Setting Up Database
WPF / Database Big Project
Design an Interface
Reading From Database
Add Data to Database
Delete Data from Database
Update Tables Automatically
Taught by
Derek Banas
