FAST3 banner
Faculty and Staff Technology Training Team
  Home Workshops Calendar Registration Form General Information About FAST3 Contact Us  

Advanced Technology Training

We offer the following Advanced Technology Training workshops:
    (an * indicates workshops being offered during the Fall 2008 term; ask us about other offerings)

Web & CSS
*Developing Web Design Using Cascading Style Sheets

SQL Server 2005 & 2008
*Updating Your SQL Server 2005 Skills to SQL Server 2008
*Querying Microsoft SQL Server 2005 with Transact-SQL
*Maintaining a Microsoft SQL Server 2005 Database
*Implementing a Microsoft SQL Server 2005 Database
Implementing & Maintaining Microsoft SQL Server 2005 Reporting Services
Implementing & Maintaining Microsoft SQL Server 2005 Integration Services

UIUC Active Directory
*Introduction to Windows Server 2003 Active Directory at UIUC
Implementing Group Policy in the UIUC Active Directory
Updating your Active Directory Technology Skills to Windows Server 2008

SharePoint 3.0 & SharePoint Server 2007
Implementing Microsoft SharePoint Server 2007
Implementing Windows SharePoint Services 3.0

Network Security
Fundamentals of Network Security

 

Developing Web Design Using Cascading Style Sheets

Have you wondered what all the talk regarding Cascading Style Sheets (CSS) is about? Have you wanted to redesign your web site to go from the use of tables to cascading style sheets, but were afraid it would cause more problems? This 6-hour course will help to inform and expose you to basic CSS concepts and best practices. Hands-on activities will include building a multi-column layout and navigation system from scratch using only CSS for positioning and styling. We'll also learn basic best practice techniques to give you a good solid foundation for your web development efforts. 

Prerequisite: Familiarity with HTML. Basic knowledge of CSS is helpful but not required.
Instructor: Tim Offenstein, Departmental Services
Hours: 6
Fee: $129

Date / Time: Sept. 9 & 11, 2008 (TuTh); 9:00 a.m - 12:00 p.m.
Registration Code: CSS-0908-ATT
Location: Illini Hall, Suite 26 (lower level)

Registration Form       Back to Top

 

Updating Your SQL Server 2005 Skills to SQL Server 2008

With the release of SQL Server 2008 just around the corner it’s time to take a look at its new features. In this one-day hands-on workshop you will take a self-guided tour of the manageability, governance, performance, security and development enhancements of the SQL Server 2008 engine. Students will be free to pick and choose from among nine modules provided to select the topics of most interest to them. In addition to the core engine, enhancements to Data Warehousing, Reporting Services and Analysis Services will also be covered.

Prerequisites: Experience with SQL Server 2005 is necessary
Instructor: Phil Nyman, Departmental Services
Hours: 7
Fee: $219

Date / Time: Nov. 10, 2008 (M); 9:00 a.m - 5:00 p.m. (lunch on your own)
Registration Code: SQL-1108-ATT
Location: Illini Hall, Suite 26 (lower level)

Registration Form       Back to Top

 

Querying Microsoft SQL Server 2005 with Transact-SQL

This one-day course provides an introduction to the MS Transact-SQL query language and detailed, hands-on experience writing SELECT queries. This course should be attended by those who are in a position to write or understand / modify existing SELECT queries. We will use MS SQL Server 2005, but the concepts apply to all relational databases. Attendees will learn about the structure of the Transact-SQL query language; the ways that queries may be issued to MS SQL Server; how to write and troubleshoot SELECT queries; how to work with date, time and string character data formats; how to group data and perform statistical summarizations; how to construct sub-queries to break down complex queries; and how to use standard table joins to retrieve data from multiple tables.

Prerequisites: Familiarity with MS Windows OS; basic familiarity with relational db concepts (tables, relationships).
Instructor: Phil Nyman, Departmental Services
Hours: 7
Fee: $199

Date / Time: Sept. 29, 2008 (M); 9:00 a.m - 5:00 p.m. (lunch on your own)
Registration Code: SQL-0908-ATT
Location: Illini Hall, Suite 26 (lower level)

Registration Form       Back to Top

 

Maintaining a Microsoft SQL Server 2005 Database

This course is intended for IT professionals who want to become skilled on SQL Server 2005 features and technologies for maintaining a database. At completion of this course, students will be able to install and configure SQL Server 2005, manage database files, backup and restore databases, manage security, and monitor SQL Server.

Prerequisite: Basic knowledge of Microsoft Windows; working knowledge of Transact-SQL; working knowledge of relational databases; some experience with database design.

Instructor: Phil Nyman, Departmental Services
Hours: 21
Fee: $389 (includes curriculum workbook materials)

Date / Time: Oct. 27, 29, & 31, 2008 (MWF); 9:00 a.m - 5:00 p.m. (lunch on your own)
Registration Code: SQL-1008-ATT
Location: Illini Hall, Suite 26 (lower level)

