Bury St Edmunds

Thetford

<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;" id="isPasted" fr-original-style="color: rgb(0, 0, 0);">Embark on a transformative journey with our Level 4 Certificate in First Response Emergency Care (FREC 4). This comprehensive course, developed in line with the esteemed guidelines of the Resuscitation Council (UK), Skills for Health, and the Faculty of Pre-Hospital Care (RCS Ed), is designed to enhance your abilities in delivering superior emergency care across various settings.</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);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(0, 0, 0);">This course is tailor-made for those seeking to expand their expertise in the NHS, private ambulance services, or specialised roles in the military, police, and fire services. It&#39;s a stepping stone for those dedicated to saving lives and providing care when it matters most.</span><br fr-original-style="" style="box-sizing: border-box;"></span></p><h4 style="color: var(--headingSmallColor); box-sizing: border-box;" id="isPasted" fr-original-style=" color: var(--headingSmallColor);"><span style="color: hsla(var(--darkAccent-hsl),1); box-sizing: border-box;" fr-original-style=" color: hsla(var(--darkAccent-hsl),1);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Dynamic Course Structure</strong></span></h4><ul data-rte-list="default" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><li fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Rich Learning Experience:</strong>&nbsp;Delve into 180 hours of <a href="https://nrmedical.training/pre-hospital-training/rtacc" style="color: var(--paragraphLinkColor); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: var(--paragraphLinkColor);">immersive learning</a>, including at least 39 hours of interactive, guided instruction.</p></li><li fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Engaging Content:</strong> The course comprises a singular, robust unit segmented into three captivating components.</p></li><li fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Flexible Completion:</strong> Complete this enriching journey within 12 months, including any necessary referrals.</p></li></ul><h4 style="color: var(--headingSmallColor); box-sizing: border-box;" fr-original-style=" color: var(--headingSmallColor);"><span style="color: hsla(var(--darkAccent-hsl),1); box-sizing: border-box;" fr-original-style=" color: hsla(var(--darkAccent-hsl),1);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Your Pathway to the Course</strong></span></h4><ul data-rte-list="default" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><li fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Age Requirement:</strong> You should be 18 or older to start this life-changing course.</p></li><li fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Prerequisites:</strong> A valid Qualsafe Level 3 Award in First Response Emergency Care (RQF) or equivalent is your gateway to this advanced level.</p></li><li fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Literacy Proficiency:</strong> We recommend a minimum of Level 2 in literacy or equivalent to fully benefit from the course content.</p></li></ul><h4 style="color: var(--headingSmallColor); box-sizing: border-box;" fr-original-style=" color: var(--headingSmallColor);"><span style="color: hsla(var(--darkAccent-hsl),1); box-sizing: border-box;" fr-original-style=" color: hsla(var(--darkAccent-hsl),1);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Beyond the Course</strong></span></h4><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">This qualification doesn&rsquo;t just end with a certificate. It paves the way for further educational endeavours and career growth in related fields. Keep the learning alive with ongoing CPD and annual refresher training.</p><h4 style="color: var(--headingSmallColor); box-sizing: border-box;" fr-original-style=" color: var(--headingSmallColor);"><span style="color: hsla(var(--darkAccent-hsl),1); box-sizing: border-box;" fr-original-style=" color: hsla(var(--darkAccent-hsl),1);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Dual-Instructor Advantage on Our FREC 4 Courses!</strong></span></h4><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">At NR Medical Training, we distinguish ourselves from other training centres by consistently conducting our FREC 3 and FREC 4 courses with a <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">minimum of two expert instructors</strong>, comprised of experienced Paramedics and EMTs. This approach sets us apart in the field of emergency care training, as many other centres often provide only the minimum requirement of one instructor per course. Our commitment to having at least two highly qualified professionals allows us to offer a far more immersive and dynamic learning environment. This dual-instructor model not only enhances the depth and breadth of the training scenarios, making them more realistic and engaging, but also gives our learners the unique advantage of drawing upon a wider pool of real-world experience and expertise. This enriched learning atmosphere ensures that our trainees receive the most comprehensive and practical education, preparing them to excel in high-pressure emergency situations.</p>

NR Medical Training

This comprehensive course, developed in line with the esteemed guidelines of the Resuscitation Council (UK), Skills for Health, and the Faculty of Pre-Hospital Care (RCS Ed), is designed to enhance your abilities in delivering superior emergency care across various settings.

FREC 4

Stockport 

At CAPE Coaching & Development, we understand the value of effective and impactful development. This September and October 2024, we’re offering 90-minute interactive online workshops designed to empower your teams and drive success.
Choose from our tailored topics:
1. Dealing with Imposter Syndrome: Understand why it happens and learn practical strategies to overcome it.
2. Stress and Resilience: Discover the true meaning of resilience, its link to wellbeing, and why it’s crucial both at work and home. Learn key techniques to manage stress and create a personal resilience template.
3. Emotional Intelligence: Unlock the secret to workplace success. Explore its importance, how to develop it, and its impact on professional relationships.
4. Critical Thinking and Problem Solving: Learn how to get unstuck, make better decisions, and focus on the right tasks.
5. Motivating Yourself and Others: Understand why the carrot and stick approach falls short and discover more effective motivation strategies.
Exceptional Value: Only £495 plus VAT per workshop.
Don’t miss out on this opportunity to bring high-impact development to your organisation. 
CAPE's Commitment
At CAPE Coaching & Development, we are dedicated to providing high-quality, impactful development that truly makes a difference. Our workshops are designed to be engaging, practical, and relevant, ensuring your teams gain the skills and insights they need to excel. Join us in creating a motivated, resilient, and emotionally intelligent workforce ready to tackle any challenge.
Sign up today: info@wearyourcape.co.uk and visit our website for more info.

CAPE Coaching and Development

Team Building

Employee Engagement

Motivation

Emotional Intelligence (EQ)

Leadership Skills

Emotional Resilience

8D Problem Solving

THRIVE

Team Management

Academic & Personal Development

Critical Thinking

Give your team the tools they need to thrive! Sign up for our 90-minute interactive workshops this September and October. From imposter syndrome to motivation, we’ve got you covered. Contact us at info@wearyourcape.co.uk to book. 

Ready to Reignite Your Team Post-Summer?

Birmingham

Erdington

Queensway

Tableau Training Uk

Visual Analytics Best Practice

London

Overview
Understand the structure and mechanics of Target Redemption Notes (TARNs), autocallables, accumulators, and faders.

Who the course is for
CEOs, CFOs, COOs with responsibility for Strategic Management
Investment bankers
Real estate consultants
Management consultants
Private Equity investors
Financial analysts
Institutional Funds and Portfolio Managers
Retail investors

Course Content
To learn more about the day by day course content please request a brochure.
To learn more about schedule, pricing & delivery options speak to a course specialist now

Finex Learning

Real Estate Finance

Property Investment

Real Estate Investing

Asset Management

Investment Management

Mastering Real Estate Investments: Strategies for Success in REITs and Beyond

Harpenden

