Name: Mastering SQL Programming Course
Price: 20 GBP
Availability: InStock

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>Database and system administrators</p>Overview<p>Manage physical data replacement and storageCreate, backup and restore databasesCreate and manage multiple temporary databases</p><p>In this course, students learn how to manage physical data replacement and storage, create, backup and restore databases, and create and manage multiple temporary databases.</p></div><div id="course-pills-2"><h4>SAP Adaptive Server Enterprise (ASE)</h4><ul><li>Explaining SAP ASE</li><li>Describing the Database Architecture</li><li>Using Query Editors</li></ul><h4>Installation</h4><ul><li>Installing Servers</li><li>Identifying Installation Parameters</li><li>Starting and Stopping SAP ASE</li><li>Connecting Clients to the Server</li></ul><h4>Database Server Configuration</h4><ul><li>Explaining the Server Configuration File</li><li>Modifying the Server Configuration File</li><li>Explaining Memory Mechanisms</li><li>Configuring Memory</li><li>Configuring the Size of Caches</li></ul><h4>Space Management</h4><ul><li>Creating Devices</li><li>Managing Devices</li><li>Mirroring Devices</li><li>Creating Databases</li><li>Managing Databases</li><li>Managing Disk Resources</li><li>Managing Temporary Databases</li></ul><h4>Security</h4><ul><li>Managing Roles</li><li>Creating Logins</li><li>Managing Logins</li><li>Managing Database Users</li><li>Managing Creation Permissions</li><li>Managing Object Permissions</li><li>Creating Groups</li><li>Creating Roles</li></ul><h4>Maintenance</h4><ul><li>Using SAP ASE Extraction Utilities</li><li>Using the Bulk Copy Utility</li><li>Explaining Automatic Recovery</li><li>Ensuring Database Consistency</li><li>Setting Up the High Speed Consistency Checker</li></ul><h4>Backup</h4><ul><li>Planning for Backups</li><li>Executing Database Backups</li><li>Restoring Database Backups</li><li>Performing Transaction Log Backups</li><li>Using Advanced Backup Techniques</li></ul><h4>Monitoring</h4><ul><li>Using SAP DB Control Center</li><li>Monitoring SAP ASE</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans EDB358 SAP System and Database Administration - Adaptive Server Enterprise 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 EDB358 SAP System and Database Administration - Adaptive Server Enterprise 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>

Nexus Human

AWS Certified Database

SAP Project

SAP ABAP

ABAP with SAP Netweaver

SAP S/4HANA

EDB358 SAP System and Database Administration - Adaptive Server Enterprise

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>Database Administrator<br />Enterprise Architect<br />System Administrator<br />System Architect<br />Technology Consultant</p>Overview<p>This course will prepare you to:<br />Understand the concepts of SAP BTP<br />Understand the tasks of an SAP BTP administrator<br />Administrate accounts, services, and users in SAP BTP<br />Manage connections, databases, and monitoring in SAP BTP</p><p>This course will prepare you to:Understand the concepts of SAP BTPUnderstand the tasks of an SAP BTP administratorAdministrate accounts, services, and users in SAP BTPManage connections, databases, and monitoring in SAP BTP</p></div><div id="course-pills-2"><h4>SAP Strategy</h4><ul><li>RISE with SAP and Intelligent, Sustainable Enterprise</li><li>SAP BTP Use Cases</li></ul><h4>Architectures</h4><ul><li>Account Model and Services</li><li>ABAP, Cloud Foundry, and Kyma Runtime Environments</li><li>Cloud Development Concept</li></ul><h4>Configuration</h4><ul><li>Discovery Center and Boosters</li><li>Command Line Interface</li></ul><h4>Connectivity</h4><ul><li>Destinations</li><li>Cloud Connector</li></ul><h4>User Management</h4><ul><li>Account User Management</li><li>SAP Cloud Identity Services</li></ul><h4>Database Offerings</h4><ul><li>SAP HANA Cloud</li></ul><h4>Application Lifecycle Management</h4><ul><li>Product Portfolio</li></ul><h4>Monitoring</h4><ul><li>SAP Application Logging Service</li><li>SAP Cloud ALM Interface Channel</li></ul><h4>SAP Cloud Transport Management Service</h4><ul><li>SAP Cloud Transport Management Service</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Introduction to SAP Business Technology Platform (BTP) Administration 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 Introduction to SAP Business Technology Platform (BTP) Administration 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>

SAP Human Capital Management

Bar Professional Training Course (BPTC)

Business Information Technology

Trainers Course

Introduction to SAP Business Technology Platform (BTP) Administration

<div id="course-pills-1">Duration<p>4 Days</p><p>24 CPD hours</p>This course is intended for<p>Application Consultants, Developers, System Administrators, and System Architects</p>Overview<p>Understand the need for an enterprise portalLog on to, navigate, and personalize the portalDescribe the components of SAP Enterprise PortalBuild-up a portal navigation structureAdapt the portal user interface to company specificationsExplain and use the main functions of the SAP Enterprise Portal, Knowledge Management and CollaborationExplain and use the community features of the portal add-ons Forums and WikisExplain and use the SAP Fiori Launchpad on Portal'</p><p>In this course, students will gain knowledge of the basic fundamentals surrounding the SAP Enterprise Portal.</p></div><div id="course-pills-2"><h4>Enterprise Portal</h4><ul><li>Explaining Business Motivations for Portals</li><li>Describing SAP NetWeaver</li><li>Explaining the Basics of SAP Enterprise Portal</li></ul><h4>The End User's Perspective</h4><ul><li>Logging On and Navigating in SAP Enterprise Portal</li><li>Personalizing SAP Enterprise Portal</li></ul><h4>Technical Infrastructure</h4><ul><li>Determining System Requirements</li><li>Outlining SAP Enterprise Portal's Architecture</li></ul><h4>Portal Platform Content</h4><ul><li>Explaining the Object Model for Portal Content</li><li>Managing iViews</li><li>Managing Portal Pages</li><li>Managing Worksets and Portal Roles</li><li>Explaining Business Packages</li><li>Outlining Portal Content Development Tools</li><li>Translating Portal Content</li></ul><h4>Look and Feel of the Portal</h4><ul><li>Managing Portal Themes</li><li>Managing Framework Pages</li><li>Managing Portal Desktops</li><li>Managing Portal Rules (Rule Collections)</li></ul><h4>Security Aspects</h4><ul><li>Identifying Security Aspects</li><li>Managing Users and Authentication Options</li><li>Describing Authorization Concepts</li><li>Describing Single Sign-On (SSO)</li><li>Evaluating Network Security</li></ul><h4>Knowledge Management (KM)</h4><ul><li>Outlining Knowledge Management (KM)</li><li>Describing Content Management (CM) Functions</li><li>Using Web Page Composer (WPC)</li><li>Describing Search and Classification (TREX)</li></ul><h4>Enterprise Workspaces</h4><ul><li>Explaining Enterprise Workspaces</li><li>Managing Personal Workspaces</li><li>Managing Shared Workspaces</li></ul><h4>Collaboration</h4><ul><li>Outlining Collaboration Functions</li><li>Using Forums</li><li>Using Wikis</li></ul><h4>Fiori Launchpad on the Portal</h4><ul><li>Outlining SAP Fiori Launchpad on Portal</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans SAPEP SAP Enterprise Portal - Fundamentals 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 SAPEP SAP Enterprise Portal - Fundamentals 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>

SAP Finance & Controlling

SAP Fiori

SAPEP SAP Enterprise Portal - Fundamentals

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>The primary audience for this course are Application Consultants and Business Process Owners/Team Leads/Power Users.</p>Overview<p>This course is organized in a fashion that mimics the step by step process planners will undergo in executing production planning tasks on a daily basis. We start with setup up alert profiles to manage the day to day exceptions. Participants will walk through a detailed analysis of the net requirements calculation process that is executed during product heuristics. Gain an understanding of how scheduling is performed as new orders are created. This will include analyzing source determination rules as well as scheduling strategies. Participants will analyze the pegging functionality and the master data parameters that can control the outcome of pegging. Additionally, we will perform an analysis of process, service and REM heuristics. Lastly, perform an overview of the detailed scheduling activities involved in developing an execution schedule.</p><p>In this course, students gain an in-depth understanding of the advanced topics required to implement production planning in SAP SCM APO.</p></div><div id="course-pills-2"><h4>Introduction to Production Planning in SAP Advanced Planning and Optimization (SAP APO)</h4><ul><li>Planning Demand in the Supply Chain</li><li>Using Production Planning and Detailed Scheduling (PP/DS)</li></ul><h4>Production Planning Results Evaluation</h4><ul><li>Evaluating the Planning Run Results with Alerts</li><li>Evaluating the Planning Results</li><li>Evaluating the Planning Run with Advanced Tools</li></ul><h4>Planning Procedure</h4><ul><li>Configuring Basic Parameters for Planning</li><li>Executing the Production Planning Run</li><li>Planning a Product Using the Planning Procedure</li></ul><h4>Order Creation with Product Heuristics</h4><ul><li>Using Demand Management in PP/DS</li><li>Planning Make-to-Order Production Using PP/DS</li><li>Using Firming in PP/DS</li><li>Configuring Product Heuristics</li><li>Managing the Reuse of Procurement Proposals Using the Lot-Size Calculation In Production</li><li>Planning</li></ul><h4>Scheduling in Production Planning</h4><ul><li>Determining the Source of Supply of the Order</li><li>Scheduling Operations with the Strategy Profile</li><li>Scheduling a Planned Order for Production</li></ul><h4>Pegging in Production Planning</h4><ul><li>Configuring Dynamic and Fixed Pegging</li></ul><h4>Additional Heuristics in Production Planning</h4><ul><li>Planning Production Using Process Heuristics</li><li>Planning Production Using Service Heuristics</li><li>Configuring Bottom-Up Heuristics</li><li>Planning Production Using Repetitive Manufacturing (REM) Heuristics</li><li>Outlining the Integration of Supply Network Planning (SNP) in PP/DS</li></ul><h4>Detailed Scheduling</h4><ul><li>Scheduling Operations with the Detailed Scheduling Planning Board</li><li>Planning Production with Detailed Scheduling Strategies and Heuristics</li><li>Managing Setup Times with the Setup Matrix</li><li>Managing Scheduling with the PP/DS Optimizer</li><li>Using MRP-Based Detailed Scheduling</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans SCM250 SAP Production Planning in SAP APO 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 SCM250 SAP Production Planning in SAP APO 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>

