Courses
SAP
- SAP ABAP
- SAP BASIS
- SAP SECURITY
- SAP NETWEAVER
- SAP XI
- SAP FICO
- SAP FSCM
- SAP MM
- SAP WM
- SAP PP
- SAP SRM
- SAP BW
- SAP BI
- SAP BPC
- SAP MDM
- SAP SD
- SAP CRM
- SAP BO
- SAP HR
- SAP HR-ABAP
- SAP GRC
- SAP HCM
- SAP APO
- SAP EP ADMIN
- SAP IS UTILITIES
- SAP PLM
- SAP SCM
- SAP PC
- SAP QM
- SAP IS RETAIL
- SAP EP JAVA WEBDYNPRO
- SAP HANA
- SAP PS
- SAP PI
- SAP IS OIL & GAS
- SAP CS
Oracle
- ORACLE 10 g
- ORACLE APPS DBA
- ORACLE APPS FINANCIALS
- ORACLE APPS TECHNICAL
- ORACLE BPEL
- ORACLE OAF
- ORACLE APPS FINANCE FUNCTIONAL R12
- OBIEE
- ORACLE 11G
- ORACLE DBA
- PL-SQL
- ORACLE HRMS
- ORACLE ADF
Other Technologies
- MS.NET
- SHARE POINT
- JAVA
- SAS
- SAS BI
- SAS OC
- QA TESTING
- SQL SERVER
- TIBCO
- SIEBEL CRM
- SIEBEL ANALYTICS
- UNIX SHELL
- BIZTALK SERVER
- CCNA
- SAS FINANCIAL MANAGEMENT
- AJAX
- LINUX
- SALES FORCE
- CCNP
- MCSE
- VMWARE
- PEOPLESOFT HRMS TECHNICAL
- CRYSTAL-REPORTS
- PMP
- TERA DATA
- WEBSPHERE
- ANDROID
- HADOOP
Data Warehousing
- INFORMATICA
- COGNOS
- DATA STAGE
- BUSINESS OBJECTS
- BUSINESS ANALYST
- COGNOS TM1
- AB INITIO
- MICROSTRATEGY
- COGNOS PLANNING AND BUDGETING
- HYPERION ESSBASE
- HYPERION DATA RELATIONSHIP MANAGEMENT
- HYPERION FINANCIAL MANAGEMENT
- HYPERION INTERACTIVE REPORT
- HYPERION FINANCIAL DATA QUALITY MANAGEMENT
- HYPERION PLANNING
- HYPERION FINANCIAL REPORT
sql server 2008
- 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 & 2008
- SQL Server 2005 & 2008 Editions
- Installing Microsoft SQL Server
- System Requirements
- Preparing for a SQL 2005 Installation
- Installation Checklist
- Setup Features
- Using the System Consistency Checker
- Component Install
- Unattended Installation
- Installation Sequence
- Installation Maintenance
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
- Upgrading to SQL Server Computer Manager
- SQL Server 2005 & 2008 Services node
- SQL Server 2005 & 2008 Network Configuration node
- SQL Server 2005 & 2008 Native Client Configuration node
- The SQLCMD Management Utility
- SQLCMD Syntax
- SQLCMD Variables
- Dedicated Administrative Connection
- SQL Server Management Studio SQLCMD Mode
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
- Parallel (multiple CPU) Index Operations
- Lock Options
- Included Columns in Indexes
- Partitioned Tables and Indexes
- XML Index Support
- Altering an Index
- Rebuilding an Index
- Reorganizing an Index
- Disabling an Index
- Dropping an Index
- Index Fragmentation
- Using the Database Tuning Advisor
Securing SQL Server 2005 & 2008
- Implementing Securable
- New Security Features
- Principals
- Securable
- Permissions
- Permission Types
- Managing Logins
- Managing Schemas
- Managing Users
- 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
- Native Data Encryption
- Code and Module Signing
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
- 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
- High Availability Operating Mode
- High Protection Operating Mode
- High Performance Operating Mode
- 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
- Support for Oracle Publishing
- HTTP Synchronization for Merge Replication
- Subscriber Initialization
- 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 & 2008 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 Optimization
- Federated Database Servers
- Partitioned Indexes
- Lock Optimization
- Best Practices for Native XML Web Services