MICROSOFT C#.NET AND SQL SERVER

Sinet has well experienced academic team to deliver
Advanced programming technologies..



COURSE DETAILS

Duration: 60 hours *

Class: Regular / Week ends / Evening / Sundays

Daily Time: 1.5 hours / 3 hours / half day / Full day

Certification: Sinet Merit Certification

JOIN NOW
* Sinet course can be customized as per student requirement.

JOB PROFILE

C# Application Developer

C# Programmer

Microsoft Windows Programmer

SQL Data Manager




MICROSOFT C#.NET AND SQL SERVER
COURSE CONTENTS

( Can be customized )



1. Introduction in C#.NET

.NET Framework,Common Language Infrastructure, Class Library , Assemblies, The Common Language Runtime (CLR), Intermediate Language (IL), Features, Namespace

2. Basics in C#.NET

Variables, Initialization of variables, Constants, Data Types, CTS Types

3. Console in C#.NET

About visual studio IDE, Solution explorer, toolbox, server explorer, properties, Program class, Console I/O, Reading and Writing in Console, Using Comments, Internal Comments, Tokens, Keywords, Identifiers, Literals, Punctuators,Operators

4. Console in C#.NET

Type Conversion, Convert class, Operators, Arithmetic Operators, Relational Operators, Logical Operators, Assignment operators, Increment/Decrement Operator

5. Flow Control (1) in C#.NET

Selection Control Constructs, If, if …else, nested if , if else if

6. Flow Control (2) in C#.NET

Selection Control Constructs, switch case, conditional operators

7. Flow Control (3) in C#.NET

Iteration Flow Control, Loops, While,do while,for, For each

8. Array in C#.NET

Single Dimensional (foreach), Multidimensional, Jagged Array

9. Functions/Methods (1) in C#.NET

Define Function, calling functions, function category, User defined Functions, Predefined Functions, String functions and Array functions

10. Functions/Methods(2) in C#.NET

Return multiple values using ‘out’, Call by value, Call by Reference, Argument Reference using ‘ref’

11. Object Oriented Programing (1) in C#.NET

Classes and Class Members, Data Members, Function Members, Properties, Object

12. Object Oriented Programing (2) in C#.NET

Constructors, Destructors, Default constructor and parameterized constructor

13. OOP Polymorphism in C#.NET

Polymorphism, Method Overloading, Constructor Overloading

14. OOP Inheritance (1) in C#.NET

Types Of Inheritance, Calling Base Class Version of function, Constructors of derived classes, Method Overriding, Use of ‘base’ keyword

15. OOP Inheritance (2) in C#.NET

Interfaces, Defining and implementing interfaces, Implementation Vs Interface Inheritance, Abstract Classes And Functions, Final Class and Function

16. OOP Property in C#.NET

Property, Define property, set and get the value of property, Delegates, Create delegate ,delegate object is used to point the functions

17. Windows Application (1) in C#.NET

Introduction to Windows Application, Windows Forms, Basic Windows Form Controls: Form, TextBox, Button, Label

18. Windows Application (2) in C#.NET

Option Button, Check Box, Combo Box

19. Windows Application (3) in C#.NET

List Box, Checked List box, Tool Tip

20. Windows Application (4) in C#.NET

Tree View, List View, Image List

21. Windows Application (5) in C#.NET

Windows Form Controls, Link Label, Masked Text Box, Date Time Picker, Numeric Up Down, Picture Box

22. Windows Application (6) in C#.NET

Progress Bar, Timer

23. Windows Application (7) in C#.NET

Web Browser, Tool strip container, toolstrip

24. Container controls in C#.NET

Windows Form Container Controls, Panel, Flow Layout Panel, GroupBox, Table Layout Panel, Split Pane

25. multithreading in C#.NET

Introduction to Threading, The Thread Class, Thread States-New, Running,Blocked, Dead, Functions-start(), sleep(), suspend(), Abort()

26. menus and toolbars in C#.NET

Context Menustrip, Menustrip, Statusstrip, Toolstrip, ToolstripContainer

27. Dialogs (1) in C#.NET

