<h2 style="color: var(--text-heading); box-sizing: border-box;" id="isPasted" fr-original-style="color: var(--text-heading);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="font-size: 24px; box-sizing: border-box;" fr-original-style="font-size: 24px;">This course at a glance</span></strong></h2><ul style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Accredited by CPDQE</li><li id="isPasted" fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(38, 99, 82) !important; box-sizing: border-box;" fr-original-style=" color: rgb(38, 99, 82) !important;">Set up and configure a data science environment, ensuring optimal productivity and efficiency in data analysis workflows.</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(38, 99, 82) !important; box-sizing: border-box;" fr-original-style=" color: rgb(38, 99, 82) !important;">Utilize the powerful features of the NumPy package for efficient manipulation and computation of numerical data.</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(38, 99, 82) !important; box-sizing: border-box;" fr-original-style=" color: rgb(38, 99, 82) !important;">Harness the capabilities of the Pandas package for data manipulation, exploration, and analysis, enabling insightful decision-making.</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(38, 99, 82) !important; box-sizing: border-box;" fr-original-style=" color: rgb(38, 99, 82) !important;">Create visually compelling data visualizations using Matplotlib, mastering both basic and advanced plotting techniques.</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(38, 99, 82) !important; box-sizing: border-box;" fr-original-style=" color: rgb(38, 99, 82) !important;">Apply data analysis and visualization techniques to real-world datasets, deriving actionable insights to drive business success.</span></li></ul><div data-id="4afcd14" data-element_type="widget" data-widget_type="text-editor.default" style="color: rgb(35, 35, 35); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(35, 35, 35);"><div data-id="4afcd14" data-element_type="widget" data-widget_type="text-editor.default" style="color: rgb(35, 35, 35); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(35, 35, 35);"><div data-id="4afcd14" data-element_type="widget" data-widget_type="text-editor.default" style="color: rgb(35, 35, 35); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(35, 35, 35);"><div data-id="4afcd14" data-element_type="widget" data-widget_type="text-editor.default" style="color: rgb(35, 35, 35); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(35, 35, 35);"><div data-id="4afcd14" data-element_type="widget" data-widget_type="text-editor.default" style="color: rgb(35, 35, 35); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(35, 35, 35);"><div data-id="4afcd14" data-element_type="widget" data-widget_type="text-editor.default" style="color: rgb(35, 35, 35); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(35, 35, 35);"><p style="color: rgb(38, 99, 82) !important; font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(38, 99, 82) !important;">Embark on a transformative journey into the world of data with our &ldquo;Data Science and Data Analytics&rdquo; course. Designed for aspiring data professionals and analysts, this comprehensive program equips you with the essential tools and techniques to excel in the dynamic field of data science. From setting up your data science environment to mastering powerful packages like NumPy, Pandas, and Matplotlib, this course covers all facets of data analysis and visualization, empowering you to unlock actionable insights and drive informed decision-making.</p><p style="color: rgb(38, 99, 82) !important; font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(38, 99, 82) !important;">Uncover the foundations of data science in the introductory modules, where you&rsquo;ll learn to navigate the data science environment and harness the capabilities of essential tools like NumPy and Pandas. Dive deeper into data visualization with comprehensive tutorials on Matplotlib, exploring advanced techniques to create compelling visual representations of your data. Whether you&rsquo;re a novice eager to enter the world of data or an experienced professional seeking to enhance your skill set, this course is your gateway to mastering the art and science of data analytics.</p></div></div></div></div></div></div><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><span style="font-size: 24px; box-sizing: border-box;" fr-original-style="font-size: 24px;">Accredited by</span></h3><p style="color: rgb(15, 21, 26); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(15, 21, 26);">This course is <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">CPDQE&nbsp;</strong>accredited, which serves as an impactful mechanism for skill enhancement.&nbsp;</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Continuing Professional Development (CPD) stands as a crucial, widely acknowledged method that aids individuals, organisations, and entire industries in staying current with their skills and knowledge.</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">CPD not only facilitates the elevation of global standards and benchmarks, aligning with the growing forces of globalisation and consumer expectations but also transforms learning into a deliberate and proactive process. It motivates professionals to uphold a consistently high level of performance and demonstrates their unwavering commitment to a specific job role or profession.</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="font-size: 24px; box-sizing: border-box;" fr-original-style="font-size: 24px;">Course Curriculum</span></strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li id="isPasted" style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Introduction to Data Science &nbsp; &nbsp; &nbsp; &nbsp;</strong></li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Data Science Environment setup &nbsp; &nbsp; &nbsp; &nbsp;</strong></li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Working with the Numpy package &nbsp; &nbsp; &nbsp; &nbsp;</strong></li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Working with Pandas Data science package &nbsp; &nbsp; &nbsp; &nbsp;</strong></li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Working with Matplotlib Data Science package part &ndash; 1 &nbsp; &nbsp; &nbsp; &nbsp;</strong></li><li style="font-weight: bold; box-sizing: border-box;" fr-original-style="font-weight: bold;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Working with Matplotlib Data Science part &ndash; 2</strong></li></ul>

LearnDrive UK

Data Science

Engineering Management

Electrical engineering (EE)

Unlock the power of data with our “Data Science and Data Analytics” course. From setting up your data science environment to mastering essential packages like NumPy, Pandas, and Matplotlib, this program empowers you to analyze, visualize, and derive actionable insights from data.





























Online Data Science & Data Analytics Course with Certificate

General Admission

<p>The SQL for Data Science, Data Analytics and Data Visualization is all you need to advance your career in the relevant fields.</p><p>Enrol now to discover everything you need to know about The SQL for Data Science, Data Analytics and Data Visualization and the skills to improve your talents in this field and be confident in your knowledge bucket with One Education as your right hand!</p><p><strong>Expert Support</strong></p><p>Dedicated tutor support and 24/7 customer support are available to all students with this premium quality course.</p><p><strong>Key Benefits</strong></p><ul><li>Learning materials of the Design course contain engaging voiceover and visual elements for your comfort.</li><li>Get 24/7 access to all content for a full year.</li><li>Each of our students gets full tutor support on weekdays (Monday to Friday)</li></ul><p><strong>Course Curriculum:</strong></p><ul><li>Section 01: Getting Started</li><li>Section 02: Server setting up</li><li>Section 03: Azure Data Studio</li><li>Section 04: Database basic SSMS</li><li>Section 05: Statements for DATA</li><li>Section 06: Data Structure statements</li><li>Section 07: User Management</li><li>Section 08: Statement Basic</li><li>Section 10: Aggregate functions</li><li>Section 11: Query statements</li><li>Section 12: Group by statement</li><li>Section 13: JOINS for Multiple table Data Analysis</li><li>Section 14: Constraints</li><li>Section 16: Advanced SQL commands</li><li>Section 17: Stored procedures</li><li>Section 18: Azure Data Studio Visualization</li><li>Section 19: Azure Studio for Data Analysis</li><li>Section 20: Import &amp; Export data</li><li>Section 21: Backup and Restore Database</li></ul><p><strong>Course Assessment </strong></p><p>To simplify the procedure of evaluation and accreditation for learners, we provide an automated assessment system. Upon completing an online module, you will immediately be given access to a specifically crafted MCQ test. The results will be evaluated instantly, and the score will be displayed for your perusal. For each test, the pass mark will be set to 60%.</p><p>When all tests have been successfully passed, you will be able to order a certificate endorsed by the Quality Licence Scheme.</p><p><strong>Exam &amp; Retakes:</strong><br />It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable.</p><p><strong>Certification</strong><br />Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery).</p><h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>This SQL for Data Science, Data Analytics and Data Visualization course is designed to enhance your expertise and boost your CV. Learn key skills and gain a certificate of achievement to prove your newly-acquired knowledge.</p>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>This SQL for Data Science, Data Analytics and Data Visualization course is open to all, with no formal entry requirements.</p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>Upon successful completion of The SQL for Data Science, Data Analytics and Data Visualization Course, learners will be equipped with many indispensable skills and have the opportunity to grab.</p>
                        </div>

One Education

SQL for Data Science, Data Analytics and Data Visualization Course

<strong>A complete course on Sqoop, Flume, and Hive: Ideal for achieving CCA175 and Hortonworks Spark Certification</strong>
        <p>In this course, you will start by learning about the Hadoop Distributed File System (HDFS) and the most common Hadoop commands required to work with HDFS. Next, you'll be introduced to Sqoop Import, which will help you gain insights into the lifecycle of the Sqoop command and how to use the import command to migrate data from MySQL to HDFS, and from MySQL to Hive. 

In addition to this, you will get up to speed with Sqoop Export for migrating data effectively, along with using Apache Flume to ingest data. As you progress, you will delve into Apache Hive, external and managed tables, working with different files, and Parquet and Avro. Toward the concluding section, you will focus on Spark DataFrames and Spark SQL. 

By the end of this course, you will have gained comprehensive insights into big data ingestion and analytics with Flume, Sqoop, Hive, and Spark. 

All code and supporting files are available at - https://github.com/PacktPublishing/Master-Big-Data-Ingestion-and-Analytics-with-Flume-Sqoop-Hive-and-Spark</p>
        <h2>What You Will Learn</h2><p>Explore the Hadoop Distributed File System (HDFS) and commands <br>Get to grips with the lifecycle of the Sqoop command <br>Use the Sqoop Import command to migrate data from MySQL to HDFS and Hive <br>Understand split-by and boundary queries <br>Use the incremental mode to migrate data from MySQL to HDFS <br>Employ Sqoop Export to migrate data from HDFS to MySQL <br>Discover Spark DataFrames  and gain insights into  working with different file formats and compression</p>
        <h2>Audience</h2><p>This course is for anyone who wants to learn Sqoop and Flume or those looking to achieve CCA and HDP certification.</p>
        <h2>Approach</h2><p>A complete course packed with step-by-step instructions, working examples, and helpful advice. This course is systematically divided into small sections that will help you understand each part individually and learn at your own pace.</p>
        <h2>Key Features</h2><p>Learn Sqoop, Flume, and Hive and successfully achieve CCA175 and Hortonworks Spark Certification  * Understand the Hadoop Distributed File System (HDFS), along with exploring Hadoop commands to work effectively with HDFS</p>
        <h2>Github Repo</h2><p>https://github.com/packtpublishing/master-big-data-ingestion-and-analytics-with-flume-sqoop-hive-and-spark</p>
        <h2>About the Author</h2><h3>Navdeep Kaur</h3><p>Navdeep Kaur - Technical Trainer
