11 Arithmetic courses in Leeds

REXX TRAINING COURSE DESCRIPTION A hands on training course covering the Restructured EXtended eXecutor (REXX) language. A large number of exercises are used to reinforce and emphasise lecture sessions. WHAT WILL YOU LEARN * Write REXX programs. * Debug REXX programs. * Examine existing code and determine its function. REXX TRAINING COURSE DETAILS * Who will benefit: Anyone wishing to learn REXX. * Prerequisites: None although experience in another high level language would be useful. * Duration 3 days REXX TRAINING COURSE CONTENTS * Introduction to REXX What is REXX? REXX environments, invoking a REXX exec, a sample REXX exec, REXX clause types. * REXX variables and data Literal data, variable data, assignment, simple variables, compound variables, stem variables, constant data, numeric data, arithmetic operations, character manipulation, hexadecimal data. * The parse instruction Parse format, Parse examples, Parse arg, Parse pull, Parse value, special templates, place holders, literal templates, numeric templates, variable templates. * Control structures Relational conditions, logical operators, simple selection, looping: uncontrolled and controlled loops, infinite loops, conditional loops, controlling loops, leave, iterate, multiple selection, instructions for subroutines, exit. * Sub routines and functions Internal and external subroutines, call, ARG(), ARG(n)return, exit, scope of variables, procedure, functions, built in functions, overriding built in functions. * Performing I/O Command conventions, preparing to read a file, execio, limitations, execio for reading, DISKR, DISKRU, DISKW, return codes. * External functions listdsi, msg, outtrap, prompt, sysdsn, sysvar, storage * Tracing Immediate commands, the trace facility, signal and call statements. * Built in functions Text handling functions, string handling, word handling, arithmetic, data conversion, bit manipulation, environment. * The data stack Data stack structure, REXX instructions for the data stack, REXX functions for the data stack, TSO/E commands for the data stack. * REXX in batch TSO/E foreground. TSO/E background.

COMPLETE C PROGRAMMING TRAINING COURSE DESCRIPTION A hands-on introduction to programming in the ANSI C programming language. The course initially moves at a fast pace in order to spend as much time as possible on the subject of pointers - the area which cause the most bugs in C programs. WHAT WILL YOU LEARN * Write ANSI C programs * Use the C libraries * Debug C programs * Examine existing code and determine its function. COMPLETE C PROGRAMMING TRAINING COURSE DETAILS * Who will benefit: Programmers wishing to learn C. Programmers wishing to learn C++ or Java. * Prerequisites: None, although experience in another high level language would be useful. * Duration 5 days COMPLETE C PROGRAMMING TRAINING COURSE CONTENTS * Getting started The compilation process, comments, main(), statement blocks, printf(). * C data types and operators char, int, float and double, qualifiers, arithmetic and assignment operators, precedence, Associativity. * Basic I/O C libraries, stdin and stdout, getchar(), putchar(), printf() formatting. * Flow control if else, dangling elses, else if, while and for loops. switch statements, the null statement, break, continue and gotos. * Functions Function calls, arguments and return types, function declarations (prototypes), function definitions, scope of variables. * The preprocessor Preprocessor actions, macros, #include. Libraries and their relationship with header files. Conditional compilation. * More data types and operators Logical, bitwise and other operators, type conversion, casting, typedefs and access modifiers. * Arrays Declaring and handling arrays, common gotchas, multidimensional arrays. * Pointers What are pointers? Why they are so important, declaring and using pointers,The three uses of the *,pointer example - scanf, pointers as arguments. * More pointers Golden rules of pointers and arrays, pointers to arrays, pointer arithmetic, arrays of pointers, multiple indirection. * Character/string manipulation Arrays of characters, string definition, working with strings, String library. * Program arguments argc and argv, example uses,char *argv[] versus char ** argv. * Program structure and storage classes Globals (externals), multi source programs, the look of a C program. * Structures Declaration, the . and - operators, unions and bitfields. * Library functions File handling, fopen and fclose, reading from and writing to files, fseek().calloc() and malloc()

