120 Character courses in Manchester

The WSET Level 1 Award in Wines is the ideal starting point for anybody new to wine or those beginning a career in wine or hospitality. It lays the foundation for understanding wine, giving you confidence for food and wine pairing and an introduction to different wine styles. What the course covers: * The basic skills and product knowledge required for the service and retail of wine * The main types and styles of wine * Common wine grapes and their characteristics * How to make food and wine pairings * How to store and serve wine * How to taste and describe wine using the WSET Level 1 Systematic Approach to Tasting Wine®(SAT) The WSET Level 1 Award in Wines has full accreditation from OfQual as part of the UK Government’s Qualifications & Credits Framework as a Level 1 Vocational Qualification. We recommend you read the course specification [https://www.localwineschool.com/files/pdf/wset-level-1-wines-specification(1).pdf] document before you sign up for the course. Course delivery * The Level 1 Award in Wines online course covers the same syllabus as the classroom course and is delivered in LIVE virtual lessons by one of our certified wine educators * The course includes 6 hours online tuition in 3 x 2 hour sessions * Your tutor will provide a guided tasting of 6 wines with you on this course (for details of how to order the wines for your course see below) * You will receive access to practice multiple-choice revision questions specific to this course * You will be sent details of how to join your LIVE sessions when you book Please note a reliable broadband connection is essential for the completion of this online course as is basic computer skills. Examination To obtain the WSET Level 1 Award in Wines Qualification, you will need to successfully pass the exam. The exam is made up of 30 multiple-choice questions to be completed in 45 minutes. You must answer at least 70% correctly to pass the exam. The exam is taken online via a Remote Invigilation [https://www.youtube.com/watch?v=DarWJz6dUbU] service. We will arrange a suitable time/date for you to take your exam when you are ready to do so. Please ensure you read the information HERE [https://www.wsetglobal.com/wset-remote-invigilation-essential-guidance/?dm_i=5G5C,KRHB,4A50QU,2G285,1] if you wish to take the exam online.  The course fee includes: * Course study guide, posted to you at no extra charge * LIVE virtual, interactive sessions taught by a Local Wine School WSET Certified Tutor * Exclusive access to practice multiple choice questions * Registration with WSET and all examination fees * Remote Invigilation service *Please note there are some minimum system requirement (contact us [info@manchesterwineschool.com?subject=wset%20online] for more information) * Internationally recognised WSET qualification certificate and pin for those who pass the exam * VAT at 20% (VAT receipt can be provided on request). Course Wines: It is recommended that 6 wines are tasted as part of this course, although this is optional and not essential to complete the course. Please note that the cost of wines is not included in the course fee above. Our wine experts have specially selected wines for this course aligned to demonstrate specific learning outcomes. They have even negotiated a specially discounted price only available to our online students. The price of the 6 bottle case around £75.95 including delivery. Details of how to order your case of wines will be provided when you book your place. Special Educational Needs Please make the school aware if you have a condition that may mean that you will qualify for additional help during the exam such as dyslexia. Important dates Registration deadline: please book at least 5 days before the start of the course, to allow time to send materials and order the tasting wines.

Aspire Consulting and Training Ltd is indisputably at the forefront of Transformative Coachingworldwide. We have a commitment to prepare individuals as coaches to achieve sustainable change for the people around them, so that they are being developed and supporting many types of growth. Achieved through a process of heightening awareness and deepening learning, this differs from other coaching methodologies that employ a tactical or remedial approach more useful in trouble-shooting and problem solving.   As people pursue coach training, they want a program with high standard, proven methodology and worldwide recognition. The TAP-C™ Model is a globally delivered program that enhances professional coaching industry standards. Our certification training program offers a fresh, leading edge approach to enable authentic and deliberate change.   We offer the ultimate solution to maximise human capital. Businesses are expecting their managers to devote an ever-increasing portion of their time to coach others and this is a trend that will only continue to expand. The challenges have never been greater for achieving results through people, and coaching will remain a vital leadership skill for the decades to come. A proven strategy for creating sustained growth, coaching enables superior performance of individuals, teams, and whole organisations.    The TAP-C™ Model is not just a new methodology or trend; it is more of a tool that drives a positive change. It helps people gain clarifications through meaningful conversations. It promotes learning by stimulating people to think through about their situation and urges them to take initiatives. Coaching is all about making people realise what needs to be modified and offer them appropriate support to bring about a change.    "Coaching is about influencing individuals to make conscious, empowered decisions to become leaders in their own lives. It is a process that occurs in a special conversation that enables learning and development and thus improves performance. It is a way of working with people that leaves them more competent and more fulfilled so that they are more able to contribute and find meaning in what they are doing."   Jay Acharya   The TAP-C™ Model incorporates a blend of coaching, mentoring and counselling, that, although considered different, share some key characteristics and skills to always support positive outcomes.    Coaching involves the belief that the individual has the answers to their own problems within, and need the focus to unlock their own potential.  Mentoring is like coaching, with a general agreement that a mentor can partner in some way to help expedite any decision making.  Counselling is closer to a therapeutic intervention. Focusing on past situations and identify ways to overcome barriers, that may be internal or external.   Our TAP-C™ Model therefore truly incorporates what we know to be an Influencing and Empowered approach to Coaching in the following way: We will explore the supporting principles of a coach and the guiding principles of a mentor, by using practical methods to help you become more effective and confident.    The purpose of this training to improve your performance at the same time of improving other abilities and create a cultured and productive working atmosphere. The core objective of the course is to enable you to set and achieve organisational, departmental and personal goals, by communicating clearly with their teams, managing time more effectively and prioritising work so that achieving an organisational strategy is more of a fluid approach.   Aims and Objectives                             The sessions focus on the theoretical aspects of empowering people in an organisation, by increasing the awareness of current competencies and abilities. The programme will meet all the objectives outlined below: * Gain a greater understanding of organisational activities * How the TAP-C™ Model can be used to develop a person and a team * Establish how to know when to be a coach, mentor and councillor * The behaviour’s of being a confident coach * How to help a person recognise their strengths and developmental areas  * How to create and develop an empowered structured organisation

Develop the skills to become an experienced bartender and fast-track your career having one week fun in Manchester City Center plus Level 2 Award Alcohol License Holder online course and invigilated exam! Designed to develop the knowledge and skills to become an experienced bartenders and obtain the personal alcohol license you need to showcase you are a professional. Fast-track your way up into the bartending industry with 1 week of hands-on training with our highly-experienced instructors. Next Available Sessions (please write in the note which one you prefer) 📅 8th-12th April 2024 ⏰ Monday to Thursday 12.00-4.00pm, Saturday 19.00-23.00 📍 Sicilian NQ - Bar and Restaurant, 14 Turner St, Manchester M4 1DZ 📅 10th-15th June 2024 ⏰ Monday to Thursday 12.00-4.00pm, Saturday 19.00-23.00📍 Sicilian NQ - Bar and Restaurant, 14 Turner St, Manchester M4 1DZ 📅 9th-14th September 2024 ⏰ Monday to Thursday 12.00-4.00pm, Saturday 19.00-23.00📍 Sicilian NQ - Bar and Restaurant, 14 Turner St, Manchester M4 1DZ -------------------------------------------------------------------------------- Highlights * Master 40 classic cocktails * You be awarded with a Dirextra's advanced bartender certificate to showcase your skills to employers at the end of your course * Personal Alcohol License Course and Exam included (online). Level 2 Award Course and Exam gains you the qualification needed to apply for your personal licence in England and Wales, which is essential if your role requires that you authorise alcohol sales, including designated premises supervisors, retail managers, restaurant and bar managers and any other persons that want to progress into these positions. * One week of fun experience * Not Suitable for beginners. At least 1 year experience is requested. Fluent in English. WHY IS THIS COURSE FOR YOU? * Add some new certified skills to your CV (get 2 certificates) * Get your Personal Alcohol License  * You'll learn to expertly craft the homemade products to incorporate into a cocktail, the supporting ingredients that bring them depth, nuance, and curb their eye-watering strength. * You'll learn how to Speed-up yourself making perfect cocktails with beautiful garnish in a very fast environment. * Progress in an professional level bartending position and work your way up to become bar supervisor COURSE PROGRAMME You’ll learn: * Course Programme (Online Part) * Licensing Policy * Personal Licence inc Duties * Premises Licence and Operating Schedule * Designated Premises Supervisor * Temporary Events * Exemptions and Prohibitions * Unauthorised Activities and Due Diligence * Rights Of Entry and Inspection * Powers To Close Licensed Premises * Protection Of Children * The Definition and Nature Of Alcohol * Smoking, Drugs and Responsible Retail * Accredited Online Invigilated Exam. Our online test centre is fully approved by Laser Awards as an Accredited personal licence qualification provider. To take the exam you need a computer using Google Chrome, a webcam, and microphone, and an internet upload speed of at least 5-10 Mbps. You also need to have valid photo ID. Please be aware that no one can be in the room when you are taking the exam. * Practical Part in presence. We'll teach you to prepare any product you could ever need to incorporate into a cocktail. You'll make:  * Syrups * Cordials  * Foams * Bitters * Fat washes * Shrubs  * Garnishes * Find out how to double shake, roll, & double stir * how to make 40+ classic cocktails.Understanding what exists and how the ingredients pair together is crucial for later developing your own signature mixes. * You’ll study ice as a vital component of a drink. You'll understand: * The purpose & necessary quantity of ice * How to use ice to change the dynamics of a drink * The effect of different types & shapes of ice * On Saturday night you will put in place what you learned in a fast-pace bar serving and preparing cocktails for real customers COURSE VENUE Sicilian NQ,  award winning "Best Neighbourhood  Bar 2023 - Central Manchester", it's a charming mediterranean style wine bar, relaxed and characterful venue nestled in Manchester’s trendy Northern Quarter, right in the heart of the city center. Northern Quarter is a cool neighbourhood, with lively street art, bohemian bars and independent shops. It's home to lively restaurants and some of the city's biggest music venues, featuring concerts from trendy independent bands and famous artists.

REGULAR EXPRESSIONS TRAINING COURSE DESCRIPTION Regular expressions are an extremely powerful tool for manipulating text and data. They are now standard features in a wide range of languages and popular tools, including Python and MySQL. Regular expressions allow you to code complex and subtle text processing that you never imagined could be automated. Once you've mastered regular expressions, they'll become an invaluable part of your toolkit. You will wonder how you ever got by without them. WHAT WILL YOU LEARN * Use Regular Expressions. * Troubleshoot Regular Expressions. * Compare RE features among different versions. * Explain how the regular expression engine works. * Optimize REs. * Match what you want, not what you don't want. REGULAR EXPRESSIONS TRAINING COURSE DETAILS * Who will benefit: Anyone looking to use regular expressions. * Prerequisites: None. * Duration 1 day REGULAR EXPRESSIONS TRAINING COURSE CONTENTS * Introduction to Regular Expressions Solving real problems, REs as a language, the filename analogy, language analogy, RE frame of mind, searching text files: egrep, egrep metacharacters, start and end of the line, character classes, matching any character with dot, alternation, ignoring differences in capitalization, word boundaries, optional items, other quantifiers: repetition, parentheses and backreferences, the great escape, expanding the foundation, linguistic diversification, the goal of a RE, more examples, RE nomenclature, Improving on the status quo. * Extended introductory examples A short introduction to Perl, matching text with regular expressions, toward a more real-world example, side effects of a successful match, Intertwined regular expression, intermission, modifying text with regular expressions, example: form letter, example: prettifying a stock price, automated editing, a small mail utility, adding commas to a number with lookaround, text-to-HTML conversion, that doubled-word thing. * Regular expression features and flavours The regex landscape, origins of REs, care and handling of REs, Integrated handling, procedural and object-oriented handling, search-and-replace example. strings character encodings and modes, strings as REs, character-encoding issues, unicode, regex modes and match modes, common metacharacters and features, character representations, character classes and class-like constructs, anchors and other 'zero-width assertions', comments and mode modifiers, grouping capturing conditionals and control. * The mechanics of expression processing Two kinds of engines, new standards, regex engine types, from the department of redundancy department, testing the engine type, match basics, about the examples, rule 1: the match that begins earliest wins, engine pieces and parts, rule 2: the standard quantifiers are greedy, regex-directed versus text-directed, NFA engine: regex-directed, DFA engine: text-directed, first thoughts: NFA and DFA in comparison, backtracking, two important points on backtracking, saved states, backtracking and greediness, more about greediness and backtracking, problems of greediness, multi-character 'quotes', lazy quantifiers, greediness and laziness, laziness and backtracking, possessive quantifiers and atomic grouping, possessive quantifiers ?, +, *+, ++ and {m,n}+, the backtracking of lookaround, is alternation greedy? taking advantage of ordered alternation, NFA DFA and posix, the longest-leftmost', posix and the longest-leftmost rule, speed and efficiency. * Practical regex techniques Continuation lines, matching an IP address, working with filenames, matching balanced sets of parentheses, watching out for unwanted matches, matching delimited text, knowing your data and making assumptions, stripping leading and trailing whitespace, matching and HTML tag, matching an HTML link, examining an HTTP URL, validating a hostname, plucking a hostname, plucking a URL, parsing CSV files. * Crafting an efficient expression Efficiency vs. correctness, localizing greediness, global view of backtracking, more work for POSIX NFA, work required during a non-match, being more specific, alternation can be expensive, benchmarking, know what you re measuring, benchmarking with Python, common optimisations, the mechanics of regex application, pre-application optimizations, optimizations with the transmission, optimization of the regex itself, techniques for faster expressions, common sense techniques, expose literal text, expose anchors, lazy versus greedy: be specific, split into multiple REs, mimic initial-character discrimination, use atomic grouping and possessive quantifiers, lead the engine to a match, unrolling the loop, observations, using atomic grouping and possessive quantifiers, short unrolling examples, unrolling C comments, the free flowing regex, a helping hand to guide the match, a well-guided regex is a fast regex.

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.

QUERYING MICROSOFT SQL SERVER COURSE DESCRIPTION This course covers the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server and provides the foundation for all SQL Server-related disciplines; namely, database administration, database development and business intelligence. This course helps prepare for exam 70-761. Note: This course is designed for SQL Server 2014or SQL Server 2016. WHAT WILL YOU LEARN * Write SELECT statements. * Create and implement views and table-valued functions. * Transform data by implementing pivot, unpivot, rollup and cube. * Create and implement stored procedures. * Add programming constructs such as variables, conditions, and loops to T-SQL code. QUERYING MICROSOFT SQL SERVER COURSE DETAILS * Who will benefit: Database administrators, database developers, and business intelligence professionals. SQL power users, namely, report writers, business analysts and client application developers. * Prerequisites: Database fundamentals * Duration 5 days QUERYING MICROSOFT SQL SERVER COURSE CONTENTS * Introduction to Microsoft SQL Server Management studio, creating and organizing T-SQL scripts, using books online. Hands on working with SQL Server tools. * T-SQL querying Introducing T-SQL, sets, predicate logic, logical order of operations in SELECT statements, basic SELECT statements, queries that filter data using predicates, queries that sort data using ORDER BY. Hands on introduction to T-SQL querying. * Writing SELECT queries Writing simple SELECT statements, eliminating duplicates with DISTINCT, column and table aliases, simple CASE expressions. Hands on writing basic SELECT statements. * Querying multiple tables cross joins and self joins, write queries that use Inner joins, write queries that use multiple-table inner joins, write queries that use self-joins, write queries that use outer joins, write queries that use cross joins. Hands on querying multiple tables. * Sorting and filtering data Sorting data, filtering data with predicates, filtering data with TOP and OFFSET-FETCH, working with unknown values, WHERE clause, ORDER BY clause, TOP option, OFFSET-FETCH clause. Hands on sorting and filtering data. * SQL Server data types Introducing SQL Server data types, Character data, date and time data, queries that return date and time data, write queries that use date and time functions, write queries that return character data, write queries that return character functions. Hands on working with SQL Server data types. * DML Adding data to tables, modifying and removing data, generating automatic column values, Inserting records with DML, updating and deleting records using DML. Hands on using DML to modify data. * Built-in functions Queries with built-in functions, conversion functions, logical functions, functions with NULL, queries that use conversion functions, queries that use logical functions, queries that test for nullability. Hands on built-in functions * Grouping and aggregating data Aggregate functions, the GROUP BY clause, filtering groups with HAVING, queries that use the GROUP BY clause, queries that use aggregate functions, queries that use distinct aggregate functions, queries that filter groups with the HAVING clause. Hands on grouping and aggregating data. * Subqueries Self-contained subqueries, correlated subqueries, EXISTS predicate with subqueries, scalar and multi-result subqueries. Hands on subqueries. * Table expressions Views, inline table-valued functions, derived tables, common table expressions. queries that use views, write queries that use derived tables, Common Table Expressions (CTEs), write queries that se inline Table valued expressions (TVFs). Hands on table expressions. * Set operators The UNION operator, EXCEPT and INTERSECT, APPLY, queries that use UNION set operators and UNION ALL, CROSS APPLY and OUTER APPLY operators. Hands on set operators. * Windows ranking, offset, and aggregate functions OVER, window functions, ranking functions, offset functions, window aggregate functions. Hands on; windows ranking, offset, and aggregate functions. * Pivoting and grouping sets PIVOT and UNPIVOT, grouping sets, queries that use the PIVOT operator, queries that use the UNPIVOT operator, queries that use the GROUPING SETS CUBE and ROLLUP subclauses. Hands on pivoting and grouping sets * Executing stored procedures Querying data with stored procedures, passing parameters to stored procedures, simple stored procedures, dynamic SQL, the EXECUTE statement to invoke stored procedures. Hands on executing stored procedures. * Programming with T-SQL T-SQL programming elements, controlling program flow, declaring variables and delimiting batches, control-of-flow elements, variables in a dynamic SQL statement, synonyms. Hands on programming with T-SQL * Error handling T-SQL error handling, structured exception handling, redirect errors with TRY/CATCH, THROW to pass an error message back to a client. Hands on implementing error handling. * Implementing transactions Transactions and the database engines, controlling transactions, BEGIN, COMMIT, and ROLLBACK, adding error handling to a CATCH block. Hands on implementing transactions.

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.

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.

SOCKETS PROGRAMMING TRAINING COURSE DESCRIPTION A hands on course for programmers using Sockets. It is important to recognise that the course assumes that delegates are already familiar with TCP/IP and Python. Practical exercises follow all the major theory sessions. WHAT WILL YOU LEARN * Read Python programs which use Sockets. * Write Python programs which use Sockets. * Debug Python programs which use Sockets. SOCKETS PROGRAMMING TRAINING COURSE DETAILS * Who will benefit: Programmers working with network applications. * Prerequisites: TCP/IP foundation for engineers Python for network engineers * Duration 2 days SOCKETS PROGRAMMING TRAINING COURSE CONTENTS * What is a socket? Review of IP, ICMP, UDP vs TCP, IP addresses, protocol numbers, ports. API's, UNIX I/O, sockets. SOCK_STREAM, SOCK_DGRAM. Hands on Compile and run code. * The systems calls Clients and servers, structs, socket(), bind(), connect(), listen(), accept(), send(), recv(), sendto (), recvfrom(), close(), shutdown(), getpeername(), gethostname(). Hands on Walk through of example client and server code. * First code TCP connections, passive opens, active opens. Hands on Write a simple 'hello world' server and client. * Application protocols User character stream, ASCII turn taking, binary protocols. Hands on Raw SMTP, Writing a mail client. * Clients Concurrency, polling, threads, event driven programming. Hands on Conferencing application. * Servers Concurrency, stateful, stateless. Forks and execs. inetd. Hands on Running servers with and without inetd, chroot jails, conferencing server modifications. * Advanced techniques Blocking, select(), partial send(s). Raw sockets, example sockets using Java, Perl and PHP. Hands on A broadcast application.