Name: CompTIA A+ (220-1002) Course
Price: 20 GBP
Availability: InStock

<div>
						<div>
							<div>
							<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>Overview
</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p>Mastering data science skills and expertise can open new doors of opportunities for you in a wide range of fields. Learn the fundamentals and develop a solid grasp of Python data science with the comprehensive Data Science with Python course. This course is designed to assist you in securing a valuable skill set and boosting your career.</p><p>This course will provide you with quality training on the fundamentals of data analysis with Python. From the step-by-step learning process, you will learn the techniques of setting up the system. Then the course will teach you Python data structure and functions. You will receive detailed lessons on NumPy, Matplotlib, and Pandas. Furthermore, you will develop the skills for Algorithm Evaluation Techniques, visualising datasets and much more.</p><p>After completing the course you will receive a certificate of achievement. This certificate will help you create an impressive resume. So join today!</p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
								</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>How will I get my certificate?</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate.</span></p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Who is This course for?</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p>This course Data Science with Python course is ideal for beginners in data science. It will help them develop a solid grasp of Python and help them pursue their dream career in the field of data science.</p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Requirements</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p>The students will not require any formal qualifications or previous experience to enrol in this course. Anyone can learn from the course anytime from anywhere through smart devices like laptops, tabs, PC, and smartphones with stable internet connections. They can complete the course according to their preferable pace so, there is no need to rush.</p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Career Path</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p>This course will equip you with valuable knowledge and effective skills in this area. After completing the course, you will be able to explore career opportunities in the fields such as</p><ul><li>Data Analyst </li><li>Data Scientist </li><li>Data Manager </li><li>Business Analyst</li></ul><p>And much more!</p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
						</div>
						</div>
					</div> <h3>Course Curriculum</h3><div><p>90 sections • 90 lectures • 10:19:00 total length</p></div><div><div><div><div><div><div><div><p>•Course Overview &amp; Table of Contents: 00:09:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Introduction to Machine Learning - Part 1 - Concepts , Definitions and Types: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Introduction to Machine Learning - Part 2 - Classifications and Applications: 00:06:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•System and Environment preparation - Part 1: 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•System and Environment preparation - Part 2: 00:06:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Learn Basics of python - Assignment 1: 00:10:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Learn Basics of python - Assignment 2: 00:09:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Learn Basics of python - Functions: 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Learn Basics of python - Data Structures: 00:12:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Learn Basics of NumPy - NumPy Array: 00:06:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Learn Basics of NumPy - NumPy Data: 00:08:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Learn Basics of NumPy - NumPy Arithmetic: 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Learn Basics of Matplotlib: 00:07:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Learn Basics of Pandas - Part 1: 00:06:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Learn Basics of Pandas - Part 2: 00:07:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Understanding the CSV data file: 00:09:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Load and Read CSV data file using Python Standard Library: 00:09:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Load and Read CSV data file using NumPy: 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Load and Read CSV data file using Pandas: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Dataset Summary - Peek, Dimensions and Data Types: 00:09:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Dataset Summary - Class Distribution and Data Summary: 00:09:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Dataset Summary - Explaining Correlation: 00:11:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Dataset Summary - Explaining Skewness - Gaussian and Normal Curve: 00:07:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Dataset Visualization - Using Histograms: 00:07:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Dataset Visualization - Using Density Plots: 00:06:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Dataset Visualization - Box and Whisker Plots: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Multivariate Dataset Visualization - Correlation Plots: 00:08:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Multivariate Dataset Visualization - Scatter Plots: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Data Preparation (Pre-Processing) - Introduction: 00:09:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Data Preparation - Re-scaling Data - Part 1: 00:09:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Data Preparation - Re-scaling Data - Part 2: 00:09:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Data Preparation - Standardizing Data - Part 1: 00:07:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Data Preparation - Standardizing Data - Part 2: 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Data Preparation - Normalizing Data: 00:08:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Data Preparation - Binarizing Data: 00:06:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Feature Selection - Introduction: 00:07:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Feature Selection - Uni-variate Part 1 - Chi-Squared Test: 00:09:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Feature Selection - Uni-variate Part 2 - Chi-Squared Test: 00:10:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Feature Selection - Recursive Feature Elimination: 00:11:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Feature Selection - Principal Component Analysis (PCA): 00:09:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Feature Selection - Feature Importance: 00:06:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Refresher Session - The Mechanism of Re-sampling, Training and Testing: 00:12:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Algorithm Evaluation Techniques - Introduction: 00:07:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Algorithm Evaluation Techniques - Train and Test Set: 00:11:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Algorithm Evaluation Techniques - K-Fold Cross Validation: 00:09:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Algorithm Evaluation Techniques - Leave One Out Cross Validation: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Algorithm Evaluation Techniques - Repeated Random Test-Train Splits: 00:07:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Algorithm Evaluation Metrics - Introduction: 00:09:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Algorithm Evaluation Metrics - Classification Accuracy: 00:08:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Algorithm Evaluation Metrics - Log Loss: 00:03:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Algorithm Evaluation Metrics - Area Under ROC Curve: 00:06:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Algorithm Evaluation Metrics - Confusion Matrix: 00:10:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Algorithm Evaluation Metrics - Classification Report: 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Algorithm Evaluation Metrics - Mean Absolute Error - Dataset Introduction: 00:06:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Algorithm Evaluation Metrics - Mean Absolute Error: 00:07:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Algorithm Evaluation Metrics - Mean Square Error: 00:03:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Algorithm Evaluation Metrics - R Squared: 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Classification Algorithm Spot Check - Logistic Regression: 00:12:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Classification Algorithm Spot Check - Linear Discriminant Analysis: 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Classification Algorithm Spot Check - K-Nearest Neighbors: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Classification Algorithm Spot Check - Naive Bayes: 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Classification Algorithm Spot Check - CART: 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Classification Algorithm Spot Check - Support Vector Machines: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Regression Algorithm Spot Check - Linear Regression: 00:08:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Regression Algorithm Spot Check - Ridge Regression: 00:03:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Regression Algorithm Spot Check - Lasso Linear Regression: 00:03:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Regression Algorithm Spot Check - Elastic Net Regression: 00:02:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Regression Algorithm Spot Check - K-Nearest Neighbors: 00:06:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Regression Algorithm Spot Check - CART: 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Regression Algorithm Spot Check - Support Vector Machines (SVM): 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Compare Algorithms - Part 1 : Choosing the best Machine Learning Model: 00:09:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Compare Algorithms - Part 2 : Choosing the best Machine Learning Model: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Pipelines : Data Preparation and Data Modelling: 00:11:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Pipelines : Feature Selection and Data Modelling: 00:10:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Performance Improvement: Ensembles - Voting: 00:07:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Performance Improvement: Ensembles - Bagging: 00:08:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Performance Improvement: Ensembles - Boosting: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Performance Improvement: Parameter Tuning using Grid Search: 00:08:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Performance Improvement: Parameter Tuning using Random Search: 00:06:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Export, Save and Load Machine Learning Models : Pickle: 00:10:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Export, Save and Load Machine Learning Models : Joblib: 00:06:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Finalizing a Model - Introduction and Steps: 00:07:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Finalizing a Classification Model - The Pima Indian Diabetes Dataset: 00:07:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Quick Session: Imbalanced Data Set - Issue Overview and Steps: 00:09:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Iris Dataset : Finalizing Multi-Class Dataset: 00:09:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Finalizing a Regression Model - The Boston Housing Price Dataset: 00:08:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Real-time Predictions: Using the Pima Indian Diabetes Classification Model: 00:07:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Real-time Predictions: Using Iris Flowers Multi-Class Classification Dataset: 00:03:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Real-time Predictions: Using the Boston Housing Regression Model: 00:08:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Resources - Data Science &amp; Machine Learning with Python: 00:00:00</p></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>

Apex Learning

Computing Skills

Data Engineering

Big Data Analytics

Data Science

Data Skills

Data Science with Python

General Admission

Packt

Java

Programming

Complete Java SE 8 Developer Bootcamp

<div id="course-pills-1">Duration<p>4 Days</p><p>24 CPD hours</p>This course is intended for<p>This course is appropriate for anyone who wants to create applications or modules to automate and simplify common tasks with Perl.</p>Overview<p>Working within in an engaging, hands-on learning environment, guided by our expert web development, PHP practitioner, students will learn to:<br />Create a working script that gets input from the command line, the keyboard, or a file<br />Use arrays to store and process data from files<br />Create formatted reports<br />Use regular expressions<br />Use the appropriate types of variables and data structures<br />Refactor duplicate code into subroutines and modules<br />What is available in the standard library<br />Use shortcuts and defaults, and what they replace</p><p>Introduction to Perl Programming Essentials is an Introductory-level practical, hands-on Perl scripting training course that guides the students from the basics of writing and running Perl scripts to using more advanced features such as file operations, report writing, the use of regular expressions, working with binary data files, and using the extensive functionality of the standard Perl library.  Students will immediately be able to use Perl to complete tasks in the real world.</p></div><div id="course-pills-2"><h4>Session: An Overview of Perl</h4><ul><li>What is Perl?</li><li>Perl is compiled and interpreted</li><li>Perl Advantages and Disadvantages</li><li>Downloading and Installing Perl</li><li>Which version of Perl</li><li>Getting Help</li></ul><h4>Session: Creating and running Perl Programs</h4><ul><li>Structure of a Perl program</li><li>Running a Perl script</li><li>Checking syntax and warnings</li><li>Execution of scripts under Unix and Windows</li></ul><h4>Session: Basic Data and I/O</h4><ul><li>Numeric and Text literals</li><li>Math operators and expressions</li><li>Scalar variables</li><li>Default values</li><li>Writing to standard output</li><li>Command line arguments</li><li>Reading from the standard input</li></ul><h4>Session: Logic and Loops</h4><ul><li>About flow control</li><li>The if statement and Boolean values</li><li>Using unless and elsif</li><li>Statement modifiers</li><li>warn() and die()</li><li>The conditional construct</li><li>Using while loop and its variants</li><li>Using the for loop</li><li>Exiting from loops</li></ul><h4>Session: Lists and Arrays</h4><ul><li>The list data type</li><li>Accessing array elements</li><li>Creating arrays</li><li>List interpolation</li><li>Arrays and memory</li><li>Counting elements</li><li>Iterating through an array</li><li>List evaluation</li><li>Slices and ranges</li></ul><h4>Session: Reading and writing text files</h4><ul><li>File I/O Overview</li><li>Opening a file</li><li>Reading text files</li><li>Writing to a text file</li><li>Arrays and file I/O</li><li>Using the &lt;&gt; operator</li></ul><h4>Session: List functions</h4><ul><li>Growing and shrinking arrays</li><li>The split() function</li><li>Splitting on whitespace</li><li>Assigning to literal lists</li><li>The join() function</li><li>The sort() function</li><li>Alternate sort keys</li><li>Reversing an array</li></ul><h4>Session: Formatting output</h4><ul><li>Using sprintf() and printf()</li><li>Report formatting overview</li><li>Defining report formats</li><li>The write() function</li><li>Advanced filehandle magic</li></ul><h4>Session: Hashes</h4><ul><li>Hash overview</li><li>Creating hashes</li><li>Hash attributes</li><li>Traversing a hash</li><li>Testing for existence of elements</li><li>Deleting hash elements</li></ul><h4>Session: References</h4><ul><li>What is a reference?</li><li>The two ways to create references</li><li>References to existing data</li><li>References to anonymous data</li><li>Dereferencing scalar, array, and ash references</li><li>Dereferencing elements of arrays and hashes</li><li>Multidimensional arrays and other data structures</li></ul><h4>Session: Text and Regular Expressions</h4><ul><li>String length</li><li>The substr() function</li><li>The index() and rindex() functions</li><li>String replication</li><li>Pattern matching and substitution</li><li>Regular expressions</li></ul><h4>Session: Raw file and data access</h4><ul><li>Opening and closing raw (binary) files</li><li>Reading raw data</li><li>Using seek() and tell()</li><li>Writing raw data</li><li>Raw data manipulation with pack() and unpack()</li></ul><h4>Session: Subroutines and variable scope</h4><ul><li>Understanding packages</li><li>Package and Lexical variables</li><li>Localizing builtin variables</li><li>Declaring  and calling subroutines</li><li>Calling subroutines</li><li>Passing parameters and returning values</li></ul><h4>Session: Working with the operating system</h4><ul><li>Determining current OS</li><li>Environment variables</li><li>Running external programs</li><li>User identification</li><li>Trapping signals</li><li>File test operators</li><li>Working with files</li><li>Time of day</li></ul><h4>Session: Shortcuts and defaults</h4><ul><li>Understanding $_</li><li>shift() with no array specified</li><li>Text file processing</li><li>Using grep() and Using map()</li><li>Command-line options for  file processing</li></ul><h4>Session: Data wrangling</h4><ul><li>Quoting in Perl</li><li>Evaluating arrays</li><li>Understanding qw( )</li><li>Getting more out of the &lt;&gt; operator</li><li>Read ranges of lines</li><li>Using m//g in scalar context</li><li>The /o modifier</li><li>Working with embedded newlines</li><li>Making REs more readable</li><li>Perl data conversion</li></ul><h4>Session: Using the Perl Library</h4><ul><li>The Perl library</li><li>Old-style library files</li><li>Perl modules</li><li>Modules bundled with Perl</li><li>A selection of modules</li><li>Getting modules from ActiveState</li><li>Getting modules from CPAN</li><li>Using Getopt::Long</li></ul><h4>Session: Some Useful Tools</h4><ul><li>Sending and receiving files with Net::FTP</li><li>Using File::Find to search for files and directories</li><li>Grabbing a Web page</li><li>Some good places to find scripts</li><li>Perl man pages for more information</li><li>Zipping and unzipping files</li></ul></div>