SAP Materials Management

SAP Sales & Distribution

SCM250 SAP Production Planning in SAP APO

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p>System Security Administrator<br />Security Architect<br />Technology Consultant</p>Overview<p>This course will prepare you to<br />Understand SAP Security fundamentals<br />Get an overview of the main SAP concepts for security<br />Be prepared to learn more in detail about each SAP concept for security</p><p>This course will prepare you to Understand SAP Security fundamentals. Get an overview of the main SAP concepts for security. Be prepared to learn more in detail about each SAP concept for security.</p></div><div id="course-pills-2"><h4>SAP Access Governance and Control</h4><ul><li>Overview of Security Fundamentals</li><li>Introduction to SAP Access Governance</li></ul><h4>SAP NetWeaver Application Security Overview</h4><ul><li>Describe SAP User Experience</li><li>Explain Basic User Administration for AS ABAP</li><li>Explain Basic Role Administration for AS ABAP</li><li>Describe SAP Fiori Catalog and Group Administration Concept</li><li>Describe AS JAVA Security</li><li>Discuss Custom Development and Security</li></ul><h4>SAP Access Governance and Compliance</h4><ul><li>Describe SAP Access Governance</li><li>Explain SAP GRC Access Control</li><li>Describe SAP Identity Management</li><li>Describe SAP Cloud Identity Access Governance</li></ul><h4>Infrastructure Security</h4><ul><li>Explaining Network Topology</li><li>Enabling Secure Network Communication (SNC)</li><li>Enabling Secure Sockets Layer (SSL)</li><li>Implementing Single Sign-On (SSO) in SAP Systems</li></ul><h4>Security Monitoring with SAP Solution Manager</h4><ul><li>Monitoring Security with SAP Solution Manager</li></ul><h4>SAP Data Privacy Governance and Cybersecurity</h4><ul><li>Introduce EU General Data Privacy Regulation (GDPR)</li><li>Discuss SAP Support for GDPR Compliance</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans SAP System Security Fundamentals 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 SAP System Security Fundamentals 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>

SAP Financial Accounting

SAP System Security Fundamentals

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>Technology Consultant<br /><br />System Administrator<br /><br />Application Consultant</p>Overview<p><span>This course will prepare you to:</span><br /><br /><span>Set up SLT configurations, replicate data into different targets (such as SAP HANA, SAP BW or Central Finance) and monitor the data replication.</span></p><p>In this course, you will learn how to use the trigger based real time data replication technology of the SAP LT Replication Server (SLT).</p></div><div id="course-pills-2"><h4>SAP Landscape Replication Server Overview</h4><ul><li>Explaining Positioning and Key Concepts</li><li>Identifying Use Cases</li><li>Understanding SLT as Part of the DMIS Product Family</li><li></li></ul><h4>SAP Landscape Transformation Server Introduction</h4><ul><li>Understanding the Architectural Concept</li><li> Explaining the Landscape Strategy and Sizing Aspects</li><li>Outlining the SLT Installation Procedure</li><li></li></ul><h4>Replication to SAP HANA</h4><ul><li>Setting Up Data Replication</li><li>Executing Data Replication</li><li>Understanding Advanced Replication Settings</li><li>Outlining Operations and Monitoring</li><li>Describing SLT Handling in Special Cases</li><li></li></ul><h4>Replication to SAP BW</h4><ul><li>Providing a Scenario Overview</li><li>Explaining Open Data Provisioning (ODP)</li><li>Describing Table-Based Replication</li><li>Comparing Table-Based Replication and ODP</li><li></li></ul><h4>Replication to SAP Data Services</h4><ul><li>Explaining SAP Data Services and Architecture</li><li>Describing the Setup of Replication to SAP Data Services</li><li></li></ul><h4>Replication to ABAP Systems</h4><ul><li>Describing the Architecture for Replication into an ABAP</li><li>System</li><li>Outlining the Setup for Replication into an ABAP System</li><li></li></ul><h4>Replication to Non-SAP Databases</h4><ul><li>Describing the Architecture for Replication to Non-SAP</li><li>Databases</li><li>Understanding the Setup of ABAP to Non-ABAP Replication</li><li></li></ul><h4>Replication to Central Finance</h4><ul><li>Describing the Architecture for Replication to Central</li><li>Finance</li><li>Understanding the Setup and Configuration of Replication to Central Finance</li><li></li></ul><h4>SAP Landscape Transformation Replication Server Summary</h4><ul><li>Providing a Summary of the SAP Landscape</li><li>Transformation Replication Server</li><li></li></ul><h4>SAP Landscape Transformation Replication Server 3.0 and Recent Updates</h4><ul><li>Outlining SAP Landscape Transformation Replication</li><li>Server 3 Updates</li><li></li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans SAP Real-time Replication with SAP LT Replication Server (SLT100) 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 SAP Real-time Replication with SAP LT Replication Server (SLT100) 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>

SAP Real-time Replication with SAP LT Replication Server (SLT100)

<div id="course-pills-1">Duration<p>4 Days</p><p>24 CPD hours</p>This course is intended for<p>The primary audience for this course are Technology Consultants, System Administrators, System Architects, Database Administrators, Help Desk/COE Support, and Program/Project Managers.</p>Overview<p>Presentation in detail of the architecture of SAP NetWeaver Application Server (SAP NetWeaver AS).Learn effective techniques for navigating.Receive an overview of the development process in an SAP system landscape</p><p>In this course, students gain knowledge about the fundamentals of SAP NetWeaver Application Server.</p></div><div id="course-pills-2"><h4>SAP Systems</h4><ul><li>Explaining the Key Capabilities of SAP NetWeaver</li><li>Explaining the Architecture of an SAP System, Application Server (AS) ABAP and Application Server (AS) Java</li></ul><h4>Navigation Basics</h4><ul><li>Navigating with SAP Graphical User Interface (GUI) for Windows in AS ABAP Systems</li><li>Navigating with a Browser in AS Java Systems</li></ul><h4>System Core</h4><ul><li>Explaining AS ABAP and AS Java System Architecture</li><li>Identifying the Processes of an AS ABAP System</li><li>Processing User Requests in AS ABAP</li><li>Using Additional Processes of an AS ABAP System</li><li>Explaining the Processes of an AS Java System</li></ul><h4>Software Development in SAP Systems</h4><ul><li>Outlining the Data Structure of an AS ABAP System</li><li>Managing Transports in the ABAP Environment</li><li>Explaining ABAP Workbench Tools</li><li>Developing and Transporting an ABAP Repository Object</li><li>Developing Applications in AS Java</li><li>Developing Applications in Eclipse for ABAP</li></ul><h4>Communication and Integration Technologies</h4><ul><li>Describing Communication with Remote Function Call-Based (RFC) Technology</li><li>Describing the Basics of Web Services</li><li>Describing OData in SAP Gateway</li></ul><h4>Application Lifecycle Management (ALM)</h4><ul><li>Explaining Application Lifecycle Management (ALM)</li><li>Describing the Installation of an SAP System</li><li>Describing the Maintenance of an SAP System</li></ul><h4>SAP Portfolio Overview</h4><ul><li>Identifying the Platform, Database, and User Experience in the SAP Technology Portfolio</li><li>Outlining Additional Components of the SAP Technology Portfolio</li><li>Identifying the Components of the SAP Applications Portfolio</li></ul><h4>SAP User Interfaces</h4><ul><li>Accessing AS ABAP Systems with SAP GUI</li><li>Accessing SAP Systems Using Other User Interfaces</li></ul><h4>Additional Information Sources</h4><ul><li>Accessing the SAP Service Marketplace (SMP)</li><li>Accessing the SAP Community Network (SCN)</li></ul></div>

