Name: Elite coding course
Price: 300 GBP
Availability: InStock

Redhill

<h3><b>SMPTE 2110 training course description</b></h3>
        <p> This course studies the new SMPTE ST 2110 suite of
          standards. The course covers all parts of the standard
          from SMPTE ST 2110-10 through to SMPTE ST 2110-
          50. The course begins with an introduction to all IP
          studios and separating video and audio streams, then
          moves on to PTP and synchronisation. Video
          encapsulation is then followed by audio encapsulation.
          Handling ancillary data finishes the course.</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
        <li>Recognise the benefits of SMPTE ST 2110.</li>
        <li>Describe SMPTE ST 2110.</li>
        <li>Explain how the SMPTE 2110 standards work.</li>
        <li>Compare and contrast SMPTE 2110 and SMPTE
          2022.</li>
        </ul>
        <h5>
        <b>SMPTE 2110 training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Anyone working in broadcast. </p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>IP broadcast fundamentals</p>
              
							<li><b>Duration</b></li>
							
              <p>1 day</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>SMPTE 2110 training course contents</b></h3>
      <ul>
        <li>Introduction</li>
        <p> The all IP studio.
          Review of IP and RTP.
          Role of SMPTE,
          SMPTE 2022,
          What is SMPTE 2110,
          SMPTE 2022 versus 2110,
          SMPTE 2110 parts,
          multiplex standards,
          2110 separate streams,
          Video,
          Audio,
          ANC.
          Essences. </p>
        <li>Separate streams and synchronisation</li>
        <p> The old way,
          blackburst,
          time code,
          DARS.
          SMPTE 2110-10,
          ST2059,
          PTP,
          PTP architecture,
          PTP accuracy,
          How PTP works,
          Offset and delay
          PTP clock types,
          Hardware time stamping
          SDP.
          Hybrids. </p>
        <li>Uncompressed video</li>
        <p> SMPTE 2110-20,
          2110-21.
          Image support,
          raster sizes,
          bit depth,
          active video and no blanking,
          bandwidth and bandwidth savings,
          pgroups.
          Timestamps.
          Packing modes.
          Packet sizes,
          pixels per packet. </p>
        <li>Audio</li>
        <p> SMPTE 2110-30,
          2110-31,
          PCM,
          AES3.
          Allowed versus required.
          Channels and streams. </p>
        <li>Ancillary data</li>
        <p> SMPTE 2110-40,
          RFC on RTP payloads for ST 291 ancillary data. </p>
      </ul>

Systems & Network Training

Network & Security

Network Engineer

SMPTE 2110 for engineers

General Admission

<h3><b>Integrating UNIX and Microsoft course description</b></h3>
      <p>This course is designed for the enterprise-level UNIX
professional and represents the highest level of
professional, distribution-neutral UNIX certification
within the industry.<br /><br />
It covers administering UNIX enterprise-wide with an
emphasis on mixed environments.</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
			 <li>Configure and troubleshoot OpenLDAP.</li>
					<li>Use OpenLDAP as an authentication backend.</li>
					<li>Manage software packages.</li>
                    <li>Use Samba<br />
- Share configuration<br />
- User and group management<br />
- Domain integration<br />
- Name services<br />
- with Linux and Windows clients</li></ul> 
        <h5>
        <b>Integrating UNIX and Microsoft course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Enterprise-level UNIX professionals.</p>
						   
              
							<li><b>Prerequisites:</b></li>
							
              <p>UNIX network administration.
							</p>
              
							<li><b>Duration</b></li>
							
              <p>5 days
						</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>Integrating UNIX and Microsoft course contents</b></h3>
      <ul>
				<li><b>OPENLDAP CONFIGURATION</b> </li><p>
</p><li>OpenLDAP replication </li><p>
Replication concepts, OpenLDAP replication, replication log files, replica hubs, LDAP referrals, LDAP sync replication.

</p><li>Securing the Directory </li><p>
Securing the directory with SSL and TLS, Firewall considerations, Unauthenticated access methods, User/password authentication methods, Maintanence of SASL user DB, certificates.

</p><li>OpenLDAP Server Performance Tuning </li><p>
Measure OpenLDAP performance, Tune software configuration to increase performance, indexes.

				</p><li><b>OPENLDAP AS AN AUTHENTICATION BACKEND LDAP</b> </li><p>
</p><li>Integration with PAM and NSS </li><p>
Configure PAM to use LDAP for authentication, NSS to retrieve information from LDAP and PAM modules in UNIX.

</p><li>Integrating LDAP with Active Directory and Kerberos </li><p>
Kerberos integration with LDAP, Cross platform authentication, Single sign-on concepts, Integration and compatibility limitations between OpenLDAP and Active Directory.

				</p><li><b>SAMBA BASICS</b> </li><p>
</p><li>Samba Concepts and Architecture </li><p>
Samba daemons and components, key issues regarding heterogeneous network, Identify key TCP/UDP ports used with SMB/CIFS, Knowledge of Samba3 and Samba4 differences.

</p><li>Configure Samba </li><p>
Samba server configuration file structure, variables and configuration parameters, Troubleshoot and debug configuration problems.

</p><li>Regular Samba Maintenance </li><p>
Monitor and interact with running Samba daemons, Perform regular backups of Samba configuration and state data.

</p><li>Troubleshooting Samba </li><p>
Samba logging, Backup TDB files, Restore TDB files, Identify TDB file corruption, Edit / list TDB file content.

</p><li>Internationalization </li><p>
Internationalization character codes and code pages, differences in the name space between Windows and Linux/Unix with respect to share, names, user/group/computer naming in a non-English environment.

				</p><li><b>SAMBA SHARE CONFIGURATION</b> </li><p>
</p><li>Linux File System and Share/Service Permissions </li><p>
File / directory permission control, Samba interaction with Linux file system permissions and ACLs, Use Samba VFS to store Windows ACLs.

</p><li>Print Services </li><p>
Printer sharing, integration between Samba and CUPS, Manage Windows print drivers and configure downloading of print drivers, security concerns with printer sharing.

				</p><li><b>SAMBA USER AND GROUP MANAGEMENT</b> </li><p>
</p><li>Managing User Accounts and Groups </li><p>
User and group accounts, mappings, user account management tools, smbpasswd, file/directory ownership of objects.

</p><li>Authentication, Authorization and Winbind </li><p>
Local password database, password synchronization, passdb backends, Convert between passdb backends, Integrate Samba with LDAP, Winbind service, PAM and NSS.

				</p><li><b>SAMBA DOMAIN INTEGRATION</b> </li><p>
</p><li>Samba as a PDC and BDC </li><p>
Domain membership and trust relationships, Create and maintain a PDC and BDC with Samba3/4, Add computers to an existing domain, logon scripts, roaming profiles, system policies.

</p><li>Samba4 as an AD compatible Domain </li><p>
Samba 4 as an AD DC, smbclient, how Samba integrates with AD services: DNS, Kerberos, NTP, LDAP.

</p><li>Configure Samba as a Domain Member Server </li><p>
Joining Samba to NT4 and AD domains, obtain a TGT from a KDC.

				</p><li><b>SAMBA NAME SERVICES</b> </li><p>
</p><li>NetBIOS and WINS </li><p>
WINS concepts, NetBIOS concepts, local master browser, domain master browser, Samba as a WINS server, name resolution, WINS replication, NetBIOS browsing and browser elections, NETBIOS name types.

</p><li>Active Directory Name Resolution </li><p>
DNS for Samba4 as an AD Domain Controller, DNS forwarding with the internal DNS server of Samba4.

		</p><li><b>WORKING WITH LINUX AND WINDOWS CLIENTS</b> </li><p>
</p><li>CIFS Integration </li><p>
SMB/CIFS concepts, remote CIFS shares from a Linux client, securely storing CIFS credentials, features and benefits of CIFS, permissions and file ownership of remote CIFS shares.

</p><li>Working with Windows Clients </li><p>
browse lists and SMB clients from Windows, Share file/print resources from Windows, the smbclient program, the Windows net utility.</p>
      </ul>

Integrating UNIX and Microsoft

<h3><b>Integrating Linux and Microsoft course description</b></h3>
      <p>This course is designed for the enterprise-level Linux
professional and represents the highest level of
professional, distribution-neutral Linux certification
within the industry.<br /><br />
LPIC-3 300 covers administering Linux enterprise-wide with an
emphasis on mixed environments.</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
			 <li>Configure and troubleshoot OpenLDAP.</li>
					<li>Use OpenLDAP as an authentication backend.</li>
					<li>Manage software packages.</li>
                    <li>Use Samba<br />
- Share configuration<br />
- User and group management<br />
- Domain integration<br />
- Name services<br />
- with Linux and Windows clients</li></ul> 
        <h5>
        <b>Integrating Linux and Microsoft course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Enterprise-level Linux professionals.</p>
						   
              
							<li><b>Prerequisites:</b></li>
							
              <p>Delegates must have an active LPIC-2 certification to
receive LPIC-3 certification, but the LPIC-2 and LPIC-3
exams may be taken in any order.
							</p>
              
							<li><b>Duration</b></li>
							
              <p>5 days
						</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>Integrating UNIX and Microsoft course contents</b></h3>
      <ul>
				<li><b>OPENLDAP CONFIGURATION</b> </li><p>
</p><li>OpenLDAP replication </li><p>
Replication concepts, OpenLDAP replication, replication log files, replica hubs, LDAP referrals, LDAP sync replication.

</p><li>Securing the Directory </li><p>
Securing the directory with SSL and TLS, Firewall considerations, Unauthenticated access methods, User/password authentication methods, Maintanence of SASL user DB, certificates.

</p><li>OpenLDAP Server Performance Tuning </li><p>
Measure OpenLDAP performance, Tune software configuration to increase performance, indexes.

				</p><li><b>OPENLDAP AS AN AUTHENTICATION BACKEND LDAP</b> </li><p>
</p><li>Integration with PAM and NSS </li><p>
Configure PAM to use LDAP for authentication, NSS to retrieve information from LDAP and PAM modules in UNIX.

</p><li>Integrating LDAP with Active Directory and Kerberos </li><p>
Kerberos integration with LDAP, Cross platform authentication, Single sign-on concepts, Integration and compatibility limitations between OpenLDAP and Active Directory.

				</p><li><b>SAMBA BASICS</b> </li><p>
</p><li>Samba Concepts and Architecture </li><p>
Samba daemons and components, key issues regarding heterogeneous network, Identify key TCP/UDP ports used with SMB/CIFS, Knowledge of Samba3 and Samba4 differences.

</p><li>Configure Samba </li><p>
Samba server configuration file structure, variables and configuration parameters, Troubleshoot and debug configuration problems.

</p><li>Regular Samba Maintenance </li><p>
Monitor and interact with running Samba daemons, Perform regular backups of Samba configuration and state data.

</p><li>Troubleshooting Samba </li><p>
Samba logging, Backup TDB files, Restore TDB files, Identify TDB file corruption, Edit / list TDB file content.

</p><li>Internationalization </li><p>
Internationalization character codes and code pages, differences in the name space between Windows and Linux/Unix with respect to share, names, user/group/computer naming in a non-English environment.

				</p><li><b>SAMBA SHARE CONFIGURATION</b> </li><p>
</p><li>Linux File System and Share/Service Permissions </li><p>
File / directory permission control, Samba interaction with Linux file system permissions and ACLs, Use Samba VFS to store Windows ACLs.

</p><li>Print Services </li><p>
Printer sharing, integration between Samba and CUPS, Manage Windows print drivers and configure downloading of print drivers, security concerns with printer sharing.

				</p><li><b>SAMBA USER AND GROUP MANAGEMENT</b> </li><p>
</p><li>Managing User Accounts and Groups </li><p>
User and group accounts, mappings, user account management tools, smbpasswd, file/directory ownership of objects.

</p><li>Authentication, Authorization and Winbind </li><p>
Local password database, password synchronization, passdb backends, Convert between passdb backends, Integrate Samba with LDAP, Winbind service, PAM and NSS.

				</p><li><b>SAMBA DOMAIN INTEGRATION</b> </li><p>
</p><li>Samba as a PDC and BDC </li><p>
Domain membership and trust relationships, Create and maintain a PDC and BDC with Samba3/4, Add computers to an existing domain, logon scripts, roaming profiles, system policies.

</p><li>Samba4 as an AD compatible Domain </li><p>
Samba 4 as an AD DC, smbclient, how Samba integrates with AD services: DNS, Kerberos, NTP, LDAP.

</p><li>Configure Samba as a Domain Member Server </li><p>
Joining Samba to NT4 and AD domains, obtain a TGT from a KDC.

				</p><li><b>SAMBA NAME SERVICES</b> </li><p>
</p><li>NetBIOS and WINS </li><p>
WINS concepts, NetBIOS concepts, local master browser, domain master browser, Samba as a WINS server, name resolution, WINS replication, NetBIOS browsing and browser elections, NETBIOS name types.

</p><li>Active Directory Name Resolution </li><p>
DNS for Samba4 as an AD Domain Controller, DNS forwarding with the internal DNS server of Samba4.

		</p><li><b>WORKING WITH LINUX AND WINDOWS CLIENTS</b> </li><p>
</p><li>CIFS Integration </li><p>
SMB/CIFS concepts, remote CIFS shares from a Linux client, securely storing CIFS credentials, features and benefits of CIFS, permissions and file ownership of remote CIFS shares.

</p><li>Working with Windows Clients </li><p>
browse lists and SMB clients from Windows, Share file/print resources from Windows, the smbclient program, the Windows net utility.</p>
      </ul>

Integrating Linux and Microsoft