Nexus Human

Programming Fundamentals

Shell Scripting

Computer Programming

Scripting Languages

Perl

Introduction Perl Programming Essentials (TT4925)

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This course is intended for individuals who are Application designers and database developers, database administrators and web server administrators.</p>Overview<p>Upon successful completion of this course, students will be able to work with Oracle database programming using the PL/SQL programming language.  They will learn the syntax, structure and features of the language.</p><p>In this course, students will learn the foundation for the programming series and the use of database-resident stored program units for Oracle 12c.</p></div><div id="course-pills-2"><h4>Selection &amp; Setup of the Database Interface</h4><ul><li>Considering Available Tools</li><li>Selecting the Appropriate Tool</li><li>Oracle Net Database Connections</li><li>Oracle PAAS Database Connections</li><li>Setup SQL Developer</li><li>Setup SQL*Plus</li><li>Setup Jdeveloper</li></ul><h4>About Bind &amp; Substitution Variables</h4><ul><li>Using SQL Developer</li><li>Using SQL*Plus</li></ul><h4>Choosing a Database Programming Language</h4><ul><li>What is Database Programming?</li><li>PL?SQL Performance Advantages</li><li>Integration wth Other Languages</li></ul><h4>PL/SQL Language Fundamentals</h4><ul><li>PL/SQL Program Structure</li><li>LANGUAGE SYNTAX RULES </li><li>EMBEDDING SQL</li><li>WRITING READABLE CODE </li><li>GENERATING DATABASE OUTPUT </li><li>SQL*PLUS INPUT OF A PROGRAM BLOCK</li></ul><h4>Declare Section</h4><ul><li>About the Declare Section</li><li>DECLARE PRIMITIVE TYPES </li><li>DECLARATION OPTIONS </li><li>NOT NULL </li><li>CONSTANT</li><li>DATA DICTIONARY INTEGRATION </li><li>%TYPE</li><li>DECLARE SIMPLE USER---DEFINED TYPES</li><li>TYPE... TABLE </li><li>TYPE... RECORD </li><li>EXTENDED USER---DEFINED TYPES</li></ul><h4>Begin Section</h4><ul><li>About the Begin Section</li><li>Manipulating Program Data</li><li>Logic Control &amp; Branching</li><li>GOTO</li><li>LOOP</li><li>IF-THEN-ELSE</li><li>CASE</li></ul><h4>Exception Section</h4><ul><li>ABOUT THE EXCEPTION SECTION</li><li>ISOLATING THE SPECIFIC EXCEPTION</li><li>PRAGMA EXCEPTION_INIT </li><li>SQLCODE &amp;SQLERRM Example </li><li>SQL%ROWCOUNT &amp;SELECT...INTO</li></ul><h4>Beyond the Basics: Explicit Cursors</h4><ul><li>ABOUT EXPLICIT CURSORS</li><li>EXTENDED CURSOR TECHNIQUES </li><li>FOR UPDATE OF Clause </li><li>WHERE CURRENT OF Clause </li><li>Using FOR?LOOP Cursors</li></ul><h4>Beyond the Basics: Nested Blocks</h4><h4>Beyond the Basics: Declared Subprograms</h4><ul><li>USING DECLARED SUBPROGRAMS</li><li>DECLARED PROCEDURE</li><li>DECLARED FUNCTION</li></ul><h4>Introducing Databse-Resident Program Units</h4><ul><li>ABOUT DATABASE---RESIDENT PROGRAMS</li><li>PHYSICAL STORAGE &amp; EXECUTION </li><li>TYPES OF STORED PROGRAM UNITS</li><li>STORED PROGRAM UNIT ADVANTAGES</li><li>MODULAR DESIGN PRINCIPLES</li></ul><h4>Creating Stored Procedures &amp; Functions</h4><ul><li>STORED PROCEDURES &amp; FUNCTIONS</li><li>CREATE PROCEDURE / CREATE FUNCTION </li><li>CREATING PROCEDURES &amp; FUNCTIONS </li><li>RAISE_SALARY() Procedure </li><li>SALARY_VALID() Function </li><li>THE PARAMETER SPECIFICATION</li><li>DEFAULT Clause </li><li>SYSTEM &amp; OBJECT PRIVILEGES </li><li>USING THE DEVELOPMENT TOOLS</li></ul><h4>Executing Stored Procedures &amp; Functions</h4><ul><li>CALLING PROCEDURES &amp; FUNCTIONS</li><li>UNIT TESTING WITH EXECUTE</li><li>ANONYMOUS BLOCK UNIT TESTING</li><li>SPECIFYING A PARAMETER NOTATION</li><li>SQL WORKSHEET UNIT TESTING</li><li>CALLING FUNCTIONS FROM SQL</li></ul><h4>Maintaining Stored Program Units</h4><ul><li>RECOMPILING PROGRAMS</li><li>Mass Recompilation Using UTL_RECOMP()</li><li>DROPPING PROCEDURES &amp; FUNCTIONS</li><li>DROP PROCEDURE / FUNCTION</li><li>DATA DICTIONARY METADATA </li><li>Using USER_OBJECTS </li><li>Using USER_SOURCE </li><li>Using USER_ERRORS </li><li>Using USER_OBJECT_SIZE </li><li>Using USER_DEPENDENCIES</li></ul><h4>Managing Dependencies</h4><ul><li>DEPENDENCY INTERNALS</li><li>TRACKING DEPENDENCIES</li><li>THE DEPENDENCY TRACKING UTILITY</li><li>SQL DEVELOPER DEPENDENCY INFO</li><li>DEPENDENCY STRATEGY CHECKLISTS</li></ul><h4>Creating &amp; Maintaining Packages</h4><ul><li>ABOUT PACKAGES</li><li>CREATING PACKAGES</li><li>MAINTAINING PACKAGES</li><li>PERFORMANCE CONSIDERATIONS</li></ul><h4>Advanced Package Capabilities</h4><ul><li>DEFINER &amp; INVOKER RIGHTS</li><li>WHITE LITS &amp; ACCESSIBLE BY</li><li>PERSISTENT GLOBAL OBJECTS</li><li>DEFINING INITIALIZATION LOGIC</li><li>OBJECT ORIENTATION SUPPORT</li></ul><h4>Advanced Cursor Techniques</h4><ul><li>USING CUSROS VARIABLES</li><li>USING SYS_REFCURSOR</li><li>USING CURSOR EXPRESSIONS</li></ul><h4>Using System-Supplied Package</h4><ul><li>DBMS_OUTPUT()</li><li>UTL_FILE()</li><li>FOPEN() EXAMPLE</li></ul><h4>Database Trigger Concepts</h4><ul><li>ABOUT DATABASE TRIGGERS</li><li>DML EVENT TRIGGER SUB---TYPES</li><li>DATABASE TRIGGER SCENARIO</li><li>TRIGGER EXECUTION MECHANISMS </li><li>TRIGGERS WITHIN SQL WORKSHEET</li></ul><h4>Creating Database Triggers</h4><ul><li>STATEMENT-LEVEL TRIGGERS</li><li>Using RAISE_APPLICATION_ERROR() </li><li>ROW---LEVEL TRIGGERS</li><li>EXAMPLES OF TRIGGERS </li><li>EMPLOYEE_SALARY_CHECK Example </li><li>EMPLOYEE_JOURNAL Example </li><li>BUDGET_EVENT Example </li><li>INSTEAD OF TRIGGERS</li><li>TRIGGERS WITHIN AN APPLICATION</li></ul><h4>Maintaining Database Triggers</h4><ul><li>CALL SYNTAX</li><li>TRIGGER MAINTENANCE TASKS </li><li>SHOW ERRORS TRIGGER </li><li>DROP TRIGGER</li><li>ALTER TRIGGER</li><li>MULTIPLE TRIGGERS FOR A TABLE </li><li>HANDLING MUTATING TABLE ISSUES</li></ul><h4>Implementing System Event Triggers</h4><ul><li>WHAT ARE SYSTEM EVENT TRIGGERS?</li><li>DEFININGTHE SCOPE</li><li>AVAILABLE SYSTEM EVENTS</li><li>SYSTEM EVENT ATTRIBUTES</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Oracle 12c PL/SQL 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 Oracle 12c PL/SQL 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>

Oracle SQL

Database Programming

Oracle

Oracle 1Z0-819

Oracle Database

