Types of Corporate Training - PDF by lts20110

VIEWS: 57 PAGES: 13

More Info
									                                                                1




                                                                    ◄ Table of Contents




 SetFocus Century Drive, Parsippany, NJ www.setfocus.com
SetFocus ••4Corporate Course Catalog 2010 •• www.setfocus.com
                                                                                                                                                                     2

Table of Contents
   About SetFocus...............................................................................................3
         Corporate Training Solutions ................................................................................................................ 3
         Standard Courses .................................................................................................................................. 3
         FastTrack Courses ................................................................................................................................. 3
         Customized Corporate Training Courses .............................................................................................. 3


   Facility.............................................................................................................4
         Campus Facility .................................................................................................................................... 4
         Classrooms ............................................................................................................................................ 4

   The GRID® .....................................................................................................4

   Rate and Schedules ........................................................................................4

   Course Descriptions .......................................................................................5

   .NET Training.................................................................................................5
         SF6001 - Programming with C# .NET ................................................................................................. 5
         SF6002 - Framework 3.5 New Features & Intro to XML .................................................................... 5
         SF6004 - Developing Windows Forms and WPF applications using VS2008 ..................................... 5
         SF6006 - Writing Queries Using Microsoft SQL Server 2008 Transact-SQL...................................... 5
         SF6007 - Visual Studio 2008: ADO.NET 3.5 and LINQ...................................................................... 6
         SF6009, SF 6010 - Developing Web Applications Using Microsoft Visual Studio 2008 .................... 6
         SF6012 - Windows Communication Foundation Using Visual C# 2008 ............................................. 6




                                                                                                                                                                         ◄ Table of Contents
   SQL Server Training ......................................................................................7
         SF8002- Writing Queries using MS SQL Server 2008 T-SQL ............................................................. 7
         SF8003 - Implementing a Microsoft SQL Server 2008 Database ........................................................ 7
         SF8005 - Advanced SQL Querying and Programming ........................................................................ 7
         SF8014 - SetFocus – Custom Microsoft SQL Server 2008 Integration Services ................................. 7
         SF8015 - SetFocus – Custom Microsoft SQL Server 2008 Reporting Services .................................. 8

   Business Intelligence Training ......................................................................9
         SF9001 - Querying and Programming using MS SQL Server 2008 Transact SQL.............................. 9
         SF9002 - Advanced Querying and Programming using MS SQL Server 2008 Transact SQL............. 9
         SF9003 - Data Warehousing Concepts ................................................................................................. 9
         SF9004 - Microsoft SQL Server 2008 Integration Services ................................................................. 9
         SF9006 - Microsoft SQL Server 2008 Analysis Services ..................................................................... 9
         SF9007 - MDX Queries ...................................................................................................................... 10
         SF9009 - Microsoft SQL Server 2008 Reporting Services................................................................. 10
         SF9010 - Business Intelligence with SharePoint and Performance Point Server ............................... 10

   SharePoint Training .....................................................................................11
         SF7001 - ASP.NET & XML Review ................................................................................................. 11
         SF7002 - SharePoint for Administrators ............................................................................................. 11
         SF7004 - SharePoint for Developers – I ............................................................................................. 11
         SF7006 - Branding & Web Content Management .............................................................................. 11
         SF7008 - SharePoint Business Processes ........................................................................................... 12
         SF7010 - SharePoint Portal Management ........................................................................................... 12




                      This Catalog was prepared on the basis of the best information available at the time of publication.
                       All information, including statements of course descriptions, curriculum, admission and graduation
                    requirements, and financial aid, is subject to revision. SetFocus, therefore, reserves the right to change
                    the requirements and regulations contained in this document with adequate notice and communication.



                                          SetFocus • Corporate Course Catalog 2010 • www.setfocus.com
                                                                                                                                      3

