Get a 10% discount on your first order when you use this promo code at checkout: MAY24BAN3X
– LEATHER GOODS MAKING CLASS – LEATHER CRAFT WORKSHOP: MAKE YOUR OWN HAND SEWN LEATHER ITEM ONE TEACHER, SIX STUDENTS WHERE? AT OUR STUDIOhttps://www.thelondonleatherworkshop.com/contact-us/ WHEN? PLEASE SELECT YOUR PREFERRED DATE THROUGH THE BUTTON BELOW COST ONE MEETING OF 6 HOURS £125.00 COURSE MATERIALS INCLUDED (WORTH £20) LEVEL: BEGINNERS AND BEGINNERS WITH SOME PREVIOUS SEWING EXPERIENCE LEARN HOW TO MAKE A LEATHER ITEM: WHAT IS THIS COURSE ABOUT? THIS IS A THEORETICAL AND PRACTICAL TASTER GROUP TUITION DURING WHICH YOU WILL RECEIVE AN OVERVIEW ON BASIC LEATHER CRAFT SKILLS AND TECHNIQUES AND REALISE YOUR OWN LEATHER ITEM TO TAKE HOME WITH YOU. THE CLASS WILL TAKE PLACE IN OUR LONDON WORKSHOP WHERE YOU WILL BE ABLE TO SEE HOW A LEATHER CRAFT STUDIO IS EQUIPPED AND RECEIVE PRACTICAL DEMONSTRATIONS OF COMMON WORKING METHODS USED IN THE FIELD. YOU WILL BE ABLE TO CHOOSE YOUR PROJECT BETWEEN A SELECTION OF DIFFERENT TYPES OF GOODS SUCH AS PASSPORT HOLDERS, GLASSES CASES, PURSES, CARD HOLDERS AND MORE. YOU WILL BE SHOWN DIFFERENT TYPES OF LEATHER AND GET TO UNDERSTAND THEIR MAIN FEATURES. YOU WILL RECEIVE AN INTRODUCTION ON HOW TO MARK, CUT, EDGE FINISH, HAND SEW LEATHER AND USE SIMPLE FASTENING HARDWARE. YOU WILL RECEIVE RELEVANT, USEFUL AND INFORMATIVE HANDOUTS AS WELL AS LISTS OF LEATHER AND TOOL SUPPLIERS. AT THE END OF THE TUITION YOU WILL HAVE: – GAINED AN UNDERSTANDING OF LEATHER TYPES AND TANNING METHODS – BEEN INSTRUCTED ON THE USE OF COMMON FASTENINGS AND CLOSURE TECHNIQUES – RECEIVED AN OVERVIEW ON THE CORRECT USE OF TOOLS FOR PREPARING, MARKING, CUTTING AND PUNCHING LEATHER – LEARNED HOW TO SADDLE STITCH LEATHER AND UNDERSTOOD THE DIFFERENT THE TOOLS AND MATERIALS USED IN THE TECHNIQUE – UNDERSTOOD AND PRACTICED LEATHER CRAFT TECHNIQUES SUCH AS BEVELING AND BURNISHING TECHNIQUES – REALISED YOU OWN SMALL, SIMPLE LEATHER ITEM TO TAKE HOME WITH YOU WHAT ARE THE ENTRY REQUIREMENTS? THIS COURSE IS SUITABLE FOR TOTAL BEGINNERS AND BEGINNERS WITH SOME EXPERIENCE IN LEATHER CRAFTS. YOU SHOULD BE ABLE TO USE MEASUREMENTS AND UNDERSTAND VERBAL AND WRITTEN ENGLISH INSTRUCTIONS. ARE THERE ANY OTHER COSTS? IS THERE ANYTHING I NEED TO BRING? MATERIALS ARE INCLUDED. FEEL FREE TO BRING A NOTEPAD, IF YOU WOULD LIKE TO TAKE SOME NOTES, WE WILL PROVIDE THE REST. INCLUDED IN THE COURSE: YOU WILL BE PROVIDED WITH USEFUL HANDOUTS WHICH CONTAIN: – A LIST OF RECOMMENDED SUPPLIERS FOR BOTH LEATHER AND FITTINGS (PHYSICALLY IN LONDON AND ONLINE) – A GLOSSARY CONTAINING INFORMATION ABOUT LEATHER TYPES AND CHARACTERISTICS HOW LONG IS THIS TUITION?: THIS TUITION WILL REQUIRE UP TO 6 HOURS TO COMPLETE. WE AIM TO PROVIDE CUSTOMISED AND HIGH-QUALITY TUITION SERVICES AND BY ONLY ALLOWING UP TO 6 STUDENTS AT A TIME, WE ARE ABLE TO FOCUS ON EACH PERSON NEEDS AND INTERESTS. AS EVERY STUDENT HAS A DIFFERENT LEVEL OF ABILITY AND PREVIOUS EXPERIENCE, THIS COURSE MIGHT LEAD SOME STUDENTS TO COMPLETE THE CORE ASPECTS OF THE LESSON IN A SHORTER TIME FRAME THAN OTHERS. STUDENTS WHO COMPLETE THE COURSE EARLY WILL BE WELCOME TO STAY AND USE THE STUDIO FACILITIES TO EXERCISE ON THE TOPICS OF THE LESSON.
HIGHFIELD LEVEL 2 AWARD IN FOOD ALLERGEN AWARENESS AND CONTROL IN CATERING (RQF) -------------------------------------------------------------------------------- * Half day course * This course gives learners the knowledge and understanding of food allergens and foods that commonly cause intolerances * Teaches how to minimise the risk of cross-contamination from allergenic ingredients -------------------------------------------------------------------------------- BENEFITS OF THIS COURSE: * This qualification is aimed at food handlers and other staff involved in food preparation and service who work within the catering industry * It provides knowledge and understanding of food allergens and foods that commonly cause intolerances * Many people are allergic to foods, or have a food intolerance * There is a duty in law for food handlers to ensure these people do not come to harm, either by going into anaphylactic shock and their potential death, or by making them feel really ill for a long period after consuming the food. * This qualification is supported by Allergy UK [https://www.allergyuk.org/], who regard it as suitable staff training for catering outlets that wish to apply for their Allergy Aware Scheme. -------------------------------------------------------------------------------- COURSE CONTENTS: * The characteristics and consequences of food allergies and intolerances * How to identify and control contamination from allergenic ingredients * Ways to accurate communicate of allergen information to consumers -------------------------------------------------------------------------------- ACCREDITED, OFQUAL REGULATED QUALIFICATION Our Food Allergen Awareness and Control in Catering training course is a nationally recognised, Ofqual regulated qualifications accredited by Highfields Qualifications [https://www.highfieldqualifications.com/]. This means that you can be rest assured that your Food Allergen Awareness and Control in Catering Certificate provides information for best practice to make a real difference to the lives of people who suffer from food allergies or intolerances. It also helps to stay on the right side of the law! The Ofqual Register number for this course is 603/1396/1 --------------------------------------------------------------------------------
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.
Game Design Training: 3ds Max and Unity 3D Personalized
By Real Animation Works
Game design training face to face training customised and bespoke.
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.
Tissue viability course Wound care training for healthcare professionals Pressure sore management Wound assessment techniques Evidence-based wound care Chronic wound management Diabetic ulcer treatment Venous leg ulcer care CPD accredited course Nursing revalidation hours Healthcare professional wound care skills Hands-on wound care practice Wound dressings and interventions Pressure sore prevention strategies Simulation wound care scenarios Tissue viability principles Optimal wound healing techniques Wound care certification program Advanced wound care education Enhancing patient outcomes through wound care
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.