Registration Form       Back to Top

 

Implementing a Microsoft SQL Server 2005 Database

This three-day instructor-led course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to implementing a database. Topics covered will include learning how to create databases and database files; create data types and tables; plan, create, and optimize indexes; implement data integrity in Microsoft SQL Server 2005 databases by using constraints and triggers; implement views; implement stored procedures and functions; and implement managed code in the database.

Prerequisite: Basic knowledge of Microsoft Windows; working knowledge of Transact-SQL; working knowledge of relational databases; some experience with database design.

Instructor:
Phil Nyman, Departmental Services
Hours: 21
Fee: $389 (includes curriculum workbook materials)

Date / Time: Dec. 1, 3, & 5, 2008 (MWF); 9:00 a.m - 5:00 p.m. (lunch on your own)
Registration Code: SQL-1208-ATT
Location: Illini Hall, Suite 26 (lower level)

Registration Form       Back to Top

 

Implementing and Maintaining Microsoft SQL Server 2005 Reporting Services

This three-day instructor-led course teaches students how to implement a Reporting Services solution in an organization. The course discusses how to use the Reporting Services development tools to create reports, and how to use the Reporting Services management and administrative tools to manage a Reporting Services solution. Topics covered will include learning how to describe SQL Server Reporting Services and its components; create a Reporting Services report; enhance a Reporting Services report; create and manipulate data sets; use report models to implement reporting for business users; configure report publishing and execution settings; implement subscriptions for reports; administer Reporting Services; and implement custom Reporting Services applications.

Prerequisite: Experience creating reports in Microsoft Access or other third-party reporting products, such as Crystal Reports; experience with Microsoft SQL Server, including SQL Server Agent, SQL Server query language (SELECT, UPDATE, INSERT, and DELETE), SQL Server System tables, and SQL Server accounts (users and permissions)

Instructor:
Phil Nyman, Departmental Services
Hours: 24
Fee: $449 (includes curriculum workbook materials)

Please call FAST3 Training Services for information about this course: 217-333-6285

Back to Top

 

Implementing and Maintaining Microsoft SQL Server 2005 Integration Services

This three-day course teaches students how to implement an Integration Services solution by discussing how to develop, deploy, and manage Integration Services packages. At course completion, attendees will be able to describe SQL Server Integration Services (SSIS) and its tools; create and deploy a SSIS package; implement control flow, data flow, and logging in a SSIS package; debug and implement error handling in a SSIS package; implement checkpoints and transactions, and manage and secure a SSIS package.

Prerequisite: Experience navigating the Windows Server environment; and experience with Microsoft SQL Server including SQL Server Agent, query language (SELECT, UPDATE, INSERT, and DELETE), system tables, and SQL Server accounts (users and permissions).

Instructor:
Phil Nyman, Departmental Services
Hours: 21
Fee: $449 (includes curriculum workbook materials)

Please call FAST3 Training Services for information about this course: 217-333-6285

Back to Top

 

Introduction to Windows Server 2003 Active Directory at UIUC

In this solid overview of the UIUC Active Directory (AD), you'll learn how and why AD uses DNS, and get an overview of AD security and authentication. Learn to create and manage computer accounts in your organizational unit (OU), and effectively manage your OU structure. Pick up some tips and tools for troubleshooting, and you're on your way!

Prerequisite: Windows server/domain administration experience; knowledge of TCP/IP and NetBIOS Networking
Instructor:  Hector Mandel, Departmental Services
Hours:
12
Fee:
$249

Date / Time: Oct. 8, 9, & 10, 2008 (WThF); 1:00 p.m - 5:00 p.m.
Registration Code: AD-1008-ATT
Location: Illini Hall, Suite 26 (lower level)

Please call FAST3 Training Services for information about this course: 217-333-6285

Back to Top

 

Updating your Active Directory Technology Skills to Windows Server 2008

This instructor-led course provides students with an understanding of Active Directory technology in Windows Server 2008 (based on an interim build of Windows Server 2008). After completing this course, attendees will be able to describe and configure server roles with Active Directory Services in Windows Server 2008; plan for and deploy Active Directory Domain Services; install, configure, and manage the Server Core role as a domain controller; manage accounts, subnets, Site-Links, Group Policy, and DNS configuration with Active Directory Domain Services; manage new Active Directory services, including Active Directory Federation Services, Active Directory Lightweight Directory Services, and Active Directory Rights Management Services; set up and manage Read-Only Domain Controllers (RODC); use auditing features in Active Directory Domain Services; and manage credentials with Active Directory Certificate Services, including Credential Roaming.