Oracle 12c PL/SQL Fundamentals

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>This course is geared for anyone needing to interface with an Oracle database such as end users, business analysts, application developers and database administrators / DBAs.</p>Overview<p>Working within in a hands-on learning environment, guided by our expert team, attendees will develop a practical approach to Oracle Database Technology. Throughout the course participants will explore:<br />Using PL/SQL programming language for database applications and development<br />incorporating PL/SQL modules within the application architecture from the initial design and planning phase<br />The essentials of building executable PL/SQL program units<br />Each of the major segments of a working program and how these interact with each other during program execution<br />Important error or exception handling capabilities of the language.<br />How database-resident program units can be used as part of the overall database application architecture<br />Applying these new skills to the development of PL/SQL packages.<br />Advanced database programming capabilities and benefits<br />How database triggers can be used as part of an advanced database application design</p><p>Oracle 19c PL/SQL Fundamentals is a three-day, hands-on course that introduces Oracle database programming using the PL/SQL programming language. Throughout the course students will explore the core syntax, structure and features of the language.<br />This course will also lay the foundation for the entire Oracle PL/SQL programming series, allowing one to progress from introductory topics to advanced application design and programming and finally onto writing complex high-performance applications. The course also explores applying the newly learned skills to the development of database applications. Participants will learn how to use database-resident stored program units such as procedures, functions, packages and database triggers. Students will also learn about the latest features in Oracle 19c.</p></div><div id="course-pills-2"><h4>Selection &amp; Setup of the Database Interface</h4><ul><li>Considering Available Tools</li><li>Selecting the Appropriate Tool</li><li>Oracle Net Database Connections</li><li>Oracle PAAS Database Connections</li><li>Setup SQL Developer</li><li>Setup SQL *Plus</li><li>Setup JDeveloper</li><li>About BIND and Substitution Variables</li><li>Using SQL Developer</li><li>Using SQL *Plus</li></ul><h4>Choosing a Database Programming Language</h4><ul><li>What is Database Programming</li><li>PL/SQL Programming</li><li>PL/SQL Performance Advantages</li><li>Integration with Other Languages</li></ul><h4>PL/SQL Language Essentials</h4><ul><li>PL/SQL Program Structure</li><li>Language Syntax Rules</li><li>Embedding SQL</li><li>Writing Readable Code</li><li>Generating Readable Code</li><li>Generating Database Output</li><li>SQL * Plus Input of Program Block</li></ul><h4>DECLARE Section</h4><ul><li>About the Declare Section</li><li>Declare Primitive Types</li><li>Declaration Options</li><li>Not Null</li><li>Constant</li><li>Data Dictionary Integration</li><li>% Type</li><li>Declare Simple User-Defined Types</li><li>Type ? Table</li><li>Type ? Record</li><li>Extended User Defined Types</li></ul><h4>BEGIN Section</h4><ul><li>About the Begin Section</li><li>Manipulating Program Data</li><li>Logic Control &amp; Braching</li><li>GOTO</li><li>LOOP</li><li>IF-THEN-ELSE</li><li>CASE</li></ul><h4>EXCEPTION Section</h4><ul><li>About the Exception Section</li><li>Isolating the Specific Exception</li><li>Pragma Exception_INIT</li><li>SQLCODE &amp;SQLERRM Example</li><li>SQL%ROWCOUNT &amp; Select ? Into</li></ul><h4>Beyond the Basics : Explicit Cursors</h4><ul><li>About Explicit Cursors</li><li>Extend Cursor Techniques</li><li>For Update of Clause</li><li>Where Current of Clause</li><li>Using for ? Loop Cursors</li></ul><h4>Introduction Database Resident Programming Units</h4><ul><li>About Database ? Resident Programs</li><li>Physical Storage &amp; Execution</li><li>Types of Stored Program Units</li><li>Stored Program Unit Advantages</li><li>Modular Design Principles</li></ul><h4>Creating Stored Procedures and Functions</h4><ul><li>Stored Procedures &amp; Functions</li><li>Create Procedure / Create Function</li><li>Creating Procedures &amp; Functions</li><li>Raise_Salary() Procedure</li><li>Salary_Valid() function</li><li>The Parameter Specification</li><li>Default Clause</li><li>System &amp; Object Privileges</li><li>Using the Development Tools</li></ul><h4>Executing Stored Procedures and Functions</h4><ul><li>Calling Procedures &amp; Functions</li><li>Unit Testing with Execute</li><li>Anonymous Block Unit Testing</li><li>Specifying a Parameter Notation</li><li>SQL Worksheet Unit Testing</li><li>Calling Functions from SQL</li></ul><h4>Maintaining Stored Programming Units</h4><ul><li>Recompiling Programs</li><li>Mass Recompilation Using UTL_RECOMP()</li><li>Dropping Procedures &amp; Functions</li><li>Drop Procedures &amp; Functions</li><li>Drop Procedure / Function</li><li>Data Dictionary Metadata</li><li>Using USER_OBJECTS</li><li>Using USER_SOURCE</li><li>Using USER_ERRORS</li><li>Using USER_OBJECT_SIZE</li><li>Using USER_DEPENDENCIES</li></ul><h4>Managing Dependencies</h4><ul><li>Dependency Internals</li><li>Tracking Dependencies</li><li>The Dependency Tracking Utility</li><li>SQL Developer Dependency Info</li><li>Dependency Strategy Checklists</li></ul><h4>Creating &amp; Maintaining</h4><ul><li>About Packages</li><li>Creating Packages</li><li>Maintaining Packages</li><li>Performance Considerations</li></ul><h4>Advanced Package Capabilities</h4><ul><li>Definer &amp; Invoker Rights</li><li>White Lists &amp; Accessible By</li><li>Persistent Global Objects</li><li>Defining Initilization Logic</li><li>Object Orientation Support</li></ul><h4>Advanced Cursor Techniques</h4><ul><li>Using Cursor Variables</li><li>Using SYS_REFCURSOR</li><li>Using Cursor Expressions</li></ul><h4>Using System Supplied Packages</h4><ul><li>DBMS_OUTPUT()</li><li>UTL_FILE()</li><li>FOPEN() Example</li></ul><h4>Database Trigger Concepts</h4><ul><li>About Database Triggers</li><li>DML Event Trigger Sub-Types</li><li>Database Trigger Scenario</li><li>Trigger Exhaustion Mechanisms</li><li>Trigger within SQL Worksheet</li></ul><h4>Creating Database Triggers</h4><ul><li>Statement Level Triggers</li><li>Using Raise Application_Error()</li><li>Row-Level Triggers</li><li>Examples of Triggers</li><li>Employee_Salary_Check Example</li><li>Employee_Journal Example</li><li>Budget_Event Example</li><li>Instead of Triggers</li><li>Triggers within and Application</li></ul><h4>Maintaining Database Triggers</h4><ul><li>Call Syntax</li><li>Trigger Maintenance Tasks</li><li>Show Errors Trigger</li><li>Drop Trigger</li><li>Alter Trigger</li><li>Multiple Triggers for a Table</li><li>Handling Mutating Table Issues</li></ul><h4>Implementing System Event Triggers</h4><ul><li>What are System Event Triggers</li><li>Defining the Scope</li><li>Available System Events</li><li>System Event Attributes</li></ul></div>

Oracle Primavera

Oracle 19c PL/SQL Fundamentals (TTOR12019)

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>Software Engineers<br />Senior Software Engineers<br />Java Developers<br />DevOps Engineers<br />Software Developers<br />.NET Developers<br />Systems Engineers<br />Full Stack Developers<br />Full Stack Java Developers<br />Data Scientists</p>Overview<p>By the end of the course, you should be able to meet the following objectives:<br />Describe the software-defined data center (SDDC)<br />Explain the vSphere components and their function in the infrastructure<br />Install and configure VMware ESXiâ¢ hosts<br />Deploy and configure VMware vCenter Server Applianceâ¢<br />Use VMware vSphere Clientâ¢ to manage the vCenter Server inventory and the vCenter Server configuration<br />Manage, monitor, back up, and protect vCenter Server Appliance<br />Create virtual networks with vSphere standard switches<br />Describe the storage technologies supported by vSphere<br />Configure virtual storage using iSCSI and NFS storage<br />Create and manage VMware vSphere VMFS datastores<br />Use the vSphere Client to create virtual machines, templates, clones, and snapshots<br />Create a content library and deploy virtual machines from templates in the library<br />Manage virtual machine resource use<br />Migrate virtual machines with VMware vSphere vMotion and VMware vSphere Storage vMotion<br />Create and manage a vSphere cluster that is enabled with VMware vSphere High Availability and VMware vSphere Distributed Resource Schedulerâ¢<br />Discuss solutions for managing the vSphere life cycle<br />Use VMware vSphere Update Managerâ¢ to apply patches and perform upgrades to ESXi hosts and virtual machines</p><p>This five-day course features intensive hands-on training that focuses on installing, configuring, and managing VMware vSphereÂ© 7, which includes VMware ESXi? 7 and VMware vCenter ServerÂ© 7. This course prepares you to administer a vSphere infrastructure for an organization of any size.  <br />This course is the foundation for most of the other VMware technologies in the software-defined data center<br /></p></div><div id="course-pills-2"><h4>Course Introduction</h4><ul><li>Introductions and course logistics </li><li>Course objectives </li></ul><h4>Introduction to vSphere and the Software-Defined Data Center </h4><ul><li>Explain basic virtualization concept</li><li>Describe how vSphere fits into the software-defined data center and the cloud infrastructure</li><li>Explain how vSphere interacts with CPUs, memory, networks, and storage</li><li>Recognize the user interfaces for accessing the vCenter Server system and ESXi hosts</li><li>Use VMware Host Client? to access and manage ESXi host</li></ul><h4>Virtual Machines</h4><ul><li>Create and remove a virtual machine</li><li>Provision a virtual machine with virtual devices</li><li>Identify the files that make up a virtual machine</li><li>Explain the importance of VMware Tools</li></ul><h4>vCenter Server</h4><ul><li>Describe the vCenter Server architecture</li><li>Discuss how ESXi hosts communicate with vCenter Server </li><li>Deploy and configure vCenter Server Appliance </li><li>Use the vSphere Client to manage the vCenter Server inventory </li><li>Add data center, organizational objects, and hosts to vCenter Server </li><li>Use roles and permissions to enable users to access objects in the vCenter Server inventory</li><li>Back up vCenter Server Appliance  </li><li>Monitor vCenter Server tasks, events, and appliance health</li><li>Use vCenter Server High Availability to protect a vCenter Server Appliance </li></ul><h4>Configuring and Managing Virtual Networks </h4><ul><li>Create and manage standard switches</li><li>Describe the virtual switch connection types</li><li>Configure virtual switch security, traffic-shaping and load-balancing policies</li><li>Compare vSphere distributed switches and standard switches </li></ul><h4>Configuring and Managing Virtual Storage </h4><ul><li>Identify storage protocols and storage device types </li><li>Discuss ESXi hosts using iSCSI, NFS, and Fibre Channel storage </li><li>Create and manage VMFS and NFS datastores</li><li>Explain how multipathing works with iSCSI, NFS, and Fibre Channel storage</li><li>Deploy virtual machines on a VMware vSAN? datastore </li></ul><h4>Virtual Machine Management</h4><ul><li>Use templates and cloning to deploy new virtual machines </li><li>Modify and manage virtual machines </li><li>Create a content library and deploy virtual machines from templates in the library </li><li>Dynamically increase the size of a virtual disk </li><li>Use customization specification files to customize a new virtual machine </li><li>Perform vSphere vMotion and vSphere Storage vMotion migrations </li><li>Create and manage virtual machine snapshots </li><li>Examine the features and functions of VMware vSphereÂ© Replication?</li></ul><h4>Resource Management and Monitoring</h4><ul><li>Discuss CPU and memory concepts in a virtualized environment </li><li>Describe what overcommitment of a resource means </li><li>Describe methods for optimizing CPU and memory usage </li><li>Use various tools to monitor resource use </li><li>Create and use alarms to report certain conditions or events</li></ul><h4>vSphere Clusters</h4><ul><li>Describe options for making a vSphere environment highly available</li><li>Explain the vSphere HA architecture </li><li>Configure and manage a vSphere HA cluster </li><li>Examine the features and functions of VMware vSphereÂ© Fault Tolerance</li><li>Configure a vSphere cluster using ESXi Cluster Quickstart </li><li>Describe the functions of a vSphere DRS cluster</li><li>Create a vSphere DRS cluster</li></ul><h4>vSphere Lifecycle Management </h4><ul><li>Describe how VMware vSphereÂ© Lifecycle Manager? works</li><li>Use vSphere Lifecycle Manager to update ESXi hosts in a cluster </li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br />Notes<p>Delivery by TDSynex, Exit Certified and New Horizons an VMware Authorised Training Centre (VATC)</p><p>Nexus Humans VMware vSphere: Install, Configure, Manage [v7.0] 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 VMware vSphere: Install, Configure, Manage [v7.0] 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>

