Name: MySQL for developers
Price: 2797 GBP
Availability: InStock

London

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Intensive hands on laparoscopic suturing course: for gynaecologists, urologists, general surgeons. Practical theory, tips and tricks, extensive hands on training. Delivered by the expert CCMIG faculty.</p>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Individual tuition and feedback, full certification provided.</p>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Suitable for trainees or consultants developing their laparoscopic practice.</p>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Learn this key skill for laparoscopic surgery, practice makes perfect!</p>

Intensive hands on laparoscopic suturing course: for gynaecologists, urologists, general surgeons and anyone performing minimal access techniques. Practical theory, tips and tricks, extensive hands on training. Delivered by the expert CCMIG faculty.

Tried and tested technique, the ABCs of laparoscopic suturing.
Individual tuition and feedback, full certification provided.
Suitable for trainees or consultants at any level developing their laparoscopic practice.
Learn this key skill for laparoscopic surgery and a structured system for training, practice makes perfect!

CCMIG

Obstetrics & Gynaecology

Gynaecologic Oncology

Laparoscopic Skills

Suture Removal

Laparoscopy

Laparoscopic Surgery

Urology

General Surgery

Laparoscopic suturing course, intensive hands on training for gynaecology, general surgery, urologists of other doctors wanting to progress their laparoscopy skills!

Laparoscopic Suturing Course

General admission

Redhill

<h3><b>Total PHP training course description</b></h3>
      <p>   PHP provides for the creation of dynamic web sites. This hands on training course looks at programming with PHP with an emphasis of building dynamic websites. Forms, state management and database integration are all covered with practicals used throughout the course to reinforce theory sessions.</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
	  
                        <li>Create dynamic web sites using PHP.</li>
					<li>Write PHP programs.</li>
                    <li>Debug PHP programs.</li>
                    <li>Examine existing code and determine its function. </li>
                  </ul>
        <h5>
        <b>Total PHP training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Anyone creating dynamic web sites.</p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>Software development fundamentals
							</p>
              
							<li><b>Duration</b></li>
							
              <p>3 days
						</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>Total PHP training course contents</b></h3>
      <ul>
				<li>What is PHP? </li><p>
PHP history, dynamic web pages, how PHP works, alternatives to PHP. Downloading and installing PHP. Installing MySQL, installing Apache, platform issues.

</p><li>A first PHP web page </li><p>
A basic PHP script, PHP page structure. PHP comments. Integrating PHP and HTML.

</p><li>PHP forms </li><p>
HTML forms, taking values from forms.

</p><li>PHP and HTML </li><p>
Page inputs, environment inputs. phpinfo(), other form elements, sticky fields, generalised code, tables, forms, form elements, style sheets, JavaScript.

</p><li>Variables operators and expressions </li><p>
Expressions, data types, assignments, scope, constants, HTTP environment variables, getting data from forms using variables.

</p><li>Operators </li><p>
Arithmetic, logical, relational, Boolean, others.

</p><li>Control statements </li><p>
Conditional: if, else, elseif, switch. Loops: while, do while, for, break, continue, exit.

</p><li>Functions </li><p>
Built in functions, declaration, arguments, scope, loading functions from other files, defaulting parameters, call by value/ name.

</p><li>Arrays </li><p>
Indexes, array initialisation, array manipulation, multi dimensional arrays, array functions.

</p><li>String handling </li><p>
What is a string, string functions, matching, extraction, replacement. String operations, cleansing, sprintf, formatting web pages, strops and others, splitting strings, REs.

</p><li>PHP and databases </li><p>
Database structure, Database APIs, MySQL, Creating tables, Editing tables, simple SQL queries using PHP, building HTML tables using SQL queries, SQL injection, security issues, error handling.

</p><li>File I/O </li><p>
Opening, reading, writing files. Permissions, ownership, locking, directories.

</p><li>PHP, cookies and sessions </li><p> 
State, Cookie properties, setting cookies, retrieving cookies, expiring/deleting cookies. Sessions, session variables, session IDs.

</p><li>PHP and email </li><p>
Emailing from servers, attachments.

</p><li>Objects </li><p>
OOP, PHP classes, constructors, instances.</p>
			
      </ul>

Systems & Network Training

Network & Security

Network Engineer

Total PHP for developers

General Admission

<h4>Overview</h4>
						<hr />
						<div></div>
							<p>
							</p><p>This course will help our clients to assist not only in meeting the challenges of introducing IPSAS but also to secure the benefits of improved financial management to help secure the organisational objectives and goals of each public service organisation. We have developed this course starting with an introduction and then implementation of IPSAS. </p>

<p>This course will help our clients to assist not only in meeting the challenges of introducing IPSAS but also to secure the benefits of improved financial management to help secure the organisational objectives and goals of each public service organisation. This enables multi-national organisations to make comparisons between projects wherever in the world they happen, irrespective of jurisdiction, culture, language and ethnicity.</p>

<p>IPSAS is becoming and will become the World standard for Public Sector entities. We have developed this course starting with an introduction and then implementation of IPSAS. This allows clients to structure the move to IPSAS within its appropriate Framework. It is an approach that enables implementation to be done in a structured and well-managed way. In the course we will consider the main requirements of IPSAS and, by showing how they affect financial reports and published accounts, will help you to apply IPSAS. The course will assist both finance managers and general managers whose organisations and departments will be affected by IPSAS.</p>
<p>
							
							</p><div>
						
					</div>

GBA Corporate

Masters in IPSAS

Online

On Site

<h3><b>SNMP training course description</b></h3>
        <p> A hands-on generic look at the technical operation of SNMP. The course starts with an overview of all the components, which make up SNMP. Hands on starts early with configuration of a managed network. The major versions of SNMP are then put into perspective followed by a look at the SNMP protocol. MIBs are then studied both from the perspective of reading MIBs and writing MIBs. The course finishes with a look at the security implications of SNMP.</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
        <li>Describe the SNMP architecture.</li>
					<li>Analyse SNMP packets.</li>
					<li>Recognise the MIB structure.</li>
                    <li>Describe the SMI.</li>
					<li>Recognise the strengths and weaknesses of SNMPv2 and SNMPv3.</li>
                  </ul>
        <h5>
        <b>SNMP training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Network administrators.<br />
                   Network operators.<br />
                    Programmers writing MIBs and agents. </p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>TCP/IP Foundation for engineers<br />
                Hands on experience of an SNMP management station would also be beneficial.</p>
              
							<li><b>Duration</b></li>
							
              <p>3 days</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>SNMP training course contents</b></h3>
      <ul>
				<li>Network management</li><p>
What is network management? Benefits, issues.
				</p><li>What is SNMP?</li><p>
SNMP architecture, SNMP MIBs, SMI, the SNMP
protocol, polling security, alternatives to SNMP:
CMIP, web based management.
	</p><li>Configuring SNMP</li><p>
Auto discovery for management stations, NMS
configuration, agent configuration, traps. <br /><span>Hands on</span>
Configuring agents and an NMS.
	</p><li>SNMP background</li><p>