ADVANCED UNIX SHELL SCRIPTING TRAINING COURSE DESCRIPTION A follow on hands on course from the Introduction to shell programming course covering the powerful sed and awk tools along with the extra Korn shell programming features. WHAT WILL YOU LEARN * Use regular expressions within grep, ed and many other utilities. * Use awk and sed. * Integrate sed and awk into shell scripts. * Recognise the role of shell scripts within the UNIX system. * Write shell scripts using new Korn shell features including: * The select construct * Arrays * Arithmetic evaluation ADVANCED UNIX SHELL SCRIPTING TRAINING COURSE DETAILS * Who will benefit: Programmers developing applications under UNIX. Administrators who need time saving utilities. Technical personnel who wish to make the most out of the Korn Shell. * Prerequisites: UNIX shell scripting * Duration 3 days ADVANCED UNIX SHELL SCRIPTING TRAINING COURSE CONTENTS * Regular Expressions What are REs? How can they be used? How to write REs * More REs e REs Tagging, matching words, repetitions. * The sed editor Basic usage: Saving output, options. sed script files, sed commands, Specifying lines to edit, Hold space and pattern space, advanced commands * Awk Basic usage, nawk script files, Patterns, Records and fields, Actions if, while, do, for... System variables NF, NR, RS... Arrays Functions length, printf, cos, user defined... Using nawk in shell scripts * Korn shell scripts Review of Bourne shell scripts functions... Variables typeset, manipulating strings Arrays Arithmetic evaluation the let command, (( )), typeset -i The select construct Syntax, workings, REPLY, PS3 Miscellaneous Enhanced I/O, ${10}

ORACLE SQL TRAINING COURSE DESCRIPTION The Oracle SQL course is designed to give delegates practical experience in writing SQL statements and scripts using Oracle SQL. The basic SELECT statement, the use of SQL functions and the basic table and view handling statements are introduced. WHAT WILL YOU LEARN * Create SQL statements to query database tables. * Use standard aggregate functions and related SELECT statement clauses. * Join Tables. * Use basic subqueries and the set operators. * Use numeric, character and date functions. * Use conversion and other miscellaneous functions. * Use SQL parameters. * Use complex subqueries. * Create and alter tables and views. * Insert, update and delete rows in database tables. * Manage sequences and synonyms. ORACLE SQL TRAINING COURSE DETAILS * Who will benefit: Anyone who needs to use and understand Oracle SQL to query and update data in an Oracle database. * Prerequisites: None. * Duration 3 days ORACLE SQL TRAINING COURSE CONTENTS * Retrieving data with the SELECT statement The SELECT statement, The SELECT and FROM clauses, Conditions and the WHERE clause, Other conditional operators, Logical operators, The ORDER BY clause, Column aliases, Arithmetic expressions, Precedence of operators. * Aggregate functions Overview of built In aggregate functions, The GROUP BY clause, The HAVING clause. * Joining tables Overview of table joins, Inner joins, Table aliases, Outer joins, Self joins, ANSI standard joins. * Basic subqueries and set operators Overview of subqueries, Basic subqueries, Set operators, The union, intersect and ,minus operators. * Numeric, character and data functions Function types, Using the table dual to try out functions, Numeric functions, Character functions, String concatenation, Date arithmetic and date functions. * Conversion and miscellaneous functions Conversion functions, The NVL and NVL2 functions, The DECODE function, CASE expressions, The COALESCE and NULLIF functions. * SQL parameters Command line substitution parameters, The accept command, The define and undefine commands. * Complex subqueries Subqueries usage, In-line views, Top-N queries, Subqueries with joins, Multi column subqueries, Correlated subqueries, Subquery rules, Using the ANY, ALL and SOME operators. * Managing data Inserting rows, Updating rows, Deleting rows, Verifying updates, Transaction control, Commit and rollback, Savepoints, Commits and constraints, Amending data in SQL developer. * Managing tables Creating tables, Specifying constraints, Altering tables, columns and constraints, Dropping tables, columns and constraints, Recovering dropped tables, Copying tables. * Managing indexes and views Creating indexes, Dropping indexes, Listing indexes, Creating and using views, Dropping views, Listing views. * Managing sequences and synonyms Create a sequence, View sequence details, Create a synonym, List synonyms.

