StayAhead Training Ltd courses

...Counts Define an ABC Compile Define ABC Classes Define an ABC Assignment Group Assign Items to an ABC Assignment Group Setting up a Cycle Count Performing... Learn about: Defining and Maintaining a Physical Inventory, Receipting Returns and Writing off Damaged Goods...

...and basic functions Insert, update, delete and replace data Create and. Suitable for: New or existing users of MySQL, who have little or no previous experience... Learn about: Using client programs to access a MySQL database...

...on the Introduction to MySQL course. The content of the course covers the topics required for the Certified MySQL Developer I examination. Delegates... Learn about: Replace and Truncate Operations, Performing advanced Insert...

...be able to understand the architecture of an Oracle database and to identify the Oracle data types and database structures. Note: There is no practical content to this seminar...

...which use some or all of the primary PL/SQL programming constructs. Together with the PL/SQL Stored Program Units course, this course is suitable for delegates...

...program units and packages. Objectives: By the end of this course, the delegate will be able to write and manage stored program units, implement package constructs and features... Learn about: Stored program units and packages, To provide the skills needed to develop, Write and maintain triggers...

...It also introduces some of the Oracle-supplied packages. Skills Gained The delegates will practise: Writing and running PL/SQL programs from SQL*Plus... Learn about: To provide the skills needed to develop, Write and maintain PL/SQL scripts, Stored program units and packages...

...and Java programs from PL/SQL;use fine-grained access control; use LOB data types and the DBMS_LOB package; use SecureFile LOBs; effectively design cursors...

...methods for a database Oracle environment variables Install Oracle software using the Oracle Universal Installer (OUI) Use the Database Configuration Assistant (DBCA)...

...report queries Building reports in various different formats Applying queries, groups, calculations and summaries to a report Editing and manipulating...

...Delegates: This course is designed for Application Designers/Developers, Software Developers, Web Developers and Oracle Forms and Reports Developers... Learn about: Software developers, Web developers...

...This course aims to give delegates practical experience in installing Oracle Database 11g software, configuring the database, performing basic monitoring... Learn about: Creating an Oracle database...

...Anyone who needs to administer, monitor and support an Oracle 10g database. Objectives: This course is designed to give database administrators the knowledge... Learn about: Creating and Managing an Oracle Database, Installing and Configuring Oracle...

...Delegates: Personnel who need to know the basic and advanced features of the UNIX Shell programming language to be able to carry out their daily...

...Although the course is based on AIX Version 6.1 it is also appropriate for prior releases of AIX. Skills Gained The delegates will have knowledge and practise... Learn about: Allowing them to administer an IBM AIX System...

...Access Control Lists The Trusted Computer Database... Learn about: Perform more advanced LVM tasks...

...Packard HP-UX Operating System training course introduces the delegate to the main concepts of the HP-UX Operating System. The most commonly used commands... Learn about: Moving and deleting files and directories...

...On completion of the course the delegate will have a good working knowledge of how to manipulate the Shell as an environment interface and how to fully... Learn about: Allowing them to administer an HP-UX system...

...a login environment are discussed and the main features of the Korn/Posix/Bash Shells are introduced The course is designed to give delegates practical... Learn about: Moving and deleting files and directories...

...On completion of this course, the delegate will be able to make effective use of a wide range of standard UNIX programming and development tools... Learn about: Backing up and restoring files with tar...