Navdeep Kaur is a big data professionals with 11 years of industry experience in different technologies and domains. She has a keen interest in providing training in new technologies. She has received CCA175 Hadoop and Spark developer certification and AWS solution architect certification. She loves guiding people and helping them achieves new goals.</p>
        <h2>Course Outline</h2><h4>1. Hadoop Introduction</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. HDFS and Hadoop Commands</p><p style='margin: 0'>Hadoop Introduction: HDFS and Hadoop Commands</p></td></tr></tbody></table><br><h4>2. Sqoop Import</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Sqoop Introduction</p><p style='margin: 0'>Sqoop Import: Sqoop Introduction</p></td></tr><tr><td style='padding: 15px;'><p>2. Managing Target Directories</p><p style='margin: 0'>Sqoop Import: Managing Target Directories</p></td></tr><tr><td style='padding: 15px;'><p>3. Working with Different File Formats</p><p style='margin: 0'>Sqoop Import: Working with Different File Formats</p></td></tr><tr><td style='padding: 15px;'><p>4. Working with Different Compressions</p><p style='margin: 0'>Sqoop Import: Working with Different Compressions</p></td></tr><tr><td style='padding: 15px;'><p>5. Conditional Imports</p><p style='margin: 0'>Sqoop Import: Conditional Imports</p></td></tr><tr><td style='padding: 15px;'><p>6. Split-by and Boundary Queries</p><p style='margin: 0'>Sqoop Import: Split-by and Boundary Queries</p></td></tr><tr><td style='padding: 15px;'><p>7. Field delimeters</p><p style='margin: 0'>Sqoop Import: Field delimeters</p></td></tr><tr><td style='padding: 15px;'><p>8. Incremental Appends</p><p style='margin: 0'>Sqoop Import: Incremental Appends</p></td></tr><tr><td style='padding: 15px;'><p>9. Sqoop Hive Import</p><p style='margin: 0'>Sqoop Import: Sqoop Hive Import</p></td></tr><tr><td style='padding: 15px;'><p>10. Sqoop List Tables/Database</p><p style='margin: 0'>Sqoop Import: Sqoop List Tables/Database</p></td></tr><tr><td style='padding: 15px;'><p>11. Sqoop Import Practice1</p><p style='margin: 0'>Sqoop Import: Sqoop Import Practice1</p></td></tr><tr><td style='padding: 15px;'><p>12. Sqoop Import Practice2</p><p style='margin: 0'>Sqoop Import: Sqoop Import Practice2</p></td></tr><tr><td style='padding: 15px;'><p>13. Sqoop Import Practice3</p><p style='margin: 0'>Sqoop Import: Sqoop Import Practice3</p></td></tr></tbody></table><br><h4>3. Sqoop Export</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Export from Hdfs to Mysql</p><p style='margin: 0'>Sqoop Export: Export from Hdfs to Mysql</p></td></tr><tr><td style='padding: 15px;'><p>2. Export from Hive to Mysql</p><p style='margin: 0'>Sqoop Export: Export from Hive to Mysql</p></td></tr></tbody></table><br><h4>4. Apache Flume</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Flume Introduction & Architecture</p><p style='margin: 0'>Apache Flume: Flume Introduction & Architecture</p></td></tr><tr><td style='padding: 15px;'><p>2. Exec Source and Logger Sink</p><p style='margin: 0'>Apache Flume: Exec Source and Logger Sink</p></td></tr><tr><td style='padding: 15px;'><p>3. Moving data from Twitter to HDFS</p><p style='margin: 0'>Apache Flume: Moving data from Twitter to HDFS</p></td></tr><tr><td style='padding: 15px;'><p>4. Moving data from NetCat to HDFS</p><p style='margin: 0'>Apache Flume: Moving data from NetCat to HDFS</p></td></tr><tr><td style='padding: 15px;'><p>5. Flume Interceptors</p><p style='margin: 0'>Apache Flume: Flume Interceptors</p></td></tr><tr><td style='padding: 15px;'><p>6. Flume Interceptor Example</p><p style='margin: 0'>Apache Flume: Flume Interceptor Example</p></td></tr><tr><td style='padding: 15px;'><p>7. Flume Multi-Agent Flow</p><p style='margin: 0'>Apache Flume: Flume Multi-Agent Flow</p></td></tr><tr><td style='padding: 15px;'><p>8. Flume Consolidation</p><p style='margin: 0'>Apache Flume: Flume Consolidation</p></td></tr></tbody></table><br><h4>5. Apache Hive</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Hive Introduction</p><p style='margin: 0'>Apache Hive: Hive Introduction</p></td></tr><tr><td style='padding: 15px;'><p>2. Hive Database</p><p style='margin: 0'>Apache Hive: Hive Database</p></td></tr><tr><td style='padding: 15px;'><p>3. Hive Managed Tables</p><p style='margin: 0'>Apache Hive: Hive Managed Tables</p></td></tr><tr><td style='padding: 15px;'><p>4. Hive External Tables</p><p style='margin: 0'>Apache Hive: Hive External Tables</p></td></tr><tr><td style='padding: 15px;'><p>5. Hive Inserts</p><p style='margin: 0'>Apache Hive: Hive Inserts</p></td></tr><tr><td style='padding: 15px;'><p>6. Hive Analytics</p><p style='margin: 0'>Apache Hive: Hive Analytics</p></td></tr><tr><td style='padding: 15px;'><p>7. Working with Parquet</p><p style='margin: 0'>Apache Hive: Working with Parquet</p></td></tr><tr><td style='padding: 15px;'><p>8. Compressing Parquet</p><p style='margin: 0'>Apache Hive: Compressing Parquet</p></td></tr><tr><td style='padding: 15px;'><p>9. Working with Fixed File Format</p><p style='margin: 0'>Apache Hive: Working with Fixed File Format</p></td></tr><tr><td style='padding: 15px;'><p>10. Alter Command</p><p style='margin: 0'>Apache Hive: Alter Command</p></td></tr><tr><td style='padding: 15px;'><p>11. Hive String Functions</p><p style='margin: 0'>Apache Hive: Hive String Functions</p></td></tr><tr><td style='padding: 15px;'><p>12. Hive Date Functions</p><p style='margin: 0'>Apache Hive: Hive Date Functions</p></td></tr><tr><td style='padding: 15px;'><p>13. Hive Partitioning</p><p style='margin: 0'>Apache Hive: Hive Partitioning</p></td></tr><tr><td style='padding: 15px;'><p>14. Hive Bucketing</p><p style='margin: 0'>Apache Hive: Hive Bucketing</p></td></tr></tbody></table><br><h4>6. Spark Introduction</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Spark Introduction</p><p style='margin: 0'>Spark Introduction: Spark Introduction</p></td></tr><tr><td style='padding: 15px;'><p>2. Resilient Distributed Datasets</p><p style='margin: 0'>Spark Introduction: Resilient Distributed Datasets</p></td></tr><tr><td style='padding: 15px;'><p>3. Cluster Overview</p><p style='margin: 0'>Spark Introduction: Cluster Overview</p></td></tr><tr><td style='padding: 15px;'><p>4. Directed Acyclic Graph (DAG) & Stages</p><p style='margin: 0'>Spark Introduction: Directed Acyclic Graph (DAG) & Stages</p></td></tr></tbody></table><br><h4>7. Spark Transformations & Actions</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Map/FlatMap Transformation</p><p style='margin: 0'>Spark Transformations & Actions: Map/FlatMap Transformation</p></td></tr><tr><td style='padding: 15px;'><p>2. Filter/Intersection</p><p style='margin: 0'>Spark Transformations & Actions: Filter/Intersection</p></td></tr><tr><td style='padding: 15px;'><p>3. Union/Distinct Transformation</p><p style='margin: 0'>Spark Transformations & Actions: Union/Distinct Transformation</p></td></tr><tr><td style='padding: 15px;'><p>4. GroupByKey/ Group people based on Birthday months</p><p style='margin: 0'>Spark Transformations & Actions: GroupByKey/ Group people based on Birthday months</p></td></tr><tr><td style='padding: 15px;'><p>5. ReduceByKey / Total Number of students in each Subject</p><p style='margin: 0'>Spark Transformations & Actions: ReduceByKey / Total Number of students in each Subject</p></td></tr><tr><td style='padding: 15px;'><p>6. SortByKey / Sort students based on their rollno</p><p style='margin: 0'>Spark Transformations & Actions: SortByKey / Sort students based on their rollno</p></td></tr><tr><td style='padding: 15px;'><p>7. MapPartition / MapPartitionWithIndex</p><p style='margin: 0'>Spark Transformations & Actions: MapPartition / MapPartitionWithIndex</p></td></tr><tr><td style='padding: 15px;'><p>8. Change number of Partitions</p><p style='margin: 0'>Spark Transformations & Actions: Change number of Partitions</p></td></tr><tr><td style='padding: 15px;'><p>9. Join / Join email address based on customer name</p><p style='margin: 0'>Spark Transformations & Actions: Join / Join email address based on customer name</p></td></tr><tr><td style='padding: 15px;'><p>10. Spark Actions</p><p style='margin: 0'>Spark Transformations & Actions: Spark Actions</p></td></tr></tbody></table><br><h4>8. Spark RDD Practice</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Scala Tuples</p><p style='margin: 0'>Spark RDD Practice: Scala Tuples</p></td></tr><tr><td style='padding: 15px;'><p>2. Extract Error Logs from log files</p><p style='margin: 0'>Spark RDD Practice: Extract Error Logs from log files</p></td></tr><tr><td style='padding: 15px;'><p>3. Frequency of word in Text File</p><p style='margin: 0'>Spark RDD Practice: Frequency of word in Text File</p></td></tr><tr><td style='padding: 15px;'><p>4. Population of each City</p><p style='margin: 0'>Spark RDD Practice: Population of each City</p></td></tr><tr><td style='padding: 15px;'><p>5. Orders placed by Customers</p><p style='margin: 0'>Spark RDD Practice: Orders placed by Customers</p></td></tr><tr><td style='padding: 15px;'><p>6. Movie Average Rating greater than 3</p><p style='margin: 0'>Spark RDD Practice: Movie Average Rating greater than 3</p></td></tr></tbody></table><br><h4>9. Spark Dataframes & Spark SQL</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Dataframe Intro</p><p style='margin: 0'>Spark Dataframes & Spark SQL: Dataframe Intro</p></td></tr><tr><td style='padding: 15px;'><p>2. Dafaframe from Json Files</p><p style='margin: 0'>Spark Dataframes & Spark SQL: Dafaframe from Json Files</p></td></tr><tr><td style='padding: 15px;'><p>3. Dataframe from Parquet Files</p><p style='margin: 0'>Spark Dataframes & Spark SQL: Dataframe from Parquet Files</p></td></tr><tr><td style='padding: 15px;'><p>4. Dataframe from CSV Files</p><p style='margin: 0'>Spark Dataframes & Spark SQL: Dataframe from CSV Files</p></td></tr><tr><td style='padding: 15px;'><p>5. Dataframe from Avro/XML Files</p><p style='margin: 0'>Spark Dataframes & Spark SQL: Dataframe from Avro/XML Files</p></td></tr><tr><td style='padding: 15px;'><p>6. Working with Different Compressions</p><p style='margin: 0'>Spark Dataframes & Spark SQL: Working with Different Compressions</p></td></tr><tr><td style='padding: 15px;'><p>7. DataFrame API Part1</p><p style='margin: 0'>Spark Dataframes & Spark SQL: DataFrame API Part1</p></td></tr><tr><td style='padding: 15px;'><p>8. DataFrame API Part2</p><p style='margin: 0'>Spark Dataframes & Spark SQL: DataFrame API Part2</p></td></tr><tr><td style='padding: 15px;'><p>9. Spark SQL</p><p style='margin: 0'>Spark Dataframes & Spark SQL: Spark SQL</p></td></tr><tr><td style='padding: 15px;'><p>10. Working with Hive Tables in Spark</p><p style='margin: 0'>Spark Dataframes & Spark SQL: Working with Hive Tables in Spark</p></td></tr></tbody></table>

Packt