About SetFocus

  Corporate Training Solutions
  Since 1997, SetFocus has been a leader in training individuals and companies on Microsoft technologies globally.

  Working with a network of industry experts, SetFocus identifies areas where IT skill gaps exist, develops relevant training
  programs, and delivers competitively priced, instructor-led classes, employing interactive technology and virtual machine access.



  We offer 3 types of Corporate Training Solutions:
  1.   Standard Courses
  2.   FastTrack Courses
  3.   And Fully Customized Corporate Training Courses




  Standard Courses
  •    These are one and two week courses that focus on .NET, SQL Server, Sharepoint, or Business Intelligence skills
  •    Each class is narrowly focused on a specific skill within those technologies and can be taken from anywhere.



  FastTrack Courses




                                                                                                                                          ◄ Table of Contents
  •    We have put together FastTrack courses that are geared towards new versions of old technologies AND emerging
       technologies
  •    We review our FastTrack courses on a quarterly basis to determine what is most needed in the marketplace
  •    These courses are delivered in the form of seminars, 2 to 3 day courses, or full 1 and 2 week courses.
  •    All courses are delivered from Noon – 6P Eastern time in order to allow attendees to work ½ days while taking the course



  Customized Corporate Training Courses
  •    SetFocus recognizes that not all companies training needs are the same
  •    SetFocus offers customized training courses to meet these challenges.
  •    We will work with you to understand what your company needs and then to design a cost effective training solution that will
       help your team get to the next level




                             SetFocus • Corporate Course Catalog 2010 • www.setfocus.com
                                                                                                                                         4

Facility                                                              The GRID
   SetFocus’ training facility is located in Parsippany, NJ,             The GRID is a seamless, remote attendance, live, face-to-face
approximately 45 minutes outside of New York City. Candidates can     instructor-led training solution.
attend class on site or remotely via The GRID®.                          The GRID uses a combination of high quality audio and video.
                                                                      Candidates attending via The GRID are able to participate in training,
Campus Facility                                                       from a remote location as though they were in a physical classroom.
  The handicap-accessible facility is located in a smoke-free
building at 4 Century Drive, Parsippany, New Jersey.
   The facility has two kitchen areas equipped with a refrigerator,
a microwave, a toaster oven, and vending machines for beverages
and snacks. These facilities are available for attendees to use.

Classrooms
   All classrooms have wireless high-speed internet access, GRID
video-conferencing equipment, and personal computers with high
resolution 19-inch flat panel monitors.




                                                                                                                                               ◄ Table of Contents
                                                                      Rate and Schedules
                                                                        For information on rates and schedules, contact us at
                                                                      corptrainingops@setfocus.com.




                                 SetFocus • Corporate Course Catalog 2010 • www.setfocus.com
.NET | SQL Server | Business Intelligence | SharePoint                                                                                     5

Course Descriptions                                                    Course Length: 40 hours
                                                                       SF6004 - Developing Windows Forms and WPF
                                                                       applications using VS2008
                                                                          Visual Studio 2008 and the .NET Framework 3.5 make it
                                                                       easier than ever to create robust, enterprise-level applications.
.NET Training                                                          You will learn how to build solid applications using structured
                                                                       exception handling, how to use the Visual Studio debugging
                                                                       features, how to use MenuStrip and ToolStrip controls, and how
                                                                       to add unprecedented flexibility to your user interfaces using the
Course Length: 40 hours                                                container controls. As you continue through this course you will
SF6001 - Programming with C# .NET                                      also be introduced to developing Windows Presentation Foundation
   The goal of this course is to provide students with the knowledge   applications.
and skills they need to develop C# applications for the Microsoft
.NET Platform. The course focuses on C# program structure,
language syntax, and implementation details.                           Prerequisites
                                                                       Before attending this course, students are expected to have:
Prerequisites                                                          •    Experience with programming in C#
Before attending this course, students are expected to have:           •    Solid understanding of the Microsoft .NET framework.
•    Experience with programming in C, C++, Visual Basic, Java, or
     another programming language.                                     Modules
•    Familiarity with the Microsoft .NET framework is recommended.     •   Introduction to Windows forms
                                                                       •   Taking advantage of the Form Event Model
Modules                                                                •   Common Windows Forms Controls
•   Overview of the Microsoft .NET platform                            •   Handling Input / Output tasks
•   Overview of .NET                                                   •   Project Settings in Visual Studio 2008
•   Using value-type variables                                         •   Debugging your applications
•   Statements and exceptions                                          •   Container Controls
•   Methods and parameters                                             •   Menus and toolbars
•   Arrays                                                             •   Deploying applications using ClickOnce
•   Essentials of object oriented programming                          •   Introduction to WPF




                                                                                                                                               ◄ Table of Contents
•   Using reference-type variables                                     •   Revisiting WPF
•   Creating and destroying objects
•   Inheritance in .NET
•   Aggregation, Namespaces, and Advanced Scope                        Course Length: 40 hours
•   Properties and Indexers                                            SF6006 - Writing Queries Using Microsoft SQL Server
•   Serialization                                                      2008 Transact-SQL
•   Deployment                                                           This course provides students with the technical skills required to
                                                                       write basic Transact-SQL queries for Microsoft SQL Server 2008.

