Microsoft Exchange Server 2007 Implementation And Maintenance - I.T.T.T.C

Microsoft Exchange Server 2007 Implementation and MaintenanceChapter 1Exchange Server 2007 Deployment1.1Overview, Hardware & Editions1.2Exchange Server, Windows & Active Directory1.3Administration Tools1.4Messaging Roles1.5Exchange Server Roles & Active Directory1.6Exchange Server & Existing Exchange OrganizationsChapter 2Managing Exchange Server 2007 Clients & Mobile Messaging Users2.1Mail Clients2.2Managing Exchange Server Service in Outlook 20072.3Mail Profiles2.4Mobile Messaging Users2.5Mobile Device & Wireless Access2.6Remote Mail and Outlook AnywhereChapter 3Exchange Server 2007 Administration & Exchange Management Shell3.1Exchange Server 2007 Organizations3.2Data Storage3.3Message Queues3.4Exchange Management Shell3.5CmdletsChapter 4User, Contact, Mailbox Administration, Groups & Address Lists4.1User and Contact Administration4.2Managing User Accounts and Mail Features4.3Mailbox Administration4.4Distribution Groups and Address Lists1

Chapter 5Exchange Server 2007 Security & Data Storage Groups5.1Exchange Server 2007 Security5.2Exchange Administrator Permissions5.3Auditing5.4Information Store5.5Content IndexingChapter 6Mailbox & Public Folder Database Administration6.1Mailbox and Public Folder Database Administration6.2Public Folder Databases & Managing Databases6.3Managed Folders and Managed Records6.4Accessing and Managing Public FoldersChapter 7Managing Transport Servers and Client Access Servers7.1Managing Hub Transport and Edge Transport Servers7.2Completing Transport Server Setup7.3Managing Message Pickup and Replay7.4Managing Accepted Domains & Email Policies7.5Remote Domains, Antispam & Message Filtering Options7.6Managing Client Access Servers7.7Enabling POP3 and IMAP4 & Deploying Outlook Anywhere7.8Managing Exchange Server Features for Mobile DevicesChapter 8Exchange Server 2007 Maintenance, Backup & Restore8.1Troubleshooting, Logging & Tracking8.2Monitoring Events, Services, Servers, and Resource Usage8.3Exchange Queues8.4Backing Up and Restoring Exchange Server 20078.5Recovering Exchange Server & Restoring Mailboxes2

Chapter-9Exchange Server 2007 Clustering9.1Clustering Overview9.2Single Copy Clusters9.3Clustered Continuous Replication Clusters9.4High Availability & Server AvailabilityExchange Server 2007 LabsLab-0Installing Exchange Server 2007Lab-1Exchange Server 2007 Maintenance ModeLab-2Exchange Management Console OverviewLab-3Windows PowerShell OverviewLab-4Exchange Management Shell OverviewLab-5Microsoft Exchange Security GroupsLab-6Modify Configuration Domain Controller & Recipient ScopeLab-7Event Viewer Logs & Exchange ServicesLab-8Recipient Configuration Node (User Mail Box)Lab-9Recipient Configuration Node (Room Mail Box)Lab-10Recipient Configuration Node (Equipment Mail Box)Lab-11Recipient Configuration Node (Link Mail Box)Lab-12Recipient Configuration Node (Mail Contact)Lab-13Recipient Configuration Node (Mail User)Lab-14Distribution & Dynamic Distribution GroupsLab-15Recipient Configuration ReviewLab-16Server Configuration (Mailbox Role)Lab-17Mailbox Role : Mailbox & Public Folder DatabaseLab-18Server Configuration (Client Access Role)Lab-19Server Configuration (Hub Transport Role)Lab-20Creating a New SMTP Receive ConnectorLab-21Add New Exchange Administrator RoleLab-22Configuring Service StartupLab-23Creating a New Address ListsLab-24Managed Default FoldersLab-25Managed Custom Folders3

