UP ITTC Short Courses

Click the name of the short course to view its outline.




UP ITTC Short Courses - Outlines

CCNA1
This course introduces the architecture, structure, functions, components, and models of the Internet and other computer networks. It uses the OSI and TCP layered models to examine the nature and roles of protocols and services at the application, network, data link, and physical layers. The principles and structure of IP addressing and the fundamentals of Ethernet concepts, media, and operations are introduced to provide a foundation for the curriculum. Labs use a “model internet” to allow students to analyze real data without affecting production networks. Packet tracer (PT) activities help students analyze protocol and network operation and build small networks in a simulated environment. At the end of the course, students build simple LAN topologies by applying basic principles of cabling; performing basic configurations of network devices, including routers and switches; and implementing IP addressing schemes.

    * What Are Networks?
    * Quality of Service (QoS)
    * Security
    * Communications with Data Networks and the Internet
    * Network Models
    * Protocols
    * OSI Application Layer
    * OSI Transport Layer
    * OSI Network Layer and Routing
    * Addressing the Network
    * IPv4
    * Overview of IPv6
    * Subnetting
    * Testing the Network Layer
    * OSI Data Link Layer
    * Media Access Control
    * OSI Physical Layer
    * LAN Technology
    * Ethernet
    * Address Resolution Protocol (ARP)
    * Shared Versus Dedicated Ethernet
    * Planning and Cabling Your Network
    * Network Diagrams
    * Configuring and Testing Your Network
    * Configuring Cisco Devices
    * Cisco IOS Basics
    * Applying a Basic Configuration Using IOS
    * Host Configuration
    * Verifying Connectivity
    * Monitoring and Documenting Networks
^ back to top

CCNA2
This is course describes the architecture, components, and operation of routers, and explains the principles of routing protocols. Students analyze, configure, verify, and troubleshoot the primary routing protocols RIPv1, RIPv2, EIGRP, and OSPF. By the end of this course, students will be able to recognize and correct common routing issues and problems. Each chapter walks the student through a basic procedural lab, and then presents basic configuration, implementation, and troubleshooting labs. Pocket Tracer (PT) activities reinforce new concepts, and allow students to model and analyze routing processes that may be difficult to visualize or understand.

    * Introduction to Routing and Packet Forwarding
    * Inside the router
    * CLI configuration and addressing review
    * Routing Tables
    * Path determination and switching functions
    * Router configuration labs
    * Static Routes
    * Summary and default static routes
    * Managing and troubleshooting static routes
    * Static route configuration labs
    * Dynamic Routing
    * Classifying dynamic routing protocols
    * Metrics
    * Administrative distances
    * Routing protocol and subnetting labs
    * Distance Vector Routing Protocol
    * Network discovery
    * Routing table maintenance
    * Routing loops
    * Basic RIPv1 configuration
    * Verification and troubleshooting
    * Automatic summarization
    * Default route and RIPv1
    * Troubleshooting
    * RIPv1 configuration labs
    * Classless Routing Protocols, VLSM and CIDR
    * Variable – length subnet masking (VLSM)
    * Classless interdomain routing (CIDR)
    * VLSM and classless routing labs
    * Configuring RIPv2
    * VLSM and CIDR with RIPv2
    * Verifying and troubleshooting RIPv2
    * RIPv2 configuration labs
    * Routing table structure
    * Classless routing behavior
    * Equal cost load balancing
    * Routing table lab
    * EIGRP
    * Basic EIGRP configuration
    * EIGRP metric calculation
    * Features of EIGRP
    * Establishing adjacencies
    * Diffusing Update Algorithm (DUAL)
    * More EIGRP configurations
    * Verifying and troubleshooting EIGRP
    * EIGRP configuration labs
    * Link
    * State Routing Protocols
    * Concept of link – state process
    * OSPF
    * Basic OSPF configuration
    * OSPF router ID
    * OSPF metric calculation
    * Establishing adjacencies
    * OSPF and multi-access networks
    * More OSPF configuration
    * Verifying and troubleshooting OSPF
    * OSPF lab configuration
^ back to top