<h3><b>Complete Python training course description</b></h3>
        <p> Python is an agile, robust, expressive, fully objectoriented,
          extensible, and scalable programming
          language. It combines the power of compiled
          languages with the simplicity and rapid development of
          scripting languages. This course covers Python from
          the very basics of 'hello world!' through to object
          oriented programming and advanced topics such as
          multi threading. Hands on follows all the major sections
          in order to reinforce the theory.</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
	    <li>Read Python programs.</li>
        <li>Write Python programs.</li>
        <li>Debug Python programs.</li>
        <li>Use Python's objects and memory model as well as
          its OOP features.</li>
        </ul>
        <h5>
        <b>Complete Python programming training course details</b></h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
               <p>Anyone wishing to learn Python. </p>
              
							<li><b>Prerequisites:</b></li>
							
             <p> None. </p>
              
							<li><b>Duration</b></li>
							
              <p>5 days
						</p>
              
							
             
              
						</ul>
					</div>
				</div>
       <h3><b>Complete Python programming training course contents</b></h3>
      <ul>
        <li>Welcome to Python: </li>
        <p> What is Python? Origins, features. Downloading and installing Python, Python manuals, comparing Python, other implementations. </p>
        <li>Getting started: </li>
        <p> Program output, the print statement, "hello world!", Program input, raw_input(), comments, operators, variables and assignment, numbers, strings, lists and tuples, dictionaries, indentation, if statement, while Loop, for loop. range(), list comprehensions. Files, open() and file() built-in functions. Errors and exceptions. Functions, Classes, Modules, useful functions. </p>
        <li>Python basics: </li>
        <p> Statements and syntax, variable assignment, identifiers, basic style guidelines, memory management, First Python programs, Related modules/developer tools. </p>
        <li>Python Objects: </li>
        <p> Other built-in types, Internal Types, Standard type operators, Standard type built-in functions, Categorizing standard types, Unsupported types. </p>
        <li>Numbers: </li>
        <p> Integers, Double precision floating point numbers, Complex numbers, Operators, Built-in and factory functions, Other numeric types. </p>
        <li>Sequences: strings, lists, and tuples: </li>
        <p> Sequences, Strings, Strings and operators, String-only operators, Built-in functions, String built-in methods, Special features of strings, Unicode, Summary of string highlights, Lists, Operators, Built-in functions, List type built-in methods, Special features of lists, Tuples, Tuple operators and built-in functions, Tuples special features, Copying Python objects and shallow and deep copies. </p>
        <li>Mapping and set types: </li>
        <p> Mapping Type: dictionaries and operators, Mapping type built-in and factory functions, Mapping type built-in methods, Dictionary keys, Set types, Set type operators, Built-in functions, Set type built-in methods. </p>
        <li>Conditionals and loops: </li>
        <p> If, else and elif statements, Conditional expressions, while, for, break, continue and pass statements, else statement . . . take two, Iterators and iter(), List comprehensions, Generator expressions. </p>
        <li>Files and input/output: </li>
        <p> File objects, File built-in functions [open() and file()], File built-in methods and attributes, Standard files, Command-line arguments, File system, File execution, Persistent storage modules. </p>
        <li>Errors and exceptions: </li>
        <p> What are exceptions? Detecting and handling exceptions, Context management, Exceptions as strings, Raising exceptions, Assertions, Standard exceptions, Creating Exceptions, Why exceptions, Exceptions and the sys module. </p>
        <li>Functions: </li>
        <p> Calling, creating and passing functions, formal arguments, variable-length arguments, functional programming, Variable scope, recursion, generators. </p>
        <li>Modules: </li>
        <p> Modules and files, Namespaces, Importing modules, Module import features, Module built-in functions, Packages, Other features of modules. </p>
        <li>Object-Oriented Programming (OOP): </li>
        <p> Classes, Class attributes, Instances, Instance attributes, Binding and method invocation, Static methods and class methods, Composition, Sub-classing and derivation, Inheritance, Built-in functions for classes, and other objects, Customizing classes with special methods, Privacy, Delegation, Advanced features of new-style classes (Python 2.2+), Related modules and documentation. </p>
        <li>Execution environment: </li>
        <p> Callable and code Objects, Executable object statements and built-in functions, Executing other programs. 'Restricted' and 'Terminating' execution, operating system interface. </p>
        <li>Regular expressions: </li>
        <p> Special symbols and characters, REs and Python, Regular expressions example. </p>
        <li>Network programming: </li>
        <p> Sockets: communication endpoints, Network programming in Python, SocketServer module, Twisted framework introduction. </p>
        <li>Internet client programming: </li>
        <p> What are internet clients? Transferring files, Network news, E-mail. </p>
        <li>Multithreaded Programming: </li>
        <p> Threads and processes Python, threads, and the global interpreter lock, The thread and threading Modules. </p>
        <li>GUI programming: </li>
        <p> Tkinter and Python programming, Tkinter Examples, Brief tour of other GUIs. </p>
        <li>Web programming: </li>
        <p> Web surfing with Python: creating simple web clients, Advanced Web clients, CGI: helping web servers process client data, Building CGI applications, Using Unicode with CGI, Advanced CGI, Web (HTTP) Servers. </p>
        <li>Database programming: </li>
        <p> Python database application programmer's interface (DB-API), ORMs. </p>
        <li>Miscellaneous </li>
        <p> Extending Python by writing extensions, Web Services, programming MS Office with Win32 COM, Python and Java programming with Jython.</p>
      </ul>

Complete Python programming

London

<p><strong>Course Objectives</strong></p><p>At the end of this course you will be able to:</p><ul><li>Record and edit a Macro</li><li>Assign macros to keyboard shortcuts, Quick Access Toolbar, Buttons and Shape objects.</li><li>Use the Visual Basic Editor; change the properties of an object; add a module to a project; write the code for a procedure and then run it; and use the Object Browser to search procedures</li><li>Manipulate data by declaring variables of different data types; combine data by using expressions; use functions to accept input and display output; and declare variables and procedures with the appropriate scope</li><li>Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks</li><li>Create an error handling routine in case things go wrong with VBA code</li></ul><p>' 1 year email support service</p><p>Take a closer look at the <strong>consistent excellent feedback from our growing corporate clients</strong> visiting our site <em><strong>ms-officetraining co uk</strong></em></p><p><em><strong>Customer Feedback</strong></em></p><ul><li><strong>Best Training Ever!</strong></li><li>Just finished a bespoke 1-1 training course in Excel Advanced, Macros &amp; VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability.</li></ul><ul><li>Amanda Morris - Treasury &amp; Systems Accountant at Reall - Real Equity for All</li></ul><ul><li><p><strong>The trainer was very knowledgeable, kept everyone involved and was enthusiastic. A great experience..</strong></p></li><li>Simon Harper - Lloyd's of London</li></ul><ul><li><p><strong>My learning experience was awesome.</strong></p></li><li>Perdinand Reagan - Subsea7</li></ul><ul><li><p><strong>Very nice and relaxed approach to teaching. Was definitely a good learning experience</strong><strong>.</strong></p></li><li>Jerome Pupe - S5 Agency World</li></ul><ul><li><strong>The Trainer – Very positive + patient + helpful + thorough</strong></li><li>Agnes Souza - Direct Wines</li></ul><p>'</p><p>With more than 20 years experience, we deliver courses on all levels of the Desktop version of <strong>Microsoft Office and Office 365</strong>; ranging from Beginner, Intermediate, Advanced to the VBA level.</p><p>Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering<strong> public, one to one, tailored and bespoke courses.</strong></p><ul><li><strong>Our competitive rates <strong>start from £550.00 per day of training</strong></strong></li></ul><p><strong><strong>Tailored training courses:</strong></strong></p><p>You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs.</p><p><strong>Introduction to Macros and VBA</strong></p><ul><li>Introducing Visual Basic for Applications</li><li>Recording a Macro</li><li>Naming conventions for Macro Procedures</li><li>Running a Macro</li><li>Absolute or Relative Cell Referencing</li><li>Saving and Opening Files with Macros</li><li>Making macros always available</li><li>Adding Macros to Keyboard Shortcuts, Quick Access Toolbar, Buttons and Shapes</li><li>Editing a Macro in the Visual Basic Editor</li><li>Understanding the Development Environment</li><li>Customising the Editor</li><li>Tips for General Typing in VBA</li><li>Using Visual Basic Help</li></ul><p><strong>Working with Procedures</strong></p><ul><li>Program Design</li><li>Understanding Modules</li><li>Naming Rules</li><li>Creating a Module</li><li>Understanding Procedures</li><li>Programming Macro Concepts</li><li>Creating a Subroutine</li><li>Creating a Function</li><li>Understanding Arguments</li><li>Exiting Procedures</li><li>Calling Procedures</li></ul><p><strong>Objects, Properties, Methods and Events</strong></p><ul><li>Understanding Objects Properties, Methods, and Events</li><li>Navigating the Object Hierarchy</li><li>Understanding Collections</li><li>Accessing a Member of a Collection</li><li>Understanding Hierarchy</li><li>Using the Object Browser</li><li>Using the With Statement</li><li>Working with Properties</li><li>Working with Methods</li><li>Creating an Event Procedure</li><li>Reserved Macro Names</li></ul><p><strong>Using Expressions, Variables and Intrinsic Functions</strong></p><ul><li>Understanding Expressions and Statements</li><li>Declaring Variables</li><li>Understanding Data Types</li><li>Determining the Value of Variables</li><li>Working with Variable Scope</li><li>Using Built-in VBA Functions</li><li>Understanding Constants</li><li>Using Message Boxes</li><li>Controlling the Answer to a Message Box</li><li>Using Input Boxes</li><li>Declaring and Using Object Variables</li></ul><p><strong>Controlling Program Execution</strong></p><ul><li>Understanding Control-of-Flow Structures</li><li>Using the If...End If Decision Structures</li><li>Nested If Statements</li><li>Using the Select Case ... End Select Structure</li><li>Using the Do ... Loop Structure</li><li>Using the For ... Next Structure</li><li>Using the For Each ... Next Structure</li><li>Guidelines for Use of Control-of-Flow Structures</li></ul><p><strong>Debugging and Handling Errors</strong></p><ul><li>Understanding Errors</li><li>Using Debugging Tools</li><li>Setting Breakpoints and Using Break Mode</li><li>Stepping Through Code</li><li>Trapping Errors with the On Error Statement</li><li>Understanding the Err Object</li><li>Working with Inline Error Handling</li><li>Writing an Error-Handling Routine</li></ul><p><strong>Working with Forms and Controls</strong></p><ul><li>Understanding UserForms</li><li>Creating a Form</li><li>Displaying and Removing a Form</li><li>Aligning and Sizing Controls</li><li>Using the Toolbox</li><li>Working with a Form's Properties, Methods, and Events</li><li>Working with Form and Control Properties, Methods and Event</li><li>Setting the Tab Order</li><li>Populating a Control</li></ul><h2>
        
            Who is this course for?
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>This course is designed to give proficiency in the Visual Basic Editor (VBE), predominantly making use of Excel objects, understanding Object's Properties, Events and Methods, basic VBA Object oriented programming, event handling, control structures, and debugging tools.</p>
                        </div><h2>
        
            Requirements
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>Preferably, delegates should have attended the Excel Advanced course.</p>
                        </div><h2>
        
            Certificates
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Digital certificate -
            Included
        </p>

                        </div>

Microsoft Office Training

Microsoft Excel Macros & VBA - In-company

<h3><b>Essential OTN training course description</b></h3>
      <p>An In-depth introduction to the terminology and
technology that will comprise tomorrow's Optical
Transport Networks.</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
        <li>Describe the problems with old technologies.</li>
				<li> Identify the purpose of new technologies.</li>
                    <li>Describe the functionality of the various
transmission mediums available</li>
                    <li>Identify OTN features and functionality. </li>
                    <li>Define the issues involved in equipment and
application rollout.</li>
                  </ul>
       
        <h5>
        <b>Essential OTN training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Anyone wishing to learn OTN.</p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>SDH foundation   or Essential DWDM
							</p>
              
							<li><b>Duration</b></li>
							
              <p>2 days
						</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>Essential OTN training course contents</b></h3>
      <ul>
			<p>	Scope, References Terms and definitions, Abbreviations
					and Conventions<br />
Optical transport network interface structure<br />
Multiplexing/mapping principles and bit rates<br />
Optical transport module
(OTM-n.m, OTM-nr.m, OTM-0.m and OTN 0.mvn)<br />
Physical specification of the ONNI<br />
Optical channel (OCh)<br />
Optical channel transport unit (OTU)<br />
Optical channel data unit (ODU)<br />
Optical channel payload unit (OPU)<br />
OTM overhead signal (OOS)<br />
Overhead description and maintenance signals<br />
Mapping of client signals and concatenation<br />
Mapping ODUk signals into the ODTUjk signal<br />
Forward error correction using 16-byte interleaved RS
(255,239) codecs<br />
ODUk tandem connection monitoring (TCM) overhead<br />
		 OPUk Multiplex Overhead</p>
		  
<p>				
</p><li>Amendment 2 including:</li> 
	OTN Multiplexing and Mapping,
Basic signal structure, ODTU12, ODTU13, ODTU23,
OPUk Multiplex Overhead, OPUk Multiplex Structure
Identifier (MSI). OPU2 Multiplex Structure Identifier
(MSI), OPU3 Multiplex Structure Identifier (MSI), OPUk
Payload Structure Identifier Reserved overhead (RES),
ODU1 into ODU2 multiplexing, ODU2 into ODU3
	multiplexing, ODU1 into ODU3 multiplexing<p></p>
		  
		  <p></p><li>Amendment 3 including:</li>
			  40 Gbit/s ODU3/OTU3 and 100
Gbit/s ODU4/OTU4, Support of gigabit Ethernet services
via ODU0, ODU2e, ODU3 and ODU4, ODU0 and
ODUFlex, Multi-lane OTU3 and OTU4 interfaces,
				  Support for InfiniBand<p></p>
		  
<p></p><li>Amendment 4 including: </li> 
	OTSn OTN synchronization
