+91 8789 400 649 / +91 7295 020 172
  Cloud Based Business Automation Solutions
Slider 1
Slider 2
Slider 3
Slider 4
Slider 5
Slider 6
Slider 7
Slider 8
Slider 1
Slider 2
Slider 3
Slider 4
Slider 5
Slider 6
Slider 7
Slider 8
Enquiry

OUR TRAINING COURSES

DOT NET TRAINING

STEEMA SOFTWARE PRIVATE LIMITED offer Fast-Track Dot Net Training and One-to-One Dot Net Training in India. Here are the major topics we cover under this Dot Net course Syllabus DOT Net Framework, C#, Classes & Objects, OOPS, Namespace, Arrays, Collections & Generics, File I/O and Streams, Remoting & Reflection, SQL Server, ADO.NET, ASP.NET 4.0, Page Life Cycle, Web Form, Validation Controls:- State Management, User Controls, Master Pages & Themes. Every topic will be covered in mostly a practical way with examples.
          We are the best Training Institute offers certification oriented Dot Net Training in India. Our participants will be eligible to clear all type of interviews at the end of our sessions. We are building a team of Dot Net trainers and participants for their future help and assistance in the subject. Our training will be focused on assisting in placements as well. We have separate HR team professionals who will take care of all your interview needs. Our Dot Net Training Course Fees is very moderate compared to others.
Course Content

DOT.NET
  • CLR, CLS & CTS
  • Compilation process in .NET
  • Assemblies & Versioning
  • Language Syntax
  • Data Types, Variables & Operators
  • Conditional Statements & Looping Structures
  • Garbage Collection and Finalization
  • Exception Handling
  • Classes and Objects
  • Abstract Classes and Interfaces
  • Constructors and Destructors
  • Structures, Enumerations
  • Boxing & Unboxing
  • Encapsulation
  • Inheritance
  • Polymorphism
  • Data Abstraction
  • Namespace, Nested Namespace
  • Delegates & Events
  • Properties, Indexer & Indexer Overload
  • Errors and Exceptions
  • Single Dimension Array, Multi Dimension Array
  • Collections
  • Generic Collections
  • Working with Directories and Files
  • Read and write file
  • Application Domain
  • MarshalByRef Object
  • Typeof
  • Introduction
  • DML DDL Functions
  • Jins & Views
  • Functions & Stored Procedure
  • Triggers & Cursors
  • Overview of ADO.NET
  • Connected vs Disconnected Architecture
  • Data Connection Object
  • Data Command Object
  • Data Adapter Object
  • Data Readers
  • Data Sets & Data Adapters
  • Structure of Dataset
  • Execute Non Query
  • Execute Reader
  • Execute Scalar
  • Introduction to Web Programming
  • Client / Server Technology
  • Understanding Web Server IIS
  • Global.asax
  • Web.config
  • Intrinsic Objects in ASP.Net
  • Web Control Class
  • Creating Web Forms Application
  • Handling Images
  • Navigating between Pages
  • Managing Server Controls
  • Server Control Events
  • Using HTML Controls
  • Using Data Controls
  • Repeater Control
  • ASP.Net validation controls
  • Configuring validation controls
  • Preserving State in Web Applications
  • Using Cookies to Preserve State
  • ASP.NET Session State
  • Application State
  • Creating User Controls
  • Interacting with User Controls
  • Loading User Controls Dynamically
  • Simple Master Page Nested Master Page
  • Configuring Master Page Creating Themes
  • Applying Themes
  • Applying Stylesheet
  • Using FileUpload Control
  • Setting the location and filename to upload the files
  • Protocols for Email
  • Sending Mails
  • Managing Attachments
  • Introduction to XML Web services
  • Creating Web Service
  • Setting the Web Service Attribute
  • Test and Run Your Web Service
  • Consuming a Web Service in Client
  • Application
  • Consuming a Third Party Web service
  • Publishing Web Applications
  • Create Web Setup Project

C# TRAINING

In this C# .net certification course you will learn the basics and methodologies of object-oriented programming languages using C#, as the programming language. It commences with the implementation of object-oriented concepts, such as abstraction, encapsulation, polymorphism, and inheritance, using C#. In addition, this C# .net certification course introduces the implementation of various programming concepts, such as threads, file handling, delegates, attributes, and reflection, used in C#. These .net classes help developers learn the programming skills that are required for developers to create Windows applications using the C# language.
          The C#.NET is the native language of the .net framework. It is very useful in all applications like desktop, network, website, etc. It provides very high-level productivity and fast development. STEEMA SOFTWARE offers exclusive C# training in India with Live Projects