MYSQL FOUNDATION TRAINING COURSE DESCRIPTION The MySQL foundation course covers the basics of the SQL language as implemented by MySQL. The course is designed to give delegates practical experience in writing SQL statements using the MySQL client program and MySQL Workbench. The basic SQL statements, including the use of SQL functions and the basic table and view handling statements are introduced. WHAT WILL YOU LEARN * Create, alter and drop a MySQL database. * Write SQL statements. * Use SQL expressions and functions. * Create and alter tables, indexes and views. * Use transactions. * Grant and revoke access privileges. * Export and import data. MYSQL FOUNDATION TRAINING COURSE DETAILS * Who will benefit: Anyone who needs to access and work with a MySQL Database. * Prerequisites: An understanding of databases and exposure to information technology in general would be useful. * Duration 3 days MYSQL FOUNDATION TRAINING COURSE CONTENTS * Database concepts What is a database? database management systems, tables, rows and columns, indexes, primary keys, unique constraints and foreign keys, client-server architecture, supported data types, storage engines and table types, Information_Schema and MySQL Databases. Hands on using a database. * Using the MySQL client What is the MySQL client? getting started and logging in, selecting a database, client commands, entering and executing SQL statements, retrieving previous commands, creating, editing and executing SQL files, redirecting output into a file, command line execution of MySQL scripts. Hands on Using the MySQL client. * Basic SELECT The SQL SELECT statement, case sensitivity, quotes, statement terminator, syntax conventions, SELECT clause, FROM clause, conditions and the WHERE clause, logical operators, ORDER BY clause, column aliases, arithmetic expressions, precedence of operators. Hands on querying the sample database. * LIMIT, UNION and AGGREGATE functions The LIMIT clause, UNION, UNION ALL, aggregate functions, GROUP BY clause, using Rollup with GROUP BY, HAVING clause. Hands on using limit, union and aggregate functions. * Subqueries and joins Subqueries, cartesian products, table aliases, natural joins, join using, join on, multi-table joins. Hands on using subqueries and joins. * Numeric and character functions Function types, testing functions, numeric functions character functions. Hands on using numeric and character functions. * Data, time and other functions Date and time column types, date and time formats, Date format function, functions to return date time, functions to extract components from date time, date time arithmetic, miscellaneous functions. Hands on using date, time and other functions. * Databases and tables Creating a database, selecting a database, creating tables, Auto_increment, show create table, column operations, constraint operations, copying tables, renaming tables, changing engine for tables, dropping tables, temporary tables. Hands on maintaining databases and tables. * Indexes and views What is an index? creating an index, reviewing indexes, dropping indexes, what is a view? creating views, view restrictions, dropping views. Hands on maintaining indexes and views. * Managing data Inserting rows, replacing rows, updating rows, deleting rows, Truncate statement, The COMMIT and ROLLBACK commands, savepoints, implicit commits. Hands on managing data. * Access control Creating users, renaming users, dropping users, granting privileges, revoking privileges. Hands on creating users, granting and revoking. * Import and export Exporting using SQL, importing using SQL, exporting from the command line, importing from the command line. Hands on export and import data.

