75 Courses in London

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}

Maximize the value of data assets in the oil and gas sector with EnergyEdge's assessment-based training course on Python programming and analytics.

NLP Business Diploma - The Fundamentals of Collaborative Relationships training & certification with Proactive NLP Ltd is your first step towards developing collaborative leadership and collaborative cultures. Start transforming your projects now!

NETWORK DEVOPS COURSE DESCRIPTION This course is not a soft skills course covering the concepts of DevOps but instead concentrates on the technical side of tools and languages for network DevOps. Particular technologies focussed on are ansible, git and Python enabling delegates to leave the course ready to starting automating their network. Hands on sessions follow all major sections. More detailed courses on individual aspects of this course are available. WHAT WILL YOU LEARN * Evaluate network automation tools. * Automate tasks with ansible. * Use git for version control. * Use Python to manage network devices. * Use Python libraries for network devices. NETWORK DEVOPS COURSE DETAILS * Who will benefit: Administrators automating tasks. * Prerequisites: TCP/IP Foundation * Duration 5 days NETWORK DEVOPS COURSE CONTENTS * What is DevOps Programming and automating networks, networks and clouds, AWS, OpenStack, SDN, DevOps for network operations. * Initial configuration Configuring SSH, ZTP, POAP. Hands on Initial lab configuration. * Getting started with ansible The language, the engine, the framework. Uses of ansible, orchestration. The architecture, Controlling machines, nodes, Agentless, SSH, modules. Configuration management, inventories, playbooks, modules, roles. Hands on Installing ansible, running ad hoc commands. * Ansible playbooks ansible-playbook, YAML, plays, tasks, handlers, modules. Playbook variables. Register module, debug module. Hands on Running playbooks. * Ansible Inventories /etc/ansible/hosts, hosts, groups, static inventories, dynamic inventories. Inventory variables, external variables. Limiting hosts. Hands on Static inventories, variables in inventory files. * Ansible modules for networking Built in modules, custom modules, return values. Core modules for network operations. Cisco and/or Juniper modules. ansible_connection. Ansible 2.6 CLI. Hands on Using modules. * Ansible templating and roles aConfiguration management, full configurations, partial configurations. The template module, the assemble module, connection: local, Jinja2 templates, variables, if, for, roles. Hands on Generating multiple configurations from a template. * Network programming and modules Why use Python? Why use ansible? alternatives, ansible tower, Linux network devices. * Programming with Python Python programming Functions. Classes, objects and instances, modules, libraries, packages. Python strings, Python file handling, pip list, pip instal. Hands on Python programming with pyping. * More Python programming Functions. Classes, objects and instances, modules, libraries, packages. Python strings, Python file handling, pip list, pip install. Hands on Python programming with pyping. * Git Distributed version control, repositories, Git and GitHub, Alternatives to GitHub, Installing git, git workflows, creating repositories, adding and editing files, branching and merging, merge conflicts. Hands on working with Git. * Python and networking APIs, Sockets, Telnetlib, pysnmp, ncclient, ciscoconfparse. * Paramiko SSH and Netmiko Integrating Python and network devices using SSH. Netmiko, Netmiko methods. Hands on Netmiko. * NAPALM What is NAPALM, NAPALM operations, getters, Replace, merge, compare, commit, discard. Hands on Configuration with NAPALM. Integrating ansible and NAPALM. * Python and REST REST APIs, enabling the REST API. Accessing the REST API with a browser, cURL, Python and REST, the request library. Hands on Using a REST API with network devices.