SAPTEC Technology Fundamentals for SAP S/4HANA and SAP Business Suite

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>Implementer</p>Overview<p>Enrolling in this course will help you better understand and leverage PeopleSoft Payroll for North America (USA) payroll requirements and processes. This knowledge will help you create, adjust and troubleshoot your organization's employee payroll.<br />Learn Off-Cycle Payroll Events<br />In addition to typical on-cycle payroll processing, Payroll for North America provides functionality for a variety of off-cycle payroll events and other payroll requirements. This course will illustrate how to reverse a paycheck, record a manual check, produce online checks and final checks and create a gross up check. In addition, you'll also learn the necessary steps to set up and process mid-period job changes and multiple jobs. Finally, you'll set up and processes benefit deductions and garnishments.</p><p>This PeopleSoft Payroll - US Rel 9.2 training teaches you how to set up and maintain employee tax data, additional pay, general deductions and direct deposits. Expert Oracle University instructors will show you how to use this solution to calculate payroll, review calculation results, identify and correct errors, confirm payroll and more.</p></div><div id="course-pills-2"><h4>Setting Up PeopleSoft HRMS Tables for Payroll Processing</h4><ul><li>Identifying HRMS Tables That Impact Payroll Processing<br />Describing Installation Table Setup for PeopleSoft Enterprise Payroll for North America<br />Describing the Role of SetID, Location, and Department in Payroll Processing<br />Describing Company Table Setup<br />Desc</li></ul><h4>Setting Up Payroll Tables</h4><ul><li>Identifying Payroll Setup Tables<br />Setting Up Source Bank Accounts<br />Creating Special Accumulators<br />Setting Up Earnings Codes<br />Setting Up Earnings Programs<br />Describing Shift Pay Setup<br />Creating a Pay Group<br />Creating a Rate Code</li></ul><h4>Setting Up U.S. Payroll Tax Tables</h4><ul><li>Identifying Tax Table Maintenance Responsibility<br />Describing PeopleSoft-Maintained Tax Tables<br />Setting Up Customer-Maintained Tax Tables</li></ul><h4>Setting Up Employee Data</h4><ul><li>Identifying Sources of Employee Data<br />Setting Up an Employee Instance<br />Entering and Viewing Employee Job Data<br />Identifying Employee Pay Data<br />Updating Employee Tax Data<br />Assigning Additional Pay to Employees<br />Assigning General Deductions to Employees<br />Updating P</li></ul><h4>Creating and Updating Paysheets</h4><ul><li>Describing Paysheets in Payroll for North America<br />Describing Balance ID Creation<br />Creating Pay Calendars<br />Setting Up Pay Run IDs<br />Creating Paysheets<br />Viewing and Updating Paysheets and Paylines<br />Describing the Payroll Unsheet Process</li></ul><h4>Calculating Payroll</h4><ul><li>Describing Payroll Calculation<br />Running Preliminary Payroll Calculation<br />Running Final Payroll Calculation</li></ul><h4>Confirming Payroll and Producing Checks and Reports</h4><ul><li>Confirming a Payroll<br />Viewing Confirmed Payroll Results Online<br />Printing Checks and Advices<br />Describing Check Reprinting<br />Describing Direct Deposit Transmittals and Reports<br />Describing Payroll and Tax Reports<br />Identifying Methods of Reversing Payroll Confirmati</li></ul><h4>Processing Off-Cycle Payrolls</h4><ul><li>Identifying Off-Cycle Payroll Processing<br />Reversing a Paycheck<br />Describing Reversal/Adjustment Processing<br />Recording a Manual Check<br />Producing an Online Check<br />Describing Retroactive Processing</li></ul><h4>Setting Up and Processing Additional Payroll Functionality</h4><ul><li>Setting Up a Holiday Schedule<br />Setting Up Advanced Earnings Options<br />Setting Up Multiple Jobs Processing<br />Setting Up and Processing Mid-period Job Changes<br />Processing Gross Ups</li></ul><h4>Setting Up and Processing Benefit Deductions in Payroll</h4><ul><li>Setting Up Deductions and Earnings for Benefits Calculations<br />Updating a Benefit Program and Enrolling Employees<br />Analyzing Benefits-Related Payroll Reports</li></ul><h4>Setting Up and Processing Garnishments</h4><ul><li>Identifying Garnishment Setup Steps<br />Describing PeopleSoft-Maintained Garnishment Tables<br />Setting Up Company-Level Tables for Garnishment Processing<br />Assigning an Employee Garnishment Deduction<br />Setting Up Employee Garnishment Specification Data<br />Reviewing Emp</li></ul><h4>Describing PeopleSoft Enterprise ePay</h4><ul><li>Identifying HRMS Tables That Impact Payroll Processing<br />Describing Installation Table Setup for PeopleSoft Enterprise Payroll for North America<br />Describing the Role of SetID, Location, and Department in Payroll Processing<br />Describing Company Table Setup<br />Desc</li></ul></div>

Certified Payroll Professional (CPP)

Oracle Fusion HCM

Professional payroll & pensions qualifications (CIPP)

Sage Payroll

Payroll

Oracle PeopleSoft Payroll - US Rel 9.2

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This course is recommended for application or system support personnel or anyone who needs an overview of the capabilities of HP UD 10.1x.</p>Overview<p>Upon successful completion of this course, you should be able to:<br />Identify the evolution of the Configuration Management System (CMS) from the Configuration Management Database (CMDB), the need for CMS, and working of CMS<br />Define the concept of Universal Discovery (UD) and be able to identify its applications and types<br />Identify the architecture and deployment process of UD, and the installation and setup of the data flow probe and its log files<br />Define the concepts of discovery adapters, discovery jobs, discovery scripts, and other discovery resources<br />Use the Universal Discovery module to perform application dependency mapping discovery and inventory discovery<br />Use zone-based discover method and discovery activities<br />Design and build agentless and agent-based discoveries, and use inventory scanners<br />Work with the Software Library Viewer and various inventory tools<br />Use the application recognition process, and discovery rules HP</p><p>This course is designed to provide an understanding of the fundamental concepts and applications of the HP Universal Discovery (UD) solution.</p></div><div id="course-pills-2">This course is designed to provide an understanding of the fundamental concepts and applications of the HP Universal Discovery (UD) solution.</div>

Microsoft DP-900

UD120 - Universal Discovery 10.x Essentials

NextGen Learning

Mastering SQL Programming Course