SNMP history, RFCs, standards, SNMP protocol
versions, SNMPv1, SNMPv2, SNMPv3, SNMP SMI
versions, which version should you use? Futures.
	</p><li>SNMPv1 packets</li><p>
SNMP in the 7 layer model, port numbers, general
packet format, BER, GET, GET-NEXT, tables,
SET, TRAP, bandwidth issues, in band versus out
of band management. <br /><span>Hands on</span> Analysing
SNMPv1 packets.
	</p><li>SNMPv2 packets</li><p>
SNMPv2 improvements, error handling, GETBULK, v2traps, INFORM. <br /><span>Hands on</span> Analysing
SNMPv2 packets.
	</p><li>SNMPv3 packets</li><p>
SNMPv3 packet format, use of SNMPv2
messages, REPORT PDU.
	</p><li>MIB structure</li><p>
The internet MIB branch, standard mib-2, extra
parts of mib-2, private enterprise MIBs, loading
extra MIBs. <br /><span>Hands on</span> MIB browsing.
	</p><li>mib-2</li><p>
The mib-2 groups, system group, interfaces group,
IP group, ICMP group, TCP group, UDP group,
transmission group, SNMP group, RMON. <br /><span>Hands on</span> mib-2 browsing in detail.
	</p><li>SMI</li><p>
The MIB layout, obtaining a private enterprise
number, MIB definitions, IMPORT, Module
identity, Textual conventions, object definitions,
notifications, compliance statements, object
groups, base SMI data types, application data
types, scalars, instances, tables, table definition,
writing agents, SMIng.
	</p><li>SNMP security</li><p>
Community strings, SNMPv1 and SNMPv2c
security practices, SNMPv3 security, SNMPv3
architecture, SNMP applications, the SNMP
engine, the EngineID, security fields in SNMPv3
packets, USM, authentication, encryption,
timeliness, VBAC, SNMPv3 configuration. </p>
      </ul>

Total SNMP for engineers

<h4>Overview</h4>
						<hr />
						<div></div>
							<p>
							</p><p>This course will help our clients to assist not only in meeting the challenges of introducing IPSAS but also to secure the benefits of improved financial management to help secure the organisational objectives and goals of each public service organisation. This enables multi-national organisations to make comparisons between projects wherever in the world they happen, irrespective of jurisdiction, culture, language and ethnicity.</p>

<p>IPSAS is becoming and will become the World standard for Public Sector entities. We have developed this course starting with an introduction and then implementation of IPSAS. This allows clients to structure the move to IPSAS within its appropriate Framework. It is an approach that enables implementation to be done in a structured and well-managed way. In the course we will consider the main requirements of IPSAS and, by showing how they affect financial reports and published accounts, will help you to apply IPSAS. The course will assist both finance managers and general managers whose organisations and departments will be affected by IPSAS.</p>

<p>The consequences of managing the finances of public organisations will be examined, together with potential unintended consequences. How to implement IPSAS effectively and economically, is probably the most important aspect. The approach will be to understand the advantages to the organisation from IPSAS implementation and how benefits realisation can be ensured both internally and for stakeholders. The course will deal with practical issues for public sector organisations, including strategic management and the medium-term financial framework</p>
<p>
							
							</p><div>
						
					</div>

IPSAS

<h3><b>LTE optimization training course description</b></h3>
      <p>  This course gives delegates an understanding of the
Key Performance Indicators used within the 3G LTE
(4G) network environment. We investigate the 3GPP
standards for KPIs (including TR 32.814, TS 32.410 &amp;
TS 32.455) these cover GERAN, UMTS &amp; LTE
environments. The course details the optimisation
procedures and the use of Self optimisation, Selforganising
&amp; Self-healing equipment now being
deployed across all releases of mobile networks.</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
			
                 <li>Explain the RF optimisation flowchart.</li>
																				<li>Describe the importance of Reference Signal
Received Power (RSRP).</li>
                    <li>List many of the 3GPP recommended KPIs.</li>
                    <li>Describe the concept of APN AMBR and UE AMBR
within LTE.</li> 
                    
                    <li>Describe the use of planning and optimisation
computer tools.</li>
                  </ul>
        <h5>
        <b>LTE optimization training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Anyone working with LTE.</p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>Essential LTE
							</p>
              
							<li><b>Duration</b></li>
							
              <p>2 days
						</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>LTE optimization training course contents</b></h3>
      <ul>
				<li>Introduction to the cellular environment </li><p>
The architecture, 2G (GSM), GPRS/EDGE, The NGMN (Next Generation Mobile Network), media gateway controller, 3GPP Rel99 the 3G introduction, HSPA deployments, 3G LTE (4G).

</p><li>Cellular network procedures </li><p>
GSM/GPRS call setup, GPRS data call setup, 3G UMTS data call setup, Data call (Voice over LTE) in LTE (using IMS), Circuit Switched Fall Back (CSFB) in LTE, IP packet session in LTE.

</p><li>Introduction to the standards </li><p>
The 3GPP specifications body, The numbering structure for KPIs, 2G KPIs, 3G/UMTS KPIs, 3G LTE KPIs, IMS KPIs.

</p><li>Introduction to the KPI definitions </li><p>
KPI definitions, accessibility KPIs, retainability KPIs, mobility KPIs, utilisation KPIs.

</p><li>In-depth overview of the air Interfaces </li><p>
GSM/GPRS FDMA &amp; TDMA solution, 3G UMTS WCDMA solution, HSPA+ sharing spare power (Codes), The 3G LTE uplink &amp; downlink interface explained, Initial attach procedures explained.

</p><li>Problem analysis </li><p>
Reference Signal Received Power (RSRP), Signal to Interference Noise Ratio (SINR), handover success rates, power adjustments, classification of coverage problems, weak coverage &amp; coverage holes, lack of dominant cells, cross coverage, improper tilt settings, uplink/downlink imbalance, signal quality, Azimuths &amp; tilts to reduce interference, Handover failure due to interference, Service drop causes.

</p><li>Mobile RF performance in 2G/3G </li><p>
Performance counters, KPIs, testing &amp; measurement, Drive testing and survey, Data collection and post processing of data, LTE service optimization, bandwidth, poor coverage, Quality, optimization process, KPI optimization, Root Cause Analysis (RCA) applied to RF issues, optimization tools and software.

</p><li>Advanced LTE network planning &amp; optimization </li><p>
LTE UE measurements (RSRP/RSRQ), LTE capacity planning, RF configuration parameters, LTE cell selection/reselection planning, LTE radio network KPIs, LTE user-centric KPIs, LTE network performance KPIs, LTE system utilization KPIs, LTE RF channel performance predictions, LTE channel information processing, LTE channel multiplexing, Physical layer and structure, MIMO in LTE, LTE resource plan LTE and Self-Organizing Networks (SON).