<p>This course starts with the basics then moves seamlessly to an intermediate level. It includes a comprehensive yet balanced look at the four main components that make up Power BI Desktop: Report view, Data view, Model view, and the Power Query Editor. It also demonstrates how to use the online Power BI service.</p><p>It looks at authoring tools that enables you to connect to and transform data from a variety of sources, allowing you to produce dynamic reports using a library of visualisations. Once you have those reports, the course looks at the seamless process of sharing those with your colleagues by publishing to the online Power BI service.</p><p>The aim of this course is to provide a strong understanding of the Power BI analysis process, by working with real-world examples that will equip you with the necessary skills to start applying your knowledge straight away.</p><section>
                    <h3>1 Getting started</h3><ul><li>The Power BI process</li><li>Launching Power BI Desktop</li><li>The four views of Power BI</li><li>Dashboard visuals</li></ul> <h3>2 Connecting to files</h3><ul><li>Connect to data sources</li><li>Connect to an Excel file</li><li>Connect to a CSV file</li><li>Connect to a database</li><li>Import vs. DirectQuery</li><li>Connect to a web source</li><li>Create a data table</li></ul> <h3>3 Transforming data</h3><ul><li>The process of cleaning data</li><li>Column data types</li><li>Remove rows with filters</li><li>Add a custom column</li><li>Append data to a table</li><li>Fix error issues</li><li>Basic maths operations</li></ul> <h3>4 Build a data model</h3><ul><li>Table relationships</li><li>Manage table relationships</li></ul> <h3>5 Merge queries</h3><ul><li>Table join kinds</li><li>Merging tables</li></ul> <h3>6 Create report visualisations</h3><ul><li>Creating map visuals</li><li>Formatting maps</li><li>Creating chart visuals</li><li>Formatting chart</li><li>Tables, matrixes, and cards</li><li>Control formatting with themes</li><li>Filter reports with slicers</li><li>Reports for mobile devices</li><li>Custom online visuals</li><li>Export report data to Excel</li></ul> <h3>7 The power query editor</h3><ul><li>Fill data up and down</li><li>Split columns by delimiter</li><li>Add conditional columns</li><li>Merging columns</li></ul> <h3>8 The M formula</h3><ul><li>Creating M functions</li><li>Create an IF function</li><li>Create a query group</li></ul> <h3>9 Pivot and unpivot tables</h3><ul><li>Pivot tables in the query editor</li><li>Pivot and append tables</li><li>Pivot but don't summarise</li><li>Unpivot tables</li><li>Append mismatched headers</li></ul> <h3>10 Data modelling revisited</h3><ul><li>Data model relationships</li><li>Mark a calendar as a date table</li></ul> <h3>11 Introduction to calculated columns</h3><ul><li>New columns vs. measures</li><li>Creating a new column calculation</li><li>The SWITCH function</li></ul> <h3>12 Introduction to DAX measures</h3><ul><li>Common measure categories</li><li>The SUM measure</li><li>Adding measures to visuals</li><li>COUNTROWS and DISINCTCOUNT functions</li><li>DAX rules</li></ul> <h3>13 The CALCULATE measure</h3><ul><li>The syntax of CALCULATE</li><li>Things of note about CALCULATE</li></ul> <h3>14 The SUMX measure</h3><ul><li>The SUMX measure</li><li>X iterator functions</li><li>Anatomy of SUMX</li></ul> <h3>15 Introduction to time intelligence</h3><ul><li>Importance of a calendar table</li><li>A special lookup table</li><li>The TOTALYTD measure</li><li>Change year end in TOTALYTD</li></ul> <h3>16 Hierarchy, groups and formatting</h3><ul><li>Create a hierarchy to drill data</li><li>Compare data in groups</li><li>Add conditional formatting</li></ul> <h3>17 Share reports on the web</h3><ul><li>Publish to the BI online service</li><li>Get quick insights</li><li>Upload reports from BI service</li><li>Exporting report data</li><li>What is Q&amp;A?</li><li>Sharing your reports</li></ul> <h3>18 Apply your learning</h3><ul><li>Post training recap lesson</li></ul> 


                </section>

The In House Training Company

Powerbi

Business Analytics & Intelligence

Microsoft Power BI

Excel Analytics

Microsoft BI

Business Intelligence (BI)

Power BI - introduction to intermediate (2 days) (In-House)

<p>This one-day workshop is ideal for those looking to work with existing databases as well as creating a new Access database. You will learn effective ways to enter and extract data and convert data into a well-presented format for reports.</p>This course will help participants:<ul><li>Plan and create a database</li><li>Sort and filter records</li><li>Use field data types</li><li>Work with tables</li><li>Create and manage a query</li><li>Create and work with forms, and use the form wizard</li><li>View, create and print reports</li></ul><section>
                    <h3>1 Access introduced</h3><ul><li>Planning a database</li><li>Creating a blank database</li><li>Opening an existing database</li><li>Security warnings</li><li>The navigation pane</li><li>Previewing database components</li><li>Closing an Access database</li></ul> <h3>2 Tables introduced</h3><ul><li>Viewing and navigating table data</li><li>Navigating using keyboard shortcuts</li><li>Editing table data</li><li>Adding records to tables</li><li>Selecting and deleting records</li><li>Finding and replacing data</li><li>Filtering tables</li><li>Summing table data</li></ul> <h3>3 Queries introduced</h3><ul><li>Opening a query in datasheet view</li><li>Opening a query in design view</li><li>Adding fields to a query</li><li>Sorting query results</li><li>Modifying datasheet view</li><li>Saving and closing queries</li></ul> <h3>4 Forms introduced</h3><ul><li>Working with form data</li><li>Sorting records</li><li>Filtering records</li><li>Working in design and layout views</li><li>Changing object attributes</li></ul> <h3>5 Reports introduced</h3><ul><li>Opening and viewing reports</li><li>Viewing a report in design view</li><li>Previewing and printing report data</li><li>Creating reports with auto report</li><li>Creating reports with the report wizard</li><li>Changing field attributes</li></ul> <h3>6 Creating a new database</h3><ul><li>Creating database tables</li><li>Creating table fields</li><li>Selecting field data types</li></ul> <h3>7 Table relationships</h3><ul><li>Introducing relationships</li><li>Establishing table relationships</li><li>The one-to-many relationship type</li><li>Establishing referential integrity</li></ul> <h3>8 Creating queries</h3><ul><li>Streamline query criteria using wildcards</li><li>Creating summary queries</li><li>Creating queries based on criteria</li><li>Running date queries</li><li>Formatting field properties</li><li>Building queries from multiple tables</li><li>Summing in queries</li></ul> <h3>9 Creating forms</h3><ul><li>Creating a new form</li><li>Inserting form fields</li><li>Working with the property sheet</li><li>The command button wizard</li><li>The command button wizard</li><li>Programming without typing</li><li>Creating forms with embedded sub forms</li><li>Creating forms with the sub form wizard</li><li>Creating forms with the form wizard</li></ul> <h3>10 Creating reports</h3><ul><li>What are report bands?</li><li>Managing report controls</li><li>Basing reports on multiple tables</li><li>Basing reports on queries</li><li>Sorting and grouping records</li></ul> 


                </section>

Data Entry Skills

Microsoft Forms

Access VBA

Microsoft Access

Trainers Course

Access - introduction (In-House)

<p>There is a lot to learn in Power BI, this course takes a comprehensive look at the fundamentals of analysing data and includes a balanced look at the four main components that make up Power BI Desktop: Report view, Data view, Model view, and the Power Query Editor. It also demonstrates how to utilise the online Power BI service.</p><p>It looks at authoring tools that enable you to connect to and transform data from a variety of sources, allowing you to produce detailed reports through a range of visualisations, in an interactive and dynamic way.</p><p>It also includes a detailed look at formulas by writing both M functions in Power Query, and DAX functions in Desktop view. This knowledge will allow you to take your reports to the next level.</p><p>The aim of this course is to provide a complete introduction to understanding the Power BI analysis process, by working hands-on with examples that will equip you with the necessary skills to start applying your learning straight away.</p><section>
                    <h3>1 Getting Started</h3><ul><li>The Power BI ecosystem</li><li>Opening Power BI Desktop</li><li>Power BI's four views</li><li>Introduction to Dashboards</li></ul> <h3>2 Importing Files</h3><ul><li>Importing data sources</li><li>Importing an Excel file</li><li>Importing a CSV file</li><li>Importing a database</li><li>Connect to an SQL Server Database</li><li>Import vs. Direct Query</li><li>Importing from the web</li><li>Importing a folder of files</li><li>Managing file connections</li></ul> <h3>3 Shape Data in the Query Editor</h3><ul><li>The process of shaping data</li><li>Managing data types</li><li>Keeping and removing rows</li><li>Add a custom column</li><li>Appending tables together</li><li>Hiding queries in reports</li><li>Fixing error issues</li><li>Basic maths operations</li></ul> <h3>4 The Data Model</h3><ul><li>Table relationships</li><li>Relationship properties</li></ul> <h3>5 Merge Queries</h3><ul><li>Table join kinds</li><li>Merging tables</li></ul> <h3>6 Inserting Dashboard Visuals</h3><ul><li>Things to keep in mind</li><li>Inserting maps</li><li>Formatting Maps</li><li>Inserting charts</li><li>Formatting Charts</li><li>Inserting a tree map</li><li>Inserting a table, matrix, and card</li><li>Controlling number formats</li><li>About report themes</li><li>Highlighting key points</li><li>Filter reports with slicers</li><li>Sync slicers across dashboards</li><li>Custom web visuals</li></ul> <h3>7 Publish and share Reports</h3><ul><li>Publishing to Power BI service</li><li>Editing online reports</li><li>Pinning visuals to a dashboard</li><li>What is Q&amp;A?</li><li>Sharing dashboards</li><li>Exporting reports to PowerPoint</li><li>Exporting reports as PDF files</li></ul> <h3>8 The Power Query Editor</h3><ul><li>Fill data up and down</li><li>Split column by delimiter</li><li>Add a conditional column</li><li>More custom columns</li><li>Merging columns</li></ul> <h3>9 The M Functions</h3><ul><li>Inserting text functions</li><li>Insert an IF function</li><li>Create a query group</li></ul> <h3>10 Pivoting Tables</h3><ul><li>Pivot a table</li><li>Pivot and append tables</li><li>Pivot but don't aggregate</li><li>Unpivot tables</li><li>Append mismatched headers</li></ul> <h3>11 Data Modelling Expanded</h3><ul><li>Understanding relationships</li><li>Mark a date table</li></ul> <h3>12 DAX New Columns</h3><ul><li>New columns and measures</li><li>New column calculations</li><li>Insert a SWITCH function</li></ul> <h3>13 Introduction to DAX Measures</h3><ul><li>Common measure functions</li><li>Insert a SUM function</li><li>Insert a COUNTROWS function</li><li>Insert a DISTINCTCOUNT function</li><li>Insert a DIVIDE function</li><li>DAX rules</li></ul> <h3>14 The CALCULATE Measure</h3><ul><li>The syntax of CALCULATE</li><li>Insert a CALCULATE function</li><li>Control field summarisation</li><li>Things of note</li></ul> <h3>15 The SUMX measure</h3><ul><li>X iterator functions</li><li>Anatomy of SUMX</li><li>Insert a SUMX function</li><li>When to use X functions</li></ul> <h3>16 Time Intelligence Measures</h3><ul><li>Importance of a calendar table</li><li>Insert a TOTALYTD function</li><li>Change financial year end date</li><li>Comparing historical data</li><li>Insert a DATEADD function</li></ul> <h3>17 Hierarchies and Groups</h3><ul><li>Mine data using hierarchies</li><li>Compare data in groups</li></ul> 


                </section>