Hadoop

Database Administration

Big Data

A complete course on Sqoop, Flume, and Hive: Ideal for achieving CCA175 and Hortonworks Spark Certification

Master Big Data Ingestion and Analytics with Flume, Sqoop, Hive and Spark

<p>The Learn MySQL from Scratch for Data Science and Analytics is all you need to advance your career in the relevant fields.</p><p>Enrol now to discover everything you need to know about The Learn MySQL from Scratch for Data Science and Analytics and the skills to improve your talents in this field and be confident in your knowledge bucket with One Education as your right hand!</p><p><strong>Expert Support</strong></p><p>Dedicated tutor support and 24/7 customer support are available to all students with this premium quality course.</p><p><strong>Key Benefits</strong></p><ul><li>Learning materials of the Design course contain engaging voiceover and visual elements for your comfort.</li><li>Get 24/7 access to all content for a full year.</li><li>Each of our students gets full tutor support on weekdays (Monday to Friday)</li></ul><p><strong>Course Curriculum:</strong></p><p><strong>Section 01: Getting Started</strong></p><ul><li>Introduction</li><li>How to get course requirements</li><li>Getting started on Windows, Linux or Mac</li><li>How to ask great questions</li><li>FAQ's</li><li>What is Source Code?</li></ul><p><strong>Section 02: SQL Server setting up</strong></p><ul><li>Section Introduction</li><li>MySQL Server Installation</li><li>Connect MySQL Server Instance</li><li>MySQL Workbench overview</li><li>Download and Restore Sample Database</li></ul><p><strong>Section 03: SQL Database basics</strong></p><ul><li>Section Introduction</li><li>Overview of Databases</li><li>Creating Database</li><li>SQL Data Types</li><li>Column Data Types on Workbench</li><li>Creating Table</li><li>Overview of Primary and Foreign Key</li><li>Primary Key</li><li>Foreign Key</li><li>Creating Temporary tables</li><li>EER - Enhanced Entity Relationship Diagrams</li></ul><p><strong>Section 04: SQL DML (Data Manipulation Language)</strong></p><ul><li>Section Introduction</li><li>Insert statement</li><li>Update statement</li><li>Delete statement</li></ul><p><strong>Section 05: SQL DDL (Data Definition Language)</strong></p><ul><li>Section Introduction</li><li>CREATE table statement</li><li>DROP statement</li><li>ALTER statement</li><li>TRUNCATE statement</li><li>COMMENT in query</li><li>RENAME table</li></ul><p><strong>Section 06: SQL DCL (Data Control Language)</strong></p><ul><li>Create Database user</li><li>GRANT permissions</li><li>REVOKE permissions</li></ul><p><strong>Section 07: SQL Statement Basic</strong></p><ul><li>Section Introduction</li><li>SQL Statement basic</li><li>SELECT Statement</li><li>SELECT DISTINCT</li><li>SELECT with column headings</li><li>Column AS statement</li><li>DASHBOARD Analytics</li></ul><p><strong>Section 08: Filtering Data rows</strong></p><ul><li>SELECT WHERE Clause - theory</li><li>SELECT WHERE Clause - practical</li></ul><p><strong>Section 09: Aggregate functions for Data Analysis</strong></p><ul><li>Sum()</li><li>Min()-Max()</li></ul><p><strong>Section 10: SQL Data Analyticstatements</strong></p><ul><li>Order By statement</li><li>SELECT TOP 3 records</li><li>BETWEEN command</li><li>IN operator</li><li>Search Data usingLIKE cards</li></ul><p><strong>Section 11: SQL Group by statement</strong></p><ul><li>Section Introduction</li><li>Group by - theory</li><li>Data Analytics with Group By</li><li>HAVING statement</li></ul><p><strong>Section 12: JOINS</strong></p><ul><li>Overview of Joins</li><li>What are Joins</li><li>Inner join</li><li>Left outer join</li><li>Right outer join</li><li>Union</li><li>CERTESIAN Product or Cross Join</li><li>Query Exercise</li><li>Solution for Query Exercise</li></ul><p><strong>Section 13: SQL Constraints</strong></p><ul><li>Section introduction</li><li>Check constraint</li><li>NOT NULL constraint</li><li>UNIQUE constraint</li></ul><p><strong>Section 14: Views</strong></p><ul><li>Creating Views</li><li>Data Analytic Viewsfrom multiple tables</li></ul><p><strong>Section 15: Advanced SQL Functions</strong></p><ul><li>Section Introduction</li><li>Timestamp</li><li>Extract from timestamp</li><li>Mathematical scalar functions</li><li>String functions</li><li>Advanced functions</li><li>Sub Queries</li><li>SELECT with calculations</li></ul><p><strong>Section 16: SQL Stored procedures</strong></p><ul><li>Create stored procedure</li><li>Stored procedure with parameter</li><li>Drop Procedure</li></ul><p><strong>Section 17: Import &amp; Export data</strong></p><ul><li>Section Introduction</li><li>Import .csv file</li><li>Export Data to .csv file</li></ul><p><strong>Section 18: Backup and Restore Database</strong></p><ul><li>Section Introduction</li><li>Creating Database backup</li><li>Restoring Database backup</li></ul><p><strong>Exam &amp; Retakes:</strong><br />It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable.</p><p><strong>Certification</strong><br />Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery).</p><h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>This Learn MySQL from Scratch for Data Science and Analytics course is designed to enhance your expertise and boost your CV. Learn key skills and gain a certificate of achievement to prove your newly-acquired knowledge.</p>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>This Learn MySQL from Scratch for Data Science and Analytics course is open to all, with no formal entry requirements.</p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>Upon successful completion of The Learn MySQL from Scratch for Data Science and Analytics Course, learners will be equipped with many indispensable skills and have the opportunity to grab.</p>
                        </div>

Learn MySQL from Scratch for Data Science and Analytics Course

<p>Unlock the power of data with our "Creating Compelling Data Visualisations" course. From mastering the fundamentals of data analytics and statistics to leveraging cutting-edge tools and techniques, each module is designed to transform raw information into impactful visual stories. Gain the skills to captivate your audience and drive data-driven decisions with clarity and precision. Enrol now and become a master of data visualisation!</p><p><strong>Learning Outcomes:</strong></p><ul><li>Acquire a comprehensive understanding of data analytics and its role in decision-making.</li><li>Develop proficiency in using statistical techniques to analyse and interpret data accurately.</li><li>Master the process of gathering and organising data efficiently for optimal analysis.</li><li>Utilise Excel as a powerful tool for data manipulation and analysis.</li><li>Explore various tools and technologies employed in data analytics.</li><li>Cultivate a data-analytic mindset to identify actionable insights from complex data sets.</li><li>Create visually compelling data visualisations that effectively communicate insights and facilitate data-driven decision-making.</li></ul><p>In today's data-driven world, the ability to transform raw information into meaningful insights is a crucial skill for professionals across industries. Introducing our comprehensive course on "Creating Compelling Data Visualisations," designed to equip you with the knowledge and techniques to excel in the realm of data analytics.</p><p>Through a series of immersive modules, you'll delve into the fascinating world of data, exploring its intricacies, gathering the right information, and storing it efficiently. Dive deep into statistical analysis, mastering the art of drawing insights from complex datasets with precision and accuracy. Discover the power of Excel as a robust tool for data manipulation and analysis.</p><p>Unleash your creativity as you learn to transform raw data into captivating visual stories. Explore a range of data visualisation tools and techniques, uncovering the best practices to effectively communicate insights to diverse audiences. Develop a data-analytic mindset, sharpening your ability to identify actionable insights and make data-driven decisions that propel your organisation forward.</p><p><strong>Certification</strong></p><p>Upon completion of the course, learners can obtain a certificate as proof of their achievement. You can receive a <strong>£4.99 </strong>PDF Certificate sent via email, a <strong>£9.99 </strong>Printed Hardcopy Certificate for delivery in the UK, or a <strong>£19.99</strong> Printed Hardcopy Certificate for international delivery. Each option depends on individual preferences and locations.</p><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        15 CPD hours / points
                                    </div>
                                        <div>
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div><h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>This course is particularly useful for:</p><ul><li>Professionals seeking to enhance their data analysis skills.</li><li>Aspiring data analysts and researchers.</li><li>Managers and decision-makers who need to interpret and communicate data effectively.</li><li>Students and graduates looking to boost their employability in the data-driven job market.</li></ul>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <ul><li>Data Analyst: £25,000 - £50,000 per year</li><li>Business Intelligence Analyst: £30,000 - £60,000 per year</li><li>Data Visualization Specialist: £35,000 - £70,000 per year</li><li>Data Scientist: £40,000 - £80,000 per year</li><li>Market Research Analyst: £25,000 - £45,000 per year</li><li>Financial Analyst: £30,000 - £60,000 per year</li></ul><p>Note: Salary ranges can vary based on factors such as experience, qualification, and industry.</p>
                        </div>

NextGen Learning

Business Analytics & Intelligence

Excel Analytics

Big Data Analytics

Data Skills

Data Analyst

Creating Compelling Data Visualisations