CCNA3
This course helps students develop an in-depth understanding of how switches operate and are implemented in the LAN environment for small and large networks. Beginning with a foundational overview of Ethernet, this course provides detailed explanations of LAN switch operation, VLAN implementation, Rapid Spanning Tree Protocol (RSTP), VLAN Trunking Protocol (VTP), Inter-VLAN routing, and wireless network operations. Students analyze, configure, verify, and troubleshoot VLANs, RSTP, VTP, and wireless networks. Campus network design and Layer 3 switching concepts are introduced.

    * Ethernet Revisited
    * Switching Concepts
    * Cisco IOS Software and Cisco Discovery Protocol
    * Inside the Switch
    * Campus Network Design
    * Basic Switch Configuration
    * VLANs and IP Telephony Basics
    * Rapid Spanning Tree Protocol
    * Trunking and VLAN Trunking Protocol
    * Inter-VLAN Routing
    * Wireless Networks and Mobility
    * Campus LANs
^ back to top

CCNA4
This course explains the principles of traffic control and access control lists (ACLs) and provides an overview of the services and protocols at the data link layer for wide-area access. Students learn about user access technologies and devices and discover how to implement and configure Point-to-Point Protocol (PPP), Poin-to-Point Protocol over Ethernet (PPPoE), DSL, and Frame Relay. WAN security concepts, tunneling, and VPN basics are introduced. The course concludes with a discussion of the special network services required by converged applications and an introduction to quality of service (QoS).

Managing Traffic:
·          Access Control Lists
Addressing Hosts:
·          Network Address Translation
·          Dynamic Host Configuration Protocol and
·          IPv6 Basics
Security
Introduction to WAN Technologies
WAN Devices and Connections:
·          CSU
·          Cable Modem and
·          DSL Modem
Connecting to the WAN:
·          Leased Lines
·          Cable and
·          DSL
Point-to-Point Protocol and Point-to-Point over Ethernet
Frame Relay
QoS Considerations
Tunneling Concepts and VPN Basics
Converged Networks
^ back to top

Open Source Enterprise Resource Planning (ERP): Theory and Application
A Foundation for Understanding ERP Systems Using Open Source Technologies
Open Source Re-engineering and ERP Systems
Planning, Design and Implementation of ERP Systems
Open Source ERP Systems: Sales and Marketing
Open Source ERP Systems: Accounting and Finance
Open Source ERP Systems: Production and Materials Management
Open Source ERP Systesm: Human Resources 
Supply Chain Management and the eMarketplace
Managing ERP Projects Using Open Source ERP Software and Tools
Hands-on Case Studies and Group Project
^ back to top

PhilNITS FE Review
This review covers all IT topics in the textbooks for Fundamental Information
Technology Engineers. A PhilNITS mock examination will also be administered.

Day 1
1 - Basic Theories of Information
2 - Hardware
 
Day 2
3 - Basic Software
4 - Multimedia System
5 - System Configurations
 
Day 3
6 - Application Fields of Computer Systems
7 - Security
8 - Operations Research
 
Day 4
9 - System Development
10 - System Operation and Maintenance
 
Day 5
11 - Data Structures
12 - Algorithms
 
Day 6
13 - Internal Design
14 - Program Design
15 - Program Implementation
 
Day 7
16 - Protocols and Transmission Control
17 - Encoding and Transmission
18 - Network (LAN and WAN)
19 - Communication Equipment and Network Software
 
Day 8
20 - Overview of Database
21 - Database Language
22 - Database Management
 
Day 9
23 - Current IT Topics
24 - Practice Problems on PM Part Exam
 
Day 10
25 - Mock Test of AM Part PhilNITS Exam
26 - Mock Test of PM Part PhilNITS Exam 
^ back to top

Project Management
Day 1
  Introduction to Project Management
  The Project Management and Information Technology Context
  The Project Management Process Groups: A Case Study
 
Day 2
  Project Integration Management
  Project Scope Management
  More on Project Scope Management
  Project Time Management
 
Day 3
   Project 2007, Project Cost Management
 
Day 4
   Project Quality Management, Certifications
   Project Human Resource Management
   Project Communications Management
 
Day 5
   Project Risk Management and
       Project Procurement Management
   Final Exam, Final Project Presentations
^ back to top

Managing Information Technology (IT) Outsourcing
Key Factors Driving IT Outsourcing
Forms of Outsourcing
How Do You Manage IT and Software Service Outsourcing?
IT and Software Project Estimation
Planning Strategies and Methods of IT Outsourcing
Organogram of IT Teams
Offsite and Onsite Staffing/Recruitment of Skilled Personnel
Directing the Offsite and Onsite Teams
Controlling and Measuring the Key Performance Index
Likely Trends for the Next Decade
Implications for Companies Supplying Knowledge-Based Services
Implications for Companies Buying Knowledge-Based Products or Services
Implications for Government and Society
^ back to top

