"Aim to help our customers achieve the end result they need in whatever is the most effective way for them. "

- Anonymous

C # Developer

Quick Stats

Conditional compilation and simplified multithreading.
It runs on the CLR, making it easy to integrate with components written in other languages.
Professionals with a certification in C++ earn anywhere between 3 - 9 lac INR per annum.

Benefits

Instant access to Course Material
On signing up for the program you will get immediate access to information and course content.
Best of technology.
Learn through the best of technology. The lectures are conducted via Videos, Reading materials, and Problem Solving questions. Students can watch the videos and read the content at their convenience, on their own schedule.
Practice till you’re perfect.
Through our practice quizzes and MCQs you can test yourself on the skills you have learnt at every level. You can also test the skills learnt by attempting the problem solving questions.
Industry-wide Recognized Certificate
Get an Industry-wide Recognized Certificate in C# Developer Program by Manipal ProLearn.
Rewarding career
This highly intensive program equips you for a rewarding career in the field of C# Programming and DB programming in SQL Server.
Strong C# Programmer
Reach out to the market as a Strong C# Programmer and find opportunities as Sr. Software Engineer, Systems Engineer etc. Professionals with a certification in C++ earn anywhere between 3 - 9 lac INR per annum.

Who Should Attend

  • Engineering Graduates, BSc - IT Graduates, MCA Graduates, PGDBA / MBA Graduates (Information Technology Specialisation)
  • Professionals who want to become C# programmers, DB developers in SQL server
  • Fresh graduates/Software Engineers/System Analysts having 0-2 years of experience in the Industry

Course Outcome

  • Design the DB and create an ER model
  • Create a normalized Relation schema
  • Write SQL server commands to retrieve and modify the data – DML and DDL commands
  • Solve problems using objected oriented concepts using C#– Abstraction, inheritance and polymorphism
  • Develop an application – A showcase project using C#
  • Write C# programs to interact with IO streams
  • Write desktop applications

Curriculum

  • Introduction to RDBMS, Conceptual Modeling and Normalization
    • Overview of DBMS
    • Overview of Databases
    • Terms and Terminologies of Database
    • Data Models
    • Relational Model Basics
    • Database Design Process
    • E-R Diagram Basics Conventions and Notations of E-R Diagram
    • Modeling Data using E-R Diagram
    • Constraints and Keys
    • Normalization Basics
    • Schema Refinement and Normal Forms
  • SQL Server and Selecting Data
    • Understanding SQL Server Instance
    • Types of Databases
    • SQL Server Client Tools
    • Demo on SSMS and Tools
    • Overview of SQL
    • Retrieving Data from a Table
    • Operators in SQL Server
    • Demo on Arithmetic Operators
    • Working with Nulls
    • Filtering Data with WHERE Clause
    • Filtering Data with WHERE Clause
    • Expressions in Select
    • Working with Range and List
    • Working with Pattern Matching
    • Aggregate Functions and GROUP BY Clause
    • Sorting Data
  • Subquery, Joins, Database Constraints, DDL
    • JOINS – Overview
    • Fetching Data from Multiple Tables
    • Fetching Matching and Non-matching Data from Multiple Tables
    • Using Self Reference
    • Subquery - Overview
    • Extracting Information using Sub-queries
    • Using the EXISTS Predicate with Subqueries
    • Sub Queries Demo
    • Introduction to CTE
    • Overview of DDL
    • Data Types in SQL Server
    • Working with Basic DDL Commands
    • Types of Constraints and Keys
    • More on Constraints and Keys
  • DML, Views, Indexes, System Function
    • Inserting Data
    • Deleting Data
    • Updating Information
    • Merge Statement
    • Views - Overview
    • Create View statement
    • Partitioned Views
    • Working with Indexed Views
    • Clustered Indexes
    • Non-Clustered Indexes
    • Indexes and Performance
    • Writing Queries with Built-in Functions
  • User defined Functions and Procedures
    • Programming with T-SQL
    • Stored Procedures
    • User Defined Functions
    • Table Valued Parameters
  • Triggers and Cursors
    • Overview of Triggers
    • Creating DML triggers - After trigger
    • Creation of DML Triggers - Instead of
    • Views and Triggers
    • Understanding Cursors
    • Implementing Cursors
  • Introduction to .NET 4.0
    • History, Features and Benefits of .NET
    • .NET Framework Architecture
    • Common Language Runtime
    • Framework Class Library
    • Tools for .NET Development
    • Versions of .NET
  • C# Fundamentals
    • Introduction to OOP Concepts
    • Overview of C#
    • Variables and Data Types
    • Overview of Operators
    • Assignment and Arithmetic Operators
    • Relational and Equity Operators
    • Conditional and Logical Operators
    • If Construct
    • Switch Construct
    • Loops and Types of Loops
    • Construct Statements
  • Methods
    • Simple Methods
    • User-defined Methods
    • Method Overloading and Overloaded Methods
  • OOPs in C#
    • Classes in C#
    • Overview of Encapsulation and Abstraction
    • Overview of Inheritance and Polymorphism
    • Overview of Access Specifiers and Modifiers
    • Overview of Property Functions
    • Abstract Class
    • Interface
    • Garbage Collection Class
    • Overview of Namespaces
  • Arrays, Indexers and Collections
    • Single Dimensional Array
    • 2-D Array
    • Jagged Array
    • Numeric and String Indexer
    • Overview of Collections
    • Overview of Stacks and Queues
    • Overview of Array Class
    • Overview of Hashtables
    • Overview of Sorted Lists
    • Generic Methods and Generic Classes
    • Generic Collections
  • Error Handling
    • Errors Overview
    • Exceptions Overview
    • Exception Classes
    • Custom Exceptions
  • Additional Programming Constructs
    • Directives
    • Pattern Search
    • IO Operations
    • Serialization
    • Delegates and Events
  • .NET Assemblies, Interoperability and COM and Desktop Applications in .NET
    • Overview of Assembly
    • Types of Assemblies
    • Structure of Assemblies
    • Overview of COM & Interoperability
    • Overview of Win Forms
    • Designing of windows forms
    • Menu driven applications
  • Database connectivity in .NET
    • Overview of ADO.NET
    • ADO .NET Architecture
    • Data Providers
    • Data Sets
    • Connected Model
    • Disconnected Model
    • DataBindings for TextBoxes
    • Navigating Records
    • Data Grid and Navigation through Records
    • ADO .NET Wizard
    • Stored Procedures
    • Transactions Using
    • Report Viewer
  • LINQ
    • Overview of LINQ
    • LINQ Internals
    • Overview of LINQ to API
    • Overview of LINQ to Object
    • Overview of LINQ to XML
    • Overview of LINQ to Dataset
  • Package and Deployment
    • Packaging and Installation Methods

 

Website Designed by © 2012 SMIIT. All Rights Reserved