<div id="course-pills-1">Duration<p>4 Days</p><p>24 CPD hours</p>This course is intended for<p></p><p>Students in this course are interested in designing and implementing DevOps processes or in passing the Microsoft Azure DevOps Solutions certification exam.</p><p></p><p></p><p>This course provides the knowledge and skills to design and implement DevOps processes and practices. Students will learn how to plan for DevOps, use source control, scale Git for an enterprise, consolidate artifacts, design a dependency management strategy, manage secrets, implement continuous integration, implement a container build strategy, design a release strategy, set up a release management workflow, implement a deployment pattern, and optimize feedback mechanisms</p><p></p>Prerequisites<p>Successful learners will have prior knowledge and understanding of:  </p><ul> <li>Cloud computing concepts, including an understanding of PaaS, SaaS, and IaaS implementations.</li> <li>Both Azure administration and Azure development with proven expertise in at least one of these areas.</li> <li>Version control, Agile software development, and core software development principles. It would be helpful to have experience in an organization that delivers software. </li> <li>AZ-104T00 - Microsoft Azure Administrator</li>   <li>AZ-204T00: Developing Solutions for Microsoft Azure</li> </ul><p></p></div><div id="course-pills-2"><h3>1 - Introduction to DevOps</h3> <ul> <li>What is DevOps?</li> <li>Explore the DevOps journey</li> <li>Identify transformation teams</li> <li>Explore shared goals and define timelines</li> </ul> <h3>2 - Choose the right project</h3> <ul> <li>Explore greenfield and brownfield projects</li> <li>Decide when to use greenfield and brownfield projects</li> <li>Decide when to use systems of record versus systems of engagement</li> <li>Identify groups to minimize initial resistance</li> <li>Identify project metrics and key performance indicators (KPIs)</li> </ul> <h3>3 - Describe team structures</h3> <ul> <li>Explore agile development practices</li> <li>Explore principles of agile development</li> <li>Define organization structure for agile practices</li> <li>Explore ideal DevOps team members</li> <li>Enable in-team and cross-team collaboration</li> <li>Select tools and processes for agile practices</li> </ul> <h3>4 - Choose the DevOps tools</h3> <ul> <li>What is Azure DevOps?</li> <li>What is GitHub?</li> <li>Explore an authorization and access strategy</li> <li>Migrate or integrate existing work management tools</li> <li>Migrate or integrate existing test management tools</li> <li>Design a license management strategy</li> </ul> <h3>5 - Plan Agile with GitHub Projects and Azure Boards</h3> <ul> <li>Link GitHub to Azure Boards</li> <li>Configure GitHub Projects</li> <li>Manage work with GitHub Project boards</li> <li>Customize Project views</li> <li>Collaborate using team discussions</li> <li>Agile Plan and Portfolio Management with Azure Boards</li> </ul> <h3>6 - Introduction to source control</h3> <ul> <li>Explore DevOps foundational practices</li> <li>What is source control?</li> <li>Explore benefits of source control</li> <li>Explore best practices for source control</li> </ul> <h3>7 - Describe types of source control systems</h3> <ul> <li>Understand centralized source control</li> <li>Understand distributed source control</li> <li>Explore Git and Team Foundation Version Control</li> <li>Examine and choose Git</li> <li>Understand objections to using Git</li> <li>Describe working with Git locally</li> </ul> <h3>8 - Work with Azure Repos and GitHub</h3> <ul> <li>Migrate from TFVC to Git</li> <li>Use GIT-TFS</li> <li>Develop online with GitHub Codespaces</li> </ul> <h3>9 - Structure your Git Repo</h3> <ul> <li>Explore monorepo versus multiple repos</li> <li>Implement a change log</li> </ul> <h3>10 - Manage Git branches and workflows</h3> <ul> <li>Explore branch workflow types</li> <li>Explore feature branch workflow</li> <li>Explore Git branch model for continuous delivery</li> <li>Explore GitHub flow</li> <li>Explore fork workflow</li> <li>Version Control with Git in Azure Repos</li> </ul> <h3>11 - Collaborate with pull requests in Azure Repos</h3> <ul> <li>Collaborate with pull requests</li> <li>Examine GitHub mobile for pull request approvals</li> </ul> <h3>12 - Identify technical debt</h3> <ul> <li>Examine code quality</li> <li>Examine complexity and quality metrics</li> <li>Measure and manage technical debt</li> <li>Integrate other code quality tools</li> <li>Plan effective code reviews</li> </ul> <h3>13 - Explore Git hooks</h3> <ul> <li>Implement Git hooks</li> </ul> <h3>14 - Plan foster inner source</h3> <ul> <li>Explore foster inner source</li> <li>Implement the fork workflow</li> <li>Describe inner source with forks</li> </ul> <h3>15 - Manage Git repositories</h3> <ul> <li>Work with large repositories</li> <li>Purge repository data</li> <li>Manage releases with GitHub Repos</li> <li>Automate release notes with GitHub</li> </ul> <h3>16 - Explore Azure Pipelines</h3> <ul> <li>Explore the concept of pipelines in DevOps</li> <li>Describe Azure Pipelines</li> <li>Understand Azure Pipelines key terms</li> </ul> <h3>17 - Manage Azure Pipeline agents and pools</h3> <ul> <li>Choose between Microsoft-hosted versus self-hosted agents</li> <li>Explore job types</li> <li>Explore predefined agent pool</li> <li>Understand typical situations for agent pools</li> <li>Communicate with Azure Pipelines</li> <li>Communicate to deploy to target servers</li> <li>Examine other considerations</li> <li>Describe security of agent pools</li> <li>Configure agent pools and understanding pipeline styles</li> </ul> <h3>18 - Describe pipelines and concurrency</h3> <ul> <li>Understand parallel jobs</li> <li>Estimate parallel jobs</li> <li>Describe Azure Pipelines and open-source projects</li> <li>Explore Azure Pipelines and Visual Designer</li> <li>Describe Azure Pipelines and YAML</li> </ul> <h3>19 - Explore continuous integration</h3> <ul> <li>Learn the four pillars of continuous integration</li> <li>Explore benefits of continuous integration</li> <li>Describe build properties</li> <li>Enable Continuous Integration with Azure Pipelines</li> </ul> <h3>20 - Implement a pipeline strategy</h3> <ul> <li>Configure agent demands</li> <li>Implement multi-agent builds</li> <li>Explore source control types supported by Azure Pipelines</li> </ul> <h3>21 - Integrate with Azure Pipelines</h3> <ul> <li>Describe the anatomy of a pipeline</li> <li>Understand the pipeline structure</li> <li>Detail templates</li> <li>Explore YAML resources</li> <li>Use multiple repositories in your pipeline</li> </ul> <h3>22 - Introduction to GitHub Actions</h3> <ul> <li>What are Actions?</li> <li>Explore Actions flow</li> <li>Understand workflows</li> <li>Describe standard workflow syntax elements</li> <li>Explore events</li> <li>Explore jobs</li> <li>Explore runners</li> <li>Examine release and test an action</li> </ul> <h3>23 - Learn continuous integration with GitHub Actions</h3> <ul> <li>Describe continuous integration with actions</li> <li>Examine environment variables</li> <li>Share artifacts between jobs</li> <li>Examine Workflow badges</li> <li>Describe best practices for creating actions</li> <li>Mark releases with Git tags</li> <li>Create encrypted secrets</li> <li>Use secrets in a workflow</li> <li>Implement GitHub Actions for CI/CD</li> </ul> <h3>24 - Design a container build strategy</h3> <ul> <li>Examine structure of containers</li> <li>Work with Docker containers</li> <li>Understand Dockerfile core concepts</li> <li>Examine multi-stage dockerfiles</li> <li>Examine considerations for multiple stage builds</li> <li>Explore Azure container-related services</li> <li>Deploy Docker containers to Azure App Service web apps</li> </ul> <h3>25 - Introduction to continuous delivery</h3> <ul> <li>Explore traditional IT development cycle</li> <li>What is continuous delivery?</li> <li>Move to continuous delivery</li> <li>Understand releases and deployments</li> <li>Understand release process versus release</li> </ul> <h3>26 - Create a release pipeline</h3> <ul> <li>Describe Azure DevOps release pipeline capabilities</li> <li>Explore release pipelines</li> <li>Explore artifact sources</li> <li>Choose the appropriate artifact source</li> <li>Examine considerations for deployment to stages</li> <li>Explore build and release tasks</li> <li>Explore custom build and release tasks</li> <li>Explore release jobs</li> <li>Configure Pipelines as Code with YAML</li> </ul> <h3>27 - Explore release recommendations</h3> <ul> <li>Understand the delivery cadence and three types of triggers</li> <li>Explore release approvals</li> <li>Explore release gates</li> <li>Use release gates to protect quality</li> <li>Control Deployments using Release Gates</li> </ul> <h3>28 - Provision and test environments</h3> <ul> <li>Provision and configure target environments</li> <li>Configure automated integration and functional test automation</li> <li>Understand Shift-left</li> <li>Set up and run availability tests</li> <li>Explore Azure Load Testing</li> <li>Set up and run functional tests</li> </ul> <h3>29 - Manage and modularize tasks and templates</h3> <ul> <li>Examine task groups</li> <li>Explore variables in release pipelines</li> <li>Understand variable groups</li> </ul> <h3>30 - Automate inspection of health</h3> <ul> <li>Automate inspection of health</li> <li>Explore events and notifications</li> <li>Explore service hooks</li> <li>Configure Azure DevOps notifications</li> <li>Configure GitHub notifications</li> <li>Explore how to measure quality of your release process</li> <li>Examine release notes and documentation</li> <li>Examine considerations for choosing release management tools</li> <li>Explore common release management tools</li> </ul> <h3>31 - Introduction to deployment patterns</h3> <ul> <li>Explore microservices architecture</li> <li>Examine classical deployment patterns</li> <li>Understand modern deployment patterns</li> </ul> <h3>32 - Implement blue-green deployment and feature toggles</h3> <ul> <li>What is blue-green deployment?</li> <li>Explore deployment slots</li> <li>Describe feature toggle maintenance</li> </ul> <h3>33 - Implement canary releases and dark launching</h3> <ul> <li>Explore canary releases</li> <li>Examine Traffic Manager</li> <li>Understand dark launching</li> </ul> <h3>34 - Implement A/B testing and progressive exposure deployment</h3> <ul> <li>What is A/B testing?</li> <li>Explore CI-CD with deployment rings</li> </ul> <h3>35 - Integrate with identity management systems</h3> <ul> <li>Integrate GitHub with single sign-on (SSO)</li> <li>Explore service principals</li> <li>Explore Managed Identity</li> </ul> <h3>36 - Manage application configuration data</h3> <ul> <li>Rethink application configuration data</li> <li>Explore separation of concerns</li> <li>Understand external configuration store patterns</li> <li>Examine Key-value pairs</li> <li>Examine App configuration feature management</li> <li>Integrate Azure Key Vault with Azure Pipelines</li> <li>Manage secrets, tokens and certificates</li> <li>Examine DevOps inner and outer loop</li> <li>Integrate Azure Key Vault with Azure DevOps</li> <li>Enable Dynamic Configuration and Feature Flags</li> </ul> <h3>37 - Explore infrastructure as code and configuration management</h3> <ul> <li>Explore environment deployment</li> <li>Examine environment configuration</li> <li>Understand imperative versus declarative configuration</li> <li>Understand idempotent configuration</li> </ul> <h3>38 - Create Azure resources using Azure Resource Manager templates</h3> <ul> <li>Why use Azure Resource Manager templates?</li> <li>Explore template components</li> <li>Manage dependencies</li> <li>Modularize templates</li> <li>Manage secrets in templates</li> <li>Deployments using Azure Bicep templates</li> </ul> <h3>39 - Create Azure resources by using Azure CLI</h3> <ul> <li>What is Azure CLI?</li> <li>Work with Azure CLI</li> </ul> <h3>40 - Explore Azure Automation with DevOps</h3> <ul> <li>Create automation accounts</li> <li>What is a runbook?</li> <li>Understand automation shared resources</li> <li>Explore runbook gallery</li> <li>Examine webhooks</li> <li>Explore source control integration</li> <li>Explore PowerShell workflows</li> <li>Create a workflow</li> <li>Examine checkpoint and parallel processing</li> </ul> <h3>41 - Implement Desired State Configuration (DSC)</h3> <ul> <li>Understand configuration drift</li> <li>Explore Desired State Configuration (DSC)</li> <li>Explore Azure Automation State configuration (DSC)</li> <li>Examine DSC configuration file</li> <li>Explore hybrid management</li> <li>Implement DSC and Linux Automation on Azure</li> </ul> <h3>42 - Implement Bicep</h3> <ul> <li>What is Bicep?</li> <li>Install Bicep</li> <li>Understand Bicep file structure and syntax</li> </ul> <h3>43 - Introduction to Secure DevOps</h3> <ul> <li>Describe SQL injection attack</li> <li>Understand DevSecOps</li> <li>Explore Secure DevOps Pipeline</li> <li>Explore key validation points</li> <li>Explore continuous security validation</li> <li>Understand threat modeling</li> </ul> <h3>44 - Implement open-source software</h3> <ul> <li>Explore how software is built</li> <li>What is open-source software</li> <li>Explore corporate concerns with open-source software components</li> <li>Explore common open-source licenses</li> <li>Examine license implications and ratings</li> </ul> <h3>45 - Software Composition Analysis</h3> <ul> <li>Inspect and validate code bases for compliance</li> <li>Explore software composition analysis (SCA)</li> <li>Integrate Mend with Azure Pipelines</li> <li>Implement GitHub Dependabot alerts and security updates</li> <li>Integrate software composition analysis checks into pipelines</li> <li>Examine tools for assess package security and license rate</li> <li>Interpret alerts from scanner tools</li> <li>Implement security and compliance in an Azure Pipeline</li> </ul> <h3>46 - Static analyzers</h3> <ul> <li>Explore SonarCloud</li> <li>Explore CodeQL in GitHub</li> <li>Manage technical debt with SonarCloud and Azure DevOps</li> </ul> <h3>47 - OWASP and Dynamic Analyzers</h3> <ul> <li>Plan Implement OWASP Secure Coding Practices</li> <li>Explore OWASP ZAP penetration test</li> <li>Explore OWASP ZAP results and bugs</li> </ul> <h3>48 - Security Monitoring and Governance</h3> <ul> <li>Implement pipeline security</li> <li>Explore Microsoft Defender for Cloud</li> <li>Examine Microsoft Defender for Cloud usage scenarios</li> <li>Explore Azure Policy</li> <li>Understand policies</li> <li>Explore initiatives</li> <li>Explore resource locks</li> <li>Explore Azure Blueprints</li> <li>Understand Microsoft Defender for Identity</li> </ul> <h3>49 - Explore package dependencies</h3> <ul> <li>What is dependency management?</li> <li>Describe elements of a dependency management strategy</li> <li>Identify dependencies</li> <li>Understand source and package componentization</li> <li>Decompose your system</li> <li>Scan your codebase for dependencies</li> </ul> <h3>50 - Understand package management</h3> <ul> <li>Explore packages</li> <li>Understand package feeds</li> <li>Explore package feed managers</li> <li>Explore common public package sources</li> <li>Explore self-hosted and SaaS based package sources</li> <li>Consume packages</li> <li>Publish packages</li> <li>Package management with Azure Artifacts</li> </ul> <h3>51 - Migrate consolidating and secure artifacts</h3> <ul> <li>Identify existing artifact repositories</li> <li>Migrate and integrating artifact repositories</li> <li>Secure access to package feeds</li> <li>Examine roles</li> <li>Examine permissions</li> <li>Examine authentication</li> </ul> <h3>52 - Implement a versioning strategy</h3> <ul> <li>Understand versioning of artifacts</li> <li>Explore semantic versioning</li> <li>Examine release views</li> <li>Promote packages</li> <li>Explore best practices for versioning</li> </ul> <h3>53 - Introduction to GitHub Packages</h3> <ul> <li>Publish packages</li> <li>Install a package</li> <li>Delete and restore a package</li> <li>Explore package access control and visibility</li> </ul> <h3>54 - Implement tools to track usage and flow</h3> <ul> <li>Understand the inner loop</li> <li>Explore Azure Monitor and Log Analytics</li> <li>Examine Kusto Query Language (KQL)</li> <li>Explore Application Insights</li> <li>Implement Application Insights</li> <li>Monitor application performance with Application Insights</li> </ul> <h3>55 - Develop monitor and status dashboards</h3> <ul> <li>Explore Azure Dashboards</li> <li>Examine view designer in Azure Monitor</li> <li>Explore Azure Monitor workbooks</li> <li>Explore Power BI</li> <li>Build your own custom application</li> </ul> <h3>56 - Share knowledge within teams</h3> <ul> <li>Share acquired knowledge within development teams</li> <li>Integrate with Azure Boards</li> <li>Share team knowledge using Azure Project Wiki</li> </ul> <h3>57 - Design processes to automate application analytics</h3> <ul> <li>Explore rapid responses and augmented search</li> <li>Integrate telemetry</li> <li>Examine monitoring tools and technologies</li> </ul> <h3>58 - Manage alerts, blameless retrospectives and a just culture</h3> <ul> <li>Examine when get a notification</li> <li>Explore how to fix it</li> <li>Explore smart detection notifications</li> <li>Improve performance</li> <li>Understand server response time degradation</li> <li>Reduce meaningless and non-actionable alerts</li> <li>Examine blameless retrospective</li> <li>Develop a just culture</li> </ul></div>

