75 XML courses delivered Live Online

Duration 3 Days 18 CPD hours This course is intended for This course is intended for IT professionals who are experienced in general Windows Server and Windows Client administration. Students should have a foundational knowledge of Windows PowerShell, which they can obtain by taking course 10961C: Automating Administration with Windows PowerShell. In addition, this course provides scripting guidance for Microsoft Azure administrators and developers who support development environments and deployment processes. Overview After completing this course, you will be able to: Create advanced functions. Use Microsoft .NET Framework and REST API in Windows PowerShell. Handle script errors. Use XML, JSON, and custom formatted data. Manage Microsoft Azure resources Analyze and debug scripts Understand Windows PowerShell workflow. This course teaches students how to automate administrative tasks using PowerShell. Students will learn crucial scripting skills such as creating advanced functions, writing controller scripts, and handling script errors. Candidates will learn how to use PowerShell when working with Microsoft Azure, SQL Server, Active Directory, IIS, Windows PowerShell Workflow, .NET resources, the REST API and XML, CSV & JSON formatted data files.This course replaces retired Microsoft course 10962. MODULE 1: CREATING ADVANCED FUNCTIONS * Lesson 1: Converting a command into an advanced function * Lesson 2: Creating a script module * Lesson 3: Defining parameter attributes and input validation * Lesson 4: Writing functions that accept pipeline input * Lesson 5: Producing complex pipeline output * Lesson 6: Using comment-based Help * Lesson 7: Using Whatif and Confirm parameters MODULE 2: USING MICROSOFT .NET FRAMEWORK AND REST API IN WINDOWS POWERSHELL * Lesson 1: Using .NET Framework in PowerShell * Lesson 2: Using REST API in PowerShell MODULE 3: WRITING CONTROLLER SCRIPTS * Lesson 1: Understanding controller scripts * Lesson 2: Writing controller scripts with a user interface * Lesson 3: Writing controller scripts that create reports MODULE 4: HANDLING SCRIPT ERRORS * Lesson 1: Understanding error handling * Lesson 2: Handling errors in a script MODULE 5: USING XML, JSON, AND CUSTOM-FORMATTED DATA * Lesson 1: Working with XML formatted data * Lesson 2: Working with JSON formatted data * Lesson 3: Working with custom-formatted data MODULE 6: ENHANCING SERVER MANAGEMENT WITH DESIRED STATE CONFIGURATION AND JUST ENOUGH ADMINISTRATION * Lesson 1: Implementing Desired State Configuration * Lesson 2: Implementing Just Enough Administration MODULE 7: ANALYZING AND DEBUGGING SCRIPTS * Lesson 1: Debugging in Windows PowerShell * Lesson 2: Analyzing and debugging an existing script MODULE 8: UNDERSTANDING WINDOWS POWERSHELL WORKFLOW * Lesson 1: Understanding Windows PowerShell Workflows * Lesson 2: Running Windows PowerShell Workflows

Rally training webinar for co-drivers looking to take the step up from single venue stage rallies or road rallying to multi-venue stage rallies.