General Admission

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p></p><p>The Microsoft 365 Endpoint Administrator is responsible for deploying, configuring, securing, managing, and monitoring devices and client applications in a corporate setting. Their duties include managing identity, access, policies, updates, and apps. They work alongside the M365 Enterprise Administrator to develop and execute a device strategy that aligns with the requirements of a modern organization. Microsoft 365 Endpoint Administrators should be well-versed in M365 workloads and possess extensive skills and experience in deploying, configuring, and maintaining Windows 11 and later, as well as non-Windows devices. Their role emphasizes cloud services over on-premises management technologies.</p><p></p><p></p><p>In this course, students will learn to plan and execute an endpoint deployment strategy using contemporary deployment techniques and implementing update strategies. The course introduces essential elements of modern management, co-management approaches, and Microsoft Intune integration. It covers app deployment, management of browser-based applications, and key security concepts such as authentication, identities, access, and compliance policies. Technologies like Microsoft Entra ID, Azure Information Protection, and Microsoft Defender for Endpoint are explored to protect devices and data.</p><p></p>Prerequisites<p>The Modern Desktop Administrator must be familiar with M365 workloads and must have strong skills and experience of deploying, configuring, and maintaining Windows 11 and later, and non-Windows devices.</p></div><div id="course-pills-2"><h3>1 - Explore the Enterprise Desktop</h3> <ul> <li>Examine benefits of modern management</li> <li>Examine the enterprise desktop life-cycle model</li> <li>Examine planning and purchasing</li> <li>Examine desktop deployment</li> <li>Plan an application deployment</li> <li>Plan for upgrades and retirement</li> </ul> <h3>2 - Explore Windows Editions</h3> <ul> <li>Examine Windows client editions and capabilities</li> <li>Select client edition</li> <li>Examine hardware requirements</li> </ul> <h3>3 - Understand Microsoft Entra ID</h3> <ul> <li>Examine Microsoft Entra ID</li> <li>Compare Microsoft Entra ID and Active Directory Domain Services</li> <li>Examine Microsoft Entra ID as a directory service for cloud apps</li> <li>Compare Microsoft Entra ID P1 and P2 plans</li> <li>Examine Microsoft Entra Domain Services</li> </ul> <h3>4 - Manage Microsoft Entra identities</h3> <ul> <li>Examine RBAC and user roles in Microsoft Entra ID</li> <li>Create and manage users in Microsoft Entra ID</li> <li>Create and manage groups in Microsoft Entra ID</li> <li>Manage Microsoft Entra objects with PowerShell</li> <li>Synchronize objects from AD DS to Microsoft Entra ID</li> </ul> <h3>5 - Manage device authentication</h3> <ul> <li>Describe Microsoft Entra join </li> <li>Examine Microsoft Entra join prerequisites limitations and benefits</li> <li>Join devices to Microsoft Entra ID</li> <li>Manage devices joined to Microsoft Entra ID</li> </ul> <h3>6 - Enroll devices using Microsoft Configuration Manager</h3> <ul> <li>Deploy the Microsoft Configuration Manager client</li> <li>Monitor the Microsoft Configuration Manager client</li> <li>Manage the Microsoft Configuration Manager client</li> </ul> <h3>7 - Enroll devices using Microsoft Intune</h3> <ul> <li>Manage mobile devices with Intune</li> <li>Enable mobile device management</li> <li>Explain considerations for device enrollment</li> <li>Manage corporate enrollment policy</li> <li>Enroll Windows devices in Intune</li> <li>Enroll Android devices in Intune</li> <li>Enroll iOS devices in Intune</li> <li>Explore device enrollment manager</li> <li>Monitor device enrollment</li> <li>Manage devices remotely</li> </ul> <h3>8 - Execute device profiles</h3> <ul> <li>Explore Intune device profiles</li> <li>Create device profiles</li> <li>Create a custom device profile</li> </ul> <h3>9 - Oversee device profiles</h3> <ul> <li>Monitor device profiles in Intune</li> <li>Manage device sync in Intune</li> <li>Manage devices in Intune using scripts</li> </ul> <h3>10 - Maintain user profiles</h3> <ul> <li>Examine user profile</li> <li>Explore user profile types</li> <li>Examine options for minimizing user profile size</li> <li>Deploy and configure folder redirection</li> <li>Sync user state with Enterprise State Roaming</li> <li>Configure Enterprise State Roaming in Azure</li> </ul> <h3>11 - Execute mobile application management</h3> <ul> <li>Examine mobile application management</li> <li>Examine considerations for mobile application management</li> <li>Prepare line-of-business apps for app protection policies</li> <li>Implement mobile application management policies in Intune</li> <li>Manage mobile application management policies in Intune</li> </ul> <h3>12 - Deploy and update applications</h3> <ul> <li>Deploy applications with Intune</li> <li>Add apps to Intune</li> <li>Manage Win32 apps with Intune</li> <li>Deploy applications with Configuration Manager</li> <li>Deploying applications with Group Policy</li> <li>Assign and publish software</li> <li>Explore Microsoft Store for Business</li> <li>Implement Microsoft Store Apps</li> <li>Update Microsoft Store Apps with Intune</li> <li>Assign apps to company employees</li> </ul> <h3>13 - Administer endpoint applications</h3> <ul> <li>Manage apps with Intune</li> <li>Manage Apps on non-enrolled devices</li> <li>Deploy Microsoft 365 Apps with Intune</li> <li>Additional Microsoft 365 Apps Deployment Tools</li> <li>Configure Microsoft Edge Internet Explorer mode</li> <li>App Inventory Review</li> </ul> <h3>14 - Protect identities in Microsoft Entra ID</h3> <ul> <li>Explore Windows Hello for Business</li> <li>Deploy Windows Hello</li> <li>Manage Windows Hello for Business</li> <li>Explore Microsoft Entra ID Protection</li> <li>Manage self-service password reset in Microsoft Entra ID</li> <li>Implement multi-factor authentication</li> </ul> <h3>15 - Enable organizational access</h3> <ul> <li>Enable access to organization resources</li> <li>Explore VPN types and configuration</li> <li>Explore Always On VPN</li> <li>Deploy Always On VPN</li> </ul> <h3>16 - Implement device compliance</h3> <ul> <li>Protect access to resources using Intune</li> <li>Explore device compliance policy</li> <li>Deploy a device compliance policy</li> <li>Explore conditional access</li> <li>Create conditional access policies</li> </ul> <h3>17 - Generate inventory and compliance reports</h3> <ul> <li>Report enrolled devices inventory in Intune</li> <li>Monitor and report device compliance</li> <li>Build custom Intune inventory reports</li> <li>Access Intune using Microsoft Graph API</li> </ul> <h3>18 - Deploy device data protection</h3> <ul> <li>Explore Windows Information Protection</li> <li>Plan Windows Information Protection</li> <li>Implement and use Windows Information Protection</li> <li>Explore Encrypting File System in Windows client</li> <li>Explore BitLocker</li> </ul> <h3>19 - Manage Microsoft Defender for Endpoint</h3> <ul> <li>Explore Microsoft Defender for Endpoint</li> <li>Examine key capabilities of Microsoft Defender for Endpoint</li> <li>Explore Windows Defender Application Control and Device Guard</li> <li>Explore Microsoft Defender Application Guard</li> <li>Examine Windows Defender Exploit Guard</li> <li>Explore Windows Defender System Guard</li> </ul> <h3>20 - Manage Microsoft Defender in Windows client</h3> <ul> <li>Explore Windows Security Center</li> <li>Explore Windows Defender Credential Guard</li> <li>Manage Microsoft Defender Antivirus</li> <li>Manage Windows Defender Firewall</li> <li>Explore Windows Defender Firewall with Advanced Security</li> </ul> <h3>21 - Manage Microsoft Defender for Cloud Apps</h3> <ul> <li>Explore Microsoft Defender for Cloud Apps</li> <li>Planning Microsoft Defender for Cloud Apps</li> <li>Implement Microsoft Defender for Cloud Apps</li> </ul> <h3>22 - Assess deployment readiness</h3> <ul> <li>Examine deployment guidelines</li> <li>Explore readiness tools</li> <li>Assess application compatibility</li> <li>Explore tools for application compatibility mitigation</li> <li>Prepare network and directory for deployment</li> <li>Plan a pilot</li> </ul> <h3>23 - Deploy using the Microsoft Deployment Toolkit</h3> <ul> <li>Evaluate traditional deployment methods</li> <li>Set up the Microsoft Deployment Toolkit for client deployment</li> <li>Manage and deploy images using the Microsoft Deployment Toolkit</li> </ul> <h3>24 - Deploy using Microsoft Configuration Manager</h3> <ul> <li>Explore client deployment using Configuration Manager</li> <li>Examine deployment components of Configuration Manager</li> <li>Manage client deployment using Configuration Manager</li> <li>Plan in-place upgrades using Configuration Manager</li> </ul> <h3>25 - Deploy Devices using Windows Autopilot</h3> <ul> <li>Use Autopilot for modern deployment</li> <li>Examine requirements for Windows Autopilot</li> <li>Prepare device IDs for Autopilot</li> <li>Implement device registration and out-of-the-box customization</li> <li>Examine Autopilot scenarios</li> <li>Troubleshoot Windows Autopilot</li> </ul> <h3>26 - Implement dynamic deployment methods</h3> <ul> <li>Examine subscription activation</li> <li>Deploy using provisioning packages</li> <li>Use Windows Configuration Designer</li> <li>Use Microsoft Entra join with automatic MDM enrollment</li> </ul> <h3>27 - Plan a transition to modern endpoint management</h3> <ul> <li>Explore using co-management to transition to modern endpoint management</li> <li>Examine prerequisites for co-management</li> <li>Evaluate modern management considerations</li> <li>Evaluate upgrades and migrations in modern transitioning</li> <li>Migrate data when modern transitioning</li> <li>Migrate workloads when modern transitioning</li> </ul> <h3>28 - Manage Windows 365</h3> <ul> <li>Explore Windows 365</li> <li>Configure Windows 365</li> <li>Administer Windows 365</li> </ul> <h3>29 - Manage Azure Virtual Desktop</h3> <ul> <li>Examine Azure Virtual Desktop</li> <li>Explore Azure Virtual Desktop</li> <li>Configure Azure Virtual Desktop</li> <li>Administer Azure Virtual Desktop</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans MD-102T00 : Microsoft 365 Endpoint Administrator 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 MD-102T00 : Microsoft 365 Endpoint Administrator 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 Certification

Microsoft 365

Microsoft AZ-900

Microsoft AZ-104

Microsoft AZ-303

Microsoft AZ-700

