Back Office Applications

SQL Server Administration

This course provides delegates with the knowledge and skills required to install, configure, administer, and troubleshoot the client-server database management system of Microsoft SQL Server. The course will help delegates prepare for the Microsoft Certified Professional Exam 70?228, System Administration for Microsoft SQL Server 2000. Delegates should be experienced in the operation of Windows 2000.

Duration - 5 days.

SQL Server Overview

What Is SQL Server, SQL Server Integration, SQL Server Databases, SQL Server Security, Working with SQL Server,

Practical: SQL Server Overview.

Planning to Install SQL Server

Hardware Installation Considerations, SQL Server 2000 Editions, Software Installation Considerations, Methods of Installing SQL Server, Verifying the Installation, Configuring SQL Server, Enterprise Manager, Troubleshooting

Practical: Installing SQL Server.

Managing Database Files

Introduction to Data Structures, Creating Databases, Managing Databases, Placing Database Files and Logs, Optimising the Database, Using Hardware-based RAID, Optimising the Database, Using Filegroups, Optimising the Database, Using Filegroups with Hardware-based RAID, Capacity Planning, Performance Considerations. 

Practical: Managing Database Files

Managing Security

Implementing an Authentication Mode, Assigning Logins to Users and Roles, Assigning Permissions to Users and Roles, Managing Security Within SQL Server, Managing Application Security, Managing SQL Server Security in the Enterprise.

Practical: Managing Security, Managing Permissions, Managing Application Security.

Performing Administrative Tasks

Automating Multiserver Jobs, Routine SQL Server Administrative Tasks, Automating Routine Maintenance Tasks, Configuration Tasks, Creating Alerts, Troubleshooting SQL Server Automation, Automating Multiserver Jobs.

Configuring SQL Server

Creating Jobs and Operators, Creating Alerts, Backing Up Databases, Preventing Data Loss, Setting and Changing a Database Recovery Model, SQL Server Backup, When to Back Up Databases, Performing Backups, Types of Backup Methods, Planning a Backup Strategy, Performance Considerations.

Practical: Backing Up Databases.

Restoring Databases

SQL Server Recovery Process, Preparing to Restore a Database, Restoring Backups, Restoring Databases from Different Backup Types.

Restoring Damaged System Databases

Practical: Restoring Databases

Monitoring SQL Server for Performance

Why to Monitor SQL Server Performance, Monitoring and Tuning, Tools for Monitoring SQL Server, Common Monitoring and Tuning Tasks.

Practical: Monitoring SQL Server.

Transferring Data

Introduction to Transferring Data, Tools for Importing and Exporting Data in SQL Server, Introduction to DTS, Transforming Data with DTS.

Practical: Transferring Data.

Maintaining High Availability

Introduction to Availability, Increasing Availability, Using Failover, Clustering, Standby Servers and Log Shipping.

Practical: Automating the Maintenance of a Standby Server.

Introducing Replication

Introduction to Distributed Data, Introduction to SQL Server Replication, SQL Server Replication Agents, SQL Server Replication Types. Physical Replication Models.

Practical: Implementing Replication

Top

Querying Microsoft SQL Server 2000 with Transact-SQL

This course provides delegates with the technical skills required to write basic Transact-SQL queries for SQL Server 2000. The course is intended for SQL Server database administrators, implementers, system engineers, and developers who are responsible for writing queries.

Delegates should have:, Experience using a Windows operating system., An understanding of basic relational database concepts, & familiarity with the role of the database administrator.

The course will help prepare for the Microsoft Certified Professional exam: 70-229, Implementing a Database Design on Microsoft SQL Server 2000.

Duration: 2 days.

Introduction to Transact-SQL

The Transact-SQL Programming Language, Types of Transact-SQL Statements, Transact-SQL Syntax Elements, Using SQL Server Books Online

Using Transact-SQL

 Querying Tools SQL Query Analyzer, Using the Object Browser Tool in SQL Query Analyzer, Using the osql Utility, Executing Transact-SQL Statements, Creating and Executing Transact-SQL Scripts

Retrieving Data

Retrieving Data by Using the SELECT Statement, Filtering Data, Formatting Result Sets, How Queries Are Processed, Performance Considerations, Retrieving Data and Manipulating Result Sets

Grouping and Summarizing Data

Listing the TOP n Values, Using Aggregate Functions, GROUP BY Fundamentals, Generating Aggregate Values Within Result Sets, Using the COMPUTE and COMPUTE BY Clauses, Grouping and Summarizing Data

Joining Multiple Tables

Using Aliases for Table Names, Combining Data from Multiple Tables, Combining Multiple Result Sets, Querying Multiple Tables

Working with Subqueries

Introduction to Subqueries, Using a Subquery as a Derived Table, Using a Subquery as an Expression, Using a Subquery to Correlate Data, Using the EXISTS and NOT EXISTS Clauses, Working with Subqueries

