Others

SQL Server DBA

SQL Server 2005 DBA

Accord Soft Offers Best SQL Server 2005 DBA Training in Chennai. We offer Internships in Real-Life Business Applications of our clients. Students are given Practical Training in the below mentioned syllabus. The syllabus can be customized according to individual needs.

Course Advantages
SQL Server 2005 provides a robust platform that enables organizations to run their most demanding, mission-critical applications. It is essential that database administrators know how to manage this complex platform correctly. This hands-on course providesyou with the skills you need to install SQL Server, create and modify storage structures, manage security, and backup and recover databases.

At the end of this course you will be able to:

Install Microsoft SQL Server 2005 and the associated bundled tools
Understand the many tools that facilitate effective Database Administration
Monitor the smooth running of the Database Server
Maintain the Database and Indexes
Setup and control Database Security
Cope effectively with Database Disaster Recovery
Implement High Availability and Replication
Use relevant TSQL commands
Understand the basics of Integration Services
Implement SQL Server Full-text search

SQL Server 2005 Database Administration Training

SQL Server 2005 Overview

Availability and Scalability Features
Security Features
Data Management Features
Administration and Maintenance Features
Development Features
To enable SQLiMail Testing mail delivery

Installing SQL Server 2005

Installing Microsoft SQL Server
System Requirements
Preparing for a SQL 2005 Installation
Installation Checklist
Setup Features
Using the System Consistency Checker
Unattended Installation
Installation Sequence
Installation Maintenance
Upgrading from previous versions of SQL Server
To verify the Installation
Administrative Tools

Upgrading to SQL Server Management Studio

Management Studio Windows
Registered Servers
Object Explorer
Review Database Objects
Modify Database Properties
Create Database Scripts
The Maintenance Plans Node
Solution Explorer
Query Editor
Template Explorer
Dynamic Help
SQL Server 2005 Services node
SQL Server 2005 Network Configuration node
SQL Server 2005 Native Client Configuration node
Dedicated Administrative Connection
SQL Server Management Studio SQLCMD Mode
Using SQL Management Objects
SMO Object Model

Monitoring the Database Server

Managing Metadata Views
Metadata Storage
System Views
Information Schema
Catalog Views
Sys All
Dynamic Management Views
System Stored Procedures

Database and Index Maintenance

Index Management New Index Features
Creating Indexes
Online Index Maintenance
Lock Options
Included Columns in Indexes
Partitioned Tables and Indexes
XML Index Support
Altering an Index
Rebuilding an Index
Reorganising an Index
Disabling an Index Dropping an Index
Index Fragmentation
Using the Database Tuning Advisor

Securing SQL Server 2005

Implementing Securables
New Security Features
Principals Securables
Permissions
Permission Types Managing Logins
Managing Users
Managing Schemas Schema Definition
Using Schemas
Managing Execution Context
Managing Permissions
Manage Server Permissions
Manage Server-Scope Securable Permissions
Manage Database Permissions
Manage Database-Scope Securable Permissions
Managing Certificates

SQL Server Disaster Recovery

Disaster Recovery
SQL 2005 Disaster Recovery Feature
Enhanced Features Database Snapshots Creating a Snapshot
Common Snapshot Applications
Undeleting table rows Undoing a table update
Recovering a dropped object
Backup and Restore
Backup Changes Restore Changes
Media Integrity Changes
Recovering the MASTER Database
Create a mirrored backup
Restore from the backup mirror
Create a snapshot
Restore the snapshot data
Automate the creation of daily snapshots

Database Availability

SQL 2005 Data Availability
Database Mirroring
The Witness Server and Automatic Failover
Configuring Database Mirroring
Transaction Safety Level
Operating Modes
Mirroring Security
Monitoring Mirroring
Database States for Database Mirroring
Prepare the Servers Configure Mirroring
Verify Principal and Mirror Access
Execute the Mirror Failover
Verify Mirror and Witness Status
Terminating the Mirror Session

Replicating Information

Replication Enhancements
Stand-alone Replication Monitor
HTTP Synchronisation for Merge Replication
Subscriber Initialisation
Replicating DDL Statements
Modified User Interface
Replication Management Objects
To Configure Publishing and Distribution
Configuring Peer-to-Peer Replication
Create a Publication
Create a Subscription with RMO

SQL Server 2005 Integration Services

Creating the Database Objects
Creating a Package Using Business Intelligence Studio
Integration Services Project Template
OLE DB Command object
Column Mappings
Adding a Data Viewer

Monitoring and Performance

SQL Server Profiler
Optimal Data Storage
Diagnostic Tools Query Analyzer
Database Engine Tuning Advisor
Index Optimisation
Federated Database Servers
Partitioned Indexes
Lock optimsation

