User-agent: * Allow: /

Software Training Institute

Thursday 17 November 2011

ABAP – COURSE CONTENT



1)     Introduction to ERP
2)     Introduction to SAP R/3 Architecture           
3)     SAP Landscape
4)     Introduction to ABAP/4 - Basics
a)     Data Types & Data Objects
b)    String Operations
c)     Conditional Statements(IF and CASE)
d)     Loops(DO and WHILE)
e)     Designing of Selection Screens
5)     Introduction to Data Dictionary
a)     Creation of Tables, Structures, Data elements and Domains
b)    Creation of Search helps and Lock-objects
c)     Open SQL Statements
6)     Introduction to Internal Tables
a)     Declaring, Populating and Processing of Internal tables
b)    Control Break Statements
7)     Modularization Techniques
Includes, Function Modules, Subroutines and Macros
8)     Reports
Classical Reports, Interactive Reports and ALV Reports
9)     Dialog/Module pool/Transactions
a)     Flow Logic and Events
b)    Table controls, Tab Strips and Sub Screens
10)  BDC(Batch Data Communication)
a)     Call Transaction and Session Methods
b)    LSMW(Legacy System Migration Workbench)
11)  SAP Scripts
12)  Smart forms
13)  User-exits and BADIs
14)  Enhancement Spots
15)  OOPS(Object Oriented Programming Concepts)
16)  Debugging Techniques
Break-points and Watch-points
17)  Performance Techniques
Runtime Analysis and SQL Trace
18)  Transport Organizer
19)  Introduction to Cross Applications
RFC, BAPI and ALE-IDOC
20)  Resume Preparation and Mock Interviews

Wednesday 2 November 2011

SQL Server 2005/2008


Introduction to SQL Server 2005/2008
  • Overview on RDBMS and Beyond Relational
  • System Databases
  • What’s New in SQL Server 2008

Installation of SQL Server 2005/2008
  • H/W Requirements
  • S/W Requirements
  • Multiple Instances
  • User Databases
  • SSMS Environment
  • Trouble Shooting Techniques

Upgrading to SQL Server 2005/2008
  • Upgrading the server by applying service packs
  • Upgrading the server by Appling hot fixes
  • In-place up gradation from SQL Server 2005 to 2008
  • Upgrade Adviser

Pages & Extents
  • Pages
  • Extents
  • Types of Extents
  • Managing Extent Allocation
  • Tracking Free Space

File & File groups
  • Database files
  • Primary Data files
  • Secondary Data files
  • Log files
  • Database File groups (Primary & User-defined)

Memory Architecture
  • 32-bit Vs 64-bit Architecture
  • Dynamic Memory Management
  • Effects of min and Max server memory
  • Using AWE

Configuring SQL Server
  • Configuring Network protocols from SQL Server Manager
  • Configuring features by using SQL Server surface area Manager
  • Configuring other settings through sp_configure
  • Dedicated Administrator Connection (DAC)
  • Connecting to DAC
  • Configuring Database Mail
  • Configuring Alert System in SQL Server agent
  • Configuring Database Settings
  • Configuring Memory Settings

Managing Services
  • Starting and Stopping Services through
Configure Manger
  • Net Command
  • Command Prompt (sqlsrvr.exe)
  • Start Up Parameter
  • Starting SQL Server in single user mode
  • Default Parameter and Advanced Parameter

Migrating SQL Server
  • Difference between in-place & Side by Side
  • Migrating by using Back and restore method
  • Migrating logins
  • Migrating Jobs
  • Migrating DTS Packages to SSIS
  • Import & Export

Security, Automation
  • Security Principles
  • Server and Database Principle
  • Database Role
  • Creating Logins and mapping Users to databases
  • Creating Schemas

Automating Administrative Tasks
  • About SQL Server Agent
  • Creating jobs, Alert and Operators
  • Scheduling the job
  • Creating Maintenance Plans
  • Working with job activity monitor

Monitoring SQL Server
  • Monitoring SQL Server Process by activity Monitor
  • Monitoring job activities by job activity Monitor
  • Monitoring SQL Server Error Logs/Windows by log file viewer

High Availability and Replication
Backup & Restore
  • Recovery Models (Simple, Full & Bulk – Logged)
  • How Backups works
  • Types of Backups
  • Full Backup
  • Diff Backup
  • T-log Backup
  • Copy Only
  • Mirror
  • Tail – Log
  • Compressed Backups
  • Restoring Modes (With Recovery, No Recovery, Read Only/Stand by)
  • Performing Restore (Point –in – time Recovery)