VMware Vsphere

vSphere

Microsoft Virtual Academy (MVA)

VMware vSphere: Install, Configure, Manage [v7.0]

Janets

Coordinate Measuring Machine (CMM)

Machine Learning (ML)

Python

Discover the power of data science and machine learning with Python! Learn essential techniques, algorithms, and tools to analyze data, build predictive models, and unlock insights. Dive into hands-on projects, from data manipulation to advanced machine learning applications. Elevate your skills and unleash the potential of Python for data-driven decision-making.

Data Science & Machine Learning With Python

JavaScript

AWS Lambda

Microservices

You will learn how to develop reliable and scalable serverless applications, following the microservices architecture. We will develop event-driven microservices with AWS serverless services that come with the power of the cloud, high availability and high scalability by nature following serverless design patterns and best practices.

AWS Serverless Microservices with Patterns and Best Practices

NextGen Learning

Mastering SQL Programming Course

CompTIA A+ (220-1002) Course

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This course is intended for professional web developers who use Microsoft Visual Studio in an individual-based or team-based, small-sized to large development environment. Candidates for this course are interested in developing advanced web applications and want to manage the rendered HTML comprehensively. They want to create websites that separate the user interface, data access, and application logic.</p>Overview<p>Describe the Microsoft Web Technologies stack and select an appropriate technology to use to develop any given application.      Design the architecture and implementation of a web application that will meet a set of functional requirements, user interface requirements, and address business models.       Configure the pipeline of ASP.NET Core web applications using middleware, and leverage dependency injection across applications.     Develop a web application that uses the ASP.NET Core routing engine to present friendly URLs and a logical navigation hierarchy to users.     Create Views in an application that display and edit data and interact with Models and Controllers.     Connect an ASP.NET Core application to a database using Entity Framework Core.     Implement a consistent look and feel across an entire web application.     Write JavaScript code that runs on the client-side and utilizes the jQuery script library to optimize the responsiveness of an web application.     Add client side packages and configure Task Runners.     Run unit tests and debugging tools against a web application in Visual Studio 2022.     Write an application that authenticates and authorizes users to access content securely using Identity.     Build an application that resists malicious attacks.     Use caching to accelerate responses to user requests.     Use SignalR to enable two-way communication between client and server.     Describe what a Web API is and why developers might add a Web API to an application.     Describe how to package and deploy an ASP.NET Core web application from a development computer to a web server.</p><p>In this 5-day course, professional web developers will learn to develop advanced ASP.NET Core applications using .NET tools and technologies. The focus will be on coding activities that enhance the performance and scalability of the Web site application.</p></div><div id="course-pills-2"><h3>Module 1: Exploring ASP.NET Core</h3><ul> <li>Introducing of Microsoft Web Technologies</li> <li>Getting Started with Razor Pages in ASP.NET Core</li> <li>Introducing ASP.NET Core MVC</li></ul>  <h3>Module 2: Designing ASP.NET Core MVC Web Applications</h3><ul> <li>Planning in the Project Design Phase</li> <li>Designing Models, Controllers and Views</li></ul>  <h3>Module 3: Configure Middleware and Services in ASP.NET Core</h3><ul> <li>Configuring Middlewares</li> <li>Configuring Services</li></ul>  <h3>Module 4: Developing Controllers</h3><ul> <li>Writing Controllers and Actions</li> <li>Configuring Routes</li> <li>Writing Action Filters</li></ul>  <h3>Module 5: Developing Views</h3><ul> <li>Creating Views with Razor Syntax</li> <li>Using HTML Helpers and Tag Helpers</li> <li>Reusing Code in Views</li></ul>   <h3>Module 6: Developing Models</h3><ul> <li>Creating MVC Models</li> <li>Working with Forms</li> <li>Validating User Input</li></ul>  <h3>Module 7: Using Entity Framework Core in ASP.NET Core</h3><ul> <li>Introduction to Entity Framework Core</li> <li>Working with Entity Framework Core</li> <li>Use Entity Framework Core to connect to Microsoft SQL Server</li></ul>  <h3>Module 8: Using Layouts, CSS and JavaScript in ASP.NET Core</h3><ul> <li>Using Layouts</li> <li>Using CSS and JavaScript</li> <li>Using JavaScript Libraries</li></ul>   <h3>Module 9: Client-Side Development</h3><ul> <li>Applying Styles and Responsive Design</li> <li>Using Task Runners</li> <li>Looking at ASP.NET Core Blazor</li></ul>   <h3>Module 10: Testing and Troubleshooting</h3><ul> <li>Testing ASP.NET Core Applications</li> <li>Implementing an Exception Handling Strategy</li> <li>Logging ASP.NET Core Applications</li></ul>  <h3>Module 11: Managing Security</h3><ul> <li>Authentication in ASP.NET Core</li> <li>Authorization in ASP.NET Core</li> <li>Defending from Common Attack</li></ul>  <h3>Module 12: Performance and Communication Implementing a Caching Strategy</h3><ul> <li>Managing State</li> <li>Supporting Two-way Communication</li></ul>  <h3>Module 13: Implementing Web APIs</h3><ul> <li>Introducing Web APIs</li> <li>Developing a Web API</li> <li>Calling a Web API</li></ul>  <h3>Module 14: Hosting and Deployment</h3><ul> <li>Hosting and Deploying On-premises</li> <li>Deploying to Microsoft Azure</li> <li>Looking at Microsoft Azure Fundamentals</li></ul></div>

Microsoft AZ-900

NET MVC

ASP.NET

Microsoft AZ-303

Microsoft AZ-700

NET Core

55340 Developing ASP.NET Core Web Applications

<strong>This beginner to the intermediate-level course on .NET MAUI mobile application development enables you to advance your Visual Studio coding skills and implement interfaces using XAML. Learn to develop and publish Minimal API with .NET Core using event driven development while understanding logic and syntax when working on the .NET environment.</strong>
        <p>The .NET multi-platform app UI is a cross-platform framework to create innovative mobile and desktop applications with C# and XAML. One can develop apps using .NET MAUI that runs on Android, iOS, macOS, and Windows and add platform-specific source code and resources.

As part of learning in this course, you will begin with a cursory introduction to the .NET MAUI concepts and features and their applications. You will learn.NET MAUI basics and design a simple API with the .NET Core. Next, you will learn to use an API in a .NET MAUI application, understand XAML controls, and write clear syntax. You will then learn to implement styles in a .NET MAUI application and utilize the MVVM (Model-View-ViewModel) pattern with the MVVM community toolkit. You will learn to use SQLite with a random mobile application. You will also learn to secure a mobile app using authentication and authorization protocols. Finally, you will learn to create your first Minimal API.

Upon completing the course, you will comprehensively learn to create your mobile applications using .NET MAUI. You will independently advance your Visual Studio coding skillsets and learn to build innovative mobile apps using .NET MAUI.