NETWORK AUTOMATION COURSE DESCRIPTION This course is not a soft skills course covering the concepts of DevOps but instead concentrates on the technical side of tools and languages for network DevOps. Particular technologies focussed on are ansible, git and Python enabling delegates to leave the course ready to starting automating their network. Hands on sessions follow all major sections. More detailed courses on individual aspects of this course are available. WHAT WILL YOU LEARN * Evaluate network automation tools. * Automate tasks with ansible. * Use git for version control. * Use Python to manage network devices. * Use Python libraries for network devices. NETWORK AUTOMATION COURSE DETAILS * Who will benefit: Network engineers. * Prerequisites: TCP/IP foundation for engineers. * Duration 5 days NETWORK AUTOMATION COURSE CONTENTS * What is DevOps Programming and automating networks, networks and clouds, AWS, OpenStack, SDN, DevOps for network operations. * Initial configuration Configuring SSH, ZTP, POAP. Hands on Initial lab configuration. * Getting started with ansible The language, the engine, the framework. Uses of ansible, orchestration. The architecture, Controlling machines, nodes, Agentless, SSH, modules. Configuration management, inventories, playbooks, modules, roles. Hands on Installing ansible, running ad hoc commands. * Ansible playbooks ansible-playbook, YAML, plays, tasks, handlers, modules. Playbook variables. Register module, debug module. Hands on Running playbooks. * Ansible Inventories /etc/ansible/hosts, hosts, groups, static inventories, dynamic inventories. Inventory variables, external variables. Limiting hosts. Hands on Static inventories, variables in inventory files. * Ansible modules for networking Built in modules, custom modules, return values. Core modules for network operations. Cisco and/ or Juniper modules. ansible_connection. Ansible 2.6 CLI. Hands on Using modules. * Ansible templating and roles Configuration management, full configurations, partial configurations. The template module, the assemble module, connection: local, Jinja2 templates, variables, if, for, roles. Hands on Generating multiple configurations from a template. * Network programming and modules Why use Python? Why use ansible? alternatives, ansible tower, Linux network devices. * Programming with Python Scripting versus application development, Python interactive mode, Python scripts, Python 2.7 vs Python 3. A simple Python script. Variables, loops, control statements, operators. PEP style guide. Python IDEs. Hands on Simple Python programs. * More Python programming Functions. Classes, objects and instances, modules, libraries, packages. Python strings, Python file handling, pip list, pip install, Hands on Python programming with pyping. * Git Distributed version control, repositories, Git and GitHub, Alternatives to GitHub, Installing git, git workflows, creating repositories, adding and editing files, branching and merging, merge conflicts. Hands on working with Git. * Python and networking APIs, Sockets, Telnetlib, pysnmp, ncclient, ciscoconfparse. * Paramiko SSH and Netmiko Integrating Python and network devices using SSH. Netmiko, Netmiko methods. Hands on Netmiko. * PyEZ Juniper, NETCONF, installing PyEZ, a first pyEZ script, pyEZ configuration management. Hands on Juniper configuration management with pyEZ. * NAPALM What is NAPALM, NAPALM operations, getters, Replace, merge, compare, commit, discard. Hands on Configuration with NAPALM. Integrating ansible and NAPALM. * Python and REST REST APIs, enabling the REST API. Accessing the REST API with a browser, cURL, Python and REST, the request library. Hands on Using a REST API with network devices.