Nexus Human

DevOps

Microsoft AZ-900

Microsoft AZ-104

Microsoft Azure

Microsoft AZ-303

Microsoft AZ-700

AZ-400T00 Designing and Implementing Microsoft DevOps Solutions

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p></p><li>Network Security Operations</li><br /><li>Workload Application Administrators</li><br /><li>Security Operations</li><br /><li>Field Engineers</li><br /><li>Network Engineers</li><br /><li>Systems Engineers</li><br /><li>Technical Solutions Architects</li><br /><li>Cisco Integrators and Partners</li><p></p>Overview<p>After taking this course, you should be able to:<br /></p><li>Define the Cisco telemetry and analytics approach.</li><br /><li>Explore common scenarios that Cisco Tetration Analytics can solve.</li><br /><li>Describe how the Cisco Tetration Analytics platform collects telemetry and other context information.</li><br /><li>Discuss how relative agents are installed and configured.</li><br /><li>Explore the operational aspects of the Cisco Tetration Analytics platform.</li><br /><li>Describe the Cisco Tetration Analytics support for application visibility or application insight based on the Application Dependency Mapping (ADM) feature.</li><br /><li>List the concepts of the intent-based declarative network management automation model.</li><br /><li>Describe the Cisco Tetration policy enforcement pipeline, components, functions, and implementation of application policy.</li><br /><li>Describe how to use Cisco Tetration Analytics for workload protection in order to provide a secure infrastructure for business-critical applications and data.</li><br /><li>Describe Cisco Tetration Analytics platform use cases in the modern heterogeneous, multicloud data center.</li><br /><li>List the options for the Cisco Tetration Analytics platform enhancements.</li><br /><li>Explain how to perform the Cisco Tetration Analytics administration.</li><p></p><p>This course teaches how to deploy, use, and operate CiscoÂ© Tetration Analytics? platform for comprehensive workload-protection and application and network insights across a multicloud infrastructure. You will learn how the Cisco Tetration Analytics platform uses streaming telemetry, behavioral analysis, unsupervised machine learning, analytical intelligence, and big data analytics to deliver pervasive visibility, automated intent-based policy, workload protection, and performance management.</p></div><div id="course-pills-2"><h4>Exploring Cisco Tetration</h4><ul><li>Data Center Challenges</li><li>Define and Position Cisco Tetration</li><li>Cisco Tetration Features</li><li>Cisco Tetration Architecture</li><li>Cisco Tetration Deployment Models</li><li>Cisco Tetration GUI Overview</li></ul><h4>Implementing and Operating Cisco Tetration</h4><ul><li>Explore Data Collection</li><li>Install the Software Agent</li><li>Install the Hardware Agent</li><li>Import Context Data</li><li>Describe Cisco Tetration Operational Concepts</li></ul><h4>Examining Cisco Tetration ADM and Application Insight</h4><ul><li>Describe Cisco Tetration Application Insight</li><li>Perform ADM</li><li>Interpret ADM Results Application Visibility</li></ul><h4>Examining Cisco Tetration Intent-Based Networking</h4><ul><li>Describe Intent-Based Policy</li><li>Examine Policy Features</li><li>Implement Policies</li></ul><h4>Enforcing Tetration Policy Pipeline and Compliance</h4><ul><li>Examine Policy Enforcement</li><li>Implement Application Policy</li><li>Examine Policy Compliance Verification and Simulation</li></ul><h4>Examining Tetration Security Use Cases</h4><ul><li>Examine Workload Security</li><li>Attack Prevention</li><li>Attack Detection</li><li>Attack Remediation</li></ul><h4>Examining IT Operations Use Cases</h4><ul><li>Key Features and IT Operations Use Cases</li><li>Performing Operations in Neighborhood App-based Use Cases</li></ul><h4>Examining Platform Enhancement Use Cases</h4><ul><li>Integrations and Advanced Features</li><li>Third-party Integration Examples</li><li>Explore Data Platform Capabilities</li></ul><h4>Exploring Cisco Tetration Analytics Administration</h4><ul><li>Examine User Authentication and Authorization</li><li>Examine Cluster Management</li><li>Configure Alerts and Syslog</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Cisco Implementing Cisco Tetration Analytics v1.0 (DCITET) 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 Cisco Implementing Cisco Tetration Analytics v1.0 (DCITET) 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>

Cisco Certified Network Associate (CCNA)

Certified Technology Specialist (CTS)

CompTIA Network+

IT Certifications

Cisco Certified Entry Networking Technician (CCENT)

Cisco Certified Internetwork Expert (CCIE)

Cisco Implementing Cisco Tetration Analytics v1.0 (DCITET)

<p>Embark on a transformative journey as a Financial Advisor with our course, "Google Analytics and Financial Planning for Financial Advisors." Gain insights into the fascinating world of finance, master essential skills, and explore the power of Google Analytics to drive data-driven decision-making. By combining financial expertise with cutting-edge technology, you'll unlock new opportunities to provide tailored financial advice and guide clients towards their financial goals, solidifying your position as a trusted Financial Advisor in today's digital age.</p><p><strong>Learning Outcomes:</strong></p><ul><li>Develop a strong foundation in finance, understanding key concepts and principles essential for a Financial Advisor.</li><li>Acquire essential skills necessary for effective financial advising, including client communication, relationship building, and ethical practices.</li><li>Gain expertise in financial planning, assisting clients in creating comprehensive financial strategies to achieve their goals.</li><li>Explore wealth management principles and learn to guide clients in making personal financial statements for informed decision-making.</li><li>Master financial risk management techniques, ensuring clients' portfolios are well protected and optimised.</li><li>Learn investment planning strategies, enabling you to analyse investment opportunities and provide sound advice to clients.</li></ul><p>Our course, "Google Analytics and Financial Planning for Financial Advisors," offers a unique blend of financial expertise and digital proficiency. Delve into the fundamental concepts of finance, acquiring the knowledge necessary to excel as a Financial Advisor. Explore essential skills for financial advisors, including effective communication, relationship building, and ethical practices, equipping you to establish trust and rapport with clients.</p><p>Unlock the realm of financial planning, where you'll learn how to develop comprehensive strategies tailored to clients' financial goals. Dive into wealth management principles, gaining insights into creating personal financial statements and guiding clients towards better financial decisions. Master financial risk management techniques, ensuring clients' portfolios are shielded from potential risks.</p><p><strong>Certification</strong></p><p>Upon successful completion of the course, all learners will be eligible to receive a certificate titled Financial Advisor to acknowledge their achievement. We are delighted to offer two formats for your certificate: <strong>PDF and Hardcopy.</strong></p><p><strong>PDF Certificate</strong>: This digital version of your certificate will be available for you to download and print for totally <strong>FREE</strong>. </p><p><strong>Hard copy Certificate</strong>: For those who wish to have a physical token of their achievement, we offer a high-quality, printed certificate. This hardcopy certificate is also provided free of charge. However, please note that delivery fees apply.</p><p>UK Delivery: If your shipping address is within the United Kingdom, the delivery fee will be only<strong> £3.99.</strong></p><p><strong>International Delivery:</strong> For all international addresses outside of the United Kingdom, the delivery fee will be only <strong>£10</strong>. </p><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        10 CPD hours / points
                                    </div>
                                        <div>
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div><h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <ul><li>Aspiring Financial Advisors seeking to establish a successful career in the finance industry.</li><li>Finance professionals looking to enhance their skills and integrate data analytics into their financial advisory services.</li><li>Individuals with a passion for finance and a desire to guide others towards their financial goals.</li><li>Business owners and entrepreneurs who want to gain a deeper understanding of financial planning and wealth management for their enterprises.</li></ul>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <ul><li>Financial Advisor: £25,000 - £60,000 per year</li><li>Wealth Manager: £30,000 - £70,000 per year</li><li>Investment Analyst: £35,000 - £80,000 per year</li><li>Financial Planner: £30,000 - £60,000 per year</li><li>Risk Manager: £40,000 - £90,000 per year</li><li>Portfolio Manager: £45,000 - £100,000 per year</li></ul>
                        </div><h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Digital certificate</h4>
        <p>
            Digital certificate -
            Included
        </p>
        <h4>Hard copy certificate</h4>
        <p>
            Hard copy certificate -
            Included
        </p>
            <div><p><strong>Hardcopy Certificate (UK Delivery):</strong></p><p>For those who wish to have a physical token of their achievement, we offer a high-quality, printed certificate. This hardcopy certificate is also provided free of charge. However, please note that delivery fees apply. If your shipping address is within the United Kingdom, the delivery fee will be only <strong>£3.99</strong>.</p><p><strong>Hardcopy Certificate (International Delivery): </strong></p><p>For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only <strong>£10</strong>.</p></div>

                        </div>

