Target Audience
The target students for this course are students who desire to gain the skills necessary to create templates, sort and filter data, import and export data, analyze data, and work with Excel on the Web. In addition, this course helps prepare students who desire to prepare for the Microsoft Office Specialist exam in Excel or Module 2 and who already have knowledge of the basics of Excel, including how to create, edit, format, and print basic worksheets.

At Course Completion
You will apply visual elements and advanced formulas to a worksheet to display data in various formats.

Course Outline
Lesson 1: Creating and Applying Templates
Lesson 2: Creating and Modifying Charts
Lesson 3: Working with Graphic Objects
Lesson 4: Calculating with Advanced Formulas
Lesson 5: Sorting and Filtering Data
Lesson 6: Using Excel with the Web

Prerequisite
Excel 2003 - Level 1

Note: There is a print link embedded within this post, please visit this post to print it.

In this course, you will use Microsoft® Office Excel 2003 to manage, edit, and print data.

Target Audience
This course is designed for persons preparing for certification as a Microsoft Office Specialist in Excel, who already have knowledge of the Microsoft Office Windows 98 (or above) operating system, and who desire to gain the skills necessary to create, edit, format and print basic Microsoft® Office Excel 2003 worksheets.

At Course Completion
You will create and edit basic Microsoft Office Excel worksheets and workbooks.

Course Outline
Lesson 1: Getting Started with Excel
Lesson 2: Modifying a Worksheet
Lesson 3: Performing Calculations
Lesson 4: Formatting a Worksheet
Lesson 5: Developing a Workbook
Lesson 6: Printing Workbook Contents
Lesson 7: Customizing Layout

Prerequisite:
Windows XP (New Version) - Level 1

Note: There is a print link embedded within this post, please visit this post to print it.

This course delves into the unique challenges of managing projects, and offers a roadmap to success. It was designed to address the skills inventory and performance outcomes that you need to be successful in today’s volatile environment.

Prerequisite
None

Target Audience
IT and Non IT Professionals

Course Objectives
• Gain a solid foundation in PMI’s Project Management Framework.
• Skills development and tool/technique utilization critical for IT Project success
• Acquire the skills to use the best emerging, cutting edge IT Project Management tools and techniques for IT Projet Success
• Use the Project Framework to effectively and immediately gain control of your projects

Course Materials
Developing & Implementing IT Project Management Techniques course manual
Project +: Study Guide by William Heldman and Lona Cram

Course Outline
I. What can project management do for me?
Project management is the application of knowledge, skills, tools and techniques to project activities to meet project requirements. Learn why it is so critical to perform this task effectively.

II. Challenges of Managing Projects
There are many challenges unique to managing projects, including competing technical and business demands, seemingly endless business reengineering and increased responsibility and accountability created through downsizing, outsourcing and increased accountability. What can you do about it?

III. Initiating the Project
A good start is integral to the success of any project. Get off on the right foot by aligning with the appropriate strategy and getting buy-in from the right people.

IV. Project planning
The actual plan is the essential tool to success; without it you have nothing. Learn to integrate the scope, resource management, risk, quality, cost, procurement, schedule, and communications plan into your day-to-day realities.

V. Estimating Project Costs and Schedules
Even with a good plan, competing demands inevitably pull the project manager in many directions. Arm yourself with tools to make these challenging situations easier.

VI. Execution - Putting the Plan in Motion
Getting it done is a success. It can be a challenge to work the plan and handle curveballs. Learn to manage your team and the plan to accomplish your goals.

VII. Taking Control of the Project
Changes, challenges and the unexplained inevitably creep into projects. Learn how you can control their effect on your project.

VIII. Completing the Project On Time/On Budget
At the end of any job, look back and see what you could do better next time.
But - most importantly, celebrate the end of the project.

IX. Next Steps to Grow as a Project Manager
So you want to do more…

X. Project + Certification Knowledge areas

XI. Project + Test Prep

XII. Tips and Tricks

Note: There is a print link embedded within this post, please visit this post to print it.