Dialogs, Predefined-Messagebox, Custom-Create a custom dialog box, System-Folderbrowser

28. Dialog (2) in C#.NET

Open File Dialog, Save File Dialog, Font Dialog, Color Dialog

29. standard control in C#.NET

Windows Form Controls, Rich Textbox

30. Windows Application in C#.NET

Printing Components, Print Document, Page Setup Dialog, Print Dialog, Print Preview Control, Print Preview Dialog

31. I/O Namespace in C#.NET

Managing File System, Moving, Copying, and Deleting Files, Reading And Writing Files, Create directory and delete directory, list the directory, Stream Operations, Reading and writing

32. Windows controls in C#.NET

Windows Form Components, Error Provider, Help Provider, Windows Form Advanced Controls, DataGridView

33. Networking in C#.NET

System.Net.Sockets Namespace, TCPClient: Client Connection from TCP network servoces, TCPListener : Listens for connection from TCP network clinets

34. SQL server in C#.NET

RDBMS: What is a database .Choosing a database (RDBMS), DB Creation, Table creation, Integrity constraints (primary key, foreign key). SQL commands-Select, Insert, Update, Delete

35. OLEDB in C#.NET

Introduction To ADO.NET, System.Data Namespace, DataTable,DataSet, OLEDB Connectivity, Classes used in System.Data.Oledb; OledbConnection, OledbCommand, OledbDataAdapter, OledbDataReader

36. SQL in C#.NET

Introduction To ADO.NET, SQL Connectivity, Classes used in System.Data,SqlClient; SqlConnection, SqlCommand, SqlDataAdaper, SqlDataReader, Login Form

37. SQL CRUD (1) in C#.NET

Insert ,Read values from Database

38. SQL CRUD (2) in C#.NET

Update and delete data from database

39. ODBC in C#.NET

ODBC Connectivity, Classes used in System.Data.Odbc; OdbcConnection, OdbcCommand, OdbcDataAdapter, OdbcDataReader, Crystal Report

40. Project in C#.NET

Create application-Registration Form ,Login Form And CRUD operation



SINET F A Q

Frequently asked question resources







What is Microsoft ASP.Net ?

ASP.NET is an open-source server-side web-application framework designed for web development to produce dynamic web pages developed by Microsoft to allow programmers to build dynamic web sites, applications and services.

Is Sinet provides Microsoft ASP.Net and MVC education with training ?

Sinet is the leader of web technologies and framework education and training including Microsoft development technologies in Kerala India. Hundreds of satisfied programmers are working across India, US, Europe and in middle east.

What is C Programming language ?

C is a general-purpose, procedural computer programming language supporting structured programming, lexical variable scope, and recursion, while a static type system prevents unintended operations, designed by Dennis Ritchie.

What is CPP (C++) Programming language ? Is Sinet provides C and C++ programming courses ?

C++ is a high-level, general-purpose programming language created by Bjarne Stroustrup as an extension of the C programming language, or "C with Classes".
Yes. Sinet provides C and Cpp programming courses professionally. Sinet is among the forefront of leading system programming educators in Kerala India.

What is Microsoft C#.Net ?

C# is a general-purpose, multi-paradigm programming language encompassing strong typing, lexically scoped, imperative, declarative, functional, generic, object-oriented, and component-oriented programming disciplines.

Is Sinet provides Microsoft C#.Net and SQLServer education with training ?

Sinet is the training leader of Microsoft dot net Programming technologies and database administration. We provides live and academic project training to students in any category using Microsoft development technologies in Kerala India.

What is Java Programming Language ?

Java is a general-purpose programming language that is class-based, object-oriented, and designed to have as few implementation dependencies as possible.Designed by: James Gosling

Is Sinet provides Oracle Java and MySQL education with training ?

Sinet is the training leader of Oracle Java technologies and database administration.

What is meant by Microsoft Office?

Microsoft Office is a suite of desktop productivity applications that is designed specifically to be used for office or business use. It is a proprietary product of Microsoft Corporation and was first released in 1990. It mainly consists of Word, Excel, PowerPoint, Access, OneNote, Outlook and Publisher applications.

