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

...a MySQL database Write SQL statements to select data from a MySQL database Use joins, subqueries, grouping and aggregate functions Use SQL expressions... Learn about: Using client programs to access a MySQL database...

...SQL expressions and functions Modify data. Suitable for: MySQL Developers who have a basic understanding of a MySQL database and SQL commands as covered... Learn about: Performing advanced Insert, Replace and Truncate Operations...

...Topics Covered: Relational Database Concepts Grid Computing Oracle Database Server Oracle Application Server Oracle Applications Oracle Support Services...

...the primary features and constructs of the PL/SQL Programming Language. Objectives: By the end of the course, the delegate will be able to write programs...

...Compilation and Compile Time Warnings The DBMS_SQL Package Native Dynamic SQL Oracle Supplied Packages The DBMS_METADATA Package Overview of DBMS_SCHEDULER... Learn about: Stored program units and packages, To provide the skills needed to develop, Write and maintain triggers...

...arrays in packages Implementing Bulk Binding and Bulk Collecting techniques Managing program unit dependencies Implementing Native Compilation and Compile-time... Learn about: Stored program units and packages, Write and maintain PL/SQL scripts, To provide the skills needed to develop...

...Delegates:This course, designed for Oracle database administrators and software development personnel who need to gain practical experience of the advanced...

...Follow-On Courses Oracle Database 10g DBA - Part II NOTE: Course technical content is subject to change without notice. Oracle Database 10g...

...in reports Using Parameters in Reports Adding graphics to a report Distributing and bursting reports Tuning reports Maximizing report performance using...

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

...Suitable for: Database Administrators of small sized databases who need to carry out basic system administration tasks on Oracle Database... Learn about: Creating an Oracle database...

...This course is designed to give database administrators the knowledge and skills needed to maintain successful and efficient day-to-day operations of an Oracle database... Learn about: Creating and Managing an Oracle Database, Installing and Configuring Oracle...

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

...for the IBM Certified Operator - AIX 6.1 Basic Operations exam. Before taking any exam, ensure you have the recommended experience. Exams are not included as part of the course... 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...

...redirection Output redirection Pipes Exercise: Using redirection and pipe facilities HP-UX Introduction Training CourseCourse Contents - DAY 2Session... 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...

...Some programming experience may also prove advantageous. Course Objectives To provide the skills needed to work productively in an HP-UX environment... 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...