ExitCertified - Canada
Ottawa, Toronto, Vancouver, Calgary, Edmonton, Winnipeg, Canada
http://www.exitcertified.com/

iSeries Database Using SQL

This course applies to iSeries, AS/400e, and AS/400 systems. SQL is a very powerful programming and database language that is widely used in business today. For example, SQL can be used to perform interactive database queries as well as to extract data from a server and pass that data to a Java applet running on a client PC. SQL is frequently used in AS/400 high level languages as an altern......
 

Learn how to manage workloads on the AS/400 system, measure system performance, and tune the operating system to meet processing requirements. Use the system functions that are available for controlling workload and tuning system performance during hands-on exercises. Evaluation criteria presented in this course are based on the latest information available from IBM development labs. If ......
 

This course applies to the iSeries, AS/400e, and AS/400 systems. Learn to write easy to use and efficient Control Language (CL) programs that require little or no involvement by system operators. Also, learn how to write user commands and modify commands provided by IBM. Practice these skills in hands-on exercises. In some instances, you are provided with several exercises. You choose the o......
 

Learn basic and advanced concepts of Logical Partitioning (LPAR) for the iSeries POWER5-based servers. Begin with an overview of LPAR on the iSeries, followed with very detailed information on configuration planning and implementation using hands-on exercises to create and implement logical partitions. Also, learn about partial processors, dynamic allocation and reallocation of memory, processo......
 

This is the foundation course for individuals interested in learning the concepts of the OnDemand system. Get a basic overview of an OnDemand system and learn about creating users, groups, applications, application groups, storage sets, and folders. Examine the tasks required to index, load, retrieve, and view Extended Binary Coded Decimal Interchange Code (EBCDIC) line documents in an OnDemand......
 

Develop the system administration skills you need to manage, maintain, and troubleshoot UniVerse systems. Gain experience analyzing sample database files and system parameters to tune and optimize performance. Learn how to modify terminal definition files to correct terminal behavior, such as proper arrow key and function key operation. Learn about and use the different data file types, alterna......
 

This course covers the Data Manipulation Language (DML) portion of Structured Query Language. Learn to create SELECT, INSERT, UPDATE, DELETE, LOAD, and UNLOAD statements, simple and complex joins, and subqueries....
 

Learn how to manage a UNIX or Windows-based IBM UniData relational database management system. Learn how to install and configure the software, manage data files, define and maintain security, and monitor system performance. Explore the relationship between UniData and the operating system....
 

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......
 

Pages:- 1 2 3 4 5 6 7 8 9 10 11

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