Is Sinet provides course in Full stack Microsoft office with Job training ?

Yes. Sinet is the leading provider of full-stack MSO and office automation with placement assistance.

What is microsoft office 365 ?

Office 365 is an integrated experience of apps and services, designed to help you pursue your passion and grow your business. Get apps like Word, Excel, PowerPoint, and more, updated monthly with the latest features and security updates. Use cloud-powered email to reach customers and coworkers wherever work takes you.

What is Microsoft Excel and what is it used for?

Microsoft Excel is a spreadsheet program. That means it's used to create grids of text, numbers and formulas specifying calculations. That's extremely valuable for many businesses, which use it to record expenditures and income, plan budgets, chart data and succinctly present fiscal results.

What is the main function of Microsoft Excel?

Excel includes many common functions that can be used to quickly find the sum, average, count, maximum value, and minimum value for a range of cells. In order to use functions correctly, you'll need to understand the different parts of a function and how to create arguments to calculate values and cell references.

What is Oracle best known for?

The company is best known for its Oracle database software, a relational database management system, and for computer systems and software, such as Solaris and Java, acquired in its purchase of Sun Microsystems in 2010. Oracle is based in Redwood Shores, California.

Is Sinet provides course in Oracle DBA education with training ?

Sinet is the training provider of Oracle technologies and database administration.

What is PHP ?

PHP is a popular general-purpose scripting language that is especially suited to web development. It was originally created by Rasmus Lerdorf in 1994; the PHP reference implementation is now produced by The PHP Group.

Is Sinet provides PHP, Laravel and Codeigniter MVC education, training and Job-Placements ?

Yes. Sinet is the leader in web technologies, framework education, training and placements. We provide PHP core and MVC development technologies across Kerala India. Hundreds of satisfied programmers are working in India, US, Europe and in the middle east.

What is Laravel and why it is used?

Laravel is an open-source PHP framework designed to make developing web apps easier and faster through built-in features. These features are part of what makes Laravel so widely used by web developers: A modular packaging system with dependency management. This means you can easily add functionalities to your Laravel app without writing them from scratch. You can either create your own packages for code you routinely use or install ready-to-use packages through Composer. A complete authentication system Object-relational mapping. Eloquent ORM included with Laravel presents database tables as classes for easier data access and manipulation. A command-line interface (CLI) that comes with dozens of pre-built commands (Artisan). Automatic testing. Automated tests are provided as an integral part of Laravel. A portable, virtual development environment. Homestead provides developers with all the tools necessary to develop Laravel straight out of the box.

Is Laravel a CMS?

Unlike CMS's like Drupal or Wordpress, Laravel gives you full control over your application. In Laravel everything is done in code, unlike Drupal or Joomla, for example, where you can create functional websites without writing a single line of code or without even knowing what PHP is. Simply put, a CMS is an app that comes with basic functionalities and is built on top of a framework. Laravel is a framework and it’s used to build apps, including CMS platforms.

What is CodeIgniter used for?

CodeIgniter is a PHP MVC framework used for developing web applications rapidly. CodeIgniter provides out of the box libraries for connecting to the database and performing various operations like sending emails, uploading files, managing sessions, etc

Is CodeIgniter a CMS?

It is not a CMS, but a starting point for new projects build with CodeIgniter that require ready-made tools like: User Management with Role-Based Access Control. Fully Modular codebase built around HMVC. Powerful, parent/child capable theme engine.

What is PHP and why it is used?

PHP is a server side scripting language. that is used to develop Static websites or Dynamic websites or Web applications. PHP stands for Hypertext Pre-processor, that earlier stood for Personal Home Pages. PHP scripts can only be interpreted on a server that has PHP installed.

What is Python Language ?

Python is an interpreted, high-level, general-purpose programming language. Created by Guido van Rossum and first released in 1991, Python's design philosophy emphasizes code readability with its notable use of significant whitespace.

Is Sinet provides course in Python and Django with training ?

Sinet is the training provider of full stack Python and Django technologies with MYSQL .

What is Python language basics?