Microsoft Power Platform

Power BI - introduction (2 day) (In-House)

<p>This one-day workshop is designed to give you an awareness of the fundamentals of Microsoft Excel and, in particular, to give you the confidence needed to efficiently create, edit and manage spreadsheets.</p>This course will help participants:<ul><li>Create tables</li><li>Use functions</li><li>Manage rows and columns</li><li>Write formulas</li><li>Manage sheets</li><li>Use content formats</li><li>Handle larger tables</li><li>Create reports and charts</li></ul><section>
                    <h3>1 Creating a table</h3><ul><li>Creating an Excel table from scratch</li><li>Wrapping text in cells</li><li>Speeding up data entry using AutoFill</li><li>Sorting columns</li></ul> <h3>2 Inserting function</h3><ul><li>Inserting function calculators</li><li>Using AutoSum to sum numbers</li><li>Statistical calculations AVERAGE, MAX and MIN</li></ul> <h3>3 Table rows and columns</h3><ul><li>Inserting and deleting rows and columns</li><li>Adjusting multiple column widths and row heights</li><li>Hiding and unhiding rows and columns</li></ul> <h3>4 Formula writing</h3><ul><li>The basics of formula writing</li><li>Understanding mathematical symbols</li><li>Using multiple mathematical symbols in a formula</li><li>When to use brackets</li><li>Troubleshooting calculation errors</li></ul> <h3>5 Managing sheets</h3><ul><li>Inserting, renaming, moving and deleting sheets</li><li>Copying a worksheet to another file</li><li>Copying a table to another sheet</li></ul> <h3>6 Managing content formats</h3><ul><li>Applying data formats</li><li>Managing number formats</li><li>Controlling formats with the Format Painter</li></ul> <h3>7 Managing larger tables</h3><ul><li>Applying freeze panes to lock tables when scrolling</li><li>Sorting on multiple columns</li><li>Using filters to extract table information</li></ul> <h3>8 Creating and modifying charts</h3><ul><li>Creating a pie chart</li><li>Creating a column chart</li><li>Inserting chart titles and data labels</li><li>Controlling chart formatting</li><li>Changing chart types</li></ul> <h3>9 Printing</h3><ul><li>Previewing and printing tables and charts</li><li>Modifying page orientation</li><li>Adjusting print margins</li><li>Printing a selection</li></ul> <h3>10 Calculating with absolute reference</h3><ul><li>The difference between a relative and absolute formula</li><li>Changing a relative formula to an absolute</li><li>Using $ signs to lock cells when copying formulas</li></ul> <h3>11 Pivot tables</h3><ul><li>Create a pivot table report</li><li>Insert a pivot chart into a report</li></ul> 


                </section>

Office Skills & Productivity

Office Skills

Microsoft Excel

Microsoft Office

Spreadsheet

Excel - introduction (In-House)

<p>This one-day workshop is designed to build upon skills already acquired using Microsoft Word, whether participants are self-taught or have previously attended a course. It gives participants a good understanding of managing different types of paragraph indents, and managing automated numbered paragraph lists.</p>This course will help participants:<ul><li>Create and manage the layout of paragraphs</li><li>Create and manage multi-level numbered paragraphs</li><li>Effectively insert, use and manage section breaks</li><li>Create and manage columns</li><li>Find, create and apply styles</li><li>Create and update a table of contents from styles</li><li>Work with styles to manage formatting</li><li>Work with sums in tables and use table headings</li><li>Input and edit text using AutoText</li><li>Work with SmartArt graphics</li><li>Link to other files using paste special</li></ul><section>
                    <h3>1 Managing paragraph layout</h3><ul><li>Controlling paragraph layouts with indents</li><li>Creating and managing paragraph hanging indents</li></ul> <h3>2 Numbering paragraphs</h3><ul><li>Creating a new multi-level numbered paragraph</li><li>Managing existing multi-level numbered paragraphs</li></ul> <h3>3 Inserting columns</h3><ul><li>Creating columns from existing paragraphs</li><li>Setting up columns</li><li>Managing columns</li></ul> <h3>4 Document section breaks</h3><ul><li>Controlling document layout using section breaks</li><li>Managing page orientation using section breaks</li><li>Managing page numbering using section breaks</li></ul> <h3>5 Using styles</h3><ul><li>Applying quick styles</li><li>Finding existing styles</li><li>Creating and saving styles</li><li>Modifying styles</li><li>Creating a table of contents from styles</li><li>Updating a table of contents</li></ul> <h3>6 Using quick parts</h3><ul><li>Saving content to quick parts</li><li>Modifying saved quick parts</li><li>Inserting content using AutoText</li><li>Editing AutoText entries</li><li>Inputting text using AutoCorrect</li></ul> <h3>7 Advanced table features</h3><ul><li>Sorting table columns</li><li>Running sums in tables</li><li>Repeating table headings at top of page</li><li>Importing Excel content in tables</li><li>Using table properties</li></ul> <h3>8 Creating a mail merge</h3><ul><li>Creating letters, labels and emails</li><li>Merging addresses from external files</li><li>Using Outlook's address book to merge</li><li>Merging to email</li></ul> <h3>9 SmartArt graphic</h3><ul><li>Visually communicate content with SmartArt</li><li>Choosing a SmartArt graphic</li><li>Inputting into SmartArt</li><li>Modifying and formatting SmartArt graphics</li></ul> <h3>10 Linking to other files</h3><ul><li>Linking to files using paste special</li><li>Linking an Excel chart to a document</li><li>Managing linked content from Word</li></ul> 


                </section>

Office Productivity

Computer Skills

Microsoft Word

Word - intermediate (In-House)

<p>This one-day course focuses on issues such as writing formulas and accessing help while writing them, and taking formulas to the next level by nesting one inside another for a powerful formula result.  It also looks at ways of analysing data with reports, summarised by varying criteria. A range of time-saving tips and tricks are shared.</p>This course will help participants:<ul><li>Calculate with absolute reference</li><li>Group worksheets</li><li>Link to tables</li><li>Use the function library effectively</li><li>Get to grips with the logical IF function</li><li>Use conditional formatting</li><li>Create pivot table reports</li><li>Use data validation</li><li>Master the VLOOKUP function</li></ul><section>
                    <h3>1 Calculating with absolute reference</h3><ul><li>The difference between a relative and absolute formula</li><li>Changing a relative formula to an absolute</li><li>Using $ signs to lock cells when copying formulas</li></ul> <h3>2 Grouping worksheets</h3><ul><li>Grouping sheets together</li><li>Inputting data into multiple sheets</li><li>Writing a 3D formula to sum tables across sheets</li></ul> <h3>3 Linking to tables</h3><ul><li>Linking to a source table</li><li>Using paste link to link a table to another file</li><li>Using edit links to manage linked tables</li></ul> <h3>4 The function library</h3><ul><li>Benefits of writing formulas in the function library</li><li>Finding the right formula using insert function</li><li>Outputting statistics with COUNTA and COUNTBLANK</li><li>Counting criteria in a list with COUNTIFS</li></ul> <h3>5 Logical IF Function</h3><ul><li>Outputting results from tests</li><li>Running multiple tests for multiple results</li><li>The concept of outputting results from numbers</li></ul> <h3>6 Conditional formatting</h3><ul><li>Enabling text and numbers to standout</li><li>Applying colour to data using rules</li><li>Managing rules</li><li>Copying rules with the format painter</li></ul> <h3>7 View side by side</h3><ul><li>Comparing two Excel tables together</li><li>Comparing two sheets together in the same file</li></ul> <h3>8 Pivot table reports</h3><ul><li>Analysing data with pivot tables</li><li>Managing a pivot table's layout</li><li>Outputting statistical reports</li><li>Controlling number formats</li><li>Visualising reports with pivot charts</li><li>Inserting slicers for filtering data</li></ul> <h3>9 Data validation</h3><ul><li>Restricting data input with data validation</li><li>Speeding up data entry with data validation</li></ul> <h3>10 VLOOKUP function</h3><ul><li>Best practices for writing a VLOOKUP</li><li>A false type lookup</li><li>A true type lookup</li><li>Enhance formula results with IFNA</li></ul> <h3>11 Print options</h3><ul><li>Getting the most from print</li><li>Printing page titles across pages</li><li>Scaling content for print</li></ul> 


                </section>