XML PRIMER TRAINING COURSE DESCRIPTION This course has been designed for web and intranet developers who want to accelerate their learning of XML and its applications without the grind of book learning. Although a basic knowledge of HTML and JavaScript is assumed, it is also assumed you know very little about XML and how to use it. On completion of this course you should understand the benefits of using XML and be able to design XML solutions where applicable to your company's Internet/intranet requirements. The course will be particularly beneficial if you want to know how to communicate data to diverse applications over the Internet or company intranet. WHAT WILL YOU LEARN * Write XML. * Debug XML. * Examine existing code and determine its function. XML PRIMER TRAINING COURSE DETAILS * Who will benefit: Anyone working with XML. * Prerequisites: HTML5 development fundamentals * Duration 3 days XML PRIMER TRAINING COURSE CONTENTS * The origins of XML Markup languages, SGML, document type definitions and validity, introducing XML, IE and XML, accessing content and adding style. * Basic XML XML document structure, elements and attributes, grammar, well formed documents, other XML elements and references. * Document Type Definition (DTDs) Creating a DTD, basic declaration, declaring elements, content definitions, entities, entity declarations, notations, defining attributes, attribute types, forcing inclusion or exclusion of DTD sections, validation. * Namespaces Declaring namespaces, scoping, removing and changing namespaces, qualified names, attribute namespaces. * An introduction to schemas Constructing schemas, defining the root element and its contents,<ELEMENTTYPE>, defining root element contents, adding attributes definitions, <ATTRIBUTETYPE>, <ELEMENT>, <ATTRIBUTE>. * XML & the Document Object Model (DOM) What the DOM offers, DOM and W3C. * Basic DOM concepts XML documents as trees, terminology of tree elements. Key DOM Objects: The document object and its creation, base objects, IE specifics, the XML node hierarchy. * Programming DOM Viewing a DOM model as XML, getting the root element of a document, iterating nodes of a DOM, basic node properties, collection objects, searching for specific values, filtering a nodelist by tagname, more filtering methods, selecting nodes from their attributes. * Amending Content and Structure Creating/saving a DOM as XML, changing content/structure, dynamically building a DOM. * Using ASP and other techniques ASP techniques, HTTPREQUEST object, XSL, transforming and formatting XML. Formatting Using CSS. CSS And XML. * XSL Transformations - XSLT Introduction, the XSL root element, applying XSL stylesheets to XML, XSL elements and operations, instructions - creating text nodes and applying templates, a 'drill-down' approach, simple output formatting, pattern filters - patterns based on position, the Match and Select attributes and their patterns, formatting output, creating new XML in output.

Duration 1 Days 6 CPD hours This course is intended for Individuals with basic computer skills, familiar with concepts related to database structure and terminology, and who want to use SQL to query databases. Overview Upon successful completion of this course, students will be able to: - connect to the SQL Server database and execute a simple query. - include a search condition in a simple query. - use various functions to perform calculations on data. - organize data obtained from a query before it is displayed on-screen. - retrieve data from tables. - format an output, save a result, and generate a report. In this course, students will compose SQL queries to retrieve desired information from a database. 1 - EXECUTING A SIMPLE QUERY * Connect to the SQL Database * Query a Database * Save a Query * Modify a Query * Execute a Saved Query 2 - PERFORMING A CONDITIONAL SEARCH * Search Using a Simple Condition * Compare Column Values * Search Using Multiple Conditions * Search for a Range of Values and Null Values * Retrieve Data Based on Patterns 3 - WORKING WITH FUNCTIONS * Perform Date Calculations * Calculate Data Using Aggregate Functions * Manipulate String Values 4 - ORGANIZING DATA * Sort Data * Rank Data * Group Data * Filter Grouped Data * Summarize Grouped Data * Use PIVOT and UNPIVOT Operators 5 - RETRIEVING DATA FROM TABLES * Combine Results of Two Queries * Compare the Results of Two Queries * Retrieve Data by Joining Tables * Check for Unmatched Records * Retrieve Information from a Single Table Using Joins 6 - PRESENTING QUERY RESULTS * Save the Query Result * Generate an XML Report