Modifying Data

Using Transactions, Inserting Data, Deleting Data, Updating Data, Performance Considerations, Modifying Data

Querying Full-Text Indexes

Introduction to Microsoft Search Service, Microsoft Search Service Components, Getting Information About Full-Text Indexes, Writing Full-Text Queries, Querying Full-Text Indexes

Introduction to Programming Objects

Displaying the text of a programming object, Introduction to Views, Advantages of Views, Creating Views, Introduction to Stored Procedures, Introduction to Triggers, Introduction to User-defined Functions Working with Views

Top

Implementing & Managing Exchange 2000

The goal of this course is to train delegates in the knowledge and skills necessary to install, configure, and administer Exchange 2000.

The course is intended for IT professionals who will administer Exchange 2000 organizations.

A working knowledge of Windows 2000 is required. Knowledge of Exchange Server 5.5 is beneficial but not essential.

This course will help delegates prepare for the Microsoft Certified Professional exam: 70-224, Installing, Configuring, and Administering Exchange 2000 Server.

Duration: 5 days

Introduction to Exchange 2000

Exchange 2000 versions, Integration with Windows 2000 Administrative Capabilities, Message Routing Capabilities, User Capabilities, Developer Capabilities.

Installing Exchange 2000

Exchange and Windows 2000, Preparing to Install Exchange 2000, Installing Exchange 2000, Default File Locations and Share-Point Permissions, Troubleshooting Installation Options.

Administering Exchange 2000

Introduction to Administrative Utilities, Introduction to Exchange System Manager, Managing Administrative Security, Creating and Configuring Administrative Groups, Using Exchange 2000 System Policies, Administering Exchange 2000 Address Lists.,

Creating and Managing Storage Groups and Stores

Storage Groups ESE Features of Exchange 2000, Creating Storage Groups, Creating Stores, Managing Storage Groups and Stores.

Creating and Managing Recipient Objects

Creating Recipient Objects, Configuring Recipient Objects, Managing Recipient Objects, Making Bulk Changes to the Directory Configuring Policies.

Creating and Managing Public Folders

Introduction to Public Folders, Configuring Public Folder Permissions, Managing Public Folder Replication, Replicating Public Folders, Setting Public Store Policies.

SMTP in Exchange 2000

Introduction to SMTP, Configuring multiple SMTP Domain Names, Configuring an SMTP virtual server, Configuring an SMTP connector, Troubleshooting SMTP connectivity. 

Message Routing in Exchange 2000

Message Routing and Routing Groups, Connecting Routing Groups, Determining Link Status, Routing Messages, Message Flow in  Exchange 2000, Message Flow Architecture; Working with Failed Links; Message Tracking.

Configuring Internet Protocols

IIS Integration with Exchange 2000, Examining Client Connectivity and Security, Kerberos Authentication, Front-End/Back-End Server Configuration and Security, Configuring NNTP Services, Troubleshooting Client Connectivity by Using Telnet,

Accessing Exchange 2000 with Outlook

Web Access, Examining Outlook Web Access, Components and Process, Configuring an HTTP Virtual Server, Securing Outlook Web Access Communication.

Configuring Instant Messaging

Introduction to Instant Messaging, Basics of Instant Messaging, Instant Messaging Terminology, Instant Messaging Components, Installing and Configuring Instant Messaging.

Instant Messaging Operations and Considerations

Best Practices

Monitoring Microsoft 2000

Tools for Monitoring Exchange 2000, Monitoring Exchange 2000 by Using The Performance Console, Monitoring Exchange 2000 by Using Monitoring and Status Logging and Viewing Diagnostic Data.

Top

Exchange Server 5.5 Administration

This course is designed for support/administration staff who will be responsible for managing one or more Exchange servers. The course covers a number of concepts, backed up with many practical exercises.

Duration: 3 days

Introduction to Exchange Server Admin

Exchange Server Administrator program Permission contexts and permission flow Windows NT Server administration tools

Creating and Managing Recipients

Types of recipient objects Creating mailboxes Configuring recipient object properties Creating and configuring custom recipients Creating and configuring distribution lists Importing and exporting data from the directory Managing recipient objects Creating and configuring Address Book views

Managing Site Configuration

Introduction to the Site Configuration container Configuring site containers Configuring site objects Introduction to Message Journaling

Managing Server Configuration

Introduction to Server Configuration objects, Configuring the Server container

Creating and Managing Public Folders

Introduction to public folders, Developing a public-folder strategy, Setting permissions on public folders, Access to public folders, Configuring Site and Server object properties, Collaboration features

Configuring Microsoft Outlook

Location of Outlook, configuration information, Introduction to Outlook configuration, Introduction to Windows NT system policies, Configuring the transport, Additional configuration options.

Top

Top