DotNet Technologies
Hadoop Bigdata
Digital Marketing
DotNet Technologies
Hardware and Networking
Java Technologies
Python
Multimedia Web and Animation
Oracle
Regular and Diploma Courses
SAP
Spoken English
Tally ERP-9
Wings
Graphic Designing-Web Design and Development
C#. Net
ASP.NET
VB.Net
SQL SERVER
SV Infotech Offers Dotnet Training in Dilsukhnagar Hyderabad. ASP.Net,VB.Net SQL Server Course training institute in Dilsukhnagar Hyderabad Telangana
.NET FRAME WORK:
What is .NET?
Languages
CLR, Assemblies,
.NET Architecture
Namespaces,
Writing dll’s and Exe’s
CLS, CTS
C# INTRODUCTION:
Syntaxes
Access Specifies, Data Types,
Conversions
Loops, control structures
Methods and Parameters
Arrays
Param Arrays
Using Aliases
Writing Multiple Main Methods
OBJECT ORIENTED PROGRAMMING:
Introduction
Static (Vs) Instance Members
Constructors
This Keyword
Inheritance
Base Keyword
Overriding, New methods
Sealed Classes
Operator Overloading
Interfaces, Abstract Classes
Destructors,GC
Properties,Indexers
Structs and Enums
Delegates
Events and Exception Handling
Partial Classes, Partial Methods
Is, as Keywords, String formatting, Var KeyWord
GUI Programming With C#.Net:
Designing GUI Applications
System. Windows. Forms namespace
Form Class
Control Programming
Visual Inheritance
Working With VS.Net 2008 IDE:
What is IDE?
IDE Windows
ToolBox, Solution Explorer
Server Explorer …..
.NET Solution Structure
Creating Consle projects through IDE
Creating Windows projects through IDE….
Working with Collections:
System. Collection Hierarchy
Array List
Hash table
Sorted List
Stack
Queue
Generics:
Generic Collections
Generic Classes
Working with I/O:
Systemic Namespace
File Directory classes
Working with Streams
Working with Readers and Writers
SERIALIZATION:
What is Serialization?
Why Serialization?
Types of Serializations
Deep (VS) Shallow Serialization
Binary Serialization
Soap Serialization
Xml Serialization
ADO.Net:
What is Ole DB?
Working with Connection, Command Object and Data readers
Working with Execute Methods of Command Object
Command Behaviors
.NET Providers for SqIServer and Oracle
Transaction Programming
Working With Adapters and DataSets
DataSet Updation
DataSet Filtering
Data Views
DataRelations
PL/Sql Execution
-Calling SqlServer Procedures
-Calling Oracle Procedures
Other ADO.Net Adv Issues
Remoting:
What is Remoting?
Introduction to Distributed Computing
Remoting (VS) WebServices
Channels
Formatters
MBV’s(VS) MBR’S
Remoting Types
-Server activated types and Client activated types
Remoting API
Remoting: First Example
Remoting using Configuration Files
Designing 3-tier and N-tier Applications
Using Remoting and ADO.NET
Remoting & Serialization
Asynchronous Programming:
What is Asynchronous Programming
Asynchronous API?
AsyncCallback delegate
System.Runtime.Remoting & Async Result
Asynchronous Remoting
Windows Services:
What is Windows Service?
Service Control Manager
System.ServerProcess namespace
Service Base Class
Creating and Installing Windows Services
Remoting & windows Services
Install Util tool
Reflection:
What is Reflection?
Why Reflection?
Type Class
System.Reflection
Assembly Class
MethodInfo,ParameterInfo…. Classes
Remoting & Reflection
Basics:
What is WWW?
Web Programming
Html & JavaScript
WebServers, IIS
Active Server Pages
Asp.NET Introduction:
Asp.Net Architecture
Asp (v) Asp.Net
Server control
Types Of Server Controls
Control Hierarchy
view States
Creating Controls Dynamically
Page class
Page Life Cycle
Page Members
Code behind Pages
Desining User Controls
Working With Asp.Net FromVS.Net IDE2008 Control Programming:
Web Server Control
Basics Web Server Controls
List Controls
Validation Controls
Data Controls
– Grid view (Paging,Sorting, Updations…..)
– Data List
Adv Controls
New Asp.Net3.5Controls
Working With Xml & Xml Web Services:
What is Xml
Writing Xml Documents
Welformed Xml Documents
Documents Type Definitions(DTP)
Validated Xml Documents
papers
– SAX Model
– DOM Model
Xml Readers
XmlNode, XmlDocument Classes
Working with Xpath
Xml Namespaces
Vlidating Xml Documents in
.NET(2.0 model (vs) 3.5 model)
XSl and Xslt
Xml Controls
Xml Web Services-an Introduction
Role of WSDL
SOAP
UDDI
Desining Xml Web services in Asp.Net
Consuming Xml Web services
Sucuring Xml Web Services
Adv . Issues in XmlWebServices
Advanced Issues in Asp.Net:
State Management
– View State
– Cookie State
– Session State
– Server Sessions
– Client Sessions
– Applications State
Tracing
Errorhandling
Appseting
Connection string settings
Caching
– Page Caching
– Page Fragmentation Caching
– Data Caching
Asp.Net Security
– Authentication
o Froms
o Windows
o PassPort
– Encrypting Passwords
– Authorization
– Pricipal and Identity Objects
Global.Asax
Application Events
Advanced Issues in Asp.Net II:
Site Navigation
Master Pages
Themes And Skins
Asynchronous Javascript and Xml(Ajax)
Ajax Programming in Asp.Net 3.5
Postbacks (vs) Callback in Asp.Net 3.5
Introduction to WebParts
Custom Controls (vs) Custom Controls
.Net Frame Work:
What is .Net?
Languages
CLR, Assemblies,
. NET Architecture
Namespaces,
Writing dll’s and Exe’s
CLS,CTS
VB.net Introduction:
Syntaxes
Access Specifiers, Data Types, Conversions
Loops, control structures
Methods and Parameters
Arrays
Param Arrays
Object Oriented Programming:
Introduction
Shared (Vs) Instance Members
Constructors
me Key Word
Inheritance
myBase Key Word
Overriding, Shadowing
Notoverrdable Methods
Notinheritable Classes
Interfaces, Absrtact Classes
Destructors,GC
Properties
Structs and Enums
Delegetes
Events
Exception Handling
Partical Classes
String formatting
Working With VS.Net 2008 IDE:
What is IDE?
IDE Windows
ToolBox, Solution Explorer
Server Explorer ……
.NET Solution Structure
Working With Collections:
System. Collections Hierarchy
ArrayList, Hashtable
Generics 3.5 with VB.NET
Working with IO Serialization:
What is Serialization?
Why Serialization?
Binary Serialization
ADO.Net:
What is OleDb?
Working with Connection, Command Object and Datareaders
Working with Execute Methods of Command Object
.NET Providers for SqlServer and Oracle
Working with Adapters and DataSets
DataSet Updation
Data Views
Remoting:
What is Remoting?
Remoting Types
-Server activated types and Client activated types
Remoting API
Designing 3-tier and N-tier Applications
Using Remoting and ADO.NET
Assemblies:
Types Of Assemblies
SFA
MFA
Private Assemblies
Shared Assemblies
Global Assembly Cache
GacUtil
Sn
->Globalization & Satelite assemblies
App Domains & MultiThreading:
What is an AppDomains?
Managed Process (Vs) UnmanagedProcesses
Working with AppDomains
Loading Dll and exe Services in appdomains
What is Threading ?
System. Threading Namespace
Thread Class
Synchonization
Monitor Class
Thread Pool
Threads and AppDomains
Remoting and AppDomains
Introduction to DBMS
File Management System And Its Drawbacks
Database Management System (DBMS) and Data Models
Physical Data Models
Logical Data Models
Hierarchical Data Model (HDBMS)
Network Data Model (NDBMS)
Relational Data Model (RDBMS)
Object Data Model (ODBMS)
Object Relational Data Model (ORDBMS)
3. Conceptual Data Models
Entity – Relationship (E-R) Model
Introduction To SQL Server
Advantages and Drawbacks Of SQL Server Compared To Oracle And DB2
Connecting To Server
Server Type
Server Name
Authentication Modes
Sql Server Authentication Mode
Windows Authentication Mode
Login and Password
Sql Server Management Studio and Tools In Management Studio
Object Explorer
Object Explorer Details
Query Editor
TSQL (Transact Structured Query Language)
Introduction To TSQL
History and Features of TSQL
Types Of TSQL Commands
Data Definition Language (DDL)
Data Manipulation Language (DML)
Data Query Language (DQL)
Transaction Control Language (TCL)
Database
Creating Database
Altering Database
Deleting Database
Constrains
Procedural Integrity Constraints
Declarative Integrity Constraints
Not Null, Unique, Default and Check constraints
Primary Key and Referential Integrity or foreign key constraints
Data Types In TSQL
Table
Creating Table
Altering Table
Deleting Table
Data Manipulation Language
Insert
Identity
Creating A Table From Another Table
Inserting Rows From One Table To Another
Update
Computed Columns
Delete
Truncate
Differences Between Delete and Truncate
Data Query Language (DQL)
Select
Where clause
Order By Clause
Distinct Keyword
Isnull() function
Column aliases
Predicates
Between … And
In
Like
Is Null
Built In Functions
Scalar Functions
Numeric Functions
Character Functions
Conversion Functions
Date Functions
Aggregate Functions
Convenient Aggregate Functions
Statistical Aggregate Functions
Group By and Having Clauses
Super Aggregates
Over(partition by …) Clause
Top n Clause
Set Operators
Union
Intersect
Except
Joins
Inner Join
Equi Join
Natural Join
Non-Equi Join
Self Join
Outer Join
Left Outer Join
Right Outer Join
Full Outer Join
Cross Join
Sub Queries
Single Row Sub Queries
Multi Row Sub Queries
Any or Some
ALL
Nested Sub Queries
Co-Related Sub Queries
Exists and Not Exists
Indexes
Clustered Index
NonClustered Index
Create , Alter and Drop Indexes
Using Indexes
Security
Login Creation
SQL Server Authenticated Login
Windows Authenticated Login
User Creation
Views
Purpose Of Views
Creating , Altering and Dropping Indexes
Simple and Complex Views
Encryption and Schema Binding Options in creating views
Transaction Management
Introduction
Begin Transaction
Commit Transaction
Rollback Transaction
TSQL Programming
Drawbacks Of TSQL that leads to TSQL Programming
Introduction To TSQL Programming
Control statements In TSQL Programming
Conditional Control Statements
If
Case
Looping Control Statements
While
Stored Sub Programs
Advantages Of Stored Sub Programs compared to Independent SQL Statements
Stored Procedures
Creating , Altering and Dropping
Input and Output Parameters
Permissions on Stored Procedures
User Defined Functions
Creating, Altering and Dropping
Types Of User Defined Functions
Scalar Functions
Table Valued Functions
Inline Table Valued Functions
Multi Statement Table Valued Functions
Triggers
Purpose of Triggers
Differences Between Stored Procedures and User Defined Functions and Triggers
Creating, Altering and Dropping Triggers
Magic Tables
Instead Of Triggers
Exception Handling
Implementing Exception Handling
Adding and removing User Defined Error Messages To And From SQL Server Error Messages List
Raising Exceptions Manual
Backup and Restore Of Database
Attach and Detach of Database
Normalization
Server Training Course Duration
30 Working days, daily one hours
Real time Interview Questions
1. Interview Questions for freshers & Experienced
Sv Infotech Offers Advanced Java Training In Dilsukhnagar. Best Training institutes for Advance Java Course in Dilsukhnagar
✓ Attend a Demo. ☎.9030061377