Log Shipping
  • Log Shipping Architecture
  • Building DRS for Log – Shipping
  • Pre – requisites/log-shipping Process
  • Deploying Log Shipping
  • Working with Log Shipping Monitor
  • Log shipping role changing
  • Removing Log Shipping

Database Mirroring
  • Overview of Database Mirroring
  • Operating Modes in Database Miring
  • Pre – Requisites for Database Mirroring
  • Deploying Database Mirroring
  • Fail – over from principle to Mirror
  • Working with Database Mirroring Monitor
  • Advantage & Disadvantage of Database Mirroring
  • Database Snapshots
  • Using Database Snapshots for reporting purpose

Replication
  • Replication Overview
  • Replication Models (snapshot/Transactional/Merge)
  • Replication agents
  • Configuration Distributor
  • Deploying Transaction Replication for High Availability
  • Creating Subscriptions (Homogeneous / Heterogeneous)
  • Monitoring replication by using replication monitor
  • Scripting Replication


Clustering SQL Server
  • What is a cluster & overview of windows Clustering
  • SQL Server Clustering Concepts
  • Installing Services pack & hot fixes on a cluster
  • Installing and Configuring SQL Server 2005 clustering
  • Moving Groups between nodes
  • Cluster Administrator
  • Adding a node on a SQL Server 2008 Failover cluster
  • Applying patches on a SQL Server 2008 cluster

Performance Tuning & Indexing
  • Index Architecture
  • How to optimally take advantage of indexes
  • Clustered & Non – clustered indexes
  • Index fragmentation
  • Indexing De-fragmentation options update Statistics
  

Oracle 11 g Database Administration


Pre requisite:
  • Working knowledge of SQL & PL / SQL
  •  Knowledge of Windows & Linux Basic Administration
 Architecture & Installation
  •  Defining an Oracle Server, Database and Instance
  • Understanding of Physical and Logical Structure
  • Execution of SQL Statements & User Sessions
  • Preparing the Database Environment for Installation
·         

Creating and Managing Oracle Database & Instance

  • Understanding SGA(System Global Area) – DB Buffer Cache, Log Buffer & Shared Pool
  • Understanding Background Process – Mandatory/Optional and their purposes
  • Initialization files – PFILE & SPFILE, Advantage of SPFILE over PFILE
  • Data Dictionary v Dynamic Performance Views to retrieve the information from Database
  • Using DBCA & Manually to Create a Database

Managing Tablespaces
  • Tablespace Architecture – TS types, OFA (Optimal Flexible Architecture)
  • Creating, Altering & Renaming a Tablespace
  • Adding, Resizing, Renaming and Relocating Datafiles
  • Creating and Managing a Tablespace using OMF and associated Advantages & Disadvantages
  • Tablespaces – offline, online, read only, read-write, multiple blocks
  • Temporary TS Groups
  • Extent Management – Dictionary and Locally Managed, Advantages & Disadvantages

Storage Management
  • Storage Parameters
  • Creating and Maintaining tables using Storage parameters
  • Working with Constraints and Indexes

User Management
  • Creating and Managing Users and Resources
  • Managing User Privileges and Roles

UNDO Management
  • Understanding Undo / Redo basics
  • Managing UNDO Tablespaces
  • Flashback Concepts

Managing Control files and Redo Log files
  • Purpose of Control files & Redolog files
  • Multiplexing & Backing of Control files
  • Multiplexing & Archiving of Online Redo Log files

Understanding Networking and their connectivity
  • Overview of Oracle Net Architecture
  • Different types of Networking
  • Oracle Net Service Configurations
  • Database Links, Materialized Views
  • Oracle Shared Server-configuring shared servers & dispatchers

Backup and Recovery
  • Basics of Database Backups & Recoveries
  • User Managed Backups –Online, Offline, Exports/Imports & Data Pumps
  • User Managed Recoveries – Complete, Incomplete, Point in time Recoveries
  • Oracle Recovery Manager (RMAN) – Features & Components
  • Configuring, Backup and Recoveries using RMAN
  • Transportable Tablespaces (TTS), SQL*Loader

Performance Tuning
  • Overview of Tuning
  • Application Tuning ,Memory Tuning, SQL Tuning
  • TKPROF, Explain Plan

Availability
  • Data Guard-configuration,  Switch Over, Fail Over
  • LogMiner
  • Oracle Automatic Storage Management (Oracle ASM) - Oracle ASM Storage Components, Oracle ASM Instances, using OMF and User-Managed Files

Oracle Enterprise 11g Database Control (GUI tool for Oracle Database Administration)
  • Overview of Enterprise Manager
  • UNDO Advisor
  • Events and Event Notification
  • Scheduling Jobs

Difference between 9i, 10g and 11g
  • New Features, deprecated features, installations