Introduction to Embedded Systems
Prerequisite:  C Programming

Course Description:
   This course is designed to teach the participants how
to program and design 8bit microcontroller embedded
systems. Although the microcontroller used in this
course is a Z8 microcontroller, with little effort, the
participants can easily learn how to use other
microcontrollers.
 
   Review of Hex and Binary
   Review of Digital Logic
   Essential Electronics
   Microcontroller Architecture & Organization
   Z8 microcontroller Features
   C Programming Review
   Using C for Z8 Microcontroller Programming
• IDE installation and configuration
• Polling
   Using C for Z8 Microcontroller Programming
• Interrupt Programming
• Built-in Timer Usage
• Serial Port Interfacing 
   Using C for Z8 Microcontroller Programming cont'd
• More Topics (TBA)
   Final Presentation
^ back to top

Introduction to Visual Basic .NET
Module 1: Introduction to the .NET Platform
Module 2: Using Microsoft Visual Studio .NET
Module 3: Working with Variables and Arrays
Module 4: Working with Procedures
Module 5: Working with Decision Loop Statements
Module 6: Structured Exception-Handling with Visual Basic .NET
Module 7: Object-Oriented Programming with Visual Basic .NET
Module 8:  Implementing Structured Exception Handling
Module 9:  Enchancing the Presentation of Windows Forms Application
Module 10: Web Forms and XML Web Services
Module 11: Accessing Data with ADO.NET
Module 12: Deploying Windows Applications Using Click Once
^ back to top

ASP .NET Programming
Module 1:  ASP .NET Primer
Module 2:  Working with Web Forms
Module 3:  Creating Web User Controls
Module 4:  Working with Data Using ADO.NET
Module 5:  Data Access with LINQ to SQL
Module 6:  Reading and Writing XML Data
Module 7:  Creating an ASP.NET AJAX Application       
Module 8:  Creating Silverlight-Based Application with Visual Studio 2008
Module 9:  State Management
Module 10: Creating and Consuming XML Web Services
Module 11: ASP .NET Security
Module 12: Configuring and Deploying ASP .NET Web Applications
^ back to top

C# Programming with Microsoft .NET
In this five-day instructor-led course, developers learn the fundamental skills that are required to design and develop object-oriented applications for the Web and Microsoft Windows by using Microsoft Visual C# .NET and the Microsoft Visual Studio .NET development environment. This course provides an alternative entry point for less experienced programmers who are not familiar with object-oriented design and programming with Windows or the Web.

   Module 1: Introduction to .NET
   Module 2: Understanding C# Language Fundamentals
   Module 3: Creating Objects in C#
   Module 4: Implementing Object-Oriented Programming Techniques in C#
   Module 5: Programming with C#
   Module 6: Building .NET-based Applications with C#
   Module 7: Using ADO.NET to Access Data
   Module 8: Creating Windows-based Applications
   Module 9: Using XML Web Services
   Module 10: Creating a Web Application with Web Forms
   Module 11: Application Settings and Deployment
   Module 12: Exploring Future Learning
^ back to top

Introduction to Oracle PL/SQL
   PL/SQL
   Cursors
   Functions
   Procedures
   Triggers
^ back to top

Basic Web Development
Basic HTML
   HTML & The World Wide Web
   Introduction To HTML
   HTML Elements
   HTML Text Formatting
   HTML Character Entities
   HTML Links
   HTML Frames
   HTML Tables
   HTML Lists
   HTML Forms
   HTML Images
   HTML Backgrounds
 
Advanced HTML
   HTML Layout
   HTML Fonts
   HTML Styles
   HTML Head
   HTML Meta
   HTML Uniform Resource Locators
   HTML Scripts
   Publishing Your Work
 
Cascading Style Sheets (CSS)
   Introduction To CSS
   CSS Syntax
   CSS How To...
   CSS Background
   CSS Text Properties
   CSS Font Properties
   CSS Border Properties
   CSS Margin Properties
   CSS Padding Properties
   CSS List Properties
   CSS Dimension Properties
   CSS Classification Properties
   CSS Positioning Properties
   CSS Pseudo-Classes Properties
   CSS Pseudo-Elements Properties
 
