Advance SQL Server Training in Bangalore

MS SQL Server

Introducing MS SQL Server

Overview of database fundamentals
• Client/Server
• RDBMS

Assembling a Database
Building a database
• Create / Delete Database
• Choosing file names and locations
• Determining file size and growth parameters
• Utilizing schemas to partition tables

Designing tables
• Defining columns and attributes
• Selecting appropriate data types
• Setting the primary keys and indexes
• Modifying or removing columns

Applying declarative constraints
• Enforcing check constraints
• Validating the existing data

Developing Database Applications
Retrieving data with Transact-SQL
• Writing SQL queries with Management Studio
• Sorting the final result sets
• Data by groups
• Joining columns from different tables
• Refining result sets with sub queries
• Altering data with SQL commands
• INSERT
• UPDATE
• DELETE

Storing query definitions
• Generating views with Management Studio
• Simplifying data access with views

Server-side and client-side programming
• Constructing a stored procedure
• Executing a stored procedure
• Exploring triggers
• Integrating SQL Server with Office


Database Management
• Export & Import Data to Different Database
• Export & Import Data from other package
• Copy Table Data
• Taking Backup & Restoring Data



Duration: 30 Hrs

Mails Us :
abacustechservices@gmail.com
Call : +91-8050080245


mail us your contact details we will contact you.

.Net Training in Bangalore

In view of the huge demand in the IT industry, We are well placed to provide an appropriate solution to its corporate and individual customers through is wide range of training programs starting from the fundamentals to the most advanced technologies with a greater focus on quality training with the most experienced trainers and the most effective training methodologies in very low cost.

Microsoft Visual Studio 2008 (.NET 3.5)

Module1

.NET Framework 3.5

• Getting Started
• Windows Operating Systems
• Win32, Com+
• Microsoft.Net & Versions
• Features of .Net Framework
• .Net Framework Architecture
• Components of .Net Framework
• Language Support
• Types of Applications
• Framework Libraries
• Namespaces, Assemblies & Deployment
• .Net 3.0/3.5 Newer Capabilities
• WCF, WPF
• Security
• Memory Management
• Metadata & Reflection
• Installations & Getting Started
• Creating Applications
• Testing & Debugging Applications
• Other Useful Tools

Module 2

ASP.Net

• Introduction to Internet & Web Applications
• Introduction to Dynamic Web Pages & ASP.Net
• ASP.Net Vs ASP
• ASP.Net Page Life Cycle
• ASP.Net Controls
• Validation Controls
• Create Master Page and Content Pages
• Data Binding in ASP.Net
• State Management & Security Issues in ASP.Net
• Configuration Settings
• Regular expressions
• Tracing & Debugging
• Deploying ASP.Net Applications

Module 3

C#.Net Programming

• Introduction to .Net Framework & Features of C#.Net
• Creating Console Applications
• Data Types, Variables, Constants
• Boxing & Un Boxing
• Operators & Expressions
• Control Structures
• Arrays & Strings
• Multithreading
• Delegates & Events
• Implementing OOPS
• OOPS Vs Structural Programming
• Features of OOPS
• Classes & Objects
• Data Abstractions, Data Hiding
• Encapsulation
• Inheritance
• Polymorphism
• Operator Overloading, Function Overloading
• Constructors & Destructors

Module 4

VB.Net Programming

• Introduction to Event driven programming & VB.Net
• Features of VB
• Creating Console Applications
• Data Types, Variables, Constants
• Operators & Expressions
• Control Structures
• Multithreading
  Arrays & Strings
  Implementing OOPS

Module 5

ADO.Net & XML

• Introduction to Database & SQL Server
• Introduction to Disconnected Architecture & ADO.Net
• ADO.Net Vs ADO
• ADO.Net Objects
• Connection objects, Data Adapter
• Command Builders, Data Table
• Data Set, Data Reader
• Data Retrieval, Insertion, Deletion & Updation
• ADO.Net Connection Pooling
• Using Data Controls
• Introduction to XML
• XML Tree, XML Syntax

Duration: 50Hrs



Mails Us :
care@study.abacustechservices.com,
abacustechservices@gmail.com

mail us your contact details we will contact you.