Duration: 1 Day / 2 Evenings

Overview
In this course, students will learn how to automate common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications.

Who Should Attend
This course was designed for students who want to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, create PivotTables and PivotCharts, incorporate multiple data sources, and import and export data. In addition, the course is also for students preparing for the Microsoft Office Specialist exam in Excel 2003 or Module 2-Key Applications of the Internet and Computing Core Certification (IC3) exam, and who already have knowledge of the basics of Excel – including how to create, edit, format, and print worksheets that include charts and sorted and filtered data.

At Course Completion
You will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications.

Course Outline

• Lesson 1: Streamlining Workflow
• Lesson 2: Collaborating with Others
• Lesson 3: Auditing Worksheets
• Lesson 4: Analyzing Data
• Lesson 5: Working with Multiple Workbooks
• Lesson 6: Importing and Exporting Data
• Lesson 7: Structuring XML Workbooks

Pre-requisite(s)

• Excel 2003 - Level 1
• Excel 2003 - Level 2

 Print this page

Duration: 5 Days Instructor-Led

This five-day instructor-led course provides students with the product knowledge and skills needed to maintain a Microsoft SQL Server 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to maintaining a database.

After completing this course, students will be able to:

• Install and configure SQL Server 2005
• Manage database files
• Manage security
• Perform administrative tasks
• Back up databases
• Restore databases
• Monitor SQL Server
• Troubleshoot SQL Server
• Transfer data
• Maintain high availability

Prerequisites

• Basic knowledge of the Microsoft Windows operating system and its core functionality
• Working knowledge of Transact-SQL
• Working knowledge of relational databases
• Some experience with database design. In addition, it is recommended, but not required, that students have completed:
  • Course 2778: Writing Queries Using Microsoft SQL Server 2005 Transact-SQL
  • Course 2779: Implementing a Microsoft SQL Server 2005 Database

Course Outline
Module 1: Installing and Configuring SQL Server 2005
Module 2: Managing Databases and Files
Module 3: Disaster Recovery
Module 4: Managing Security
Module 5: Monitoring SQL Server
Module 6: Transferring Data
Module 7: Automating Administrative Tasks
Module 8: Maintaining High Availability
Module 9: Introduction to Replication

 Print this page

Microsoft
MS 2780 Maintaining a Microsoft SQL Server 2005 Database
MS 2400 Implementing and Managing Microsoft Exchange Server 2003
MS 2840 Implementing Security for Applications
MS 2310 Developing MS ASP.NET Web Applications using Visual Studio.NET

Business Development
Business Analyst Fundamentals
Developing Requirements with Use Cases

Cisco
CCNA Exploration v4.0 - Parts I & II

Security
Certified Information Systems Security Professional (CISSP)

Oracle
Oracle Fundamentals
Oracle Database 10g: Introduction to SQL

CompTIA
CompTIA A+ Essentials 2006
CompTIA A+ 220-602 2006

UNIX
UNIX Administration

 Print this page

Microsoft Server
MS 2273 - Managing and Maintaining a Microsoft Windows Server 2003 Environment
MS 2279 - Planning, Implementing, and Maintaining a Microsoft Windows Server 2003 Active Directory Infrastructure

Microsoft .Net
MS 2310 - Developing MS ASP.NET Web Applications using Visual Studio.NET
MS 2524 - Developing XML Web Services Using Microsoft ASP.NET

Oracle
Oracle Database 10g: Administration Workshop II
Oracle Database 10g: Introduction to SQL
Oracle Database 10g: Data Guard Administration
Oracle Database 10g: Security Release 2
Oracle Database 10g: Performance Tuning

Cisco
Networking Fundamentals

UNIX / Linux
Unix Shell Scripting

Business Development
Defining Business Systems with UML

CompTIA
Server +

Citrix
Citrix Presentation Server v 4.5 Admin & Support

 Print this page

Report Writing
Crystal Reports - Quick Start

Microsoft SQL
2780 Maintaining a Microsoft SQL Server 2005 Database

Business Development
Business Analysis Fundamentals
Dev. Requirements with Use Cases

Microsoft Office 2K3
Excel 2003, Level 1
Excel 2003, Level 3
Access 2003, Level 1

 Print this page

Microsoft Server
MS 2273 - Managing and Maintaining a Microsoft Windows Server 2003 Environment
MS 2277 - Implementing, Managing, and Maintaining a Microsoft Windows Server 2003 Network Infrastructure: Network Services

Oracle
Oracle Fundamentals
Oracle Database 10g: SQL Tuning Workshop
Oracle Database 10g: Program with PL/SQL
Oracle Database 10g: Administration Workshop I

Security
Certified Information Systems Security Professional (CISSP)

UNIX / Linux
RH Linux Administration
UNIX Administration

ITIL
ITIL Foundation Level 1 Certification
ITIL 3.0 - Foundation for IT Service Management

Report Writing
Crystal Reports - Power User

Microsoft Office 2003
Microsoft Access 2003: Level 1

 Print this page

Overview
Students will learn the basic skills necessary to understand the structure of the UNIX operating system and to use the available utilities and commands to manage their personal file structures in the UNIX C Shell.

Course Content

• Unix Structure
• Getting Started
• Unix Command Line Structure
• System Resources & Printing
• Shells
• Special Unix Features
• Text Processing
• Other Useful Commands
• Shell Programming
• Editors
• Unix Command Summary