JavaScript
   Introduction to JavaScript
   JavaScript How To...
   JavaScript Where To...
   JavaScript Variables
   JavaScript Functions
   JavaScript Looping
   JavaScript Guidelines
   JavaScript String Object
   JavaScript Array Object
   JavaScript Date Object
   JavaScript Math Object
   JavaScript Window
   JavaScript Frames
   JavaScript Form Object
   JavaScript Browser Detection
^ back to top

PHP & MySQL
Introduction
   PHP History
   PHP Overview
   PHP Characteristics
   Why Learn PHP
   How PHP Works with the Web Server
   Hardware and Software Requirements
   Setting-up the Web Environment
   PHP Files & Apache
 
Writing PHP Statements
   PHP Statements
   Adding PHP into Web Documents
   Comments
 
Variables
   Naming Variables
   Creating & Assigning Variables
   Constants
 
Data Types
   Data Types in PHP
   FALSE Conditions
   Assigning Data Types
   Typecasting
   Operations
   Strings
 
Arrays
   Creating Arrays
   Using Arrays in Statements
   Arrays in List Statements
   Traversing an Array
 
PHP Programming Basics
   Reusing PHP Code
   Including Files
   Functions
   Variables in Functions
 
Web Applications
   PHP & HTML Forms
   Super Global Variables
   Saving State in PHP
   Cookies
   Sessions
 
Working with MySQL
   Using PHPMyAdmin
   Connecting to a MySQL Database
   Selecting a Database
   Inserting Data
   Retrieving Data
   Changing Data
   Deleting Data
^ back to top

Advanced PHP & MySQL
Day 1: Database Driven-Applications Reviewed
·         Database Revisited
·         SQL Joins
 
Day 2: Object-Oriented Programming in PHP
·         OOP Fundamentals
·         Class Methods & Properties
·         Constants, Static Methods, & Properties
·         Interfaces & Abstract Classes
·         Exceptions
 
Day 3: XML & Web Services
·         Introduction to XML
·         SimpleXML
·         DOM
·         Web Services
 
Day 4: Securing PHP Applications
·         Security Concepts
·         Website Security
·         Database Security
·         Session Security
·         File System Security
 
Day 5: Project Presentation
^ back to top

Search Engine Optimization (SEO)
Pre-requisites:
·         HTML (Basic Web Development)
·         Familiarity with Internet & WWW
Day 1:
·         Understanding SEO (AM)
Search Engine Basics
Creating an SEO Plan
·         SEO Strategies (PM)
Day 2:
·         Optimizing Search Strategies (AM)
·         Practicum & Workshop (PM)
Day 3 (2 weeks after Day 2):
·         SEO Maintenance & Project Results Presentation
^ back to top

C Programming
This course is a lecture and laboratory course that gives students theoretical background on designing programs (internal design process, functional decomposition, logical and physical data organization, creating reusable parts, etc.) and allows them to practice proper program design by creating programs in C, based on given specifications.

C Fundamentals
   Statements and Blocks
   Basic Data Types
   Constants and Variables
   Arithmetic, Logical, and Relational Operators
 
Control Structures
   if / if-else
   switch
   while, do-while, for loops
   break and continue
 
Subprograms
   Functions and procedures
   Parameters passing
 
Arrays, Strings, and Pointers
Command Line Arguments
Structures
File Handling
Dynamic Memory Allocation
^ back to top

C++ Programming
   Making and Using Objects
   The C in C++
   Data Abstraction
   Hiding the Implementation
   Initialization and Cleanup
   Function Overloading and Default Arguments
   Constants
   Inline Functions
   Name Control
   References and the Copy-Constructor
   Operator Overloading
   Dynamic Object Creation
   Inheritance and Composition
   Polymorphism and Virtual Functions
   Introduction to Templates
^ back to top

Java Programming I (Basic)
Day 1: Introduction to Computer Programming
      Introduction to Java
     Getting to Know Your Programming Environment
     Programming Fundamentals
           -Dissecting my first Java Program

Day 2: Programming Fundamentals
      Getting Input from the Keyboard
      Control Structures
           -Decision Control Structures (if, else, switch)

Day 3: Control Structures
         - Loops
        Java Arrays
        Command Line Arguments
        Working with Java Class Library
           -Introduction to Object-oriented Programming
           -Encapsulation
           -Classes and Objects
           -Class variables and methods