Training Express

Google Analytics and Financial Planning for Financial Advisors Course

<p>This comprehensive Administrative Professional Development Bundle is your gateway to a world of possibilities! We've combined the magic of data manipulation, the precision of document control, and the versatility of virtual assistance into one comprehensive program. Become a data entry virtuoso, transform information into insightful stories, and provide seamless virtual support - all while ensuring meticulous document management. This bundle is your passport to a career brimming with variety, challenge, and endless opportunities for growth. </p><p>We've meticulously curated this program to equip you with the most sought-after skills in today's data-driven workplace. You'll master the fundamentals of data entry, transform data into insightful visualisations with Google Data Studio, ensure document accuracy through document control procedures, and provide comprehensive virtual assistant services to clients.</p><p><strong>This bundle is your key to:</strong></p><ul><li>A dynamic and fulfilling career</li><li>Standing out from the crowd with a diverse skillset</li><li>Increased earning potential</li><li>Career flexibility - work remotely or in an office!</li></ul><p>Don't just survive your workday, thrive in it!  Enrol today and unlock your full administrative potential.</p><p>This power-packed bundle combines six specialised courses, each designed to equip you with practical knowledge and industry-recognised skills:</p><ul><li><strong>Data Entry:</strong> Become a data whiz! This course delves into accurate and efficient data input methods, teaching you to handle large datasets with speed and precision. You'll also master data quality control techniques to ensure the integrity of the information you manage. Brush up on your typing skills to further enhance your efficiency.</li><li><strong>Data Analytics: </strong>Unleash the power of data storytelling! Learn how to transform raw data into compelling and informative visualisations using Google's user-friendly Data Studio platform. This course equips you with the skills to create clear and concise dashboards and reports, empowering you to communicate insights effectively.</li><li><strong>Document Control:</strong> Ensure information accuracy and accessibility! Master the art of document creation, editing, version control, and archiving procedures. This course equips you with the skills to maintain a well-organized document management system, streamlining workflows and guaranteeing information retrieval efficiency.</li><li><strong>Virtual Assistant:</strong> Become a one-stop shop for remote support! Develop the proficiency to provide administrative, technical, and creative assistance to clients virtually. Learn how to manage schedules, emails, calendars, and travel arrangements, while also mastering essential technical skills to support clients effectively. </li><li><strong>Google Data Studio: Data Analytics: </strong>This Data Analytics training covers the entire learning curve for GDS and how to get the greatest benefits out of it. You will be taught the fundamentals of Google Sheets, including queries and calculations. Following that, you will have a masterclass on GDS, covering everything from field computation to layout design and meeting a client's page needs.  </li><li><strong>Vendor Documentation:</strong> Craft clear and user-friendly instructions! This course dives into the principles of creating vendor documentation, ensuring smooth product implementation and user adoption. Learn how to write concise instructions, develop user guides, and design effective training materials.</li></ul><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        20 CPD hours / points
                                    </div>
                                        <div>
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div><h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>Are you someone who:</p><ul><li><strong>Craves Variety:</strong> This bundle offers a diverse range of skills, ensuring you never get stuck in a monotonous routine.</li><li><strong>Loves a Challenge:</strong> The program pushes you to learn new skills and become a well-rounded administrative professional.</li><li><strong>Thrives in a Data-Driven World:</strong> If you find data fascinating and want to unlock its power, this bundle equips you to manage and analyze information effectively.</li><li><strong>Dreams of Remote Work:</strong> Master virtual assistant skills and open doors to a flexible and location-independent career.</li><li><strong>Wants to Make a Difference:</strong> Your skills will empower businesses to operate efficiently and users to navigate complex systems.</li></ul><p>If you answered yes to any of these, then this Rockstar Admin Bundle is tailor-made for you! </p>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>Basic computer literacy and a willingness to learn are essential for success in this program.  Prior experience in any of the covered areas is a plus but not mandatory.</p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>By successfully completing this diploma bundle, you'll unlock a world of exciting career opportunities.  Potential career paths include:</p><ul><li>Data Entry Clerk</li><li>Data Analyst</li><li>Document Control Specialist </li><li>Virtual Assistant</li><li>Business Analyst</li><li>Information Specialist</li></ul>
                        </div><h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certification of completion</h4>
        <p>
            Digital certificate -
            £9
        </p>
            <div><p>Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of £9 for PDF Certificate.</p></div>
        <h4>Certification of completion </h4>
        <p>
            Hard copy certificate -
            £15
        </p>
            <div><p>Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery).</p></div>

                        </div>

Level 3 Data Entry, Data Analytics, Document Control & Virtual Assistant Diploma Course

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p>Applications consultants, business analysts, business process owners, developer consultants, help desk consultants, project managers, and technology consultants.</p>Overview<p>This course will prepare you to:<br />Give an overview of the S/4HANA embedded analytics architecture<br />Explain the analytical offerings per user type<br />Give an Introduction to SAP Best Practices for Analytics with SAP S/4HANA<br />Explain the integration scenarios with SAP Business Warehouse</p><p>In this course, students will gain an overview of the S/4HANA embedded analytics real-time operational reporting, its offerings per user type for the S/4HANA 610 and its integration with SAP Business Warehouse.</p></div><div id="course-pills-2"><h4>Module 1</h4><ul><li>S/4HANA and S/4HANA embedded analytics introduction</li></ul><h4>Module 2</h4><ul><li>S/4HANA embedded analytics architecture overview</li></ul><h4>Module 3</h4><ul><li>Analytical Consumption</li></ul><h4>Module 4</h4><ul><li>SAP Best Practices for Analytics with SAP S/4HANA</li></ul><h4>Module 5</h4><ul><li>SAP Business Warehouse Integration Scenarios</li></ul></div>

SAP Human Capital Management

SAP Project

SAP Sales & Distribution

SAP S/4HANA

S4H400 SAP S/4HANA Embedded Analytics - Overview



The Real Estate Investment School is a four day course, that unravels the complexity of Investment Cash Flows through Advanced Modelling, Interpretation and Theory.
With a strong emphasis on practical application, you will gain a profound understanding of the complexities involved in analysing investment cash flows and interpreting their implications for effective decision-making.
Upon completion of the course, you will have the expertise to confidently model investment cash flows to a proficient level, empowering you to make informed financial decisions and drive positive outcomes for your investments.


The Investment focused school combines three of our courses:
Real Estate Analyst
Real Estate Modelling Masterclass
Understanding Key Principles of Real Estate Financial Modelling


On this course you will…
Construct Investment Financial Models starting from foundational principles
Learn how to value an appraise property investments.
Gain a comprehensive understanding of modelling tenancy schedules, including lease structures, rental income projections, lease expiry analysis, and lease renewal
Develop proficiency in creating robust models.
Understand how the application and use structure finance products in Real Estate
Learn advanced modelling techniques to analyse underlying asset risk
Appreciate the importance of data in investment cash flow modelling.
Gain a deep comprehension of the interrelationship between the metrics used in investment cash flow modelling


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


Day Four
Understanding Key Principles of Real Estate Financial Modelling
Real Estate Financial Modelling Mathematics
Time Value of Money
Net Present Value (NPV)
Internal Rare of Return (IRR)
Growth
What Discount Rate?
Certainty of a cash flow
Liquidity


Price, Value & Worth
Comparing Price, Value and Worth
Conventional Valuation Methods
Term and Reversion, Layer Method
Property Yields and Capitalisation Method
Exit calculations across Europe


Discounting 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


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

Financial Modelling & Analysis

Financial Modelling

Property Investment

Financial Analysis

Microsoft Excel

Professional Development

The Real Estate Investment School is a four day course, that unravels the complexity of Investment Cash Flows through Advanced Modelling, Interpretation and Theory.

Real Estate Investment School (Investment Cash Flow Modelling)

<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

Continuous Professional Development (CPD)

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

Real Estate Analyst (Investment Cash Flow Modelling in Excel)

In-Person 

Virtual

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

Office Skills & Productivity

Access VBA

Visual Basic Analysis

Microsoft Power Automate

Excel - Automating Excel with Macros and Analysis Tools

<div dir="ltr" style="color: rgb(31, 31, 31); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(31, 31, 31);">
<div dir="ltr" style="color: rgb(31, 31, 31); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(31, 31, 31);">
<div dir="ltr" style="color: rgb(31, 31, 31); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(31, 31, 31);">