Excel - intermediate (In-House)

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This course is designed for anyone seeking CCNA certification. The course also provides foundational knowledge for all support technicians involved in the basic installation, operation, and verification of Cisco networks. The job roles best suited to the material in this course are:<br />Entry-level network engineer<br />Network administrator<br />Network support technician<br />Help desk technician</p>Overview<p>This course will help you:<br />Learn the knowledge and skills to install, configure, and operate a small- to medium-sized network<br />Gain a foundation in the essentials of networking, security, and automation<br />Earn 30 CE credits toward recertification</p><p>The Implementing and Administering Cisco Solutions (CCNA) v2.0 course gives you a broad range of fundamental knowledge for all IT careers. Through a combination of lecture, hands-on labs, and self-study, you will learn how to install, operate, configure, and verify basic IPv4 and IPv6 networks. The course covers configuring network components such as switches, routers, and wireless LAN controllers; managing network devices; and identifying basic security threats. The course also gives you a foundation in network programmability, automation, and software-defined networking. This course helps you prepare to take the 200-301 CiscoÂ© Certified Network Associate (CCNAÂ©) exam. By passing this one exam, you earn the CCNA certification. This course also earns you 30 Continuing Education (CE) credits towards recertification.</p></div><div id="course-pills-2"><h4>Course Outline </h4><ul><li>Exploring the Functions of Networking ? Lecture</li><li>Introducing the Host-to-Host Communications Model ? Lecture</li><li>Operating Cisco IOS Software ? Lecture</li><li>Introducing LANs ? Lecture</li><li>Exploring the TCP/IP Link Layer ? Lecture</li><li>Starting a Switch ? Lecture</li><li>Introducing the TCP/IP Internet Layer, IPv4 Addressing, and Subnets ? Lecture</li><li>Explaining the TCP/IP Transport Layer and Application Layer ? Lecture</li><li>Exploring the Functions of Routing ? Lecture</li><li>Configuring a Cisco Router ? Lecture</li><li>Exploring the Packet Delivery Process ? Lecture</li><li>Troubleshooting a Simple Network ? Lecture</li><li>Introducing Basic IPv6 ? Lecture</li><li>Configuring Static Routing ? Lecture</li><li>Implementing VLANs and Trunks ? Lecture</li><li>Routing Between VLANs ? Lecture</li><li>Introducing OSPF ? Lecture</li><li>Building Redundant Switched Topologies ? Self-study</li><li>Improving Redundant Switched Topologies with EtherChannel ? Lecture</li><li>Exploring Layer 3 Redundancy ? Self-study</li><li>Introducing WAN Technologies ? Self-study</li><li>Explaining Basics of ACL ? Lecture</li><li>Enabling Internet Connectivity ? Lecture</li><li>Introducing QoS ? Self-study</li><li>Explaining Wireless Fundamentals ? Self-study</li><li>Introducing Architectures and Virtualization ? Self-study</li><li>Explaining the Evolution of Intelligent Networks ? Lecture</li><li>Introducing System Monitoring ? Lecture</li><li>Managing Cisco Devices ? Lecture</li><li>Examining the Security Threat Landscape ? Self-study</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Cisco Implementing and Administering Cisco Solutions v2.0 (CCNA) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the Cisco Implementing and Administering Cisco Solutions v2.0 (CCNA) 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

Cisco Certified Network Associate (CCNA)

Certified in Cybersecurity (CC)

Cisco Certified Network Professional certification (CCNP)

CompTIA Network+

Cisco Certified Entry Networking Technician (CCENT)

Cisco Certified Internetwork Expert (CCIE)

Cisco Implementing and Administering Cisco Solutions v2.0 (CCNA)

General Admission

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>The Certified Ethical Hacking v12 course will significantly benefit security officers, auditors, security professionals, site administrators, and anyone who is concerned about the integrity of the network infrastructure.</p>Overview<p>Information security controls, laws, and standards. Various types of footprinting, footprinting tools, and countermeasures. Network scanning techniques and scanning countermeasures Enumeration techniques and enumeration countermeasures Vulnerability analysis to identify security loopholes in the target organization?s network, communication infrastructure, and end systems. System hacking methodology, steganography, steganalysis attacks, and covering tracks to discover system and network vulnerabilities. Different types of malware (Trojan, Virus, worms, etc.), system auditing for malware attacks, malware analysis, and countermeasures. Packet sniffing techniques to discover network vulnerabilities and countermeasures to defend against sniffing. Social engineering techniques and how to identify theft attacks to audit human-level vulnerabilities and social engineering countermeasures. DoS/DDoS attack techniques and tools to audit a target and DoS/DDoS countermeasures. Session hijacking techniques to discover network-level session management, authentication/authorization, and cryptographic weaknesses and countermeasures. Webserver attacks and a comprehensive attack methodology to audit vulnerabilities in webserver infrastructure, and countermeasures. Web application attacks, comprehensive web application hacking methodology to audit vulnerabilities in web applications, and countermeasures. SQL injection attack techniques, injection detection tools to detect SQL injection attempts, and countermeasures. Wireless encryption, wireless hacking methodology, wireless hacking tools, and Wi-Fi security tools. Mobile platform attack vector, android vulnerability exploitations, and mobile security guidelines and tools. Firewall, IDS and honeypot evasion techniques, evasion tools and techniques to audit a network perimeter for weaknesses, and countermeasures. Cloud computing concepts (Container technology, serverless computing), the working of various threats and attacks, and security techniques and tools. Penetration testing, security audit, vulnerability assessment, and penetration testing roadmap. Threats to IoT and OT platforms and defending IoT and OT devices. Cryptography ciphers, Public Key Infrastructure (PKI), cryptography attacks, and cryptanalysis tools.</p><p>CEH provides an in-depth understanding of ethical hacking phases, various attack vectors, and preventative countermeasures. It will teach you how hackers think and act maliciously so you will be better positioned to setup your security infrastructure and defend against future attacks. An understanding of system weaknesses and vulnerabilities helps organizations strengthen their system security controls to minimize the risk of an incident. CEH was built to incorporate a hands-on environment and systematic process across each ethical hacking domain and methodology, giving you the opportunity to work towards proving the required knowledge and skills needed to achieve the CEH credential. You will be exposed to an entirely different posture toward the responsibilities and measures required to be secure. Now in its 12th version, CEH continues to evolve with the latest operating systems, tools, tactics, exploits, and technologies.</p></div><div id="course-pills-2"><h3>1 - Introduction to Ethical Hacking</h3> <ul> <li>Information Security Overview</li> <li>Cyber Kill Chain Concepts</li> <li>Hacking Concepts</li> <li>Ethical Hacking Concepts</li> <li>Information Security Controls</li> <li>Information Security Laws and Standards</li> </ul> <h3>2 - 2 - Foot-printing and Reconnaissance</h3> <ul> <li>Footprinting Concepts</li> <li>Footprinting through Search Engines</li> <li>Footprinting through Web Services</li> <li>Footprinting through Social Networking Sites</li> <li>Website Footprinting</li> <li>Email Footprinting</li> <li>Who is Footprinting</li> <li>DNS Footprinting</li> <li>Network Footprinting</li> <li>Footprinting through Social Engineering</li> <li>Footprinting Tools</li> <li>Footprinting Countermeasures</li> </ul> <h3>3 - Scanning Networks</h3> <ul> <li>Network Scanning Concepts</li> <li>Scanning Tools</li> <li>Host Discovery</li> <li>Port and Service Discovery</li> <li>OS Discovery (Banner Grabbing/OS Fingerprinting) </li><li>Scanning Beyond IDS and Firewall</li> <li>Draw Network Diagrams</li> </ul> <h3>4 - Enumeration</h3> <ul> <li>Enumeration Concepts</li> <li>NetBIOS Enumeration</li> <li>SNMP Enumeration</li> <li>LDAP Enumeration</li> <li>NTP and NFS Enumeration</li> <li>SMTP and DNS Enumeration</li> <li>Other Enumeration Techniques</li> <li>Enumeration Countermeasures</li> </ul> <h3>5 - Vulnerability Analysis</h3> <ul> <li>Vulnerability Assessment Concepts</li> <li>Vulnerability Classification and Assessment Types</li> <li>Vulnerability Assessment Solutions and Tools</li> <li>Vulnerability Assessment Reports</li> </ul> <h3>6 - System Hacking</h3> <ul> <li>System Hacking Concepts</li> <li>Gaining Access</li> <li>Escalating Privileges</li> <li>Maintaining Access</li> <li>Clearing Logs</li> </ul> <h3>7 - Malware Threats</h3> <ul> <li>Malware Concepts</li> <li>APT Concepts</li> <li>Trojan Concepts</li> <li>Virus and Worm Concepts</li> <li>Fileless Malware Concepts</li> <li>Malware Analysis</li> <li>Countermeasures</li> <li>Anti-Malware Software</li> </ul> <h3>8 - Sniffing</h3> <ul> <li>Sniffing Concepts</li> <li>Sniffing Technique: MAC Attacks</li> <li>Sniffing Technique: DHCP Attacks</li> <li>Sniffing Technique: ARP Poisoning</li> <li>Sniffing Technique: Spoofing Attacks</li> <li>Sniffing Technique: DNS Poisoning</li> <li>Sniffing Tools</li> <li>Countermeasures</li> <li>Sniffing Detection Techniques</li> </ul> <h3>9 - Social Engineering</h3> <ul> <li>Social Engineering Concepts</li> <li>Social Engineering Techniques</li> <li>Insider Threats</li> <li>Impersonation on Social Networking Sites</li> <li>Identity Theft</li> <li>Countermeasures</li> </ul> <h3>10 - Denial-of-Service</h3> <ul> <li>DoS/DDoS Concepts</li> <li>DoS/DDoS Attack Techniques</li> <li>BotnetsDDoS Case Study</li> <li>DoS/DDoS Attack Tools</li> <li>Countermeasures</li> <li>DoS/DDoS Protection Tools</li> </ul> <h3>11 - Session Hijacking</h3> <ul> <li>Session Hijacking Concepts</li> <li>Application Level Session Hijacking</li> <li>Network Level Session Hijacking</li> <li>Session Hijacking Tools</li> <li>Countermeasures</li> </ul> <h3>12 - Evading IDS, Firewalls, and Honeypots</h3> <ul> <li>IDS, IPS, Firewall, and Honeypot Concepts</li> <li>IDS, IPS, Firewall, and Honeypot Solutions</li> <li>Evading IDS</li> <li>Evading Firewalls</li> <li>IDS/Firewall Evading Tools</li> <li>Detecting Honeypots</li> <li>IDS/Firewall Evasion Countermeasures</li> </ul> <h3>13 - Hacking Web Servers</h3> <ul> <li>Web Server Concepts</li> <li>Web Server Attacks</li> <li>Web Server Attack Methodology</li> <li>Web Server Attack Tools</li> <li>Countermeasures</li> <li>Patch Management</li> <li>Web Server Security Tools</li> </ul> <h3>14 - Hacking Web Applications</h3> <ul> <li>Web Application Concepts</li> <li>Web Application Threats</li> <li>Web Application Hacking Methodology</li> <li>Web API, Webhooks, and Web Shell</li> <li>Web Application Security</li> </ul> <h3>15 - SQL Injection</h3> <ul> <li>SQL Injection Concepts</li> <li>Types of SQL Injection</li> <li>SQL Injection Methodology</li> <li>SQL Injection Tools</li> <li>Evasion Techniques</li> <li>Countermeasures</li> </ul> <h3>16 - Hacking Wireless Networks</h3> <ul> <li>Wireless Concepts</li> <li>Wireless Encryption</li> <li>Wireless Threats</li> <li>Wireless Hacking Methodology</li> <li>Wireless Hacking Tools</li> <li>Bluetooth Hacking</li> <li>Countermeasures</li> <li>Wireless Security Tools</li> </ul> <h3>17 - Hacking Mobile Platforms</h3> <ul> <li>Mobile Platform Attack Vectors</li> <li>Hacking Android OS</li> <li>Hacking iOS</li> <li>Mobile Device Management</li> <li>Mobile Security Guidelines and Tools</li> </ul> <h3>18 - IoT and OT Hacking</h3> <ul> <li>IoT Hacking</li> <li>IoT Concepts</li> <li>IoT Attacks</li> <li>IoT Hacking Methodology</li> <li>IoT Hacking Tools</li> <li>Countermeasures</li> <li>OT Hacking</li> <li>OT Concepts</li> <li>OT Attacks</li> <li>OT Hacking Methodology</li> <li>OT Hacking Tools</li> <li>Countermeasures</li> </ul> <h3>19 - Cloud Computing</h3> <ul> <li>Cloud Computing Concepts</li> <li>Container Technology</li> <li>Serverless Computing</li> <li>Cloud Computing Threats</li> <li>Cloud Hacking</li> <li>Cloud Security</li> </ul> <h3>20 - Cryptography</h3> <ul> <li>Cryptography Concepts</li> <li>Encryption Algorithms</li> <li>Cryptography Tools</li> <li>Public Key Infrastructure (PKI) </li><li>Email Encryption</li> <li>Disk Encryption</li> <li>Cryptanalysis</li> <li>Countermeasures</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans EC-Council Certified Ethical Hacker (CEH) v.12 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 EC-Council Certified Ethical Hacker (CEH) v.12 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>