Lab-26Managed Folder Mailbox PoliciesLab-27Offline Address BookLab-28Assigning Advanced Exchange Server PermissionsLab-29Auditing Exchange Server UsageLab-30Hub Transport: Remote DomainsLab-31Hub Transport: Accepted DomainsLab-32Hub Transport: Email Address PoliciesLab-33Hub Transport: Transport RulesLab-34Hub Transport: JournalingLab-35Hub Transport: Send ConnectorsLab-36Hub Transport: Edge SubscriptionsLab-37Exchange Server 2007 Performance CountersLab-38Mail Client: Outlook 2007 Online HelpLab-39Mail Client: Outlook 2007 OverviewLab-40Mail Client: Outlook 2007 DetailsLab-41Mail Client: Outlook 2007 Web SiteLab-42Toolbox: Best Practice AnalyzerLab-43Toolbox: Database Recovery ManagementLab-44Toolbox: Database TroubleshooterLab-45Toolbox: Mail Flow TroubleshooterLab-46Toolbox: Message TrackingLab-47Toolbox: Queue ViewerLab-48Toolbox: Performance TroubleshooterLab-49Tools Web SiteLab-50Exchange 2007 File PathsLab-51Exchange Server 2007 Backup & RestoreLab-52Exchange Setup ParametersLab-53Office Outlook Web AccessLab-54Creating Multiple Storage GroupsLab-55Enabling & Verifying LCRLab-56PowerShell Scripts, Properties & CommandsLab-57Unified Messaging: Configuring Dial PlansLab-58Unified Messaging: Configuring IP GatewaysLab-59Unified Messaging: Configuring Mailbox PoliciesLab-60Unified Messaging: Configuring Auto Attendants4

SQL Server 2005 Implementation and MaintenanceChapter 0Introduction to RDBM & SQL0.1Database Basics0.2SQL Basics Part I0.3SQL Basics Part IIChapter 1Installing Microsoft SQL Server 20051.1Introduction to SQL Server 20051.2Prerequisites1.3Preparing to Install1.4Upgrading from a Previous version1.5Installing SQL Server 20051.6Relational Database Concepts1.7SQL Server Management StudioChapter 2Creating and Configuring Databases2.1Planning your database2.2Filegroups2.3Database File Placement2.4Creating Data Storage Structures2.5Estimating Storage Requirements2.6Creating and Configuring DatabasesChapter 3Working with Tables and Views3.1Planning Tables3.2Introducing Built-in Data Types3.3Creating Tables3.4Restricting the Data3.5Partitioning Tables3.6Understanding Views5

Chapter 4Performing Indexing and Full-Text Searching4.1Index Architecture4.2Clustered Indexes4.3Non-Clustered Indexes4.4Indexes, Primary Keys & Full Text SearchingChapter 5Introducing More Database Objects5.1Stored Procedures5.2Triggers5.3Event Notifications5.4Functions5.5User Defined TypesChapter 6Implementing Security in SQL Server 20056.1SQL Server Security Modes6.2SQL Server Logins & Fixed Server Roles6.3Creating Database User Accounts6.4Permissions & Permission States6.5Database Roles6.6Ownership Chains6.7Linked Server Security6.8Encryption & Security PlanChapter 7Working with Relational Data7.1Transactions7.2Populating Tables7.3Bulk Inserting XML & Bulk-Logged Recovery Model7.4Supporting Different Collation Types and Orders When Querying Data7.5Casting and Converting7.6Datatype Precedence & Collations7.7Error Handling6

Chapter 8Working with XML Data8.1XML Data, Datatypes & XML Schema8.2Querying XML Data8.3Creating XML IndexesChapter 9Working with Service Broker and HTTP9.1Service Broker9.2Working with Service Broker9.3Using Service Broker9.4HTTP EndpointsChapter 10Maintaining and Automating SQL Server10.1Maintaining Indexes10.2Maintaining Statistics10.3Maintaining Databases10.4Automation Basics10.5Configuring Database Mail10.6Creating Operators & Jobs10.7Creating Alerts10.8Maintenance Plan Wizard & Copying DatabasesChapter 11Performing Backups and Restores11.1Backup a Database11.2Restoring a Database11.3Devising a Backup StrategyChapter 12Achieving High Availability through Replication12.1Introducing Replication12.2Introducing the Publisher Subscriber Metaphor12.3Replication Factors and Distribution12.4Replication Internals7

12.5Replication Types12.6Publication & Distributor Issues12.7Replication Models12.8Replicating over the Internet and to Heterogeneous Database Servers12.9Installing, Using & Managing ReplicationChapter 13Introducing More High-Availability Methods13.1Choosing the High-Availability Features You Need13.2Database Mirroring Overview13.3Database Mirroring Implementation13.4Log Shipping13.5Database SnapshotsChapter 14Monitoring and Optimizing SQL Server 200514.1System Monitor14.2SQL Profiler & Database Engine Tuning Advisor14.3Troubleshooting SQL Server70-431 SQL Server 2005 LabsSection-1 LabsLab 1.1Installing SQL Server 2005Lab 1.2Installing SQL Server 2005 Service Pack 2Lab 1.3SQL Server Management Studio OverviewLab 1.4Installing the 2nd InstanceLab 1.5Exploring the SQL Server Management StudioLab 1.6Creating TablesSection-2 LabsLab 2.1Creating a Database using Management StudioLab 2.2Gathering Information about your Database8