Course Length: 40 hours                                                Prerequisites
SF6002 - Framework 3.5 New Features & Intro to XML                     Before attending this course, students are expected to have:
   This course dives deep into advanced framework concepts             •    Knowledge of data integrity concepts.
such as generics and the new features that are revolutionizing         •    Relational database design skills.
.NET programming, covering lambda expressions and collection           •    Some Programming skills - recommended.
interfaces. The Intro to XML provides a technological overview of
the structure and programming techniques of XML.                       Modules
                                                                       •   Getting Started with Databases and Transact-SQL in SQL
Prerequisites                                                              Server 2008
Before attending this course, students are expected to have:           •   Querying and Filtering Data
•    Experience with programming in C#                                 •   Grouping and Summarizing Data
•    Solid understanding of the Microsoft .NET framework.              •   Joining Data from Multiple Tables
                                                                       •   Working with Subqueries
Modules                                                                •   Modifying Data in Tables
•   Classes                                                            •   Querying Metadata, XML, and Full-Text Indexes
•   Inheritance                                                        •   Using Programming Objects for Data Retrieval
•   Interfaces                                                         •   Using Advanced Querying Techniques
•   Well-Formed Types
•   Generics
•   Delegates and Lambda Expressions
•   Events
•   Collection Interfaces
•   Building Custom Collections
•   Basic XML
•   Validating XML
                                                                                                                   continued on page 6




                                  SetFocus • Corporate Course Catalog 2010 • www.setfocus.com
.NET | SQL Server | Business Intelligence | SharePoint                                                                                  6
Course Length: 40 hours                                              Course Length: 40 hours
SF6007 - Visual Studio 2008: ADO.NET 3.5 and LINQ                    SF6012 - Windows Communication Foundation Using
   This course provides students with the knowledge and              Visual C# 2008
skills using ADO.NET 3.5 to access and modify data stored in            In this course, you will learn how to use Windows Communication
relational database systems and to access data in                    Foundation (WCF) and you will see how it is a unified programming
non-relational sources.                                              model for building service-oriented distributed applications. You will
                                                                     see how to build, host and call WCF services and you will gain a
Prerequisites                                                        deep understanding of the basic building blocks of WCF, including
Before attending this course, students are expected to have:         endpoints, bindings and contracts. In addition, see how to handle
•    Experience with programming in C#                               exceptions, maintain state between calls to a service and use
•    Solid understanding of the Microsoft .NET framework.            transactions. Subsequent topics include and basics of WCF security,
•    Familiarity with the Visual Studio IDE                          and building WCF services that support Representational State
                                                                     Transfer (REST) and syndication. By the time you have completed
Modules                                                              the course, you will have a good understanding of how to build and
•   Accessing Data with ADO.NET                                      use WCF services in your distributed applications.
•   Retrieving Data
•   Caching Data in DataSets                                         Prerequisites
•   Updating Data                                                    Before attending this course, students are expected to have:
•   Handling Exceptions and Data Errors                              •    Experience with programming in C#
•   Using Strongly Typed DataSet Classes                             •    Solid understanding of the Microsoft .NET framework.
•   LINQ to Objects                                                  •    Knowledge of building Windows and Console applications using
•   LINQ to SQL                                                           Visual Studio
                                                                     •    Familiarity with building and consuming Web Services –
                                                                          recommended
Course Length: 80 hours
SF6009, SF 6010 - Developing Web Applications Using                  Modules
Microsoft Visual Studio 2008                                         •   Introduction to WCF
  This course will teach introductory-level Web developers the       •   Hosting and Calling WCF Services
fundamentals of Web application development and best practices for   •   Bindings and Contracts
Microsoft Web development technologies, including ASP.NET 3.5,       •   Exceptions, Diagnostics and Message Patterns




                                                                                                                                              ◄ Table of Contents
ASP.NET AJAX Extensions and Silverlight. This course focuses on      •   Sessions and Transactions
using the Microsoft Visual Studio 2008 development environment       •   Security
and the Microsoft .NET Framework 3.5 to create a Web application     •   Workflow Services
that delivers dynamic content to a Web site.                         •   RESTful Services and Syndication

Prerequisites
Before attending this course, students are expected to have:
•    Experience with programming in C#
•    Solid understanding of the Microsoft .NET framework.
•    Familiarity with the Visual Studio IDE
•    Working knowledge of web development tools and techniques
     – recommended

