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: Receipting Returns and Writing off Damaged Goods, Defining and Maintaining a Physical Inventory...

...indexes and views Use various data types and constraints Understand how privileges are controlled Understand the principles of transactions Export and Import data Topics Covered... Learn about: Using client programs to access a MySQL database...

...Before taking any exam, delegates must ensure they have the recommended experience. Objectives: By the end of the course, delegates will be able... Learn about: Performing advanced Insert, Replace and Truncate Operations...

...managers, project managers, system analysts and people with some technical background who want an overview of the capabilities of the Oracle database...

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

...and database administrators who need to write new, or maintain existing, PL/SQL triggers, program units and packages. Delegates: This course... Learn about: Write and maintain triggers, Stored program units and packages, To provide the skills needed to develop...

...Warnings Implementing Native Dynamic SQL Using a variety of Oracle-supplied packages Who will the Course Benefit? Oracle database administrators... Learn about: To provide the skills needed to develop, Write and maintain PL/SQL scripts, Stored program units and packages...

...use LOB data types and the DBMS_LOB package; use SecureFile LOBs; effectively design cursors; improve memory usage with PL/SQL result caching and SQL result...

...knowledge required to develop web-based database applications using Oracle Forms. Oracle Database 10g DBA - Part I Course Overview This course is designed...

...need to create reports in a variety of styles and customise reports to meet their business requirements. This course is aimed at database administrators...

...Reports and Forms Pages and Regions Items and Buttons Page Processing Shared Components Display Dynamic Content Session State and Debugging Themes... 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...

...and Temporary Segments Monitoring and Resolving Lock Conflicts Maintaining Database Security Monitoring the Performance of the Database Loading and Unloading... Learn about: Installing and Configuring Oracle, Creating and Managing an Oracle Database...

...utilise the Shell programming language. In addition, the delegate will be able to make effective use of a wide range of standard UNIX programming and development tools...

...Introductions Session 1: THE SYSTEM ADMINISTRATORS' ROLE Role of a Systems Administrator The root Login and the su Command Session 2: INTRODUCTION TO... Learn about: Allowing them to administer an IBM AIX System...

...Theory Disk Management Procedures Alternative Mirroring And Stripping With RAID Disk Replacement Techniques Backing up the System Using mksysb Backup... Learn about: Perform more advanced LVM tasks...

...own login environment Who will the Course Benefit? Anyone who needs to understand and use the HP-UX Operating System. There are no formal pre-requisites... Learn about: Moving and deleting files and directories...

...utilise the Shell programming language. Topics Covered: Shell Environment Customisation of the Environment Shell Program Structure Shell Program Execution... Learn about: Allowing them to administer an HP-UX system...

...Skills Gained The delegates will practice: Creating, copying, renaming, moving and deleting files and directories Using the shell's redirection and... Learn about: Moving and deleting files and directories...

...Programmers, developers and system administrators who need to construct shellscripts using advanced text handling facilities. Objectives: On completion of this course... Learn about: Backing up and restoring files with tar...