Course Content

C#
  • Introduction to .Net
  • Platform for the .Net
  • Drawbacks of Current Trend
  • Net Framework – BCL & CLR l Key design goals
  • CLR, CTS, MSIL & other tools
  • Multiple Language Interaction & support l Moving from Project to Assemblies…
  • Security in .NET – CAS
  • Advantages/Disadvantages
  • Features of .Net
  • Assemblies in Detail
  • GAC, Strong Names
  • Language Interop
  • Reflection
  • Advantages/Disadvantages
  • Why C#/ Why Not C#
  • Where does C# Fit in
  • C, C++ to Visual C#
  • Features of C#
  • .NET Namespaces
  • .NET Versions – 1.1/2.0/3.0/3.5 Beta
  • Visual Studio.NET 2003/2005/Orcas/2008
  • Windows Vista – New Look
  • Gadgets/SideBars/UAC – relation with .NET
  • Hardware/Software Requirements
  • FAQ’s with detailed answers
  • The start of the application
  • C#.Net Program Design
  • Variables and types
  • Value types and reference types (CTS)
  • Strings and arrays
  • The Console class
  • String formatting
  • Statements and flows
  • Programming Structures
  • Command-line arguments
  • VS.NET to Create C#.NET Apps
  • C# 3.0/3.5 features – Implicit types , Extention Methods and more
  • Windows forms library – WinForms
  • Layout Enhancements
  • Forms and controls – Hierarchy
  • Creating simple GUI by hand
  • Event handling
  • Basic controls
  • Windows forms – buttons, check boxes, radio buttons, panels, group boxes, list boxes, picture boxes…
  • Menus
  • Built-in dialog boxes and printing
  • Extender Controls
  • ToolStrips, StatusStrips and progress bars
  • A new MDI forms strategy
  • Inheritance with forms
  • New Controls – Web Browser, Property Grid etc
  • Classes & objects
  • Abstract & override methods
  • Creating and using your own classes l Data members and member methods l Instantiate an object
  • This keyword
  • Properties – Read Only Write Only…
  • Build process using windows class library l Generate classes for other clients
  • How to use classes as part of project
  • Accessibility levels, specifiers
  • Constructors
  • Method overloading
  • Class (static) variables & methods
  • Object destruction
  • ‘ref’ and ‘out’ parameters
  • Constant values
  • Enumerations
  • Inheritance and Polymorphism
  • The root of all classes
  • Creating derived classes
  • Method overriding and hiding
  • Polymorphism and virtual functions
  • Casting objects
  • Abstract classes
  • Sealed classes
  • Static classes
  • Case Studies
  • Class Diagram in VS.Net
  • Refactoring & others
  • FAQ’s
  • Unstructured error handling support
  • Structured error handling
  • Error categories
  • Debugging the application
  • Debug and Trace classes
  • Code Optimization
  • Testing and strategies
  • History and background
  • From DAO to ADO.NET
  • ADO.NET LINQ
  • ADO.NET design goals
  • The ADO.NET architecture and its components
  • ADO.NET in relation to the other .NET tools
  • DataSet in RealTime Scenarious
  • Connected and disconnected environment
  • ADO.NET object model
  • Data sources, providers and connections
  • Commands and data readers
  • Data sets and data adaptors
  • Data tables, rows and columns
  • Constraints and relations
  • Data-centric applications – New ADO.Net Hierarchy
  • Connecting to a data source
  • SQL Server .NET data provider
  • OLE-DB .NET data provider
  • Connections and connection strings
  • SQL-Server integrated security
  • Connection pooling
  • ADO.NET exceptions
  • Commands
  • Creating and executing commands
  • Reading data using a data reader
  • Batch queries & single result queries
  • Parameterised queries (input & output parameters)
  • Adding, editing and deleting data
  • Stored procedures
  • Why using a disconnected environment?
  • DataSet and DataAdapter features
  • Filling data sets using data adapters
  • Read data using data tables, rows and columns
  • Batch queries and data sets
  • Visual Studio Data Menu & tools
  • DataSet Navigation
  • DataSet Functionality
  • DataSet Optimistic Concurrency
  • Searching in data sets
  • Find on primary keys
  • Searching on any column
  • Searching on row state
  • Wildcard searches
  • Sorting and filtering using data views
  • Searching in a data view
  • Client Server Basics
  • N-Tier – Classical and New
  • N-Tier importance w.r.t other .Net technologies
  • Build User Interface Layer – importance
  • Business Layer in N-Tier – advantages & disadvantages
  • Data Access Layer – Generic/Specific Advantages
  • N-Tier DataBase Application
  • SQLHelper, CodeSmith etc tools awareness
  • XML Basics – Importance in Todays world
  • XML designers/support in VS.NET
  • XML Derived Technologies – XSD ,XSL , SOAP ,WSDL
  • System.Xml Namespace
  • Stream Model XML
  • XML DOM
  • XmlTextReader,TextWriter
  • XmlTextReader, TextWriter XMLDocument/ XmlDataDocumentClasses
  • Dom Objects – XMLNode/XMLNodeList
  • XPATH- Query Language for XML
  • DOM – Navigation & Access Case Studies
  • About user – defined controls
  • Understanding the control class with Container
  • Add Properties/Methods/Events to Control
  • Pack & use control in other windows applications
  • Create & implement a windows control
  • Understanding services
  • Creating windows services
  • Setting properties
  • Compile, run & install services
  • Event log services
  • About Distributed Applications
  • COM/DCOM in Distributed Environment
  • Drawbacks of DCOM
  • .NET Remoting – New distributed environment
  • Advantages & Disadvantages
  • Remoting – Web Services comparisons
  • MBR, MBV
  • Channels
  • Formatters
  • Programming Model – Object Styles & Lifestyles
  • Activation
  • Case Study – Implementation using Remoting
  • Reporting Need in the application
  • Crystal Reports – Reporting Tool
  • Different Versions of Crystal Reports
  • Developing a Crystal Report
  • Different ways to Invoke/Deploy Crystal Reports
  • Packaging Code
  • ClickOnce Deployment
  • Configuring the .Net framework
  • Deploying the application in Web Server
  • Deployment – other methods