MD-102T00 Microsoft 365 Endpoint Administrator

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This course is for experienced information technology (IT) professionals, typically described as Enterprise Desktop Administrators (EDAs). These EDAs deploy, manage, and maintain PCs, devices, and applications across medium, large, and enterprise organizations. A significant portion of this audience uses, or intends to use, the latest release of Configuration Manager to manage and deploy PCs, devices, and applications.</p>Overview<p>Describe the features Configuration Manager and Intune include, and explain how you can use these features to manage PCs and mobile devices in an enterprise environment. Analyze data by using queries and reports. Prepare a management infrastructure, including configuring boundaries, boundary groups, and resource discovery, and integrating mobile-device management with Intune. Deploy and manage the Configuration Manager client. Configure, manage, and monitor hardware and software inventory, and use Asset Intelligence and software metering. Identify and configure the most appropriate method to distribute and manage content used for deployments. Distribute, deploy, and monitor applications for managed users and systems. Maintain software updates for PCs that Configuration Manager manages. Implement Endpoint Protection for managed PCs. Configure an operating-system deployment strategy by using Configuration Manager. Manage and maintain a Configuration Manager site.</p><p>This five-day course describes how to use Configuration Manager and its associated site systems to efficiently manage network resources. In this five-day course, you will learn day-to-day management tasks, including how to manage applications, client health, hardware and software inventory, operating system deployment, and software updates by using Configuration Manager. You also will learn how to optimize Endpoint Protection, manage compliance, and create management queries and reports.  Although this course and the associated labs are written for Microsoft Endpoint Configuration Manager and Windows 11, the skills taught will also be backwards compatible with previous editions of System Center Configuration Manager and Windows 10.</p>Prerequisites<p></p><li>Networking fundamentals, including common networking protocols, topologies, hardware, media, routing, switching, and addressing.</li>  <li>Active Directory Domain Services (AD DS) principles and fundamentals of AD DS management.</li>  <li>Installation, configuration, and troubleshooting for Windows-based personal computers.</li>  <li>Basic concepts of public key infrastructure (PKI) security.</li>  <li>Basic understanding of scripting and Windows PowerShell syntax.</li>  <li>Basic understanding of Windows Server roles and services.</li>  <li>Basic understanding of the configuration options for iOS and Android Mobile device platforms.</li><p></p></div><div id="course-pills-2"><h3>1 - Managing computers and mobile devices in the enterprise</h3> <ul> <li>Overview of systems management by using enterprise management solutions</li> <li>Overview of the Configuration Manager architecture</li> <li>Overview of the Configuration Manager administrative tools</li> <li>Tools for monitoring and troubleshooting a Configuration Manager site</li> </ul> <h3>2 - Analyzing data using queries, reports, and CMPivot</h3> <ul> <li>Introduction to queries</li> <li>Configuring SQL Server Reporting Services</li> <li>Analyzing the real-time state of a device by using CMPivot</li> </ul> <h3>3 - Preparing the Configuration Manager management infrastructure</h3> <ul> <li>Configuring site boundaries and boundary groups</li> <li>Configuring resource discovery</li> <li>Organizing resources using device and user collections</li> </ul> <h3>4 - Deploying and managing the Configuration Manager client</h3> <ul> <li>Overview of the Configuration Manager client</li> <li>Deploying the Configuration Manager client</li> <li>Configuring and monitoring client status</li> <li>Managing client settings and performing management operations</li> </ul> <h3>5 - Managing inventory for PCs and applications</h3> <ul> <li>Overview of inventory collection</li> <li>Configuring hardware and software inventory</li> <li>Managing inventory collection</li> <li>Configuring software metering</li> <li>Configuring and managing Asset Intelligence</li> </ul> <h3>6 - Distributing and managing content used for deployments</h3> <ul> <li>Preparing the infrastructure for content management</li> <li>Distributing and managing content on distribution points</li> </ul> <h3>7 - Deploying and managing applications</h3> <ul> <li>Overview of application management</li> <li>Creating applications</li> <li>Deploying applications</li> <li>Managing applications</li> <li>Deploying and managing Windows apps</li> </ul> <h3>8 - Maintaining software updates for managed PCs</h3> <ul> <li>The software updates process</li> <li>Preparing a Configuration Manager site for software updates</li> <li>Managing software updates</li> <li>Configuring automatic deployment rules</li> <li>Monitoring and troubleshooting software updates</li> <li>Enabling third-party updates</li> </ul> <h3>9 - Implementing Defender Protection for managed PCs</h3> <ul> <li>Overview of Endpoint Protection in Configuration Manager</li> <li>Configuring, deploying, and monitoring Endpoint Protection policies</li> <li>Configuring and deploying advanced threat policies</li> <h3>10 - Managing compliance and secure data access</h3> <ul> <li>Overview of Compliance Settings</li> <li>Configuring compliance settings</li> <li>Viewing compliance results</li> <li>Managing resource and data access</li> <h3>11 - Managing operating system deployment</h3> <ul> <li>An overview of operating system deployment</li> <li>Preparing a site for operating system deployment</li> <li>Deploying an operating system</li> <li>Managing Windows as a service</li> <h3>12 - Managing and maintaining a Configuration Manager site</h3> <ul> <li>Configuring role-based administration</li> <li>Configuring Remote Tools</li> <li>Overview of Configuration Manager site maintenance and Management Insights</li> <li>Backing up and recovering a Configuration Manager site</li> <li>Updating the Configuration Manager infrastructure</li> <h3>13 - What?s new in Microsoft Endpoint Configuration Manager</h3> <ul> <li>Whats new in Microsoft Endpoint Manager covering each semi annual release</li> </ul></ul></ul></ul></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans 55348: Administering Microsoft Endpoint Configuration Manager 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 55348: Administering Microsoft Endpoint Configuration Manager 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>

Sccm

Microsoft Certified Technology Specialist (MCTS)

Commercial & Contract Management Certification Program (CCM)

IT Manager

Microsoft Certified Trainer (MCT)

55348 Administering Microsoft Endpoint Configuration Manager

<div data-node="61658ba442cd6" style="color: rgb(117, 117, 117); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(117, 117, 117);"><div data-node="61658ba442cd7" fr-original-style="" style="box-sizing: border-box;"><div data-node="61658ba442cd8" fr-original-style="" style="box-sizing: border-box;"><div data-node="61658ba442cd9" data-animation-delay="0" data-animation-duration="1" fr-original-style="" style="box-sizing: border-box;"><div data-node="6165945ab79d7" style="color: rgb(117, 117, 117); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(117, 117, 117);"><div data-node="6165945ab79d8" fr-original-style="" style="box-sizing: border-box;"><div data-node="6165945ab79d9" fr-original-style="" style="box-sizing: border-box;"><div data-node="6165945ab79da" data-animation-delay="0" data-animation-duration="1" fr-original-style="" style="box-sizing: border-box;"><div data-node="61657d76a40c2" style="color: rgb(117, 117, 117); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(117, 117, 117);"><div data-node="61657d76a40c3" fr-original-style="" style="box-sizing: border-box;"><div data-node="61657d76a40c4" fr-original-style="" style="box-sizing: border-box;"><div data-node="61657d76a40c5" data-animation-delay="0" data-animation-duration="1" fr-original-style="" style="box-sizing: border-box;"><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Digital Electronics Course</span></h3></div><div data-node="618322664d7fd" data-animation-delay="0" data-animation-duration="1" fr-original-style="" style="box-sizing: border-box;"><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Aim</span></h3><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">This <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Digital Electronics Course</strong>&nbsp;is designed to give practical knowledge of the type of electronic circuitry used in a modern Computer System or in any type of Computer Controlled equipment such as Photocopiers, Cash Registers, Tablets, mobile phones and many other types of IT equipment.&nbsp;</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Digital Electronics involves the use of Silicon chips (Integrated Circuits). The internal structure of a computer is to a large extent comprised of Digital Electronic Circuits.</p></div></div><div data-node="618322b7d4864" data-animation-delay="0" data-animation-duration="1" fr-original-style="" style="box-sizing: border-box;"><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Duration and Schedule</span></h3><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">This <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Digital Electronics Course</strong> runs over 10 evenings (every Monday and Wednesday) from 7.00pm to 10.00pm with the next course commencing on&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="color: rgb(255, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(255, 0, 0);">Monday 2nd September 2024 at 7.00 pm</span>.</strong></p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="color: rgb(255, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(255, 0, 0);"><b style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">A payment of &pound;65 secures your place on your chosen course.</b><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">&nbsp;The balance of the course fees of &pound;600 can be paid shortly before course commencement.</span></span><br fr-original-style="" style="box-sizing: border-box;"></strong></p></div></div></div></div></div><div data-node="61657d76a40c7" style="color: rgb(117, 117, 117); box-sizing: border-box;" fr-original-style=" color: rgb(117, 117, 117);"><div data-node="61657d76a40c8" fr-original-style="" style="box-sizing: border-box;"><div data-node="61657d76a40c9" fr-original-style="" style="box-sizing: border-box;"><div data-node="6183230b58256" data-animation-delay="0" data-animation-duration="1" fr-original-style="" style="box-sizing: border-box;"><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Online Virtual Classroom &ndash; how it works?</span></h3><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">The course will be delivered through 9 online virtual classroom sessions. The 10th and last session will involve the additional practical work for the course as well as the written examination (multiple choice for City &amp; Guilds and written for Hi-Tech Training) which will take place at our training centre at 43 North Great Georges Street, Dublin 1 (completed online for non ROI learners).</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">During the virtual classroom sessions, trainees will have a live video feed with their instructor talking to them, doing practical live demonstrations on equipment being involved actively in the learning.</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">We will send out a practical kit so that trainees can complete assignments and practical work at home. The kit is the property of Hi-Tech Training and will be returned to Hi-Tech Training on the last day of the course.<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">(The kits may also be purchased by the learner&hellip;.see the&nbsp;<a href="http://hitechtraining.ie/product-category/electronics-courses/digital-electronics-course/" target="_blank" rel="noopener" style="color: rgb(209, 33, 56); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(209, 33, 56);">Kits Page Link</a>&nbsp;for more details).<br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">The kit consists of power supply unit breadboard, multimeter, cables, The kit consists of breadboard, multimeter, oscilloscope, battery and connectors, components including resistors, LEDs and ICs (AND, NAND, OR, NOR, X-OR, X-NOR, Inverter, Buffer, Latches, Flip-Flops, Timers, etc). Trainees will build various projects as part of the course. The kit forms an integral part of the course, so full course fees need to be paid at least 7 days prior to course commencement to allow time to ship the kit in time for the course.</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">* If attending the course from outside of Ireland the course practical training kit must be purchased via our online shop in time for delivery before course commencement. The equipment will then remain the property of the trainee.</strong></p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">In preparation for each course, we have a quick informal free 1 hr online meeting approx. 7 days prior to course commencement, to make sure that trainees get connected through Zoom properly, let them know what the virtual classroom will be like and go through any questions they may have. To join the virtual sessions, you will need a PC/Laptop or Tablet with an internet connection. Joining instructions (login IDs, etc.) will be sent before the Informal Induction session.</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><br fr-original-style="" style="box-sizing: border-box;"></p></div></div><div data-node="61657d76a40d2" data-animation-delay="0.0" data-animation-duration="1" fr-original-style="" style="box-sizing: border-box;"><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Learning Objectives</span></h3><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">This course equips participants with practical &ldquo;Hands-on&rdquo; skills relevant to the workplace and the theory required for certification. Participants can expect to have the skills to:&nbsp;</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Build and fault-finding a range of Digital Electronic circuits used in computers and computer-controlled equipment</li><li fr-original-style="" style="box-sizing: border-box;">Use test equipment including Multimeters, Oscilloscopes, logic probes and pulsers to implement systematic fault-finding techniques.</li><li fr-original-style="" style="box-sizing: border-box;">Study and use of popular Digital Electronic gates and more advanced circuits</li></ul></div></div><div data-node="61657d76a40d7" data-animation-delay="0.0" data-animation-duration="1" fr-original-style="" style="box-sizing: border-box;"><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Course Content</span></h3><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Introduction to Electronics: &ndash; Electric Current, OHMS Law, Insulation, Conduction and related Formulae. Resistor colour codes.</li><li fr-original-style="" style="box-sizing: border-box;">Practical study of Digital I.C.s including AND, NAND, OR, NOR, X-OR, X-NOR, Inverter, Buffer, SR Latches and D-Latches and Flip-Flops.</li><li fr-original-style="" style="box-sizing: border-box;">Oscillators, Multivibrators and 555 Timers. Switches and Switch De-bounce circuits and their applications.</li><li fr-original-style="" style="box-sizing: border-box;">Numbering systems, TTL and CMOS technologies</li><li fr-original-style="" style="box-sizing: border-box;">Counters, Counter Decoding Circuitry, Shift Registers</li><li fr-original-style="" style="box-sizing: border-box;">A-D and D-A converters</li><li fr-original-style="" style="box-sizing: border-box;">Digital Displays: &ndash; LED and LCD, numeric and alphanumeric, operating currents, voltages and power requirements. Display decoders and drivers.</li><li fr-original-style="" style="box-sizing: border-box;">Test Equipment: &ndash; Practical use of Analogue and Digital Multimeters, Oscilloscopes, Logic probes, Logic Pulsers, etc.</li><li fr-original-style="" style="box-sizing: border-box;">Fault-finding techniques: &ndash; Diagnosing and rectifying faults on circuits built during course.</li><li fr-original-style="" style="box-sizing: border-box;">Health &amp; Safety, Care of Tools and instruments for assembly and repair</li></ul></div></div></div></div></div><div data-node="61657d76a40d3" style="color: rgb(117, 117, 117); box-sizing: border-box;" fr-original-style=" color: rgb(117, 117, 117);"><div data-node="61657d76a40d4" fr-original-style="" style="box-sizing: border-box;"><div data-node="61657d76a40d5" fr-original-style="" style="box-sizing: border-box;"><div data-node="61657d76a40d6" data-animation-delay="0.0" data-animation-duration="1" fr-original-style="" style="box-sizing: border-box;"><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Certification</span></h3><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">City &amp; Guilds of London Institute Digital Electronics 2 (Examination No. 7267-425). This examination consists of 1 written paper and 4 practical assignments. The qualification can be used as part of the requirement for <a title="City & Guilds Diploma in IT Systems Support" href="http://hitechtraining.ie/city-guilds-certification/" style="color: rgb(209, 33, 56); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(209, 33, 56);">City &amp; Guilds Diploma in IT Systems Support (7267-24).</a></li><li fr-original-style="" style="box-sizing: border-box;">On completion of the Course, having been successful in an examination, the participant will receive a Hi-Tech Training Certificate.</li></ul></div></div><div data-node="61657d76a40d8" data-animation-delay="0" data-animation-duration="1" fr-original-style="" style="box-sizing: border-box;"><img width="794" height="602" src="http://hitechtraining.ie/wp-content/uploads/2022/02/Hi-Tech-City-Guilds-Diploma-in-IT-Systems-Support-7267-24.png" alt="Hi Tech - City & Guilds Diploma in IT Systems Support (7267-24)" itemprop="image" srcset="https://hitechtraining.ie/wp-content/uploads/2022/02/Hi-Tech-City-Guilds-Diploma-in-IT-Systems-Support-7267-24.png 794w, https://hitechtraining.ie/wp-content/uploads/2022/02/Hi-Tech-City-Guilds-Diploma-in-IT-Systems-Support-7267-24-300x227.png 300w, https://hitechtraining.ie/wp-content/uploads/2022/02/Hi-Tech-City-Guilds-Diploma-in-IT-Systems-Support-7267-24-768x582.png 768w, https://hitechtraining.ie/wp-content/uploads/2022/02/Hi-Tech-City-Guilds-Diploma-in-IT-Systems-Support-7267-24-600x455.png 600w, https://hitechtraining.ie/wp-content/uploads/2022/02/Hi-Tech-City-Guilds-Diploma-in-IT-Systems-Support-7267-24-64x49.png 64w" sizes="(max-width: 794px) 100vw, 794px" title="Hi Tech - City & Guilds Diploma in IT Systems Support (7267-24)" fr-original-style="" style="cursor: pointer; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" fr-original-class="fr-draggable"></div></div></div></div></div></div></div></div></div></div></div></div><div data-node="61658ba442ce7" style="color: rgb(117, 117, 117); box-sizing: border-box;" fr-original-style=" color: rgb(117, 117, 117);"><div data-node="61658ba442ce8" fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div></div>