Day 4: Working with Java Class Libraries (con’t)
    Object-Oriented Programming
    Inheritance

Day 5: Polymorphism
    Basic Exception Handling
    Exceptions and Assertions
    Advance programming Techniques
    Tour of the java.lang Package
^ back to top

Java Programming II (Intermediate)
Day 1: Review of Basic Concepts in Java
        Advanced Programming Techniques

Day 2: Tour of the java.lang Package
        Text-Based Applications

Day 3: Abstract Windowing Toolkit & Swing
        GUI Event Handling

Day 4: Threads
        Networking

Day 5:  Advanced I/O Streams
        An Introduction to Generics
^ back to top

Java EE
Introduction to J2EE
Sample Servlet
Servlet/Container Interaction
Servlet Lifecycle
Generating Response
Handling Request Params
Request Forwarding
Data Passing
Web.xml
Deploying Servlet w/o IDE
Closing
JSP
Expressions
Scriptlets
Directives
Redirection with JSPs
JSP Implicit Objects
JavaBeans in JSP
Exercise
Closing
SQL
Database Setup
SELECT
INSERT
DELETE
UPDATE
JNDI (Java Naming and Directory Interface)
JDBC
Retrieving Connection
MetaData
Using DataSource
Exercise
^ back to top

Database Systems
The course includes overview of the database development process, entity relationship diagrams, relational analysis including normalization, physical database design, SQL, object-oriented databases, client-server and internet database environment, XML, transaction processing and concurrency control, data warehousing and data mining.
Requirements: Exercises and Project
Course Duration: 5 days
Prerequisites: None
Day 1
Introduction to Databases
Database Development Process
Entity Relationship Diagram
Exercises
Overview of Project Requirements
Day 2
Relational Analysis
Physical Database Design
SQL
Hands-on Exercises
Day 3
Object-Oriented Database Modeling
Object-Oriented Database Development
Overview of Commercial and Open Source Relational Databases
Overview of Commercial and Open Source Object Databases
Hands-on Exercises
Day 4
Client/Server Systems and Internet Database Environment
XML Databases
Transaction Processing and Concurrency Control
Hands-on Exercises
Day 5
Data Warehousing
Data and Database Administration
Distributed Databases
Project Presentation
^ back to top

Software Engineering
Product of Software Engineering
Process of Software Engineering
Project Management and Project Planning
Risk Management
Project Scheduling and Tracking
Configuration Management
Quality Assurance
Measurement Analysis
System Engineering
Analysis Concepts and Principles
Analysis Modeling OO Technique
Analysis Modeling Structured Technique
Design Concepts and Principles
Introduction to OO Design
Identifying Design Elements
Class, Message and Responsibilities
Structured Design
Low-Level Design
User Interface Design
Software Testing Methods
Object-Oriented Test Strategy
Software Testing Strategy
Deployment and Maintenance
^ back to top

Software Quality Assurance and Testing
Introduction
The Software Quality Challenge
What Is Software Quality?
Software Quality Factors
The Components of the Software Quality Assurance System: An Overview
Pre-Project Software Quality Components
Contract Review
Development and Quality Plans
SQA Components in the Project Life Cycle
Integrating Quality Activities in the Project Life Cycle
Reviews
Software Testing - Strategies
Software Testing - Implementation
Assuring the Quality of Software Maintenance
Assuring the Quality of External Participants' Parts
Case Tools and Their Effects on Software Quality
Software Quality Infrastructure Components
Procedures and Work Instructions
Supporting Quality Devices
Staff Training, Instructing and Certification
Preventive and Corrective Actions
Configuration Management
Documentation and Quality Records Controls
Software Quality Management Components
Project Progress Control
Software Quality Metrics
Software Quality Costs
SQA and Testing Software and Tools
Concepts and Applications
Hands-on Case Studies
The Future of SQA
The Future of SQA: Challenges
The Future of SQA: Tools for Overcoming the Challenges
^ back to top

Linux Network and Systems Administration
Linux 101
   Linux Desktop
   Hardware and Architecture
   Linux Installation and Package Management
   GNU and Unix Commands
   Devices, Linux Filesystems, and the
     Filesystem Hierarchy Standard
   The X Window System
 
Linux 102
   Kernel
   Boot, Initialization, Shutdown, and Runlevels
   Printing
   Documentation
   Shells, Scripting, Programming, and Compiling
   Administrative Tasks
   Networking Fundamentals
   Networking Services
   Security