Modules
•   Introduction to ASP.NET
•   Working with Controls
•   Configuration
•   Data Binding
•   Validating User Input
•   CSS
•   Themes and Master Pages
•   Site Navigation
•   Displaying Data with the GridView Control
•   Managing State
•   Managing Users with ASP.NET’s Membership Features
•   Server Debugging
•   Tracing
•   Creating New Controls
•   Improving Performance with Output Caching
•   Advanced Caching Techniques
•   AJAX
•   ASP.NET Profile Features
•   SilverLight Workshop




                                 SetFocus • Corporate Course Catalog 2010 • www.setfocus.com
.NET | SQL Server | Business Intelligence | SharePoint                                                                                    7

SQL Server Training                                                     Modules
                                                                        •   SQL 2005 new features workshop
                                                                        •   SQL 2008 new features workshop
                                                                        •   Hierarchies and recursive querying
Course Length: 40 hours                                                 •   Working with dates
SF8002- Writing Queries using MS SQL Server                             •   Concurrency and locking
2008 T-SQL                                                              •   Query performance tuning
  This course provides students with the technical skills required to   •   Database security and encryption
write basic Transact-SQL queries for Microsoft SQL Server 2008.         •   Spatial data

Prerequisites
Before attending this course, students are expected to have:            Course Length: 40 hours
•    Knowledge of data integrity concepts.                              SF8014 - SetFocus – Custom Microsoft SQL Server 2008
•    Relational database design skills.                                 Integration Services
•    Some Programming skills - recommended.                               This course will enable technology professionals with little or no
                                                                        ETL experience to be comfortable and productive with the SSIS
Modules                                                                 tools and technologies. In this course you will learn about the
•   Getting Started with Databases and Transact-SQL in                  Business Intelligence Development Studio (BIDS) and working with
    SQL Server 2008                                                     Control and Data Flows to build workflows to extract, transform,
•   Querying and Filtering Data                                         and load data using a variety of data sources, transformations, and
•   Grouping and Summarizing Data                                       destinations. You will also become familiar with SSIS package
•   Joining Data from Multiple Tables                                   management and package deployment along with learning to write
•   Working with Subqueries                                             solid code using debugging, error handling, and logging techniques.
•   Modifying Data in Tables
•   Querying Metadata, XML, and Full-Text Indexes                       Prerequisites
•   Using Programming Objects for Data Retrieval                        Before attending this course, students are expected to have:
•   Using Advanced Querying Techniques                                  •    Familiarity with SQL Server Management Studio for
                                                                             development and administrative tasks.
                                                                        •    Knowledge of querying using T-SQL
Course Length: 40 hours                                                 •    Solid understanding of basic relational databases design




                                                                                                                                               ◄ Table of Contents
SF8003 - Implementing a Microsoft SQL Server
2008 Database                                                           Modules
  This SQL Server training class provides students with the             •   Guided tour of SSIS
knowledge and skills to implement a Microsoft SQL Server 2008           •   Control Flow
database. The class focuses on teaching individuals how to use          •   Data Flows
SQL Server 2008 product features and tools related to implementing      •   Variables and Configurations
a database.                                                             •   Advanced Control Flow
                                                                        •   Error logging and handling
Prerequisites                                                           •   Advanced Data Flow
Before attending this course, students are expected to have:            •   Package Deployment
•    Basic knowledge of the Microsoft Windows operating system          •   Package Management
     and its core functionality.                                        •   Scripting and custom components
•    Working knowledge of Transact-SQL.                                 •   Best Practices
•    Working knowledge of relational databases.
•    Some experience with database design.

Modules
•   Create databases and database files
•   Create data types, tables and Indexes
•   Implementing Data Integrity by Using Constraints and Triggers                                                  continued on page 8
•   Using XML
•   Implementing Views, Stored Procedures, Functions, Managed
    Code
•   Managing Transactions and Locks
•   Using Service Broker


Course Length: 40 hours
SF8005 - Advanced SQL Querying and Programming
   The course focuses on writing and tuning queries and
programming with T-SQL in SQL Server 2008. In this course you
will learn the details and capabilities of T-SQL.

Prerequisites
Before attending this course, students are expected to have:
•    Working knowledge of Transact-SQL.
•    Working knowledge of relational databases.
•    Some experience with database design.




                                  SetFocus • Corporate Course Catalog 2010 • www.setfocus.com
.NET | SQL Server | Business Intelligence | SharePoint                                          8
Course Length: 40 hours
SF8015 - SetFocus – Custom Microsoft SQL Server 2008
Reporting Services
   In this course, you will learn how to use SQL Server 2008
