ExitCertified - USA
Las Vegas, Sacramento, San Francisco, San Jose, United States
http://www.exitcertified.com

IBM Informix Dynamic Server Administration

Develop the skills necessary to successfully administer one or more database servers. Learn how to configure and initialize a database server instance, configure and test client connectivity, configure and manage memory and disk usage, plan and implement system maintenance tasks, and configure the server for optimal Online Transaction Processing (OLTP) or decision support....
 

Learn how to perform, basic and advanced, database administrative tasks using IBM DB2 Universal Database. These tasks include creating and populating databases and implementing a logical design to support recovery requirements. Examine access strategies and describe strategies chosen by Optimizer using Explain tools. Use the db2diag.log file messages to direct your investigation of problems by ......
 

Acquire the skills necessary to produce application programs that manipulate DB2 databases. Emphasis is on embedding SQL statements and preparing programs for execution....
 

Through lectures and machine lab exercises, learn how to recognize when an IBM DB2 stored procedure is the correct solution for an application, how to use the Development Center, how to CALL a stored procedure, how to create a stored procedure using Data Definition Language (DDL), and how to troubleshoot a stored procedure. Learn about coding stored procedures in DB2 SQL Procedure Language ......
 

Learn the components of DB2 UDB for z/OS and OS/390 data sharing and how to plan for and implement DB2 data sharing on the z/OS and OS/390 platforms. Learn how to set up a naming convention by renaming a non-data sharing DB2, enable a two-way DB2 data sharing group on a Parallel Sysplex OS/390 environment, verify and test data sharing functions, and create a database in the data sharing group....
 

Learn how to perform database administration using IBM DB2 UDB in a partitioned environment on UNIX. These tasks include installing DB2 UDB in a partitioned environment, creating and populating databases, designing a database for parallel use, examining data for parallel queries, and using DB2 UDB utilities. ...
 

In this workshop, begin with a short, but intensive lecture period to explore a wide range of configuration and tuning issues in the IBM Informix Dynamic Server environment. Spend the remainder of the workshop working on a real-world decision support and Online Transaction Processing (OLTP) system, and getting extensive, hands-on experience configuring and tuning IBM Informix Dynamic Server on ......
 

Learn how to perform database administration tasks using DB2 UDB for Linux, UNIX, and Windows. These tasks include creating DB2 instances, creating and populating databases, and using logical design to support concurrency and recovery requirements. Use a Windows operating system during hands-on labs....
 

Learn how to perform database administration tasks such as creating DB2 instances, creating and populating databases, and using logical design to support concurrency and recovery requirements with DB2 UDB for Linux, UNIX, and Windows. Use an AIX operating system during hands-on labs....
 

Learn how to perform database administration tasks such as creating DB2 instances, creating and populating databases, and using logical design to support concurrency and recovery requirements with DB2 UDB for Linux, UNIX and Windows. Use a Linux operating system during hands-on labs....
 

Learn about SQL and how it applies to the entire DB2 UDB Family. This course is appropriate for individuals working in an OS/390, VM/VSE, AIX, or Windows environment. Complete extensive hands-on exercises to develop your skills to use the SQL you learn. Perform these exercises either by using the DB2 UDB for Linux, UNIX, or Windows product in a Windows environment or by using the DB2 UDB for z/......
 

Learn the functions and components of IBM DB2 UDB, a relational database manager, which may be installed on a variety of operating systems. DB2 UDB runs under z/OS and OS/390 on MVS, VM, AIX, Linux, HP-UX, Sun, and Windows operating systems. Discuss the DB2 UDB products and services. Focus on the services DB2 UDB provides and how they work, not on DB2 UDB internal workings. If you are i......
 

This course replaces CF113. Learn how to take advantage of advanced programming techniques to access DB2 databases in the workstation environment. You can use these techniques in addition to the standard embedded SQL calls that you learned in the prerequisite course: DB2 UDB Programming Fundamentals (CF104) ...
 

Address the use of the data quality assurance methodology and the AuditStage software in a DataStage XE warehouse application. Get a conceptual overview of data quality assurance in a warehouse, followed by detailed instruction in the use of the AuditStage manager software. Learn to organize a data quality analysis project and to build and package data filters to perform quality analysis. Concl......
 

Learn how to plan for, install, configure, manage, and perform problem isolation on an IBM TotalStorage DS4000 (formerly Fibre Array Storage Technology (FAStT)) Storage Area Network (SAN) in this hands-on course. Emphasize using Storage Manager and TotalStorage Productivity Center (TPC) to manage and monitor all aspects of the SAN....
 

Using the DataStage Mainframe edition, learn to build Extraction, Transformation, Load (ETL) jobs that run on the mainframe. These jobs extract data from a variety of native mainframe sources, including Common Business Oriented Language (COBOL) files, DB2 tables, Information Management System (IMS) databases, and Teradata databases. After transforming the data, these jobs can load the data into......
 

Gain knowledge on WebSphere Information Integrator Queue (Q) Replication’s use of WebSphere MQ to perform queue based data replication activities between IBM relational database systems and between IBM and non-IBM relational database systems. Learn to use Q Replication’s highly parallel, transaction based, asynchronous message based transmission capability. Compare Q Replication’......
 

In this course, updated to IBM Query Management Facility (QMF) Version 8, build on your previously acquired knowledge of SQL and DB2. Learn how to use QMF to access data and how to use QMF’s very powerful report formatting capabilities to produce tailored reports. Learn to direct QMF’s activities using the QMF command language and the ins and outs of writing QMF Procedures (PROCs)......
 

Learn about the features of DB2 UDB Data Warehouse Edition (DWE) Version 8.2. Create user / system profiles and management classes in Query Patroller in order to maximize the throughput of your DB2 UDB for Linux, UNIX, and Windows system. Use DB2 Alphablox to access DB2 tables defined as a star schema as though they were a multidimensional database.Through extensive hands-on exercises, use the ......
 

After an overview of relational concepts that are important for designing relational databases, learn about the different views of the data of the application domain and the steps included in this comprehensive relational database design methodology. These steps include: Analyzing a problem statement for an application domain Establishing an Entity Resolution (ER) model to visualize a......
 

Pages:- 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15

School Index A~Z: A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z