Level 2 – Associate (C# Programming)
Welcome to the C#.NET Programming with Microsoft SQL Server Course, designed to empower you
with the knowledge and skills needed to leverage the one of the top leading backend programming
and relational database management system. C# is widely deployed globally running on various
platforms enables developers to build many types of secure and robust applications that run in .NET.
The SQL Server on the other hand is a database platform for enterprise data management who wish
to venture in managing database running in Microsoft SQL Server that covers relational database,
database design, and Structured Query Language (SQL).
Suitable for students, career shifters, and IT professionals.
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.
Online Training (4 days – 3 hrs. per day)
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