Symbian OS

Oracle DBA

Dip, in Mob Apps Devp

Diploma in Mobile Application Development

Accord Soft Offers Best Diploma in Mobile Application development Training in Chennai. We offer Internships in Real-Life Business Applications of our clients. Students are given Practical Training in the below mentioned syllabus. The syllabus can be customized according to individual needs.

SYMBIAN OS PROGRAMMING

1. Overview of the course

Introduction to symbian OS and code warrior IDE
Introduction to availability of mobile phones.

2. Coding idioms for Symbian OS Over an Application

Naming Conventions for Symbian OS
Exceptional Handling in Symbian Style (ELeave, TRAP & TRAPD)
The Cleanup Stack (AddtoStackL)
Two-Phase Construction
Descriptor and its Various Styles
Panics
Bug Detection Using Assertions

3. Symbian Architecture

Overview of Symbian Architecture using class hierarchy.

4. An Insight into the Application Frame work

Creating a console Application.
Creating a GUI Application using frame work.
Working on various aspects of GUI.

5. Debugging

Emulator Debugging.
Device Debugging.

6. Symbian OS User Interfaces

Defining your own dialogs and implementing
Multipage dialogs
Reusing buttons
Resources and controls
Write basic views
Use graphics contexts
Menu design issues

7. Active Object

Asynchronous Event Handling
Implementing Active scheduler
Implementing Active Object

8. Client-server

When and how to write a server
Client-side and server-side issues
Dealing with Synchronous and Asynchronous Requests

9. Sockets and TCP/ IP

Introduction to the Socket server and its key classes.
Implementing Socket-based communication.
Architecture for Socket-based communications.

10. Using Design patterns under various scenarios

Developing Mobile Phone Applications With J2ME Technology

Overview of the J2ME Architecture

Describe J2ME Architecture
Run the J2ME Wireless Toolkit demonstrations

Building and Executing MIDP Applications

Define the MIDP 2.0 application environment
Define the MIDP development process
Write and build a MIDP application (MIDlet)
Interrogate the device to verify that it can run the new MIDlet

Creating a High-Level User Interface

Describe the MIDP user interface (UI) architecture
Describe the MIDP high-level UI API
Describe the Display object
Define the Item class and subclass components
Implement high-level item event handling
Display a message on the MIDlet screen
Implement a user input interface
Handle user input through item state changes
Verify form data using a Command object
Implement the menu system

Creating a Low-Level User Interface

Describe the MIDP low-level UI API
Describe the low-level UI event handling
Handle pointer events
Create and implement a splash screen using the Canvas class
Implement a skip option on the splash screen

Enhanced High and Low-Level Interfaces

Describe the CustomItem abstract class
Describe CustomItem class event handling
Describe the javax.microedition.lcdui.game package
Create a form and add CustomItem, TextBox, and Gauge objects to download a game
Create the StarShip Battle 2004 game

Managing Data on the Device

Define data persistence and the RMS package in the MIDP
Access RecordStore objects on the device object
Store and retrieve data in a RecordStore object
Describe the RecordEnumeration interface
List RecordStore objects
Share a RecordStore object between MIDlet suites
Implement an option screen, and save and retrieve the data in the RecordStore object

Accessing Network Data and Services

Access data with the Generic Connection Framework (GCF) interface
Exchange Data over Hypertext Transfer Protocol (HTTP)
Use the HttpConnection interface to retrieve text for an application help screen

Media Control

Describe media control in the MIDP
Describe the Mobile Media API (MMAPI) class hierarchy and interfaces
Add sound to the StarShip Battle 2004 game

MIDP Security

Describe the MIDlet security model and define three MIDP security concerns
Describe the MIDP Push technology
Create a certificate
Authenticate a MIDlet suite
Create a MIDlet that handles static Push connections
Create a MIDlet that handles dynamic Push connections

Over-the-Air Provisioning

Download J2ME applications
Describe application deployment
Provision MIDP 2.0 applications

iPhone Mobile Application development

Intro to Objective-C:
Objective-C is the object-oriented programming language that you use to write iPhone apps. While this isn't a comprehensive course on Objective-C, you'll learn enough to jump right into iPhone development: classes, objects, properties, message sending, memory management, and the Foundation classes.

Xcode and Interface Builder
Xcode is the IDE used for iPhone development and Interface Builder is the visual tool for designing your app's user interface. You'll learn how to use both of them to work more efficiently.

Cocoa Touch
Cocoa Touch is a set of object-oriented libraries for creating apps that run on the iPhone and iPod Touch. Cocoa Touch is based on Cocoa, and embodies various object-oriented design patterns also used for programming on the Mac. Understanding those patterns is essential to becoming a competent iPhone developer. You'll learn the benefits of model-view-controller (MVC), delegation, notifications, and other patterns in Cocoa Touch.