IT Certifications

Cyber Security

Certified Ethical Hacker (CEH)

Certified Cyber Professional (CCP)

Ethical Hacking

EC-Council Certified Ethical Hacker (CEH) v12

<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 audience for this course is data professionals managing data and databases who want to learn about administering the data platform technologies that are available on Microsoft Azure. This course is also valuable for data architects and application developers who need to understand what technologies are available for the data platform with Azure and how to work with those technologies through applications.</p><p></p><p></p><p>This course provides students with the knowledge and skills to administer a SQL Server database infrastructure for cloud, on-premises and hybrid relational databases and who work with the Microsoft PaaS relational database offerings. Additionally, it will be of use to individuals who develop applications that deliver content from SQL-based relational databases.</p><p></p>Prerequisites<p>In addition to their professional experience, students who take this training should have technical knowledge equivalent to the following courses:   </p><li>AZ-900T00 Microsoft Azure Fundamentals  </li><li>DP-900T00 Microsoft Azure Data Fundamentals<p></p></li></div><div id="course-pills-2"><h3>1 - Prepare to maintain SQL databases on Azure</h3> <ul> <li>Describe Microsoft Intelligent Data Platform roles</li> <li>Understand SQL Server in an Azure virtual machine</li> <li>Design Azure SQL Database for cloud-native applications</li> <li>Explore Azure SQL Database Managed Instance</li> </ul> <h3>2 - Deploy IaaS solutions with Azure SQL</h3> <ul> <li>Explain IaaS options to deploy SQL Server in Azure</li> <li>Understand hybrid scenarios</li> <li>Explore performance and security</li> <li>Explain high availability and disaster recovery options</li> </ul> <h3>3 - Deploy PaaS solutions with Azure SQL</h3> <ul> <li>Explain PaaS options for deploying SQL Server in Azure</li> <li>Explore single SQL database</li> <li>Deploy SQL database elastic pool</li> <li>Understand SQL database hyperscale</li> <li>Examine SQL managed instance</li> <li>Describe SQL Edge</li> </ul> <h3>4 - Evaluate strategies for migrating to Azure SQL</h3> <ul> <li>Understand compatibility level</li> <li>Understand Azure preview features</li> <li>Describe Azure database migration options</li> </ul> <h3>5 - Migrate SQL workloads to Azure SQL databases</h3> <ul> <li>Choose the right SQL Server Instance option in Azure</li> <li>Migrate SQL Server to Azure SQL Database offline</li> <li>Migrate SQL Server to Azure SQL Database online</li> <li>Load and move data to Azure SQL Database</li> </ul> <h3>6 - Migrate SQL workloads to Azure Managed Instances</h3> <ul> <li>Evaluate migration scenarios to SQL Database Managed Instance</li> <li>Migrate to SQL Database Managed Instance</li> <li>Load and Move data to SQL Database Managed Instance</li> </ul> <h3>7 - Configure database authentication and authorization</h3> <ul> <li>Describe Active Directory and Azure Active Directory</li> <li>Describe authentication and identities</li> <li>Describe Security Principals</li> <li>Describe database and object permissions</li> <li>Identify authentication and authorization failures</li> </ul> <h3>8 - Protect data in-transit and at rest</h3> <ul> <li>Explore Transparent Data Encryption</li> <li>Configure server and database firewall rules</li> <li>Explain object encryption and secure enclaves</li> <li>Enable encrypted connections</li> <li>Describe SQL injection</li> <li>Understand Azure Key Vault</li> </ul> <h3>9 - Implement compliance controls for sensitive data</h3> <ul> <li>Explore data classification</li> <li>Explore server and database audit</li> <li>Implement Dynamic Data Masking</li> <li>Implement Row Level security</li> <li>Understand Microsoft Defender for SQL</li> <li>Explore Azure SQL Database Ledger</li> <li>Implement Azure Purview</li> </ul> <h3>10 - Describe performance monitoring</h3> <ul> <li>Describe performance monitoring tools</li> <li>Describe critical performance metrics</li> <li>Establish baseline metrics</li> <li>Explore extended events</li> <li>Describe Azure SQL Insights</li> <li>Explore Query Performance Insight</li> </ul> <h3>11 - Configure SQL Server resources for optimal performance</h3> <ul> <li>Explain how to optimize Azure storage for SQL Server virtual machines</li> <li>Describe virtual machine resizing</li> <li>Optimize database storage</li> <li>Control SQL Server resources</li> </ul> <h3>12 - Configure databases for optimal performance</h3> <ul> <li>Explore database maintenance checks</li> <li>Describe database scoped configuration options</li> <li>Describe automatic tuning</li> <li>Describe intelligent query processing</li> </ul> <h3>13 - Explore query performance optimization</h3> <ul> <li>Understand query plans</li> <li>Explain estimated and actual query plans</li> <li>Describe dynamic management views and functions</li> <li>Explore Query Store</li> <li>Identify problematic query plans</li> <li>Describe blocking and locking</li> </ul> <h3>14 - Evaluate performance improvements</h3> <ul> <li>Describe wait statistics</li> <li>Tune and maintain indexes</li> <li>Understand query hints</li> </ul> <h3>15 - Explore performance-based design</h3> <ul> <li>Describe normalization</li> <li>Choose appropriate data types</li> <li>Design indexes</li> </ul> <h3>16 - Automate deployment of database resources</h3> <ul> <li>Describe deployment models in Azure</li> <li>Automate deployment by using Azure Resource Manager templates and Bicep</li> <li>Automate deployment by using PowerShell</li> <li>Automate deployment by using Azure CLI</li> </ul> <h3>17 - Create and manage SQL Agent jobs</h3> <ul> <li>Create a SQL Server maintenance plan</li> <li>Describe task status notifications</li> </ul> <h3>18 - Manage Azure PaaS tasks using automation</h3> <ul> <li>Explore Elastic jobs</li> <li>Understand Azure Automation</li> <li>Build an automation runbook</li> <li>Automate database workflows by using Logic Apps</li> <li>Monitor automated tasks</li> </ul> <h3>19 - Describe high availability and disaster recovery strategies</h3> <ul> <li>Describe recovery time objective and recovery point objective</li> <li>Explore high availability and disaster recovery options</li> <li>Describe Azure high availability and disaster recovery  features for Azure Virtual Machines</li> <li>Describe high availability and disaster recovery options for PaaS deployments</li> <li>Explore an IaaS high availability and disaster recovery solution</li> <li>Describe hybrid solutions</li> </ul> <h3>20 - Explore IaaS and PaaS solutions for high availability and disaster recovery</h3> <ul> <li>Describe failover clusters in Windows Server</li> <li>Configure Always-on availability groups</li> <li>Describe temporal tables in Azure SQL Database</li> <li>Describe active geo-replication for Azure SQL Database</li> <li>Explore auto-failover groups for Azure SQL Database and Azure SQL Managed Instance</li> </ul> <h3>21 - Back up and restore databases</h3> <ul> <li>Back up and restore SQL Server running on Azure virtual machines</li> <li>Back up a SQL Server virtual machine</li> <li>Back up and restore a database using Azure SQL Database</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans DP-300T00: Administering Microsoft Azure SQL Solutions 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 DP-300T00: Administering Microsoft Azure SQL Solutions 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>