This five-day instructor-led class provides students with a thorough grounding in Microsoft .NET security implementation and general development security best practices. This course will prepare a student to take the Implementing Security for Applications exam (available in Microsoft Visual Basic .NET 70-330 and Microsoft Visual C# 70-340).

Target Audience
This course is intended for experienced, professional application developers, including those employed by software companies or working on corporate development teams.

Prerequisites
Before attending this course, students:

• Should have a minimum of 1 year of experience using Microsoft Visual Studio .NET 2003 (.NET Framework 1.1) and 23 years of additional development experience.
• Should be experienced in either Visual Basic .NET or Visual C#.

Microsoft Certification exams
This course will help the student prepare for the following Microsoft Certification exams:

• Exam 70-330: Implementing Security for Applications with Microsoft Visual Basic .NET
• Exam 70-340: Implementing Security for Applications with Microsoft Visual C# .NET

Course Materials
The student kit includes a comprehensive workbook and other necessary materials for this class.

Course Outline
Module 1: Overview of Application Security
Module 2: Implementing Platform Security Best Practices
Module 3: Implementing Coding Security Best Practices
Module 4: Using .NET Framework Security Features
Module 5: Implementing Role-based Security
Module 6: Implementing Code-Access Security
Module 7: Implementing Cryptography in .NET
Module 8: Securing ASP.NET Applications
Module 9: Securing Remote .NET Applications
Module 10: Configuring .NET Security
Module 11: Implementing Security Testing
Module 12: Deploying Applications with Security

Note: There is a print link embedded within this post, please visit this post to print it.

He presently maintains the following certifications: CISSP, CISA, MCSE, MCT, CTT+, A+, N+, Security+, CNA, CCNA, CIW Security Analyst, CCE, CEH, CHFI, CEI, DCNP, ES Dragon IDS, ES Advanced Dragon IDS, and TICSA.

He has consulted and led assessment activities for many organizations including Alaska Communications System, Nortel, Motorola, Adaptec, Lucent, Fidelity, Kaiser Medical, Southwestern Bell Corp, and Federal and State Governmental agencies such as the FBI and DoD.

While consulting consumes a large amount of Michael’s time, he enjoys teaching. Michael has a proven reputation as both a dynamic and influential speaker. His delivery style is considered energetic and entertaining, yet insightful. He focuses on real-life examples and uses analogies to meet his learning objectives. Michael has spoken at major security, technology, and educational conferences including ISC2’s Security Leadership Conference, ISACA’s Training Conference, TAET Educational Conference, Government Technology Conference (GTC), and DataMark’s Security Conference.

Books authored or co-authored by Michael Gregg include, Que CISSP Exam Cram Questions, Que CISSP Exam Cram 2, Sam’s Inside Network Security Assessment, Que CEH Exam Prep 2, Syngress Hack the Stack, Sybex Security Administrators Street Smarts, Syngress Emerging Threat Analysis 2006, Syngress CHFI Study Guide, Que CISA Exam Prep 2, Syngress Security + Study Guide, Syngress Open Source Security Tools, Syngress Emerging Threat Analysis 2008, and Wiley’s How to Build Your Own Network Security Lab.

Michael has also led the development of more than 15 training classes and courses used by training vendors, developers, colleges, and universities such as: Advanced Security Boot Camp, Ethical Hacking, Professional Hacking Boot Camp, Inside Risk Assessment, Introduction to Network Security, Mastering Security, and Advanced Security Concepts. He is also an Expert Q&A for TechTarget.com web sites including SearchNetworking, SearchMobilNetworking, and SearchSMB. He answers questions from inquisitive readers. He also serves on the TechTarget Editorial Board of Advisors.

He is a member of the American College of Forensic Examiners, the Independent Computer Consulting Association, and the Texas Association for Educational Technology. Michael enjoys giving back to the community and as for his most recent community project; he served as an unpaid consultant to help develop the first certification program for the AISD High School.

Duration:
Classroom: 40 hours / 5 Days (mandatory)
Additional Lab Work: 60 hours (extra-curriculum)

Introduction
Cisco Certified Network Associate - CCNA Exploration will be delivered in two segments:

Parts I & II
- Network Fundamentals
- Routing Protocols and Concepts

Parts III & IV
- LAN Switching and Wireless
- Accessing the WAN

The complete curriculum provides the student with the skills necessary to succeed in networking-related jobs and services and help them prepare for the CCNA certification. It also help students to fulfil job responsibilities of network technicians, network administrators, and network engineers.

Overview
This course provides a comprehensive, theoretical and practical approach to learning the technologies and protocols needed to design and implement a converged switched network. Students learn about the hierarchical network design model and how to select devices for each layer. The course explains how to configure a switch for basic functionality and how to implement Virtual LANs, VTP and Inter-VLAN routing in a converged network. The different implementations of Spanning Tree Protocol in a converged network are presented, and students develop the knowledge and skills necessary to implement a WLAN in a smallto- medium network.

The course also discusses the WAN technologies and network services required by converged applications in enterprise networks. The course uses the Cisco Network Architecture to introduce integrated network services and explains how to select the appropriate devices and technologies to meet network requirements. Students learn how to implement and configure common data link protocols and how to apply WAN security concepts, principles of traffic, access control and addressing services. Finally, students learn how to detect, troubleshoot and correct common enterprise network implementation issues.

Prerequisites
ICND Part I (Interconnecting Cisco Network Devices, Part I)
- Network Fundamentals,
- Routing Protocols and Concepts

Target Audience
Junior IT professionals with who need to develop advanced network problem-solving and analytical skills.

Course Content

• LAN Design
• Basic Switch Concepts and Configuration
• VLANs
• VTP
• STP
• Inter-VLAN Routing
• Basic Wireless Concepts and Configuration
• Introduction to WANs
• PPP
• Frame Relay
• Network Security
• ACLs
• Teleworker Services
• IP Addressing Services
• Network Troubleshooting

Note: There is a print link embedded within this post, please visit this post to print it.

Duration:
Classroom: 40 hours / 5 Days (mandatory)
Additional Lab Work: 60 hours (extra-curriculum)

Introduction
Cisco Certified Network Associate - CCNA Exploration will be delivered in two segments:

Parts I & II
- Network Fundamentals
- Routing Protocols and Concepts

Parts III & IV
- LAN Switching and Wireless
- Accessing the WAN

The complete curriculum provides the student with the skills necessary to succeed in networking-related jobs and services and help them prepare for the CCNA certification. It also help students to fulfil job responsibilities of network technicians, network administrators, and network engineers.

Overview
This course introduces the architecture, structure, functions, components and models of the internet and other computer networks. It uses the OSI and TCP layered models to examine the nature and roles of protocols and services at the application, network, data link and physical layers. The principles and structure of IP addressing and the fundamentals of Ethernet concepts, media, and operations are introduced to provide a foundation for the curriculum. Labs use a model internet to allow students to analyze real data without effecting production networks. Packet Tracer (PT) activities help students analyze protocol and network operation and build small networks in a simulated environment. At the end of the course, students build simple LAN topologies by applying basic principles of cabling, performing basic configuration of network devices such as routers and switches, and implementing IP addressing
schemes.

The course also describes the architecture, components, and operations of routers, and explains the principles of routing and routing protocols. Students analyze, configure, verify, and troubleshoot the primary routing protocols RIPv1, RIPv2, EIGRP and OSPF. By the end of this course, students will be able to recognize and correct common routing issues and problems. Students complete a basic procedural lab, followed by basic configuration, implementation, and troubleshooting labs in each chapter. Packet Tracer activities reinforce new concepts, and allow students to model and analyze routing processes that may be difficult to visualize or understand.

Prerequisites
None

Target Audience
Junior IT professionals with who need to develop advanced network problem-solving and analytical skills.

Course Content

• Living in a Network-Centric World
• Communicating over the Internet
• Application Layer Functionality and Protocols
• OSI Transport Layer
• OSI Network Layer
• Addressing the Networks Ipv4
• Data Link Layer
• OSI Physical Layer
• Ethernet
• Planning and Cabling Networks
• Configuring and Testing your Network
• Introduction to Routing and Packet Forwarding
• Static Routing
• Introduction to Dynamic Routing Protocols
• Distance Vector Routing Protocols
• RIP Version 1
• VLSM and CIDR
• RIPv2
• The Routing Table: A Closer Look
• EIGRP
• Link-State Routing Protocols
• OSPF

Note: There is a print link embedded within this post, please visit this post to print it.

Those who perform business analysis functions in organizations provide an essential function by capturing the requirements for a project, designing the solutions, and ensuring the defined scope meets the customer’s needs, goals and objectives. This practical introduction will provide participants with proven analysis tools and techniques, including methods to define the problem using a systematic approach, analyze the business process, and create a conceptual solution that is applicable in virtually any software environment. This repeatable framework will ensure your requirements are consistently complete and accurate. Pragmatic solutions to keep the customer involved in the process include facilitation, questioning, listening, business need identification, communication, culture analysis, stakeholder engagement, problem solving, and presentation of the most feasible solution.

Target Audience
Business Analyst, Business Systems Analyst, Systems Analyst, Project Manager, Systems Architect or Designer, Systems or Application Developer, Systems Tester, Leader of systems project or team, Change Agents & Change Management team members.

Course Objectives

• Comprehend the shifting role of a Business Analyst
• Define your business and systems processes
• Select the appropriate model for your process, choosing the right technique for your type of system
• Identify the scope of the project
• Understand, analyze, and articulate the as-built and future-state system
• Target your analysis and understand the consequence of the solutions
• Gather required information through multiple methods
• Conduct efficient interviews
• Ask targeted questions to discover the root causes, not just symptoms
• Conduct effective sessions to capture and verify requirements
• Improve the quality of the requirements elicited
• Use consistent documentation based on industry best practices
• Present clear, unambiguous potential solutions to real business needs
• Use visual representations of the business process, workflows, and data models to ensure clarity
• Improve communication skills through hands-on practice e clarity
• Apply analysis techniques to any methodology or data modeling
• Bridge the communication gap between business people and technology solution providers
• Understanding business culture and how this can impact the success of the project

Course Outline
• The Business Case for Business Analysis
• Introduction to Business Analysis
• Project Initiation
• Understand the System
• Analyzing Existing System Components
• Defining Future State Components and Process Details
• Writing Requirements for the Future State

Note: There is a print link embedded within this post, please visit this post to print it.

Get project requirements right the first time, every time, using these state-of-the-art techniques!

Ensure that scope is under control from the outset — even on complex projects. Prevent expensive errors and omissions in requirements with a proven approach and methodology. Practice real-world tools and techniques for immediate application.

Target Audience
If you’re involved at all in defining and managing systems development projects, you will find this workshop invaluable:
• Business customer, user or partner
• IT Manager or Director
• Business Analyst
• Developer or Programmer
• Business Systems Analyst
• QA Manager or Director
• Systems Analyst
• Project Manager
• Architect or Designer
• Systems or Application Developer
• Systems Tester
• Leader of Systems projects or teams

Course Outline
1. Use Cases and the Requirements Problem
This section presents an overview of the requirements challenges inherent in IT projects and how a use case approach can overcome them.

2. Introduction to Requirements Development with Use Cases
Use cases are one of the best approaches for developing requirements. Here we’ll review key definitions and terms, overview a requirements-management framework and see how use cases fit into the development life cycle.

3. Use Cases and IT Project Initiation
To apply use cases successfully, you should plan for them from the very beginning. This section explores project initiation and its relationship to use cases. In particular, you’ll examine how to define a business problem, identify stakeholders, and determine initial project scope. You’ll also learn about a tool for graphically depicting project scope.

4. How Use Cases Are Developed and Organized
This section of the course will clarify when use cases should be applied, describe the discovery and organization of use cases, examine further the relationship between stakeholders’ requirements and use cases, and provide guidance for how to determine the level of detail appropriate for a project.

5. Requirements Elicitation and Key Elements of Use Cases
Use cases are typically developed as business requirements are elicited and discovered. In this section of the workshop, we examine requirements elicitation, its relation to use case development, and some important tools.

6. Documenting Requirements with Use Cases
This section of the workshop focuses on how to apply the knowledge you’ve gained so far to writing a use case. It also examines more complex aspects of uses cases, including extend relationships and use case linking on larger systems.

7. Improving Functional Requirements and Use Cases
Analysts must know how to organize the use cases and requirements in a Software Requirements Specification and how to assure quality. Here we will apply standards for quality to our use cases and requirements, look at some proven ways to prevent common problems, and explore how to derive maximum benefit from reviews.

8. Use Cases and System Requirements
In this section, we will examine ways to derive system requirements from functional requirements and use cases and how to identify constraints on the solution design. We’ll also explore how use cases not only trace back to requirements, but also how they trace forward through the development life cycle to design and testing.

9. Applying Use Cases on Real Projects
Without application, the learning is merely academic. In the final section, you will discuss how to employ use cases on real IT projects. The capstone of your two-day investment will be an individualized action plan for putting the power of use cases to work on your projects and in your organizational environment.

Note: There is a print link embedded within this post, please visit this post to print it.

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

Target Audience
This course is intended for IT Professionals wanting to become skilled on SQL Server 2005 product features and technologies for implementing a database.

Prerequisites
Before attending this course, students must have:
• 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 Outline
Module 1: Creating Databases and Database Files
Module 2: Creating Data Types and Tables
Module 3: Using XML
Module 4: Creating and Tuning Indexes
Module 5: Implementing Data Integrity
Module 6: Implementing Views
Module 7: Implementing Stored Procedures and Functions
Module 8: Implementing Managed Code in the Database
Module 9: Using Service Broker

Note: There is a print link embedded within this post, please visit this post to print it.