Views and Their Controllers
Views represent the user interface of your app, and all the dynamic aspects of a view are handled by a view controller. View controllers are the hub of the model-view-controller (MVC) design. You'll learn how to design views and wire them up to view controllers with outlets and actions.

Navigation
Efficient and consistent navigation is especially important on a mobile device. You'll learn how to use navigation and tab bar controllers to improve the user experience of your app.

Table Views
Table views are central to many iPhone apps, such as the contact manager. You'll learn how to organize data in tables, insert and delete table data, and navigate between tables using navigation controllers.

Keyboard Input
The virtual keyboard is unique to the iPhone and it's important that your app makes it as easy as possible to enter text. You'll learn how to use delegates to design and handle keyboard input for an ideal user experience.

Touch Events
Take advantage of the touch screen by learning how to handle touch events and multi-touch gestures.

Core Data
Core Data is a new feature of the iPhone 3.0 OS that offers an elegant solution to data modeling and persistence. You'll learn how to get started managing, modeling, and persisting app data using Core Data.

Custom Drawing
Graphics are an important element of your app's user interface. Static images only take you so far. Set your app apart from the crowd by learning how to create custom views drawn with Core Graphics.

Core Animation
Add that extra :"wow factor:" to your app and give users visual feedback through rich animations by learning how to use basic animation layers and timing functions.

Photos
Personalize your app by learning how to access a user's existing photos from your app.

Networking
Extend the reach of your app by learning how to communicate with external web services.

Performance and Debugging
Learn how to use power tools, including Instruments and the Clang Static Analyzer, to detect memory leaks and profile the performance of your app.

SQL Server Developer Track

BI & DWH

Business Intelligence & Datawarehousing- (BI & DWH)

Training Duration- 60 Hours

Accord Soft Offers Best Business Intelligence & Datawarehousing Training in Chennai. We offer Internships in Real-Life Business Applications of our clients. Students are given Practical Training in the below mentioned syllabus. The syllabus can be customized according to individual needs.

Datawarehousing

What is Data Warehouse?
Characteristics of Data warehouse
What is Data warehousing?
Principles of Data warehouse
Benefits of DWH
What is an Online Transactional system (OLTP)?
Difference between OLTP and DWH
Architecture of DWH
HPQS
Approaches of Data warehousing
Normalization and De-normalization
DWH Lifecycle
Data Modeling
Dimension table
Fact Table
Aggregate table
Schemas
Star schema
Snowflake schema
Basic Data Model Objects
Identifying
Non-identifying
Display Levels
Subject Area
Star schema
Snowflake schema
Types Of Fact Tables:
Cumulative
Snapshot
Fact less Fact
Types of Facts
Additive
Semi Additive
Non Additive
Confirmed Dimension
Confirmed Fact
Degenerated Dimension
Casual Dimension
ODS
Cube
Hierarchies
Slowly changing Dimension Concepts
OLAP's

ERWIN

Getting Started
Erwin Workplace
Model Explorer
Dockable Toolbars
Stored Display Tabs
Basic Data Model Objects
Identifying
Non-identifying
Display Levels
Subject Area

Informatica

Introduction to Informatica
Products of Informatica
Difference between Power mart and Power center
Installation of Informatica
Configuring Informatica
Configuring Informatica Repository Server
Creating & Configuring Repository
Configuration Informatica Server
Configuration Temp Server(Workflow Manager)
Informatica Architecture
Informatica Client Tools
Designer (Components)
Source Analyzer
Workflow Manager (Components)
Workflow Monitor
Repository Manager
Repository Server Admin Console
Informatica Server Tools
Repository Server
Server
Transformations
Source Qualifier
Filter
Expression
Aggregator
Joiner
Router
Rank
Sorter
Sequence Generator
Union
Xml Source Qualifier
Lookup (Connected/Unconnected)
Stored Procedure(Connected/Unconnected)
Update Strategy
Transaction Control
Normalizer
Application Source Qualifier
Application multi-group Source Qualifier
Custom
Mapplet Input
Mapplet Output
Midstream XML Generator
Midstream XML Parser
Concepts
SQL Override
Working with files (Sources, Target)
File Repository Concept
Constrained Based Loading
Parameters
Mapping Parameters
Mapping Variables
Session Parameters
Incremental Aggregator
Application Source Qualifier
Debugging
Slowly Changing Dimension

Business Objects

BO Reporting Tool
The Query Panel
Turning Tables to chart
Formatting Cells/Tables
The Structure View
Insertion of Rows or Columns
Breaks
Sections
Ranking
Filter
Alerters
Crosstabs
Grouping
Slice? and - Dice
Drill
Exporting Data
Data Providers
Master/Detail Reports
Introduction to BO Designer
Simple Universe and Object Creation
Creating Hierarchy
Resolving Loops and SQL Problems
Supervisor