messaging channel (OSMC) overhead, FC-1600<p></p>
		  
		  
<p></p><li>Amendment 5 Including:</li> 
	ODUk.ts, OTU0LL (OTU0 low
latency), OTSiA (optical tributary signal assembly).
OTSiG (optical tributary signal group), OTSiG-O (optical
tributary signal overhead), CMEP (connection monitoring
end- point), CMOH (connection monitoring overhead),
MOTU (Multi-OUT), MOTUm (Multi-OTU with
management), OTUCn-M (Optical Transport Unit-Cn,
with n OxUC overhead instances and 5G tributary slots).
SOTU (Single-OUT). SOTUm (Single-OTU with
management).<p></p>
		  
<p>Modified bit rates and capacity for OTU1/2/3/4
OTM.nr.m, OTM.n.m, OTM.0.3v4, OTM 0.4v4
Mapping of CBR2G5, CBR10G, CBR10G3 and CBR40G
	signals into OPUk<br />
64B/66B and 513B block code format<br />
PCS lane alignment marker for 40GBASE-R and
100GBASE-R<br /> 
PT=20/PT=21 and AMP/GMP options<br />
OTL 4.10 to OTL 4.4 gearbox<br />
ODU switching and Line protection Schemes<br />
10 x 10 MSA<br />
Overview of current and future coherent and noncoherent technologies<br /> 
40Gbit and 100Gbit compliant ROADM's<br /> 
Implementers Guide including replacement terms.<br />
Differing vendor's equipment and their implementations<br /></p>
	
	
		  <p></p><li>Individual and group planning exercises:</li>
Upgrade a customer STM-64/10G network to a 40G/
OTN network.<br />
Upgrade a customer old 16 Wavelength WDM network
to be OTN compliant.<br /> 
Implement a new customer 40 wavelength OTU3 OTN
compliant MSPP (DWDM) network.<br /> Design a cost-effective solution where we can hand over
circuits using 'Optical Transport Lanes'.

<p></p>
      </ul>

Essential OTN

<h3><b>Querying Microsoft SQL Server course description</b></h3>
        <p>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. <br />
Note: This course is
designed for SQL Server 2014or SQL Server 2016. </p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
                       <li>Write SELECT statements.</li>

<li>Create and implement views and table-valued
functions.</li>

<li>Transform data by implementing pivot, unpivot,
rollup and cube.</li>

<li>Create and implement stored procedures.</li>

<li>Add programming constructs such as variables,
conditions, and loops to T-SQL code.</li>

                  </ul>
        <h5>
        <b>Querying Microsoft SQL Server course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Database administrators, database developers, and
business intelligence professionals. <br />SQL power users,
namely, report writers, business analysts and client
application developers.</p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>Database fundamentals</p>
              
							<li><b>Duration</b></li>
							
              <p>5 days</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>Querying Microsoft SQL Server course contents</b></h3>
      <ul>
        <li>Introduction to Microsoft SQL Server </li><p>
Management studio, creating and organizing T-SQL scripts, using books online.
<br /><span>Hands on</span> working with SQL Server tools.

</p><li>T-SQL querying </li><p>
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.
<br /><span>Hands on</span> introduction to T-SQL querying.

</p><li>Writing SELECT queries </li><p>
Writing simple SELECT statements, eliminating duplicates with DISTINCT, column and table aliases, simple CASE expressions.
<br /><span>Hands on</span> writing basic SELECT statements.

</p><li>Querying multiple tables </li><p>
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.
<br /><span>Hands on</span> querying multiple tables.

</p><li>Sorting and filtering data </li><p>
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.
<br /><span>Hands on</span> sorting and filtering data.

</p><li>SQL Server data types </li><p>
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.
<br /><span>Hands on</span> working with SQL Server data types.

</p><li>DML </li><p>
Adding data to tables, modifying and removing data, generating automatic column values, Inserting records with DML, updating and deleting records using DML.
<br /><span>Hands on</span> using DML to modify data.

</p><li>Built-in functions </li><p>
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.
<br /><span>Hands on</span> built-in functions

</p><li>Grouping and aggregating data </li><p>
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.
<br /><span>Hands on</span> grouping and aggregating data.

</p><li>Subqueries </li><p>
Self-contained subqueries, correlated subqueries, EXISTS predicate with subqueries, scalar and multi-result subqueries.
<br /><span>Hands on</span> subqueries.

</p><li>Table expressions </li><p>
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).
<br /><span>Hands on</span> table expressions.

</p><li>Set operators </li><p>
The UNION operator, EXCEPT and INTERSECT, APPLY, queries that use UNION set operators and UNION ALL, CROSS APPLY and OUTER APPLY operators.
<br /><span>Hands on</span> set operators.

</p><li>Windows ranking, offset, and aggregate functions </li><p>
OVER, window functions, ranking functions, offset functions, window aggregate functions. Hands on; windows ranking, offset, and aggregate functions.

</p><li>Pivoting and grouping sets </li><p>
	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.
<br /><span>Hands on</span> pivoting and grouping sets

</p><li>Executing stored procedures </li><p>
Querying data with stored procedures, passing parameters to stored procedures, simple stored procedures, dynamic SQL, the EXECUTE statement to invoke stored procedures.
<br /><span>Hands on</span> executing stored procedures.

</p><li>Programming with T-SQL </li><p>
T-SQL programming elements, controlling program flow, declaring variables and delimiting batches, control-of-flow elements, variables in a dynamic SQL statement, synonyms.
<br /><span>Hands on</span> programming with T-SQL

</p><li>Error handling </li><p>
T-SQL error handling, structured exception handling, redirect errors with TRY/CATCH, THROW to pass an error message back to a client.
<br /><span>Hands on</span> implementing error handling.

</p><li>Implementing transactions </li><p>
Transactions and the database engines, controlling transactions, BEGIN, COMMIT, and ROLLBACK, adding error handling to a CATCH block.
<br /><span>Hands on</span> implementing transactions.
</p>
      </ul>

Querying Microsoft SQL Server

Chesterfield

<div data-css="tve-u-17298e4b572" fr-original-style=" color: rgb(0, 0, 0);" id="isPasted" style="color: rgb(0, 0, 0); box-sizing: border-box;"><div data-css="tve-u-17298e4b56c" fr-original-style="" style="box-sizing: border-box;"><div data-css="tve-u-17298e4b56b" fr-original-style="" style="box-sizing: border-box;"><p data-css="tve-u-17298e4b576" fr-original-style=" color: rgb(34, 177, 77) !important;" style="color: rgb(34, 177, 77) !important; font-size: 16px; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&pound; Enquire</strong></p></div></div></div><div data-css="tve-u-17298e4b520" data-icon-code="icon-check" fr-original-style=" color: rgb(0, 0, 0);" style="color: rgb(0, 0, 0); box-sizing: border-box;"><ul fr-original-style="" style="box-sizing: border-box;"><li data-css="tve-u-16f8a5891e5" fr-original-style=" color: rgb(135, 145, 152);" style="color: rgb(135, 145, 152); box-sizing: border-box;"><div data-css="tve-u-17298e4b524" fr-original-style="" style="box-sizing: border-box;"></div><span data-css="tve-u-17298e4b503" fr-original-style=" color: rgb(0, 0, 0) !important;" style="color: rgb(0, 0, 0) !important; box-sizing: border-box;">Focus Awards Level 4 Certificate in Education and Training (RQF)</span></li><li data-css="tve-u-16f8a5891e5" fr-original-style=" color: rgb(135, 145, 152);" style="color: rgb(135, 145, 152); box-sizing: border-box;"><div data-css="tve-u-17298e4b524" fr-original-style="" style="box-sizing: border-box;"></div><span data-css="tve-u-17298e4b503" fr-original-style=" color: rgb(0, 0, 0) !important;" style="color: rgb(0, 0, 0) !important; box-sizing: border-box;">Brand new course coming soon</span></li><li data-css="tve-u-16f8a5891e5" fr-original-style=" color: rgb(135, 145, 152);" style="color: rgb(135, 145, 152); box-sizing: border-box;"><div data-css="tve-u-1760a758eaa" fr-original-style="" style="box-sizing: border-box;"></div><span data-css="tve-u-17298e4b503" fr-original-style=" color: rgb(0, 0, 0) !important;" style="color: rgb(0, 0, 0) !important; box-sizing: border-box;">Currently run via virtual classrooms</span></li><li data-css="tve-u-16f8a5891e5" fr-original-style=" color: rgb(135, 145, 152);" style="color: rgb(135, 145, 152); box-sizing: border-box;"><div data-css="tve-u-172e194444d" fr-original-style="" style="box-sizing: border-box;"></div><span data-css="tve-u-17298e4b503" fr-original-style=" color: rgb(0, 0, 0) !important;" style="color: rgb(0, 0, 0) !important; box-sizing: border-box;">Ask us for more information!</span></li></ul></div>

Pochat Training

Level 4 Certificate In Education And Training

General admission

<h2>ITIL® 4 Specialist: High Velocity IT: In-House Training</h2>
 <p>The ITIL® 4 Specialist: High-Velocity IT module is part of the Managing Professional stream for ITIL® 4. Candidates need to pass the related certification exam for working towards the Managing Professional (MP) designation.</p>
 <p>This course is based on the ITIL® 4 Specialist: High-Velocity IT exam specifications from AXELOS. With the help of ITIL® 4 concepts and terminology, exercises, and examples included in the course, candidates acquire the relevant knowledge required to pass the certification exam.</p>
 <p>This module addresses the specifics of digital transformation and helps organizations to evolve towards a convergence of business and technology, or to establish a new digital organization. It was designed to enable practitioners to explore the ways in which digital organizations and digital operating models function in high-velocity environments. Working practices such as Agile and Lean, and technical practices and technologies such as Cloud, Automation, and Automatic Testing are included.</p><h3>What You Will Learn</h3>
 <p>At the end of this course, participants will be able to:</p>
 <ul>
 <li>Understand concepts regarding the high-velocity nature of the digital enterprise, including the demand it places on IT.</li>
 <li>Understand the digital product lifecycle in terms of the ITIL operating model.</li>
 <li>Understand the importance of the ITIL guiding principles and other fundamental concepts for delivering high-velocity IT.</li>
 <li>Know how to contribute to achieving value with digital products.</li>
 </ul><section>
                    <h3>Course Introduction </h3> <ul> <li>Let's Get to Know Each Other </li> <li>Course Learning Objectives </li> <li>Target Audience </li> <li>Characteristics </li> <li>ITIL® 4 Certification Scheme </li> <li>Course Components </li> <li>Course Agenda </li> <li>Module-End Exercises </li> <li>Exam Details </li> </ul> <h3>Introduction to High-Velocity IT </h3> <ul> <li>High-Velocity IT </li> <li>Digital Technology </li> <li>Digital Organizations </li> <li>Digital Transformation </li> </ul> <h3>High-Velocity IT Approaches </h3> <ul> <li>Relevance of High-Velocity IT Approaches </li> <li>High-Velocity IT Approaches in Detail </li> </ul> <h3>High-Velocity IT Operating Models Introduction </h3> <ul> <li>ITIL® Perspective </li> <li>High-Velocity IT Aspects </li> <li>High-Velocity IT Applications </li> </ul> <h3>ITIL® Building Blocks for High-Velocity IT </h3> <ul> <li>Digital Product Lifecycle </li> <li>Service Value Streams </li> <li>Four Dimensions of Service Management </li> <li>ITIL® Management Practices </li> </ul> <h3>High-Velocity IT Culture </h3> <ul> <li>Key Behavior Patterns </li> <li>ITIL® Guiding Principles </li> </ul> <h3>Supporting Models and Concepts for Purpose </h3> <ul> <li>Ethics </li> <li>Design Thinking </li> </ul> <h3>Supporting Models and Concepts for People </h3> <ul> <li>Reconstructing for Service Agility </li> <li>Safety Culture </li> <li>Stress Prevention  </li> </ul> <h3>Supporting Models and Concepts for Progress </h3> <ul> <li>Working in Complex Environments Lean Culture </li> <li>ITIL® Continual Improvement Model  </li> </ul> <h3>High-Velocity IT Objectives and Techniques </h3> <ul> <li>High-Velocity IT Objectives </li> <li>High-Velocity IT Techniques </li> </ul> <h3>Techniques for Valuable Investments </h3> <ul> <li>Prioritization Techniques </li> <li>Minimum Viable Products and Services </li> <li>Product / Service Ownership </li> <li>A/B Testing </li> </ul> <h3>Techniques for Fast Developments </h3> <ul> <li>Basic Concepts Related to Fast Development </li> <li>Infrastructure as Code Reviews </li> <li>Continual Business Analysis </li> <li>Continuous Integration / Continuous Delivery (CI/CD) </li> <li>Continuous Testing </li> <li>Kanban </li> </ul> <h3>Techniques for Resilient Operations </h3> <ul> <li>Introduction to Resilient Operations </li> <li>Technical Debt </li> <li>Chaos Engineering </li> <li>Definition of Done </li> <li>Version Control </li> <li>Algorithmic IT Operations </li> <li>ChatOps </li> <li>Site Reliability Engineering (SRE) </li> </ul> <h3>Techniques for Co-created Value </h3> <ul> <li>Basic Concepts of Co-created Value </li> <li>Service Experience </li> </ul> <h3>Techniques for Assured Conformance </h3> <ul> <li>DevOps Audit Defense Toolkit </li> <li>DevSecOpsPeer Review</li> </ul>


                </section>

IIL Europe Ltd

ITIL 4 Specialist: High Velocity IT: In-House Training

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Come learn to code with me</p>

Elite coding courses

Elite coding course