</p><li>Radio network optimization work flow </li><p>
Work flow, the existing network, Optimization team establishment and cluster division, Single site verification, Alarm check, Cell state check, Radio parameters check, Site verification, Statistics analysis, Coverage problem analysis.

</p><li>Mobile internet and QoS issues </li><p>
Cellular QoS reference models. How QoS impact on KPIs and measurements, Introduction to mobile internet, The concept of shared access technologies, Support for QoS in the WCDMA environment, The PDP context model, Supporting end-to-end QoS, EPS bearer concepts, Default EPS bearer, Dedicated EPS bearer, APN-AMBR, UE-AMBR.</p>
      </ul>

LTE optimisation and capability

<h2>Portfolio Management Skills</h2>
<p>The main purpose of this workshop is to equip and enable people in a portfolio management office and PMO to effectively and efficiently support the Executive Leadership and Operational Management to plan, implement, manage, and evolve portfolio management in their organization. There is a deliberate focus on preparing you to become a strong and effective change advocate for meaningful portfolio management that delivers objective measurements of benefit contribution towards the strategic objectives to lead, manage, and continuously improve portfolio management governance, processes, and frameworks with and through the direction of a portfolio practice, principles, and delivery boards.</p><h3>What you Will Learn</h3>
<p>At the end of this program, you will be able to:</p>
<ul>
<li>Articulate the benefits of portfolio management</li>
<li>Link the initiatives in an organization with its strategic objectives</li>
<li>Participate in the introduction of portfolio management in an organization</li>
<li>Create or improve the portfolio governance structure</li>
<li>Lead the inventory of ongoing and new initiatives</li>
<li>Assist the executives in the prioritization of initiatives through the use of Multi-criteria Analysis and other selection tools</li>
<li>Support the executives in balancing the portfolio based on the optimal use of resources and priorities</li>
<li>Create a portfolio delivery plan</li>
<li>Define thresholds and variance reporting criteria</li>
<li>Assist the executives and the financial team in the definition of Stage Gate Funding</li>
<li>Lead the Stage Gate reviews</li>
<li>Analyze the benefits that are being realized by the initiatives</li>
</ul><section>
                    <h3>Foundation Concepts</h3><ul><li>Definitions</li><li>Benefits of Portfolio Management</li><li>Objectives of Portfolio Management</li><li>Portfolio Life Cycles</li></ul><h3>Governing the Portfolio</h3><ul><li>Portfolio Governance structure</li><li>Roles and responsibilities</li><li>Initial activities when starting portfolio management</li></ul><h3>Prioritizing Initiatives</h3><ul><li>Prioritize purpose</li><li>Multi-Criteria Analysis</li><li>Analytical Hierarchy Process (AHP)</li><li>Strategic alignment</li></ul><h3>Balancing the Portfolio</h3><ul><li>Allocating resources and budgets</li><li>Communicating decisions of initiatives status</li></ul><h3>Planning the Portfolio</h3><ul><li>Planning review cycles</li><li>Using Stage Gate Funding</li><li>Setting thresholds and variance reporting</li><li>Tool examples</li></ul><h3>Managing the Portfolio Delivery</h3><ul><li>Project and Program Life Cycles</li><li>Stage Gate Reviews</li><li>Loop back to Prioritize, Balance and Plan</li><li>Interaction with the Portfolio Delivery Board</li><li>Project, Program and Functional Managers' roles and responsibilities</li></ul>


                </section>

IIL Europe Ltd

Portfolio Management Skills

<h3><b>Microsoft Active Directory course description</b></h3>
      <p> A thorough understanding of this system is essential for
anyone managing enterprise MS networks. Essential
theory is complimented with a high level of hands on
practice allowing delegates to observe the
idiosyncrasies of Active Directory and Group Policy at
first hand. Delegates learn the fundamental theory of
AD and progress onto building a multi-domain network
in the classroom. The course includes troubleshooting
methods, and essential maintenance procedures. This
course is designed to teach you the skills needed for
day to day management of these technologies.</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
	 <li>Install AD on multiple PCs.</li>
																				<li>Use the tools to create and manage objects.</li>
                    <li>Create appropriate group policies to restrict
selected user's desktops and network access.</li>
                    <li>Install DNS to support Active Directory without
loosing Internet Connectivity. </li>
                    <li>Maintain and troubleshoot AD problems</li>
                     <li>Backup Active Directory.</li>
                  </ul>
        <h5><b>Microsoft Active Directory course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Technical staff working with AD based networks.</p>
              
							<li><b>Prerequisites:</b></li>
							
							<p>Supporting Windows server.
                    </p>
              
							<li><b>Duration</b></li>
							
              <p>3 days
						</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>Microsoft Active Directory course contents</b></h3>
      <ul>
				<li>Introduction to Active Directory </li><p>
Network authentication methods, Active Directory defined, AD naming conventions, network management with AD, AD structures: Domains, Organisational Units, Forests &amp; Trees, Sites, The Global Catalogue. Windows 2003 new features, installing AD.
<br /><span>Hands on</span> Installing an AD network.

</p><li>Windows overview </li><p>
Management methods Server management tools, installing the additional tools, Terminal Server: Administration mode, Administrator accounts in AD, Local Security Policy.
<br /><span>Hands on</span> Install the management tools, Management using Terminal Services.

</p><li>Creating &amp; Managing Objects (a quick look) </li><p>
AD management tools, AD users and computers, Creating &amp; managing OUs, User Accounts and groups, controlling access to AD objects, moving objects, Publishing resources, locating objects in AD, delegating authority.
<br /><span>Hands on</span> Creating a control OU structure and delegating authority.

</p><li>Introduction to Group Policies </li><p>
What are Group Policies? Where Group Policy data is stored, security, Group Policy flow.
<br /><span>Hands on</span> Implementing Group Policies

</p><li>Working with Group Policies </li><p>
Local security templates, administrative templates, scripts, folder redirection, software deployment.
<br /><span>Hands on</span> Scripts, redirecting the start menu, creating a secure, robust desktop environment.

</p><li>Implementing DNS </li><p>
DNS basics, troubleshooting, implementing DNS zones.
<br /><span>Hands on</span> Building a unified DNS solution.

</p><li>Maintaining and managing the AD database </li><p>
AD support tools, database internal structure, replication, replication tools, Single Operations Masters, tools for maintenance, maintenance techniques, Backing up AD, Directory Services restore mode, NTDSUtil, Authoritative &amp; non-authoritative restoration, rebuilding.
<br /><span>Hands on</span> NTDSUtil.
</p>
      </ul>

Microsoft Active Directory