<p style="margin: 0cm; font-size: 15px; font-family: Calibri, sans-serif; color: var(--text); box-sizing: border-box;" id="isPasted" fr-original-style='margin:0cm;font-size:15px;font-family:"Calibri",sans-serif;'><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Empower Your Business with YouTube: Practical Workshop</strong></p><p style="margin: 0cm; font-size: 15px; font-family: Calibri, sans-serif; color: var(--text); box-sizing: border-box;" fr-original-style='margin:0cm;font-size:15px;font-family:"Calibri",sans-serif;'>&nbsp;</p><p style="margin: 0cm; font-size: 15px; font-family: Calibri, sans-serif; color: var(--text); box-sizing: border-box;" fr-original-style='margin:0cm;font-size:15px;font-family:"Calibri",sans-serif;'>Harness YouTube to expand your reach, build brand awareness, and boost sales. Our interactive YouTube for Business workshop provides essential skills to set up and optimise your channel for success.</p><p style="margin: 0cm; font-size: 15px; font-family: Calibri, sans-serif; color: var(--text); box-sizing: border-box;" fr-original-style='margin:0cm;font-size:15px;font-family:"Calibri",sans-serif;'>&nbsp;</p><p style="margin: 0cm; font-size: 15px; font-family: Calibri, sans-serif; color: var(--text); box-sizing: border-box;" fr-original-style='margin:0cm;font-size:15px;font-family:"Calibri",sans-serif;'><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">What You&#39;ll Learn:</strong></p><p style="margin: 0cm; font-size: 15px; font-family: Calibri, sans-serif; color: var(--text); box-sizing: border-box;" fr-original-style='margin:0cm;font-size:15px;font-family:"Calibri",sans-serif;'>&nbsp;</p><p style="margin: 0cm; font-size: 15px; font-family: Calibri, sans-serif; color: var(--text); box-sizing: border-box;" fr-original-style='margin:0cm;font-size:15px;font-family:"Calibri",sans-serif;'><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Create a Professional Channel:</strong> Build a captivating YouTube channel that represents your brand.</p><p style="margin: 0cm; font-size: 15px; font-family: Calibri, sans-serif; color: var(--text); box-sizing: border-box;" fr-original-style='margin:0cm;font-size:15px;font-family:"Calibri",sans-serif;'><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Optimise for Search:</strong> Learn key techniques to ensure your videos are easily found.</p><p style="margin: 0cm; font-size: 15px; font-family: Calibri, sans-serif; color: var(--text); box-sizing: border-box;" fr-original-style='margin:0cm;font-size:15px;font-family:"Calibri",sans-serif;'><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Effective Marketing:</strong> Discover strategies to promote your videos, generate leads, and increase conversions.</p><p style="margin: 0cm; font-size: 15px; font-family: Calibri, sans-serif; color: var(--text); box-sizing: border-box;" fr-original-style='margin:0cm;font-size:15px;font-family:"Calibri",sans-serif;'><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Analyse Performance:</strong> Use analytics to refine your strategies and improve content.</p><p style="margin: 0cm; font-size: 15px; font-family: Calibri, sans-serif; color: var(--text); box-sizing: border-box;" fr-original-style='margin:0cm;font-size:15px;font-family:"Calibri",sans-serif;'>&nbsp;</p><p style="margin: 0cm; font-size: 15px; font-family: Calibri, sans-serif; color: var(--text); box-sizing: border-box;" fr-original-style='margin:0cm;font-size:15px;font-family:"Calibri",sans-serif;'><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Enrol Today and Transform Your Business</strong></p><p style="margin: 0cm; font-size: 15px; font-family: Calibri, sans-serif; color: var(--text); box-sizing: border-box;" fr-original-style='margin:0cm;font-size:15px;font-family:"Calibri",sans-serif;'>&nbsp;</p><p style="margin: 0cm; font-size: 15px; font-family: Calibri, sans-serif; color: var(--text); box-sizing: border-box;" fr-original-style='margin:0cm;font-size:15px;font-family:"Calibri",sans-serif;'>Seize this chance to harness YouTube&#39;s potential. Enrol now in our YouTube for Business workshop and start creating videos that engage and elevate your business.</p><p style="margin: 0cm; font-size: 15px; font-family: Calibri, sans-serif; color: var(--text); box-sizing: border-box;" fr-original-style='margin:0cm;font-size:15px;font-family:"Calibri",sans-serif;'><br fr-original-style="" style="box-sizing: border-box;"></p>

<p style='margin: 0cm 0cm 0.0001pt; font-size: 15px; font-family: Calibri, "sans-serif"; color: var(--text); box-sizing: border-box;' id="isPasted" fr-original-style='margin:0cm;margin-bottom:.0001pt;font-size:15px;font-family:"Calibri","sans-serif";'><span style='font-family: "Segoe UI", "sans-serif"; box-sizing: border-box;' fr-original-style='font-family:"Segoe UI","sans-serif";'><u fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Explainer Video:</strong></u></span></p>

<iframe width="560" height="315" src="https://www.youtube.com/embed/lND5ACrCVos?si=1wlFLPU_5PfiL4Ri" title="YouTube video player" frameborder="0" allowfullscreen="" fr-original-style="" style="box-sizing: border-box;"><span class="fr-mk" style="display: none;">&nbsp;</span><span class="fr-mk" style="display: none;">&nbsp;</span><span class="fr-mk" style="display: none;">&nbsp;</span></iframe>


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

Empower Your Business with YouTube: Practical Workshop
 
Harness YouTube to expand your reach, build brand awareness, and boost sales. Our interactive YouTube for Business workshop provides essential skills to set up and optimise your channel for success.
 
What You'll Learn:
 
Create a Professional Channel: Build a captivating YouTube channel that represents your brand.
Optimise for Search: Learn key techniques to ensure your videos are easily found.
Effective Marketing: Discover strategies to promote your videos, generate leads, and increase conversions.
Analyse Performance: Use analytics to refine your strategies and improve content.
 
Enrol Today and Transform Your Business
 
Seize this chance to harness YouTube's potential. Enrol now in our YouTube for Business workshop and start creating videos that engage and elevate your business.


Explainer Video:


Clockwork Eye Video Training

Video

Video Marketing

Video Creation

Mobile Video Production

Video Design

Video Production

Video Editing

Video & Mobile Marketing

Learn how to create and manage a successful YouTube channel for your business. This workshop will cover everything you need to know when setting up and using YouTube in your business. You will also learn how to use YouTube analytics to track your channel's performance to help you make improvements.

YouTube For Business (Interactive Workshop)

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



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


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


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


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


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


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

Real Estate Finance

Investment Management

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

Real Estate Modelling Masterclass (Advanced Cash Flow Modelling)

<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

Risk Management

Investment

Financial Risk 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)

<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;">Master YouTube with TubeBuddy: A Micro-Workshop</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Unlock your YouTube channel&#39;s full potential with our exclusive micro-workshop on TubeBuddy, the ultimate tool for video creators. Learn how to effectively use TubeBuddy&#39;s powerful features to optimise your content, increase your visibility, and grow your audience.&nbsp;</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;">What You&rsquo;ll Learn:</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;">SEO &amp; Keywords:</strong> Master the Keyword Explorer and SEO Studio to dominate search results.</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;">Content Optimisation:</strong> Utilise A/B Testing, Thumbnail Analyser, and Click Magnet for maximum engagement.</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;">Efficiency Tools:</strong> Streamline your workflow with Bulk Processing and advanced analytics.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Join us and transform your YouTube strategy with expert insights and practical tips on leveraging TubeBuddy. Don&rsquo;t miss this opportunity to take your channel to the next level!</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">For more information on TubeBuddy&rsquo;s features, visit <a href="https://www.tubebuddy.com/pricing?a=ClockworkEye" target="_blank" rel="noopener noreferrer" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;"><span style="color: rgb(44, 130, 201); box-sizing: border-box;" fr-original-style="color: rgb(44, 130, 201);">TubeBuddy</span></a><a data-fr-linked="true" href="https://www.tubebuddy.com/" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;"></a>.</p>

Photography & Video

Film & Video

Videography

Unlock your YouTube channel's potential with our TubeBuddy micro-workshop. Learn SEO, content optimisation, and efficiency tools to grow your audience and boost engagement.

Master YouTube with TubeBuddy (A Micro-Workshop)

<p><strong>Get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £180 as a Gift-Enrol Now!!!</strong></p><p>Gain the essential skills for a<strong> Data Analyst </strong>role through this <strong>TWENTY-in-One career-oriented </strong>Professional Data Analyst Program from Apex Learning and position yourself competitively in the thriving job market for data analysts, which will see a <strong>20% growth by 2028</strong> (U.K. Bureau of Labor Statistics).</p><p>Power your<strong> Data Analyst </strong>career by learning the <strong>core principles</strong> of data analysis and gaining professional skills. You'll go through with a variety of data sources, project scenarios, and data analysis tools, including <strong>Excel</strong>, <strong>Power BI</strong>, <strong>SQL</strong>, <strong> Python</strong>, <strong>Google Data Studio</strong>,<strong> Tableau</strong> and <strong>SAS</strong>, gaining practical experience with data manipulation and applying analytical techniques.</p><p>Along with this Data Analyst : Data Analytics bundle, you will get 19 other premium courses.</p><p><strong>This Data Analyst : Data Analytics Bundle Consists of the following Premium courses:</strong></p><ul><li><strong>Course 01:</strong> Introduction to Data Analysis</li><li><strong>Course 02:</strong> Data Analytics with Tableau</li><li><strong>Course 03:</strong> Python for Data Analysis</li><li><strong>Course 04:</strong> Basic Google Data Studio</li><li><strong>Course 05:</strong> SQL NoSQL Big Data and Hadoop</li><li><strong>Course 06:</strong> Complete Microsoft Power BI 2021</li><li><strong>Course 07:</strong> Fundamentals of Business Analysis</li><li><strong>Course 08:</strong> Complete Introduction to Business Data Analysis Level 3</li><li><strong>Course 09:</strong> Business Intelligence and Data Mining Masterclass</li><li><strong>Course 10:</strong> Research Methods in Business</li><li><strong>Course 11:</strong> Statistical Analysis</li><li><strong>Course 12:</strong> Graph Theory Algorithms</li><li><strong>Course 13:</strong> Clinical Data Analysis with SAS</li><li><strong>Course 14:</strong> Data Analysis in Excel Level 3 Course</li><li><strong>Course 15:</strong> Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query</li><li><strong>Course 16:</strong> PowerPoint Diploma</li><li><strong>Course 17:</strong> Data Protection and Data Security Level 2</li><li><strong>Course 18:</strong> Functional Skills IT</li><li><strong>Course 19:</strong> Decision Making and Critical Thinking</li></ul><p>So, enrol in this Data Analyst : Data Analytics Training now to advance your career!</p><p>This Data Analyst : Data Analytics bundle Does Not require any prior programming or statistical skills and is suitable for learners with or without college degrees.</p><p>The Data Analyst : Data Analytics bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Data Analyst : Data Analytics expertise and essential knowledge, which will assist you in reaching your goal. Moreover, you can learn from any place in your own time without travelling for classes.</p><p><strong>H</strong><strong>ow will I get my Certificate?</strong></p><p>After successfully completing the Data Analyst : Data Analytics Training, you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement.</p><ul><li><strong>PDF Certificate: Free (For The Title Course)</strong></li><li><strong>Hard Copy Certificate: Free (For The Title Course)</strong></li></ul><p>P.S. The delivery charge inside the U.K. is £3.99, and the international students must pay £9.99.</p><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        125 CPD hours / points
                                    </div>
                                        <div>
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div><h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>Anyone from any background can enrol in this Data Analyst : Data Analytics bundle.</p>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>This Data Analyst : Data Analytics Trainingcourse has been designed to be fully compatible with tablets and smartphones.</p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>Data Analyst : Data Analytics Training<strong>: </strong></p><p>This <strong>Data Analyst (Data Analytics) </strong>Bundle is ideal for anyone who wants to take their development to the next level and fast-track their career in any of the following roles:b</p><ul><li>Data analytics manager</li><li>Financial analyst</li><li>Marketing analyst</li><li>Systems analyst</li><li>Data scientist</li><li>Machine learning engineer</li><li>Data analytics consultant</li></ul>
                        </div><h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Digital certificate -
            Included
        </p>
            <div> <p>You will get the PDF Certificate for the title course (<strong>Data Analysis</strong>) absolutely Free! </p> </div>
        <h4>Certificate of completion</h4>
        <p>
            Hard copy certificate -
            Included
        </p>
            <div> <p>You will get the Hard Copy certificate for the title course (<strong>Data Analysis</strong>) absolutely Free! Other Hard Copy certificates are available for £10 each. </p><p>Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.</p> </div>

                        </div>