Hi-Tech Training

City & Guilds

Electronics

Digital Design

Electrical Engineering

Analog Electronics

Computer Engineering

Digital Skills

Online Education

This Digital Electronics Course is designed to give practical knowledge of the type of electronic circuitry used in a modern Computer System or in any type of Computer Controlled equipment such as Photocopiers, Cash Registers, Tablets, mobile phones and many other types of IT equipment. 

Digital Electronics involves the use of Silicon chips (Integrated Circuits). The internal structure of a computer is to a large extent comprised of Digital Electronic Circuits.

Digital Electronics Course Online

Deposit Only

Full Price (including Deposit)

<h3 style="color: rgb(55, 55, 55); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(55, 55, 55);">Audience</h3><p style="color: rgb(55, 55, 55); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(55, 55, 55);">This is an intermediate course for system and database administrators, application developers, and other individuals who need a technical introduction to selected new features of Db2 13 for z/OS.</p><h3 style="color: rgb(55, 55, 55); box-sizing: border-box;" fr-original-style=" color: rgb(55, 55, 55);">Prerequisites</h3><div style="color: rgb(55, 55, 55); box-sizing: border-box;" fr-original-style=" color: rgb(55, 55, 55);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">You should have practical experience with Db2 for z/OS</p></div><h3 style="color: rgb(55, 55, 55); box-sizing: border-box;" fr-original-style=" color: rgb(55, 55, 55);">Duration</h3><p style="color: rgb(55, 55, 55); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(55, 55, 55);">2 days.&nbsp;</p><h3 style="color: rgb(55, 55, 55); box-sizing: border-box;" fr-original-style=" color: rgb(55, 55, 55);">Course Objectives</h3><p style="color: rgb(55, 55, 55); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(55, 55, 55);">Learn about the new features and enhancements of Db2 for z/OS (v13), including the technical detail of the functional enhancements of this significant new version of Db2 for z/OS.</p><h3 style="color: rgb(55, 55, 55); box-sizing: border-box;" fr-original-style=" color: rgb(55, 55, 55);">Course Content</h3><ul style="color: rgb(55, 55, 55); box-sizing: border-box;" fr-original-style=" color: rgb(55, 55, 55);"><li fr-original-style="" style="box-sizing: border-box;">Unit 1: Db2 v12 Function Levels: Selected Highlights</li><li fr-original-style="" style="box-sizing: border-box;">Unit 2: Migrating to Db2 13</li><li fr-original-style="" style="box-sizing: border-box;">Unit 3: Availability &amp; Scalability</li><li fr-original-style="" style="box-sizing: border-box;">Unit 4: Performance</li><li fr-original-style="" style="box-sizing: border-box;">Unit 5: Application Management and SQL Changes</li><li fr-original-style="" style="box-sizing: border-box;">Unit 6: SQL Data Insights</li><li fr-original-style="" style="box-sizing: border-box;">Unit 7: Security</li><li fr-original-style="" style="box-sizing: border-box;">Unit 8: IBM Db2 Utilities</li><li fr-original-style="" style="box-sizing: border-box;">Unit 9: Instrumentation and Serviceability</li></ul>

Verhoef Training Ltd.

New Db2 13 Functions and Features - CV321G

Early bird