Lab 2.3Setting Database OptionsSection-3 LabsLab 3.1Creating the Products TableLab 3.2Creating the Customers TableLab 3.3Creating the Orders TableLab 3.4Creating the Valid Zip Code ConstraintLab 3.5Testing your ConstraintLab 3.6Creating Default ConstraintLab 3.7Creating a Unique ConstraintLab 3.8Creating a Partition Function and SchemaLab 3.9Creating the Contact in 398 ViewLab 3.10Creating an Updatable ViewSection-4 LabsLab 4.1Creating a Table ScanLab 4.2Creating an IndexLab 4.3Creating a Primary KeyLab 4.4Creating a Full-Text Catalog & IndexSection-5 LabsLab 5.1Viewing System Stored Procedures in Object ExplorerLab 5.2Using Predefined TemplatesLab 5.3Creating a Simple Stored ProcedureLab 5.4Creating a DDL TriggerLab 5.5Creating a Scalar User-Defined FunctionLab 5.6Creating a T-SQL User-Defined TypeSection-6 LabsLab 6.1Setting the Authentication ModeLab 6.2Creating Standard LoginsLab 6.3Creating Windows Accounts9

Lab 6.4Creating SQL Server Logins for Windows AccountsLab 6.5Testing SQL Server Logins for Windows AccountsLab 6.6Adding Logins to Fixed Server RolesLab 6.7Creating User Accounts in AdventureWorksLab 6.8Statement and Object PermissionsLab 6.9Adding Users to Fixed Database RolesLab 6.10Creating and Adding Users to Custom Database RolesLab 6.11Creating an Application RoleSection-7 LabsLab 7.1bcp & sqlcmd parametersLab 7.2Bulk-Logged Recovery ModelLab 7.3TRY CATCH BlockSection-8 LabsLab 8.1Reconstructing an IndexLab 8.2Updating Index StatisticsLab 8.3Using DBCC CHECKDB on AdventureWorksLab 8.4Shrinking the DatabaseLab 8.5Configuring a MailhostLab 8.6Configuring the SQL Server Agent to Use the MailhostLab 8.7Configuring an OperatorLab 8.8Creating a Fail-Safe OperatorLab 8.9Creating a JobLab 8.10Creating an Alert for a Standard ErrorLab 8.11Testing an Alert with RAISEERROR()Lab 8.12Creating and Firing an Alert Based on a Custom ErrorLab 8.13Creating a Performance AlertLab 8.14Creating a WMI AlertLab 8.15Maintenance Plan WizardLab 8.16Copy Database Wizard10

Section-9 LabsLab 9.1Creating a Permanent Backup DeviceLab 9.2Performing a Full BackupLab 9.3Performing a Differential BackupLab 9.4Performing a Transaction Log BackupLab 9.5Performing a Filegroup BackupLab 9.6Backing Up to Multiple DevicesLab 9.7Restoring a DatabaseSection-10 LabsLab 10.1Installing a Distribution ServerLab 10.2Creating a PublicationLab 10.3Creating a SubscriptionLab 10.4Replication MonitorSection-11 LabsLab 11.1System MonitorLab 11.2Creating a Trace with ProfilerLab 11.3Replaying a TraceLab 11.4Database Engine Tuning AdvisorLab 11.5Reading SQL Server & Windows Event LogsLab 11.6Activity MonitorLab 11.7Connecting to the DAC11

Installing and Configuring ISA Server 2004/2006Chapter 0ISA Server 2004 ON-LINE HELP0.1ISA Server 2004 ON-LINE HELP0.2ISA Server 2004 Web SiteChapter 1ISA Server 2004 Overview1.1ISA Server Capabilities & Operation1.2ISA Server 2004 Editions and System Requirements1.3ISA Server Tools and Remote Administration1.4ISA Server as a Firewall1.5Comparing ISA 2004 to Other Firewall Products1.6ISA Server Deployment ScenariosChapter 2Installing and Configuring ISA Server 2004 Standard2.1Installing & Configuring ISA Server 2004 Std. Edition2.2Understanding Caching ConceptsChapter 3ISA Server 2004 Clients3.1Overview of ISA Server 2004 Client Types3.2ISA Server 2004 Client Types3.3Using Infrastructure ServersChapter 4Upgrading from ISA Server 20004.1Upgrading ISA Server 20044.2Troubleshooting ISA Server Upgrades12