Duration 3 Days 18 CPD hours This course is intended for This is an introductory-level XML training course, designed for those needing an introduction to concepts and technologies associated with XML and its related recommendations. Previous experience or knowledge of HTML is helpful but not essential. Overview This course is an intensive, hands-on introduction to XML, XPath, and XSLT. The course is a balanced mixture of theory and practical labs designed to take students from the basic fundamentals of XML through to the related advanced technologies. The students walk through the different standards in a structured manner to enable them to master the concepts and ideas, which are reinforced in the lab exercises. The course starts with the fundamentals of XML, including coverage of DTDs and XML Schema. It then moves on to the XPath and XSLT standards, and how to use them to transform XML documents into other documents such as HTML documents or other XML documents. This course provides indoctrination in the practical use of W3C standards (including XSL and XML Schema) and of implementing tools and technologies. This course is programming language independent, making it useful for Java, .NET, C++, and any other programming orientation. Graduates will hit the ground running, applying XML to projects at both an architectural as well as a line by line coding level. We can easily adapt this course to industry and client specific needs.In addition to valuable knowledge and working examples, students receive a copy of the 'Xtensil' product. This unique software was developed to assist in implementing, testing, and fielding XML applications. Xtensil is used as both a teaching aid and a straightforward, basic, fully functional XML toolkit that students can use on Windows and Linux platforms. Working in a hands-on learning environment student will learn to: Write well-formed XML documents Model business requirements using XML Handle XML reserved characters Validate an XML document with a DTD and with a Schema Centralize data and markup definition with entities Create DTDs and Schemas using XML tools Generate XML documents from databases Write XSL templates to transform XML documents into HTML Integrate XML, XSL and the DOM to implement a complete solution The Extensible Markup Language (XML) is a standard that is enabling a revolution in web applications and business to business interactions. XML is the basis for Wireless Markup Language (WML), Voice Markup Language (VoiceML), Simple Object Access Protocol (SOAP), Web Services, and numerous industry initiatives such as ACORD (insurance), PXML (proposal/RFP) and OTA (travel). Introduction to XML is a three-day, hands-on course geared for software developers who need to understand what XML is and how to use in with today's systems and architectures. This course covers the topics from tags to architectures. The course is a balanced mixture of theory and practical labs designed to take students from a quick review of the basic fundamentals of XML through to the related advanced technologies. The students walk through the different standards in a structured manner to enable them to master the concepts and ideas, which are reinforced in the lab exercises. The course starts with a quick review of the fundamentals of XML before covering XML Schema in detail. It then moves on to the XPath and XSLT covering advanced topics in both. Finally, XML and Web Services security mechanisms and issues are addressed. XML CONTENT * Introduction to XML * XML Mechanics XML STRUCTURE * Namespaces * Structure Using Schemas XML FORMATTING * CSS and Rendering XML * XSL Transformations * XSLT and XPath * XPath 2.0 and XSLT 2.0 Overview * XSL FO (Formatting Objects) APPLYING XML * XML Interoperability * XML Performance Improvements * Web Services Overview * XML Applications ADDITIONAL COURSE DETAILS: Nexus Humans Introduction to XML (TT4300) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Introduction to XML (TT4300) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

XSLT 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 * Transform and style XML documents using XSLT. XSLT TRAINING COURSE DETAILS * Who will benefit: Anyone working with XSLT. * Prerequisites: XML primer * Duration 2 days XSLT TRAINING COURSE CONTENTS * Introduction Extensible Stylesheet Language (XSL), transforming and formatting XML. * XML refresher The basic rules for building an XML document. * An introduction to XSLT The basic concepts of XSLT, xsl:output, xsl:template, xsl:value-of. * XML documents as trees How the original XML is transformed into a set of nodes, the general terms for manipulating node trees. * Paths (XPath) Use of path matching to select required nodes for transformation. * Using templates xsl:apply-templates, xsl:template match, nested templates, xsl:copy , <comment> and <element> , default templates, parameters. * Control xsl:if, xsl:choose, xsl:for-each, xsl:sort. * Constructing the result tree xsl:output, xsl:attribute, xsl:attribute-set, xsl:comment, xsl:processing-instruction, xsl:text, xsl:value-of, xsl:variable. * Combining templates xsl:include, xsl:import, xsl:apply-imports. * Transforming to text