Book your place early to get an extra discount!

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></strong></strong></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Real Estate Analyst</strong></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The Real Estate Analyst course has been taught non-stop to global real estate firms over the last 25 years, and is without doubt the core financial modelling training in your career portfolio. Whether you have an upcoming financial modelling test for a new job or an APC exam, the Real Estate Analyst course is the choice for you.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Create flexible real estate investment focused financial models in Excel. Case studies focus on core, core plus and value add property investments. This course shows you how to model income producing property with both annual and quarterly discounted cash flows, build rent functions, model costs and calculate returns. It also shows you how to interpret and analyse the results.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">On this course, you will&hellip;</strong></strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Learn how to structure an investment cash flow from first principles and how to value and appraise property investments</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Build annual and quarterly discounted cash flows</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Look in depth at modelling tenancy schedules: rent reviews, upward-only, break options, lease expiry</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Build OPEX and CAPEX into your cash flow</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Analyse risk using sensitivity tables and charts</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Employ best practice and find solutions to common modelling problems</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who will benefit from this course?</strong></strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Real Estate Investors</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Surveyors</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Portfolio Analysts</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Investment Managers</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Asset Managers</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Real Estate professionals at any level with exposure to real estate financial models on a frequent basis</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Mid-level to senior Real Estate Analysts who would like to start building their own real estate models quickly, rather than relying solely on coaching from existing team members</li><li value="8" fr-original-style="" style="box-sizing: border-box;">Junior or new Real Estate Analysts who would like to start building their own real estate models quickly, rather than relying solely on coaching from existing team members</li><li value="9" fr-original-style="" style="box-sizing: border-box;">APC candidates who would like the opportunity to consolidate their competencies by understanding how theory and variables interact within the precision context of a financial model.</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Day One</strong></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Know how to build a property asset cash flow, analyse geared, and un-geared IRRs.</p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Term &amp; Reversion and Layer Method Valuation (Intro to Excel)</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Equivalent Yield (Solver, Scenario and Goal Seek functions)</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Single-Let Discounted Cash Flow</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Cash Flow inputs (Rents, Yields, Growth Rates, Target Returns)</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Analysis and use of date series</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Internal Rate of Return (IRR) and Net Present Value (NPV)</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Comparing Value, Price and Worth</li><li value="8" fr-original-style="" style="box-sizing: border-box;">Adding borrowing and analysing geared returns</li><li value="9" fr-original-style="" style="box-sizing: border-box;">Introducing Rent Reviews and other &lsquo;events&rsquo; into cash flows</li><li value="10" fr-original-style="" style="box-sizing: border-box;">The &lsquo;Rent Function&rsquo; concept and Logic functions (IF,OR,AND)</li><li value="11" fr-original-style="" style="box-sizing: border-box;">Sensitivity analysis</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Day Two</strong></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Know how to build a multi-let property cash flow and apply the concepts on a hypothetical case study.</p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">The &lsquo;Rent Function&rsquo; and Multi-let cash flows</li><li value="2" fr-original-style="" style="box-sizing: border-box;">The &lsquo;date problem&rsquo; and assumptions in property asset cash flows</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Reducing the rent function, intermediate calculations and modelling theory</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Modelling lease expiries, break clauses, voids, and upward only covenants</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Incorporating time-varying rental growth rates</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Analysing multi-let cash flows to see if the leases are sufficiently diversified</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Further IRR analysis (XIRR, MIRR)</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Included in the Course</strong></strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">CPD Accredited Certificate &amp; LinkedIn Proficiency Badge</li><li value="2" id="isPasted" fr-original-style="" style="box-sizing: border-box;">Course Manual - In-Person Course attendees will receive a Physical Copy, Virtual Course attendees will receive a Virtual Copy and have the option to purchase a Hard Copy at an additional fee</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Course Files</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Post Course Support - Two Months of Questions &amp; Answers, and One year of support is available for an additional fee</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">For more information about the Real Estate Analyst such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:</p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">E - s.musgrave@bayfieldtraining.com</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">T - 01223 517851</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">W - <a href="https://www.bayfieldtraining.com/" target="_blank" rel="nofollow noopener noreferrer ugc" title="https://www.bayfieldtraining.com/" data-airgap-id="125" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">www.bayfieldtraining.com</a></p>



Real Estate Analyst
The Real Estate Analyst course has been taught non-stop to global real estate firms over the last 25 years, and is without doubt the core financial modelling training in your career portfolio. Whether you have an upcoming financial modelling test for a new job or an APC exam, the Real Estate Analyst course is the choice for you.
Create flexible real estate investment focused financial models in Excel. Case studies focus on core, core plus and value add property investments. This course shows you how to model income producing property with both annual and quarterly discounted cash flows, build rent functions, model costs and calculate returns. It also shows you how to interpret and analyse the results.


On this course, you will…
Learn how to structure an investment cash flow from first principles and how to value and appraise property investments
Build annual and quarterly discounted cash flows
Look in depth at modelling tenancy schedules: rent reviews, upward-only, break options, lease expiry
Build OPEX and CAPEX into your cash flow
Analyse risk using sensitivity tables and charts
Employ best practice and find solutions to common modelling problems


Who will benefit from this course?
Real Estate Investors
Surveyors
Portfolio Analysts
Investment Managers
Asset Managers
Real Estate professionals at any level with exposure to real estate financial models on a frequent basis
Mid-level to senior Real Estate Analysts who would like to start building their own real estate models quickly, rather than relying solely on coaching from existing team members
Junior or new Real Estate Analysts who would like to start building their own real estate models quickly, rather than relying solely on coaching from existing team members
APC candidates who would like the opportunity to consolidate their competencies by understanding how theory and variables interact within the precision context of a financial model.


Day One
Know how to build a property asset cash flow, analyse geared, and un-geared IRRs.
Term & Reversion and Layer Method Valuation (Intro to Excel)
Equivalent Yield (Solver, Scenario and Goal Seek functions)
Single-Let Discounted Cash Flow
Cash Flow inputs (Rents, Yields, Growth Rates, Target Returns)
Analysis and use of date series
Internal Rate of Return (IRR) and Net Present Value (NPV)
Comparing Value, Price and Worth
Adding borrowing and analysing geared returns
Introducing Rent Reviews and other ‘events’ into cash flows
The ‘Rent Function’ concept and Logic functions (IF,OR,AND)
Sensitivity analysis


Day Two
Know how to build a multi-let property cash flow and apply the concepts on a hypothetical case study.
The ‘Rent Function’ and Multi-let cash flows
The ‘date problem’ and assumptions in property asset cash flows
Reducing the rent function, intermediate calculations and modelling theory
Modelling lease expiries, break clauses, voids, and upward only covenants
Incorporating time-varying rental growth rates
Analysing multi-let cash flows to see if the leases are sufficiently diversified
Further IRR analysis (XIRR, MIRR)


Included in the Course
CPD Accredited Certificate & LinkedIn Proficiency Badge
Course Manual - In-Person Course attendees will receive a Physical Copy, Virtual Course attendees will receive a Virtual Copy and have the option to purchase a Hard Copy at an additional fee
Course Files
Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)
Post Course Support - Two Months of Questions & Answers, and One year of support is available for an additional fee


For more information about the Real Estate Analyst such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:
E - s.musgrave@bayfieldtraining.com
T - 01223 517851
W - www.bayfieldtraining.com

Bayfield Training

Financial Modelling & Analysis

Financial Modelling

Professional Development

Property & Real Estate Photography

Continuous Professional Development (CPD)

The Real Estate Analyst course has been taught non-stop to global real estate firms over the last 25 years, and is without doubt the core financial modelling training in your career portfolio. Whether you have an upcoming financial modelling test for a new job or an APC exam, the Real Estate Analyst course is the choice for you.

Real Estate Analyst (Investment Cash Flow Modelling in Excel)

In-Person 

Virtual

Tom Reynolds

Product Management

Agile

Agile PM

Productivity

Kanban

Agile Coach

Attend our world class Kanban University accredited Certified Kanban System Design training course and learn to implement Kanban in your company

Certified Kanban System Design – KMP I - 24-26 September

Standard

Early Bird

<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>

Online Course Creation

Microsoft Power Apps

Microsoft Sharepoint

Power Apps

Microsoft Power Platform

SharePoint

55215 SharePoint Online Power User

<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

Microsoft Power Automate

Excel - Automating Excel with Macros and Analysis Tools

Chesterfield