Business Objects

Introduction to Web intelligence
Getting started with Info view
Viewing Documents in Info view
Creating New Documents with queries
Restricting Data returned by a Query
Displaying information in different ways
Enhancing report presentation
Formatting reports
Creating Formulae and Variables

COGNOS

Cognos Impromptu
Power play Window
Transformer

COGNOS Reportnet

Cognos Reportnet an Architecture
Cognos connection
Report studio
Query studio
Frame work manager

Cloud Computing

Cloud Computing - (SalesForce)

Building Applications with Force.com & Visualforce is a must for application developers who want to create custom Force.com applications or customize existing Salesforce applications. Participants will learn how to use the declarative "clicks not code" capabilities of the Force.com platform to create new applications as well as Visualforce pages and components to create custom interfaces. Apex & Visualforce Controllers is perfect for developers who want a deep dive into Force.com capabilities to build and deploy Force.com applications. This hands-on course covers the Apex programming language, including Visualforce controllers.

What You Will Learn

When you complete the course, you will be able to use

The capabilities of the Force.com platform to develop or extend software-as-a-service (SaaS) applications
Build and customize multiuser software-as-a-service (SaaS) applications with just clicks
Define the application's data model
Customize the user interface
Create advanced workflows and validations
Automate business processes
Manage your data
Develop a custom user interface with Visualforce
Develop custom Apex code
Create Apex triggers to take action when records are saved
Develop using the Force.com Sandbox testing environment
Write Visualforce controllers to manage custom data sets and actions for pages
Create multi-page wizards, maintaining a unified view state across the experience

Designing Applications on Force.com

Learn about factors to consider when building a data model
Develop custom objects and fields, encrypted fields, field help, and field history tracking
Use master detail, lookup, and many-to-many Relationships
Create a user interface for custom applications using the Custom Object tab, Page Layout, and
Customization options
Set field attributes on the page layout
Use the Custom Object queue and event-based
Workflow rules with field update actions
Develop custom formulas and validation rules

Designing Applications for Multiple Users

Learn about factors to consider when designing applications for multiple users
Create profiles, understand what a profile controls (including data access), and customize profiles to manage the user experience
Customize the user experience with record types and page layouts
Control access to records
Employ OWD, sharing rules and levels, roles, public groups, and manual share
Apply profiles, OWDs, role hierarchy, and sharing to restrict access to sensitive data
Apply OWDs, public groups, and manual sharing to create conditional access to data
Analyze suitability of FLS, page layouts, and record types to satisfy business requirements

Implementing Business Processes

Use the vlookup, regex, ischanged, isnew, and priorvalue functions to build business processes
Use validation rules to enforce conditional required behavior
Use functions to enforce data format and data consistency
Implement multistep approval workflows and escalations to automate business processes
Create parallel approval workflows and workflow approvals with dynamic approval routing
Use outbound messages as part of an approval workflow
Establish approval workflow criteria with cross-object formulas
Set up field history tracking to audit processes
Learn techniques to prevent or record data Changes

Managing Data

Learn when and how to use upsert
Use data management tools and the capabilities of API-based tools
Configure the Data Loader via command line
Encrypt passwords using encrypt.bat
Use the Data Loader to create mapping files and to upsert data

Visualforce Pages

Learn about the capabilities of the Visualforce framework
Incorporate Visualforce pages into Salesforce
Construct expression bindings and incorporate Salesforce into Visualforce pages with
Visualforce tags
Use Visualforce tags to create page layouts, input forms, output tables, custom components, and more
Create partial page refreshes on JavaScript events
Learn about the functionality that comes with Visualforce standard controllers
Find out when Apex is required for create

Apex

Apex features compared to other programming languages
Use cases for which Apex is a good solution
Apex access modifiers
Available Apex object types
About types of collections
The syntax for including SOQL queries within Apex
Write SOQL for loops to handle bulk data
About the two types of DML statements
Use limit statements
The Save execution order and when "before" and "after" Apex triggers fre
The types of governor limits and contexts Code Apex triggers to handle bulk data
Unit test for a previous class, using assertion methods, and run a test
Write a Web services class
Consume an external WSDL and access it through Apex
The arguments to send an email from Apex
Create a Salesforce email domain and code a class to consume email

Visualforce Controllers

Explore the functionality of each Visualforce standard controller
Code custom controllers and extensions
Use testing, debugging, and deploying controllers capabilities
Learn the basics of testing controllers vs. regular Apex classes

Courses

Reach Us

Name

Phone

Course Interested In

Interested in Placement Training

Yes No

Query

Gallery