<h2>Portfolio Management Skills: In-House Training</h2>
<p>The main purpose of this workshop is to equip and enable people in a portfolio management office and PMO to effectively and efficiently support the Executive Leadership and Operational Management to plan, implement, manage, and evolve portfolio management in their organization. There is a deliberate focus on preparing you to become a strong and effective change advocate for meaningful portfolio management that delivers objective measurements of benefit contribution towards the strategic objectives to lead, manage, and continuously improve portfolio management governance, processes, and frameworks with and through the direction of a portfolio practice, principles, and delivery boards.</p><h3>What you Will Learn</h3>
<p>At the end of this program, you will be able to:</p>
<ul>
<li>Articulate the benefits of portfolio management</li>
<li>Link the initiatives in an organization with its strategic objectives</li>
<li>Participate in the introduction of portfolio management in an organization</li>
<li>Create or improve the portfolio governance structure</li>
<li>Lead the inventory of ongoing and new initiatives</li>
<li>Assist the executives in the prioritization of initiatives through the use of Multi-criteria Analysis and other selection tools</li>
<li>Support the executives in balancing the portfolio based on the optimal use of resources and priorities</li>
<li>Create a portfolio delivery plan</li>
<li>Define thresholds and variance reporting criteria</li>
<li>Assist the executives and the financial team in the definition of Stage Gate Funding</li>
<li>Lead the Stage Gate reviews</li>
<li>Analyze the benefits that are being realized by the initiatives</li>
</ul><section>
                    <h3>Foundation Concepts</h3><ul><li>Definitions</li><li>Benefits of Portfolio Management</li><li>Objectives of Portfolio Management</li><li>Portfolio Life Cycles</li></ul><h3>Governing the Portfolio</h3><ul><li>Portfolio Governance structure</li><li>Roles and responsibilities</li><li>Initial activities when starting portfolio management</li></ul><h3>Prioritizing Initiatives</h3><ul><li>Prioritize purpose</li><li>Multi-Criteria Analysis</li><li>Analytical Hierarchy Process (AHP)</li><li>Strategic alignment</li></ul><h3>Balancing the Portfolio</h3><ul><li>Allocating resources and budgets</li><li>Communicating decisions of initiatives status</li></ul><h3>Planning the Portfolio</h3><ul><li>Planning review cycles</li><li>Using Stage Gate Funding</li><li>Setting thresholds and variance reporting</li><li>Tool examples</li></ul><h3>Managing the Portfolio Delivery</h3><ul><li>Project and Program Life Cycles</li><li>Stage Gate Reviews</li><li>Loop back to Prioritize, Balance and Plan</li><li>Interaction with the Portfolio Delivery Board</li><li>Project, Program and Functional Managers' roles and responsibilities</li></ul>


                </section>

Portfolio Management Skills: In-House Training

<h3><b>MySQL for developers training course description</b></h3>
        <p>  This MySQL Developers training course is designed for MySQL Developers who have a good understanding of a MySQL database and experience of using SQL commands. The course provides further practical experience in more advanced MySQL commands and SQL statements including Stored Routines, Triggers and Event Scheduling. </p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
                      <li>Provide the skills needed to write more advanced queries and database maintenance statements on a MySQL database.</li>
<li>Use advanced features of the MySQL Client.</li>
<li>Use advanced data types.</li>
<li>Manage the structure of databases and tables.</li>
<li>Manage and using indexes.</li>
<li>Write complex SQL query statements.</li>
<li>Use advanced SQL expressions.</li>
<li>Use advanced SQL functions.</li>
<li>Perform advanced Insert, Update, Delete, Replace and Truncate Operations.</li>
<li>Use user variable syntax and properties.</li>
<li>Import and export data from within MySQL.</li>
<li>Import and export data from the command line.</li>
<li>Perform complex joins to access multiple tables.</li>
<li>Perform complex subqueries.</li>
<li>Create, manage and us views.</li>
<li>Use prepared statements.</li>
<li>Create and use stored routines.</li>
<li>Create and use triggers.</li>
<li>Obtain database metadata.</li>
<li>Optimize queries.</li>
<li>Work with the main storage engines.</li>
<li>Debug MySQL applications.</li>

                  </ul>
        <h5>
        <b>MySQL for developers training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>MySQL Developers who have a basic understanding of a MySQL database and SQL commands as covered on the Introduction to MySQL course.</p>
              
							<li><b>Prerequisites:</b></li>
							
							<p>MySQL foundation </p>
              
							<li><b>Duration</b></li>
							
              <p>5 days</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>MySQL for developers training course contents</b></h3>
      <ul>
        <li>Introduction </li><p>
Administration and Course Materials, Course Structure and Agenda, Delegate and Trainer Introductions.

</p><li>Client/server concepts </li><p>
MySQL client/server architecture, Server modes, Using client programs, Logging in options, Configuration files, Precedence of logging in options
<br /><span>Hands on</span> Using client/server

</p><li>The MySQL client program </li><p>
Using MySQL interactively, The MySQL prompts, Client commands and SQL statements, Editing, Selecting a database, Help, Safe updates, Using script files, Using a source file, Redirecting output into a file, Command line execution, Mysql output formats, Overriding the defaults, Html and xml output, MySQL Utilities.
<br /><span>Hands on</span> Using the MySQL client program

</p><li>Data types </li><p>
Bit data type, Numeric data types, Auto_increment, Character string data types, Character sets and collation, Binary string data types, Enum and Set data types, Temporal data types, Timezone support, Handling Missing Or Invalid Data Values, SQL_MODE options.
<br /><span>Hands on</span> Using data types 

</p><li>Identifiers </li><p>
Using Quotes with identifier naming, Case sensitivity in Identifier naming, Qualifying columns with table and database names, Using reserved words as identifiers, Function names
<br /><span>Hands on</span> Using identifiers

</p><li>Databases </li><p>
Database properties, Creating a database, Selecting a database, Altering databases, Dropping databases, Obtaining database metadata, The SHOW command, The INFORMATION_SCHEMA database, The SHOW CREATE command
<br /><span>Hands on</span> Using databases

</p><li>Tables and indexes </li><p>
Table properties, Creating tables, Create table using Select or Like, Temporary tables and memory tables, Altering tables, Adding columns, Changing column widths and types, Renaming columns, Dropping columns, Adding constraints, Dropping constraints, Renaming tables, Change the table storage engine, Multiple alterations, Dropping tables, Emptying tables, Obtaining table metadata, Show create table, The information_schema, Index introduction, Structure of a mysql index, Creating and dropping indexes, Creating an index, Altering a table to add an index, Specifying index type, Dropping indexes, Obtaining Index Metadata.
<br /><span>Hands on</span> Creating, altering and dropping tables/indexes

</p><li>Querying for data </li><p>
The SQL select statement and MySQL differences, Advanced order by, Order by and collation, Order by with enum datatype, Order by with Set datatype, Ordering with distinct and group by Special features of union, Limit and order by clauses, Group By clause, Group_concat, Using Rollup in a Group By clause.
<br /><span>Hands on</span> Querying for data

</p><li>SQL Expressions and functions </li><p>
Components of expressions, Nulls, Numeric expressions, String expressions, Temporal expressions, Comparison functions, Flow control functions, Numeric functions, String functions, Temporal functions.
<br /><span>Hands on</span> Using expressions and functions