Prerequisites: On-the-job experience in planning, implementing, managing, or supporting Microsoft Windows Server 2000 or 2003, including:
    familiarity with Active Directory and Network Infrastructure;
    working knowledge of networking (e.g. TCP/IP and Domain Name System (DNS));
    experience in designing a Microsoft Windows Server 2003 Active Directory and Network Infrastructure;
    experience in designing security for a Microsoft Windows Server 2003 Network;
    experience in installing, configuring, & administering Windows 2000, Windows XP Professional, or Microsoft Vista.
Instructor:  Hector Mandel, Departmental Services
Hours:
20
Fee:
$389

Please call FAST3 Training Services for information about this course: 217-333-6285

Back to Top

 

Implementing Group Policy in the UIUC Active Directory

Group Policy provides directory-based desktop configuration management. In the UIUC Active Directory, you can use Group Policy to define configurations for groups of users and computers. With Group Policy, you will be able to specify settings for registry-based policies, security, software installation, scripts, folder redirection, remote installation services, and Internet Explorer maintenance. This 12-hour workshop is designed for UIUC Active Directory OU administrators.

Prerequisite: Introduction to Windows Server 2003 Active Directory at UIUC, or equivalent experience
Instructor:  Hector Mandel, Departmental Services
Hours:
12
Fee:
$249

Please call FAST3 Training Services for information about this course: 217-333-6285

Back to Top

 

Implementing Windows SharePoint Services 3.0

This two-day instructor-led course provides students with the knowledge and skills to successfully implement Microsoft Windows SharePoint Services (WSS) version 3.0 in their organizations. Attendees will learn the importance of thinking about the architecture of their entire environment, including business and application needs, during the planning and deployment phases. The course covers how to perform a clean installation of WSS 3.0 and also describes all the prerequisites required to select the most appropriate method for upgrading WSS from 2.0 to 3.0 in a specific scenario. In addition, the course focuses on how to manage WSS after it is configured.

Prerequisite: Experience in implementing, managing, and supporting Microsoft Windows Server 2003, including IIS; working knowledge of networking, for example, TCP/IP and Domain Name System (DNS); basic knowledge of SharePoint Server.

Instructor: Philip Nyman, Departmental Services
Hours: 12
Fee: $399 (includes curriculum workbook materials)

Please call FAST3 Training Services for information about this course: 217-333-6285

Back to Top

 

Implementing Microsoft SharePoint Server 2007

This three-day course provides students with knowledge and skills required to implement Microsoft Office SharePoint Server (MOSS) 2007 At course completion attendees will be able to describe MOSS 2007; plan for and design a MOSS 2007 implementation; deploy and administer MOSS 2007; implement a portal solution, a content management solution, and a business intelligence solution, and a search and indexing solution with MOSS 2007; and maintain and optimize MOSS 2007.

Prerequisite: Experience in implementing, managing, and supporting a Windows SharePoint Services 3.0 environment; at least 2 years of experience implementing, managing, and supporting Microsoft Windows Server 2003 and Internet Information Services (IIS); and working knowledge of networking.

Instructor: Philip Nyman, Departmental Services
Hours: 24
Fee: $449 (includes curriculum workbook materials)

Please call FAST3 Training Services for information about this course: 217-333-6285

Back to Top

 

Fundamentals of Network Security

This four-day, instructor-led course, designed for administrators who are responsible for the day-to-day administration of Microsoft Windows systems, provides attendees with the knowledge and skills to begin supporting network security within an organization. Students who complete this course will be able to identify security threats and vulnerabilities, and help respond to and recover from security incidents. Although the course focuses on Microsoft product- and technology-specific implementation of security concepts, many of these same concepts can be applied to other technologies.

After completing this course, students will be able to:

  • Explain common attacks against network assets, the associated threats and vulnerabilities, and what network security personnel do to secure assets.
  • Explain how to use cryptography to help protect information and how to choose an appropriate encryption method for an organization.
  • Implement security-enhanced computing baselines in an organization.
  • Help protect information in an organization by using authentication and access control.
  • Deploy and manage certificates.
  • Help protect transmission of data by identifying threats to network devices and implementing security for common data transmission, remote access, and wireless network traffic.
  • Help protect Web servers against common attacks and configure security for Web browsers.
  • Help protect e-mail messages and instant messaging from common security threats.
  • Identify common security threats and vulnerabilities to directory services and DNS, and then apply security methods to help protect them.
  • Identify network perimeter threats and monitor perimeter security for a network.
  • Identify types of security policies to manage operational security, and then use these policies to ensure compliance by users in an organization.
  • Preserve business continuity by implementing a security-enhanced disaster recovery strategy, communicating risks to others, and performing secure backup and recovery.
  • Identify, respond to, and assist in the formal investigation of security incidents.

Prerequisite: should have general knowledge of networking concepts and one or more years of experience managing Windows computers. Other IT professionals may also take this course on the path to becoming a security specialist.
Hours: 32

Please call FAST3 Training Services for information about this course: 217-333-6285

Back to Top

 

 

University of Illinois at Urbana-Champaign