|
CHOOSE A CATEGORY BELOW:
All Classes |
Administration |
Application Development |
Business IT
Business Management |
Certification |
Database Classes |
Media & Design |
Microsoft
Networking Classes |
Operating Systems |
Programming |
Project Management
Security |
Soft-Skills |
Storage |
Virtualization |
Web Development
|
| ArcGIS Desktop is ESRI's full-featured GIS software for visualizing, creating, managing, and analyzing geographic data. This course provides the foundation for becoming a successful ArcGIS Desktop user. Students learn fundamental GIS concepts and become familiar with the range of functionality available in the software. In course exercises, they work with ArcGIS Desktop and see how it provides a complete GIS software solution. |
|
|
| ArcGIS software offers many tools for visualizing, creating, managing, and analyzing geographic data. In this course, students extend their ArcGIS skills in the areas of cartography, data automation and editing, and geoprocessing and spatial analysis. Students work with advanced cartographic tools as they learn how to efficiently create effective maps. A major focus of the course is the geodatabase. Students learn database design considerations and techniques for creating, maintaining, and managing GIS data stored in a geodatabase. The ArcGIS geoprocessing tools for spatial analysis are also covered and, in a course project, students apply many of their newly acquired skills. |
|
|
ArcGIS Desktop software is an integrated system that includes all the tools needed to get the most out of a GIS. This course introduces fundamental concepts of GIS and the major functionality contained within ArcGIS Desktop software. In course exercises, students follow the GIS analytical process and work with a variety of tools to solve realistic problems. This course emphasizes practical GIS skills. |
|
|
| Gain experience using Informix data movement utilities, including SQL LOAD and UNLOAD, dbload, dbexport, dbimport, onpload, and the High Performance Loader (HPL). |
|
|
| Learn the Data Manipulation Language (DML) portion of SQL. |
|
|
| This course provides an in-depth view of the features and functionality of Access 2007. You learn to upsize Excel spreadsheets, develop and support robust Access systems, manipulate and query data, develop forms and design sophisticated data analysis reports. |
|
|
| Modern database solutions require a seamless integration of specific user requirements with Access objects. In this course, you gain the skills necessary to create intelligent forms by manipulating properties, executing methods, and incorporating business logic to create a complete solution. |
|
|
| SQL Server 2000 extends the performance, reliability, and ease-of-use of previous versions and provides a database platform that scales up and out to meet the needs of large online transaction processing (OLTP), data warehousing, and e-Commerce applications. It will also scale down to meet the needs of individual desktops and portable devices. This course will teach you to install and administer SQL 2000, create and manage database files, and understand how to program a basic query. |
|
|
| Get the knowledge and skills you need to maintain a Microsoft SQL Server 2005 database in this 5-day course. Learn how to use SQL Server 2005 product features and tools related to maintaining a database. |
|
|
| Get the knowledge and skills to implement a Microsoft SQL Server 2005 database in this course. Learn to use SQL Server 2005 product features and tools related to implementing a database. Make the most of Microsoft SQL Server 2005's many new features for Developers to increase flexibility, productivity, scalability, and performance. Examine .Net integration, Native XML Data Type, SQL Service Broker, Native Data Encryption, Notification Services, Web Services, ADO.Net 2.0, SQL Server Management Studio, Business Intelligence Development Studio, and integration with Visual Studio 2005. In this course, you will explore the new and existing features using the development of example applications as a solution-based training model. |
|
|
This instructor-led course provides students with the knowledge and skills to implement database using the new Microsoft SQL Server 2008 language. The course focuses on teaching individuals how to use SQL Server 2008 product features and tools related to implementing a database. Changes and updates from MS SQL Server 2005 will also be examined. This course is intended for experienced SQL Server 2005 developers and database administrators who want to upgrade their skills to SQL Server 2008. |
|
|
| Structured Query Language (SQL) is a standard language that allows users to query data from databases, update information within databases, create and delete tables, rows and columns, and control access to data. It is included in products other than databases, and many familiar programming languages are designed to work with embedded SQL. Many of these products support SQL with proprietary extensions, but all such products support a common subset of SQL. This course focuses on that common subset of SQL used by over 100 databases, languages and software applications. |
|
|
| The course is designed for Database Administrators and others who wish to monitor and tune MySQL. This course will prepare each student with the skills needed to utilize tools for monitoring, evaluating and tuning. Students will evaluate the architecture, learn to use the tools, configure the database for performance, tune application and SQL code, tune the server, examine the storage engines, assess the application architecture, and learn general tuning concepts. |
|
|
| This course provides a comprehensive introduction to the MySQL relational database management system (RDBMS). You gain the skills needed to administer and maintain MySQL databases while addressing scalability and reliability issues. |
|
|
This class covers the fundamentals of SQL and relational databases, using MySQL as a teaching tool. |
|
|
| In this class, students will learn how to create, retrieve, and manipulate objects in Oracle10g Structured Query Language (SQL). Students will also be introduced to Oracle10g database features and tools. The Oracle10g release has greatly enhanced the features and functionality of PL/SQL. Students will learn the fundamentals of the PL/SQL programming language. Students will write stored procedures, functions, packages, and triggers, and implement complex business rules in Oracle. Students will learn programming, management, and security issues of working with PL/SQL program units. Programming topics will include the built-in packages that come with Oracle, the creation of triggers, and stored procedure features. |
|
|
| The Oracle10g release has greatly enhanced the features and functionality of PL/SQL. Students will learn the fundamentals of the PL/SQL programming language. Students will write stored procedures, functions, packages, and triggers, and implement complex business rules in Oracle. Students will learn programming, management, and security issues of working with PL/SQL program units. Programming topics will include the built-in packages that come with Oracle, the creation of triggers, and stored procedure features. |
|
|
| This class will develop the key fundamental skills necessary to be an Oracle DBA. Students will design and create a server using the Optimal Flexible Architecture (OFA), configure logical and physical structures, set up database and user security, add and administer users, and monitor and tune main server areas. Each student will create a toolkit of administration scripts for database management and tuning by the end of this class. This class will also address issues for DBAs having to support Oracle8i and Oracle9i databases. |
|
|
| This class will introduce the experienced Oracle DBA to the new features contained in Oracle Database 10g. As students are introduced to the various new features, labs will reinforce the material presented in this course. Once this course is completed, the student will have gained the foundational knowledge to begin to administer Oracle10g databases. |
|
|
| In this class, students will learn how to create, retrieve, and manipulate objects in Oracle10g Structured Query Language (SQL). Students will also be introduced to Oracle10g database features and tools. Students will go on to develop deeper insight into relational database design and RDBMS operation, learn concepts and specific SQL syntax for extended Oracle datatypes, learn analysis and tuning techniques to increase SQL performance, and master advanced features of Oracle SQL for large data sets and data warehouses. |
|
|
| Master the architecture and capabilities of the ORACLE9i database server. Create and manage database users and implement a security system to control user and system activities. Implement a backup strategy and perform recovery in the event of system failure. There will be an examination of the alternatives for loading a table based upon an understanding of data loading facilities. |
|
|
This course includes an overview of six sigma concepts, required infrastructure, expected benefits, enterprise level metrics, the DMAIC method for achieving breakthroughs in performance, project selection, and project management. |
|
|
| This course includes an overview of six sigma concepts, required infrastructure, expected benefits, enterprise level metrics, and the DMAIC method for achieving breakthroughs in performance. |
|
|
| This course covers JMP software's approach to data manipulation and analysis, measurement systems analysis, design of experiments, and statistical process control in direct support of DMAIC breakthrough projects. |
|
|
| Learn to tune Adaptive Server Enterprise (ASE) for optimal performance and explore ASE architecture in depth. Study topics that include designing databases for performance, diagnosing and correcting performance problems, managing ASE system resources (CPUs, disks, I/O), optimizer statistics, SMP features, relevant data structures, benchmarking turning methodology and techniques, table partitions, and parallel processing. Examine the use of Sybase performance monitoring utilities (Monitoring Tables, sp_sysmon, system Stored Procedures) and major performance trade-offs. Gain insight on choosing appropriate locking schemes. |
|
|
| Learn how to identify the major tasks of Sybase system and database administration and practice these tasks using your own Adaptive Server Enterprise (ASE) in a safe and controlled environment. Emphasis is given to resource management (memory, disk, and tempdb space with a goal of creating a reliable Adaptive Server environment. Examine fundamental monitoring and troubleshooting methods, backup and recovery strategies, job scheduling and user access issues. |
|
|