COBOL TRAINING COURSE DESCRIPTION A hands on training course providing an introduction to COBOL. WHAT WILL YOU LEARN * Write COBOL programs * Debug COBOL programs * Examine existing code and determine its function. COBOL TRAINING COURSE DETAILS * Who will benefit: Programmers working with COBOL. * Prerequisites: None although experience in another high level language would be useful. A 10 day version of this course would be more applicable for those new to programming. * Duration 5 days COBOL TRAINING COURSE CONTENTS * Introduction to COBOL Compilation, linkage editor. Compile errors, compiler options. Divisions, syntax and format, COBOL character set, program structure. * COBOL statement structure COBOL words, format of statements. * Divisions Identification entries, Environment entries, Data division: FD, record descriptions, hierarchy and level numbers, description-string entry. * File and Working-Storage Sections Literals, figurative constants, redefines clause, data representation, Usage clause, synchronization, sign clause. * Procedure Division File status codes; Open, Read, Write, Close, Stop, Goback; Accept, display; Move, Justified, data name qualification, reference modification. * Perform statement Out-of-line, With test ... Until, ... Times, in-line statement; Go to statement. * Program design Design techniques, design considerations, procedure names, program structure. * Printing Printed output, Write, advancing option, editing characters; Initialize. * Condition testing Conditional statements: IF, class, sign and relation conditions, condition-name conditionals, Set, compound conditions, logical operators. Evaluate, Continue. * Arithmetic Rounded option, On Size Error option, Add, Subtract, Multiply, Divide, Compute. * Non-sequential files File access modes, Select. Indexed and relative files. Open, Close, creating / reading sequential access files, Write, Read, Invalid key clause, reading, writing / updating Random access files, Rewrite, Delete, Start. * Declarative routines Clauses. * Subroutines Call, Using clause - calling program/called program, Linkage Section, returning control. * Table handling Subscripted tables: One/two/three dimensional tables, Perform, variable length tables. Indexed tables: Set, using an index; Search. Copy code: Copy, Suppress, Replacing. * Data Manipulation Inspect, String, Unstring. COBOL/370 LE/370 and Intrinsic Functions.

LINUX SHELL SCRIPTING TRAINING COURSE DESCRIPTION A practical introduction to writing scripts using the Bourne shell under any Linux operating system. Applicable for those using the Korn shell as well. WHAT WILL YOU LEARN * Read shell scripts. * Write shell scripts. * Use different types of quotes. * Recognise the role of shell scripts within the Linux system. LINUX SHELL SCRIPTING TRAINING COURSE DETAILS * Who will benefit: Programmers developing programs under UNIX. Administrators / support personnel who wish to find out more about the workings of Linux or write simple utility programs. * Prerequisites: Linux Fundamentals * Duration 2 days LINUX SHELL SCRIPTING TRAINING COURSE CONTENTS * Review of Linux fundamentals * Basic shell scripts What does the shell do? How are commands executed? Different shells. what is a shell script? Comments, creating shell scripts. * Variables Setting variables, using variables, set, scope, export, sourcing, environmental variables, read. * Positional parameters $0 to $9, $#, $* and others. shift parameter substitution. * Control statements The test command The if statement while loops for loops The case statement. * Special characters Redirection of errors, here documents, quoting. * Arithmetic in shell scripts The expr command. * System shell scripts * Screen handling The terminfo database, The tput command. * Advanced issues (optional session) Shell functions, getopts, xargs, debugging shell scripts, portability issues. Extras in the Korn shell. * Optimising shell scripts The time command, performance tips.