VISUAL BASIC TRAINING

This hands-on Visual Basic training course provides a thorough introduction to the use of Visual Basic 6. The main goal of the course is to enable the participant to create business applications with Visual Basic that utilize the multi-tier application design strategy for maintainability and reusability. The hands-on exercises are focused on solving commonly encountered business problems. The course introduces the Visual Basic Integrated Development Environment (IDE) and its wealth of development tools. Students will learn to build effective user interfaces with Visual Basic controls, forms, and other GUI components. The Visual Basic language is covered in detail. Students will learn the use of the debugging and testing tools available in Visual Studio. Database access is introduced, using Visual Basic's ADO Control and data-aware components like the Data Grid and Data Environment Designer. The course includes an introduction to object-oriented programming techniques and using the Packaging and Deployment tool to deliver completed applications to end users.
Course Content

VB.Net
  • Capabilities of Visual Basic
  • Visual Basic Overview
  • Types of Visual Basic Projects
  • Rapid Application Development
  • RAD Problems
  • Visual Basic Editions
  • The Visual Basic IDE
  • Managing the Workspace
  • Life Cycle Overview
  • The Visual Basic Project Lifecycle
  • Creating Projects
  • Project Files
  • Source Management
  • Test Running a Project
  • Compiling
  • Deploying Applications
  • Designing N-Tier Applications
  • Using the Integrated Documentation
  • Microsoft Developer Network
  • Forms
  • Designing a GUI
  • Code Window
  • Form Properties and Methods
  • Controls
  • Properties
  • Events and Event Handling
  • Dialogs
  • Dialog Modality
  • Command Dialogs
  • Standard Windows Dialogs
  • Creating a New Dialog
  • Form Load and Unload
  • Form Control Syntax
  • Laying Out a Dialog Interface
  • Laying Out a Dialog Interface
  • Working with Frames
  • Tab Order
  • Hot Keys
  • Layout Tools and Techniques
  • Validation Controls
  • Fundamentals of Coding
  • Code Editor
  • Module Basics
  • Event Procedures
  • Code Window Tips and Shortcuts
  • Statements and comments
  • Scope in Visual Basic Programs
  • Setting Scope Blocks
  • Data Types
  • Constants
  • Arithmetic Expressions
  • Logic and Boolean Expressions
  • Type Conversion
  • Arrays
  • Working with Strings
  • Date, Currency and Variant Types
  • Formatting Data
  • Logic Statements
  • Conditional Constructs (If/Then, Select Case)
  • Iteration (Do Loop, For Loop)
  • Background Loops
  • Background Processing
  • Application Structure
  • Purpose of Subroutines
  • Procedures
  • Functions
  • Arguments
  • ByRef vs. ByVal Parameters
  • Optional Arguments
  • Designing for Maintainability
  • Types of Errors
  • Error Handling
  • Creating Error Handlers
  • Debugging Applications
  • Writing Validation Routines
  • Invoking Validation
  • Controlling Flow
  • Keyboard Event Handling
  • The Validate Event
  • SDI Applications
  • MDI Applications
  • Application Lifecycle
  • Displaying Child Windows
  • Menus
  • Toolbars
  • Status Bars
  • Other Useful Controls & Objects
  • Control Arrays
  • Visual Basic File Access
  • File I/O Commands
  • File System Objects
  • The Registry
  • Database Concepts
  • The ADO Data Control
  • The DataGrid Control
  • Data View Window
  • Data Form Wizard
  • Data Environment Designer
  • The Packaging and Deployment Wizard
  • Creating Deployment Packages