</p><li>Updating data </li><p>
Update operations and privileges, Inserting rows, Insert using a set clause, Inserting duplicate values, Replacing rows, Updating rows, Update using the order by and limit clauses, Deleting rows, The delete and truncate statements.
Exercise: Inserting, updating, replacing and deleting data

</p><li>Connectors 	</li><p>
MySQL client interfaces, MySQL connectors, Oracle and community conectors, Connecting to MySQL server using Java and PHP connectors, MySQL and NoSQL, Innodb integration with memcached.

</p><li>Obtaining database metadata </li><p>
What is metadata?, The mysqlshow utility, The show and describe commands, Describing tables, The information_schema, Listing tables, Listing columns, Listing views, Listing key_columns_usage.
<br /><span>Hands on</span> Obtaining database metadata

</p><li>Debugging 	</li><p>
Mysql error messages, The show statement, Show errors, Show count(*) errors, Show warnings, Show count(*) warnings, Note messages, The perror utility.
<br /><span>Hands on</span> Debugging

</p><li>Joins </li><p>
Overview of inner joins, Cartesian product, Inner joins with original syntax, Non equi-join, Using table aliases to avoid name clashes, Inner Joins With ISO/ANSI Syntax, Outer Joins, Left outer joins, Right outer joins, Full outer joins, Updating multiple tables simultaneously, Updating rows in one table based on a condition in another, Updating rows in one table reading data from another, Deleting from multiple tables simultaneously, Deleting rows in one table based on a condition in another.
<br /><span>Hands on</span> Coding joins

</p><li>Subqueries 	</li><p>
Types of subquery, Multiple-column subqueries, Correlated subqueries, Using the ANY, ALL and SOME operators, Using the EXISTS operator, Subqueries as scalar expressions, Inline views, Converting subqueries to joins, Using subqueries in updates and deletes.
<br /><span>Hands on</span> Coding subqueries

</p><li>Views </li><p>
Why views are used, Creating views, View creation restrictions, View algorithms, Updateable views, Altering and dropping views, Displaying information about views, Privileges for views.
<br /><span>Hands on</span> Using views

</p><li>Import and Export </li><p>
Exporting using SQL, Privileges required to export data, Importing using SQL, Messages when loading data, Privileges required to load data, Exporting from the command line, Mysqldump main options, Importing from the command line, Mysqlimport main options.
<br /><span>Hands on</span> Importing and exporting

</p><li>User variables and prepared statements </li><p>
Creating User variables, User variables in a select, Prepared statements, The prepare statement, The execute statement, The deallocate statement, Using prepared statements in code, with connectors.
<br /><span>Hands on</span> Using variables and prepared statements

</p><li>Introduction to stored routines </li><p>
Types of stored routines, Benefits of stored routines, Stored routine features, Differences between procedures and functions, Introduction to the Block, Declaring variables and constants, Assigning values to variables, Definer rights and invoker rights, Using SELECT in stored routines, Altering and dropping stored routines, Obtaining stored routine metadata, Stored routine privileges and execution security.
<br /><span>Hands on</span> Writing simple stored routines

</p><li>Stored routines - program logic </li><p>
The IF .. THEN .. ELSEIF construct, The CASE statement, The basic loop, The while loop, The repeat loop, The iterate statement, Nested loops.
<br /><span>Hands on</span> Writing stored routines with program logic

</p><li>Stored routines - exception handlers and cursors </li><p>
Dealing with errors using Exception handlers, Cursors, What is a cursor?, Cursor operations, Declaring cursors, Opening and closing cursors, Fetching rows, Status checking.
<br /><span>Hands on</span> Writing stored routines with program logic

</p><li>Procedures with parameters </li><p>
Creating procedures with parameters, Calling Procedures With Parameters.
<br /><span>Hands on</span> Writing stored routines with parameters

</p><li>Functions 	</li><p>
What is a function?, The create function statement, Executing functions, Executing functions from code, Executing functions from SQL statements, The deterministic and SQL clauses.
<br /><span>Hands on</span> Writing functions

</p><li>Triggers </li><p>
Trigger creation, Restrictions on triggers, The create trigger statement, Using the old and new qualifiers, Managing triggers, Destroying triggers, Required privileges.
<br /><span>Hands on</span> Writing triggers

</p><li>Basic optimizations </li><p>
Normalisation of data to third normal form, Using indexes for optimization, General query enhancement, Using Explain to analyze queries, Choosing an INNODB or MYISAM storage engine, Using MySQL Enterprise Monitor in query optimization.
<br /><span>Hands on</span> Making use of basic optimizations

</p><li>More about indexes </li><p>
Indexes and joins
<br /><span>Hands on</span> Investigating indexes and joins
				</p>
      </ul>

MySQL for developers

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p>The primary audience for this course are persons who are new to reporting with MicrosoftÂ© SQL ServerÂ© Report Builder and SSRS, persons who are transitioning from another reporting software application, and persons who are existing Report Builder and SSRS report authors. The secondary audience for this course are persons who are using Report Designer (SSRS). Course participants may be business analysts, programmer analysts, data analysts, database administrators, or IT professionals and may or may not have experience with MicrosoftÂ© SQL ServerÂ© Report Builder and SSRS, programming (Visual Basic), and/or Transact-Structured Query Language (T-SQL) experience.</p>Overview<p>After completing this course, students will be able to: Create parameter reports. Create list reports. Format reports with complex expressions. Add images and subreports. Add drilldown and drillthrough functionality. Add sparklines, data bars, and indicators.</p><p>In this course, students will continue their learning on the foundations of report writing with MicrosoftÂ© SQL ServerÂ© Report Builder and SSRS. The focus will be on report creation by connecting to a database and manipulating the data.</p></div><div id="course-pills-2"><h3>1 - Parameter Reports</h3> <ul> <li>Parameterized Reporting</li> <li>Create Report Parameters</li> <li>Modify Report Parameters</li> <li>Provide Default Parameter Values</li> <li>Provide Available Values for Parameters</li> <li>Lab: Creating Parameterized Reports</li> </ul> <h3>2 - List Data Regions</h3> <ul> <li>Introducing the List Data Region</li> <li>Create Reports Using List Data Regions</li> <li>Modify Reports Which Use List Data Regions</li> <li>Lab: Creating List Reports</li> </ul> <h3>3 - Enhancing Reports with Complex Expressions</h3> <ul> <li>Formatting Reports</li> <li>Top N Reports</li> <li>Running Values</li> <li>Lab: Enhancing Reports with Complex Expressions</li> </ul> <h3>4 - Enhance Reports with Images and Subreports</h3> <ul> <li>Add Images to Reports</li> <li>Retrieve Images from a Database</li> <li>Introducing SSRS (SQL Server Reporting Services) Report Server</li> <li>Add Subreports to Reports</li> <li>Lab: Working With Images and Subreports</li> </ul> <h3>5 - Drilldown and Drillthrough Reports</h3> <ul> <li>Add and Configure Drilldown Reporting</li> <li>Add and Configure Drillthrough Reporting</li> <li>Lab: Add Drilldown and Drillthrough Functionality to Reports</li> </ul> <h3>6 - Sparklines, Data Bars, and Indicators</h3> <ul> <li>Sparklines</li> <li>Data Bars</li> <li>Indicators</li> <li>Lab: Adding Sparklines, Data Bars, and Indicators to Reports</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans 55128 Writing Reports with Report Builder and SSRS Level 2 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 55128 Writing Reports with Report Builder and SSRS Level 2 course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Nexus Human