TOTAL SIPP COURSE DESCRIPTION SIPp is a robust performance testing tool designed for evaluating the SIP protocol. This comprehensive course takes you on a journey from the initial installation of SIPp to mastering fundamental scenarios, exploring diverse architectures, delving into statistics analysis, and crafting XML scenario files. WHAT WILL YOU LEARN * Monitor SIP traffic with SIPp. * Use SIPp for performance testing. * Use the standard SIPp scenarios. * Create custom scenarios in XML for SIPp. TOTAL SIPP COURSE DETAILS * Who will benefit: Those working with SIP. * Prerequisites: Definitive SIP for engineers * Duration 2 days TOTAL SIPP COURSE CONTENTS * Introduction What is SIPp? SIP review: UAC, UAS, INVITE, BYE. Sample SIP call flows. Hands on Wireshark, SIP call flow. * Installing SIPp Getting SIPp, installing SIPp. * Using SIPp Running sipp. sipp with uas scenario, sipp with uac scenario. The integrated scenarios. Online help. Hands on uac, uas. * Controlling SIPp Hot keys, commands, UDP socket. Running SIPp in the background. Traffic control. SIPp performance testing. Hands on Changing call rates, remote control, pausing traffic. * Monitoring SIP traffic Scenario screen, statistics. Response times, counters. Hands on Monitoring SIP traffic. * More integrated scenarios SIPp and media and RTP. 3PCC. 3PCC extended. Transport modes: UDP, TCP, TLS, SCTP, IPv6 mono and multi socket. Hands on Third Party Call Control. * XML What is XML? Content, markup, elements, attributes. Start tags, end tags. Hands on Displaying embedded scenarios, looking at the XML files of the integrated scenarios. * Creating your own XML scenarios scenario, message commands, send, recv, nop, pause, sendCmd, recvCmd, common sipp scenario attributes, command specific sipp scenario attributes. XML DTD, jEdit. Hands on uac and uas scenario XML files. * Recv actions Log and warning, exec, variables, variable types, variable scope. External variables. Hands on RTP streaming, Change a calls network destination, injection files. * Regular expressions What is an RE. POSIX 1003.2. Re injection. Validation. Hands on regex example.

WEB DEVELOPMENT TRAINING COURSE DESCRIPTION This three-day course helps build a foundation in the development of Web applications. This is not a HTML course but covers the technologies needed to develop web applications. Technologies covered include: ASP.NET, XML, AJAX and HTTP error codes. WHAT WILL YOU LEARN * Program Web applications. * Work with data and services. * Troubleshoot and debug Web applications. * Work with client side scripting. * Configure and deploy web applications. WEB DEVELOPMENT TRAINING COURSE DETAILS * Who will benefit: Anyone looking for an introduction to web development. * Prerequisites: None. * Duration 3 days WEB DEVELOPMENT TRAINING COURSE CONTENTS * Programming web applications * Customise the layout and appearance of a web page CSS; tables; embedding images; page layout for navigation. * Understand ASP.NET intrinsic objects Request; Server; Application; Session; Response; HttpContext. * Understand state information in web applications Understand how state is stored based on application design and hardware; understand different types such as session state, view state, control state and application state. * Understand events and control page flow Application and page life cycle events; page events; control events; application events; session events; cross-page posting; Response.Redirect; Server.Transfer; IsPostBack; setting AutoEventWireup. * Understand controls Understanding various types of controls, including user, server, web and validation controls; know which is the appropriate type of control for a scenario. * Understand configuration files Understanding the usage of web.config and machine.config, and the settings that can be made. * Working with data and services * Read and write XML data Understanding XML, XML validation Does not include: Web services; XPath syntax; XmlDocument; XPathNavigator; XPathNodeIterator; XPathDocument; XmlReader; XmlWriter; XmlDataDocument; XmlNamespaceManager. * Distinguish between DataSet & DataReader objects The ability to choose the proper data object to use based on application requirements/design. * Call a service from a web page Creating a basic WCF service or web service so that it can be consumed; App_WebReferences; configuration. * Understand DataSource controls LinqDataSource: ObjectDataSource; XmlDataSource; SqlDataSource. * Bind controls to data by using data binding syntax Ensure that data is updated and displayed in data-aware controls. * Manage data connections and databases Database connections; connection objects; connection pools; transaction objects. * Troubleshooting and debugging web applications * Debug a web application Use in conjunction with custom error pages to display appropriate error information to the appropriate user; implement tracing of a web application, Trace.axd, Trace=True on @Page directive. * Handle web application errors HTTP error codes. * Working with client-side scripting * Understand client-side scripting Purpose of client-side scripting; various client-side scripting languages. LE/370 and Intrinsic Functions. * Understand AJAX concepts ASP.NET AJAX implementation; working with client-side libraries, EnablePartialRendering, Triggers, ChildrenAsTriggers, Scripts, Services, UpdateProgress, Timer, ScriptManagerProxy, extender controls. * Configuring and deploying web applications * Configure authentication and authorisation Forms authentication, Windows authentication; authorisation; file authorisation; impersonation Does not include: Windows Cardspace authentication, Passport (Windows Live ID) authentication, Custom authentication. * Configure projects, solutions and reference assemblies Local assemblies; shared assemblies (GAC); web application projects; solutions; configuration files; AppSettings. * Publish web applications Choosing the appropriate method to deploy an application based on existing or intended environment; updatable vs. not updateable; MSI deployment; Internet Information Server (IIS) installation and configuration. * Understand application pools Purpose of application pools; effect of application pools on web applications.

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.

