|
Visual Studio
|
beginning
|
Visual Studio is an integrated development environment developed by Microsoft. You will learn the product difference with Visual Studio 2003, 2005, and 2008. You will learn how to get the most out of using visual studio to develop desktop, enterprise, or web products on a 2 tier or n tier system.
Related Microsoft courses: 3402, 2310, 6463, 2364
|
Basic programming, us of windows operating system
|
|
|
Access 2003 Basic
|
Beginners
|
In summary, learn how to plan and create a database, work with tables, create queries and forms, filter records, and generate reports. Specifically in this course, learn what a database is, how to create a database, design a database, create relationships, make tables, import/export data into tables, create various types of queries by asking question from the database, generating forms to enter data and analyze or view data in the database, and create reports on data in the database from various tables or queries that collect or join data from multiple tables
|
Basic knowledge of computer using the XP operating system and Microsoft Excel
|
|
|
Access Intermediate
|
Intermediate
|
In summary, Students will learn how to set table relationships, work with Lookup fields and subdatasheets, create join queries, create PivotTables and PivotCharts, and use hyperlink fields and data access pages. In this course learn more sophisticated queries and condition your data, validate data entry, also create more sophisticated forms and reports with making them available outside access and on the web, be introduced to creating macros to perform special actions on forms and reports
|
Understanding of the Access Basic course.
|
Access Level 2
|
|
Access Advanced
|
Advanced
|
Students will learn how to: query with SQL; use crosstab, parameter, and action queries; create and run macros; import, export, and link database objects; optimize, replicate, and synchronize databases; and maintain database security. In this course learn how to make more sophisticated macros and extend the capabilities of access with programming in Visual Basic for Applications, create pivot tables and pivot graphs to view multidimensional data, how to administer the database by backing up your database and managing its growth with splitting and linking to external database
|
Understanding of the Access Intermediate course
|
Access Level 3
|
|
Sql Server 2000 Implementation
|
beginning to advanced
|
Objective: To become a database developer and administrator and
Prepare you for the MCDB(Microsoft Certified DataBase Admin and Developer) Certificate:
Target: This course is appropriate for anyone who will be implementing and maintaining SQL Server 2000 databases and database applications. This includes implementation in small LANS, large enterprises, or any environment in between. It will also be helpful for anyone involved with database applications design and anyone considering SQL server as part of a business solution. This course can be used for test preparation for the Microsoft 70-229, Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition.
Course Objectives: You should share these overall course objectives to know what to expect overall for this course. After completing this course you shall know to:
• Identify SQL Server features and editions. Explain how SQL Server is organized and identify SQL Server objects.
• Analyze business requirements and design a database solution
• Create and manage a database and files
• Create and manage user – defined data types and user tables
• Use bulk loading procedures to load and transfer data. Design a replication solution to meet business requirements.
• Use SQL queries to retrieve, organize, and summarize table data.
• Create and test batches, views, stored procedures, and user defined functions (UDFs)
• Use insert, UPDATE, DELETE to manipulate data. Manage transactions, cursors, and triggers.
• Monitor and optimize database performance.
Related Microsoft courses: Microsoft 2071 and 2073
|
Access, Data base management, and SQL 1-2.
|
2071, 2073
|
|
Sql Server 2005 Database Developer
|
beginning to advanced
|
This course prepares you for passing the 70-431 exam to become a database technology specialist.
Course Coverage:
* 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.
* Implement data integrity in Microsoft SQL Server 2005 by using triggers.
* Implement views.
* Implement stored procedures.
* Implement functions.
* Implement managed code in the database.
* Manage transactions and locks.
* Use Service Broker to build a messaging-based solution.
* Use Notification Services to generate and send notifications.
|
Sql 1 and 2 suggested before learning T-SQL. SQL Server 2000 suggested.
Recommended to complete:
* Course 2778: Writing Queries Using Microsoft SQL Server 2005 Transact-SQL.
* Course 2780: Maintaining a Microsoft SQL Server 2005 Database.
|
2779
|
|
Sql Server 2005 Data Base Administration
|
beginning to advanced
|
This is the second course that prepares you for the 70-431 exam as a database technology specialist. Requires completion on 2779 and 2780 for adequate preparation for the 70-431 exam.
Course Coverage:
* Install and configure SQL Server 2005.
* Manage database files.
* Backup and restore databases.
* Manage security.
* Monitor SQL Server.
* Transfer data into and out of SQL Server.
* Automate administrative tasks.
* Replicate data between SQL Server instances.
* Maintain high availability.
|
Recommended pre-requisites:
* Course 2778: Writing Queries Using Microsoft SQL Server 2005 Transact-SQL.
* Course 2779: Implementing a Microsoft SQL Server 2005 Database.
|
2780
|
|
Database Management
|
Beginning to advanced
|
Gives you a solid foundation in practical database design and implementation. The course provides in-depth coverage of database design, demonstrating that the key to successful database implementation is in proper design of databases to fit within a larger strategic view of the data environment. Included in this course is Unified Modeling Language coverage, expanded coverage of SQL Server functions, all-new business intelligence coverage, and added coverage of data security. With a strong hands-on component that includes real-world examples and exercises, this book will help students develop database design skills that have valuable and meaningful application in the real world.
|
XP and windows , Excel
|
DB Man
|
|
Oracle Administration I
|
beginning to advanced
|
Learn to perform day-to-day duties of a database administrator using Oracle 10g. Course covers initialization parameters, table space storage, data integrity, constraints, and user profiles. Course can prepare students for the update Oracle certification exam, Database Fundamentals I (#1Z0-041).
|
Oracle Sql and PL/SQL
|
Oracle Admin I
|
|
Oracle Administration II
|
beginning to advanced
|
Learn to perform day-to-day duties of a database administrator using Oracle 10g. Course covers key tools and techniques used for Oracle database backup, recovery and network administration. This course prepares students for the update Oracle certification exam, Database Fundamentals I (#1Z0-043).
|
Oracle Administration I
|
Oracle Admin II
|
|
IBM Maximo V6 EAM Implementation
|
beginning
|
This course will provide you with the foundation and tools to automatically inventory and
manage your assets for your organization.
Course Coverage:
1. Inventory Management
2. Bar coding
3. Inventory Standardized Codes
4. Asset Tagging
5. Tracking and Monitoring Asset and Asset Actions - IMAC
6. Software
7. Auto Discovery
8. Services
9. Inventory Costs
10. Standards and Regulations that necessitate inventorying
|
None
|
000-906
|
|
Inventory and Asset Management
|
Beginning
|
Learn the process of inventory management and be empowered with an organized inventory system. Gain knowledge and tools to automate and organize your business's inventory to pass your audits, maintain your compliance and regulatory requirements, and avoid fines.
Topics covered:
1.Auditing, Compliance, and regulation
2. Inventory and Asset Tagging
3. Bar coding technologies
4. Process and Cost Analysis
5. Cataloging inventory
6. Inventory Systems available
7. Auto-discovery: Automated identification
8. Reconciliation
9. Licensing and Contract Management
10. Materials management and Preventative Maintainability
11. IMAC: Asset Actions
12. Integration
14. Economic Justifications and TOC
15. Procurement
|
High school or college degree
|
|
|
Virtualization
|
Beginning to intermediate
|
Class covers several of the most popular virtual machine software widely used today (VirtualPC, Virtual Server, VMware). Learn virtualization concepts and how to choose the right virtualization product for your needs. Learn to download, install and use VMWare Workstation 6, VMWare Server, Microsoft Virtual PC 2007, and Microsoft Virtual Server 2005. Also covers the creation, configuration, and management virtual machines.
|
basic knowledge of operating systems such as XP, Vista, Windows Server, Linux, Unix, or Mac OS
|
|
|
Information Architecture
|
Beginning
|
An Information System requires knowledge of security, networking, and computer systems. But most importantly requires knowledge of customer requirements, definition of the problems, and ability to propose solutions that suite customer needs and budgets. Learn the organization of information and how to develop systems that achieve the needed faster transitions from innovation idea, prototype, and finally to market in order to increase market share. In this module you will learn that an Information Management System (IMS) is a major automation tool to achieve business objectives. In order to automate the process of information creation and dissemination in your organization, you will learn how to select IT services an d how to implement and use an IMS. In addition, you will learn the economic advantages and commercial value. In this course you will learn flow charting software, use cases, Object Diagrams, Functional, Data flow diagrams and more.
|
Visio, MS Office, XP
General familiarity with the Internet and some other operating system.
|
|
|
Economic Justification
|
Beginning
|
Deciding on laboratory equipment, tools, and software involves due diligence in order to make the most cost effective decision with the great return on investment. This module shall review the process and the formulas which will help you economically justify your commercial decisions.
Course Topics:
Lecture 1. Introduction: Overview and Definitions
Lecture 2. Types of Laboratory Robots/History
Lecture 3. Integrated Laboratory Automation
Lecture 4. Overview of the Major Vendors Supplying Laboratory
Automation
Lecture 5. Introduction to Economic Analysis
and the Time-Value of Money, the “amortization”
problem
Lecture 6. Costs of Laboratory Research and Laboratory Automation
Lecture 7. Comparing Manual, “Islands” of
Automation and “Full” Automation Alternatives
Lecture 8. Long Term Planning Issues - Budgets and Leases
Lecture 9. Example Case Study as Introduction to
Students Final Projects
Lecture 10. Students Present Case Studies or I Will Present Salient
Points, End of Class
|
Management experience, some sales or purchasing, engineering background may help
|
|
|
Laboratory Automation
|
Beginning
|
Today's increasingly competitive business environment continues to emphasize on the use of automation technology to improve laboratory productivity, to accelerate discovery, and to maintain quality. Knowledgeable planning and implementation is key to successful automation applications. This is an introductory course, aimed at those considering automating their laboratory operations and those managing increasingly automated laboratories.
The course will cover:
1. Reasons for employing laboratory automation.
2.Planning, implementing and maintaining successful automation applications.
3.Automation specific issues involving documentation, validation, open systems and standards.
4.A discussion of system integration including communication architecture, software for system control and scheduling, error handling, automatic ID, sensors, vision systems and data transfer.
5.Understanding the relationship of automation and informatics, and the various options, tools and strategies that may be employed to manage automation-generated data.
6.A preview of emerging technologies that will have an impact on laboratory automation including nanotechnology, microfabrication and microfluidics.
|
Excel, XP, Windows
Basic Lab Tech experience or familiarity may help
|
|
|
Laboratory Information Management Systems
|
Beginning
|
Library Information Management Systems (LIMS) address the industry pressure to shorten new product development times and authenticate and validate information associated with products. A LIMS helps an organization achieve the needed faster transitions from innovation idea, prototype, and finally to market in order to increase market share. In this module you will learn that a LIMS is a major automation tool to achieve laboratory objectives. In order to automate the process of information creation and dissemination in your organization, you will learn how to select a LIMS and how to implement and use a LIMS. In addition, you will learn the economic advantages and commercial value of a LIMS.
Course Topics:
1. Developing the overall strategy for a project via a LIMS matrix: High level prioritization of the functions and phasing of the project. Covers what is a LIMS, the full scope of a system within an organization and approaches to implementing the system, replacing an existing system. Use of a commercial LIMS in a combinatorial chemistry environment.
2.Overview of the system development life cycle of a LIMS.
3.User requirements specification: Why is it important? What is it? Role of prototyping in developing user requirements? Understanding your working practices and processes.
4.Role of the Users in a LIMS project.
5.Validation of a LIMS: life cycle approach and the documented evidence required for systems in a regulated environment.
6.Risk assessment of a project throughout the project life cycle.
7. LIMS products and tools
|
Software understanding
Life Science background
Systems background helps.
|
|
|
Introduction to Bio-Informatics
|
Beginning
|
Bioinformatics is an ever growing field of study. Both Biotechnology driven and Pharmaceutical companies have become very reliant on the tools of data mining and informatics. The field of informatics has grown into three areas that you will become familiar with and those areas are bio-informatics, chemi-informatics, and molecular modeling. In this course, you will become acquainted with the tools and resources for applying bioinformatics.
The course will cover:
1. Instrumentation generating data for bioinformaticists such as Readers, detectors, sequencers.
2.Snaps and micro array data.
3.Data collection- data collected and what information is usually sought.
4.Data mining - mining genes and proteins to understand gene function and find lead drugs.
5.Bioinformatics Tools and Products.
6.Programming Languages for Gene Discovery.
|
Lifescience and programming in some language would help
|
|