SSRS

Service Design Courses (SDC)

Report Writing

Manager Training

Trainers Course

Teaching & Training

55128 Writing Reports with Report Builder and SSRS Level 2

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

Bayfield Training

Financial Modelling & Analysis

Real Estate Finance

Financial Modelling

Financial Analysis

Professional Development

Continuous Professional Development (CPD)

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


An Introduction to Real Estate (12 Hours Online Self-Study)

Bournemouth

London Waterloo Academy

Dental Nurse

Dental Assistant

VIRTUAL DENTAL NURSING DIPLOMA

Registration Fee

Tuition Fee

Exam Fee

One Day Introduction Course

<div data-hook="bgLayers" style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><div data-mesh-id="comp-lmkyrn781inlineContent-gridContainer" data-testid="mesh-container-content" fr-original-style="" style="box-sizing: border-box;"><div data-testid="richTextElement" fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));">This CPD accredited Level 3 course will qualify you as an 1st party internal auditor and a 2nd party supplier auditor. It is a useful precursor to becoming a 3rd party Lead Auditor. The course content has been developed by experienced Lead Auditors.</p><p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));">It focuses on auditor competencies and best practice for auditing today&rsquo;s industries.</p><p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));">This course is applicable to any and all industries that need to comply with specified standards and mitigate risk by checking compliance through auditing and inspection. It applies to businesses requiring confidence in their suppliers and to manage their approval through supplier audits. These industries include food, packaging, storage &amp; distribution, pharmaceutical, medical device, automotive etc. It is also applicable to systems and controls applicable to all industries such as health &amp; safety.</p><p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));">Holders of the qualification will have the knowledge necessary to effectively audit and inspect professionally and ethically for compliance, and to identify risks that require mitigation.&nbsp;</p><p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));">By the end of this course you will be able to:</p><ul style="color: rgb(var(--color_25)); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));"><li fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));">Define purpose, benefit &amp; limitations of audits</p></li><li fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));">Use auditing techniques &amp; have required competencies</p></li><li fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));">Plan &amp; conduct audits</p></li><li fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));">Audit against the appropriate standards</p></li><li fr-original-style="" style="box-sizing: border-box;"><p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));">Assess and critique sites</p></li></ul><p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));">A learner will receive a Certificate of Achievement upon successful completion of the exam.</p><p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));">&nbsp;This course has been accredited by the CPD Accreditation Office for delivery, structure and content.</p></div></div></div>

This CPD accredited Level 3 course will qualify you as an 1st party internal auditor and a 2nd party supplier auditor. It is a useful precursor to becoming a 3rd party Lead Auditor. The course content has been developed by experienced Lead Auditors.
It focuses on auditor competencies and best practice for auditing today’s industries.
This course is applicable to any and all industries that need to comply with specified standards and mitigate risk by checking compliance through auditing and inspection. It applies to businesses requiring confidence in their suppliers and to manage their approval through supplier audits. These industries include food, packaging, storage & distribution, pharmaceutical, medical device, automotive etc. It is also applicable to systems and controls applicable to all industries such as health & safety.
Holders of the qualification will have the knowledge necessary to effectively audit and inspect professionally and ethically for compliance, and to identify risks that require mitigation. 
By the end of this course you will be able to:
Define purpose, benefit & limitations of audits
Use auditing techniques & have required competencies
Plan & conduct audits
Audit against the appropriate standards
Assess and critique sites
A learner will receive a Certificate of Achievement upon successful completion of the exam.
 This course has been accredited by the CPD Accreditation Office for delivery, structure and content.

Ask Sonia Limited

Food Safety

Internal Auditing

Auditor

CPD accredited Level 3 Effective Auditing & Inspection course. 
Delivered online (Zoom) by a live tutor.
Exam and Certificate fee included in the price.

CPD Accredited Effective Auditing & Inspection Level 3 (1 day)

Belfast

<div style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">The purpose of this&nbsp;qualification&nbsp;is to enable&nbsp;learners to develop the&nbsp;knowledge and skills&nbsp;so they can engage, facilitate, educate and support clients in a gym or health club environment.</span></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);"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Completing this qualification allows learners to access Gym Instructor jobs.</span></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);"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong style="color: rgb(235, 92, 35); font-weight: 700; box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(235, 92, 35);">Qualification Structure:</strong></span></p><li id="isPasted" style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Unit 1 &ndash; Anatomy &amp; physiology for exercise &amp; fitness instructors</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Unit 2 &ndash; Providing a positive customer experience in the exercise environment</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Unit 3 &ndash; Lifestyle management &amp; health awareness</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Unit 4 &ndash; Gym-based programme planning and preparation</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Unit 5 &ndash; Gym-based programme delivery and professional instruction</li><div fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong style="color: rgb(235, 92, 35); font-weight: 700; box-sizing: border-box;" fr-original-style=" color: rgb(235, 92, 35);"><br fr-original-style="" style="box-sizing: border-box;"></strong></span></div><div fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong style="color: rgb(235, 92, 35); font-weight: 700; box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(235, 92, 35);">Entry Requirements:</strong></span></div><div fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 0, 0); font-size: 16px; box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(0, 0, 0); font-size: 16px;">Learners must be aged 16 plus. Ideally they should have some experience of gym-based exercises as participation in a variety of gym-based practical sessions will be required throughout the qualification. Learners should also have communication skills pitched at level 2 which can be developed during the course.</span><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></div><div fr-original-style="" style="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></div><div id="isPasted" fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong style="color: rgb(235, 92, 35); font-weight: 700; box-sizing: border-box;" fr-original-style=" color: rgb(235, 92, 35);">Assessments:</strong></span></div><ul style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Multiple choice test</span><p style="color: rgb(0, 0, 0); text-align: left; font-size: var(--font-size); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); text-align: left;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Assessment workbook</span></p><p style="color: rgb(0, 0, 0); text-align: left; font-size: var(--font-size); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); text-align: left;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Observation of practical skills</span></p><p style="color: rgb(0, 0, 0); text-align: left; font-size: var(--font-size); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0); text-align: left;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Portfolio of evidence (Learner assessment record)</span></p></ul></div><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><br fr-original-style="" style="box-sizing: border-box;"></div>