UNIX SHELL PROGRAMMING TRAINING COURSE DESCRIPTION This course has been designed as a follow on course for the XML primer course. The course looks at the use of XSLT in the transforming and styling XML documents. WHAT WILL YOU LEARN * Read shell scripts. * Write shell scripts. * Use different types of quotes. * Recognise the role of shell scripts within the UNIX system. UNIX SHELL PROGRAMMING TRAINING COURSE DETAILS * Who will benefit: Programmers developing programs under UNIX. Anyone working with XML. Administrators Support personnel who wish to find out more about the workings of UNIX or write simple utility programs. * Prerequisites: UNIX fundamentals Some programming experience would be useful although not essential. * Duration 2 days UNIX SHELL PROGRAMMING TRAINING COURSE CONTENTS * Review of UNIX fundamentals * Basic shell scripts What does the shell do? How are commands executed? Different shells. What is a shell script? Comments, creating shell scripts. * Variables Setting variables, using variables, set, scope, export, sourcing, environmental variables, read. * Positional parameters 0 to $9, $#, $* and others. shift parameter substitution. * Control statements The test command, The if statement, while loops, for loops, The case statement, Special characters, Redirection of errors, here documents, quoting. * Arithmetic in shell scripts The expr command. * System shell scripts * Screen handling The terminfo database The tput comand * Avanced issues (optional session) Shell functions, getopts, xargs, debugging shell scripts, portability issues. Extras in the Korn shell. * Optimising shell scripts The time command, performance tips.

TOTAL PHP TRAINING COURSE DESCRIPTION PHP provides for the creation of dynamic web sites. This hands on training course looks at programming with PHP with an emphasis of building dynamic websites. Forms, state management and database integration are all covered with practicals used throughout the course to reinforce theory sessions. WHAT WILL YOU LEARN * Create dynamic web sites using PHP. * Write PHP programs. * Debug PHP programs. * Examine existing code and determine its function. TOTAL PHP TRAINING COURSE DETAILS * Who will benefit: Anyone creating dynamic web sites. * Prerequisites: Software development fundamentals * Duration 3 days TOTAL PHP TRAINING COURSE CONTENTS * What is PHP? PHP history, dynamic web pages, how PHP works, alternatives to PHP. Downloading and installing PHP. Installing MySQL, installing Apache, platform issues. * A first PHP web page A basic PHP script, PHP page structure. PHP comments. Integrating PHP and HTML. * PHP forms HTML forms, taking values from forms. * PHP and HTML Page inputs, environment inputs. phpinfo(), other form elements, sticky fields, generalised code, tables, forms, form elements, style sheets, JavaScript. * Variables operators and expressions Expressions, data types, assignments, scope, constants, HTTP environment variables, getting data from forms using variables. * Operators Arithmetic, logical, relational, Boolean, others. * Control statements Conditional: if, else, elseif, switch. Loops: while, do while, for, break, continue, exit. * Functions Built in functions, declaration, arguments, scope, loading functions from other files, defaulting parameters, call by value/ name. * Arrays Indexes, array initialisation, array manipulation, multi dimensional arrays, array functions. * String handling What is a string, string functions, matching, extraction, replacement. String operations, cleansing, sprintf, formatting web pages, strops and others, splitting strings, REs. * PHP and databases Database structure, Database APIs, MySQL, Creating tables, Editing tables, simple SQL queries using PHP, building HTML tables using SQL queries, SQL injection, security issues, error handling. * File I/O Opening, reading, writing files. Permissions, ownership, locking, directories. * PHP, cookies and sessions State, Cookie properties, setting cookies, retrieving cookies, expiring/deleting cookies. Sessions, session variables, session IDs. * PHP and email Emailing from servers, attachments. * Objects OOP, PHP classes, constructors, instances.