Azure SQL Database

Microsoft AZ-900

Microsoft Azure

Microsoft AZ-700

DP-300T00 Administering Microsoft Azure SQL Solutions

<div id="course-pills-1">Duration<p>4 Days</p><p>24 CPD hours</p>This course is intended for<p></p><p>Successful students have experience and knowledge in IT operations, including networking, virtualization, identity, security, business continuity, disaster recovery, data platforms, and governance. Students also have experience designing and architecting solutions.</p> <p>Before attending this course, students must have previous experience deploying or administering Azure resources and strong conceptual knowledge of:</p> <ul> <li><p>Azure compute technologies such as VMs, containers and serverless solutions</p> </li> <li><p>Azure virtual networking to include load balancers</p> </li> <li><p>Azure Storage technologies (unstructured and databases)</p> </li> <li><p>General application design concepts such as messaging and high availability</p> </li> </ul><p></p><p></p><p>This course teaches Azure Solution Architects how to design infrastructure solutions. Course topics cover governance, compute, application architecture, storage, data integration, authentication, networks, business continuity, and migrations. The course combines lecture with case studies to demonstrate basic architect design principles.</p><p></p>Prerequisites<p>Before attending this course, students must have previous experience deploying or administering Azure resources and conceptual knowledge of:  </p><li>Azure Active Directory</li>  <li>Azure compute technologies such as VMs, containers and serverless solutions</li>  <li>Azure virtual networking to include load balancers</li>  <li>Azure Storage technologies (unstructured and databases)</li>  <li>General application design concepts such as messaging and high availability</li>  <li>AZ-104T00 - Microsoft Azure Administrator<p></p></li></div><div id="course-pills-2"><h3>1 - Design governance</h3> <ul> <li>Design for governance</li> <li>Design for management groups</li> <li>Design for subscriptions</li> <li>Design for resource groups</li> <li>Design for resource tags</li> <li>Design for Azure Policy</li> <li>Design for role-based access control (RBAC)</li> <li>Design for Azure landing zones</li> </ul> <h3>2 - Design an Azure compute solution</h3> <ul> <li>Choose an Azure compute service</li> <li>Design for Azure Virtual Machines solutions</li> <li>Design for Azure Batch solutions</li> <li>Design for Azure App Service solutions</li> <li>Design for Azure Container Instances solutions</li> <li>Design for Azure Kubernetes Service solutions</li> <li>Design for Azure Functions solutions</li> <li>Design for Azure Logic Apps solutions</li> </ul> <h3>3 - Design a data storage solution for non-relational data</h3> <ul> <li>Design for data storage</li> <li>Design for Azure storage accounts</li> <li>Design for data redundancy</li> <li>Design for Azure Blob Storage</li> <li>Design for Azure Files</li> <li>Design for Azure managed disks</li> <li>Design for storage security</li> </ul> <h3>4 - Design a data storage solution for relational data</h3> <ul> <li>Design for Azure SQL Database</li> <li>Design for Azure SQL Managed Instance</li> <li>Design for SQL Server on Azure Virtual Machines</li> <li>Recommend a solution for database scalability</li> <li>Recommend a solution for database availability</li> <li>Design security for data at rest, data in motion, and data in use</li> <li>Design for Azure SQL Edge</li> <li>Design for Azure Cosmos DB and Table Storage</li> </ul> <h3>5 - Design data integration</h3> <ul> <li>Design a data integration solution with Azure Data Factory</li> <li>Design a data integration solution with Azure Data Lake</li> <li>Design a data integration and analytic solution with Azure Databricks</li> <li>Design a data integration and analytic solution with Azure Synapse Analytics</li> <li>Design strategies for hot, warm, and cold data paths</li> <li>Design an Azure Stream Analytics solution for data analysis</li> </ul> <h3>6 - Design an application architecture</h3> <ul> <li>Describe message and event scenarios</li> <li>Design a messaging solution</li> <li>Design an Azure Event Hubs messaging solution</li> <li>Design an event-driven solution</li> <li>Design a caching solution</li> <li>Design API integration</li> <li>Design an automated app deployment solution</li> <li>Design an app configuration management solution</li> </ul> <h3>7 - Design authentication and authorization solutions</h3> <ul> <li>Design for identity and access management (IAM)</li> <li>Design for Microsoft Entra ID</li> <li>Design for Microsoft Entra business-to-business (B2B)</li> <li>Design for Azure Active Directory B2C (business-to-customer)</li> <li>Design for conditional access</li> <li>Design for identity protection</li> <li>Design for access reviews</li> <li>Design service principals for applications</li> <li>Design managed identities</li> <li>Design for Azure Key Vault</li> </ul> <h3>8 - Design a solution to log and monitor Azure resources</h3> <ul> <li>Design for Azure Monitor data sources</li> <li>Design for Azure Monitor Logs (Log Analytics) workspaces</li> <li>Design for Azure Workbooks and Azure insights</li> <li>Design for Azure Data Explorer</li> </ul> <h3>9 - Design network solutions</h3> <ul> <li>Recommend a network architecture solution based on workload requirements</li> <li>Design patterns for Azure network connectivity services</li> <li>Design outbound connectivity and routing</li> <li>Design for on-premises connectivity to Azure Virtual Network</li> <li>Choose an application delivery service</li> <li>Design for application delivery services</li> <li>Design for application protection services</li> </ul> <h3>10 - Design a solution for backup and disaster recovery</h3> <ul> <li>Design for backup and recovery</li> <li>Design for Azure Backup</li> <li>Design for Azure blob backup and recovery</li> <li>Design for Azure files backup and recovery</li> <li>Design for Azure virtual machine backup and recovery</li> <li>Design for Azure SQL backup and recovery</li> <li>Design for Azure Site Recovery</li> </ul> <h3>11 - Design migrations</h3> <ul> <li>Evaluate migration with the Cloud Adoption Framework</li> <li>Describe the Azure migration framework</li> <li>Assess your on-premises workloads</li> <li>Select a migration tool</li> <li>Migrate your structured data in databases</li> <li>Select an online storage migration tool for unstructured data</li> <li>Migrate offline data</li> </ul> <h3>12 - Introduction to the Microsoft Azure Well-Architected Framework</h3> <ul> <li>Azure Well-Architected Framework pillars</li> <li>Cost optimization</li> <li>Operational excellence</li> <li>Performance efficiency</li> <li>Reliability</li> <li>Security</li> </ul> <h3>13 - Microsoft Azure Well-Architected Framework - Cost Optimization</h3> <ul> <li>Develop cost-management discipline</li> <li>Design with a cost-efficiency mindset</li> <li>Design for usage optimization</li> <li>Design for rate optimization</li> <li>Monitor and optimize over time</li> </ul> <h3>14 - Microsoft Azure Well-Architected Framework - Operational excellence</h3> <ul> <li>Embrace DevOps culture</li> <li>Establish development standards</li> <li>Evolve operations with observability</li> <li>Deploy with confidence</li> <li>Automate for efficiency</li> <li>Adopt safe deployment practices</li> </ul> <h3>15 - Microsoft Azure Well-Architected Framework - Performance efficiency</h3> <ul> <li>Negotiate realistic performance targets</li> <li>Design to meet capacity requirements</li> <li>Achieve and sustain performance</li> <li>Improve efficiency through optimization</li> </ul> <h3>16 - Microsoft Azure Well-Architected Framework - Reliability</h3> <ul> <li>Design for business requirements</li> <li>Design for resilience</li> <li>Design for recovery</li> <li>Design for operations</li> <li>Keep it simple</li> </ul> <h3>17 - Microsoft Azure Well-Architected Framework - Security</h3> <ul> <li>Plan your security readiness</li> <li>Design to protect confidentiality</li> <li>Design to protect integrity</li> <li>Design to protect availability</li> <li>Sustain and evolve your security posture</li> </ul> <h3>18 - Getting started with the Microsoft Cloud Adoption Framework for Azure</h3> <ul> <li>Customer narrative</li> <li>Common blockers</li> </ul> <h3>19 - Prepare for successful cloud adoption with a well-defined strategy</h3> <ul> <li>Customer narrative</li> <li>Capture strategic motivation</li> <li>Define objectives and key results</li> <li>Evaluate financial considerations</li> <li>Understand technical considerations</li> <li>Create a business case</li> </ul> <h3>20 - Prepare for cloud adoption with a data-driven plan</h3> <ul> <li>Customer narrative</li> </ul> <h3>21 - Choose the best Azure landing zone to support your requirements for cloud operations</h3> <ul> <li>Customer narrative</li> <li>Common operating models</li> <li>Design areas for Azure landing zones</li> <li>Design principles for Azure landing zones</li> <li>Journey to the target architecture</li> <li>Choose an Azure landing zone option</li> <li>Deploy the Azure landing zone accelerator</li> <li>Enhance your landing zone</li> </ul> <h3>22 - Migrate to Azure through repeatable processes and common tools</h3> <ul> <li>Customer narrative</li> <li>Migration process</li> <li>Migration tools</li> <li>Common tech platforms</li> </ul> <h3>23 - Address tangible risks with the Govern methodology of the Cloud Adoption Framework for Azure</h3> <ul> <li>Customer narrative</li> <li>Govern methodology</li> <li>Corporate policies</li> <li>Governance disciplines</li> <li>Deploy a cloud governance foundation</li> <li>The Cost Management discipline</li> </ul> <h3>24 - Ensure stable operations and optimization across all supported workloads deployed to the cloud</h3> <ul> <li>Establish business commitments</li> <li>Deploy an operations baseline</li> <li>Protect and recover</li> <li>Enhance an operations baseline</li> <li>Manage platform and workload specialization</li> </ul> <h3>25 - Innovate applications by using Azure cloud technologies</h3> <ul> <li>Follow the innovation lifecycle</li> <li>Azure technologies for the build process</li> <li>Infuse your applications with AI</li> <li>Azure technologies for measuring business impact</li> <li>Azure technologies for the learn process</li> </ul> <h3>26 - Prepare for cloud security by using the Microsoft Cloud Adoption Framework for Azure</h3> <ul> <li>Customer narrative</li> <li>Methodology</li> <li>Security roles and responsibilities</li> <li>Simplify compliance and security</li> <li>Simplify security implementation</li> <li>Security tools and policies</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans AZ-305T00: Designing Microsoft Azure Infrastructure Solutions 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 AZ-305T00: Designing Microsoft Azure Infrastructure Solutions 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>