The purpose of this qualification is to enable learners to develop the knowledge and skills so they can engage, facilitate, educate and support clients in a gym or health club environment.
Completing this qualification allows learners to access Gym Instructor jobs.
Qualification Structure:
Unit 1 – Anatomy & physiology for exercise & fitness instructors
Unit 2 – Providing a positive customer experience in the exercise environment
Unit 3 – Lifestyle management & health awareness
Unit 4 – Gym-based programme planning and preparation
Unit 5 – Gym-based programme delivery and professional instruction
Entry Requirements:Learners must be aged 16 plus. Ideally they should have some experience of gym-based exercises as participation in a variety of gym-based practical sessions will be required throughout the qualification. Learners should also have communication skills pitched at level 2 which can be developed during the course.

Assessments:
Multiple choice test
Assessment workbook
Observation of practical skills
Portfolio of evidence (Learner assessment record)

Platinum Training Institute

Physical Activity

The purpose of this qualification is to enable learners to develop the knowledge and skills so they can engage, facilitate, educate and support clients in a gym or health club environment.

Completing this qualification allows learners to access Gym Instructor jobs.

YMCA Level 2 Certificate in Gym Instructing

<div style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(0, 0, 0);">The purpose&nbsp;of these qualifications is to enable learners to coach clients &ndash; one to one and in small groups &ndash; towards their health and fitness goals. Learners will develop the knowledge, skills and behaviours to plan and deliver creative and personalised exercise programmes, provide nutritional advice and support clients with their overall lifestyle management.</span></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);"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong style="color: rgb(235, 92, 35); font-weight: 700; box-sizing: border-box;" fr-original-style=" color: rgb(235, 92, 35);">This qualification is mapped directly to:</strong></span></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);"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">The Chartered Institute for the Management of Sport and Physical Activity (CIMSPA) professional standards for a Personal Trainer.</span></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);"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong style="color: rgb(235, 92, 35); font-weight: 700; box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(235, 92, 35);">Qualification Structure:</strong></span></p><ul style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><li id="isPasted" fr-original-style="" style="box-sizing: border-box;">Unit 1: Anatomy &amp; physiology for exercise &amp; fitness instructors</li><li fr-original-style="" style="box-sizing: border-box;">Unit 2: Providing a positive customer experience in the exercise environment</li><li fr-original-style="" style="box-sizing: border-box;">Unit 3: Lifestyle management &amp; health awareness</li><li fr-original-style="" style="box-sizing: border-box;">Unit 4: Gym-based programme planning and preparation</li><li fr-original-style="" style="box-sizing: border-box;">Unit 5: Gym-based programme delivery and professional instruction</li><li fr-original-style="" style="box-sizing: border-box;">Unit 6: Applied anatomy and physiology</li><li fr-original-style="" style="box-sizing: border-box;">Unit 7: Promoting wellness through client motivation and interaction</li><li fr-original-style="" style="box-sizing: border-box;">Unit 8: Bespoke exercise programme design</li><li fr-original-style="" style="box-sizing: border-box;">Unit 9: Customised exercise programme instruction and communication techniques</li><li fr-original-style="" style="box-sizing: border-box;">Unit 10: Nutrition to support physical activity</li><li fr-original-style="" style="box-sizing: border-box;">Unit 11: Business acumen for a successful Personal Training Practice</li></ul><div fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong style="color: rgb(235, 92, 35); font-weight: 700; box-sizing: border-box;" fr-original-style=" color: rgb(235, 92, 35);"><br fr-original-style="" style="box-sizing: border-box;"></strong></span></div><div fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong style="color: rgb(235, 92, 35); font-weight: 700; box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(235, 92, 35);">Entry Requirements:</strong></span></div><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(0, 0, 0);">Learners must be aged 16 plus. Ideally they should have some experience of gym-based exercises as participation in a variety of gym-based practical sessions will be required throughout the qualification. Learners should also have communication skills pitched at level 2 which can be developed during the course.</span></p><div fr-original-style="" style="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></div><div id="isPasted" fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong style="color: rgb(235, 92, 35); font-weight: 700; box-sizing: border-box;" fr-original-style=" color: rgb(235, 92, 35);">Assessments:</strong></span></div><div style="color: rgb(105, 105, 105); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(105, 105, 105);"><section fr-original-style="" style="box-sizing: border-box;"><div data-tags="{All} " fr-original-style="" style="box-sizing: border-box;"><div itemprop="text" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Multiple choice test</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Assessment workbook</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Observation of practical skills</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Portfolio of evidence (Learner assessment record)</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><div id="isPasted" fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong style="color: rgb(235, 92, 35); font-weight: 700; box-sizing: border-box;" fr-original-style=" color: rgb(235, 92, 35);">Add Ons:</strong></span></div><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">If you choose the <em fr-original-style="" style="box-sizing: border-box;">Gold</em> or <em fr-original-style="" style="box-sizing: border-box;">Platinum</em> Course you will receive the following:</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 style="color: rgb(235, 92, 35); font-weight: 700; box-sizing: border-box;" fr-original-style=" color: rgb(235, 92, 35);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">NASM Certified Nutrition Coach (CNC) - </span></strong><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><em fr-original-style="" style="box-sizing: border-box;">*Platinum Only</em></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">NASM Behaviour Change Science: Help Clients Stick with their Programme</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">NASM Speed Agility and Quickness Training</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">NASM Navigating Diets</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">NASM Anatomy of a Research paper: How to Read beyond the Abstract</strong></span></p></div><br fr-original-style="" style="box-sizing: border-box;"></div></section></div></div><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><br fr-original-style="" style="box-sizing: border-box;"></div>

The purpose of these qualifications is to enable learners to coach clients – one to one and in small groups – towards their health and fitness goals. Learners will develop the knowledge, skills and behaviours to plan and deliver creative and personalised exercise programmes, provide nutritional advice and support clients with their overall lifestyle management.
This qualification is mapped directly to:
The Chartered Institute for the Management of Sport and Physical Activity (CIMSPA) professional standards for a Personal Trainer.
Qualification Structure:
Unit 1: Anatomy & physiology for exercise & fitness instructors
Unit 2: Providing a positive customer experience in the exercise environment
Unit 3: Lifestyle management & health awareness
Unit 4: Gym-based programme planning and preparation
Unit 5: Gym-based programme delivery and professional instruction
Unit 6: Applied anatomy and physiology
Unit 7: Promoting wellness through client motivation and interaction
Unit 8: Bespoke exercise programme design
Unit 9: Customised exercise programme instruction and communication techniques
Unit 10: Nutrition to support physical activity
Unit 11: Business acumen for a successful Personal Training Practice
Entry Requirements:
Learners must be aged 16 plus. Ideally they should have some experience of gym-based exercises as participation in a variety of gym-based practical sessions will be required throughout the qualification. Learners should also have communication skills pitched at level 2 which can be developed during the course.
Assessments:
Multiple choice test
Assessment workbook
Observation of practical skills
Portfolio of evidence (Learner assessment record)


Add Ons:
If you choose the Gold or Platinum Course you will receive the following:
NASM Certified Nutrition Coach (CNC) - *Platinum Only
NASM Behaviour Change Science: Help Clients Stick with their Programme
NASM Speed Agility and Quickness Training
NASM Navigating Diets
NASM Anatomy of a Research paper: How to Read beyond the Abstract