COMPLETE JAVASCRIPT TRAINING COURSE DESCRIPTION A hands on course covering JavaScript programming. Core JavaScript is covered first, including the basics, arrays, functions, classes, modules and Regular expressions. Client side JavaScript is then covered including JavaScript in browsers, Scripting CSS, the jQuery library and HTML APIs. WHAT WILL YOU LEARN * Read JavaScript. * Write JavaScript. * Debug JavaScript. COMPLETE JAVASCRIPT TRAINING COURSE DETAILS * Who will benefit: Anyone wishing to learn JavaScript. * Prerequisites: None. * Duration 3 days COMPLETE JAVASCRIPT TRAINING COURSE CONTENTS * CORE JAVASCRIPT * Lexical structure: Character set, comments, literals, identifiers, and reserved words, optional semicolons.. * Types, values and variables: Numbers, text, boolean values, null and undefines, the global object, wrapper objects, immutable primitive values and mutable object references, type conversions, variable declaration, variable scope. * Expressions and operators: Primary expressions, object and array initializers, function definition expressions, property access expressions, invocation expressions, object creation expressions, operator overview, arithmetic expressions, relational expressions, logical expressions, assignment expressions, evaluation expressions, miscellaneous operators. * Statements: Expression statements, compound and empty statements, declaration statements, conditionals, loops, jumps, miscellaneous statements, summary of JavaScript statements. * Objects: Creating objects, querying and setting properties, deleting properties, testing properties, enumerating properties, property getters and setters, property attributes, object attributes, serializing objects, object methods. * Arrays: Creating arrays, reading and writing array elements, sparse arrays, array length, adding and deleting array elements, iterating arrays, multi-dimensional arrays, array methods, FCMAScript 5 array methods, array type, array-like objects, strings as arrays. * Functions: Defining functions, invoking functions, function arguments and parameters, functions as values, functions as namespaces, closures, function properties, methods and constructor, functional programming. * Classes and modules: Classes and prototypes, classes and constructors, Java-style classes in JavaScript, augmenting classes, classes and types, object oriented techniques in JavaScript, subclasses, classes in ECMAScript 5, modules. * Pattern matching and regular expressions: Defining regular expressions, string methods for pattern matching, the RegExp object. * JavaScript subsets and extensions: JavaScript subsets, constants and scoped variables, destructuring assignment, iteration, shorthand functions, multiple catch clauses, E4X: ECMAScript for XML. * Server-side JavaScript: Scripting Java with Rhino, asynchronous I/O with node. * CLIENT SIDE JAVASCRIPT * JavaScript in web browsers: Client side JavaScript, embedding JavaScript in HTML, execution of JavaScript programs, compatibility and interoperability, accessibility, security, client side frameworks. * The Window object: Timers, browser location and navigation, browsing history, browser screen information, dialog boxes, error handling, document elements as window properties, multiple windows and frames. * Scripting Documents: Overview of the DOM, selecting document elements, document structure and traversal, attributes, element content, creating, inserting and deleting nodes. Example: generating a table of contents, document and element geometry and scrolling, HTML forms, other document features. * Scripting CSS: Overview of CSS, important CSS properties, scripting inline styles, querying computed styles, scripting CSS classes, scripting stylesheets. * Handling events: Types of events, registering event handlers, event handler invocation, document load events, mouse events, mousewheel events, drag and drop events, text events, keyboard events. * Scripted HTTP: Using XMLHttpRequest, HTTP by <script>: JSOMP, Comet with server-sent events. * The jQuery library: jQuery basics, jQuery getters and setters, altering document structure, handling events with jQuery, Animated effects, Ajax with jQuery, Utility functions, jQuery selectors and selection methods, Extending jQuery with plug-ins. The jQuery UI library. Client side storage: localStorage and sessionStorage, Cookies, IE usingData persistence, Applicatioin storage and offline webapps. * Scripted media and graphics: Scripting images, Scripting audio and video, SCG:scalable vector graphics, Graphics in a <canvas>. * Scripted HTTP: Using XMLHttpRequest, HTTP by <script>: JSOMP, Comet with server-sent events. * The jQuery library: jQuery basics, jQuery getters and setters, altering document structure, handling events with jQuery, Animated effects, Ajax with jQuery, Utility functions, jQuery selectors and selection methods, Extending jQuery with plug-ins. The jQuery UI library. * Client side storage: localStorage and sessionStorage, Cookies, IE usingData persistence, Applicatioin storage and offline webapps. * Scripted media and graphics: Scripting images, Scripting audio and video, SCG:scalable vector graphics, Graphics in a <canvas>. * HTMLS APIs: Geolocation, history management, cross-origin messaging, web workers, type arrays and ArrayBuffers, blobs, the filesystem API, client side databases, web sockets.