Reporting Services, explore its basic architecture and gain a basic
understanding of the components of SSRS 2008. You’ll then explore
tabular and list reports that employ datasets and data regions.
As you progress you’ll learn to add custom expressions, custom
functions and format your reports using Visual Studio 2008 and SQL
Server 2008 Business Intelligence Studio. The reports you create
in the course will employ shared data sources, interactive sorting,
and drill-down capabilities. You’ll then understand how Reporting
Services parameters work and create parameters in ad-hoc SQL.
Next you’ll be building Matrix reports and charts then explore the
use of Reporting Services gauges. The Deployment of Reporting
Services projects follow using a variety of formats and client-side
printing. You’ll gain knowledge of SSRS Security in managing of user
roles and accounts. You’ll also discover how to view reports using
URL access and the Reporting Services Web Service API, without
requiring users to use Internet Explorer. Finally, you’ll learn how to
empower your users to create ad-hoc reports using Report Builder
and Report Model projects.

Prerequisites
Before attending this course, students are expected to have:
•    Familiarity with SQL Server Management Studio for
     development and administrative tasks.
•    Knowledge of querying using T-SQL
•    Solid understanding of basic relational databases design




                                                                                                    ◄ Table of Contents
Modules
•   Introducing SQL Server Reporting Services
•   Creating Tabular and List Reports
•   Calculation and Formatting
•   Grouping and Sorting
•   Working with Parameters
•   Creating Matrix Reports and Charts
•   Managing Reporting Services
•   Security
•   Snapshots and Subscriptions
•   Ad-Hoc Reporting with Report Builder 2.0
•   Programming Reporting Services
•   Advanced Reporting Services Programming




                                  SetFocus • Corporate Course Catalog 2010 • www.setfocus.com
.NET | SQL Server | Business Intelligence | SharePoint                                                                                     9

Business Intelligence Training                                           Modules
                                                                         •   Dimensional Modeling Primer
                                                                         •   Retail Sales
Course Length: 40 hours                                                  •   Inventory
                                                                         •   Procurement
SF9001 - Querying and Programming using MS SQL
                                                                         •   Order Management
Server 2008 Transact SQL                                                 •   Customer Relationship Management
   This course provides students with the technical skills required to   •   Accounting
write basic Transact-SQL queries for Microsoft SQL Server 2008. It       •   Human Resources Management
also provides students with the knowledge and skills to create views     •   Financial Services
and stored procedures in a Microsoft SQL Server 2008 database.

Prerequisites
Before attending this course, students are expected to have:             Course Length: 40 hours
•    Knowledge of data integrity concepts.                               SF9004 - Microsoft SQL Server 2008 Integration Services
•    Relational database design skills.                                    This course will enable technology professionals with little or no
•    Some Programming skills - recommended.                              ETL experience to be comfortable and productive with the SSIS
                                                                         tools and technologies. In this course you will learn about the
Modules                                                                  Business Intelligence Development Studio (BIDS) and working with
•   Retrieving Data                                                      Control and Data Flows to build workflows to extract, transform,
•   Grouping Data                                                        and load data using a variety of data sources, transformations, and
•   Joining tables                                                       destinations. You will also become familiar with SSIS package
•   Sub queries                                                          management and package deployment along with learning to write
•   Modifying Data                                                       solid code using debugging, error handling, and logging techniques.
•   Implementing Data Integrity by Using Constraints and Triggers
•   Implementing Views                                                   Prerequisites
•   Implementing Stored Procedures                                       Before attending this course, students are expected to have:
                                                                         •    Familiarity with SQL Server Management Studio for develop-
                                                                              ment and administrative tasks.
Course Length: 40 hours                                                  •    Knowledge of querying using T-SQL
SF9002 - Advanced Querying and Programming using                         •    Solid understanding of basic relational databases design




                                                                                                                                                 ◄ Table of Contents
MS SQL Server 2008 Transact SQL
  The course focuses on writing and tuning queries and                   Modules
programming with T-SQL in SQL Server 2008. Advanced features             •   Guided tour of SSIS
such as recursive querying, database encryption and spatial data         •   Control Flow
are discussed.                                                           •   Data Flows
                                                                         •   Variables and Configurations
                                                                         •   Advanced Control Flow
Prerequisites
                                                                         •   Error logging and handling
Before attending this course, students are expected to have:
                                                                         •   Advanced Data Flow
•    Working knowledge of Transact-SQL.
                                                                         •   Package Deployment
•    Working knowledge of relational databases.
                                                                         •   Package Management
•    Some experience with database design.
                                                                         •   Scripting and custom components
                                                                         •   Best Practices
Modules
                                                                         •   Going Beyond ETL