All resources are available at: https://github.com/PacktPublishing/Mobile-Development-with-.NET-MAUI</p>
        <h2>What You Will Learn</h2><p>Build interfaces with XAML (Extensible Application Markup Language)<br>Develop and publish Minimal API with .NET Core<br>Use various MAUI controls and MAUI layouts<br>Use the MVVM pattern and community toolkit<br>Implement .NET MAUI authentication<br>Utilize an API in .NET MAUI app and secure it using JSON web tokens</p>
        <h2>Audience</h2><p>This course is aimed at anyone interested in learning .NET MAUI and making cross-platform mobile applications. To take this course, you will need to know C#. Even if you do not have much exposure to the .NET development stack, this course is beginner-friendly and offers many development tips. You will also need a capable machine to run Visual Studio 2022 and mobile emulators.</p>
        <h2>Approach</h2><p>The course content is deftly constructed to educate and let you understand all related activities in each module on the application being built. You will also work on troubleshooting and debugging as you advance. You will implement best practices and write efficient, logical code. You will acquire knowledge step-by-step throughout the course and be challenged to be the best you can be.</p>
        <h2>Key Features</h2><p>Learn .NET MAUI basics, design simple APIs with .NET Core and consume an API using .NET MAUI * Create XAML controls and syntax and implement styles in a .NET MAUI application * Learn about the MVVM pattern using the MVVM community toolkit</p>
        <h2>Github Repo</h2><p>https://github.com/PacktPublishing/Mobile-Development-with-.NET-MAUI</p>
        <h2>About the Author</h2><h3>Trevoir Williams</h3><p>Trevoir Williams is a software engineer and part-time lecturer. With a master's degree in computer science, he has spent over a decade teaching web, software, and database development courses. He also has extensive industry experience in web application development, Azure Cloud system, and server administration. He enjoys teaching IT and development courses and hopes to impart knowledge of the latest developments in industry standards and techniques to his students.</p>
        <h2>Course Outline</h2><h4>1. Introduction</h4><p>This section focuses on introducing an outline of the course objectives and the .NET MAUI concepts briefly.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Introduction</p><p style='margin: 0'>In this video, the author introduces the course objectives and the concepts of .NET MAUI mobile development.</p></td></tr></tbody></table><br><h4>2. Environment Setup</h4><p>This section focuses on the environment setup for the MAUI functioning.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Setup Development Environment</p><p style='margin: 0'>This video demonstrates a step-by-step process of installing and setting up the various programs and environments for the working of .NET MAUI.</p></td></tr></tbody></table><br><h4>3. Create Your First .NET MAUI APP</h4><p>This section focuses on the .NET MAUI app creation, creating controls with XAML, understanding the layouts, and setting and defining values.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Create Controls with C#</p><p style='margin: 0'>In this video, you will learn how to create controls using the C# program.</p></td></tr><tr><td style='padding: 15px;'><p>2. Create Controls with XAML</p><p style='margin: 0'>After learning to create controls using the C# program, in this video, you will learn to recreate that using the XAML code.</p></td></tr><tr><td style='padding: 15px;'><p>3. Understand MAUI Layouts</p><p style='margin: 0'>In this video, you will learn to create a new content page and understand the layout structure of MAUI.</p></td></tr><tr><td style='padding: 15px;'><p>4. Set Global Markup Values</p><p style='margin: 0'>In this lesson, you will learn about the Extensible Application Markup Language extension and set aside labels.</p></td></tr><tr><td style='padding: 15px;'><p>5. Define Platform-Specific Values</p><p style='margin: 0'>Here, you will learn about platform-specific markup and look at device configurations that determine the app's performance.</p></td></tr><tr><td style='padding: 15px;'><p>6. Shared Resources</p><p style='margin: 0'>This video demonstrates sharing resources that are not coupled with any one type of control.</p></td></tr><tr><td style='padding: 15px;'><p>7. Navigating Multiple Pages</p><p style='margin: 0'>In this video, we will look at playout navigation, a window we created for the mini-icon that slides from the side into the center.</p></td></tr><tr><td style='padding: 15px;'><p>8. Section Summary</p><p style='margin: 0'>This video briefly outlines and recapitulates what you learned through the lessons of this section.</p></td></tr></tbody></table><br><h4>4. Create a Car Listing APP (MVVM and CRUD)</h4><p>This section focuses on creating a car listing application using the MVVM and CRUD models.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Section Overview</p><p style='margin: 0'>This section outlines what you will learn in this section, including navigation properties, different layouts, and the MVVM and CRUD models.</p></td></tr><tr><td style='padding: 15px;'><p>2. Setup .NET MAUI Project</p><p style='margin: 0'>In this video, you will learn to set up the .NET MAUI project and create a global JSON file to begin the project.</p></td></tr><tr><td style='padding: 15px;'><p>3. Create Data Model</p><p style='margin: 0'>In this lesson, we are going to set up our data model in which we are going to store the elements of the data.</p></td></tr><tr><td style='padding: 15px;'><p>4. Create Data Access Services</p><p style='margin: 0'>In this video, we will create a data access service class that will behave as the transporter for the application data store and the actual application.</p></td></tr><tr><td style='padding: 15px;'><p>5. MVVM Toolkit Updates</p><p style='margin: 0'>In this lesson, we will look at the updates from the 8.0.0 Preview 4 regarding the changes in the class names.</p></td></tr><tr><td style='padding: 15px;'><p>6. Understanding the MVVM Pattern</p><p style='margin: 0'>In this video, you will learn to create our view model. You will learn to create an abstract base class, which acts as the transmitter of the properties' inheritance to the rest of the classes.</p></td></tr><tr><td style='padding: 15px;'><p>7. Set Up View Model and Command</p><p style='margin: 0'>In this lesson, you will learn to set up the view model for the car listing case called the "CarListViewModel".</p></td></tr><tr><td style='padding: 15px;'><p>8. Understanding Dependency Injection</p><p style='margin: 0'>You will learn about dependency injections that link one base class to another and how it is facilitated in the .NET MAUI app.</p></td></tr><tr><td style='padding: 15px;'><p>9. Implement Data Template and Collection View</p><p style='margin: 0'>In this video, you will learn how to decide on the user interface for our application. We will create a template and a collection view.</p></td></tr><tr><td style='padding: 15px;'><p>10. Style Our List Page View</p><p style='margin: 0'>This video demonstrates how to improve the aesthetics of the application interface that we created in the previous lesson.</p></td></tr><tr><td style='padding: 15px;'><p>11. Implement a Details Page</p><p style='margin: 0'>In this video, you will learn about implementing the details page and understand the syntax used step by step.</p></td></tr><tr><td style='padding: 15px;'><p>12. Exploring Storage Options</p><p style='margin: 0'>In this video, we will look at the different options for storage, the most suitable option, and when it would be the most suitable option to use.</p></td></tr><tr><td style='padding: 15px;'><p>13. Add SQLite Database to App</p><p style='margin: 0'>This video demonstrates how to set up our SQLite database to the application we created to store the data in the data model.</p></td></tr><tr><td style='padding: 15px;'><p>14. Setup Form to Add and Delete Records</p><p style='margin: 0'>This lecture takes us through the process of setting up a form to input data into the database, and you will also learn how to add and delete records from the database.</p></td></tr><tr><td style='padding: 15px;'><p>15. Section Summary</p><p style='margin: 0'>In the final video of this section, we will briefly recapitulate what we have learned so far and brush up on the skillsets learned.</p></td></tr></tbody></table><br><h4>5. Develop Supporting API</h4><p>This section focuses on using Restful API to complement our mobile application. We will look at setting up databases, setting up the CORS policy, configuring the endpoints, and publishing the API to a local server.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Section Overview</p><p style='margin: 0'>This video demonstrates how we will begin to use the Restful API to complement our created mobile application.</p></td></tr><tr><td style='padding: 15px;'><p>2. Setup API Project</p><p style='margin: 0'>In this video, you will learn how to set up our API project. We will choose to build using the .NET Core Web API.</p></td></tr><tr><td style='padding: 15px;'><p>3. Setup CORS Policy</p><p style='margin: 0'>In this lesson, we will look at setting up Cross Origin Resource Sharing (CORS), which will be used whenever a device accesses an API across the network.</p></td></tr><tr><td style='padding: 15px;'><p>4. Setup Database</p><p style='margin: 0'>In this video, we will delve deeper into configuring our database as APIs will have their database and are the point of information or point of reference to any third-party application.</p></td></tr><tr><td style='padding: 15px;'><p>5. Configure API Endpoints</p><p style='margin: 0'>In this video, you will learn what an API endpoint is and how to create the API endpoints, which uses the MAP function with the verb (get, put, delete, for) of choice to run the function.</p></td></tr><tr><td style='padding: 15px;'><p>6. Test API Functions</p><p style='margin: 0'>Here, you will learn about testing and running the API functions we created on the mobile application using Postman.</p></td></tr><tr><td style='padding: 15px;'><p>7. Prepare Server for API Deployment</p><p style='margin: 0'>To deploy the API we created smoothly, we will look at some of the housekeeping functions we would need to indulge in and then run the API.</p></td></tr><tr><td style='padding: 15px;'><p>8. Refactor and Publish API To Local Server</p><p style='margin: 0'>In this video, we will consider the factors before publishing our API to a local server and other configuration considerations to take when developing an API against an Android emulator.</p></td></tr><tr><td style='padding: 15px;'><p>9. Configure Mobile App for Network Connections</p><p style='margin: 0'>In this lesson, we will examine a few explanations of how our emulators work and consider the configurations based on that.</p></td></tr><tr><td style='padding: 15px;'><p>10. Refactor MAUI App for API</p><p style='margin: 0'>Here, you will learn to refactor our mobile application to communicate with the API. You will also learn to create additional API services to enhance the mobile app.</p></td></tr><tr><td style='padding: 15px;'><p>11. Essential Fixes</p><p style='margin: 0'>In this video, you will learn to fix errors arising when we test our API by running it, then identify the errors and fix them.</p></td></tr><tr><td style='padding: 15px;'><p>12. Section Summary</p><p style='margin: 0'>This video summarizes what we learned through the section and looks at some of the intricacies of API connectivity relative to Android versus other devices.</p></td></tr></tbody></table><br><h4>6. Authentication Flow</h4><p>This section focuses on multiple processes. You will learn about the different navigational properties and different layouts. We will also look at the MVVM pattern and how it can be implemented.</p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Section Overview</p><p style='margin: 0'>This video briefly outlines what you will learn in this section, including authentication and authorization, creating login pages, and setting up a secure logout system.</p></td></tr><tr><td style='padding: 15px;'><p>2. Add Identity to API</p><p style='margin: 0'>In this lesson, you will learn to add support for the authentication leverage for an API. We will use the Identity library that is built into the system.</p></td></tr><tr><td style='padding: 15px;'><p>3. Set Up Login Endpoint</p><p style='margin: 0'>Here, we will understand how to create a login endpoint. You will learn how to receive the login information and how to validate it.</p></td></tr><tr><td style='padding: 15px;'><p>4. Add App Loading Page</p><p style='margin: 0'>We will look back at the .NET MAUI app and create two pages: the application loading page and the application login page.</p></td></tr><tr><td style='padding: 15px;'><p>5. Add App Login Page</p><p style='margin: 0'>In this video, you will learn to add an application login page and look at the activity that needs to happen before the login is executed.</p></td></tr><tr><td style='padding: 15px;'><p>6. Seed Users and Roles</p><p style='margin: 0'>After creating the login page, you will learn to populate the seed users and define their roles in the system.</p></td></tr><tr><td style='padding: 15px;'><p>7. Authentication and Authorization to API</p><p style='margin: 0'>In this lesson, you will learn to set up the configuration as needed to govern the issuance and valuation of our access tokens.</p></td></tr><tr><td style='padding: 15px;'><p>8. Set Up JSON Web Token Generation</p><p style='margin: 0'>In this lesson, we will focus on generating an access token and ensuring that the content of the token is readable.</p></td></tr><tr><td style='padding: 15px;'><p>9. Set Up Login Logic and Flow</p><p style='margin: 0'>In this lesson, we will look back at our .NET MAUI app and outfit it with logic to handle, login, and manage the login flow by extending the API access.</p></td></tr><tr><td style='padding: 15px;'><p>10. Adjust App Flow and Layout</p><p style='margin: 0'>Here, you will learn to modify the user interface. You will learn to navigate through the login and main pages and simulate the content displayed based on the roles of the seed users.</p></td></tr><tr><td style='padding: 15px;'><p>11. Handle Logout</p><p style='margin: 0'>In this lesson, we will look at handling the logout operations. You will learn to add a logout operation and a logout button to allow the seed users to log out at will.</p></td></tr><tr><td style='padding: 15px;'><p>12. Section Summary</p><p style='margin: 0'>This final video will recap the concepts we have learned in this section, including creating logins and logouts, seeding users, creating default admins, and handling the login and logout flows.</p></td></tr></tbody></table>

.NET MAUI

This beginner to the intermediate-level course on .NET MAUI mobile application development enables you to advance your Visual Studio coding skills and implement interfaces using XAML. Learn to develop and publish Minimal API with .NET Core using event driven development while understanding logic and syntax when working on the .NET environment.

Mobile Development with .NET MAUI

<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 Financial Modelling School (5 days)</strong></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The Real Estate Financial Modelling School is an intensive week meticulously designed to teach the best practices to create flexible and robust cash flows in Excel.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This week long CPD accredited training is ideal for those Real Estate professionals, who are looking to bolster the DCF modelling skills. This course covers Real Estate Investment, Development, Finance &amp; Risk.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The school combines three of our courses:</p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Real Estate Analyst</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Real Estate Investor</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Real Estate Modelling Masterclass</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;">All of the courses are interlinked to give you a full understanding of the subject using Excel.</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;">Implement cash flows in excel throughout the whole week.</li><li value="2" fr-original-style="" style="box-sizing: border-box;">In the first two days you will learn how to develop rent functions and net operating income. We will show you how to value and appraise property investments and analyse the results.</li><li value="3" fr-original-style="" style="box-sizing: border-box;">On the third and fourth day you will learn how to model and analyse development projects using both residuals and cash flow methods. It will show you how to interrogate and compare alternative return metrics such as profit-equity multiples, profit and cost, net present value, worth and internal rate of return. Additionally you will cover how to model cash flow from different sector office, retail and leisure.</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Finally on the fifth day debt structures will be covered as well as joint ventures and partnership financing. You will also learn how to implement the full spectrum of the risk analysis from sensitivity to Monte Carlo.</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 school?</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 at any level with exposure to real estate financial models on a frequent basis</li><li value="2" 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="3" fr-original-style="" style="box-sizing: border-box;">Mid-level to senior Real Estate Analysts</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Real Estate Managers who would like to gain an understanding of the dynamics of debt and financial return fluctuations in more detail</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Property industry modellers who would like to be fully proficient in building complex financial models</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><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;"><em fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">Real Estate Analyst I</em></em></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">Know how to build a property asset cash flow, analyse geared, and un-geared IRRs.</em></em></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;"><em fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">Real Estate Analyst II</em></em></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">Know how to build a multi-let property cash flow and apply the concepts on a hypothetical case study.</em></em></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;">Day Three</strong></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">Real Estate Investor I</em></em></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Modelling international variations in real estate income streams i.e. Includes indexation patterns, rent caps, discounts / premiums to indexation, rent free periods, as well as how to deal with costs during vacancy</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Modelling sector variations in real estate income streams i.e. Office versus industrial, retail &amp; leisure</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Further senior debt covenants</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Advance Rent Function techniques to manage feature rich lease structures</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 Four</strong></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">Real Estate Investor II</em></em></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Introduction to development appraisals</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Residual models, site and profit calculations</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Development cash flows versus Investment cash flows</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Introduction to straight line versus S-curve costing</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Phased asset sales in development appraisals</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Discounting development cash flows</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Complimentary return metrics for development appraisals</li><li value="8" fr-original-style="" style="box-sizing: border-box;">Introduction to development finance</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 Five</strong></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">Real Estate Modelling Masterclass</em></em></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;">Advance 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 fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">For more information about the Real Estate Financial Modelling School 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>