<p style="color: rgb(26, 26, 26); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(26, 26, 26);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">This driver CPC course Rules of The Road &amp; Fuel-Efficient Driving is suitable for LGV &amp; PCV and will cover:</strong></p><p style="color: rgb(26, 26, 26); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(26, 26, 26);">Requirements, Speed Limits, SMART Motorways, Highway Code, Road Signs, Bridge Strikes, Mobile Phones, Sat-Navs, Traffic Accident Procedure, Benefits of Fuel-Efficient Driving, Fuels and Fluids, Use of Vehicles,&nbsp;Other Factors,&nbsp;Driving Safely and Fuel Efficiently.</p><p style="color: rgb(26, 26, 26); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(26, 26, 26);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">All courses start at 07:45 hrs and finish at 15:45 hrs</strong></p><p style="color: rgb(26, 26, 26); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(26, 26, 26);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">All courses are 8 hours long with included 2 breaks of 15 minutes and a lunch break of 30 minutes.</strong></p><p style="color: rgb(26, 26, 26); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(26, 26, 26);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Approval:</strong> This course is registered with JAUPT as approved for Driver CPC qualification.</p><p style="color: rgb(26, 26, 26); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(26, 26, 26);">Course Approval Number: CRS18242/475.</p><p style="color: rgb(26, 26, 26); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(26, 26, 26);">On completion of the course all attendees will receive certificate of attendance.</p><p style="color: rgb(26, 26, 26); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(26, 26, 26);">Please note repeat courses are not accepted by DVSA and by joining this course you confirm that you are aware of the modules covered by you and certify that, if you have covered these before you are happy to repeat the modules due to needing further education on the subject.</p>

This driver CPC course Vulnerable Road Users is suitable for LGV & PCV and will cover:
Where Do We Encounter VRU’s? Who Are the VRU’s? Sharing Road Space, Route Planning, New Traffic Systems, Professional Drivers Role, Hazard Perception, Defensive Driving, Blindspots, Vehicle Safety Systems, Cyclists, Pedestrians, Motorcyclists, Horse Riders
All courses start at 07:45 hrs and finish at 15:45 hrs
All courses are 8 hours long with included 2 breaks of 15 minutes and a lunch break of 30 minutes.
Approval: This course is registered with JAUPT as approved for Driver CPC qualification.
Course Approval Number: CRS5814/475.
On completion of the course all attendees will receive certificate of attendance.
Please note repeat courses are not accepted by DVSA and by joining this course you confirm that you are aware of the modules covered by you and certify that, if you have covered these before you are happy to repeat the modules due to needing further education on the subject.

PETM

Road Safety

Driver CPC

Vulnerable Road Users - Online

<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p>The intended audience for this course would be those who have been using Office 365 for some time and are now looking at optimizing their existing business processes and designing new ones.</p>Overview<p>#NAME?</p><p>This course delivers an instructor-led product showcase for Microsoft Power Automate from start to finish in an engaging and practical way. Power Automate is a diverse product, turning business processes into automated, consistent and visual workPower Automates. Power Automate is designed to interweave the various products in Office 365 as well as connect to other on-premises and web-based solutions. This course will give you the confidence to select the right actions and workPower Automate logic for your business workPower Automates.</p></div><div id="course-pills-2"><h3>1 - An Introduction to Power Automate</h3> <ul> <li>What is Microsoft Power Automate?</li> <li>The benefits of automation</li> <li>How to get to Power Automate</li> <li>Lab 1: Setup your tenant</li> <li>Setup Office 365</li> <li>Download Course Files</li> <li>Customise your App Launcher</li> <li>Create accounts for colleagues</li> <li>After completing this module, students will be able to:</li> <li>Know what Microsoft Power Automate is</li> <li>The Benefits of using Power Automate to automate processes</li> <li>How to access a Power Automate</li> </ul> <h3>2 - Getting Started with Power Automate</h3> <ul> <li>Using Power Automate templates</li> <li>Navigating in Power Automate</li> <li>Editing a Power Automate</li> <li>Publish and trigger a Power Automate</li> <li>Turn off or delete a Power Automate</li> <li>Lab 1: Building processes in Office 365</li> <li>Create a Team with a channel</li> <li>Build an absence business process</li> <li>Testing the absence process</li> <li>Optional: Create Feedback Form</li> <li>Optional: Power Automate to Notify of Bad Ratings</li> <li>Optional: Test your Form and Power Automate</li> <li>After completing this module, students will be able to:</li> <li>How to use Power Automate tempaltes</li> <li>How to navigate around Power Automate</li> <li>How to edit Power Automates</li> <li>How to publish and trigger Power Automates</li> <li>How to turn off or delete Power Automates</li> </ul> <h3>3 - Power Automate Logic</h3> <ul> <li>Adding conditions</li> <li>Designing switches</li> <li>Using apply to each</li> <li>Configuring do until logic</li> <li>Adding a scope</li> <li>Lab 1: Scheduling documentation reviews</li> <li>Setup a policy library in SharePoint</li> <li>Design a policy review schedule</li> <li>Testing the policy review process</li> <li>Optional: Notify if a file nears review</li> <li>After completing this module, students will be able to:</li> <li>How to add condtions in a Power Automate</li> <li>How to design switches for a Power Automate</li> <li>How to use apply to each</li> <li>How to configure do until logic</li> <li>How to add a scope</li> </ul> <h3>4 - Integration</h3> <ul> <li>Standard and premium connectors</li> <li>Connecting to web services</li> <li>Using Power Automate with on-premises data</li> <li>Lab 1: Using Power Automate and SQL to Review Sales</li> <li>Create a new orders list</li> <li>Designing the price check process</li> <li>Testing the price check process</li> <li>Optional: Update with managers</li> <li>After completing this module, students will be able to:</li> <li>How to use Standard and Premium connectors</li> <li>How to connect to web services</li> <li>How to using Power Automate with on-premises data</li> </ul> <h3>5 - The Mobile App</h3> <ul> <li>Downloading the mobile app</li> <li>Signing in and account management</li> <li>Building and managing Power Automates</li> <li>Creating buttons</li> <li>Feeds and approvals</li> <li>Lab 1: Optional: Using the Power Automate mobile app</li> <li>Setting up the Power Automate mobile app</li> <li>Create a new Power Automate in the mobile app</li> <li>Using Power Automate buttons in the app</li> <li>Uninstall the Power Automate mobile app</li> <li>After completing this module, students will be able to:</li> <li>How to download the mobile app</li> <li>How to sign into the mobile app</li> <li>How to build and manage Power Automates in the mobile app</li> <li>How to create buttons in the mobile app</li> <li>How to feed and use approvals in the mobile app</li> </ul> <h3>6 - Administration and Maintenance</h3> <ul> <li>Maintaining a Power Automate</li> <li>View history and analytics</li> <li>Sharing a Power Automate</li> <li>Export and import Power Automates</li> <li>Office 365 administration for Power Automate</li> <li>Environments</li> <li>Data policies</li> <li>Data integration</li> <li>Lab 1: Maintaining your Power Automates</li> <li>Share a Power Automate with a colleague</li> <li>Disabling an active Power Automate</li> <li>Deleting a Power Automate</li> <li>After completing this module, students will be able to:</li> <li>How to maintain a Power Automate</li> <li>How to view history and analytics for a Power Automate</li> <li>How to share a Power Automate</li> <li>How to export and import Power Automates</li> <li>How to administrate a Power Automate in Office 365</li> <li>How to use data policies in a Power Automate</li> <li>How to use data integration in a Power Automate</li> </ul></div>

Nexus Human

Microsoft Power Apps

Power Apps

Microsoft 365

Microsoft Power Platform

Power Automate

Microsoft Power Automate

55268 Microsoft Power Automate for End Users

<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p>To ensure success, students should have completed Excel Essentials and Excel Functions Including Pivot Tables and Lookups or have the equivalent knowledge and experience.</p>Overview<p>Upon successful completion of this course, students will be able to enhance productivity and efficiency by streamlining workflow, collaborate with others, and audit and analyse data.</p><p>This course is designed for students desiring to gain skills necessary to create macros, collaborate with others, audit and analyse data, incorporate multiple data sources, and import data.</p></div><div id="course-pills-2"><h4>Working with Multiple Worksheets and Workbooks </h4><ul><li>Working with Named Ranges</li><li>Link Cells Across Worksheets and Workbooks </li><li>Use 3D References to Calculate Across Worksheets</li><li>Consolidate Data</li></ul><h4>Use Formula Auditing and Error Checking</h4><ul><li>Reveal Formulas</li><li>Trace Cell Precedents and Dependents </li><li>Locate Errors in Formulas </li><li>Watch and Evaluate Formulas </li></ul><h4>Reviewing and Protecting Workbooks </h4><ul><li>Control Data Entry via Data Validation</li><li>Protect Workbook Access</li><li>Protect Worksheets and Cell Content </li><li>Add and Edit Comments</li><li>Prepare a Workbook for Distribution </li><li>Modify Excel's Default Settings</li></ul><h4>Using Macros to Automate Workbook Functionality</h4><ul><li>Create Macros via Recording </li><li>Run Macros via Buttons and Shortcuts</li><li>Assign Macros to the Quick Access Toolbar and Ribbon </li><li>Assign Macros to Objects </li><li>View Macro Code</li></ul><h4>Forecasting and Analysis Data</h4><ul><li>Use Conditional Formatting to Highlight, Sort and Filter Key Data</li><li>Advanced Conditional Formatting using Formulas</li><li>Create Sparklines to Visualise Data</li><li>Add Trendlines to Charts to Visualise and Forecast Trends</li><li>Use Data Tables and Scenarios to Project Potential Outcomes </li><li>Use Goal Seek to Calculate Outcomes</li><li>Forecast Data Trends Using Solver</li></ul></div>

Office Skills & Productivity

Excel Analytics

Access VBA

Visual Basic Analysis

Microsoft Excel

Excel - Automating Excel with Macros and Analysis Tools

<article>
<div>
<h5>Java EVENINGS Course</h5>
</div>
<div></div>
<p>  						 
	</p><div>
	<ul>
		<p>
		<b>Python EVENINGS Course. </b>Basic Python syntax and principles of Object Orientated Programming. 
		<br />Most attendees are in-work IT Professional.
		<br />Private individuals are also very welcome. 
		<br />Evening courses also running.
		<br /><b>Our Style: </b>Hands-on, Practical  
		<br /><b>Location:  </b>Online, Instructor-led  
		<br /><b>Download:  </b>anaconda.com
		<br /><b>Duration:  </b>6 weeks, 1 evening per week, 6pm - 8pm
		<br /><b>Times: </b>arrange a time for your time zone
	    </p>
	</ul>	

<p></p>
</div></article>

<div>
	  <div>
		 <h5>Python Basics EVENINGS Course </h5>
	  </div>
	  <div></div>
	  <p> 
 
				This Python course London Evening covers the essential Python Basics, in our interactive, instructor led Live Virtual Classroom.
				This Python Basics course is a very good introduction to essential fundamental programming concepts using Python as programming language.
				These concepts are daily used by programmers and is your first step to working as a programmer.
				By the end, you'll be comfortable in programming Python code.
				You will have done small projects.
				This will serve for you as examples and samples that you can use to build larger projects.
				You can publish your code online to keep as a portfolio.

<br />
This Python Programming course is hands-on and practical, to give you in-depth, practical experience of the topics covered.

	  </p>
	<div>
	<h5>Week 1: Basics</h5>
	</div>
	<div></div>
	<div> 
					<p>  <strong>Python Data Types and Variables:</strong>  
					<br />  Primitive types; Characters &amp; Strings; Boolean; Working with variables and its scope; Conversion and casting types in Python.	 
					<br /> <strong>Operators and Expressions: </strong>   
					<br />  Introduction of operators; Arithmetic operators; Relational operators; Assignment operator; Logical operators; Increment and decrement operators.
					</p> 
			 
				<p><strong> Decision Making:</strong>
				<br />If statement; If - else statement; If- elif - else statement; Nested if - else.
				</p><p><strong>Using Loops:</strong>
				<br />The while, while-else.
				<br />For loop;
				<br />Jump statements: break, continue;
				<br />Nesting loops.				
				</p>
			</div>
	<div>
	<h5>Week 2: Data Structures</h5>
	</div> <div></div>
	<div> 
				<p> Lists.
					<br />Tuples.
					<br />Sets.
					<br />Dictionary. Nested Dictionary.
					<br />Json Files.
				</p>
			</div>
	<div>
	<h5>Week 3: Python built-in functions</h5>
	</div> <div></div>
	<div> 
				<p>  
				<br />Using Built-in modules and functions:
				<br />Strings Functions.
				<br />Pattern matching with Regex.
				<br />Maths Functions.
				<br />Random Functions.
				<br />Python Date functions.
				</p>
			</div>
	<div>
	<h5>Week 4: OOP: Using Modules, functions, classes</h5>
	</div> <div></div>
	<div>
				<p>  Creating and using custom Functions.
					<br />Creating functions;
					<br />Using parameters and return values;
					<br />
					<br />Introduction to Classes and Objects:
					<br />Creating a Class; 
					<br />Creating an Object; Using an Object; 
					<br />Adding Instance variables; Controlling accessibility; Naming conventions for class members. 
					<br /> Class Constructors; Parameterized Constructors.
					<br />Inheritance. Overload.
				</p>
			</div>

	<div>
	<h5>Week 5: Pandas DataBase Basics</h5>
	</div> <div></div>
	<div>	 
		<p> <b>Connection details:</b>
				Connect to a database using access codes. 
				<br /><b>Select Queries:</b>
				Retrieving records and iterating results sets, using variables and parameters in queries. 
				<br />Working with DDL comands:
				Create a database, drop a database.
				Create a table, alter tables, drop a table. 
				<br />Working with DML Commands:
				Insert, delete, update records.
		</p>
	</div>
	
	 
	<div>
	<h5>Week 6: Pandas Dataframe Basics</h5>
	</div> <div></div>
	<div>	 
		<p> Getting data into a dataframe:
			<br />Dict to Dataframe, Dataframe to Dict.
			<br />Excel To Dict, Dict to Excel , working with Excel data, multiple Excel sheets.

			<br />Dataframe basics:
			<br />Slicing Dataframes,
			<br />Getting information about the dataframe,
			<br />Filter, sort and query a Dataframes,
			<br />Duplicate values,
			<br />Working with null-values,
			<br />Sampling,
			<br />Group by,
			<br />Join.

		</p>
	</div>
	  
