SQL SERVER 2008 PRODUCTION CLUSTER SETUP
REPLICATION TECHNOLOGIES
DISASTER RECOVERY SETUP
SQL SERVER 2008 MIRRORING
REALTIME PRODUCTION CRITICAL SCENARIOS
REALTIME PRODUCTION PERFORMANCE AND TUNING ISSUES
REBUILD MASTER AND RECOVER PRODUCTION DATABASES
SQL SERVER INTEGRATION SERVICES (SSIS)
SQL SERVER REPORTING SERVICES (SSRS)

SQL SERVER 2008 Development Course Highlights

FULL DEVELOPMENT CYCLE EXAMPLES
Database Design and SQL SERVER 2008 PROGRAMMING FOR BACKEND DEVELOPER
Data Modeling
MORE THAN 50 SQL SERVER SCRIPTS
SQL SERVER INTEGRATION SERVICES
SQL SERVER REPORTING SERVICES
Project work for SSIS and SSRS

SQL SERVER INTEGRATION SERVICES

Introduction to the SSIS environment
Tasks
Drilling into the Data Flow
Expressions and Variables
Containers
Advanced Tasks
Event Handling and Logging in SSIS
Migration from DTS
Administrating SSIS
Enterprise package development.

SQL SERVER REPORTING SERVICES

SSRS Architecture and components
Installation and Setup
BIDS environment and the Report Designer IDE
Report Development Lifecycle
Reporting Services Report Designer
Designing and Developing Reports with Reporting Services
Report Deployment
Report Builder
Grouping and Sorting
Parameters
Expressions, Functions, and Custom Code
Report Management
Adhoc Reporting
Report security
Report Scheduling

INTRODUCTION TO BI & MICROSTRATEGY
COMPONENTS OF MICROSTRATEGY
MICROSTRATEGY DESKTOP / PUBLIC OBJECTS

• REPORTS
• METRICS
• FILTERS
• PROMPTS
• CUSTOM GROUPS / CONSOLIDATIONS
• DRILL MAPS

DASH BOARDS
ARCHITECTURE / SCHEMA OBJECTS

• ATTRIBUTES
• FACTS

NARROWCAST SERVER / DISTRIBUTION SERVICES
MICROSRATEGY ADMINISTRATOR
ENTERPRISE MANAGER
INTEGRITY MANAGER
MICROSTRATEGY OFFICE
UPGRADE PROCEDURE

Preamble

• Impact of SharePoint in IT Industry?
• Why it is called a powerful platform and what are the benefits?

Installing SharePoint

• Configure Windows SharePoint Services 3.0
• Configure MOSS 2007

SharePoint Architecture

• Learn about ASP.NET Integration with WSS
• Explore IIS and Application Pools
• Explore Content and Configuration database
• Explore SharePoint web.config file
• Explore 12 Hive

WSS vs MOSS 2007

• Explore WSS features
• Explore MOSS 2007 features

SharePoint Server 2007 Collaboration

• Explore SharePoint team site
  • Team site components
  • Navigation
  • Lists and Libraries
  • Recycle Bin
• Sharing Information cross departments
  • Calendars
  • Tasks
  • Discussions
  • Wiki
  • Blog
• Document Management
  • Versioning
  • Check-In and Check-Out
  • Content Approval
  • Configure Alerts
• Securing Content
  • SharePoint groups
  • Security at list and item level
• Integration with the Office System
  • Integration with Out look
  • Integration with excel and access

Application Security

• Application pools
• Web application security
• Site level security
• List and item level security

Backup and Restore

• Backup and restore through Central Administration
• Backup and restore using stsadm command prompt
• Site template and list templates
• Create new sites and lists based on the custom templates

Shared Service Providers

• Shared Services features and components
• Configure MOSS 2007 Enterprise Search

Search

• Create content source
• Configure crawl rules
• Create Search scopes
• Implement Advanced search
• Add a file type in advance search
• Customize search result pages

My Site

• Explore User profiles and My site

Branding

• Master Pages
• Styles
• Navigation

CAML Queries

• Explore U2U Query builder
• Implement complex CAML queries against the SharePoint lists

Web Parts and User Controls

• Explore SharePoint web parts
• Implement custom web parts and deploy in SharePoint

Debugging

• Explore SharePoint logs
• Explore Event Viewer
• Explore other sources to handle the common errors in development

Event Handlers

• Learn Event handlers
• Synchronous and Asynchronous actions

InfoPath Services

• Explore form features
• Create dynamic forms
• Publishing and activating forms in SharePoint Server

Workflows

• Explore SharePoint Out of the Box workflows
• Develop SharePoint Designer Workflows
• Develop Custom workflows using visual studio

Timer Jobs

• Timer status
• Timer Job Definition
• Create custom timer jobs
• Activate and deactivate in the SharePoint site

Course Introduction and Methodology
Virtualization Overview
Planning & Installing ESX & ESXi

• Planning ESX Server Deployment
• vSphere™ 4.1 Deployment Guidelines
• ESX Installation
• ESX Management
• ESXi Installation
• ESXi Management
• Configuring Resolution Mgt and NTP

Using Tools to Administer a VMware® Environment

• Overview of 3rd Party Tools

Configuring Networking

• Create & Modify Virtual Networks

Configuring Storage

• iSCSI Storage
• Fibre Channel Storage
• VMFS Datastores
• NAS Storage and NFS Datastores
• Raw Device Mapping (RDM)
• Storage Comparisons

vCenter™ and License Server

• Licensing
• vCenter™ Installation
• Site template and list templates
• vCenter™ Inventory
• Managing vCenter™
• Planning vCenter™ Deployment
• Troubleshooting vCenter™, license, and database
• Troubleshooting the VIC

VM Creation and Configuration & Snapshots

• Create a VM
• Create Multiple VMs
• Virtual Appliances
• Physical to Virtual Conversions
• Manage VMs
• Virtual Machine Startup/Shutdown
• Virtual Machine Snapshots
• Web Access
• Troubleshooting Virtual Machines
• Data Recovery (GUI Backup & Restore)

Security and Permissions

• User Access

Advanced ESX and vCenter™ Management

• Configuring VMotion
• Storage VMotion
• Distributed Resource Scheduler (DRS)
• Resource Pools in DRS Cluster
• High Availability (HA)

Patching and Upgrading ESX

• Patching ESX Server 4
• Upgrades and Migrations
• Update Manager
• Upgrading from ESX 3.x to ESX 4.x

Server and VM Monitoring

• Tools for Optimization
• Monitor VM Performance
• Configuring Alarms
• ESX and vCenter™ Log Files