AWS Certified Solutions Architect

AZ-305T00 Designing Microsoft Azure Infrastructure Solutions

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>The primary audience for this course is people who are moving into a database role, or whose role has expanded to include database technologies. Developers that deliver content from SQL Server databases will also benefit from this material.</p>Overview<p>After completing this course, you will be able to:<br />Describe key database concepts in the context of SQL Server<br />Describe database languages used in SQL Server<br />Describe data modelling techniques<br />Describe normalization and denormalization techniques<br />Describe relationship types and effects in database design<br />Describe the effects of database design on performance<br />Describe commonly used database objects</p><p>This course is provided as an introductory class for anyone getting started with databases. It will be useful to programmers and other IT professionals whose job roles are expanding into database management. Students will learn fundamental database concepts through demonstrations and hands-on labs on a SQL Server instance.<br />This material updates and replaces course Microsoft course 10985 which was previously published under the same title.</p></div><div id="course-pills-2"><h4>Module 1: Introduction to databases</h4><ul><li>Introduction to Relational Databases</li><li>Other Databases and Storage</li><li>Data Analysis</li><li>SQL Server Database Languages</li></ul><h4>Module 2: Data Modeling</h4><ul><li>Data Modelling</li><li>Designing a Database</li><li>Relationship Modeling</li></ul><h4>Module 3: Normalization</h4><ul><li>Fundamentals of Normalization</li><li>Normal Form</li><li>Denormalization</li></ul><h4>Module 4: Relationships</h4><ul><li>Introduction to Relationships</li><li>Planning Referential Integrity</li></ul><h4>Module 5: Performance</h4><ul><li>Indexing</li><li>Query Performance</li><li>Concurrency</li></ul><h4>Module 6: Database Objects</h4><ul><li>Tables</li><li>Views</li><li>Stored Procedures, Triggers and Functions</li></ul></div>

Microsoft SQL Server

Microsoft SQL

AWS Certified Database

SQL Server

Database Administration

55315: Introduction to SQL Databases

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong id="isPasted" style="color: rgb(34, 177, 77); font-weight: 700; box-sizing: border-box;" fr-original-style=" color: rgb(34, 177, 77);">CPD Accredited, Interactive&nbsp;Short Course</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li id="isPasted" fr-original-style="" style="box-sizing: border-box;">2 hr session</li><li fr-original-style="" style="box-sizing: border-box;">What is Attention Deficit Disorder?</li><li fr-original-style="" style="box-sizing: border-box;">How can you best understand, and thus cope and help those affected?</li></ul><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Contents:</strong><ul id="isPasted" fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">What is ADHD</li><li fr-original-style="" style="box-sizing: border-box;">ADHD as part of the Autistic Spectrum</li><li fr-original-style="" style="box-sizing: border-box;">How to help you cope if you have ADHD</li><li fr-original-style="" style="box-sizing: border-box;">How to cope with children who have ADHD</li><li fr-original-style="" style="box-sizing: border-box;">Great for teachers and TAs in schools, others who work with people who have ADHD, and of course, those with ADHD themselves</li></ul><h2 fr-original-style="" style="box-sizing: border-box;">Benefits of this Short Course:</h2><ul fr-original-style="" style="box-sizing: border-box;"><li id="isPasted" fr-original-style="" style="box-sizing: border-box;">Boys are around 4 x as likely to have ADHD</li><li fr-original-style="" style="box-sizing: border-box;">Worldwide, 5% of people have it - that is 1 out of every 20!</li><li fr-original-style="" style="box-sizing: border-box;">The figure for this is estimated to be higher in the UK</li><li fr-original-style="" style="box-sizing: border-box;">This means that every single classroom in the UK will have at least one child or young people with Attention Deficit Hyperactive Disorder</li><li fr-original-style="" style="box-sizing: border-box;">Learn more about the condition and how you can help them cope and take part in &#39;normal&#39; life.</li></ul><h2 fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></h2>

CPD Accredited, Interactive Short Course
2 - 3.5 hr sessions
What is Attention Deficit Disorder?
How can you best understand, and thus cope and help those affected?
Course Contents:
What is ADHD
ADHD as part of the Autistic Spectrum
How to help you cope if you have ADHD
How to cope with children who have ADHD
Great for teachers and TAs in schools, others who work with people who have ADHD, and of course, those with ADHD themselves
Benefits of this Short Course:
Boys are around 4 x as likely to have ADHD
Worldwide, 5% of people have it - that is 1 out of every 20!
The figure for this is estimated to be higher in the UK
This means that every single classroom in the UK will have at least one child or young people with Attention Deficit Hyperactive Disorder
Learn more about the condition and how you can help them cope and take part in 'normal' life.