</div>
 

<div>   

	   <div id="cincluded">
		  <div>
			 <h5>What is included</h5>
		  </div>

		  <article>
		  <div>
			 <ul>
				<li>PCWorkshops Course Certificate on completion  </li>
									   
				<li>Python Course Notes</li>
				<li>Python Code Examples</li>
				<li>Practical Python Course exercises and Code Samples</li>
				<li>After the course: 1-Hour personalised online revision session</li>
			 </ul>
		  </div>
		  </article>
	   </div>
				    
<div>
	                  <div>
	                     <h5 id="cincluded2">Book the Python  Course</h5>
	                  </div>
 
<div id="eventbrite-widget-container-60636103217"></div>




							 
</div>
				   <div id="caboutus">
	                  <div>
	                     <h5>About us</h5>
	                  </div> 
	                  	<article>
					    <div>
					    	<div>
					    		<div>
					    			
					    			<h5>Our experienced trainers are award winners. </h5> 
					    			<ul>
										<li>
											More about us
										</li>
										<li>
											FAQ's
										</li>
										<li>
											Client Comments  
										</li>
									 </ul>
					    		</div>
					    		<div>
					    			
					    				
					    			
					    		</div>
					    	</div>
	                     
					    </div>
					    </article>						
	               </div>
				   
				   
	        </div>

Python EVENINGS Course
Basic Python syntax and principles of object-oriented programming. 
Most attendees are in-work IT Professional. 
Private individuals are also very welcome. 
Evening courses also running. 

Details:
Our Style: Hands-on, Practical 
Location: Online, Instructor-led 
Download: anaconda.com 
Duration: 4 weeks, 1 evening per week, 6pm - 8pm 
Times: arrange a time for your time zone 
How to attend:  
Connection Link For the course: https://meet.goto.com/910697125
Once you have made the payment, use the above link on the date booked, to connect with the trainer. 
Python Basics EVENINGS Course
 This Python course London Evening covers the essential Python Basics, in our interactive, instructor led Live Virtual Classroom. This Python Basics course is a very good introduction to essential fundamental programming concepts using Python as programming language. These concepts are daily used by programmers and is your first step to working as a programmer. By the end, you'll be comfortable in programming Python code. You will have done small projects. This will serve for you as examples and samples that you can use to build larger projects. You can publish your code online to keep as a portfolio. 

This Python Programming course is hands-on and practical, to give you in-depth, practical experience of the topics covered. 
Week 1: Basics
 Python Data Types and Variables: 
Primitive Data types; Working with variables and its scope; Conversion and casting types in Python. 
 Operators and Expressions:  
 Introduction of operators; Arithmetic operators; Relational operators; Assignment operator; Logical operators; Increment and decrement operators. 
 Decision Making: 
If statement; If - else statement; If- elif - else statement; Nested if - else. 
Using Loops: 
The while, while-else. 
For loop; 
Jump statements: break, continue; 
Nesting loops. 
Week 2: Data Structures & Database
Lists.  
Tuples. 
Sets. 
Dictionary. Nested Dictionary. 
Json Files. 
Reading csv and text files
Connecting with a database and run SQL Queries. 
Week 3: Python built-in functions &  Pandas Dataframe Basics
 
Using built-in modules and functions: 
Strings Functions. 
Maths Functions. 
Random Functions. 
Data Frames; 
Getting data into a dataframe: 
Dict to Dataframe, Dataframe to Dict.  
Dataframe basics: 
Slicing Dataframes, 
Getting information about the dataframe, 
Filter and query a Dataframes, 
Working with null-values.
Week 4: OOP: Using Modules, functions, classes
 Creating and using custom Functions. 
Creating functions; 
Using parameters and return values; 
 
Introduction to Classes and Objects: 
Creating a Class; 
Creating an Object; Using an Object; 
Adding instance variables; controlling accessibility; and naming conventions for class members. 
 Class Constructors; Parameterized Constructors. 
Inheritance. Overload. 

What is included
PCWorkshops Course Certificate on completion
Python Course Notes
Python Code Examples
Practical Python Course exercises and Code Samples
After the course: 1-Hour personalised online revision session
  

PCWorkshops

Online Course Creation

Programming Fundamentals

Computer Programming

Professional Skills Course (PSC)

Instructor

Python

Basic Python syntax and principles of Object Orientated Programming. 
Most attendees are in-work IT Professional. 
Private individuals are also very welcome. 
Evening courses also running. 
Our Style: Hands-on, Practical 
Location: Online, Instructor-led 
Download: anaconda.com 
Duration: 6 weeks, 1 evening per week, 6pm - 8pm 
Times: arrange a time for your time zone 

Python EVENINGS Course, Online Instructor-led

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><b style="color: rgb(26, 26, 26); box-sizing: border-box;" fr-original-style="color: rgb(26, 26, 26);">This driver CPC course - Customer Service &amp; Manual Handling</b><b style="color: rgb(26, 26, 26); box-sizing: border-box;" fr-original-style="color: rgb(26, 26, 26);"> is suitable for LGV &amp; PCV and will cover:</b></p><p style="color: rgb(26, 26, 26); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(26, 26, 26);">Company &amp; Driver Image,&nbsp;Who Customers Are and What They Want,&nbsp;Communication Skills,&nbsp;Giving Good Customer Service,&nbsp;About Manual Handling,&nbsp;The Spine,&nbsp;Manual Handling Injuries and Their Costs,&nbsp;Regulations,&nbsp;Manual Handling Risk Assessment,&nbsp;Safe Handling Techniques,&nbsp;Manual Handling Equipment.</p><p style="color: rgb(26, 26, 26); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(26, 26, 26);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">All courses start at 07:45 hrs and finish at 15:45 hrs</strong></p><p style="color: rgb(26, 26, 26); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(26, 26, 26);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">All courses are 8 hours long with included 2 breaks of 15 minutes and a lunch break of 30 minutes.</strong></p><p style="color: rgb(26, 26, 26); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(26, 26, 26);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Approval:</strong> This course is registered with JAUPT as approved for Driver CPC qualification.</p><p style="color: rgb(26, 26, 26); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(26, 26, 26);">Course Approval Number: CRS18242/475.</p><p style="color: rgb(26, 26, 26); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(26, 26, 26);">On completion of the course all attendees will receive certificate of attendance.</p><p style="color: rgb(26, 26, 26); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(26, 26, 26);">Please note repeat courses are not accepted by DVSA and by joining this course you confirm that you are aware of the modules covered by you and certify that, if you have covered these before you are happy to repeat the modules due to needing further education on the subject.</p>

This driver CPC course - Rules of the Road & Manual Handling is suitable for LGV & PCV and will cover:
Requirements, Speed Limits, SMART Motorways, Highway Code, Road Signs, Bridge Strikes, Mobile Phones, Sat-Navs, Traffic Accident Procedure, About Manual Handling, The Spine, Manual Handling Injuries and Their Costs, Regulations, Manual Handling Risk Assessment, Safe Handling Techniques, Manual Handling Equipment.
All courses start at 07:45 hrs and finish at 15:45 hrs
All courses are 8 hours long with included 2 breaks of 15 minutes and a lunch break of 30 minutes.
Approval: This course is registered with JAUPT as approved for Driver CPC qualification.
Course Approval Number: CRS18242/475.
On completion of the course all attendees will receive certificate of attendance.
Please note repeat courses are not accepted by DVSA and by joining this course you confirm that you are aware of the modules covered by you and certify that, if you have covered these before you are happy to repeat the modules due to needing further education on the subject.

HGV Driver

7.5 Ton Driver

Manual Handling

Rules of the Road & Manual Handling - Online

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>Candidates for this course design, develop, secure, and troubleshoot Power Platform solutions. Candidates implement components of a solution that include application enhancements, custom user experience, system integrations, data conversions, custom process automation, and custom visualizations. Candidates will gain applied knowledge of Power Platform services, including in-depth understanding of capabilities, boundaries, and constraints.</p>Overview<p>After completing this course, students will be able to:<br />Create a technical design<br />Configure Common Data Service<br />Create and configure Power Apps<br />Configure business process automation<br />Extend the user experience<br />Extend the platform<br />Develop Integrations</p><p>The Microsoft Power Platform helps organizations optimize their operations by simplifying, automating and transforming business tasks and processes. In this course, students will learn how to build Power Apps, Automate Flows and extend the platform to complete business requirements and solve complex business problems.</p></div><div id="course-pills-2"><h4>Create a model-driven application in Power Apps</h4><ul><li>This module introduces you to creating a model-driven app in Power Apps that uses Common Data Service.</li></ul><h4>Get started using Common Data Service</h4><ul><li>This module will explain the concepts behind and benefits of Common Data Service. Creating an environment, entities, fields and options sets are also discussed.</li></ul><h4>Create a canvas app in Power Apps</h4><ul><li>This module introduces you to Power Apps, helps you create and customize an app, and then manage and distribute it. It will also show you how to provide the best app navigation, and build the best UI using themes, icons, images, personalization, different form factors, and controls.</li></ul><h4>Automate a business process using Power Automate</h4><ul><li>This module introduces you to Power Automate, teaches you how to build workflows, and how to administer flows.</li></ul><h4>Create a business process flow in Power Automate</h4><ul><li>This module introduces you to creating business process flows in Power Automate</li></ul><h4>Introduction to developing with Power Platform</h4><ul><li>This module is the first step in learning about platform, tools, and the ecosystem of the Power Platform</li></ul><h4>Extending the Power Platform user experience Model Driven apps</h4><ul><li>This module describes how to create client scripting, perform common actions with client script, and automate business process flow with client scrip. Learn about what client script can do, rules, and maintaining scripts. Discover when to use client script as well as when not to use client script.</li></ul><h4>Create components with Power Apps Component Framework</h4><ul><li>This module describes how to get started with Power Apps Component Framework with an introductory module on the core concepts and components. Then it shows you how to build a component and work with advanced Power Apps Component Framework features.</li></ul><h4>Extending the Power Platform Common Data Service</h4><ul><li>This module looks at the tools and resources needed for extending the Power Platform. We'll start with looking at the SDKs, the extensibility model, and event framework. This learning path also covers when to use plug-ins. Configuration of plug-ins as well as registering and deploying plug-ins.</li></ul><h4>Integrate with Power Platform and Common Data Service</h4><ul><li>This module describes how to integrate with Common Data Service using code by learning about Common Data Service API. Get an in-depth overview of options available with Common Data Service to integrate data and events to Azure.</li></ul><h4>Extend Power Apps portals</h4><ul><li>This module describes how to transform a content portal into a full web app interacting with Common Data Service. We will also cover the options available to customizers and developers to extend the portal functionality and integrate with Office 365, Power Platform, and Azure components.</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans PL-400T00 Microsoft Power Platform Developer training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>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.  <p></p>While we feel this is the best course for the PL-400T00 Microsoft Power Platform Developer 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.  <p></p>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.<p></p></div>

Microsoft PL-900

Microsoft AZ-303

PL-400T00 Microsoft Power Platform Developer

<article>
<div>
<h5>Learn SQL Course, 1-Day</h5>
</div>
<div></div>
<p>  						 
	</p><div>
	<ul>
		<p>
		<b>SQL Queries Course, 1-Day. </b>Basic SQL syntax. 
		<br />Most attendees are in-work IT Professional.
		<br />Private individuals are also very welcome. 
		<br />Evening courses also running.
		<br /><b>Our Style: </b>Hands-on, Practical  
		<br /><b>Location:  </b>Online, Instructor-led  
		<br /><b>Download:  </b>anaconda.com
		<br /><b>Duration:  </b>6 weeks, 1 evening per week, 6pm - 8pm
		<br /><b>Times: </b>arrange a time for your time zone
	    </p>
	</ul>	

<p></p>
</div></article>

<div>
	  <div>
		 <h5>Learn SQL Course, 1-Day</h5>
	  </div>
	  <div></div>
	  <p> With SQL Queries, you could learn SQL in a day, and master the basics of SQL, get interesting, insightful and essential business intelligence from data by using SQL queries on this SQL Course London, UK. 
	  <br />Queries are made easy and simple, saving hours of online training.
 
		<br />This 1 Day course is packed with power query techniques.

<br /><br />This SQL Introduction Course is hands-on, practical with many excellent query examples.
<br /><br />This course is Platform Independent.
<br /><br />This SQL course is hands-on and practical, to give you in-depth, practical experience of the topics covered.
<br /><br />Ask your SQL questions in small, friendly classroom SQL Course. 
<br /><br />Online, Instructor-led, Interactive, full screen sharing.

	  </p>
	<div>
	<h5> Learn SQL Relational Database Concepts:</h5>
	</div>
	<div></div>
	<div> 
					<p>  <strong>Database:</strong>  
					<br />What is a Relational Database?
<br />Tables, Rows and Columns
<br />Indexes, Primary Keys and Foreign Keys
<br />Data Types  
					</p> 
			 
				 
			</div>
	<div>
	<h5>Learn SQL Essentials:</h5>
	</div> <div></div>
	<div> 
				<p> <strong>Basics.</strong>
					<br />SQL Language Essentials:
<br />The SQL Select Statement, the Where Clause, SQL Order By Clause, Working with Null Values
<br />SQL Arithmetic Operations, Expression Queries
<br />SQL Column Aliases
<br />Limit/Top, Distinct

				 
				</p>
			</div>
	<div>
	<h5>Summarizing and Grouping Data:</h5>
	</div> <div></div>
	<div> 
				<p>  <strong>Group by</strong>
				<br />
Aggregate Functions (Sum, Avg, Count, Max, Min)
<br />The Group By Clause
<br />The Having Clause
				 
				</p>
			</div>
	<div>
	<h5>Querying Multiple Tables:</h5>
	</div> <div></div>
	<div>
				<p>   <strong>Joins</strong>
					<br />