Duration 5 Days 30 CPD hours This course is intended for The primary audience for this course is database professionals who need to fulfil a Business Intelligence Developer role. They will need to focus on hands-on work creating BI solutions including Data Warehouse implementation, ETL, and data cleansing. Overview Create sophisticated SSIS packages for extracting, transforming, and loading data Use containers to efficiently control repetitive tasks and transactions Configure packages to dynamically adapt to environment changes Use Data Quality Services to cleanse data Successfully troubleshoot packages Create and Manage the SSIS Catalog Deploy, configure, and schedule packages Secure the SSIS Catalog SQL Server Integration Services is the Community Courseware version of 20767CC Implementing a SQL Data Warehouse. This five-day instructor-led course is intended for IT professionals who need to learn how to use SSIS to build, deploy, maintain, and secure Integration Services projects and packages, and to use SSIS to extract, transform, and load data to and from SQL Server. This course is similar to the retired Course 20767-C: Implementing a SQL Data Warehouse but focuses more on building packages, rather than the entire data warehouse design and implementation. Prerequisites Working knowledge of T-SQL and SQL Server Agent jobs is helpful, but not required. Basic knowledge of the Microsoft Windows operating system and its core functionality. Working knowledge of relational databases. Some experience with database design. 1 - SSIS OVERVIEW * Import/Export Wizard * Exporting Data with the Wizard * Common Import Concerns * Quality Checking Imported/Exported Data 2 - WORKING WITH SOLUTIONS AND PROJECTS * Working with SQL Server Data Tools * Understanding Solutions and Projects * Working with the Visual Studio Interface 3 - BASIC CONTROL FLOW * Working with Tasks * Understanding Precedence Constraints * Annotating Packages * Grouping Tasks * Package and Task Properties * Connection Managers * Favorite Tasks 4 - COMMON TASKS * Analysis Services Processing * Data Profiling Task * Execute Package Task * Execute Process Task * Expression Task * File System Task * FTP Task * Hadoop Task * Script Task Introduction * Send Mail Task * Web Service Task * XML Task 5 - DATA FLOW SOURCES AND DESTINATIONS * The Data Flow Task * The Data Flow SSIS Toolbox * Working with Data Sources * SSIS Data Sources * Working with Data Destinations * SSIS Data Destinations 6 - DATA FLOW TRANSFORMATIONS * Transformations * Configuring Transformations 7 - MAKING PACKAGES DYNAMIC * Features for Making Packages Dynamic * Package Parameters * Project Parameters * Variables * SQL Parameters * Expressions in Tasks * Expressions in Connection Managers * After Deployment * How It All Fits Together 8 - CONTAINERS * Sequence Containers * For Loop Containers * Foreach Loop Containers 9 - TROUBLESHOOTING AND PACKAGE RELIABILITY * Understanding MaximumErrorCount * Breakpoints * Redirecting Error Rows * Logging * Event Handlers * Using Checkpoints * Transactions 10 - DEPLOYING TO THE SSIS CATALOG * The SSIS Catalog * Deploying Projects * Working with Environments * Executing Packages in SSMS * Executing Packages from the Command Line * Deployment Model Differences 11 - INSTALLING AND ADMINISTERING SSIS * Installing SSIS * Upgrading SSIS * Managing the SSIS Catalog * Viewing Built-in SSIS Reports * Managing SSIS Logging and Operation Histories * Automating Package Execution 12 - SECURING THE SSIS CATALOG * Principals * Securables * Grantable Permissions * Granting Permissions * Configuring Proxy Accounts ADDITIONAL COURSE DETAILS: Nexus Humans 55321 SQL Server Integration Services training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the 55321 SQL Server Integration Services course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.