Real Estate Financial Modelling School (5 days)
The Real Estate Financial Modelling School is an intensive week meticulously designed to teach the best practices to create flexible and robust cash flows in Excel.
This week long CPD accredited training is ideal for those Real Estate professionals, who are looking to bolster the DCF modelling skills. This course covers Real Estate Investment, Development, Finance & Risk.
The school combines three of our courses:
Real Estate Analyst
Real Estate Investor
Real Estate Modelling Masterclass


All of the courses are interlinked to give you a full understanding of the subject using Excel.


On this course you will…
Implement cash flows in excel throughout the whole week.
In the first two days you will learn how to develop rent functions and net operating income. We will show you how to value and appraise property investments and analyse the results.
On the third and fourth day you will learn how to model and analyse development projects using both residuals and cash flow methods. It will show you how to interrogate and compare alternative return metrics such as profit-equity multiples, profit and cost, net present value, worth and internal rate of return. Additionally you will cover how to model cash flow from different sector office, retail and leisure.
Finally on the fifth day debt structures will be covered as well as joint ventures and partnership financing. You will also learn how to implement the full spectrum of the risk analysis from sensitivity to Monte Carlo.


Who will benefit from this school?
Real Estate professionals at any level with exposure to real estate financial models on a frequent basis
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
Mid-level to senior Real Estate Analysts
Real Estate Managers who would like to gain an understanding of the dynamics of debt and financial return fluctuations in more detail
Property industry modellers who would like to be fully proficient in building complex financial models


Course Outline
Day One
Real Estate Analyst I
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
Real Estate Analyst II
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)


Day Three
Real Estate Investor I
Modelling international variations in real estate income streams i.e. Includes indexation patterns, rent caps, discounts / premiums to indexation, rent free periods, as well as how to deal with costs during vacancy
Modelling sector variations in real estate income streams i.e. Office versus industrial, retail & leisure
Further senior debt covenants
Advance Rent Function techniques to manage feature rich lease structures


Day Four
Real Estate Investor II
Introduction to development appraisals
Residual models, site and profit calculations
Development cash flows versus Investment cash flows
Introduction to straight line versus S-curve costing
Phased asset sales in development appraisals
Discounting development cash flows
Complimentary return metrics for development appraisals
Introduction to development finance


Day Five
Real Estate Modelling Masterclass
Mezzanine debt modelling
Joint Venture structures between developers and lender/equity partners
Promote and profit share structure calculations
Advance 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 Financial Modelling School 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

Real Estate Finance

Microsoft Excel

Professional Development

Continuous Professional Development (CPD)

This week long CPD accredited training is ideal for those Real Estate professionals, who are looking to bolster the DCF modelling skills. This course covers Real Estate Investment, Development, Finance & Risk.