Reference:
   Linux Professional Institute Level 1 Certification Program
^ back to top

Object-Oriented Analysis and Design Using UML
This introduces the concepts of Object-Oriented Analysis and Design. Also, it teaches the students about the Unified Modeling Language (UML). Students will learn how to construct Use Case diagrams, Class diagrams, Sequence diagrams, Collaboration diagrams, Activity diagrams, State-Chart diagrams, Component diagrams and Deployment diagrams.

Prerequisites:
To succeed fully in this course, students should be able to:
   Use a modeling tool such as Rational Rose, MS Visio or the like
   Program in an Object-Oriented programming language such as C++ or Java
 
Day 1:
   Overview of Object-Oriented Analysis and Design
   Object-Oriented Concepts
   Introduction to Unified Modeling Language (UML)
 
Day 2:
   Use Case Diagrams
   Class Diagrams
 
Day 3:
   Sequence Diagrams
   Collaboration Diagrams
 
Day 4:
   Activity Diagrams
   State-Chart Diagrams
   Component Diagrams
   Deployment Diagrams
^ back to top

IP Telephony
Paradigm Shift in Communication Traffic
Internet
What is Protocol?
What is Internet Protocol?
Internet Protocol Suite & OSI RM
Internet Protocol Suite & OSI RM
Basic Internet Protocol Suite
The IP Seven Layered Model
What is TCP?
TCP & OSI RM
Internet Protocol Telephony
IP Telephony
Concept of IP Telephony
IP Telephony Infrastructure
      COMPONENTS:
Terminal
Server
Gateway
Conference Bridge
Addressing
What is a Terminal?
What are Servers?
What are Gateways?
What is Conferencing Bridge?
What is an Address?
      TElephone Number Mapping (ENUM)
      IP Telephony
VoIP Services
      IP Telephony
VoIP Protocols
      IP Telephony
H.323 & SIP Protocol Stack/OSI RM
      H.323
Multimedia communication over ATM networks (H.310, H.321)
      H.323 timeline
H.323 version 2
      What is Quality of Service (QoS)?
      H.323 Network Architecture
      H.323 Communication Phases
      H.245 for media-oriented signaling
      Establishment of audio-visual communication
      H.323 Communication Phases
      Scope & Component Defined in H.323
      Functional/Logical Components of H.323
      Functional/Logical Components of H.323
      Structure and Scope of H.323
      H.323 Protocol Suite
      H.323 Call Set Up Scenario
      Basic Call Signaling & Conference Control Interactions
      Signaling Model
      Signaling Model
      Signaling Model
      Protocol Architecture
      H.323 Advantage
      What is SIP?
      SIP stands for Session Initiation Protocol
      SIP Network Architecture
SIP Network Elements
      User Agent
      Two Basic Types of Proxy Servers
      What is SDP?
      SIP Messages
      Other SIP Requests Messages
      Six Classes of Response
      SIP Transactions
      SIP Dialogs
      Protocol Architecture in SIP
      MGCP
Stands for Media Gateway Control Protocol
^ back to top

IT Security Analysis
Information Security Framework
Access Control and Site Security
Review of TCP/IP Internetworking
Attack Methods and Countermeasures
Host Hardening
Elements of Cryptography
Application Security
Managing the Security Function
^ back to top

Mobile Applications Development Using Java ME
Introduction to Mobile Applications Programming

Mobile Devices
  • Java 2 Micro Edition
  • CLDC
  • CDC
  • MIDP
  • MIDlets

Getting Started with Mobile Programming
  • “Hello, World!” MIDlet
  • Using NetBeans and Mobility Pack

High-Level User Interface
  • Display
  • Displayable
  • Command
  • Ticker
  • Screen
  • Item
  • Alert
  • List
  • TextBox
  • Form

Low-Level User Interface
  • Canvas
  • Graphics

Persistence Storage
  • Record Stores
  • Record Enumeration
  • Record Comparator
  • Record Filter

Networking
  • Generic Connection Framework
  • HTTP Connection
  • HTTPS Connection
  • TCP Sockets
  • Server Sockets
  • Datagrams

J2ME and Enterprise Computing
  • Servlets
  • JSP/JSTL
  • JDBC
  • XML Parsing

Optimizations
  • Program Execution
  • JAR Size
  • Networking
  • Memory Usage

