UF Information Technology Certification

Elective Categories

Elective courses may only be applied towards one certificate; credit for a completed course will not be counted towards the elective requirements of multiple certificates.

Course Name	Provider
Database 1
Course 4100: Core Training for Microsoft Access 2003 Fundamentals	MSITA
Course 4127: Core Training for Microsoft Access 2002	MSITA
Course 4326: An Introduction to Transact-SQL in Microsoft SQL Server 2008	MSITA
Getting Started with Microsoft Office Access 2007	MSITA
Microsoft Access 1: Basics and Database Fundamentals	HSC
Microsoft Access 2: Tables	HSC
Microsoft Access 2003 – Basic	HR
Microsoft Access 3: Relationships	HSC
Microsoft Access 4: Select Queries	HSC
Microsoft Access 5: Intro to Forms and Reports	HSC
Performing Basic Queries in Microsoft® SQL Server™ 2005	MSITA
What's New in Microsoft Office Access 2007	MSITA
Database 2
Accessing and Displaying Data with Microsoft® Visual Studio® 2005	MSITA
Analyzing Capacity Needs for Microsoft® SQL Server™ 2005	MSITA
Connecting to Databases and Reading Data with Microsoft® Visual Studio® 2005	MSITA
Data Binding by Using Windows Forms Controls with Microsoft® Visual Studio® 2005	MSITA
Designing a Microsoft® SQL Server™ 2005 Security Exceptions Policy	MSITA
Designing a Response Strategy for Threats and Attacks Against Microsoft® SQL Server™ 2005	MSITA
Designing a SQL Server™ 2005 Security Policy to Integrate with Systems Infrastructure	MSITA
Designing Security Policies for Microsoft® SQL Server™ 2005 Instances and Databases	MSITA
Grouping and Summarizing Data in Microsoft® SQL Server™ 2005	MSITA
Importing and Exporting Information in Microsoft Office Access 2007	MSITA
Integrating Data Encryption into a Microsoft® SQL Server™ 2005 Database Security Design	MSITA
Introduction to Designing SQL Server Security for Microsoft® SQL Server™ 2005	MSITA
Joining Data from Multiple Tables in Microsoft® SQL Server™ 2005	MSITA
Keeping Information Accurate and Secure in Microsoft Office Access 2007	MSITA
Locating Specific Information in Microsoft Office Access 2007	MSITA
Microsoft Access 2003 – Advanced	HR
Microsoft Access 6: Forms	HSC
Microsoft Access 7: Reports	HSC
Microsoft Access 8: Queries II	HSC
Microsoft Access 9: Forms & Macros	HSC
Microsoft SQL Server 2000 Database Design	MSITA
Microsoft SQL Server 2000 Querying with Transcat -SQL	MSITA
Modifying Data in Microsoft® SQL Server™ 2005	MSITA
Using Commands to Query and Update Databases with Microsoft® Visual Studio® 2005	MSITA
Working with Forms in Microsoft Office Access 2007	MSITA
Working with Reports in Microsoft Office Access 2007	MSITA
Working with Subqueries in Microsoft® SQL Server™ 2005	MSITA
Database 3
Building a Monitoring Solution for Microsoft® SQL Server™ 2005 Performance Issues	MSITA
Collection 2786: Designing a Microsoft® SQL Server™ 2005 Infrastructure	MSITA
Collection 2787: Designing Security for Microsoft® SQL Server™ 2005	MSITA
Collection 2788: Designing High-Availability Database Solutions Using Microsoft® SQL Server™ 2005	MSITA
Combining High-Availability Technologies Using Microsoft® SQL Server™ 2005	MSITA
Course 2937: Administering and Monitoring Microsoft SQL Server 2005	MSITA
Creating Managed Code for Microsoft® SQL Server™ 2005 with Microsoft® Visual Studio® 2005	MSITA
Designing a Clustering Solution Using Microsoft® SQL Server™ 2005	MSITA
Designing a Data Archiving Strategy for Microsoft® SQL Server™ 2005	MSITA
Designing a Data Distribution Strategy for Microsoft® SQL Server™ 2005	MSITA
Designing a Data Recovery Strategy for Microsoft® SQL Server™ 2005	MSITA
Designing a Database Mirroring Solution Using Microsoft® SQL Server™ 2005	MSITA
Designing a Database Server Consolidation Strategy for Microsoft® SQL Server™ 2005	MSITA
Designing a Highly Available Database Storage Solution Using Microsoft® SQL Server™ 2005	MSITA
Designing a Log Shipping Solution Using Microsoft® SQL Server™ 2005	MSITA
Designing a Microsoft® SQL Server™ 2005 Database Server Infrastructure	MSITA
Designing Replication Solutions for High Availability Using Microsoft® SQL Server™ 2005	MSITA
Documenting and Testing a High-Availability Strategy Using Microsoft® SQL Server™ 2005	MSITA
Enhancing Database Performance with Microsoft® Visual Studio® 2005	MSITA
Establishing Database Conventions and Standards for Microsoft® SQL Server™ 2005	MSITA
Handling Large Objects with Microsoft® Visual Studio® 2005	MSITA
Managing and Automating Microsoft® SQL Server™ 2005 Databases and Servers	MSITA
Managing Microsoft® SQL Server™ 2005 Supporting Services	MSITA
Microsoft SQL Server 2000 System Administration	MSITA
Minimizing and Handling Database Operation Conflicts with Microsoft® Visual Studio® 2005	MSITA
Optimizing the Microsoft® SQL Server™ 2005 Query Performance Environment	MSITA
Performing Disconnected Operations by Using Microsoft® Visual Studio® 2005 Wizards	MSITA
Performing Disconnected Operations Programmatically with Microsoft® Visual Studio® 2005	MSITA
Performing Transactional Operations with Microsoft® Visual Studio® 2005	MSITA
Performing XML Operations on Disconnected Data with Microsoft® Visual Studio® 2005	MSITA
Querying Metadata, XML, and Full-Text Indexes in Microsoft® SQL Server™ 2005	MSITA
Selecting the Appropriate High-Availability Technology Using Microsoft® SQL Server™ 2005	MSITA
Troubleshooting Microsoft® SQL Server™ 2005 Concurrency Issues	MSITA
Troubleshooting Microsoft® SQL Server™ 2005 Connectivity Issues	MSITA
Troubleshooting Microsoft® SQL Server™ 2005 Data Issues	MSITA
Troubleshooting Microsoft® SQL Server™ 2005 Performance Issues	MSITA
Using Advanced Querying Techniques in Microsoft® SQL Server™ 2005	MSITA
Using Programming Objects for Data Retrieval in Microsoft® SQL Server™ 2005	MSITA

- Courses from higher level categories may be used to substitute for elective requirements in lower level categories (ex: a course from the Desktop Publishing 2 category can be used to fulfill the requirement for a course from the Desktop Publishing 1 category).
- Elective courses can not be double counted; if a certificate requires eight elective courses, eight separate courses in the appropriate categories must be completed to receive that certificate (even if a specific course falls into multiple categories).

---