Joining Tables
<br />Inner Joins, Outer Joins, Self Joins, Full Joins, 
<br />Cross Joins
<br />Alternative Join Syntax
				</p>
			</div>

	 
	
	 
	<div>
	<h5>Basic Subqueries</h5>
	</div> 
	<div></div>
	<div>	 
		<p> <strong>Sub-queries</strong>
			<br />Basics of CTE tables
			<br />SQL subqueries 
			<br />Using subqueries in the from clause
			<br />Using subqueries in the where clause
			<br />Using subqueries in the select clause
			<br />Using subqueries in the having clause 
			
		</p>
	</div>
	<div>
	<h5>Combine Queries</h5>
	</div> 
	<div></div>
	<div>	 
		<p> <strong>Combine Queries</strong>
			<br />The Union Operator
			<br /> Intersect and Minus Operators
			<br /> Simulating combine Intersect and Minus queries by using sub-queries
					   

			 

		</p>
	</div>
	  
</div>
 

<div>   

	   <div id="cincluded">
		  <div>
			 <h5>What is included</h5>
		  </div>

		  <article>
		  <div>
			 <ul>
				<li>PCWorkshops Course Certificate on completion  </li>
									   
				<li>SQL Course Notes</li>
				<li>SQL Code Examples</li>
				<li>Practical SQL Course exercises and Code Samples</li>
				<li>After the course: 1-Hour personalised online revision session</li>
			 </ul>
		  </div>
		  </article>
	   </div>
				    
<div>
	                  <div>
	                     <h5 id="cincluded2">Book the SQL Course</h5>
	                  </div>
 
	 
 <div id="eventbrite-widget-container-100389112538"></div>




									
					
					 
</div>
				   <div id="caboutus">
	                  <div>
	                     <h5>About us</h5>
	                  </div> 
	                  	<article>
					    <div>
					    	<div>
					    		<div>
					    			
					    			<h5>Our experienced trainers are award winners. </h5> 
					    			<ul>
										<li>
											More about us
										</li>
										<li>
											FAQ's
										</li>
										<li>
											Client Comments  
										</li>
										<li>
										<div id="LTF_ST_m8v4lCcicRynaFxnT4tD2JOVCitkIkMwzh0sIQRc9Toth01PZo"></div>
										</li>	
									 </ul>
					    		</div>
					    		<div>
					    			
					    				
					    			
					    		</div>
					    	</div>
	                     
					    </div>
					    </article>						
	               </div>
				   
				   
	        </div>

Learn SQL Course, 1-Day
This SQL course is platform independent.
SQL Queries Course, 1-Day. Basic SQL syntax.  This course is good for any database, covering standard SQL. Most attendees are in-work IT Professional. 
Private individuals are also very welcome. 
Evening courses also running. 

Details
Our Style: Hands-on, Practical 
Location: Online, Instructor-led 
Download: anaconda.com 
Duration: 6 weeks, 1 evening per week, 6pm - 8pm 
Times: arrange a time for your time zone 
Join us on your booked dates on https://meet.goto.com/910697125
Learn SQL Course, 1-Day Online Instructor-led
With SQL Queries, you could learn SQL in a day, and master the basics of SQL, and get interesting, insightful, and essential business intelligence from data by using SQL queries on this SQL Course in London, UK. 
Queries are made easy and simple, saving hours of online training. 
This 1 Day course is packed with power query techniques. 

This SQL Introduction Course is hands-on, practical with many excellent query examples.
This SQL course is hands-on and practical to give you in-depth, practical experience of the topics covered.
Ask your SQL questions in a small, friendly classroom SQL course. 

Learn SQL. Relational Database Concepts:
 Database: 
What is a Relational Database?

Tables, Rows and Columns

Indexes, Primary Keys and Foreign Keys

Data Types 
Learn SQL Essentials:
 Basics. 
SQL Language Essentials:

The SQL Select Statement, the Where Clause, SQL Order By Clause, Working with Null Values

SQL Arithmetic Operations, Expression Queries

SQL Column Aliases

Limit/Top, Distinct 
Summarizing and Grouping Data:
 Group by 

Aggregate Functions (Sum, Avg, Count, Max, Min)

The Group By Clause

The Having Clause 
Querying Multiple Tables:
 Joins 

Joining Tables

Inner Joins, Outer Joins, Self Joins, Full Joins, 
Cross Joins

Alternative Join Syntax 
Basic Subqueries
 Sub-queries 
Basics of CTE tables 
SQL subqueries 
Using subqueries in the from clause 
Using subqueries in the where clause 
Using subqueries in the select clause 
Using subqueries in the having clause 
 
 Combine Queries 
The Union Operator 
 Intersect and Minus Operators 
 Simulating combined Intersect and Minus queries by using sub-queries 

What is included
PCWorkshops Course Certificate on completion
SQL Course Notes
SQL Code Examples
Practical SQL Course exercises and Code Samples
After the course: 1-Hour personalised online revision session
  



Database Programming

IT Skills

Data Skills

SQL Queries Course, 1-Day. Basic SQL syntax.  This course is good for any database, covering standard SQL. Most attendees are in-work IT Professional. 
Private individuals are also very welcome. 

Learn SQL Basics, 1-day Course, Online Instructor-Led

<div id="course-pills-1">Duration<p>4 Days</p><p>24 CPD hours</p>This course is intended for<p>This course is intended for both novice and experienced SharePoint users who wish to make full use of SharePoint Online.</p>Overview<p>#NAME?</p><p>This course delivers the complete site owner story from start to finish in an engaging and practical way to ensure you have the confidence to plan and create new sites or manage your existing sites in SharePoint Online. Your goal is to learn how to make SharePoint online relevant to your team by using a sites functionality to help you share information and collaborate with your colleagues. During the class, you will also learn best practices and ?what not to do? as you watch live, interactive demonstrations and put theory into practice with hands on exercises in SharePoint Online.</p></div><div id="course-pills-2"><h3>1 - An Introduction to SharePoint Online</h3> <ul> <li>Introducing Office 365 and SharePoint</li> <li>Getting started with Office 365</li> <li>The cloud revolution</li> <li>Login to Office 365</li> <li>What is Office 365</li> <li>Using the app launcher</li> <li>What is SharePoint</li> <li>Office 365 settings</li> <li>Introducing Office 365 Groups</li> <li>Delve</li> <li>Ownership and Access</li> <li>OneDrive</li> </ul> <h3>2 - Creating Sites</h3> <ul> <li>Planning your sites</li> <li>Create new subsites</li> <li>The Office 365 tenant</li> <li>Site templates</li> <li>Web addresses</li> <li>Apply a them</li> <li>Site collections</li> <li>Building your navigation</li> <li>Create a new site</li> <li>Delete subsites</li> <li>Team site navigation</li> <li>User interface: classic vs modern</li> <li>Site contents: classic vs modern</li> <li>Where does classic come from?</li> </ul> <h3>3 - Creating and Managing Web Pages</h3> <ul> <li>The types of pages found in SharePoint</li> <li>Classic SharePoint pages</li> <li>Modern SharePoint pages</li> <li>How to use classic team site pages</li> <li>Create news and site pages</li> <li>Review features of publishing sites</li> <li>Web parts</li> <li>Save, publish, share and delete pages</li> <li>Communication sites</li> </ul> <h3>4 - Working with Apps</h3> <ul> <li>An introduction to apps</li> <li>Co-authoring</li> <li>Marketplace apps</li> <li>Check In ? Out</li> <li>Adding apps to a site</li> <li>Edit and view file properties</li> <li>Create and manage columns</li> <li>Quick edit view</li> <li>Public and personal views</li> <li>File commands</li> <li>Managing app settings</li> <li>Copy link and Share</li> <li>Content approval</li> <li>Folders</li> <li>Major and minor versioning</li> <li>The recycle bin</li> <li>Document sets</li> <li>Alerts</li> <li>Working with files in a library</li> <li>OneDrive sync</li> <li>Create, Upload and edit files</li> <li>Working with classic lists</li> </ul> <h3>5 - Building processes with Flow and PowerApps</h3> <ul> <li>What are business processes?</li> <li>Design and publish a Flow</li> <li>Classic tools for designing processes</li> <li>Getting started with PowerApps in SharePoint</li> <li>Design and test a classic workflow</li> <li>Enhance data capture with PowerApps</li> <li>Getting started with Flow in SharePoint</li> <li>Test a Flow and PowerApps enriched list</li> </ul> <h3>6 - Customizing Security</h3> <ul> <li>Office 365 Group access</li> <li>Share a file</li> <li>Updating Office 365 Group Security</li> <li>Remove a user</li> <li>Managing access to SharePoint</li> <li>Customizing SharePoint security</li> <li>New sites private vs public</li> <li>Create permission levels and groups</li> <li>Setup access requests</li> <li>Security inheritance</li> <li>Share a site</li> <li>Security best practices</li> </ul> <h3>7 - Working with Search</h3> <ul> <li>Delve</li> <li>Search tips</li> <li>An introduction to SharePoint search</li> <li>Accessing classic search</li> <li>Search in folders, libraries and sites</li> <li>Promoted results</li> <li>Search results</li> </ul> <h3>8 - Enterprise Content Management</h3> <ul> <li>Managed metadata service</li> <li>Information management policies</li> <li>An introduction to content types</li> <li>The records center</li> <li>Create and manage content type</li> <li>In-place records management</li> <li>Deploy content types</li> <li>The content organizer</li> <li>Using content types in apps</li> <li>Durable links</li> <li>The content type hub</li> </ul></div>

Microsoft Sharepoint

SharePoint