Get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £180 as a Gift-Enrol Now!!!
Gain the essential skills for a Data Analyst role through this TWENTY-in-One career-oriented Professional Data Analyst Program from Apex Learning and position yourself competitively in the thriving job market for data analysts, which will see a 20% growth by 2028 (U.K. Bureau of Labor Statistics).
Power your Data Analyst career by learning the core principles of data analysis and gaining professional skills. You'll go through with a variety of data sources, project scenarios, and data analysis tools, including Excel, Power BI, SQL,  Python, Google Data Studio, Tableau and SAS, gaining practical experience with data manipulation and applying analytical techniques.
Along with this Data Analyst : Data Analytics bundle, you will get 19 other premium courses.
This Data Analyst : Data Analytics Bundle Consists of the following Premium courses:
Course 01: Introduction to Data Analysis
Course 02: Data Analytics with Tableau
Course 03: Python for Data Analysis
Course 04: Basic Google Data Studio
Course 05: SQL NoSQL Big Data and Hadoop
Course 06: Complete Microsoft Power BI 2021
Course 07: Fundamentals of Business Analysis
Course 08: Complete Introduction to Business Data Analysis Level 3
Course 09: Business Intelligence and Data Mining Masterclass
Course 10: Research Methods in Business
Course 11: Statistical Analysis
Course 12: Graph Theory Algorithms
Course 13: Clinical Data Analysis with SAS
Course 14: Data Analysis in Excel Level 3 Course
Course 15: Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query
Course 16: PowerPoint Diploma
Course 17: Data Protection and Data Security Level 2
Course 18: Functional Skills IT
Course 19: Decision Making and Critical Thinking
So, enrol in this Data Analyst : Data Analytics Training now to advance your career!
This Data Analyst : Data Analytics bundle Does Not require any prior programming or statistical skills and is suitable for learners with or without college degrees.
The Data Analyst : Data Analytics bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Data Analyst : Data Analytics expertise and essential knowledge, which will assist you in reaching your goal. Moreover, you can learn from any place in your own time without travelling for classes.
How will I get my Certificate?
After successfully completing the Data Analyst : Data Analytics Training, you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement.
PDF Certificate: Free (For The Title Course)
Hard Copy Certificate: Free (For The Title Course)
P.S. The delivery charge inside the U.K. is £3.99, and the international students must pay £9.99.
 CPD 
125 CPD hours / points  Accredited by CPD Quality Standards
 Who is this course for? 
Anyone from any background can enrol in this Data Analyst : Data Analytics bundle.
 Requirements 
This Data Analyst : Data Analytics Trainingcourse has been designed to be fully compatible with tablets and smartphones.
 Career path 
Data Analyst : Data Analytics Training: 
This Data Analyst (Data Analytics) Bundle is ideal for anyone who wants to take their development to the next level and fast-track their career in any of the following roles:b
Data analytics manager
Financial analyst
Marketing analyst
Systems analyst
Data scientist
Machine learning engineer
Data analytics consultant
 Certificates 
Certificate of completion
 Digital certificate - Included 
You will get the PDF Certificate for the title course (Data Analysis) absolutely Free! 
Certificate of completion
 Hard copy certificate - Included 
You will get the Hard Copy certificate for the title course (Data Analysis) absolutely Free! Other Hard Copy certificates are available for £10 each. 
Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

Apex Learning

Data Analyst : Data Analytics Training

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

Microsoft Certification

Microsoft SC-200

SC-200T00 Microsoft Security Operations Analyst

<p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(111, 114, 135);">Are you looking to enter the dynamic world of real estate?</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Our course is designed to equip you with the knowledge and tools you need to communicate effectively with real estate professionals and develop key skills in real estate investment strategy and analytics.</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(111, 114, 135);">At the end of the course, you&#39;ll be able to read and interpret real estate market reports, and have a firm grasp of how iconic buildings, cities, and companies fit into the overall picture of the real estate sector.</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(111, 114, 135);"><br fr-original-style="" style="box-sizing: border-box;"></p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><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 style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><li fr-original-style="" style="box-sizing: border-box;">Become familiar with the players, structure, general terminology and overall needs of Real Estate.</li><li fr-original-style="" style="box-sizing: border-box;">Learn what is Real Estate and why it is different from other asset classes</li><li fr-original-style="" style="box-sizing: border-box;">Get to grips with the overall size and structure of the UK Real Estate Market</li><li fr-original-style="" style="box-sizing: border-box;">Learn and analyse the links between the different parts of the property market</li><li fr-original-style="" style="box-sizing: border-box;">Understand who works in the Real Estate Market, their qualifications and their job descriptions</li><li fr-original-style="" style="box-sizing: border-box;">Recognise how and when to use basic real estate concepts: Rent, Value, Yield, Risk and Return, etc&hellip;</li><li fr-original-style="" style="box-sizing: border-box;">Learn how to read a real estate market report</li><li fr-original-style="" style="box-sizing: border-box;">Understand how current affairs, politics and economics affects Real Estate Investment</li><li fr-original-style="" style="box-sizing: border-box;">Use household names and iconic companies, cities and buildings to help consolidate your appreciation of this exciting sector</li></ul><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><br fr-original-style="" style="box-sizing: border-box;"></p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><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 style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><li fr-original-style="" style="box-sizing: border-box;">Graduates or undergraduates studying economics, finance.</li><li fr-original-style="" style="box-sizing: border-box;">Professionals working in Marketing or Accounting teams within Real Estate firms.</li><li fr-original-style="" style="box-sizing: border-box;">APC students.</li><li fr-original-style="" style="box-sizing: border-box;">Anyone interested in Real Estate.</li><li fr-original-style="" style="box-sizing: border-box;">School leavers/A-Level Students looking to gain an understanding of Real Estate.</li><li fr-original-style="" style="box-sizing: border-box;">Non cognate students who wish to transfer into Real Estate/Finance careers.</li></ul><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><br fr-original-style="" style="box-sizing: border-box;"></p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><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 style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><em fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">Module 1: What is and why buy Real Estate?</em></em></p><ul style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><li fr-original-style="" style="box-sizing: border-box;">The property Market</li><li fr-original-style="" style="box-sizing: border-box;">The Size and Structure of the UK property market</li><li fr-original-style="" style="box-sizing: border-box;">The impact of Real Estate in the Economy</li></ul><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><br fr-original-style="" style="box-sizing: border-box;"></p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><em fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">Module 2: The Real Estate Market System</em></em></p><ul style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><li fr-original-style="" style="box-sizing: border-box;">The Space Market</li><li fr-original-style="" style="box-sizing: border-box;">The Asset Market</li><li fr-original-style="" style="box-sizing: border-box;">The Development Market</li></ul><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><br fr-original-style="" style="box-sizing: border-box;"></p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><em fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">Module 3: How to value Real Estate</em></em></p><ul style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><li fr-original-style="" style="box-sizing: border-box;">An Introduction to Financial Mathematics</li><li fr-original-style="" style="box-sizing: border-box;">The difference between Price, Value and Worth</li><li fr-original-style="" style="box-sizing: border-box;">Property Yield</li><li fr-original-style="" style="box-sizing: border-box;">Conventional Valuation Methods</li></ul><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><br fr-original-style="" style="box-sizing: border-box;"></p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><em fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">Module 4: How to read a Real Estate Market Report</em></em></p><ul style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><li fr-original-style="" style="box-sizing: border-box;">Property Market Indicators: Stock Indicators</li><li fr-original-style="" style="box-sizing: border-box;">Property Market Indicators: Investment Indicators</li></ul><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><br fr-original-style="" style="box-sizing: border-box;"></p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><em fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">Module 5: Who works in Real Estate?</em></em></p><ul style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><li fr-original-style="" style="box-sizing: border-box;">The build Environment by Cobalt Recruitment</li><li fr-original-style="" style="box-sizing: border-box;">Rea; Estate Agents</li><li fr-original-style="" style="box-sizing: border-box;">Examples of Real Estate Market Agents CVs</li><li fr-original-style="" style="box-sizing: border-box;">Real Estate Network</li></ul><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><br fr-original-style="" style="box-sizing: border-box;"></p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><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 style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><li fr-original-style="" style="box-sizing: border-box;">CPD Accredited Certificate</li><li fr-original-style="" style="box-sizing: border-box;">12 Months Access to the Course</li><li fr-original-style="" style="box-sizing: border-box;">Course Files</li><li fr-original-style="" style="box-sizing: border-box;">Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)</li><li 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 Introduction to Real Estate, 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>

Are you looking to enter the dynamic world of real estate?

Our course is designed to equip you with the knowledge and tools you need to communicate effectively with real estate professionals and develop key skills in real estate investment strategy and analytics.

At the end of the course, you'll be able to read and interpret real estate market reports, and have a firm grasp of how iconic buildings, cities, and companies fit into the overall picture of the real estate sector.



On this course, you will…

Become familiar with the players, structure, general terminology and overall needs of Real Estate.
Learn what is Real Estate and why it is different from other asset classes
Get to grips with the overall size and structure of the UK Real Estate Market
Learn and analyse the links between the different parts of the property market
Understand who works in the Real Estate Market, their qualifications and their job descriptions
Recognise how and when to use basic real estate concepts: Rent, Value, Yield, Risk and Return, etc…
Learn how to read a real estate market report
Understand how current affairs, politics and economics affects Real Estate Investment
Use household names and iconic companies, cities and buildings to help consolidate your appreciation of this exciting sector


Who will benefit from this course:

Graduates or undergraduates studying economics, finance.
Professionals working in Marketing or Accounting teams within Real Estate firms.
APC students.
Anyone interested in Real Estate.
School leavers/A-Level Students looking to gain an understanding of Real Estate.
Non cognate students who wish to transfer into Real Estate/Finance careers.


Course Outline

Module 1: What is and why buy Real Estate?

The property Market
The Size and Structure of the UK property market
The impact of Real Estate in the Economy


Module 2: The Real Estate Market System

The Space Market
The Asset Market
The Development Market


Module 3: How to value Real Estate

An Introduction to Financial Mathematics
The difference between Price, Value and Worth
Property Yield
Conventional Valuation Methods


Module 4: How to read a Real Estate Market Report

Property Market Indicators: Stock Indicators
Property Market Indicators: Investment Indicators


Module 5: Who works in Real Estate?

The build Environment by Cobalt Recruitment
Rea; Estate Agents
Examples of Real Estate Market Agents CVs
Real Estate Network


1836 Analytics courses delivered Online

Online Data Science & Data Analytics Course with Certificate

By LearnDrive UK

SQL for Data Science, Data Analytics and Data Visualization Course

By One Education

Master Big Data Ingestion and Analytics with Flume, Sqoop, Hive and Spark

By Packt

Learn MySQL from Scratch for Data Science and Analytics Course

By One Education

Creating Compelling Data Visualisations

By NextGen Learning

AZ-400T00 Designing and Implementing Microsoft DevOps Solutions

By Nexus Human

Cisco Implementing Cisco Tetration Analytics v1.0 (DCITET)

By Nexus Human

Google Analytics and Financial Planning for Financial Advisors Course

By Training Express

Level 3 Data Entry, Data Analytics, Document Control & Virtual Assistant Diploma Course

By One Education

S4H400 SAP S/4HANA Embedded Analytics - Overview

By Nexus Human