Real Estate Financial Modelling School

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p></p><p>Students in this course are interested in Azure development or in passing the Microsoft Azure Developer Associate certification exam.</p><p></p><p></p><p>This course teaches developers how to create end-to-end solutions in Microsoft Azure. Students will learn how to implement Azure compute solutions, create Azure Functions, implement and manage web apps, develop solutions utilizing Azure storage, implement authentication and authorization, and secure their solutions by using KeyVault and Managed Identities. Students will also learn how to connect to and consume Azure services and third-party services, and include event- and message-based models in their solutions. The course also covers monitoring, troubleshooting, and optimizing Azure solutions.</p><p></p>Prerequisites<p>To be successful in this course, learners should have the following: Hands-on experience with Azure IaaS and PaaS solutions, and the Azure Portal. Experience writing in an Azure supported language at the intermediate level. (C#, JavaScript, Python, or Java) Ability to write code to connect and perform operations on, a SQL or NoSQL database product. (SQL Server, Oracle, MongoDB, Cassandra or similar) Experience writing code to handle authentication, authorization, and other security principles at the intermediate level. A general understanding of HTML, the HTTP protocol and REST API interfaces.</p></div><div id="course-pills-2"><h3>1 - Explore Azure App Service</h3> <ul> <li>Examine Azure App Service</li> <li>Examine Azure App Service plans</li> <li>Deploy to App Service</li> <li>Explore authentication and authorization in App Service</li> <li>Discover App Service networking features</li> </ul> <h3>2 - Configure web app settings</h3> <ul> <li>Configure application settings</li> <li>Configure general settings</li> <li>Configure path mappings</li> <li>Enable diagnostic logging</li> <li>Configure security certificates</li> </ul> <h3>3 - Scale apps in Azure App Service</h3> <ul> <li>Examine autoscale factors</li> <li>Identify autoscale factors</li> <li>Enable autoscale in App Service</li> <li>Explore autoscale best practices</li> </ul> <h3>4 - Explore Azure App Service deployment slots</h3> <ul> <li>Explore staging environments</li> <li>Examine slot swapping</li> <li>Swap deployment slots</li> <li>Route traffic in App Service</li> </ul> <h3>5 - Explore Azure Functions</h3> <ul> <li>Discover Azure Functions</li> <li>Compare Azure Functions hosting options</li> <li>Scale Azure Functions</li> </ul> <h3>6 - Develop Azure Functions</h3> <ul> <li>Explore Azure Functions development</li> <li>Create triggers and bindings</li> <li>Connect functions to Azure services</li> </ul> <h3>7 - Explore Azure Blob storage</h3> <ul> <li>Explore Azure Blob storage</li> <li>Discover Azure Blob storage resource types</li> <li>Explore Azure Storage security features</li> <li>Discover static website hosting in Azure Storage</li> </ul> <h3>8 - Manage the Azure Blob storage lifecycle</h3> <ul> <li>Explore the Azure Blob storage lifecycle</li> <li>Discover Blob storage lifecycle policies</li> <li>Implement Blob storage lifecycle policies</li> <li>Rehydrate blob data from the archive tier</li> </ul> <h3>9 - Work with Azure Blob storage</h3> <ul> <li>Explore Azure Blob storage client library</li> <li>Create a client object</li> <li>Manage container properties and metadata by using .NET</li> <li>Set and retrieve properties and metadata for blob resources by using REST</li> </ul> <h3>10 - Explore Azure Cosmos DB</h3> <ul> <li>Identify key benefits of Azure Cosmos DB</li> <li>Explore the resource hierarchy</li> <li>Explore consistency levels</li> <li>Choose the right consistency level</li> <li>Explore supported APIs</li> <li>Discover request units</li> </ul> <h3>11 - Work with Azure Cosmos DB</h3> <ul> <li>Explore Microsoft .NET SDK v3 for Azure Cosmos DB</li> <li>Create stored procedures</li> <li>Create triggers and user-defined functions</li> <li>Explore change feed in Azure Cosmos DB</li> </ul> <h3>12 - Manage container images in Azure Container Registry</h3> <ul> <li>Discover the Azure Container Registry</li> <li>Explore storage capabilities</li> <li>Build and manage containers with tasks</li> <li>Explore elements of a Dockerfile</li> </ul> <h3>13 - Run container images in Azure Container Instances</h3> <ul> <li>Explore Azure Container Instances</li> <li>Run containerized tasks with restart policies</li> <li>Set environment variables in container instances</li> <li>Mount an Azure file share in Azure Container Instances</li> </ul> <h3>14 - Implement Azure Container Apps</h3> <ul> <li>Explore Azure Container Apps</li> <li>Explore containers in Azure Container Apps</li> <li>Implement authentication and authorization in Azure Container Apps</li> <li>Manage revisions and secrets in Azure Container Apps</li> <li>Explore Dapr integration with Azure Container Apps</li> </ul> <h3>15 - Explore the Microsoft identity platform</h3> <ul> <li>Explore the Microsoft identity platform</li> <li>Explore service principals</li> <li>Discover permissions and consent</li> <li>Discover conditional access</li> </ul> <h3>16 - Implement authentication by using the Microsoft Authentication Library</h3> <ul> <li>Explore the Microsoft Authentication Library</li> <li>Initialize client applications</li> </ul> <h3>17 - Implement shared access signatures</h3> <ul> <li>Discover shared access signatures</li> <li>Choose when to use shared access signatures</li> <li>Explore stored access policies</li> </ul> <h3>18 - Explore Microsoft Graph</h3> <ul> <li>Discover Microsoft Graph</li> <li>Query Microsoft Graph by using REST</li> <li>Query Microsoft Graph by using SDKs</li> <li>Apply best practices to Microsoft Graph</li> </ul> <h3>19 - Implement Azure Key Vault</h3> <ul> <li>Explore Azure Key Vault</li> <li>Discover Azure Key Vault best practices</li> <li>Authenticate to Azure Key Vault</li> </ul> <h3>20 - Implement managed identities</h3> <ul> <li>Explore managed identities</li> <li>Discover the managed identities authentication flow</li> <li>Configure managed identities</li> <li>Acquire an access token</li> </ul> <h3>21 - Implement Azure App Configuration</h3> <ul> <li>Explore the Azure App Configuration service</li> <li>Create paired keys and values</li> <li>Manage application features</li> <li>Secure app configuration data</li> </ul> <h3>22 - Explore API Management</h3> <ul> <li>Discover the API Management service</li> <li>Explore API gateways</li> <li>Explore API Management policies</li> <li>Create advanced policies</li> <li>Secure APIs by using subscriptions</li> <li>Secure APIs by using certificates</li> </ul> <h3>23 - Explore Azure Event Grid</h3> <ul> <li>Explore Azure Event Grid</li> <li>Discover event schemas</li> <li>Explore event delivery durability</li> <li>Control access to events</li> <li>Receive events by using webhooks</li> <li>Filter events</li> </ul> <h3>24 - Explore Azure Event Hubs</h3> <ul> <li>Discover Azure Event Hubs</li> <li>Explore Event Hubs Capture</li> <li>Scale your processing application</li> <li>Control access to events</li> <li>Perform common operations with the Event Hubs client library</li> </ul> <h3>25 - Discover Azure message queues</h3> <ul> <li>Choose a message queue solution</li> <li>Explore Azure Service Bus</li> <li>Discover Service Bus queues, topics, and subscriptions</li> <li>Explore Service Bus message payloads and serialization</li> <li>Explore Azure Queue Storage</li> <li>Create and manage Azure Queue Storage and messages by using .NET</li> </ul> <h3>26 - Monitor app performance</h3> <ul> <li>Explore Application Insights</li> <li>Discover log-based metrics</li> <li>Instrument an app for monitoring</li> <li>Select an availability test</li> <li>Troubleshoot app performance by using Application Map</li> </ul> <h3>27 - Develop for Azure Cache for Redis</h3> <ul> <li>Explore Azure Cache for Redis</li> <li>Configure Azure Cache for Redis</li> <li>Interact with Azure Cache for Redis by using .NET</li> </ul> <h3>28 - Develop for storage on CDNs</h3> <ul> <li>Explore Azure Content Delivery Networks</li> <li>Control cache behavior on Azure Content Delivery Networks</li> <li>Interact with Azure Content Delivery Networks by using .NET</li> </ul></div>

Microsoft AZ-104

Microsoft Azure

AWS Certified Solutions Architect

AZ-204T00 Developing Solutions for Microsoft Azure

<p id="isPasted" 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;">Real Estate Development cash flows require greater skill and flexibility from Analysts, and an ability to work with simultaneously with project partners. Value add and opportunistic property investments are complex both in their initial scope and their cash flow projections.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This course will show delegates how to appraise projects in Excel, incorporate and communicate updates as they happen and ultimately understand how to convert an opportunistic property investment into a core asset that can be sold on.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Residual models (profit &amp; site) are demonstrated first to illustrate the main components of any scheme and the traditional methods of evaluation such as profit on cost ratio, rental yield and interest cover. Development cash flows are then constructed in detail looking in particular at phased income as well as fixed, variable and incidental construction costs and their impact on the net cash flow. Additional performance metrics are calculated including geared IRR and return on equity.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Development financing can be trickier than straightforward senior debt investment financing. This is because finance is often required in stages. The brought forward carried forward method demonstrated on the course, is the easiest way to deal with programmed debt drawdown functions and rolled-up interest.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The assessment of project specific risk is arguably much more important in development schemes. Sensitivity analysis and scenario analysis are covered in the final section of the course.</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;">On this course you will&hellip;</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 calculate land and profit residuals</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Learn how to structure a full development cash flow, including phased sales, S-curve and straight line cost functions</li><li value="3" fr-original-style="" style="box-sizing: border-box;">You will be taught how to find maximum bidding prices for site development and building refurbishments</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Understanding development financing considerations and learn how to optimise financing</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Analyse financial and project completion risks</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;">Who will benefit from this course?</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Developers</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;">Real Estate professionals at any level with exposure to real estate financial models on a frequent basis</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Fund 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;">Land managers</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Planning managers</li><li value="8" fr-original-style="" style="box-sizing: border-box;">Lenders</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;">Course Outline</strong></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;">Day One</strong></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;">Learn how to build a discounted cash flow, analyse returns and understand the components of development models</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Gross versus Net Yields, calculating Net Development Value (NDV)</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Profit residual, with and without financing</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Site residual, how to calculate profit without knowing your costs.</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Introducing financing to site residual calculations</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Purchase price and acquisition costs</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Phased Sales, marketing and disposal costs</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Modelling construction costs using straight line basis, fixed costs, variable costs, incidental costs and construction fees</li><li value="8" fr-original-style="" style="box-sizing: border-box;">Professional fees</li><li value="9" fr-original-style="" style="box-sizing: border-box;">Income and expenditure project functions</li><li value="10" fr-original-style="" style="box-sizing: border-box;">Logic functions, logic tables and array formulae</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;">Day Two</strong></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;">Learn how to build a detailed property development project cash flow, add financing and perform risk analysis on commercial development projects</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Multiple IRRs, competing projects, scoping and linear programming, maximising performance</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Return metrics: Equity profit ratio (EPR), Costs paid out of proceeds (POP), Profit on cost ratio (PCR)</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Alternative site calculation, Net present value (NPV),</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Modelling construction costs using S-curve , variable costs, incidental costs and construction fees</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Switching between scenarios</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Introduction to Development financing, Pari Passu versus Equity First Financing</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Debt scheduling: brought forward and carried forward method</li><li value="8" fr-original-style="" style="box-sizing: border-box;">Consideration of the impact of development finance interest, fees and covenants</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;">Included in the Course</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" 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 Developer 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>



Real Estate Development cash flows require greater skill and flexibility from Analysts, and an ability to work with simultaneously with project partners. Value add and opportunistic property investments are complex both in their initial scope and their cash flow projections.
This course will show delegates how to appraise projects in Excel, incorporate and communicate updates as they happen and ultimately understand how to convert an opportunistic property investment into a core asset that can be sold on.
Residual models (profit & site) are demonstrated first to illustrate the main components of any scheme and the traditional methods of evaluation such as profit on cost ratio, rental yield and interest cover. Development cash flows are then constructed in detail looking in particular at phased income as well as fixed, variable and incidental construction costs and their impact on the net cash flow. Additional performance metrics are calculated including geared IRR and return on equity.
Development financing can be trickier than straightforward senior debt investment financing. This is because finance is often required in stages. The brought forward carried forward method demonstrated on the course, is the easiest way to deal with programmed debt drawdown functions and rolled-up interest.
The assessment of project specific risk is arguably much more important in development schemes. Sensitivity analysis and scenario analysis are covered in the final section of the course.


On this course you will…
Learn how to calculate land and profit residuals
Learn how to structure a full development cash flow, including phased sales, S-curve and straight line cost functions
You will be taught how to find maximum bidding prices for site development and building refurbishments
Understanding development financing considerations and learn how to optimise financing
Analyse financial and project completion risks
Employ best practice and find solutions to common modelling problems


Who will benefit from this course?
Developers
Surveyors
Real Estate professionals at any level with exposure to real estate financial models on a frequent basis
Fund managers
Asset managers
Land managers
Planning managers
Lenders


Course Outline
Day One
Learn how to build a discounted cash flow, analyse returns and understand the components of development models
Gross versus Net Yields, calculating Net Development Value (NDV)
Profit residual, with and without financing
Site residual, how to calculate profit without knowing your costs.
Introducing financing to site residual calculations
Purchase price and acquisition costs
Phased Sales, marketing and disposal costs
Modelling construction costs using straight line basis, fixed costs, variable costs, incidental costs and construction fees
Professional fees
Income and expenditure project functions
Logic functions, logic tables and array formulae


Day Two
Learn how to build a detailed property development project cash flow, add financing and perform risk analysis on commercial development projects
Multiple IRRs, competing projects, scoping and linear programming, maximising performance
Return metrics: Equity profit ratio (EPR), Costs paid out of proceeds (POP), Profit on cost ratio (PCR)
Alternative site calculation, Net present value (NPV),
Modelling construction costs using S-curve , variable costs, incidental costs and construction fees
Switching between scenarios
Introduction to Development financing, Pari Passu versus Equity First Financing
Debt scheduling: brought forward and carried forward method
Consideration of the impact of development finance interest, fees and covenants


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

Financial Modelling & Analysis

Financial Modelling

Financial Risk Management

This course will show delegates how to appraise projects in Excel, incorporate and communicate updates as they happen and ultimately understand how to convert an opportunistic property investment into a core asset that can be sold on.

Real Estate Developer (Development Cash Flow Modelling in Excel)

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Real Estate Investments are unique in that they generate both rental income and capital appreciation, making cash flow modelling an essential tool for Real Estate Investors, Lenders, and Analysts.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">On this course, we will use case studies to enhance the delegates understanding of Real Estate financial appraisals, and help them fully appreciate the theory behind the numbers. We will cover topics such as discounting, compounding, forecasting rental income and expenses, calculating net operating income (NOI), factoring in capital expenditures, modelling debt service, and determining the internal rate of return (IRR).</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">This course will provide you with a solid foundation for understanding and analysing real estate cash flows.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">On this course you will...</strong></span></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Study the financial concepts of compounding, discounting and in-perpetuity</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Consider the importance of the timing and uncertainty of both fixed and growing income streams</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Contrast different property yield metrics</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Build-up risk premiums for discount rates, discuss the importance of liquidity, transparency and volatility</li><li value="5" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Compare and contrast time and money-weighted measures of return</li><li value="6" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Learn about valuation principles</li><li value="7" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Contrast value and worth</li><li value="8" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Discuss the importance and sourcing of inputs and outputs</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who will benefit from this course?</strong></span></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Professional Real Estate Transaction Managers</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Asset Managers</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Portfolio Managers</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Recent graduates with exposure to real estate financial modelling</li><li value="5" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">New employees with exposure to real estate financial modelling</li><li value="6" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">People working in Argus, Anaplan or any commercial real estate software and would like to understand financial modelling key principles.</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Outline</strong>:</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Morning</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Real Estate Financial Mathematics</span></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Time Value of Money</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Net Present Value (NPV)</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Internal Rate of Return (IRR)</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Growth</li><li value="5" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">What Discount Rate?</li><li value="6" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Certainty of a cash flow</li><li value="7" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Liquidity</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Price, Value and Worth</span></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Comparing Price, Value and Worth</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Conventional Valuation Methods</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Term and Reversion, Layer Method</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Property Yields and Capitalisation Method</li><li value="5" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Exit calculations across Europe</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><br fr-original-style="" style="box-sizing: border-box;"></span></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;">Afternoon</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Discounted Cash Flow Models</span></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Investment Appraisal Models</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Cash flow inputs: Rents, Yields, Growth Rates, Target Returns</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Cash-on-Cash and Equity Multiple</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Discount Rates &amp; Exit Cap Rate</li><li value="5" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Operating Assumptions</li><li value="6" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Adding borrowing and analysing geared returns</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Model Interpretation and Analysis</span></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Sensitivity analysis and scenario analysis</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Growth and inflation</li><li value="3" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Performance measures</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Contemporary issues for analysis (such as the rise in interest rates)</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Quizzes | Q&amp;A</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><br fr-original-style="" style="box-sizing: border-box;"></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Included in the Course</strong></span></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">A Bayfield Training Certificate &amp; 7.5 CPD Hours</li><li value="2" style="font-size: 16px; box-sizing: border-box;" id="isPasted" fr-original-style="font-size: 16px;">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" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Course Files</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)</li><li value="5" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">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;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><br fr-original-style="" style="box-sizing: border-box;"></span></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 Understanding Key Principles of Real Estate Financial Modelling 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>



Real Estate Investments are unique in that they generate both rental income and capital appreciation, making cash flow modelling an essential tool for Real Estate Investors, Lenders, and Analysts.
On this course, we will use case studies to enhance the delegates understanding of Real Estate financial appraisals, and help them fully appreciate the theory behind the numbers. We will cover topics such as discounting, compounding, forecasting rental income and expenses, calculating net operating income (NOI), factoring in capital expenditures, modelling debt service, and determining the internal rate of return (IRR).
This course will provide you with a solid foundation for understanding and analysing real estate cash flows.


On this course you will...
Study the financial concepts of compounding, discounting and in-perpetuity
Consider the importance of the timing and uncertainty of both fixed and growing income streams
Contrast different property yield metrics
Build-up risk premiums for discount rates, discuss the importance of liquidity, transparency and volatility
Compare and contrast time and money-weighted measures of return
Learn about valuation principles
Contrast value and worth
Discuss the importance and sourcing of inputs and outputs


Who will benefit from this course?
Professional Real Estate Transaction Managers
Asset Managers
Portfolio Managers
Recent graduates with exposure to real estate financial modelling
New employees with exposure to real estate financial modelling
People working in Argus, Anaplan or any commercial real estate software and would like to understand financial modelling key principles.


Course Outline:
Morning
Real Estate Financial Mathematics
Time Value of Money
Net Present Value (NPV)
Internal Rate of Return (IRR)
Growth
What Discount Rate?
Certainty of a cash flow
Liquidity
Price, Value and Worth
Comparing Price, Value and Worth
Conventional Valuation Methods
Term and Reversion, Layer Method
Property Yields and Capitalisation Method
Exit calculations across Europe


Afternoon
Discounted Cash Flow Models
Investment Appraisal Models
Cash flow inputs: Rents, Yields, Growth Rates, Target Returns
Cash-on-Cash and Equity Multiple
Discount Rates & Exit Cap Rate
Operating Assumptions
Adding borrowing and analysing geared returns
Model Interpretation and Analysis
Sensitivity analysis and scenario analysis
Growth and inflation
Performance measures
Contemporary issues for analysis (such as the rise in interest rates)


Quizzes | Q&A


Included in the Course
A Bayfield Training Certificate & 7.5 CPD Hours
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 Understanding Key Principles of Real Estate Financial Modelling 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

Property Investment

Risk Management

Investment

Investment Management

On this course, we will use case studies to enhance the delegates understanding of Real Estate financial appraisals, and help them fully appreciate the theory behind the numbers. 

Understanding Key Principles of Real Estate Modelling (Advanced Theoretical Course)

Redhill

<h3><b>Complete VB.Net training course description</b></h3>
      <p> A hands on introduction to programming in Visual BASIC .Net.</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
	    <li>Build Visual BASIC applications.</li>
					  															 <li>Build simple components</li>
                       <li>Debug Visual BASIC programs.</li>
                       <li>Examine existing code and determine its function.</li>
                  </ul>
        <h5>
        <b>Complete VB.Net training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
            <p> Anyone wishing to program in Visual BASIC.<br />
                    Anyone wishing to build Windows based applications.
							</p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>None although experience in another high level language would be useful.
							</p>
              
							<li><b>Duration</b></li>
							
              <p>5 days
						</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>Complete VB.Net training course contents</b></h3>
      <ul>
				<li>Writing your first program </li><p>
Visual Studio, forms designer, running VB programs, the UI, properties, writing the code.

</p><li>Toolbox Controls </li><p>
Basic use, input controls, ActiveX controls.

</p><li>Menus and Dialog Boxes </li><p>
Menus, Dialog Box controls, event procedures.

</p><li>Visual Basic .NET variables and operators </li><p>
Variables, I/O, data types, constants, operators, Math Methods, precedence.

</p><li>Decision Structures and Loops and Timers </li><p>
Event-Driven programming, Ifâ¦Then, Select Case, Forâ¦Next Loops, Timer Control.

</p><li>Debugging Visual Basic .NET Programs </li><p>
Break Mode, watch &amp; command windows.

</p><li>Structured Error Handling </li><p>
Try...Catch, Finally, Err Object, retry periods.

</p><li>Modules and Procedures </li><p>
Standard modules, public variables, procedures.

</p><li>Arrays and Collections to Manage Data </li><p>
Fixed-Size &amp; dynamic Arrays, ReDim Preserve, object collections, Controls Collection.

</p><li>Text Files and String Processing </li><p>
Text Box object, Text String methods, sorting.

</p><li>Automating Office Applications </li><p>
Application objects, automation in VB, the Object Browser, the Process Component.

</p><li>Deploying Visual Basic .NET Applications </li><p>
Planning a deployment, ways to deploy an application, deployment projects, options.

</p><li>Managing Windows Forms </li><p>
Forms, positioning, manipulation, adding controls, organizing controls, Startup Object.

</p><li>Adding Graphics and Animation Effects </li><p>
System.Drawing namespace, coordinates, SystemPaint Event, animation, transparency.

</p><li>Inheriting Forms and Creating Base Classes </li><p>
Inheriting forms, inheritance picker, base classes and inheritance, classes in projects.

</p><li>Working with Printers </li><p>
PrintDocument class, Text Box object, Print Preview and Page Setup Dialog Boxes.

</p><li>Database programming with ADO.NET </li><p>
Databases, ADO.NET, Data Adapters, Datasets, Bound &amp; Navigation Controls. Displaying database records, formatting DataGrid cells, updating the database.

</p><li>Displaying HTML Documents Using IE </li><p>
IE Object, Internet Controls, IE Events.

</p><li>Web Forms for Interactive Web Applications </li><p>
ASP.NET, Web Forms vs. Windows Forms, HTML controls, web applications, event procedures for web forms controls.</p>
			
      </ul>

Systems & Network Training

Network & Security

Network Engineer

Complete VB.NET programming

<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

Property & Real Estate Photography

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

<h3><b>ASP.Net training course description</b></h3>
        <p> Our hands on ASP.NET training course that will teach students how to create a simple ASP.NET application that delivers dynamic content to the web. The course is applicable for those using C# or VB.NET with ASP.NET.</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
        <li>Create a web form with server controls</li>
        <li>Separate page code from content with code-behind pages, page controls, and components. </li>
        <li>Display dynamic data from a data source by using ADO.NET and data binding.</li>
        <li>Debug ASP.NET pages by using trace. </li>
        </ul>
        <h5>
        <b>ASP.Net training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Programmers working with ASP.NET.</p>
              
							<li><b>Prerequisites:</b></li>
							
              <p> HTML5 development fundamentals<br />
                 VBNet_course.htm or<br />
                C++ programming foundation </p>
              
							<li><b>Duration</b></li>
							
              <p>3 days </p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>ASP.Net training course contents</b></h3>
      <ul>
        <li>Working with ASP.NET </li>
        <p> Introducing ASP.NET.<br />
          Creating web forms.<br />
          Adding ASP.NET code to a page.<br />
          Handling page events. </p>
        <li>Using Web Controls </li>
        <p> Web controls and HTML controls compared.<br />
          Using intrinsic controls.<br />
          Using input validation controls.<br />
          Introduction to user controls. </p>
        <li>Using trace in ASP.NET pages </li>
        <p> Overview of tracing.<br />
          Trace information.<br />
          Page-level trace and application-level trace. </p>
        <li>Separating code from content </li>
        <p> Advantages of partitioning an ASP.NET page.<br />
          Creating and using code-behind pages.<br />
          Creating and using components and classes.<br />
          Inheritance of classes.<br />
          Interfaces. </p>
        <li>Using ADO .NET to access data </li>
        <p> Accessing text files.<br />
          Overview of ADO .NET<br />
          Connecting to a data source.<br />
          Accessing data with DateSets.<br />
          Using DataViews.<br />
          Accessing data with DataReaders.<br />
          Using XML data with a DataSet. </p>
        <li>Creating an ASP.NET Web Application </li>
        <p> Requirements of a web application.<br />
          Sharing information between pages.<br />
          Securing an ASP.NET application.<br />
          Web services.<br />
          Creating a simple web service using Visual Studio.NET<br />
          Calling a web service using Visual Studio.NET</p>
      </ul>

Building ASP.net applications

<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;">This Real Estate Financial Modelling course will enhance delegates skills in crafting sophisticated financial models tailored for debt financing within the Real Estate sector.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This is another One-Day course that is intended for the most ambitious modellers in the property industry, with a focus on constructing a flexible Real Estate Debt Model. This Real Estate Finance course follows on perfectly from our Real Estate Analyst and Real Estate Developer training courses.</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;"><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 delegates will...</strong></strong><br fr-original-style="" style="box-sizing: border-box;">&bull; Learn how to build senior debt models with geared net cash flow.<br fr-original-style="" style="box-sizing: border-box;">&bull; Explore and assess the influence of complex debt structures on returns.<br fr-original-style="" style="box-sizing: border-box;">&bull; Develop advanced mezzanine debt models affecting project cash flows.<br fr-original-style="" style="box-sizing: border-box;">&bull; Model joint venture structures for optimised partnerships.<br fr-original-style="" style="box-sizing: border-box;">&bull; Calculate promote and profit share structures in Real Estate transactions.<br fr-original-style="" style="box-sizing: border-box;">&bull; Construct sophisticated project cash flow models with mezzanine debts.</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;"><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><br fr-original-style="" style="box-sizing: border-box;">&bull; Real Estate Professionals who have had exposure to Real Estate financial models<br fr-original-style="" style="box-sizing: border-box;">&bull; Mid to Senior level Real Estate Analysts looking to develop their financial modelling skills in development, portfolio analysis<br fr-original-style="" style="box-sizing: border-box;">&bull; Real Estate Developers<br fr-original-style="" style="box-sizing: border-box;">&bull; Financial Analysts<br fr-original-style="" style="box-sizing: border-box;">&bull; Investment Managers<br fr-original-style="" style="box-sizing: border-box;">&bull; Banking and Finance Professionals in Real Estate</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;"><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><br fr-original-style="" style="box-sizing: border-box;">&bull; Mathematics of amortisation and debt finance.<br fr-original-style="" style="box-sizing: border-box;">&bull; Basic senior debt models and geared net cash flow.<br fr-original-style="" style="box-sizing: border-box;">&bull; Debt Cash Flow metrics: LTV, IRR and Interest Rate Dynamics.<br fr-original-style="" style="box-sizing: border-box;">&bull; Mezzanine debt modelling.<br fr-original-style="" style="box-sizing: border-box;">&bull; Joint Venture structures between developers and lender/equity partners.<br fr-original-style="" style="box-sizing: border-box;">&bull; Promote and profit share structure calculations.<br fr-original-style="" style="box-sizing: border-box;">&bull; Advanced project cash flows with mezzanine debt.</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 id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Included in the Course</strong></span></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">A Bayfield Training Certificate</li><li value="2" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">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" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Course Files</li><li value="4" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)</li><li value="5" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">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 Finance 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 Real Estate Financial Modelling course will enhance delegates skills in crafting sophisticated financial models tailored for debt financing within the Real Estate sector.
This is another One-Day course that is intended for the most ambitious modellers in the property industry, with a focus on constructing a flexible Real Estate Debt Model. This Real Estate Finance course follows on perfectly from our Real Estate Analyst and Real Estate Developer training courses.

On this course delegates will...
• Learn how to build senior debt models with geared net cash flow.
• Explore and assess the influence of complex debt structures on returns.
• Develop advanced mezzanine debt models affecting project cash flows.
• Model joint venture structures for optimised partnerships.
• Calculate promote and profit share structures in Real Estate transactions.
• Construct sophisticated project cash flow models with mezzanine debts.

Who will benefit from this course?
• Real Estate Professionals who have had exposure to Real Estate financial models
• Mid to Senior level Real Estate Analysts looking to develop their financial modelling skills in development, portfolio analysis
• Real Estate Developers
• Financial Analysts
• Investment Managers
• Banking and Finance Professionals in Real Estate

Course Outline
• Mathematics of amortisation and debt finance.
• Basic senior debt models and geared net cash flow.
• Debt Cash Flow metrics: LTV, IRR and Interest Rate Dynamics.
• Mezzanine debt modelling.
• Joint Venture structures between developers and lender/equity partners.
• Promote and profit share structure calculations.
• Advanced project cash flows with mezzanine debt.


Included in the Course
A Bayfield Training Certificate
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 Finance 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

Financial Analysis

This Real Estate Financial Modelling course will enhance delegates skills in crafting sophisticated financial models tailored for debt financing within the Real Estate sector.

494 Courses delivered Online

Data Science with Python

By Apex Learning

Complete Java SE 8 Developer Bootcamp

By Packt

Introduction Perl Programming Essentials (TT4925)

By Nexus Human

Oracle 12c PL/SQL Fundamentals

By Nexus Human

Oracle 19c PL/SQL Fundamentals (TTOR12019)

By Nexus Human

VMware vSphere: Install, Configure, Manage [v7.0]

By Nexus Human

Data Science & Machine Learning With Python

By Janets

AWS Serverless Microservices with Patterns and Best Practices

By Packt

Mastering SQL Programming Course

By NextGen Learning

CompTIA A+ (220-1002) Course

By NextGen Learning