55215 SharePoint Online Power User

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p></p><p>This course is intended for IT Professionals who are already experienced in general Windows Server, Windows client, Azure, and Microsoft 365 administration, and who want to learn more about using Windows PowerShell for administration. No prior experience with any version of PowerShell or any scripting language is assumed. This course is also suitable for IT Professionals already experienced in server administration, including Microsoft Exchange Server, Microsoft SharePoint Server, and Microsoft SQL Server.</p><p></p><p></p><p>This course provides students with the fundamental knowledge and skills to use PowerShell for administering and automating administration of Windows servers. This course provides students the skills to identify and build the command they require to perform a specific task. In addition, students learn how to build scripts to accomplish advanced tasks such as automating repetitive tasks and generating reports. This course provides prerequisite skills supporting a broad range of Microsoft products, including Windows Server, Windows Client, Microsoft Azure, and Microsoft 365. In keeping with that goal, this course will not focus on any one of those products, although Windows Server, which is the common platform for all of those products, will serve as the example for the techniques this course teaches.</p><p></p>Prerequisites<p>Before attending this course, students must have: </p><ul><li>-Experience with Windows networking technologies and implementation.</li> <li>- Experience with Windows Server administration, maintenance, and troubleshooting.</li></ul><p></p></div><div id="course-pills-2"><h3>1 - Review Windows PowerShell</h3> <ul> <li>Learn about Windows PowerShell</li> <li>Get familiar with Windows PowerShell applications</li> <li>Identify factors to install and use Windows PowerShell</li> <li>Configure the Windows PowerShell console</li> <li>Configure the Windows PowerShell Integrated Scripting Environment (ISE)</li> <li>Use Visual Studio Code with PowerShell</li> </ul> <h3>2 - Understand the command syntax in Windows PowerShell</h3> <ul> <li>Discover the structure of PowerShell cmdlets</li> <li>Discover the parameters for using PowerShell cmdlets</li> <li>Review the tab completion feature in PowerShell</li> <li>Display the About files content in PowerShell</li> </ul> <h3>3 - Find commands and Get-Help in Windows PowerShell</h3> <ul> <li>Define modules in PowerShell</li> <li>Find cmdlets in PowerShell</li> <li>Use command aliases in PowerShell</li> <li>Use Show-Command and Get-Help in PowerShell</li> <li>Interpret the help file contents and update the local help content in PowerShell</li> </ul> <h3>4 - Manage Active Directory Domain Services using PowerShell cmdlets</h3> <ul> <li>Manage user accounts in PowerShell</li> <li>Manage groups and group memberships in PowerShell</li> <li>Manage computer accounts in PowerShell</li> <li>Manage organizational units and Active Directory objects in PowerShell</li> </ul> <h3>5 - Manage network service settings for Windows devices using PowerShell cmdlets</h3> <ul> <li>Manage IP addresses in PowerShell</li> <li>Manage IP routing in PowerShell</li> <li>Manage DNS clients in PowerShell</li> <li>Manage Windows Firewall settings in PowerShell</li> </ul> <h3>6 - Manage Windows Server settings using PowerShell cmdlets</h3> <ul> <li>Automate management tasks using the Group Policy management cmdlets</li> <li>Manage server roles and services using PowerShell cmdlets</li> <li>Manage Hyper-V Virtual Machines using PowerShell cmdlets</li> <li>Manage Internet Information Services using PowerShell cmdlets</li> </ul> <h3>7 - Manage settings for a local Windows machine using PowerShell cmdlets</h3> <ul> <li>Manage Windows 10 using PowerShell</li> <li>Manage permissions with PowerShell</li> </ul> <h3>8 - Understand the Windows PowerShell pipeline</h3> <ul> <li>Review Windows PowerShell pipeline and its output</li> <li>Discover object members in PowerShell</li> <li>Control the formatting of pipeline output</li> </ul> <h3>9 - Select, sort, and measure objects using the pipeline</h3> <ul> <li>Sort and group objects by property in the pipeline</li> <li>Measure objects in the pipeline</li> <li>Select a set of objects in the pipeline</li> <li>Select object properties in the pipeline</li> <li>Create and format calculated properties in the pipeline</li> </ul> <h3>10 - Filter objects out of the pipeline</h3> <ul> <li>Learn about the comparison operators in PowerShell</li> <li>Review basic filter syntax in the pipeline</li> <li>Review advanced filter syntax in the pipeline</li> <li>Optimize the filter performance in the pipeline</li> </ul> <h3>11 - Enumerate objects in the pipeline</h3> <ul> <li>Learn about enumerations in the pipeline</li> <li>Review basic syntax to enumerate objects in the pipeline</li> <li>Review advanced syntax to enumerate objects in the pipeline</li> </ul> <h3>12 - Send and pass data as output from the pipeline</h3> <ul> <li>Write pipeline data to a file</li> <li>Convert pipeline objects to other forms of data representation in PowerShell</li> <li>Control additional output options in PowerShell</li> </ul> <h3>13 - Pass pipeline objects</h3> <ul> <li>Pipeline parameter binding</li> <li>Identify ByValue parameters</li> <li>Pass data by using ByValue</li> <li>Pass data by using ByPropertyName</li> <li>Identify ByPropertyName parameters</li> <li>Use manual parameters to override the pipeline</li> <li>Use parenthetical commands</li> <li>Expand property values</li> </ul> <h3>14 - Connect with data stores using PowerShell providers</h3> <ul> <li>Define Windows PowerShell providers</li> <li>Review the built-in providers in PowerShell</li> <li>Access provider help in PowerShell</li> </ul> <h3>15 - Use PowerShell drives in PowerShell</h3> <ul> <li>Explain PowerShell drives in PowerShell</li> <li>Use PowerShell drive cmdlets in PowerShell</li> <li>Manage the file system in PowerShell</li> <li>Manage the registry in PowerShell</li> <li>Work with certificates in PowerShell</li> <li>Work with other PowerShell drives in PowerShell</li> </ul> <h3>16 - Review CIM and WMI</h3> <ul> <li>Review architecture of CIM and WMI</li> <li>Review repositories in CIM and WMI</li> <li>Locate online class documentation by using CIM and WMI cmdlets</li> </ul> <h3>17 - Query configuration information by using CIM and WMI</h3> <ul> <li>List local repository namespaces and classes by using CIM and WMI</li> <li>Query instances by using commands and WMI Query Language</li> <li>Connect to remote computers by using CIM and WMI cmdlets</li> <li>Query repository classes from remote computers by using CIMSession objects</li> </ul> <h3>18 - Query and manipulate repository objects by using CIM and WMI methods</h3> <ul> <li>Discover methods of repository objects by using CIM and WMI</li> <li>Locate class methods and documentation by using CIM and WMI</li> <li>Invoke methods of repository objects by using CIM and WMI</li> </ul> <h3>19 - Manage variables in Windows PowerShell scripts</h3> <ul> <li>Define variables in Windows PowerShell scripts</li> <li>Create variable names in Windows PowerShell scripts</li> <li>Assign values and types to variables in Windows PowerShell scripts</li> <li>Identify the methods and properties of variables in Windows PowerShell scripts</li> <li>Use string variables and methods in Windows PowerShell scripts</li> <li>Use date variables and methods in Windows PowerShell scripts</li> </ul> <h3>20 - Work with arrays and hash tables in Windows PowerShell scripts</h3> <ul> <li>Define an array in Windows PowerShell scripts</li> <li>Work with array lists in Windows PowerShell scripts</li> <li>Define hash tables in Windows PowerShell Scripts</li> <li>Work with hash tables in Windows PowerShell scripts</li> </ul> <h3>21 - Create and run scripts by using Windows PowerShell</h3> <ul> <li>Review Windows PowerShell scripts</li> <li>Modify scripts in the PowerShell Gallery</li> <li>Create scripts using Windows PowerShell</li> <li>Review the PowerShellGet module in Windows PowerShell</li> <li>Run scripts and set the execution policy in Windows PowerShell</li> <li>Review Windows PowerShell and AppLocker</li> <li>Sign the scripts digitally in Windows PowerShell</li> </ul> <h3>22 - Work with scripting constructs in Windows PowerShell</h3> <ul> <li>Review and use the ForEach loop in Windows PowerShell scripts</li> <li>Review and use the If construct in Windows PowerShell scripts</li> <li>Review and use the Switch construct in Windows PowerShell scripts</li> <li>Review the For construct in Windows PowerShell scripts</li> <li>Review other loop constructs in Windows PowerShell scripts</li> <li>Review Break and Continue in Windows PowerShell scripts</li> </ul> <h3>23 - Import data in different formats for use in scripts by using Windows PowerShell cmdlets</h3> <ul> <li>Use the Get-Content command in Windows PowerShell scripts</li> <li>Use the Import-Csv cmdlet in Windows PowerShell scripts</li> <li>Use the Import-Clixml cmdlet in Windows PowerShell scripts</li> <li>Use the ConvertFrom-Json cmdlet in Windows PowerShell scripts</li> </ul> <h3>24 - Use methods to accept user inputs in Windows PowerShell scripts</h3> <ul> <li>Identify values that might change in Windows PowerShell scripts</li> <li>Use the Read-Host cmdlet in Windows PowerShell scripts</li> <li>Use the Get-Credential cmdlet in Windows PowerShell scripts</li> <li>Use the Out-GridView cmdlet in Windows PowerShell scripts</li> <li>Pass parameters to a Windows PowerShell script</li> </ul> <h3>25 - Troubleshoot scripts and handle errors in Windows PowerShell</h3> <ul> <li>Interpret error messages generated for Windows PowerShell commands</li> <li>Add output to Windows PowerShell scripts</li> <li>Use breakpoints in Windows PowerShell scripts</li> <li>Interpret error actions for Windows PowerShell commands</li> </ul> <h3>26 - Use functions and modules in Windows PowerShell scripts</h3> <ul> <li>Review functions in Windows PowerShell scripts</li> <li>Use variable scope in Windows PowerShell scripts</li> <li>Create modules in Windows PowerShell scripts</li> <li>Use the dot sourcing feature in Windows PowerShell</li> </ul> <h3>27 - Manage single and multiple computers by using Windows PowerShell remoting</h3> <ul> <li>Review the remoting feature of Windows PowerShell</li> <li>Compare remoting with remote connectivity</li> <li>Review the remoting security feature of Windows PowerShell</li> <li>Enable remoting by using Windows PowerShell</li> <li>Use one-to-one remoting by using Windows PowerShell</li> <li>Use one-to-many remoting by using Windows PowerShell</li> <li>Compare remoting output with local output</li> </ul> <h3>28 - Use advanced Windows PowerShell remoting techniques</h3> <ul> <li>Review common remoting techniques of Windows PowerShell</li> <li>Send parameters to remote computers in Windows PowerShell</li> <li>Set access protection to variables, aliases, and functions by using the scope modifier</li> <li>Enable multi-hop remoting in Windows PowerShell</li> </ul> <h3>29 - Manage persistent connections to remote computers by using Windows PowerShell sessions</h3> <ul> <li>Review persistent connections in Windows PowerShell</li> <li>Create and manage persistent PSSessions by using Windows PowerShell</li> <li>Disconnect PSSessions by using Windows PowerShell</li> <li>Review the feature of implicit remoting in Windows PowerShell</li> </ul> <h3>30 - Review Azure PowerShell module</h3> <ul> <li>Review Azure PowerShell</li> <li>Review the benefits of the Azure PowerShell module</li> <li>Install the Azure PowerShell module</li> <li>Migrate Azure PowerShell from AzureRM to Azure</li> <li>Review Microsoft Azure Active Directory module for Windows PowerShell and Azure Active Directory PowerShell for Graph modules</li> </ul> <h3>31 - Review the features and tools for Azure Cloud Shell</h3> <ul> <li>Review the characteristics of Azure Cloud Shell</li> <li>Review the features and tools of Azure Cloud Shell</li> <li>Configure and experiment with Azure Cloud Shell</li> </ul> <h3>32 - Manage Azure resources with Windows PowerShell</h3> <ul> <li>Create a new Azure virtual machine by using Windows PowerShell commands</li> <li>Manage Azure virtual machines by using Windows PowerShell commands</li> <li>Manage Azure related storage by using Azure PowerShell</li> <li>Manage Azure subscriptions by using Azure PowerShell</li> </ul> <h3>33 - Manage users, groups, and licenses in Microsoft Entra ID by using Windows PowerShell</h3> <ul> <li>Review benefits to manage Microsoft 365 services by using Windows PowerShell</li> <li>Connect to the Microsoft 365 tenant by using Windows PowerShell</li> <li>Manage users in Microsoft 365 by using Windows PowerShell</li> <li>Manage groups in Microsoft 365 by using Windows PowerShell</li> <li>Manage roles in Microsoft 365 by using Windows PowerShell</li> <li>Manage licenses in Microsoft 365 by using Windows PowerShell</li> </ul> <h3>34 - Manage Exchange Online by using Windows PowerShell</h3> <ul> <li>Connect to Exchange Online by using Windows PowerShell</li> <li>Manage mailboxes in Exchange Online by using Windows PowerShell</li> <li>Manage resources in Exchange Online by using Windows PowerShell</li> <li>Manage admin roles in Exchange Online by using Windows PowerShell</li> </ul> <h3>35 - Manage SharePoint Online by using Windows PowerShell</h3> <ul> <li>Install and connect to SharePoint Online Management Shell by using Windows PowerShell</li> <li>Manage SharePoint Online users and groups by using Windows PowerShell</li> <li>Manage SharePoint sites by using Windows PowerShell</li> <li>Manage SharePoint Online external user sharing by using Windows PowerShell</li> </ul> <h3>36 - Manage Microsoft Teams by using Windows PowerShell</h3> <ul> <li>Review Microsoft Teams PowerShell module</li> <li>Install the Microsoft Teams PowerShell module</li> <li>Manage teams with Microsoft Teams PowerShell module</li> </ul> <h3>37 - Create and manage background jobs using Windows PowerShell</h3> <ul> <li>Define the types of background jobs in Windows PowerShell</li> <li>Start remote jobs and CIM/WMI jobs in Windows PowerShell</li> <li>Monitor jobs in Windows PowerShell</li> <li>Retrieve results for running jobs in Windows PowerShell</li> </ul> <h3>38 - Create and manage scheduled jobs using Windows PowerShell</h3> <ul> <li>Create and run Windows PowerShell scripts as scheduled tasks</li> <li>Define scheduled jobs in Windows PowerShell</li> <li>Create job option and job trigger objects in Windows PowerShell</li> <li>Create and register a scheduled job in Windows PowerShell</li> <li>Retrieve the results from a scheduled job in Windows PowerShell</li> </ul></div>

Azure PowerShell

Powershell

Microsoft AZ-104

AZ-040T00 Automating Administration with Powershell

