14 Arithmetic courses in London

PYTHON BASICS: COURSE DESCRIPTION Excellent for beginners, practical, in small groups of max 4 people, 1 Day Online Instructor-led. You could contact us for your prefereed date. Session 1: Python Data Types and Variables: * Primitive types; Characters & Strings; Boolean; Working with variables and its scope; Conversion and casting types in Python. * Operators and Expressions: * Introduction of operators; Arithmetic operators; Relational operators; Assignment operator; Logical operators; Increment and decrement operators.. * Exercise: Calculate Movie Tickets for a Party, Are there enough seats in the cinema? Decision Making & Loops * If statement; If - else statement; If- elif - else statement; Nested if - else; * Exercise: Calculate the travel fee to deliver goods * The while, For loop * Jump statements: break, continue; * Nesting loops. * Exercise: Enter a password, if incorrect 3 times, you are blocked. Session 2: Data Structures * Lists. * Tuples. * Exercise: Hangman Game * Exercise: Get a word for the game from a Json File, store the high score in a Dictionary file Session 3: Files and exceptions * Exception Handling, Exception types; Using try and Except. * Files, streams: Open, Traverse, Read and Create Files: Csv, txt and Json Files. * API: Connecting to API’s. Session 4: OOP * Creating and using custom Functions. * Using parameters and return values. * Creating a Class; Creating an Object; Using an Object; Adding Instance variables; * Class Constructors; Parameterized Constructors. * Inheritance. Override. Session 5: Pandas Dataframe Basics * Getting data into a dataframe: Dict to Dataframe, Dataframe to Dict. Excel To Dict, Dict to Excel , working with Excel data, multiple Excel sheets. * Getting information about the dataframe, * Filter, sort and query a Dataframes, Slicing Dataframes, * Duplicate values,Working with null-values, Sampling. * Exercise: Query the top 1000 grossing movies of the last century Session 6: Built in Functions: String, Math, Random * Python built-in functions: * Strings functions. Maths functions. Random Functions. * Exercise: Find information in prose, to get the sentiment of the prose. * Exercise: Get a word for the game from a txt File * Exercise: Win the lottery INCLUDED: * PCWorkshops's Python Programming Basics Certification * Course notes, exercises and code examples * Revision session after the course -------------------------------------------------------------------------------- REFUND POLICY No Refunds

Python coding, interactive, instructor-led, hands-on, practical. From basics to working with professionals. Python Part Time. Python Coding. -------------------------------------------------------------------------------- Python Beginners Evenings Course COURSE SUMMARY This Python Programming course has become essential to all professional who would like to do code using Python. Learn evenings, work while studying. Work and study Python Part Time. It is a Python beginners course and teaches Python coding from scratch to intermediate. Hands-on, practical. We code some real life examples in this course. Duration: 3 Evenings, once per week for 3 weeks 6pm-8pm, of which the first date only shows on the booking. Virtual Classroom: You could attend in our classroom, or attend online via virtual classroom, by select the appropriate ticket. Who Should Attend? This course is intended for beginner programmers who need to code in Python. Fast-paced, Quite intensive. Course Outline: Session 1: Basics * Python Data Types, Variables, * Operators and Expressions: Arithmetic operators; Relational operators; Assignment operator; Logical operators. * Decision Making: If statement; If - else statement; If- elif - else statement; Nested if - else; * Using Loops: The while, while-else; do-while and the for loop; Enhanced for loop; Jump statements: break, continue; Nesting loops. Session 2: Lists. Dictionaries, Json * Python Data Structures: Lists. Data Structures: 2-d Lists, Tuples. Dictionary, Nested Disctionary. Session 3: Built-in functions: * Python Date Functions. Random. Math Functions. String Functions. Python Regex. Session 4: Database: * Connect to a database, create Database, create a table, insert, delete, update records, query a database and display results. Drop database, drop table. Session 5: Files * Exception Handling in Python: Fundamentals of exception handling; Exception types; Using try and except. * Files, streams: Create, Open, Traverse and Read Files: Csv, txt and Json Files. * API: Connecting to API’s Session 6: M ethods, Classes and Objects * Creating and using Function, Working with parameters, Calling functions. * Object-Oriented Programming (OOP) principles. Modules and Classes, Creating an Object; Using an Object; Adding Instance variables; Controlling accessibility; Naming conventions for class member.s FAQ Do I need Python on my Laptop? Ideally spoken yes, but if not possible, you could use our online platform. Can I pay by BACS? Yes, simply email us, a Python course consultant will contact you. training@pcworkshopslondon.co.uk or pcworkshopslondon@gmail.com Can I pay with PayPal? Yes, simply email us, a course consultant will contact you. training@pcworkshopslondon.co.uk or pcworkshopslondon@gmail.com Do I get an invoice? Yes, on request. Can I pay with a PO (Purchase Order Number)? Yes, simply email us, a Python course consultant will contact you. training@pcworkshopslondon.co.uk or pcworkshopslondon@gmail.com Do I get a certificate? Yes, a PCWorkshops Certificate Can I attend in classroom? Yes, on request, and it would incur an additional charge, depending on your location. We have offices in London, Manchester, Birmingham, Portmouth, Southend-on-Sea, Milton Keynes. Can beginners follow this course? Yes, this is a Python beginner friendly course. We offer Python courses with max 4 people, so we make sure each delegates fully understand the material covered Can I customise the course? Yes, all our Python courses are customisable. We can customise the dates, times, location. course outline. -------------------------------------------------------------------------------- REFUND POLICY No Refunds

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.