Pochat Training

Neurodiversity

ADHD (Attention Deficit Hyperactivity Disorder)

Coping With ADHD

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

Platinum Training Institute

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

Bournemouth

London Waterloo Academy

Flight Attendant

Stewardess

FLIGHT ATTENDANT VIRTUAL VIA ZOOM COURSE, EVENINGS

Registration Fee

Course Fee

Manchester

<p style="color: rgb(34, 34, 34); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(34, 34, 34);">The WSET Level 2 Award in Wines has full accreditation from OfQual as a Level 2 Vocational Qualification. Through a combination of tasting and theory you will explore the factors that impact the style and quality of wine and learn how to describe wines with confidence.</p><p style="color: rgb(34, 34, 34); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(34, 34, 34);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Schedule:</strong></p><p style="color: rgb(34, 34, 34); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(34, 34, 34);">The 8 x 2-hour online sessions on -&nbsp;</p><p style="color: rgb(34, 34, 34); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(34, 34, 34);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">What the course covers</strong></p><ul style="color: rgb(34, 34, 34); box-sizing: border-box;" fr-original-style=" color: rgb(34, 34, 34);"><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Wine tasting</strong>: You will learn how to taste and describe wines using the WSET Systematic Approach to Tasting (SAT)</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Food and wine pairing</strong>: You will learn the principles of food and wine pairing</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Wine service and storage</strong>: You will learn the correct way to store and serve wine and how to recognise common faults found in wine</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Labelling</strong>: You will learn how to decode and understand wine labels</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Factors influencing the style of wine</strong>: You will explore how environmental factors, grape-growing, vineyard and maturation options influence the style and quality of the wines made all over the world</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Grape varieties</strong>: You&#39;ll learn about the styles of wines produced by the key international red and white grape varieties (Chardonnay, Pinot Grigio, Sauvignon Blanc, Riesling, Cabernet Sauvignon, Pinot Noir, Merlot and Syrah/Shiraz) as well as the styles of wines made with 22 regionally important grape varieties grown in 70 wine regions (GI&#39;s) around the world</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Sparkling and Fortified wines</strong>: You will be taught how grape varieties and winemaking processes influence the style of wines in these two key wine categories.</li></ul><p style="color: rgb(34, 34, 34); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(34, 34, 34);">No prior wine knowledge is required however the course builds upon the&nbsp;<a href="https://www.localwineschool.com/manchester/events/professional-courses/wset-courses/wset-course-level-1-online/" target="_blank" rel="noopener" style="color: rgb(157, 40, 51); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(157, 40, 51);">WSET Level 1 Award in Wines</a> course. It is not essential to complete Level 1 to join the Level 2 course but if you are a complete begineer you may wish to consider this option. We recommend you read the course specification document&nbsp;<a href="https://www.wsetglobal.com/media/11718/wset_l2wines_specification_en_jun2022_issue11.pdf" target="_blank" rel="noopener" style="color: rgb(157, 40, 51); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(157, 40, 51);">HERE</a>&nbsp;for full details of the content, structure and assesment criteria. Any questions please&nbsp;<a href="https://www.localwineschool.com/manchester/contact/" target="_blank" rel="noopener" style="color: rgb(157, 40, 51); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(157, 40, 51);">get in touch</a>.</p><p style="color: rgb(34, 34, 34); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(34, 34, 34);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course delivery</strong></p><ul style="color: rgb(34, 34, 34); box-sizing: border-box;" fr-original-style=" color: rgb(34, 34, 34);"><li fr-original-style="" style="box-sizing: border-box;">The Level 2 Award in Wines online course covers the same syllabus as the classroom course and is delivered in LIVE interactive online lessons by one of our certified wine educators</li><li fr-original-style="" style="box-sizing: border-box;">This course includes 16 hours online tuition in 8 x 2hr sessions&nbsp;and we recommend a minimum of 12 hours additional study</li><li fr-original-style="" style="box-sizing: border-box;">Your tutor will give you a guided tasting of 12 wines on this course (for details of how to order the wines see below)</li><li fr-original-style="" style="box-sizing: border-box;">You will receive access to practice multiple-choice revision questions specific to this course - FREE OF CHARGE</li></ul><p style="color: rgb(34, 34, 34); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(34, 34, 34);">Please note a reliable broadband connection is essential for the completion of this online course as are basic computer skills.</p><p style="color: rgb(34, 34, 34); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(34, 34, 34);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Examination</strong></p><p style="color: rgb(34, 34, 34); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(34, 34, 34);">To obtain the WSET Level 2 Award in Wines Qualification, you will need to successfully pass the exam. The exam is made up of 50 multiple-choice questions to be completed in 1 hour. A mark of 55% is required to pass the exam.</p><p style="color: rgb(34, 34, 34); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(34, 34, 34);">The exam is taken online via a <a href="https://www.youtube.com/watch?v=DarWJz6dUbU" target="_blank" rel="noopener" style="color: rgb(157, 40, 51); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(157, 40, 51);">Remote Invigilation</a> service giving you the flexibility to take the exam at a time and date of your choice. More details will be sent upon registration. Please ensure you read the information&nbsp;<a href="https://www.wsetglobal.com/wset-remote-invigilation-essential-guidance/?dm_i=5G5C,KRHB,4A50QU,2G285,1" target="_blank" rel="noopener" style="color: rgb(157, 40, 51); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(157, 40, 51);">HERE</a>&nbsp;if you wish to take the exam online.&nbsp;</p><p style="color: rgb(34, 34, 34); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(34, 34, 34);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Whats included</strong></p><ul style="color: rgb(34, 34, 34); box-sizing: border-box;" fr-original-style=" color: rgb(34, 34, 34);"><li fr-original-style="" style="box-sizing: border-box;">All WSET course materials posted to you at no extra charge including: Looking Behind the Label course manual, Study Guide, specification and SAT Tasting Card</li><li fr-original-style="" style="box-sizing: border-box;">LIVE virtual interactive sessions taught by a Local Wine School WSET Certified Tutor</li><li fr-original-style="" style="box-sizing: border-box;">Exclusive access to practice multiple choice questions provided FREE OF CHARGE</li><li fr-original-style="" style="box-sizing: border-box;">WSET exam fee&nbsp;</li><li fr-original-style="" style="box-sizing: border-box;">Remote Invigilation service&nbsp;</li><li fr-original-style="" style="box-sizing: border-box;">Internationally recognised WSET qualification, certificate and pin for those who pass the exam</li><li fr-original-style="" style="box-sizing: border-box;">VAT at 20% &nbsp;(VAT receipt can be provided on request)</li></ul><p style="color: rgb(34, 34, 34); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(34, 34, 34);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Wines</strong></p><p style="color: rgb(34, 34, 34); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(34, 34, 34);">It is recommended that at least 12 wines are tasted as part of this course, although this is optional and the cost of wines is not included in the course fee above.</p><p style="color: rgb(34, 34, 34); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(34, 34, 34);">Our wine experts have specially selected wines for this course designed to demonstrate specific learning outcomes. We have negotiated a discounted price only available to our online students. Details of how to order your case of wines will be provided when you book your place. The cost is approx &pound;150 including VAT and delivery.&nbsp;</p><p style="color: rgb(34, 34, 34); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(34, 34, 34);">Wine preservation advice is give so that after each tasting exercise you can reseal and return to the wines over the coming days. &nbsp;</p><p style="color: rgb(34, 34, 34); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(34, 34, 34);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Special Educational Needs</strong></p><p style="color: rgb(34, 34, 34); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(34, 34, 34);">Please make the school aware if you have a condition which may mean that you will qualify for additional help during the exam such as dyslexia.</p><p style="color: rgb(34, 34, 34); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(34, 34, 34);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Important dates</strong></p><p style="color: rgb(34, 34, 34); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(34, 34, 34);">Registration deadline: please book at least 5 days before the start of the course, to allow time to send materials and order the tasting wines.</p>

Manchester Wine School

Sommelier

ONLINE - WSET Level 2 Award in Wines - Evenings

1336 Courses in Leeds

FREC 4

By NR Medical Training

Ready to Reignite Your Team Post-Summer?

By CAPE Coaching and Development

Visual Analytics Best Practice

By Tableau Training Uk

Mastering Real Estate Investments: Strategies for Success in REITs and Beyond

By Finex Learning

Power BI - introduction to intermediate (2 days) (In-House)

By The In House Training Company

Access - introduction (In-House)

By The In House Training Company

Power BI - introduction (2 day) (In-House)

By The In House Training Company

Excel - introduction (In-House)

By The In House Training Company

Word - intermediate (In-House)

By The In House Training Company

Excel - intermediate (In-House)

By The In House Training Company

Search By Location