MS SQL TRAINING

SQL Server delivers breakthrough mission-critical capabilities with in-memory performance and operational analytics built-in. Comprehensive security features help protect your data at rest and in motion.
          Organizations gain deeper insights into their data with capabilities that go beyond business intelligence to perform advanced analytics directly within their database and present rich visualizations for business insights on any device.

You can also gain the benefits of hyper-scale cloud that lets you dynamically stretch your warm and cold transactional data to Microsoft Azure in a secured way so your data is always at hand for queries, no matter the size. In addition, SQL Server delivers a complete database platform for the hybrid cloud, enabling you to easily build, deploy and manage solutions that span on-premises and cloud.
Course Content

MS SQL
  • Outlining SQL as the cornerstone of database activity
  • Applying the ANSI/ISO standards
  • Describing the fundamental building blocks: tables, columns, primary keys and foreign keys
  • Creating tables and columns
  • Building tables with CREATE TABLE
  • Modifying table structure with ALTER TABLE
  • Adding columns to an existing table
  • Removing tables with DROP TABLE
  • Guaranteeing uniqueness with primary key constraints
  • Enforcing integrity with foreign key constraints
  • Imposing business rules with check constraints
  • Enabling and disabling constraints
  • Removing constraints with ALTER TABLE
  • Expediting data retrieval with indexes
  • Recommending guidelines for index creation
  • Modifying table contents
  • Adding table rows with INSERT
  • Changing row content with UPDATE
  • Removing rows with DELETE
  • Atomic Consistent Isolated Durable (ACID) rules
  • Controlling transactions with COMMIT and ROLLBACK
  • Retrieving data with SELECT
  • Restricting rows with the WHERE filter
  • Sorting the result with ORDER BY
  • Handling NULL values in expressions
  • Avoiding NULL value pitfalls in filter conditions
  • Applying the ANSI/ISO standard join syntax
  • Matching related rows with INNER JOIN
  • Including nonmatched rows with OUTER JOIN
  • Creating a Cartesian product with CROSS JOIN
  • Stacking results with UNION
  • Identifying matching rows with INTERSECT
  • Utilizing EXCEPT to find nonmatching rows
  • Processing data with row functions
  • Conditional formatting with the CASE expression
  • Utilizing the CASE expression to simulate IF tests
  • Dealing with NULL values
  • Summarizing data using SUM, AVG and COUNT
  • Finding the highest/lowest values with MAX and MIN
  • Defining the summary level with GROUP BY
  • Applying filter conditions with HAVING
  • Applying subqueries in filter conditions
  • Correlated vs. noncorrelated subqueries
  • Testing the existence of rows
  • Placing subqueries in the column list
  • Creating complex expressions containing subqueries
  • Handling subqueries that return no rows
  • Breaking down complex problems
  • Selecting data from a query result set
  • Subqueries in the FROM clause
  • Creating views in a database
  • Building reusable code
  • Updateable vs. non-updateable views