Python is an object-oriented programming language created by Guido Rossum in 1989. It is ideally designed for rapid prototyping of complex applications. ... Python programming is widely used in Artificial Intelligence, Natural Language Generation, Neural Networks and other advanced fields of Computer Science.

What is the difference between Python and Django?

Django is a web application framework that uses Python. Python is a programming language. Django is a web framework which is coded in Python. So, the difference is just like the difference between a given programming language and the software that is built using it.

Is Python used for games?

Python is also good for building tools for game designers which simplify tasks like level design or dialog tree creation and having those tools export that work into a format the main game engine can use. Some game engines might use Python as a scripting language.

what is python django ?

Django is a free and open source web application framework written in Python. A framework is nothing more than a collection of modules that make development easier. ... The official project site describes Django as "a high-level Python Web framework that encourages rapid development and clean, pragmatic design.

How long does it take to learn Python?

Basic Python is where you get to learn syntax, keywords, if-else, loops, data types, functions, classes and exception handling, etc. An average programmer may take around 2–4 weeks to get acquainted with these basics.

What is sql server? Is Sinet provides course in Microsoft SQL Server with training ?

Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer across a network. Sinet is the training provider of SQL Server technologies and database administration.

What is difference between SQL and SQL Server?

The main difference between SQL and MS SQL is that SQL is a query language that is used in relation databases whereas MS SQL Server is itself a relational database management system (RDBMS) developed by Microsoft. A DBMS is a software that is used to manage the database.

What is responsive web design ?

Responsive web design is an approach to web design that makes web pages render well on a variety of devices and window or screen sizes. Recent work also considers the viewer proximity as part of the viewing context as an extension for RWD.

Is Sinet provides course in Full stack Web Designing with Job training ?

Yes. Sinet is the leading provider of full-stack responsive web designing and digital marketing technologies with placement assistance.

What is ASP NET MVC used for?

ASP.NET MVC is an open source web development framework from Microsoft that provides a Model View Controller architecture. ASP.net MVC offers an alternative to ASP.net web forms for building web applications. It is a part of the . Net platform for building, deploying and running web apps.

Is ASP NET MVC cross platform?

When it comes to web application development, there are multiple technologies available to choose from. There are open-source technologies like Java & PHP, and then, there is closed-source technology ASP.NET MVC. ... ASP.NET Core is an open-source, cross-platform framework developed by both the Microsoft and its community.

Should I learn .NET or .NET core?

ASP.NET Core is the next version of ASP.NET MVC. You should learn ASP.Net Core because ASP.NET Core is an open-source, cross-platform framework for building modern, cloud-based web apps on Windows, macOS, or Linux.

Is Job Placement support available in Sinet Software Institute?

Yes. Sinet has effective job placement system for students. Its starts from education, Job training, recognition merit certifications, experience certificates after completion of training programs and finally placement activities. Hundreds of alumni students working here and abroad are our pride.

Can Sinet provide multinational company certifications like Microsoft, Oracle, SAP while learning at Sinet Institute?

Yes. Sinet has been providing MNC certifications by collaboration with various testing centres as educational partners.

Is Sinet institute got any ISO standard of recognition?

Yes. Sinet has been maintaining its quality and as a result of this effort, Sinet is ISO 9001: 2015 certified educational organization.

Is free wi-fi available in Sinet Software Institute?

Yes. Sinet provides free wi-fi and high speed internet to students inside Sinet Software Institute campus

Free warranty against technology obsolescence is available at Sinet Software Institute?

Yes. Sinet provides warranty against technology obsolescence and students will get the added advantage of latest technology even they admitted for old versions.

Separate boys and girls Hostel facility is available at Sinet Software Institute?

Yes. Sinet provides hostel facility to our students by affiliation with privately managed hostels.

Is parking facility available in Sinet Perinthalmanna?

Yes. Sinet provides sperate parking for cars and bikes with the supervision of skilled security personal





SINET IS AN ISO 9001 : 2015 CERTIFIED SOFTWARE TRAINING INSTITUTE

(Division of Sinet Education)

www.sinetedu.com