Course
Schedule
AJAX
ASP_NET
Access DB
Acrobat
ActiveDir
C# .NET Prog.
CSS (HTML)
Cisco Week
Crystal Reports
DP Design
DigCameras
Dreamweaver
E-commerce
Excel
Exchange
ExpressionWeb
FileMaker
Fireworks
Flash
HTML
Illustrator
InDesign
Introductory
JSP
Java
JavaScript
Linux
Networks
ObjectOProg.
Office2007
Oracle
Outlook
PHP
Perl
PhotoElems
Photoshop
PowerPoint
Premiere
Prog. Concpts
Project
Publisher
QuarkXPress
QuickBooks
SQL
SQL Reporting
SQLServerAdm
Security
SharePoint
SharePtAdmin
SharePtDesign
Support
TCP/IP
UNIX
VB.NET
Visio
Vista Admin
Vista Intro.
Vista Trans.
Visual Basic 6
W2003 Policy
W2003 Server
W2008 Server
Win XP Intro.
Wireless Net.
Word
XML
|
Microsoft SQL Server 2005 |
| ||
 | |||
|
Introduction to SQL Server System Administration (Prerequisite: Intermediate Applications of SQL or equivalent experience.) Learn the basics of installing, configuring, and administering Microsoft SQL Server. Get an overview of SQL Server and how the current version differs from previous versions. Install and configure Microsoft SQL Server Enterprise Edition and learn about the various SQL Server editions. Investigate how to troubleshoot your installation, along with how to install and troubleshoot the client tools used to connect to SQL Server. Learn about some of the common tools and utilities, such as the SQL Server Management Studio, that come with the program and can assist you in managing your database. Discuss SQL Server security from the standpoint of creating and working with user logon accounts and setting database security through database permissions. Fee: $389 | |||
|
Two-Day Class Meets 8:30am-4:00pm (13 hours) | |||
| Code | Dates | Location | Instructor |
| G9561 | Wed., Nov. 12 & Thurs., Nov. 13 | West County | Frank Richey |
| G9771 | Thurs., Jan. 15 & Fri., Jan. 16 | West County | Frank Richey |
| |||
|
Intermediate SQL Server System Administration (Prerequisite: Introduction to SQL Server System Administration or equivalent experience.) This course is a continuation of the introductory course, with an emphasis on maintenance, optimization, and performance tuning of a SQL Server database. Investigate how to plan the space requirements for a database and control its size. Learn to optimize queries and defragment, import, export, back up, and restore databases. Additional topics include index tuning, multi-user considerations, an introduction to SQL Server Integration Services (SSIS), and disaster recovery considerations. Fee: $389 | |||
|
Two-Day Class Meets 8:30am-4:00pm (13 hours) | |||
| Code | Dates | Location | Instructor |
| G9562 | Tues., Nov. 25 & Wed., Nov. 26 | West County | Frank Richey |
| G9772 | Thurs., Jan. 29 & Fri., Jan. 30 | West County | Frank Richey |
| |||
|
Advanced SQL Server System Administration (Prerequisite: Intermediate SQL Server System Administration or equivalent experience.) Explore advanced techniques using SQL Server to store and retrieve data from other SQL Server and other heterogeneous data sources. Probe deeper into the administration of SQL Server with a discussion of the Microsoft Distributed Transaction Coordinator and distributed transactions. Investigate various methods of storing and retrieving data from multiple locations, including linked servers, data replication, and log shipping. Learn how to configure snapshot, transactional, and merge replication and the advantages and disadvantages of each. Fee: $389 | |||
|
Two-Day Class Meets 8:30am-4:00pm (13 hours) | |||
| Code | Dates | Location | Instructor |
| G9317 | Tues., Sept. 30 & Wed., Oct. 1 | West County | Frank Richey |
| G9663 | Tues., Dec. 9 & Wed., Dec. 10 | West County | Frank Richey |
| G9873 | Thurs., Feb. 12 & Fri., Feb. 13 | West County | Frank Richey |
|
| |||