<h2 id="isPasted" fr-original-style="" style="box-sizing: border-box;">QA Level 2 Award In Principles Of Risk Assessment (RQF)</h2><ul fr-original-style="" style="box-sizing: border-box;"><li id="isPasted" fr-original-style="" style="box-sizing: border-box;">Face to Face: One-day course</li><li fr-original-style="" style="box-sizing: border-box;">Virtual Classroom: Spread over 3 sessions of 2&frac12; hr duration</li><li fr-original-style="" style="box-sizing: border-box;">Don&#39;t run risks with the safety of your people - it will cost you a lot more when things start to go wrong...</li><li fr-original-style="" style="box-sizing: border-box;">Risk Assessments are vital for Health and Safety, and vital for the whole process</li></ul><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Contents:</strong><ul id="isPasted" fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Main causes of Work-related Fatalities, Injuries and ill health</li><li fr-original-style="" style="box-sizing: border-box;">Moral, Legal and Economic Reasons for Preventing Accidents and ill health at Work</li><li fr-original-style="" style="box-sizing: border-box;">Key Terms associated with Risk Assessments in Health and Safety at Work:<ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Accident</li><li fr-original-style="" style="box-sizing: border-box;">Near Miss</li><li fr-original-style="" style="box-sizing: border-box;">Accident Triangle</li><li fr-original-style="" style="box-sizing: border-box;">Hazard</li><li fr-original-style="" style="box-sizing: border-box;">Risk</li><li fr-original-style="" style="box-sizing: border-box;">Risk Assessment</li><li fr-original-style="" style="box-sizing: border-box;">Suitable and Sufficient</li><li fr-original-style="" style="box-sizing: border-box;">Competence</li></ul></li><li fr-original-style="" style="box-sizing: border-box;">The Role of Risk Assessments in Accident and ill Health Prevention</li><li fr-original-style="" style="box-sizing: border-box;">Legal Requirements for Risk Assessments</li><li fr-original-style="" style="box-sizing: border-box;">Importance of Personal hygiene</li><li fr-original-style="" style="box-sizing: border-box;">Basic Process for Undertaking a Risk Assessment</li><li fr-original-style="" style="box-sizing: border-box;">The Five Steps of a Risk Assessment</li></ul><h3 data-css="tve-u-1724b5d034d" id="isPasted" style="color: rgb(34, 34, 34) !important; box-sizing: border-box;" fr-original-style=" color: rgb(34, 34, 34) !important;">Benefits of this course:</h3><ul fr-original-style="" style="box-sizing: border-box;"><li id="isPasted" fr-original-style="" style="box-sizing: border-box;">In 2020/21, a whopping 1.7 million people suffered from a work-related illness</li><li fr-original-style="" style="box-sizing: border-box;">441,000 of those sustained an injury</li><li fr-original-style="" style="box-sizing: border-box;">142 People, plus 60 members of the public, lost their lives...</li><li fr-original-style="" style="box-sizing: border-box;">The estimated cost of injuries and ill health was &pound;15 billion</li><li fr-original-style="" style="box-sizing: border-box;">28.2 million working days, or 108,045 working years, were lost due to work-related illnesses and injuries</li><li fr-original-style="" style="box-sizing: border-box;">It is an employer&#39;s duty to protect the health, safety and welfare of their employees and other people who might be affected by their business. This includes providing sufficient information, instruction and training of employees, so they can work in a way that does not put themselves or others at risk</li><li fr-original-style="" style="box-sizing: border-box;">Our QA Level 2 Award in Principles of Risk Assessment (RQF) course is ideal for all employees, helping them to create a better understanding of health and safety issues and risk assessments</li></ul><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><h3 fr-original-style="" style="box-sizing: border-box;">Accredited, Ofqual regulated qualification:</h3><div fr-original-style="" style="box-sizing: border-box;"><img src="https://images.cademy.co.uk/pochat-training/d4bd1328-0561-4a59-aef0-01af2e9666f7/original.png" style="width: 300px; display: inline-block; vertical-align: bottom; margin: 5px 5px 5px 0px; text-align: left; max-width: calc(100% - 5px); float: left; cursor: pointer; padding: 0px 1px; user-select: none; position: relative; box-sizing: border-box;" fr-original-style="width: 300px; display: inline-block; vertical-align: bottom; margin: 5px 5px 5px 0px; text-align: left; max-width: calc(100% - 5px); float: left;" fr-original-class="fr-draggable"><span id="isPasted" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">QA Level 2 Award in Principles of Risk Assessment (RQF) training course is a nationally recognised, Ofqual regulated qualification accredited by&nbsp;</span><a href="https://qualsafeawards.org/" style="color: rgb(34, 177, 77); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" target="_blank" fr-original-style=" color: rgb(34, 177, 77);">Qualsafe Awards</a><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">.</span><br style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><br style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">This means that you can be rest assured that your Principles of Risk Assessment certificate fulfils the legal requirements and is a very good way to make sure you and your employees are trained appropriately.</span><br style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><br style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">The&nbsp;</span><strong style="color: rgb(0, 0, 0); font-weight: 700; box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Ofqual Register number</strong><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">&nbsp;for this course is&nbsp;</span><strong style="color: rgb(0, 0, 0); font-weight: 700; box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">603/0857/9</strong></div><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p>

QA Level 2 Award In Principles Of Risk Assessment (RQF)
Face to Face: One-day course
Virtual Classroom: Spread over 3 sessions of 2½ hr duration
Don't run risks with the safety of your people - it will cost you a lot more when things start to go wrong...
Risk Assessments are vital for Health and Safety, and vital for the whole process



Course Contents:
Main causes of Work-related Fatalities, Injuries and ill health
Moral, Legal and Economic Reasons for Preventing Accidents and ill health at Work
Key Terms associated with Risk Assessments in Health and Safety at Work:AccidentNear MissAccident TriangleHazardRiskRisk AssessmentSuitable and SufficientCompetence
The Role of Risk Assessments in Accident and ill Health Prevention
Legal Requirements for Risk Assessments
Importance of Personal hygiene
Basic Process for Undertaking a Risk Assessment
The Five Steps of a Risk Assessment
Benefits of this course:
In 2020/21, a whopping 1.7 million people suffered from a work-related illness
441,000 of those sustained an injury
142 People, plus 60 members of the public, lost their lives...
The estimated cost of injuries and ill health was £15 billion
28.2 million working days, or 108,045 working years, were lost due to work-related illnesses and injuries
It is an employer's duty to protect the health, safety and welfare of their employees and other people who might be affected by their business. This includes providing sufficient information, instruction and training of employees, so they can work in a way that does not put themselves or others at risk
Our QA Level 2 Award in Principles of Risk Assessment (RQF) course is ideal for all employees, helping them to create a better understanding of health and safety issues and risk assessments



Accredited, Ofqual regulated qualification:

QA Level 2 Award in Principles of Risk Assessment (RQF) training course is a nationally recognised, Ofqual regulated qualification accredited by Qualsafe Awards.This means that you can be rest assured that your Principles of Risk Assessment certificate fulfils the legal requirements and is a very good way to make sure you and your employees are trained appropriately.The Ofqual Register number for this course is 603/0857/9



Pochat Training

Risk Assessment

Principles of Risk Assessment

<h2 id="isPasted" fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></h2><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This advanced financial modelling course will benefit Real Estate Professionals looking to develop their financial modelling skills to the next level. This course is intended to the most ambitious modellers in the property industry who would like to be fully proficient in building complex real estate models.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">On this course you will...</strong></strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Understand how the application and use of Structured Finance products in Real Estate</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Learn how to introduce several tranches of debt in a development project</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Understand how to model different parties to a project</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Create Joint Venture structures between Developers, Lenders and Equity Partners</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Learn advanced modelling techniques to analyse underlying asset risk</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Understand how underlying asset risk impacts return to all parties to a project</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who will benefit from this course?</strong></strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Real Estate professionals from a mid to senior level with exposure to Real Estate financial models</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Mid-level to senior Real Estate Analysts who would like to advance their financial modelling skills in areas such as development, portfolio analysis, and risk analysis</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Real Estate Investors who would like to expand their knowledge and understanding of Real Estate cash flow models to an advanced level</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Outline</strong></strong>:</p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Mezzanine debt modelling</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Joint Venture structures between developers and lender/equity partners</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Promote and profit share structure calculations</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Advanced project cash flows with mezzanine debts</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Key Real Estate and investment risks, risk adjustment of exit yields</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Sensitivity and Scenario Analysis</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Monte Carlo Analysis</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Included in the Course</strong></strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">CPD Accredited Certificate &amp; LinkedIn Proficiency Badge</li><li value="2" id="isPasted" fr-original-style="" style="box-sizing: border-box;">Course Manual - In-Person Course attendees will receive a Physical Copy, Virtual Course attendees will receive a Virtual Copy and have the option to purchase a Hard Copy at an additional fee</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Course Files</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Post Course Support - Two Months of Questions &amp; Answers, and One year of support is available for an additional fee</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">For more information about the Real Estate Modelling Masterclass such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">E - s.musgrave@bayfieldtraining.com</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">T - 01223 517851</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">W - <a href="https://www.bayfieldtraining.com/" target="_blank" rel="nofollow noopener noreferrer ugc" title="https://www.bayfieldtraining.com/" data-airgap-id="125" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">www.bayfieldtraining.com</a></p>



This advanced financial modelling course will benefit Real Estate Professionals looking to develop their financial modelling skills to the next level. This course is intended to the most ambitious modellers in the property industry who would like to be fully proficient in building complex real estate models.


On this course you will...
Understand how the application and use of Structured Finance products in Real Estate
Learn how to introduce several tranches of debt in a development project
Understand how to model different parties to a project
Create Joint Venture structures between Developers, Lenders and Equity Partners
Learn advanced modelling techniques to analyse underlying asset risk
Understand how underlying asset risk impacts return to all parties to a project


Who will benefit from this course?
Real Estate professionals from a mid to senior level with exposure to Real Estate financial models
Mid-level to senior Real Estate Analysts who would like to advance their financial modelling skills in areas such as development, portfolio analysis, and risk analysis
Real Estate Investors who would like to expand their knowledge and understanding of Real Estate cash flow models to an advanced level


Course Outline:
Mezzanine debt modelling
Joint Venture structures between developers and lender/equity partners
Promote and profit share structure calculations
Advanced project cash flows with mezzanine debts
Key Real Estate and investment risks, risk adjustment of exit yields
Sensitivity and Scenario Analysis
Monte Carlo Analysis


Included in the Course
CPD Accredited Certificate & LinkedIn Proficiency Badge
Course Manual - In-Person Course attendees will receive a Physical Copy, Virtual Course attendees will receive a Virtual Copy and have the option to purchase a Hard Copy at an additional fee
Course Files
Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)
Post Course Support - Two Months of Questions & Answers, and One year of support is available for an additional fee


For more information about the Real Estate Modelling Masterclass such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:
E - s.musgrave@bayfieldtraining.com
T - 01223 517851
W - www.bayfieldtraining.com

Real Estate Finance

Investment Management

This course is intended to the most ambitious modellers in the property industry who would like to be fully proficient in building complex real estate models.

6862 Courses

EDB358 SAP System and Database Administration - Adaptive Server Enterprise

By Nexus Human

Introduction to SAP Business Technology Platform (BTP) Administration

By Nexus Human

SAPEP SAP Enterprise Portal - Fundamentals

By Nexus Human

SCM250 SAP Production Planning in SAP APO

By Nexus Human

SAP System Security Fundamentals

By Nexus Human

SAP Real-time Replication with SAP LT Replication Server (SLT100)

By Nexus Human

SAPTEC Technology Fundamentals for SAP S/4HANA and SAP Business Suite

By Nexus Human

Oracle PeopleSoft Payroll - US Rel 9.2

By Nexus Human

UD120 - Universal Discovery 10.x Essentials

By Nexus Human

Mastering SQL Programming Course

By NextGen Learning

Search By Location