SOFTWARE DEVELOPMENT TRAINING COURSE DESCRIPTION This three-day MTA Training course helps you prepare for Microsoft Technology Associate Exam 98-361, and build an understanding of these topics: Core programming, Object-Oriented programming, general software development, web applications, desktop applications, and databases. This course leverages the same content as found in the Microsoft Official Academic Course (MOAC) for this exam. WHAT WILL YOU LEARN * Describe core programming. * Explain Object Oriented programming. * Describe general software development. * Describe Web applications. * Describe desktop applications. * Explain how databases work. SOFTWARE DEVELOPMENT TRAINING COURSE DETAILS * Who will benefit: Anyone looking to learn the fundamentals of software. * Prerequisites: None. * Duration 3 days SOFTWARE DEVELOPMENT TRAINING COURSE CONTENTS * Core programming * Computer storage and data types How a computer stores programs and the instructions in computer memory, memory stacks and heaps, memory size requirements for the various data storage types, numeric data and textual data. * Computer decision structures Various decision structures used in all computer programming languages; If decision structures; multiple decision structures, such as If…Else and switch/Select Case; reading flowcharts; decision tables; evaluating expressions. * Handling repetition For loops, While loops, Do...While loops and recursion. * Understand error handling Structured exception handling. * Object-oriented programming * Classes Properties, methods, events and constructors; how to create a class; how to use classes in code. * Inheritance Inheriting the functionality of a base class into a derived class. * Polymorphism Extending the functionality in a class after inheriting from a base class, overriding methods in the derived class. * Encapsulation Creating classes that hide their implementation details while still allowing access to the required functionality through the interface, access modifiers. * General software development * Application life cycle management Phases of application life cycle management, software testing. * Interpret application specifications Application specifications, translating them into prototypes, code, select appropriate application type and components. * Algorithms and data structures Arrays, stacks, queues, linked lists and sorting algorithms; performance implications of various data structures; choosing the right data structure. * Web applications * Web page development HTML, CSS, JavaScript. * ASP.NET web application development Page life cycle, event model, state management, client-side versus server-side programming. * Web hosting Creating virtual directories and websites, deploying web applications, understanding the role of Internet Information Services. * Web services Web services that will be consumed by client applications, accessing web services from a client application, SOAP, WSDL. * Desktop applications * Windows apps UI design guideline categories, characteristics and capabilities of Store Apps, identify gestures. * Console-based applications Characteristics and capabilities of console- based applications. * Windows Services Characteristics and capabilities of Windows Services. * Databases * Relational database management systems Characteristics and capabilities of database products, database design, ERDs, normalisation concepts. * Database query methods SQL, creating and accessing stored procedures, updating and selecting data. * Database connection methods Connecting to various types of data stores, such as flat file; XML file; in-memory object; resource optimisation.

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 VISUAL BASIC TRAINING COURSE DESCRIPTION A hands-on introduction to programming in Visual BASIC V6. WHAT WILL YOU LEARN * Build Visual BASIC applications. * Build simple components. * Debug Visual BASIC programs. * Examine existing code and determine its function. COMPLETE VISUAL BASIC TRAINING COURSE DETAILS * Who will benefit: Anyone wishing to program in Visual BASIC. * Prerequisites: None although experience in another high level language would be useful. * Duration 5 days COMPLETE VISUAL BASIC TRAINING COURSE CONTENTS * Application development using VB VB features. VB editions, VB terminology. Working in the Development Environment. Event-Driven Programming. Creating a program in VB. Project and executable files. VB reference materials. * Visual Basic fundamentals Objects. Controlling objects. Introduction to forms. Introduction to controls. Basic controls. * Working with code and forms Modules. Working with code. Interacting with the user. Working with code statements. Managing forms. * Variables and procedures Introduction to variables and constants. Working with Procedures and Functions. * Controlling program execution Common VB functions. Comparison and relational operators. Conditional structures. Looping structures. * Debugging Error types. Debugging logic errors in VB. * Working with controls Control types. Standard controls. Advanced standard controls. ActiveX controls. Insertable controls. * Data access using the ADO data control Overview of ActiveX Data Objects. VB data access features. Relational database concepts. Using the ADO data Control to access data. SQL. Manipulating data. Using the data form wizard. * Input validation Field-Level validation. The masked edit control. Form-Level validation. Form events used when validating data. * Error trapping Trapping run time errors. Error handling overview. Enabling an error trap. Errors and the calling chain. In line error handling. * Enhancing the User Interface Menus. Status bars. Toolbars. * Drag and Drop Overview of Drag and Drop. Mouse events Drag and Drop basics. * More about controls Using control arrays. Using the controls collection. Working with object variables. Collections. * Finishing touches User Interface design principles. Distributing an application. Creating a default project.

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.

OVERVIEW -------------------------------------------------------------------------------- Data and visual analytics are emerging fields concerned with analysing, modelling, and visualizing complex high-dimensional data. It can be analysed and visualised with many languages like Python, R Programming and more. This course will help to attain the skills and give in-depth knowledge to the participant's enhanced way of modelling, analysing and visualizing techniques.  The course will highlight practical challenges including composite real-world data and will also comprise several practical studies