Optional Packages
  • Overview
  • MMAPI
  • WMA

Other Topics
  • Timers
  • Push Functionality
^ back to top

Technical Communication for IT

I.    The Field of Technical Communication
•    Technical Communication's Role in IT
•    Technical Writing Team (Roles and Skills Set)
•    Industries

II.    Content Development
•    “The Content” (what we document)
•    Deliverables/Type of Documents and Formats (user guide, administration guide, installation guide, configuration guide, release notes, etc.)
•    Audience Analysis (end user, technical users)
•    Styles and Standards (use of active voice, present tense, etc)
•    Organization (structure of the book)
•    Minimalism
•    Case Study

III.    Tools: Overview and Brief Demo
•    Authoring Tools: FM, RoboHelp, Word, QuarkExpress
•    Graphic Tools: Snag It, Visio, PaintShop Pro, Corel
•    Publishing: Adobe Distiller (PDF), Webworks, Eclipse, MSHelp Workshop
•    Translation Tools: CAT, Translation Memories, Project Management
•    CMS Overview
•    Case Study

IV.    Process: Overview and Presentation of Industry Best Practices
•    Project Cycle
•    Documentation Life Cycle
•    Cross-Functional Team Integration
•    Scoping and Planning (schedules, documentation plans, budget)
•    Requirements
•    Prototyping
•    Reviews and Walkthroughs
•    Testing
•    Deployment
•    Evaluation/Post-Mortem
•    Tracking and Reporting
•    Case Study

V.    Critique of Work
•    Invite TW
•    Q&A
^ back to top


Microsoft Access 2007
Day 1:
1.    The Microsoft Access 2007 Interface
2.    Data Modeling
a.    Creating a Data Model
i.    Entity Relationship Diagram
ii.   Key and Non-Dey Fields
iii.  Types of Relationships
1.    one-to-one
2.    one-to-many
3.    many-to-many
b.    Transforming the Data Model into Tables
c.  Implementing the Data Model on the Target Database Platform

Day 2:
3.    Managing the Structure of Access Tables
a.    Creating a Blank Database
b.    Creating a Table
i.    Using Design View
ii.   Using Wizard
iii.  By Entering Data
c.    Saving a Table
d.    Opening a Table
e.    Renaming a Table
f.    Importing a Table and Its Columns
g.    Changing the Structure of a Table
h.   Closing a Table
i.    Deleting a Table
4.    Managing Table Relationships
a.    Configuring Relationships Between Tables
b.   Modifying the Type of Join (Inner Join, Left Outer Join, Right Outer Join)
c.    Enforcing Referential Integrity and Other Constraints   
d.    Using Subdata Sheets
5.    Managing Access Records
a.    Adding a Record
b.    Editing a Record
c.    Deleting a Record
d.    Selecting a Record
e.    Copying a Record
f.    Sorting and Filtering Data
g.    Select Query
h.    Parameterized Queries
i.    Cross-tab Queries

Day 3:
j.    Action Queries
i.    Make-Table Query
ii.    Append Query
iii.    Update Query
iv.    Delete Query
6.    Creating and Configuring Access Forms
a.    Creating a Form in Design View
b.    Creating a Form by Using the Wizard
c.    Editing Form Properties
i.    Using Operators, Expressions and Functions
ii.   Using the Expression Builder
d.    Incorporating Charts on Forms
i.    Chart Properties
ii.   Chart Types
e.    Using Subforms
f.    Customizing a Form in Design View
g.    Customizing a Form in PivotTable or PivotChart View

Day 4:
7.    Creating an Configuring Access Reports
a.    Creating a Report
b.    Customizing a Report
c.    Publish a Report Snapshot to the Web
8.    Importing and Exporting Data
a.    Importing and Exporting Microsoft SQL Server Tables
b.    Importing Excel to Access and Exporting Access to Excel
c.    Importing a Text File to Access and Exporting Access to a Text File
d.    Importing an XML File to Access and Exporting Access to an XML File
e.    Importing an HTML File to Access and Exporting Access to HTML
f.    Integrating Access with MS Word’s Mail Merge
g.    Importing the Contacts Table from Outlook

Day 5:
9.    Access Projects
a.    Creating an Access Project
b.    Access Project Property Page
10.    Access Macros and Modules
11.    Project Presentation
^ back to top

UP Information Technology Training Center - Helping You Build a Solid IT Career