|
We offer the following Advanced Technology Training workshops:
(*workshops marked with asterisk are being offered during the May through
August, 2008 time frame)
Web & CSS
*Developing Web Design Using Cascading Style Sheets
SQL Server 2005 & 2008
*Updating Your SQL Server 2005 Skills to
SQL Server 2008 NEW!
*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
Troubleshooting & Optimizing Database Servers using Microsoft SQL Server
2005
UIUC Active Directory
*Introduction to Windows Server 2003 Active Directory
at UIUC
*Updating your Active Directory Technology Skills to Windows Server
2008
*Implementing Group Policy in the UIUC Active Directory
SharePoint 3.0 & SharePoint Server 2007
*Implementing Microsoft SharePoint
Server 2007
Implementing Windows SharePoint Services 3.0
Oracle Database 10g
Oracle Database 10g: Admin Workshop I
Windows Vista
Deploying Microsoft Windows Vista Business Desktops
Network Security
Fundamentals of Network Security
Implementing & Administering Security in
a Windows Server 2003 Network
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 one day course will help to
inform and expose you to basic CSS concepts. Hands-on activities will
include building a replica of
the UIUC template page 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, CITES Departmental Services
Hours: 6
Fee: $129
Date / Time: May 6 & 8, 2008 (TuTh); 1:00 p.m - 4:00 p.m.
Registration Code: CSS-0508-ATT
Location: UIUC (Champaign) -- location to be announced
Date / Time: June 23 & 25, 2008 (MW); 1:00 p.m - 4:00 p.m.
Registration Code: CSS-0608-ATT
Location: UIUC (Champaign) -- location to be announced
Registration Form
Back to Top
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, CITES Departmental Services
Hours: 7
Fee: $219
Date / Time: July 22, 2008 (Tu); 9:00 a.m - 5:00 p.m. (lunch
on your own)
Registration Code: MS-6158A-0708
Location: UIUC (Champaign) -- location to be announced
Registration Form
Back to Top
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, CITES Departmental Services
Hours: 7
Fee: $199
Date / Time: July 7, 2008 (M); 9:00 a.m - 5:00 p.m. (lunch
on your own)
Registration Code: SQL-0708-ATT
Location: UIUC (Champaign) -- location to be announced
Registration Form
Back to Top
This course is intended for IT professionals who want to become
skilled on SQL Server 2005 features and technologies for maintaining a
database. It is the first half of the Microsoft Official Curriculum
course 2780. 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, CITES Departmental Services
Hours:
21
Fee: $389 (includes official Microsoft curriculum)
Date / Time: May 19 - 23, 2008 (M - F); 1:00 p.m - 5:00
p.m.
Registration Code: MS-2780B-0508
Location: UIUC (Champaign) -- location to be announced
Registration Form
Back to Top
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; use XML-related features in Microsoft SQL Server 2005; plan,
create, and optimize indexes; implement data integrity in Microsoft SQL
Server 2005 databases by using constraints, triggers, and XML schemas;
implement views; implement stored procedures and functions; implement
managed code in the database; and use Service Broker to build a
messaging-based solution.
Prerequisite: Basic knowledge of Microsoft Windows; working
knowledge of Transact-SQL; working knowledge of relational databases;
some experience with database design.
Instructor: Phil Nyman, CITES Departmental Services
Hours:
21
Fee: $389 (includes official Microsoft curriculum)
Date / Time: June 30 - July 2, 2008 (M - W); 9:00 a.m - 4:00
p.m. (lunch on your own)
Registration Code: MS-2779B-0608
Location: UIUC (Champaign) -- location to be announced
Registration Form
Back to Top
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.
For more details, see
http://www.microsoft.com/learning/syllabi/en-us/2793afinal.mspx
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, CITES Departmental Services
Hours:
24
Fee: $449 (includes official Microsoft curriculum)
Date / Time: Aug. 18 - 20, 2008 (M - W); 9:00 a.m - 5:00 p.m. (lunch
on your own)
Registration Code: MS-2793-0808
Location: UIUC (Champaign) -- location to be announced
Registration Form
Back to Top
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, CITES Departmental Services
Hours:
21
Fee: $449 (includes official Microsoft curriculum)
Date / Time: May 5, 7, & 9, 2008 (MWF); 9:00 a.m - 5:00 p.m. (lunch
on your own)
Registration Code: MS-2792A-0508
Location: UIUC (Champaign) -- location to be announced
Date / Time: July 15 - 17, 2008 (Tu - Th); 9:00 a.m - 5:00 p.m. (lunch
on your own)
Registration Code: MS-2792-0708
Location: UIUC (Champaign) -- location to be announced
Registration Form
Back to Top
This two-day workshop will teach database administrators working in
enterprise environments how to determine and troubleshoot performance
issues using Microsoft SQL Server 2005. The primary focus of this
workshop is to teach the overall process of troubleshooting. It includes
establishing monitoring standards and baselines, determining performance
thresholds, and focusing the investigation on specific issues.
For more details, see
http://www.microsoft.com/learning/syllabi/en-us/2790afinal.mspx
Prerequisite:
Working knowledge of
SQL Server 2005 architecture including indexing, SQL execution plans,
and SQL Server basic configuration; basic monitoring and troubleshooting
skills; working knowledge of the operating system and platform;
understanding of Transact-SQL syntax and programming logic; basic
understanding of how Domain Name Service (DNS) operates and how servers
communicate between domains; familiarity with SQL Server 2005 features,
tools, and technologies.
Instructor: Phil Nyman, CITES Departmental Services
Hours:
12
Fee: $399 (includes official Microsoft curriculum)
Please contact Training Services for scheduling information about this
course: 217-333-6285
Registration Form
Back to Top
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, CITES Departmental Services
Hours: 12
Fee: $249
Date / Time: June 2, 4, & 6, 2008 (MWF); 1:00 p.m - 5:00
p.m.
Registration Code: AD-0608-ATT
Location: UIUC (Champaign) -- location to be announced
Registration Form
Back to Top
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.
For more details, see
http://www.microsoft.com/learning/syllabi/en-us/6416afinal.mspx
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, CITES Departmental Services
Hours: 20
Fee: $389
Deadline to Register: Wednesday, May 7,
2008
Date / Time: May 19 - 23, 2008 (M - F); 1:00 p.m - 5:00
p.m.
Registration Code: MS-6416A-0508
Location:
Illini Hall, Suite 26
Date / Time: Aug. 11 - 15, 2008 (M - F); 1:00 p.m - 5:00
p.m.
Registration Code: MS-6416A-0808
Location:
Illini Hall, Suite 26
Registration Form
Back to Top
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, CITES Departmental Services
Hours: 12
Fee: $249
Date / Time: July 8 - 10, 2008 (Tu - Th); 1:00 p.m - 5:00
p.m.
Registration Code: GP-0708-ATT
Location: UIUC (Champaign) -- location to be announced
Registration
Form Back to Top
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.
For more details, see
http://www.microsoft.com/learning/syllabi/en-us/5060Afinal.mspx
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, CITES Departmental Services
Hours: 12
Fee: $399 (includes official Microsoft curriculum)
Please contact Training Services for scheduling information about this
course: 217-333-6285
Registration Form
Back to Top
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, CITES Departmental Services
Hours: 24
Fee: $449 (includes official Microsoft curriculum)
Date / Time: June 23 - 25, 2008 (M - W); 9:00 a.m - 5:00 p.m. (lunch
on your own)
Registration Code: MS-5061-0608
Location: UIUC (Champaign) -- location to be announced
Registration Form
Back to Top
This course is designed to give you a firm foundation in basic database
administration. You'll learn how to install and maintain an Oracle
database, and gain a conceptual understanding of the Oracle database
architecture and how its components work and interact with one another.
You will also learn how to create an operational database and properly
manage the various structures in an effective and efficient manner
including performance monitoring, database security, user management,
and backup/recovery techniques. All topics are reinforced with
structured hands-on practices.
Please contact Training Services for scheduling information about this
course: 217-333-6285
Back to Top
This instructor-led hands-on course provides students with the
knowledge and skills to successfully deploy Microsoft® Windows Vista™
business desktops throughout their organization. Students are introduced
to the deployment life cycle, which consists of planning for the
deployment, building and customizing the deployment method, and then
implementing the actual deployment.
After completing this course, students will be able to:
- Describe the challenges, techniques, and processes that take place
throughout the Microsoft Windows Vista desktop deployment life-cycle.
- Inventory, analyze, and mitigate application compatibility when
planning a Microsoft Windows Vista desktop deployment.
- Capture and restore user state information during a workstation
deployment task.
- Create a custom image of a desktop computer that runs the Microsoft
Windows Vista operating system.
- Deploy a Microsoft Windows Vista image using a Lite Touch
methodology.
- Secure a desktop running Microsoft Windows Vista using Windows Vista
technology.
Prerequisites: Before attending this course, students must have:
- Experience deploying Windows® client systems.
- At least one year of experience managing a Microsoft Windows
desktop operating system environment.
- Familiarity with standard client and application deployment
methods such as Group Policy, disk imaging, and Systems Management
Server (SMS).
- Familiarity with the Business Desktop Deployment (BDD) Solution
Accelerator.
Contact FAST3 for further information on
this workshop.
217-333-6285
Back to Top
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
Contact FAST3 for further information on
this workshop.
217-333-6285
Back to Top
This 5-day course focuses on Windows Server 2003 based infrastructure
solutions. The learning objective is to provide functional skills in
planning and implementing infrastructure security.
Topics covered will include
- planning and configuring an authorization and authentication
strategy
- installing, configuring, and managing certification authorities
- configuring, deploying, and managing certificates
- planning, implementing, and troubleshooting smart card certificates
- planning, implementing, and troubleshooting Encrypting File System (EFS)
- planning, configuring, and deploying a secure member server baseline
- planning, configuring, and implementing secure baselines for server
roles
- planning, configuring, implementing, and deploying client computer
baselines
- planning and implementing software updates
- planning, deploying, and troubleshooting data transmission security
- planning and implementing security for wireless networks
- planning and implementing perimeter security with Internet Security
and Acceleration (ISA) Server 2004
For more detailed information about this course, visit:
http://www.microsoft.com/learning/syllabi/en-us/2823bfinal.mspx
Prerequisite: Completion of
MOC 2810 OR equivalent experience. Experience implementing a
Windows 2000 or Windows Server 2003 Active Directory environment.
Experience with organizational resources such as Web, FTP and
Exchange servers (not expected to have detailed knowledge). Shared
resources and network services such as DHCP, DNS and WINS also
helpful.
Contact FAST3 for further information on
this workshop.
217-333-6285
Back to Top
|