•   SQL 2005 new features workshop
•   SQL 2008 new features workshop
•   Hierarchies and recursive querying
•   Working with dates                                                   Course Length: 40 hours
•   Concurrency and locking                                              SF9006 - Microsoft SQL Server 2008 Analysis Services
•   Query performance tuning                                                In this course, you will learn how to use Microsoft SQL Server
•   Database security and encryption                                     2008 Analysis Services (SSAS) to design and implement On Line
•   Spatial data                                                         Analytical Processing (OLAP) cubes and data mining models to
                                                                         support Business Intelligence (BI) solutions. This course includes
                                                                         concepts, procedures and practices based on real-world experience
Course Length: 40 hours                                                  giving both the novice and experienced SQL Server 2008 developer
SF9003 - Data Warehousing Concepts                                       the tools to build data cubes and forecasting solutions. This course
   The course primarily focuses on dimensional modeling, consider-       also provides information on end-user tools including Microsoft Excel
ations and common pitfalls in the design process. Case studies from      2007, Office Visio 2007 Professional Edition.
several industries will be discussed from a design perspective to give
the participants a broad framework of understanding of the dimen-        Prerequisites
sional modeling process.                                                 Before attending this course, students are expected to have:
                                                                         •    Working experience with SQL Server 2000 or 2005
Prerequisites                                                            •    Solid understanding of relational database concepts
Before attending this course, students are expected to have:             •    Working knowledge of DTS or SSIS
•    Good understanding of basic data warehousing concepts such
     as dimensions, measures etc.
•    Working knowledge of Transact-SQL.
•    Working knowledge of relational databases.
•    Some experience with database design.                                                                        continued on page 10



                                  SetFocus • Corporate Course Catalog 2010 • www.setfocus.com
.NET | SQL Server | Business Intelligence | SharePoint                                                                                  10
Modules                                                                your users to create ad-hoc reports using Report Builder and Report
•   What is Business Intelligence?                                     Model projects.
•   OLAP Modeling
•   Using SSAS in BIDS                                                 Prerequisites
•   Intermediate SSAS                                                  Before attending this course, students are expected to have:
•   Advanced SSAS                                                      •    Familiarity with SQL Server Management Studio for
•   Cube Storage and Aggregation                                            development and administrative tasks.
•   Introduction to MDX Queries                                        •    Knowledge of querying using T-SQL
•   MDX Expressions                                                    •    Solid understanding of basic relational databases design
•   Introduction to Data Mining
•   SSAS Administration                                                Modules
•   Advanced Administration and Optimization                           •   Introducing SQL Server Reporting Services
•   Introduction to SSAS clients                                       •   Creating Tabular and List Reports
                                                                       •   Calculation and Formatting
                                                                       •   Grouping and Sorting
Course Length: 40 hours                                                •   Working with Parameters
SF9007 - MDX Queries                                                   •   Creating Matrix Reports and Charts
    This course shows data warehouse developers what they need         •   Managing Reporting Services
to know to build effective multidimensional data warehouses.           •   Security
After a brief overview of the MDX language and a look at how           •   Programming Reporting Services
it is used to access data in sophisticated, multidimensional           •   Advanced Reporting Services Programming
databases and data warehousing, the class moves directly to            •   Snapshots and Subscriptions
providing practical examples of MDX in use. The material covers        •   Ad-Hoc Reporting with Report Builder 2.0
changes in the MDX language itself as well as major changes in its
implementation with the latest software releases of Microsoft SQL
Server Analysis Services. It also covers more advanced techniques,     Course Length: 40 hours
like aggregation, query templates, and MDX optimization, and shows     SF9010 - Business Intelligence with SharePoint and
users what they need to know to access and analyze data to make        Performance Point Server
better business decisions.                                                In this course, you will learn how to create KPI scorecards and
                                                                       build dashboards with various charts for monitoring and analysis




                                                                                                                                             ◄ Table of Contents
Prerequisites                                                          using Performance Point Server 2007, create reports and score
Before attending this course, students are expected to have:           cards using SharePoint Excel Services. This course also shows
•    Working experience with SQL Server 2000 or 2005                   students how to incorporate reports from SQL Server Reporting
•    Solid understanding of relational database concepts               Services into SharePoint, how to incorporate Excel spreadsheets
•    Working knowledge of DTS or SSIS                                  into SharePoint via Excel Services and into Performance Point.
•    Solid understanding of data warehousing concepts
•    Working knowledge of OLAP Modeling, cube storage                  Prerequisites
     and aggregation                                                   Before attending this course, students are expected to have:
                                                                       •    Solid understanding of basic relational databases design
