Level 2 – Intermediate (C# Programming)
Recorded Training held last March 2024
Who is this course for?
- Individuals with the following:
- Basic knowledge in programming using high level programming languages like Java, C++,Python
- Basic understanding of databases and database concepts
- Familiarity with general IT concepts and terminologies.
Tools:
- Visual Studio, SQL Server Database Engine, SQL Server Management Studio
Course Outline
Day 1: Introduction to C# Programming, .NET
- Familiarize Visual Studio
- Introduce type of Applications using Console Application
- Syntax, Output, Comments
- Variable and Data Types
- Type Casting
- User Input/ Output
- Operators
- Math Function
- Data Types
- If/else and Switch
- Loopings (for, do while, foreach, while)
- Arrays
Day 2: Introduction to Object Oriented Programming and C# Windows Forms
- Object Oriented Programming
- Class and Objects
- Enums
- Properties
- Abstraction
- Polymorphism
- Inheritance
- Creating new Project
- Adding new Form
- Working with Multiple Forms
- Adding Controls
- Designing Forms
- Apply Programming and OOP Concepts
Day 3: Introduction to SQL Server
- Familiarity with SQL Server Management Studio
- Table and Relational Databases
- Primary Key and Foreign Keys
- Normalizations
- Data Types
- Types of SQL Languages
o Data Definition (ALTER, CREATE, TRUNCATE, DROP)
o Data Manipulation (INSERT, UPDATE, DELETE)
o Data Query (SELECT) - SQL Functions
Day 4: CRUD Operations in C# with SQL Server
- Establish connection string using App Config
- Design a form with Grid view to display records.
- Use SQL name spaces in C#.NET.
- Perform add, edit, delete SQL commands.
- Perform data retrieval.
- Application of C# basic programming and OOP
- C# exceptions
4 Sessions
₱500.00
✅ Digital Badge
✅ Video Recording of All Live Sessions
✅ Learning materials from our trainer
As an SQL Server DBA, he has extensive experience managing and maintaining databases. Proficient in administering Windows Server environments. Skilled in automating backend processes for efficiency. Adept at planning, executing, and delivering IT projects. Proven experience in managing and maintaining IT infrastructure. Experienced in developing .NET applications.