<div id="course-pills-1">Duration<p>4 Days</p><p>24 CPD hours</p>This course is intended for<p></p><p>The Microsoft Security Operations Analyst collaborates with organizational stakeholders to secure information technology systems for the organization. Their goal is to reduce organizational risk by rapidly remediating active attacks in the environment, advising on improvements to threat protection practices, and referring violations of organizational policies to appropriate stakeholders. Responsibilities include threat management, monitoring, and response by using a variety of security solutions across their environment. The role primarily investigates, responds to, and hunts for threats using Microsoft Sentinel, Microsoft Defender for Cloud, Microsoft 365 Defender, and third-party security products. Since the Security Operations Analyst consumes the operational output of these tools, they are also a critical stakeholder in the configuration and deployment of these technologies.</p><p></p><p></p><p>Learn how to investigate, respond to, and hunt for threats using Microsoft Sentinel, Microsoft Defender for Cloud, and Microsoft 365 Defender. In this course you will learn how to mitigate cyberthreats using these technologies. Specifically, you will configure and use Microsoft Sentinel as well as utilize Kusto Query Language (KQL) to perform detection, analysis, and reporting. The course was designed for people who work in a Security Operations job role and helps learners prepare for the exam SC-200: Microsoft Security Operations Analyst.</p><p></p>Prerequisites<p></p><li>Basic understanding of Microsoft 365</li>  <li>Fundamental understanding of Microsoft security, compliance, and identity products</li>   <li> Intermediate understanding of Windows 10</li>  <li> Familiarity with Azure services, specifically Azure SQL Database and Azure Storage</li>   <li> Familiarity with Azure virtual machines and virtual networking</li>   <li>Basic understanding of scripting concepts.</li><p></p></div><div id="course-pills-2"><h3>1 - Introduction to Microsoft 365 threat protection</h3> <ul> <li>Explore Extended Detection &amp; Response (XDR) response use cases</li> <li>Understand Microsoft Defender XDR in a Security Operations Center (SOC)</li> <li>Explore Microsoft Security Graph</li> <li>Investigate security incidents in Microsoft Defender XDR</li> </ul> <h3>2 - Mitigate incidents using Microsoft 365 Defender</h3> <ul> <li>Use the Microsoft Defender portal</li> <li>Manage incidents</li> <li>Investigate incidents</li> <li>Manage and investigate alerts</li> <li>Manage automated investigations</li> <li>Use the action center</li> <li>Explore advanced hunting</li> <li>Investigate Microsoft Entra sign-in logs</li> <li>Understand Microsoft Secure Score</li> <li>Analyze threat analytics</li> <li>Analyze reports</li> <li>Configure the Microsoft Defender portal</li> </ul> <h3>3 - Protect your identities with Microsoft Entra ID Protection</h3> <ul> <li>Microsoft Entra ID Protection overview</li> <li>Detect risks with Microsoft Entra ID Protection policies</li> <li>Investigate and remediate risks detected by Microsoft Entra ID Protection</li> </ul> <h3>4 - Remediate risks with Microsoft Defender for Office 365</h3> <ul> <li>Automate, investigate, and remediate</li> <li>Configure, protect, and detect</li> <li>Simulate attacks</li> </ul> <h3>5 - Safeguard your environment with Microsoft Defender for Identity</h3> <ul> <li>Configure Microsoft Defender for Identity sensors</li> <li>Review compromised accounts or data</li> <li>Integrate with other Microsoft tools</li> </ul> <h3>6 - Secure your cloud apps and services with Microsoft Defender for Cloud Apps</h3> <ul> <li>Understand the Defender for Cloud Apps Framework</li> <li>Explore your cloud apps with Cloud Discovery</li> <li>Protect your data and apps with Conditional Access App Control</li> <li>Walk through discovery and access control with Microsoft Defender for Cloud Apps</li> <li>Classify and protect sensitive information</li> <li>Detect Threats</li> </ul> <h3>7 - Respond to data loss prevention alerts using Microsoft 365</h3> <ul> <li>Describe data loss prevention alerts</li> <li>Investigate data loss prevention alerts in Microsoft Purview</li> <li>Investigate data loss prevention alerts in Microsoft Defender for Cloud Apps</li> </ul> <h3>8 - Manage insider risk in Microsoft Purview</h3> <ul> <li>Insider risk management overview</li> <li>Create and manage insider risk policies</li> <li>Investigate insider risk alerts</li> <li>Take action on insider risk alerts through cases</li> <li>Manage insider risk management forensic evidence</li> <li>Create insider risk management notice templates</li> </ul> <h3>9 - Investigate threats by using audit features in Microsoft Defender XDR and Microsoft Purview Standard</h3> <ul> <li>Explore Microsoft Purview Audit solutions</li> <li>Implement Microsoft Purview Audit (Standard)</li> <li>Start recording activity in the Unified Audit Log</li> <li>Search the Unified Audit Log (UAL)</li> <li>Export, configure, and view audit log records</li> <li>Use audit log searching to investigate common support issues</li> </ul> <h3>10 - Investigate threats using audit in Microsoft Defender XDR and Microsoft Purview (Premium)</h3> <ul> <li>Explore Microsoft Purview Audit (Premium)</li> <li>Implement Microsoft Purview Audit (Premium)</li> <li>Manage audit log retention policies</li> <li>Investigate compromised email accounts using Purview Audit (Premium)</li> </ul> <h3>11 - Investigate threats with Content search in Microsoft Purview</h3> <ul> <li>Explore Microsoft Purview eDiscovery solutions</li> <li>Create a content search</li> <li>View the search results and statistics</li> <li>Export the search results and search report</li> <li>Configure search permissions filtering</li> <li>Search for and delete email messages</li> </ul> <h3>12 - Protect against threats with Microsoft Defender for Endpoint</h3> <ul> <li>Practice security administration</li> <li>Hunt threats within your network</li> </ul> <h3>13 - Deploy the Microsoft Defender for Endpoint environment</h3> <ul> <li>Create your environment</li> <li>Understand operating systems compatibility and features</li> <li>Onboard devices</li> <li>Manage access</li> <li>Create and manage roles for role-based access control</li> <li>Configure device groups</li> <li>Configure environment advanced features</li> </ul> <h3>14 - Implement Windows security enhancements with Microsoft Defender for Endpoint</h3> <ul> <li>Understand attack surface reduction</li> <li>Enable attack surface reduction rules</li> </ul> <h3>15 - Perform device investigations in Microsoft Defender for Endpoint</h3> <ul> <li>Use the device inventory list</li> <li>Investigate the device</li> <li>Use behavioral blocking</li> <li>Detect devices with device discovery</li> </ul> <h3>16 - Perform actions on a device using Microsoft Defender for Endpoint</h3> <ul> <li>Explain device actions</li> <li>Run Microsoft Defender antivirus scan on devices</li> <li>Collect investigation package from devices</li> <li>Initiate live response session</li> </ul> <h3>17 - Perform evidence and entities investigations using Microsoft Defender for Endpoint</h3> <ul> <li>Investigate a file</li> <li>Investigate a user account</li> <li>Investigate an IP address</li> <li>Investigate a domain</li> </ul> <h3>18 - Configure and manage automation using Microsoft Defender for Endpoint</h3> <ul> <li>Configure advanced features</li> <li>Manage automation upload and folder settings</li> <li>Configure automated investigation and remediation capabilities</li> <li>Block at risk devices</li> </ul> <h3>19 - Configure for alerts and detections in Microsoft Defender for Endpoint</h3> <ul> <li>Configure advanced features</li> <li>Configure alert notifications</li> <li>Manage alert suppression</li> <li>Manage indicators</li> </ul> <h3>20 - Utilize Vulnerability Management in Microsoft Defender for Endpoint</h3> <ul> <li>Understand vulnerability management</li> <li>Explore vulnerabilities on your devices</li> <li>Manage remediation</li> </ul> <h3>21 - Plan for cloud workload protections using Microsoft Defender for Cloud</h3> <ul> <li>Explain Microsoft Defender for Cloud</li> <li>Describe Microsoft Defender for Cloud workload protections</li> <li>Enable Microsoft Defender for Cloud</li> </ul> <h3>22 - Connect Azure assets to Microsoft Defender for Cloud</h3> <ul> <li>Explore and manage your resources with asset inventory</li> <li>Configure auto provisioning</li> <li>Manual log analytics agent provisioning</li> </ul> <h3>23 - Connect non-Azure resources to Microsoft Defender for Cloud</h3> <ul> <li>Protect non-Azure resources</li> <li>Connect non-Azure machines</li> <li>Connect your AWS accounts</li> <li>Connect your GCP accounts</li> </ul> <h3>24 - Manage your cloud security posture management?</h3> <ul> <li>Explore Secure Score</li> <li>Explore Recommendations</li> <li>Measure and enforce regulatory compliance</li> <li>Understand Workbooks</li> </ul> <h3>25 - Explain cloud workload protections in Microsoft Defender for Cloud</h3> <ul> <li>Understand Microsoft Defender for servers</li> <li>Understand Microsoft Defender for App Service</li> <li>Understand Microsoft Defender for Storage</li> <li>Understand Microsoft Defender for SQL</li> <li>Understand Microsoft Defender for open-source databases</li> <li>Understand Microsoft Defender for Key Vault</li> <li>Understand Microsoft Defender for Resource Manager</li> <li>Understand Microsoft Defender for DNS</li> <li>Understand Microsoft Defender for Containers</li> <li>Understand Microsoft Defender additional protections</li> </ul> <h3>26 - Remediate security alerts using Microsoft Defender for Cloud</h3> <ul> <li>Understand security alerts</li> <li>Remediate alerts and automate responses</li> <li>Suppress alerts from Defender for Cloud</li> <li>Generate threat intelligence reports</li> <li>Respond to alerts from Azure resources</li> </ul> <h3>27 - Construct KQL statements for Microsoft Sentinel</h3> <ul> <li>Understand the Kusto Query Language statement structure</li> <li>Use the search operator</li> <li>Use the where operator</li> <li>Use the let statement</li> <li>Use the extend operator</li> <li>Use the order by operator</li> <li>Use the project operators</li> </ul> <h3>28 - Analyze query results using KQL</h3> <ul> <li>Use the summarize operator</li> <li>Use the summarize operator to filter results</li> <li>Use the summarize operator to prepare data</li> <li>Use the render operator to create visualizations</li> </ul> <h3>29 - Build multi-table statements using KQL</h3> <ul> <li>Use the union operator</li> <li>Use the join operator</li> </ul> <h3>30 - Work with data in Microsoft Sentinel using Kusto Query Language</h3> <ul> <li>Extract data from unstructured string fields</li> <li>Extract data from structured string data</li> <li>Integrate external data</li> <li>Create parsers with functions</li> </ul> <h3>31 - Introduction to Microsoft Sentinel</h3> <ul> <li>What is Microsoft Sentinel?</li> <li>How Microsoft Sentinel works</li> <li>When to use Microsoft Sentinel</li> </ul> <h3>32 - Create and manage Microsoft Sentinel workspaces</h3> <ul> <li>Plan for the Microsoft Sentinel workspace</li> <li>Create a Microsoft Sentinel workspace</li> <li>Manage workspaces across tenants using Azure Lighthouse</li> <li>Understand Microsoft Sentinel permissions and roles</li> <li>Manage Microsoft Sentinel settings</li> <li>Configure logs</li> </ul> <h3>33 - Query logs in Microsoft Sentinel</h3> <ul> <li>Query logs in the logs page</li> <li>Understand Microsoft Sentinel tables</li> <li>Understand common tables</li> <li>Understand Microsoft Defender XDR tables</li> </ul> <h3>34 - Use watchlists in Microsoft Sentinel</h3> <ul> <li>Plan for watchlists</li> <li>Create a watchlist</li> <li>Manage watchlists</li> </ul> <h3>35 - Utilize threat intelligence in Microsoft Sentinel</h3> <ul> <li>Define threat intelligence</li> <li>Manage your threat indicators</li> <li>View your threat indicators with KQL</li> </ul> <h3>36 - Connect data to Microsoft Sentinel using data connectors</h3> <ul> <li>Ingest log data with data connectors</li> <li>Understand data connector providers</li> <li>View connected hosts</li> </ul> <h3>37 - Connect Microsoft services to Microsoft Sentinel</h3> <ul> <li>Plan for Microsoft services connectors</li> <li>Connect the Microsoft Office 365 connector</li> <li>Connect the Microsoft Entra connector</li> <li>Connect the Microsoft Entra ID Protection connector</li> <li>Connect the Azure Activity connector</li> </ul> <h3>38 - Connect Microsoft Defender XDR to Microsoft Sentinel</h3> <ul> <li>Plan for Microsoft Defender XDR connectors</li> <li>Connect the Microsoft Defender XDR connector</li> <li>Connect Microsoft Defender for Cloud connector</li> <li>Connect Microsoft Defender for IoT</li> <li>Connect Microsoft Defender legacy connectors</li> </ul> <h3>39 - Connect Windows hosts to Microsoft Sentinel</h3> <ul> <li>Plan for Windows hosts security events connector</li> <li>Connect using the Windows Security Events via AMA Connector</li> <li>Connect using the Security Events via Legacy Agent Connector</li> <li>Collect Sysmon event logs</li> </ul> <h3>40 - Connect Common Event Format logs to Microsoft Sentinel</h3> <ul> <li>Plan for Common Event Format connector</li> <li>Connect your external solution using the Common Event Format connector</li> </ul> <h3>41 - Connect syslog data sources to Microsoft Sentinel</h3> <ul> <li>Plan for syslog data collection</li> <li>Collect data from Linux-based sources using syslog</li> <li>Configure the Data Collection Rule for Syslog Data Sources</li> <li>Parse syslog data with KQL</li> </ul> <h3>42 - Connect threat indicators to Microsoft Sentinel</h3> <ul> <li>Plan for threat intelligence connectors</li> <li>Connect the threat intelligence TAXII connector</li> <li>Connect the threat intelligence platforms connector</li> <li>View your threat indicators with KQL</li> </ul> <h3>43 - Threat detection with Microsoft Sentinel analytics</h3> <ul> <li>What is Microsoft Sentinel Analytics?</li> <li>Types of analytics rules</li> <li>Create an analytics rule from templates</li> <li>Create an analytics rule from wizard</li> <li>Manage analytics rules</li> </ul> <h3>44 - Automation in Microsoft Sentinel</h3> <ul> <li>Understand automation options</li> <li>Create automation rules</li> </ul> <h3>45 - Threat response with Microsoft Sentinel playbooks</h3> <ul> <li>What are Microsoft Sentinel playbooks?</li> <li>Trigger a playbook in real-time</li> <li>Run playbooks on demand</li> </ul> <h3>46 - Security incident management in Microsoft Sentinel</h3> <ul> <li>Understand incidents</li> <li>Incident evidence and entities</li> <li>Incident management</li> </ul> <h3>47 - Identify threats with Behavioral Analytics</h3> <ul> <li>Understand behavioral analytics</li> <li>Explore entities</li> <li>Display entity behavior information</li> <li>Use Anomaly detection analytical rule templates</li> </ul> <h3>48 - Data normalization in Microsoft Sentinel</h3> <ul> <li>Understand data normalization</li> <li>Use ASIM Parsers</li> <li>Understand parameterized KQL functions</li> <li>Create an ASIM Parser</li> <li>Configure Azure Monitor Data Collection Rules</li> </ul> <h3>49 - Query, visualize, and monitor data in Microsoft Sentinel</h3> <ul> <li>Monitor and visualize data</li> <li>Query data using Kusto Query Language</li> <li>Use default Microsoft Sentinel Workbooks</li> <li>Create a new Microsoft Sentinel Workbook</li> </ul> <h3>50 - Manage content in Microsoft Sentinel</h3> <ul> <li>Use solutions from the content hub</li> <li>Use repositories for deployment</li> </ul> <h3>51 - Explain threat hunting concepts in Microsoft Sentinel</h3> <ul> <li>Understand cybersecurity threat hunts</li> <li>Develop a hypothesis</li> <li>Explore MITRE ATT&amp;CK</li> </ul> <h3>52 - Threat hunting with Microsoft Sentinel</h3> <ul> <li>Explore creation and management of threat-hunting queries</li> <li>Save key findings with bookmarks</li> <li>Observe threats over time with livestream</li> </ul> <h3>53 - Use Search jobs in Microsoft Sentinel</h3> <ul> <li>Hunt with a Search Job</li> <li>Restore historical data</li> </ul> <h3>54 - Hunt for threats using notebooks in Microsoft Sentinel</h3> <ul> <li>Access Azure Sentinel data with external tools</li> <li>Hunt with notebooks</li> <li>Create a notebook</li> <li>Explore notebook code</li> </ul></div>

175 Code courses in Belfast

SMPTE 2110 for engineers

By Systems & Network Training

Integrating UNIX and Microsoft

By Systems & Network Training

Integrating Linux and Microsoft

By Systems & Network Training

Complete Python programming

By Systems & Network Training

Microsoft Excel Macros & VBA - In-company

By Microsoft Office Training

Essential OTN

By Systems & Network Training

Querying Microsoft SQL Server

By Systems & Network Training

Level 4 Certificate In Education And Training

By Pochat Training

ITIL 4 Specialist: High Velocity IT: In-House Training

By IIL Europe Ltd

Elite coding course

By Elite coding courses

Search By Location