Modules                                                                •    Knowledge of querying using T-SQL
•   Introduction to MDX                                                •    Solid understanding of data warehousing concepts
•   Calculated Members and Named Sets                                  •    Knowledge of querying using MDX
•   Common Calculations and Selections                                 •    Working knowledge of a reporting tool preferably SSRS
•   MDX Query Context and Execution
•   Named Sets and Set Aliases                                         Modules
•   Sorting and Ranking in MDX                                         •   Introduction to PerformancePoint Server
                                                                       •   Performance Management
                                                                       •   Creating Scorecards
Course Length: 40 hours                                                •   Creating Reports and Scorecards
SF9009 - Microsoft SQL Server 2008 Reporting Services                  •   Importing SSRS Reports
   In this course, you will learn how to use SQL Server 2008           •   Creating a SharePoint Site Collection
Reporting Services, explore its basic architecture and gain a basic    •   Incorporating SSRS reports into SharePoint
understanding of the components of SSRS 2008. You’ll then explore      •   Incorporating Excel spreadsheets into SharePoint via Excel
tabular and list reports that employ datasets and data regions. As         Services
you progress you’ll learn to add custom expressions, custom func-      •   Incorporating Excel spreadsheets into PerformancePoint
tions and format your reports using Visual Studio 2008 and SQL
Server 2008 Business Intelligence Studio. The reports you create in
the course will employ shared data sources, interactive sorting, and
drill-down capabilities. You’ll then understand how Reporting Ser-
vices parameters work and create parameters in ad-hoc SQL. Next
you’ll be building Matrix reports and charts then explore the use of
Reporting Services gauges. The deployment of Reporting Services
projects follow using a variety of formats and client-side printing.
You’ll gain knowledge of SSRS Security in managing user roles and
accounts. You’ll also discover how to view reports using URL ac-
cess and the Reporting Services Web Service API, without requiring
users to use Internet Explorer. Finally, you’ll learn how to empower




                                 SetFocus • Corporate Course Catalog 2010 • www.setfocus.com
.NET | SQL Server | Business Intelligence | SharePoint                                                                                  11

SharePoint Training                                                     Prerequisites
                                                                        Before attending this course, students are expected to have:
                                                                        •    Solid understanding of the .NET framework
Course Length: 24 hours                                                 •    Working knowledge of developing ASP.NET applications using
                                                                             Visual Studio
SF7001 - ASP.NET & XML Review
                                                                        •    Microsoft Active Directory - recommended
  This course is aimed at providing a review of basic XML and
ASP.NET features that are foundational for developing
                                                                        Modules
SharePoint solutions.
                                                                        •   Introduction to SharePoint Development
                                                                        •   Site Columns and Content Types
Prerequisites
                                                                        •   Extending Lists with Office 2007
Before attending this course, students are expected to have:
                                                                        •   Authentication and Authorization
•    Solid understanding of the .NET framework
                                                                        •   Forms Based Authentication and Anonymous Access
•    Working knowledge of developing ASP.NET applications using
                                                                        •   SharePoint Architecture
     Visual Studio
                                                                        •   Features
                                                                        •   Solution Development
Modules                                                                 •   Categorized Document Library
•   Configuration                                                       •   Site Definitions
•   Cascading Style Sheets                                              •   Programming Fundamentals
•   Themes and Master Pages                                             •   Creating User Controls and Web Parts
•   Site Navigation                                                     •   Advanced List Concepts
•   Managing Users with ASP.NET’s Membership Features
•   ASP.NET Profile Features
•   Empowering Users with Web Parts                                     Course Length: 32 hours
•   Basic XML
                                                                        SF7006 - Branding & Web Content Management
•   Validating XML
                                                                           In this course, you’ll learn about the web content management
•   Technologies for Handling XML Data
                                                                        features of Microsoft SharePoint 2007. The course starts from the
                                                                        perspective of an end-user so that you will understand what the
                                                                        authors and consumers of your SharePoint sites will see, and then
Course Length: 24 hours                                                 goes beneath the surface to teach you to customize and extend the
SF7002 - SharePoint for Administrators




                                                                                                                                               ◄ Table of Contents
                                                                        out-of-the-box features.
  This course teaches you the principles and practices of how to           You will understand how to implement sites that face the
deploy, manage, and maintain SharePoint. It takes you through           Internet with branded look and feel so that your visitors will never
each phase of a deployment as you plan, install, rollout, and support   know they are looking at a SharePoint site; and you’ll understand
SharePoint in the real world.                                           how to configure the same site to support the creators and managers
                                                                        of content in your organization. You’ll also learn how to implement
