StayAhead Training Ltd courses

...delegates will be able to use the 11i Inventory module to carry out daily tasks such as recording receipts and issues of stock. Delegates will be trained... Learn about: Defining and Maintaining a Physical Inventory, Receipting Returns and Writing off Damaged Goods...

...subqueries, grouping and aggregate functions Use SQL expressions and basic functions Insert, update, delete and replace data Create and alter tables... 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: Replace and Truncate Operations, Performing advanced Insert...

...By the end of this seminar delegates will be able to identify the main features that are. Suitable for: This seminar is designed for IT Professionals who are decision makers...

...PL/SQL Programs Generating SQL*Plus and SQL Developer Output IF THEN ELSIF ELSE Statements CASE Expressions Basic Loops The WHILE and FOR Loops Nested...

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

...software development personnel and database support staff who need to write PL/SQL scripts and implement or maintain database triggers, program units and packages... Learn about: Stored program units and packages, To provide the skills needed to develop, Write and maintain PL/SQL scripts...

...and apply coding standards to avoid SQL injection attacks. This course is suitable for delegates intending to sit the Oracle exam #1Z0-146: Oracle Database...

...tools available to a DBA Using SQL*Plus in Oracle to manage a database Administer the database using Enterprise Manager (EM) Start and stop the agent Start...

...experience in designing and creating web and paper reports using the Report Wizard. They will also be able to add dynamic report data to static HTML pages...

...Authorize and Authenticate Users Administer Workspaces Topics Covered: Overview of Oracle Application Express SQL Workshop Build an Application Create... Learn about: Software developers, Web developers...

...Part I and Oracle Database 11g DBA - Part II. Delegates: Database Administrators of small sized databases who need to carry out basic system administration... Learn about: Creating an Oracle database...

...and skills needed to maintain successful and efficient day-to-day operations of an Oracle database. The Oracle database administrator will gain practical... Learn about: Installing and Configuring Oracle, Creating and Managing an Oracle Database...

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

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

...On completion of the course the delegate will have practical experience of how to troubleshoot system startup problems, perform more advanced LVM tasks... Learn about: Perform more advanced LVM tasks...

...INTRODUCTION TO THE vi EDITOR Overview of the vi editor Basic functions Switching to input mode Other useful commands Exercises: Using the vi editor Exercise... Learn about: Moving and deleting files and directories...

...Shell Variables Positional Parameters Special Shell Variables Shell Programming Statements Conditional Statements Looping Constructs Interrupt Handling Debugging Tools... Learn about: Allowing them to administer an HP-UX system...

...Programmers, administrators and support personnel who need to understand the HP-UX Operating system, existing shellscripts, automate procedures and write their own utilities... 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...