NASM

Personal Trainer

Coaching

Sport

Fitness

The purpose of these qualifications is to enable learners to coach clients – one to one and in small groups – towards their health and fitness goals. Learners will develop the knowledge, skills and behaviours to plan and deliver creative and personalised exercise programmes, provide nutritional advice and support clients with their overall lifestyle management.

PTI Diploma in Personal Training

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This course will prepare participants to take the FC0-U61 exam to obtain the IT Fundamentals+ certification and help participants learn some of the basic principles and techniques of providing PC, mobile, applications, and network support.</p>Overview<p>On course completion, participants will be able to: - Set up a computer workstation and use basic software applications. - Explain the functions and types of devices used within a computer system. - Apply basic computer maintenance and support principles. - Describe some principles of software and database development. - Configure computers and mobile devices to connect to home networks and to the Internet. - Identify security issues affecting the use of computers and networks.</p><p>This course will prepare participants to take the FC0-U61 exam to obtain the IT Fundamentals+ certification and help participants learn some of the basic principles and techniques of providing PC, mobile, applications, and network support.</p></div><div id="course-pills-2"><h3>1 - Identifying Computer Hardware</h3> <ul> <li>Identify Types of Computing Devices</li> <li>Identify Internal Computer Components</li> <li>Common Computer Connector Types</li> <li>Identify Common Peripheral Devices</li> </ul> <h3>2 - Identifying Computer Software</h3> <ul> <li>Compare Functions and Features of Common Operating Systems</li> <li>Identify Application Software</li> </ul> <h3>3 - Setting Up a Basic Workstation</h3> <ul> <li>Connect Hardware</li> <li>Install and Configure Operating Systems</li> <li>Install and Configure Applications</li> <li>Configure Accessibility Options</li> </ul> <h3>4 - Configuring Network Access</h3> <ul> <li>Network Connection Types</li> <li>Install and Configure a SOHO Router</li> <li>Network and Alternative Technologies</li> <li>Sharing and Storage Methods</li> </ul> <h3>5 - Working with Files, Folders, and Applications</h3> <ul> <li>Create Files</li> <li>Navigate a File Structure</li> <li>Manage Files and Folders</li> <li>Compress and Extract Files</li> <li>Create Screen Captures</li> </ul> <h3>6 - Configuring and Using Wireless Devices</h3> <ul> <li>Configuring Wireless Devices</li> <li>Use Wireless Devices</li> </ul> <h3>7 - Securing Computing Devices</h3> <ul> <li>Identify Security Threats</li> <li>Apply Security Best Practices</li> <li>Perform Secure Web Browsing</li> </ul> <h3>8 - Supporting Computers and Users</h3> <ul> <li>Environmental and Safety Concepts</li> <li>Back Up and Restore Data</li> <li>Manage Software</li> <li>Implement Basic Support Measures</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans CompTIA IT Fundamentals Plus Certification (ITF Plus) (Exam FCO-U61) 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 CompTIA IT Fundamentals Plus Certification (ITF Plus) (Exam FCO-U61) 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>

CompTIA Network+

IT Certifications

IT Networking Fundamentals

CompTIA A+

CompTIA Security+

CompTIA IT Fundamentals+

<p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(var(--color_25));">This combined HACCP and Food Safety Level 4 course, developed by STC and accredited by the CPD Accreditation Office, will give you a 2 in 1 qualification which is unique. Other training providers only provide these as separate qualifications, however STC has challenged this practice since &ldquo;you can&rsquo;t know HACCP without food safety, and you can&rsquo;t know food safety without HACCP!&rdquo; And at Ask Sonia Ltd, we whole heartedly agree!</p><p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));">We are very proud to offer this accredited qualification to those involved with any and all aspects in a food business relating to HACCP &amp; Food Safety.&nbsp;</p><p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));">Holders of the qualification will have the knowledge necessary to be an integral part of a food business as well as part of Technical &amp; Quality departments and HACCP team members, team leaders, consultants or trainers. The qualification is also suitable for those working in related industries, such as packaging, storage &amp; distribution.</p><p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));">The qualification is also relevant to those owning/managing smaller food businesses to give them the underpinning knowledge to develop a HACCP study and understand the fundamentals of food safety.</p><p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));">Attendees should already have knowledge of food safety hazards and controls, as this course will take the attendee through the intermediate levels at the start, and build up to provide the required advanced level of knowledge and understanding by the end of the course.</p><p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));">HACCP and food safety training is regarded by the Foods Standards Agency as being important to maintaining good practice in the production of safe food.</p><p style="color: rgb(var(--color_25)); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(var(--color_25));">This course has been accredited by the CPD Accreditation Office for delivery, structure and content.</p>

This combined HACCP and Food Safety Level 4 course, developed by STC and accredited by the CPD Accreditation Office, will give you a 2 in 1 qualification which is unique. Other training providers only provide these as separate qualifications, however STC has challenged this practice since “you can’t know HACCP without food safety, and you can’t know food safety without HACCP!” And at Ask Sonia Ltd, we whole heartedly agree!
We are very proud to offer this accredited qualification to those involved with any and all aspects in a food business relating to HACCP & Food Safety. 
Holders of the qualification will have the knowledge necessary to be an integral part of a food business as well as part of Technical & Quality departments and HACCP team members, team leaders, consultants or trainers. The qualification is also suitable for those working in related industries, such as packaging, storage & distribution.
The qualification is also relevant to those owning/managing smaller food businesses to give them the underpinning knowledge to develop a HACCP study and understand the fundamentals of food safety.
Attendees should already have knowledge of food safety hazards and controls, as this course will take the attendee through the intermediate levels at the start, and build up to provide the required advanced level of knowledge and understanding by the end of the course.
HACCP and food safety training is regarded by the Foods Standards Agency as being important to maintaining good practice in the production of safe food.
This course has been accredited by the CPD Accreditation Office for delivery, structure and content.

HACCP

CPD accredited Advanced (Level 4) HACCP & Food Safety training course. 
Delivered online (Zoom) by a live tutor.
Exam and Certificate fee included in the price.

CPD Accredited Advanced Combined HACCP & Food Safety Level 4 (5 days)

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

Azure PowerShell

Powershell

Microsoft AZ-104

Power Automate

Microsoft AZ-303

Microsoft Power Automate

AZ-040T00 Automating Administration with Powershell

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

619 Courses in London

Laparoscopic Suturing Course

By CCMIG

Total PHP for developers

By Systems & Network Training

Masters in IPSAS

By GBA Corporate

Total SNMP for engineers

By Systems & Network Training

IPSAS

By GBA Corporate

LTE optimisation and capability

By Systems & Network Training

Portfolio Management Skills

By IIL Europe Ltd

Microsoft Active Directory

By Systems & Network Training

Portfolio Management Skills: In-House Training

By IIL Europe Ltd

MySQL for developers

By Systems & Network Training

Search By Location