Prerequisites                                                           and customize things like security and navigation, how to deploy
Before attending this course, students are expected to have:            content to production environments, and how to target different
•    Knowledge of general Windows administration concepts –             audiences and different countries and languages.
     recommended
•    Knowledge of building and configuring web sites                    Prerequisites
•    Working knowledge of creating user accounts and groups in          Before attending this course, students are expected to have:
     Microsoft Active Directory - recommended                           •    Solid understanding of the .NET framework
                                                                        •    Working knowledge of developing ASP.NET applications using
Modules                                                                      Visual Studio
•   Planning                                                            •    Understanding of Site collections, Sites, Lists and Libraries,
•   Installing                                                               Features, Site Definitions, and Solution Packages.
•   Configuring the server                                              •    Working knowledge of HTML and XML.
•   Preparing
•   Roll-out                                                            Modules
•   Providing support                                                   •   Introduction to MOSS Publishing
•   Managing the server                                                 •   Branding
•   Configuring external access                                         •   Creating a Publishing Site Definition
                                                                        •   Content Types and Page Layouts
                                                                        •   SharePoint Site Design
Course Length: 40 hours                                                 •   Content Management
SF7004 - SharePoint for Developers – I                                  •   Navigation and Search
  This course is designed to provide those who are                      •   Aggregation Information
responsible for customizing and creating new functionality
within the platform mastery of these common tasks, including:
customization of look and feel through styles, themes, and
master pages, controls and web parts, custom pages, creation
and deployment of solutions, security, debugging, workflows,
custom site definitions, lists, documents libraries, and features.
Students who master the contents of this course will possess                                                        continued on page 12
the knowledge to productively contribute on most types of
SharePoint implementation because they will understand the
tasks and building blocks required in all types of custom solutions.




                                  SetFocus • Corporate Course Catalog 2010 • www.setfocus.com
.NET | SQL Server | Business Intelligence | SharePoint                                           12
Course Length: 32 hours
SF7008 - SharePoint Business Processes
   Microsoft Office SharePoint Server 2007 provides a wealth of
services that you can use, customize, and extend to augment and
streamline your business processes. This course covers these
features and teaches you how to build on them to create business
solutions. The beginning of the course orients you with the built-in
capabilities and teaches how to customize them using SharePoint
Designer. From there you will learn how to create custom forms
using both ASP.NET and InfoPath. The last half of the course
teaches how to build custom workflows in SharePoint using Visual
Studio and covers sequential workflows, state machines, tasks, and
custom workflow forms using both ASP.NET and InfoPath.

Prerequisites
Before attending this course, students are expected to have:
•    Solid understanding of the .NET framework
•    Working knowledge of developing ASP.NET applications using
     Visual Studio
•    Understanding of Site collections, Sites, Lists and Libraries,
     Features, Site Definitions, and Solution Packages.
•    Working knowledge of HTML and XML.

Modules
•   Out-of-the-Box Business Process Automation
•   SharePoint Designer Workflows
•   Working with SharePoint Designer and Custom
    ASP.NET Forms
•   Using InfoPath Forms with SharePoint
•   Custom Workflows and the SharePoint Object Model




                                                                                                      ◄ Table of Contents
•   Visual Studio 2008 Workflow Development Basics
•   Workflow Tasks
•   Workflow Forms


Course Length: 24 hours
SF7010 - SharePoint Portal Management
   In this course, you’ll learn about the portal features found in
Microsoft Office SharePoint Server’s Standard and Enterprise
versions, MOSS. After completing this course, you’ll have a good
understanding of the standard MOSS collaboration portal features
including collaboration portals, user profiles, search, and information
management policies, as well as the enterprise features including
business data catalog, InfoPath forms services and Excel Services.

Prerequisites
Before attending this course, students are expected to have:
•    Solid understanding of the .NET framework
•    Working knowledge of developing ASP.NET applications using
     Visual Studio
•    Understanding of Site collections, Sites, Lists and Libraries,
     Features, Site Definitions, and Solution Packages.
•    Working knowledge of HTML and XML.
•    Understanding of the web content management features of
     MOSS.

Modules
•   Collaboration Portals
•   Personalization and My Sites
•   Business Data Catalog
•   Office Forms Services
•   Excel Services
•   Customizing Search Center
•   Programming with the Search API
•   Document Management




                                   SetFocus • Corporate Course Catalog 2010 • www.setfocus.com
                                                              13




                                                                   ◄ Table of Contents




              w w w.setfo c u s.co m


SetFocus • Corporate Course Catalog 2010 • www.setfocus.com

								
To top