Name: Negotiation Skills - Professional 1 Day Workshop in Harrogate
Price: 595 GBP
Availability: InStock

Chester

<h1 dir="ltr" id="isPasted" fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Course Overview:</span></h1><p dir="ltr" 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:#000000;">This training based on leading teams will help you to develop anyone that leads a team or is involved in a leadership role. It is also useful for those that are about to embark on a position of leadership or need to develop their leadership skills.</span></p><p dir="ltr" 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:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Contents:</strong></span></p><p dir="ltr" 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:#000000;">Having an effective team around you is crucial. However, it is an area that is often left to chance, which can lead to de-motivated individuals that do not feel part of the business and consequently do not perform. This course looks at what it takes to lead an effective team and how you can get the best out of the people in it by understanding the role of the leader, both personally and from the point of view of the team.</span></p><p dir="ltr" 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:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Topics:</strong></span></p><ul fr-original-style="" style="box-sizing: border-box;"><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" 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:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Qualities of an Effective Leader</strong></span><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">&nbsp;&ndash; Identifying the key characteristics of effective leaders, rating themselves against them and establishing key actions to develop the skills.</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" 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:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Leader or Manager?</strong></span><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">&nbsp;&ndash; Establishing the difference between the two and comparing themselves to those qualities.</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" 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:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">That Vision Thing</strong></span><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">&nbsp;&ndash; Making the business vision &lsquo;live&rsquo; for the team by answering key questions.</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" 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:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Developing Your Team Goals</strong></span><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">&nbsp;&ndash; Reviewing an action plan that develops clear goals for their team based on the business vision.</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" 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:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Motivation</strong></span><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">&nbsp;&ndash; Determining the &lsquo;Why&rsquo; for their staff and developing an understanding of emotions in a business context.</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" 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:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">What Motivates?</strong></span><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">&nbsp;&ndash; Looking at specific motivators for individuals and understanding that everyone is motivated by different things.</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" 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:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Being Consistently Different</strong>&nbsp;</span><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">&ndash; Going against popular leadership theory and identifying that each staff member needs to be treated differently.</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" 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:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Dealing With Difficult Team Members</strong></span><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">&nbsp;&ndash; Understanding why team members are difficult. Looking at different behavior types and strategies for responding to them. Also, realizing that &lsquo;difficult&rsquo; behavior sometimes has its benefits.</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" 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:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Coaching</strong></span><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">&nbsp;&ndash; Using a simple method of coaching, including action plans.</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" 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:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Three Key Skills of Coaching</strong></span><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">&nbsp;&ndash; Looking at the skills required to be an effective coach.</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" 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:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Instant Results Coaching</strong></span><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">&nbsp;&ndash; Coaching in a hurry!</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" 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:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Can Do Coaching Practice</strong></span><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">&nbsp;&ndash; Putting the learning into practice</span></p></li></ul><p dir="ltr" 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:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Feature:</strong></span></p><p dir="ltr" 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:#000000;">By the end of this training you will be able to:</span></p><ul fr-original-style="" style="box-sizing: border-box;"><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" 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:#000000;">Explain the qualities of an effective leader</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" 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:#000000;">Benchmark themselves against those qualities and develop actions to improve</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" 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:#000000;">Explain the difference between leading and managing</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" 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:#000000;">Explain the value of sharing the business vision with the team</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" 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:#000000;">Develop team goals based on the business vision</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" 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:#000000;">Motivate their staff by understanding their drivers and developing actions to support them</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" 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:#000000;">Deal with difficult staff members</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" 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:#000000;">Challenge staff in a meaningful and effective way</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" 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:#000000;">Coach staff effectively using a simple process</span></p></li></ul><p dir="ltr" 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:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Certification:</strong></span></p><p dir="ltr" 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:#000000;">Once after the training you receive course completion certificate from Mangates</span></p><p dir="ltr" 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:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who can Attend?</strong></span></p><p dir="ltr" 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:#000000;">Anybody who is interested in learning Effective Skills to Lead a Team.</span></p>

Certificate: Course Completion Certificate | Language: English

Duration: 1 Day | Credits: 8 PDUs

Course Delivery: Classroom | Virtual Live

Lunch and Beverages are included in a classroom session

Course  Overview:

This course focuses on effective negotiation techniques to be successful in different situations and with people holding different levels of power. The course evaluates how negotiations impact the organizations and ourselves. Reflect on the different outcomes that can be achieved through negotiation and understand which outcomes are acceptable for the intended objectives. Finally participants reflect on the influencing process and how one can achieve things without having the authority or power. 

Each module has been carefully selected based on the intake and skills gaps of the specific audience. After a brief introduction, participants are given 1 to 2 minutes to introduce themselves, practicing their presentation and communication skills (if the intake has included the requested video, this introduction will only be 1 minute). 

Learning Objectives:

At the end of this course, you will be able to:
Define negotiation and influencing stages and how to do so effectively. 
Understand different aspects of negotiating: persuasion, manipulation, assertiveness, rationalization, and active listening. 
Understand individuals and organizations (attitude, behavior and culture). What each party expects, dealing with emotions, and resistance. 
Power play: who is in control and how to change it – tactics and coordination of power. The importance of knowledge.
Understand communication strategies, effectiveness in communicating, verbal and nonverbal 
Orchestrating a plan: positioning, anticipating problems, managing conflicts, and  approaching others for help. 
Understand interpersonal skills: importance of self-awareness, adapting expectations, and resilience. 
Understand results: risk assessment, damage control, keeping good relationships, win-win outcomes. 
Understand how to use BAPNA, ZOPA, negotiation canvas and other tools and strategies.
Understand how communication and presentation skills empower your negotiation abilities. 

Agenda:

Before We Begin
Welcome/Introductions
Purpose/Inspiration
Course Dynamics
Self Evaluation on Basic Negotiation Skills Knowledge - Class Discussion

Negotiation Canvas
Understanding the Methodology
Think, Feel, See, Hear, Say and Do
Giving and Taking
Points of Interest
Plan B (Key Arguments and Drawbacks)

BATNA and ZOPA
BATNA - Best Alternative to a Negotiated Agreement Intro
Example/Role play: Selling a Car
ZOPA - Zone of Possible Agreement or "bargaining range” Intro
Example/Role Play: Overcoming a Negative Bargaining Zone

Evaluating Success
Defining Negotiation Success
Criteria to Evaluate/Measure Success and Effectiveness
Exercise/Role Play: Hand Shaking
Maintaining a Continued Positive Relationship

Influence and persuasion 
Definitions
General Overview
Positive and Negative Ways to Influence
Open Discussion: Sun vs Wind Tale 
Video: Perception and Persuasion
Video: The Science of Persuasion

Introduction to Communication and Presentation skills
Communication Skills
Exercise/Role Play: Connecting Strangers
Presentation Skills
Exercise/Role Play: Words Clearly Spoken and Silence
Video TED: How to Sound Smart - View and Discuss

Conclusions
Wrap Up
Self Assessment GAP
Feedback Form
Closing Remarks

Mangates

Negotiation Skills - Professional 1 Day Workshop in Chester

The sale ends 5 days before the event starts.

Early Bird Fee

The sale ends 10 days before the event starts.

Standard Fee

Canterbury

Negotiation Skills - Professional 1 Day Workshop in Canterbury

Carlisle

Negotiation Skills - Professional 1 Day Workshop in Carlisle

Fleet 

Negotiation Skills - Professional 1 Day Workshop in Fleet

Glasgow

Negotiation Skills - Professional 1 Day Workshop in Glasgow

High Wycombe 

Negotiation Skills - Professional 1 Day Workshop in High Wycombe

Hamilton, UK

Negotiation Skills - Professional 1 Day Workshop in Hamilton, UK

Gloucester

Negotiation Skills - Professional 1 Day Workshop in Gloucester

Guildford

Negotiation Skills - Professional 1 Day Workshop in Guildford

Harrogate

Negotiation Skills - Professional 1 Day Workshop in Harrogate

<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);">Learn the &lsquo;Essentials&rsquo; of gift wrapping in just 90 minutes (with your friends!)</span></p><p style="color: rgb(51, 51, 51); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(51, 51, 51);"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">What&rsquo;s included (and how it will help):</span></p><ul style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);"><li style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;"><span style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;">Step by step tuition covering all the&nbsp;</span><b fr-original-style="" style="box-sizing: border-box;">Essential Techniques</b><span style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;">&nbsp;of gift wrapping so you never need to grab a gift/bottle bag again&nbsp;</span></li><li style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;"><span style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;">Practical guidance on tying different styles of&nbsp;</span><b fr-original-style="" style="box-sizing: border-box;">Ribbon Bow&nbsp;</b><span style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;">so you can confidently use them on any gift (and when it&rsquo;s best to use each one)&nbsp;</span></li><li style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;"><span style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;">Learn&nbsp;</span><b fr-original-style="" style="box-sizing: border-box;">Pro tips</b><span style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;">&nbsp;so you feel less overwhelmed &amp; can gift wrap quickly at busy times&nbsp;</span></li></ul><p style="color: rgb(51, 51, 51); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);">With many years experience teaching classes, both one to one and in groups, you will complete the class feeling confident that your gift wrapping will never be an embarrassment to you again.</p><div style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);"><br fr-original-style="" style="box-sizing: border-box;"></div><div style="color: rgb(51, 51, 51); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(51, 51, 51);"><div style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;"><div style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;"><div style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;"><div style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;"><div style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;"><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><h2 style="color: rgb(250, 247, 242) !important; box-sizing: border-box;" fr-original-style=" color: rgb(250, 247, 242) !important;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">90 Minute Group Class</span></h2><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">No Replay</span></div><div style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;"><span style="color: rgb(153, 153, 153); box-sizing: border-box;" fr-original-style=" color: rgb(153, 153, 153);"><span style="color: rgb(225, 34, 44) !important; box-sizing: border-box;" fr-original-style=" color: rgb(225, 34, 44) !important;">&pound;97</span></span></div><div style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;"><ul style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;"><li style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;"><span style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;">How to measure exactly how much gift wrapping paper you need so you always know how much to cut (and why this is important)</span></li><li style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;"><span style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;">Wrap a box using the paper &amp; only 3 pieces of tape so you can do this quickly &amp; easily</span></li><li style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;"><span style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;">Learn to tie 2 differnt styles of bow (and when to use them)</span></li><li style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;"><span style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;">How to pleat gift wrapping paper so you can add extra detail to a gift</span></li><li style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;"><span style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;">How to wrap a bottle so you never need to grab a bottle bag again</span></li></ul></div><div style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;"><br fr-original-style="" style="box-sizing: border-box;"></div></div><div style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;"><div style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;"><h2 style="color: rgb(250, 247, 242) !important; box-sizing: border-box;" fr-original-style=" color: rgb(250, 247, 242) !important;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">90 Minute Group Class</span></h2><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">Includes replay</span></div><div style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;"><span style="color: rgb(153, 153, 153); box-sizing: border-box;" fr-original-style=" color: rgb(153, 153, 153);"><span style="color: rgb(225, 34, 44) !important; box-sizing: border-box;" fr-original-style=" color: rgb(225, 34, 44) !important;">&pound;&pound;117</span></span></div><div style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;"><ul style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;"><li style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;"><span style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;">How to measure exactly how much gift wrapping paper you need so you always know how much to cut (and why this is important)</span></li><li style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;"><span style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;">Wrap a box using the paper &amp; only 3 pieces of tape so you can do this quickly &amp; easily</span></li><li style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;"><span style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;">Learn to tie 2 differnt styles of bow (and when to use them)</span></li><li style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;"><span style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;">How to pleat gift wrapping paper so you can add extra detail to a gift</span></li><li style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;"><span style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;">How to wrap a bottle so you never need to grab a bottle bag again</span></li><li style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;"><span style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;">Plus a replay of the class</span></li></ul></div><div style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;"><br fr-original-style="" style="box-sizing: border-box;"></div></div></div></div><div style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;"><div style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;"><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><h4 style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;">FREQUENTLY ASKED QUESTIONS</h4></div></div></div></div><div style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);"><div style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;"><div style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;"><div style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;"><h4 style="color: rgb(102, 102, 102); box-sizing: border-box;" fr-original-style=" color: rgb(102, 102, 102);">1. What&#39;s included in a 90 minute virtual class?</h4><ul style="color: rgb(51, 51, 51); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(51, 51, 51);"><li style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;"><span style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;">Step by step tuition covering all the&nbsp;</span><b fr-original-style="" style="box-sizing: border-box;">Essential Techniques</b><span style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;">&nbsp;of gift wrapping so you never need to grab a gift/bottle bag again&nbsp;</span></li><li style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;"><span style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;">Practical guidance on tying different styles of&nbsp;</span><b fr-original-style="" style="box-sizing: border-box;">Ribbon Bow&nbsp;</b><span style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;">so you can confidently use them on any gift (and when it&rsquo;s best to use each one)&nbsp;</span></li><li style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;"><span style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;">Learn&nbsp;</span><b fr-original-style="" style="box-sizing: border-box;">Pro tips</b><span style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;">&nbsp;so you feel less overwhelmed &amp; can gift wrap quickly at busy times&nbsp;</span></li></ul></div><div style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;"><h4 style="color: rgb(102, 102, 102); box-sizing: border-box;" fr-original-style=" color: rgb(102, 102, 102);">2. How much is a 90 minute virtual gift wrapping class?</h4><div fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(51, 51, 51); box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(51, 51, 51);">There are 2 options to choose from starting from &pound;97 per person</span></div></div><div style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;"><h4 style="color: rgb(102, 102, 102); box-sizing: border-box;" fr-original-style=" color: rgb(102, 102, 102);">3. How long does a virtual gift wrapping class last?</h4><div fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(51, 51, 51); box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(51, 51, 51);">A group virtual gift wrapping class lasts 90 minutes but I recommend allowing 2 hours in case there are any tech issue (unlikely but better to be prepared).</span></div></div><div style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;"><h4 style="color: rgb(102, 102, 102); box-sizing: border-box;" fr-original-style=" color: rgb(102, 102, 102);">4. Are materials provided?</h4><div fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(51, 51, 51); box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(51, 51, 51);">No, materials are not provided. I will send you a list of what you need at least 2 weeks ahead of the class (or once your booking is confirmed if less than 2 weeks until the class)</span></div></div><div style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;"><h4 style="color: rgb(102, 102, 102); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(102, 102, 102);">5. What is the difference between an in person &amp; a virtual workshop?</h4><div fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(51, 51, 51); box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(51, 51, 51);">At a 90 minute virtual class you will get tuition on essential gift wrapping techniques, p</span><span style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);">ractical guidance on tying different styles of&nbsp;</span><span style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style="color: rgb(51, 51, 51);">bow &amp; l</span><span style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);">earn p</span><span style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style="color: rgb(51, 51, 51);">ro tips. An in-person class ususally last a full day, includes lunch/refreshments and all materials which are not included with any virtual classes.</span></div></div></div></div><div style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;"><div style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;"><div style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;"><h4 style="color: rgb(102, 102, 102); box-sizing: border-box;" fr-original-style=" color: rgb(102, 102, 102);">6. What if I can&#39;t attend the class - do I get a refund?</h4><div fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(51, 51, 51); box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(51, 51, 51);">If you can bo longer attend the date of the class you have chosen, you may move your booking to another date, once, at no extra charge. I do limit the number of people at a group virtual class so if your chosen date to move to is full, you may need to wait until another class becomes available. If no class is available then you will be eligible for a refund.&nbsp;</span></div></div><div style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;"><h4 style="color: rgb(102, 102, 102); box-sizing: border-box;" fr-original-style=" color: rgb(102, 102, 102);">7. Who is a virtual class suitable for?</h4><div fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(51, 51, 51); box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(51, 51, 51);">The classes are suitable for any skill level from beginner to anyone that has already tried the basics and wants to learn more. A group class is ideal if want to attend with a group of friends but you struggle to attend an in person class that fits in with your schedule/commitments.</span></div></div><div style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;"><h4 style="color: rgb(102, 102, 102); box-sizing: border-box;" fr-original-style=" color: rgb(102, 102, 102);">8. Who is a virtual class not suitable for?</h4><div style="color: rgb(51, 51, 51); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(51, 51, 51);"><div style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;"><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: inherit !important;">There are no exclusions to suitability</p></div></div></div><div style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;"><h4 style="color: rgb(102, 102, 102); box-sizing: border-box;" fr-original-style=" color: rgb(102, 102, 102);">9. What results can I expect if I attend a virtual class?</h4><div fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(51, 51, 51); box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(51, 51, 51);">That all depends on you and if you&rsquo;re prepared to go away and practice/use the skills you have learned in the class.&nbsp;</span></div></div><div style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;"><h4 style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);">10. Is there a replay?</h4><div style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;"><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: inherit !important;">You do have the option to buy a class that includes a recording. If you decide after the class that you&rsquo;d like to purchase a recording, email me&nbsp;<span style="color: rgb(255, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(255, 0, 0);">louise@louiselewis.co.uk</span></p></div></div></div></div></div>

Learn the ‘Essentials’ of gift wrapping in just 90 minutes (with your friends!)
What’s included (and how it will help):
Step by step tuition covering all the Essential Techniques of gift wrapping so you never need to grab a gift/bottle bag again
Practical guidance on tying different styles of Ribbon Bow so you can confidently use them on any gift (and when it’s best to use each one)
Learn Pro tips so you feel less overwhelmed & can gift wrap quickly at busy times
With many years experience teaching classes, both one to one and in groups, you will complete the class feeling confident that your gift wrapping will never be an embarrassment to you again.



90 Minute Group Class
No Replay
£97
How to measure exactly how much gift wrapping paper you need so you always know how much to cut (and why this is important)
Wrap a box using the paper & only 3 pieces of tape so you can do this quickly & easily
Learn to tie 2 differnt styles of bow (and when to use them)
How to pleat gift wrapping paper so you can add extra detail to a gift
How to wrap a bottle so you never need to grab a bottle bag again
90 Minute Group Class
Includes replay
££117
How to measure exactly how much gift wrapping paper you need so you always know how much to cut (and why this is important)
Wrap a box using the paper & only 3 pieces of tape so you can do this quickly & easily
Learn to tie 2 differnt styles of bow (and when to use them)
How to pleat gift wrapping paper so you can add extra detail to a gift
How to wrap a bottle so you never need to grab a bottle bag again
Plus a replay of the class



FREQUENTLY ASKED QUESTIONS
1. What's included in a 90 minute virtual class?
Step by step tuition covering all the Essential Techniques of gift wrapping so you never need to grab a gift/bottle bag again
Practical guidance on tying different styles of Ribbon Bow so you can confidently use them on any gift (and when it’s best to use each one)
Learn Pro tips so you feel less overwhelmed & can gift wrap quickly at busy times
2. How much is a 90 minute virtual gift wrapping class?There are 2 options to choose from starting from £97 per person3. How long does a virtual gift wrapping class last?A group virtual gift wrapping class lasts 90 minutes but I recommend allowing 2 hours in case there are any tech issue (unlikely but better to be prepared).4. Are materials provided?No, materials are not provided. I will send you a list of what you need at least 2 weeks ahead of the class (or once your booking is confirmed if less than 2 weeks until the class)5. What is the difference between an in person & a virtual workshop?At a 90 minute virtual class you will get tuition on essential gift wrapping techniques, practical guidance on tying different styles of bow & learn pro tips. An in-person class ususally last a full day, includes lunch/refreshments and all materials which are not included with any virtual classes.
6. What if I can't attend the class - do I get a refund?If you can bo longer attend the date of the class you have chosen, you may move your booking to another date, once, at no extra charge. I do limit the number of people at a group virtual class so if your chosen date to move to is full, you may need to wait until another class becomes available. If no class is available then you will be eligible for a refund. 7. Who is a virtual class suitable for?The classes are suitable for any skill level from beginner to anyone that has already tried the basics and wants to learn more. A group class is ideal if want to attend with a group of friends but you struggle to attend an in person class that fits in with your schedule/commitments.
8. Who is a virtual class not suitable for?
There are no exclusions to suitability
9. What results can I expect if I attend a virtual class?That all depends on you and if you’re prepared to go away and practice/use the skills you have learned in the class.
10. Is there a replay?
You do have the option to buy a class that includes a recording. If you decide after the class that you’d like to purchase a recording, email me louise@louiselewis.co.uk

Louise Lewis

90 minute Group Gift Wrapping Class

No Replay

Includes Replay

Are you interested in learning Vehicle Wrapping, and have you been thinking 'Where can I find a Vehicle Wrapping Course near me?'. Well, you are at the right place. You can now learn all the basics of Vehicle Wrapping and its best practices from your home. Welcome to our comprehensive vehicle wrapping course solely dedicated to enthusiasts, beginners, and professionals who share a desire to transform automobiles into works of art.
This course is designed to provide the skills and information you need to improve your car customisation game. Whether you are a DIY enthusiast or an aspiring professional, this training will meet your learning goals. Each session will gradually increase your knowledge of everything from fundamental automobile preparation to advanced vinyl wrapping techniques.
Through this course, you will learn the fundamentals of vehicle care and the art of washing; car detailing essentials and the details of vinyl wrapping a hood; the art of wrapping different car panels, including doors, fenders, and rear quarters; Inlays, emblem, and badge removal techniques for a seamless finish; and Wrapping additional components such as trunks, side skirts, bumpers, and even side mirrors.
In addition, you also learn invaluable tips and tricks, such as adding a buffer to the squeegee, cutting edges with precision, and utilising specialised tools like Knifeless Tape. These insights ensure you learn the techniques and adopt industry best practices.
By the end of this course, you will be a knowledgeable automotive detailing and automobile wrapping expert. With competence in handling every panel, corner, and logo, you will be confident in transforming any car from ordinary to eye-catching.
What are you waiting for? Dive deep into the vinyl wrapping course to unleash your imagination and let your creativity flow. Prepare to dazzle with your newly gained skills in automotive customising as you redefine vehicle aesthetics!
What you will learn from this Vehicle Wrapping Course

Fundamentals of vehicle care and washing techniques.
Car detailing and preparation processes for effective wrapping.
Proper usage of tools, including adding a buffer to the squeegee, cutting edges with precision, and utilising Knifeless Tape.
Wrapping techniques for various automotive parts, including the hood, fenders, doors, rear quarter panels, trunks, side skirts, bumpers, front bumper, and mirrors.
Removal and application techniques for various components, such as bumpers, headlights, door handles, emblems, and badges.
Inlay creation and its appropriate use in vinyl wrapping.
Tips for efficient material usage and cutting to save resources.
Entry Requirement
Anyone interested in learning more about this subject should take this Vehicle Wrapping Course. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject.
The course is open to students from any academic background, as there is no prerequisites to enrol on this course. The course materials are accessible from an internet enabled device at anytime of the day.
CPD Certificate from Course Gate
At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22.
Career path
The Vehicle Wrapping Course will help you to enhance your knowledge and skill in this sector. After accomplishing this course, you will enrich and improve yourself and brighten up your career in the relevant job market.

Course Curriculum

Vehicle Wrapping Course			
	Module 01: Vehicle Wash		00:04:00
	Module 02: Car Detailing & Preparation of the vehicle		00:05:00
	Module 03: How To Use The Squeegee		00:08:00
	Module 04: How To Vinyl Wrap A Hood With Air Vents		00:04:00
	Module 05: How To Remove Bumpers & Headlights		00:05:00
	Module 06: How To Vinyl Wrap A Fender		00:07:00
	Module 07: How To Cut The Vinyl Wrap Material For Each Panel To Save Material		00:05:00
	Module 08: How To Remove The Door Handles		00:08:00
	Module 09: How To Vinyl Wrap The Doors for Vehicle Wrapping		00:06:00
	Module 10: Door Handle Vinyl Wrap for Vehicle Wrapping		00:08:00
	Module 11: How To Wrap the Rear Quarter Panel for Vehicle Wrapping		00:08:00
	Module 12: How To Make an Inlay and When To Use an Inlay for Vehicle Wrapping		00:05:00
	Module 13: Trunk Vinyl Wrap for Vehicle Wrapping		00:07:00
	Module 14: Side Skirts Vinyl Wrap for Vehicle Wrapping		00:09:00
	Module 15: How to Remove the Roof Antenna for Vehicle Wrapping		00:10:00
	Module 16: How To Vinyl Wrap the Roof for Vehicle Wrapping		00:06:00
	Module 17: How To Vinyl Wrap The Rear Bumper for Vehicle Wrapping		00:08:00
	Module 18: How To Vinyl Wrap The Front Bumper for Vehicle Wrapping		00:10:00
	Module 19: Side Mirrors Vinyl Wrap for Vehicle Wrapping		00:11:00
	Module 20: How to install the Emblems the correct way		00:09:00
Certificate and Transcript			
	Order Your Certificates or Transcripts		00:00:00

Course Gate

Automotive

Automotive Technician

Car Maintenance

Automotive Engineering

Vehicle Wrapping

Trainers Course

Vehicle Wrapping Course

General Admission

Packt

Kali Linux

Python

Ethical Hacking

If you are a newbie in the field of ethical hacking or want to become an ethical hacker, this course is just what will get you started. This is a comprehensive course with real-world examples to help you understand the fundamentals of hacking and cyber security.

The Complete Ethical Hacking Course

<div>
						<div>
							<div>
							<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>Overview
</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>This comprehensive course on </span><b><span>SQL NoSQL Big Data and Hadoop</span></b> will deepen your understanding on this topic.</p><p><span><span>After successful completion of this course you can acquire the required skills in this sector. This </span><b>SQL NoSQL Big Data and Hadoop</b> comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market.</span></p><p><span><span>So enrol in this course today to fast track your career ladder.</span></span></p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
								</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>How will I get my certificate?</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>At the end of the course there will be an online written test, which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price.</span></p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Who is This course for?</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>There is no experience or previous qualifications required for enrolment on this </span><b><span>SQL NoSQL Big Data and Hadoop</span></b>. It is available to all students, of all academic backgrounds.</p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Requirements</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>Our </span><b><span>SQL NoSQL Big Data and Hadoop</span></b> is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G.</p><p><span><span>There is no time limit for completing this course, it can be studied in your own time at your own pace.</span></span></p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Career Path</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p>Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to-</p><ul><li>Open doors of opportunities</li><li>Increase your adaptability</li><li>Keep you relevant</li><li>Boost confidence</li></ul><p>And much more!</p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
						</div>
						</div>
					</div> <h3>Course Curriculum</h3><div><p>14 sections • 130 lectures • 22:34:00 total length</p></div><div><div><div><div><div><div><div><p>•Introduction: 00:07:00</p></div><div><div><p>•Building a Data-driven Organization - Introduction: 00:04:00</p></div><div><div><p>•Data Engineering: 00:06:00</p></div><div><div><p>•Learning Environment &amp; Course Material: 00:04:00</p></div><div><div><p>•Movielens Dataset: 00:03:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Introduction to Relational Databases: 00:09:00</p></div><div><div><p>•SQL: 00:05:00</p></div><div><div><p>•Movielens Relational Model: 00:15:00</p></div><div><div><p>•Movielens Relational Model: Normalization vs Denormalization: 00:16:00</p></div><div><div><p>•MySQL: 00:05:00</p></div><div><div><p>•Movielens in MySQL: Database import: 00:06:00</p></div><div><div><p>•OLTP in RDBMS: CRUD Applications: 00:17:00</p></div><div><div><p>•Indexes: 00:16:00</p></div><div><div><p>•Data Warehousing: 00:15:00</p></div><div><div><p>•Analytical Processing: 00:17:00</p></div><div><div><p>•Transaction Logs: 00:06:00</p></div><div><div><p>•Relational Databases  - Wrap Up: 00:03:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Distributed Databases: 00:07:00</p></div><div><div><p>•CAP Theorem: 00:10:00</p></div><div><div><p>•BASE: 00:07:00</p></div><div><div><p>•Other Classifications: 00:07:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Introduction to KV Stores: 00:02:00</p></div><div><div><p>•Redis: 00:04:00</p></div><div><div><p>•Install Redis: 00:07:00</p></div><div><div><p>•Time Complexity of Algorithm: 00:05:00</p></div><div><div><p>•Data Structures in Redis : Key &amp; String: 00:20:00</p></div><div><div><p>•Data Structures in Redis II : Hash &amp; List: 00:18:00</p></div><div><div><p>•Data structures in Redis III : Set &amp; Sorted Set: 00:21:00</p></div><div><div><p>•Data structures in Redis IV : Geo &amp; HyperLogLog: 00:11:00</p></div><div><div><p>•Data structures in Redis V : Pubsub &amp; Transaction: 00:08:00</p></div><div><div><p>•Modelling Movielens in Redis: 00:11:00</p></div><div><div><p>•Redis Example in Application: 00:29:00</p></div><div><div><p>•KV Stores: Wrap Up: 00:02:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Introduction to Document-Oriented Databases: 00:05:00</p></div><div><div><p>•MongoDB: 00:04:00</p></div><div><div><p>•MongoDB Installation: 00:02:00</p></div><div><div><p>•Movielens in MongoDB: 00:13:00</p></div><div><div><p>•Movielens in MongoDB: Normalization vs Denormalization: 00:11:00</p></div><div><div><p>•Movielens in MongoDB: Implementation: 00:10:00</p></div><div><div><p>•CRUD Operations in MongoDB: 00:13:00</p></div><div><div><p>•Indexes: 00:16:00</p></div><div><div><p>•MongoDB Aggregation Query - MapReduce function: 00:09:00</p></div><div><div><p>•MongoDB Aggregation Query - Aggregation Framework: 00:16:00</p></div><div><div><p>•Demo: MySQL vs MongoDB. Modeling with Spark: 00:02:00</p></div><div><div><p>•Document Stores: Wrap Up: 00:03:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Introduction to Search Engine Stores: 00:05:00</p></div><div><div><p>•Elasticsearch: 00:09:00</p></div><div><div><p>•Basic Terms Concepts and Description: 00:13:00</p></div><div><div><p>•Movielens in Elastisearch: 00:12:00</p></div><div><div><p>•CRUD in Elasticsearch: 00:15:00</p></div><div><div><p>•Search Queries in Elasticsearch: 00:23:00</p></div><div><div><p>•Aggregation Queries in Elasticsearch: 00:23:00</p></div><div><div><p>•The Elastic Stack (ELK): 00:12:00</p></div><div><div><p>•Use case: UFO Sighting in ElasticSearch: 00:29:00</p></div><div><div><p>•Search Engines: Wrap Up: 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Introduction to Columnar databases: 00:06:00</p></div><div><div><p>•HBase: 00:07:00</p></div><div><div><p>•HBase Architecture: 00:09:00</p></div><div><div><p>•HBase Installation: 00:09:00</p></div><div><div><p>•Apache Zookeeper: 00:06:00</p></div><div><div><p>•Movielens Data in HBase: 00:17:00</p></div><div><div><p>•Performing CRUD in HBase: 00:24:00</p></div><div><div><p>•SQL on HBase - Apache Phoenix: 00:14:00</p></div><div><div><p>•SQL on HBase - Apache Phoenix - Movielens: 00:10:00</p></div><div><div><p>•Demo : GeoLife GPS Trajectories: 00:02:00</p></div><div><div><p>•Wide Column Store: Wrap Up: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Introduction to Time Series: 00:09:00</p></div><div><div><p>•InfluxDB: 00:03:00</p></div><div><div><p>•InfluxDB Installation: 00:07:00</p></div><div><div><p>•InfluxDB Data Model: 00:07:00</p></div><div><div><p>•Data manipulation in InfluxDB: 00:17:00</p></div><div><div><p>•TICK Stack I: 00:12:00</p></div><div><div><p>•TICK Stack II: 00:23:00</p></div><div><div><p>•Time Series Databases: Wrap Up: 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Introduction to Graph Databases: 00:05:00</p></div><div><div><p>•Modelling in Graph: 00:14:00</p></div><div><div><p>•Modelling Movielens as a Graph: 00:10:00</p></div><div><div><p>•Neo4J: 00:04:00</p></div><div><div><p>•Neo4J installation: 00:08:00</p></div><div><div><p>•Cypher: 00:12:00</p></div><div><div><p>•Cypher II: 00:19:00</p></div><div><div><p>•Movielens in Neo4J: Data Import: 00:17:00</p></div><div><div><p>•Movielens in Neo4J: Spring Application: 00:12:00</p></div><div><div><p>•Data Analysis in Graph Databases: 00:05:00</p></div><div><div><p>•Examples of Graph Algorithms in Neo4J: 00:18:00</p></div><div><div><p>•Graph Databases: Wrap Up: 00:07:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Introduction to Big Data With Apache Hadoop: 00:06:00</p></div><div><div><p>•Big Data Storage in Hadoop (HDFS): 00:16:00</p></div><div><div><p>•Big Data Processing : YARN: 00:11:00</p></div><div><div><p>•Installation: 00:13:00</p></div><div><div><p>•Data Processing in Hadoop (MapReduce): 00:14:00</p></div><div><div><p>•Examples in MapReduce: 00:25:00</p></div><div><div><p>•Data Processing in Hadoop (Pig): 00:12:00</p></div><div><div><p>•Examples in Pig: 00:21:00</p></div><div><div><p>•Data Processing in Hadoop (Spark): 00:23:00</p></div><div><div><p>•Examples in Spark: 00:23:00</p></div><div><div><p>•Data Analytics with Apache Spark: 00:09:00</p></div><div><div><p>•Data Compression: 00:06:00</p></div><div><div><p>•Data serialization and storage formats: 00:20:00</p></div><div><div><p>•Hadoop: Wrap Up: 00:07:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Introduction Big Data SQL Engines: 00:03:00</p></div><div><div><p>•Apache Hive: 00:10:00</p></div><div><div><p>•Apache Hive : Demonstration: 00:20:00</p></div><div><div><p>•MPP SQL-on-Hadoop: Introduction: 00:03:00</p></div><div><div><p>•Impala: 00:06:00</p></div><div><div><p>•Impala : Demonstration: 00:18:00</p></div><div><div><p>•PrestoDB: 00:13:00</p></div><div><div><p>•PrestoDB : Demonstration: 00:14:00</p></div><div><div><p>•SQL-on-Hadoop: Wrap Up: 00:02:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Data Architectures: 00:05:00</p></div><div><div><p>•Introduction to Distributed Commit Logs: 00:07:00</p></div><div><div><p>•Apache Kafka: 00:03:00</p></div><div><div><p>•Confluent Platform Installation: 00:10:00</p></div><div><div><p>•Data Modeling in Kafka I: 00:13:00</p></div><div><div><p>•Data Modeling in Kafka II: 00:15:00</p></div><div><div><p>•Data Generation for Testing: 00:09:00</p></div><div><div><p>•Use case: Toll fee Collection: 00:04:00</p></div><div><div><p>•Stream processing: 00:11:00</p></div><div><div><p>•Stream Processing II with Stream + Connect APIs: 00:19:00</p></div><div><div><p>•Example: Kafka Streams: 00:15:00</p></div><div><div><p>•KSQL : Streaming Processing in SQL: 00:04:00</p></div><div><div><p>•KSQL: Example: 00:14:00</p></div><div><div><p>•Demonstration: NYC Taxi and Fares: 00:01:00</p></div><div><div><p>•Streaming: Wrap Up: 00:02:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Database Polyglot: 00:04:00</p></div><div><div><p>•Extending your knowledge: 00:08:00</p></div><div><div><p>•Data Visualization: 00:11:00</p></div><div><div><p>•Building a Data-driven Organization - Conclusion: 00:07:00</p></div><div><div><p>•Conclusion: 00:03:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Assignment -SQL NoSQL Big Data and Hadoop: 00:00:00</p></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>

Overview

This comprehensive course on SQL NoSQL Big Data and Hadoop will deepen your understanding on this topic.
After successful completion of this course you can acquire the required skills in this sector. This SQL NoSQL Big Data and Hadoop comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market.
So enrol in this course today to fast track your career ladder.
How will I get my certificate?
At the end of the course there will be an online written test, which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price.
Who is This course for?
There is no experience or previous qualifications required for enrolment on this SQL NoSQL Big Data and Hadoop. It is available to all students, of all academic backgrounds.
Requirements
Our SQL NoSQL Big Data and Hadoop is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G.
There is no time limit for completing this course, it can be studied in your own time at your own pace.
Career Path
Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to-
Open doors of opportunities
Increase your adaptability
Keep you relevant
Boost confidence
And much more!
Course Curriculum
14 sections • 130 lectures • 22:34:00 total length
•Introduction: 00:07:00
•Building a Data-driven Organization - Introduction: 00:04:00
•Data Engineering: 00:06:00
•Learning Environment & Course Material: 00:04:00
•Movielens Dataset: 00:03:00
•Introduction to Relational Databases: 00:09:00
•SQL: 00:05:00
•Movielens Relational Model: 00:15:00
•Movielens Relational Model: Normalization vs Denormalization: 00:16:00
•MySQL: 00:05:00
•Movielens in MySQL: Database import: 00:06:00
•OLTP in RDBMS: CRUD Applications: 00:17:00
•Indexes: 00:16:00
•Data Warehousing: 00:15:00
•Analytical Processing: 00:17:00
•Transaction Logs: 00:06:00
•Relational Databases - Wrap Up: 00:03:00
•Distributed Databases: 00:07:00
•CAP Theorem: 00:10:00
•BASE: 00:07:00
•Other Classifications: 00:07:00
•Introduction to KV Stores: 00:02:00
•Redis: 00:04:00
•Install Redis: 00:07:00
•Time Complexity of Algorithm: 00:05:00
•Data Structures in Redis : Key & String: 00:20:00
•Data Structures in Redis II : Hash & List: 00:18:00
•Data structures in Redis III : Set & Sorted Set: 00:21:00
•Data structures in Redis IV : Geo & HyperLogLog: 00:11:00
•Data structures in Redis V : Pubsub & Transaction: 00:08:00
•Modelling Movielens in Redis: 00:11:00
•Redis Example in Application: 00:29:00
•KV Stores: Wrap Up: 00:02:00
•Introduction to Document-Oriented Databases: 00:05:00
•MongoDB: 00:04:00
•MongoDB Installation: 00:02:00
•Movielens in MongoDB: 00:13:00
•Movielens in MongoDB: Normalization vs Denormalization: 00:11:00
•Movielens in MongoDB: Implementation: 00:10:00
•CRUD Operations in MongoDB: 00:13:00
•Indexes: 00:16:00
•MongoDB Aggregation Query - MapReduce function: 00:09:00
•MongoDB Aggregation Query - Aggregation Framework: 00:16:00
•Demo: MySQL vs MongoDB. Modeling with Spark: 00:02:00
•Document Stores: Wrap Up: 00:03:00
•Introduction to Search Engine Stores: 00:05:00
•Elasticsearch: 00:09:00
•Basic Terms Concepts and Description: 00:13:00
•Movielens in Elastisearch: 00:12:00
•CRUD in Elasticsearch: 00:15:00
•Search Queries in Elasticsearch: 00:23:00
•Aggregation Queries in Elasticsearch: 00:23:00
•The Elastic Stack (ELK): 00:12:00
•Use case: UFO Sighting in ElasticSearch: 00:29:00
•Search Engines: Wrap Up: 00:04:00
•Introduction to Columnar databases: 00:06:00
•HBase: 00:07:00
•HBase Architecture: 00:09:00
•HBase Installation: 00:09:00
•Apache Zookeeper: 00:06:00
•Movielens Data in HBase: 00:17:00
•Performing CRUD in HBase: 00:24:00
•SQL on HBase - Apache Phoenix: 00:14:00
•SQL on HBase - Apache Phoenix - Movielens: 00:10:00
•Demo : GeoLife GPS Trajectories: 00:02:00
•Wide Column Store: Wrap Up: 00:05:00
•Introduction to Time Series: 00:09:00
•InfluxDB: 00:03:00
•InfluxDB Installation: 00:07:00
•InfluxDB Data Model: 00:07:00
•Data manipulation in InfluxDB: 00:17:00
•TICK Stack I: 00:12:00
•TICK Stack II: 00:23:00
•Time Series Databases: Wrap Up: 00:04:00
•Introduction to Graph Databases: 00:05:00
•Modelling in Graph: 00:14:00
•Modelling Movielens as a Graph: 00:10:00
•Neo4J: 00:04:00
•Neo4J installation: 00:08:00
•Cypher: 00:12:00
•Cypher II: 00:19:00
•Movielens in Neo4J: Data Import: 00:17:00
•Movielens in Neo4J: Spring Application: 00:12:00
•Data Analysis in Graph Databases: 00:05:00
•Examples of Graph Algorithms in Neo4J: 00:18:00
•Graph Databases: Wrap Up: 00:07:00
•Introduction to Big Data With Apache Hadoop: 00:06:00
•Big Data Storage in Hadoop (HDFS): 00:16:00
•Big Data Processing : YARN: 00:11:00
•Installation: 00:13:00
•Data Processing in Hadoop (MapReduce): 00:14:00
•Examples in MapReduce: 00:25:00
•Data Processing in Hadoop (Pig): 00:12:00
•Examples in Pig: 00:21:00
•Data Processing in Hadoop (Spark): 00:23:00
•Examples in Spark: 00:23:00
•Data Analytics with Apache Spark: 00:09:00
•Data Compression: 00:06:00
•Data serialization and storage formats: 00:20:00
•Hadoop: Wrap Up: 00:07:00
•Introduction Big Data SQL Engines: 00:03:00
•Apache Hive: 00:10:00
•Apache Hive : Demonstration: 00:20:00
•MPP SQL-on-Hadoop: Introduction: 00:03:00
•Impala: 00:06:00
•Impala : Demonstration: 00:18:00
•PrestoDB: 00:13:00
•PrestoDB : Demonstration: 00:14:00
•SQL-on-Hadoop: Wrap Up: 00:02:00
•Data Architectures: 00:05:00
•Introduction to Distributed Commit Logs: 00:07:00
•Apache Kafka: 00:03:00
•Confluent Platform Installation: 00:10:00
•Data Modeling in Kafka I: 00:13:00
•Data Modeling in Kafka II: 00:15:00
•Data Generation for Testing: 00:09:00
•Use case: Toll fee Collection: 00:04:00
•Stream processing: 00:11:00
•Stream Processing II with Stream + Connect APIs: 00:19:00
•Example: Kafka Streams: 00:15:00
•KSQL : Streaming Processing in SQL: 00:04:00
•KSQL: Example: 00:14:00
•Demonstration: NYC Taxi and Fares: 00:01:00
•Streaming: Wrap Up: 00:02:00
•Database Polyglot: 00:04:00
•Extending your knowledge: 00:08:00
•Data Visualization: 00:11:00
•Building a Data-driven Organization - Conclusion: 00:07:00
•Conclusion: 00:03:00
•Assignment -SQL NoSQL Big Data and Hadoop: 00:00:00

Apex Learning

Computing Skills

Data Engineering

Hadoop

AWS Certified Database

Data Skills

SQL NoSQL Big Data and Hadoop

<strong>Create 3 useful desktop applications with web technologies using Electron</strong>
        <p>Be ready to get hands-on in this interactive project-based course designed to help you build and package cross-platform desktop applications using Electron. If you didn't already know, many popular apps such as VS Code, Slack, and Skype are built on Electron!
Throughout this course, you'll be building 3 apps -
&bull;	ImageShrink - An app to optimize images for websites
&bull;	SystTop - A real-time CPU monitor with notifications and system tray
&bull;	BugLogger - A CRUD app to track logs, which uses React and the MongoDB Atlas cloud database
In the first section of this course, you will start with an introduction to Electron and how it works. As you progress, you will start creating your first app- ImageShrink.  You will also learn how to create menus with custom items.
The next section will take you through the steps to create the interface, log files, and IPC communication. In addition to this, you will go on to build a menu template.
In later sections, you'll get up to speed with working through 2 more applications, SystTop and BugLogger. The course will also help you focus on how to work with Interval/Dynamic System Stats.
By the end of this course, you will be able to build desktop apps with Electron and even establish communication between processes with IPCMain and IPCRenderer.

All codes and supporting files are available at-
https://github.com/PacktPublishing/Electron-from-Scratch-Build-Desktop-Applications-with-JavaScript</p>
        <h2>What You Will Learn</h2><p>Become well-versed with how to use IPC to communicate between Main and Renderer Processes<br>Understand how to create and package 3 complete cross-platform applications<br>Delve into working with local data as well as the MongoDB Atlas database</p>
        <h2>Audience</h2><p>This course is designed for developers who are looking to build desktop apps with web technologies.</p>
        <h2>Approach</h2><p>This is a hands-on, project-based course for learning how to build and package cross-platform desktop applications using Electron. It is carefully structured and contains effective explanations and examples to help you learn easily.</p>
        <h2>Key Features</h2><p>Gain proficiency in building desktop applications with Electron * Understand how to use Vanilla JS and React with Electron * Create custom menu items, system tray apps, and more</p>
        <h2>Github Repo</h2><p>https://github.com/packtpublishing/electron-from-scratch-build-desktop-applications-with-javascript</p>
        <h2>About the Author</h2><h3>Brad Traversy</h3><p>Brad Traversy has been programming for around 12 years and teaching for almost 5 years. He is the owner of Traversy Media, which is a successful web development YouTube channel and specializes in everything from HTML5 to front-end frameworks such as Angular as well as server-side technologies such as Node.js, PHP, and Python. Brad has mastered explaining overly complex topics in a simple manner that is understandable. Invest in your knowledge by watching Brad's courses.</p>
        <h2>Course Outline</h2><h4>1. Introduction</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Welcome To The Course</p><p style='margin: 0'>Introduction: Welcome To The Course</p></td></tr><tr><td style='padding: 15px;'><p>2. Electron: What & Why?</p><p style='margin: 0'>Introduction: Electron: What & Why?</p></td></tr><tr><td style='padding: 15px;'><p>3. How electron works</p><p style='margin: 0'>Introduction: How electron works</p></td></tr><tr><td style='padding: 15px;'><p>4. Environment & Code Repo</p><p style='margin: 0'>Introduction: Environment & Code Repo</p></td></tr></tbody></table><br><h4>2. Starting Project 1 - ImageShrink App</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Project Intro</p><p style='margin: 0'>Starting Project 1 - ImageShrink App: Project Intro</p></td></tr><tr><td style='padding: 15px;'><p>2. Setup & BrowserWindow</p><p style='margin: 0'>Starting Project 1 - ImageShrink App: Setup & BrowserWindow</p></td></tr><tr><td style='padding: 15px;'><p>3. Loading a Window File & Adding an Icon</p><p style='margin: 0'>Starting Project 1 - ImageShrink App: Loading a Window File & Adding an Icon</p></td></tr><tr><td style='padding: 15px;'><p>4. Environment & Platform Check</p><p style='margin: 0'>Starting Project 1 - ImageShrink App: Environment & Platform Check</p></td></tr><tr><td style='padding: 15px;'><p>5. Using Nodemon With Electron</p><p style='margin: 0'>Starting Project 1 - ImageShrink App: Using Nodemon With Electron</p></td></tr></tbody></table><br><h4>3. Working with the menu</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Creating a Menu Template</p><p style='margin: 0'>Working with the menu: Creating a Menu Template</p></td></tr><tr><td style='padding: 15px;'><p>2. Menu & Global Shortcuts</p><p style='margin: 0'>Working with the menu: Menu & Global Shortcuts</p></td></tr><tr><td style='padding: 15px;'><p>3. Menu Roles</p><p style='margin: 0'>Working with the menu: Menu Roles</p></td></tr><tr><td style='padding: 15px;'><p>4. Open Window From Menu</p><p style='margin: 0'>Working with the menu: Open Window From Menu</p></td></tr></tbody></table><br><h4>4. Interface, IPC, ImageMin & Packaging</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Creating The Interface</p><p style='margin: 0'>Interface, IPC, ImageMin & Packaging: Creating The Interface</p></td></tr><tr><td style='padding: 15px;'><p>2. Renderer Node Integration</p><p style='margin: 0'>Interface, IPC, ImageMin & Packaging: Renderer Node Integration</p></td></tr><tr><td style='padding: 15px;'><p>3. IPC Communication</p><p style='margin: 0'>Interface, IPC, ImageMin & Packaging: IPC Communication</p></td></tr><tr><td style='padding: 15px;'><p>4. Implementing Imagemin & Plugins</p><p style='margin: 0'>Interface, IPC, ImageMin & Packaging: Implementing Imagemin & Plugins</p></td></tr><tr><td style='padding: 15px;'><p>5. Send Events To Renderer</p><p style='margin: 0'>Interface, IPC, ImageMin & Packaging: Send Events To Renderer</p></td></tr><tr><td style='padding: 15px;'><p>6. Creating Log Files</p><p style='margin: 0'>Interface, IPC, ImageMin & Packaging: Creating Log Files</p></td></tr><tr><td style='padding: 15px;'><p>7. Package & Test Our App</p><p style='margin: 0'>Interface, IPC, ImageMin & Packaging: Package & Test Our App</p></td></tr></tbody></table><br><h4>5. Project 2 - SysTop App</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Project Intro</p><p style='margin: 0'>Project 2 - SysTop App: Project Intro</p></td></tr><tr><td style='padding: 15px;'><p>2. Boilerplate Setup</p><p style='margin: 0'>Project 2 - SysTop App: Boilerplate Setup</p></td></tr><tr><td style='padding: 15px;'><p>3. Template Assets Setup</p><p style='margin: 0'>Project 2 - SysTop App: Template Assets Setup</p></td></tr><tr><td style='padding: 15px;'><p>4. Creating The Interface</p><p style='margin: 0'>Project 2 - SysTop App: Creating The Interface</p></td></tr></tbody></table><br><h4>6. System Stats & Renderer Process</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Static System Stats</p><p style='margin: 0'>System Stats & Renderer Process: Static System Stats</p></td></tr><tr><td style='padding: 15px;'><p>2. Interval/Dynamic System Stats</p><p style='margin: 0'>System Stats & Renderer Process: Interval/Dynamic System Stats</p></td></tr><tr><td style='padding: 15px;'><p>3. Progress Bar & CPU Overload</p><p style='margin: 0'>System Stats & Renderer Process: Progress Bar & CPU Overload</p></td></tr><tr><td style='padding: 15px;'><p>4. Notifications API</p><p style='margin: 0'>System Stats & Renderer Process: Notifications API</p></td></tr><tr><td style='padding: 15px;'><p>5. Notification Timing</p><p style='margin: 0'>System Stats & Renderer Process: Notification Timing</p></td></tr></tbody></table><br><h4>7. Storing local data</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Creating a Store</p><p style='margin: 0'>Storing local data: Creating a Store</p></td></tr><tr><td style='padding: 15px;'><p>2. Set Default Settings To Renderer</p><p style='margin: 0'>Storing local data: Set Default Settings To Renderer</p></td></tr><tr><td style='padding: 15px;'><p>3. Saving Data To Our Store/File</p><p style='margin: 0'>Storing local data: Saving Data To Our Store/File</p></td></tr><tr><td style='padding: 15px;'><p>4. Use Settings Data In Monitor</p><p style='margin: 0'>Storing local data: Use Settings Data In Monitor</p></td></tr></tbody></table><br><h4>8. Tray Icon & Wrap Up</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Creating a Tray Icon</p><p style='margin: 0'>Tray Icon & Wrap Up: Creating a Tray Icon</p></td></tr><tr><td style='padding: 15px;'><p>2. Tray Context Menu</p><p style='margin: 0'>Tray Icon & Wrap Up: Tray Context Menu</p></td></tr><tr><td style='padding: 15px;'><p>3. Nav Toggle Menu Item</p><p style='margin: 0'>Tray Icon & Wrap Up: Nav Toggle Menu Item</p></td></tr><tr><td style='padding: 15px;'><p>4. MainWindow Class</p><p style='margin: 0'>Tray Icon & Wrap Up: MainWindow Class</p></td></tr><tr><td style='padding: 15px;'><p>5. AppTray Class</p><p style='margin: 0'>Tray Icon & Wrap Up: AppTray Class</p></td></tr><tr><td style='padding: 15px;'><p>6. Package & Test Our App</p><p style='margin: 0'>Tray Icon & Wrap Up: Package & Test Our App</p></td></tr></tbody></table><br><h4>9. Project 3 - BugLogger App & Creating The React UI</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Project Intro</p><p style='margin: 0'>Project 3 - BugLogger App & Creating The React UI: Project Intro</p></td></tr><tr><td style='padding: 15px;'><p>2. React-Electron Boilerplate Setup</p><p style='margin: 0'>Project 3 - BugLogger App & Creating The React UI: React-Electron Boilerplate Setup</p></td></tr><tr><td style='padding: 15px;'><p>3. Log State & Table</p><p style='margin: 0'>Project 3 - BugLogger App & Creating The React UI: Log State & Table</p></td></tr><tr><td style='padding: 15px;'><p>4. LogItem Component</p><p style='margin: 0'>Project 3 - BugLogger App & Creating The React UI: LogItem Component</p></td></tr><tr><td style='padding: 15px;'><p>5. Formatting Dates With Moment</p><p style='margin: 0'>Project 3 - BugLogger App & Creating The React UI: Formatting Dates With Moment</p></td></tr><tr><td style='padding: 15px;'><p>6. AddLogItem Component</p><p style='margin: 0'>Project 3 - BugLogger App & Creating The React UI: AddLogItem Component</p></td></tr><tr><td style='padding: 15px;'><p>7. Adding a Log (UI Only)</p><p style='margin: 0'>Project 3 - BugLogger App & Creating The React UI: Adding a Log (UI Only)</p></td></tr><tr><td style='padding: 15px;'><p>8. Displaying Alerts</p><p style='margin: 0'>Project 3 - BugLogger App & Creating The React UI: Displaying Alerts</p></td></tr><tr><td style='padding: 15px;'><p>9. Deleting a Log (UI Only)</p><p style='margin: 0'>Project 3 - BugLogger App & Creating The React UI: Deleting a Log (UI Only)</p></td></tr></tbody></table><br><h4>10. Main Process, IPC & MongoDB</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Setup MongoDB Atlas</p><p style='margin: 0'>Main Process, IPC & MongoDB: Setup MongoDB Atlas</p></td></tr><tr><td style='padding: 15px;'><p>2. Connect To Database With Mongoose</p><p style='margin: 0'>Main Process, IPC & MongoDB: Connect To Database With Mongoose</p></td></tr><tr><td style='padding: 15px;'><p>3. Create Log Model</p><p style='margin: 0'>Main Process, IPC & MongoDB: Create Log Model</p></td></tr><tr><td style='padding: 15px;'><p>4. Get Logs From Database</p><p style='margin: 0'>Main Process, IPC & MongoDB: Get Logs From Database</p></td></tr><tr><td style='padding: 15px;'><p>5. Add Log To Database</p><p style='margin: 0'>Main Process, IPC & MongoDB: Add Log To Database</p></td></tr><tr><td style='padding: 15px;'><p>6. Delete Logs From Database</p><p style='margin: 0'>Main Process, IPC & MongoDB: Delete Logs From Database</p></td></tr><tr><td style='padding: 15px;'><p>7. Clear Logs Menu Item</p><p style='margin: 0'>Main Process, IPC & MongoDB: Clear Logs Menu Item</p></td></tr><tr><td style='padding: 15px;'><p>8. Package & Test Our App</p><p style='margin: 0'>Main Process, IPC & MongoDB: Package & Test Our App</p></td></tr><tr><td style='padding: 15px;'><p>9. Custom Icon</p><p style='margin: 0'>Main Process, IPC & MongoDB: Custom Icon</p></td></tr></tbody></table>

Create 3 useful desktop applications with web technologies using Electron
Be ready to get hands-on in this interactive project-based course designed to help you build and package cross-platform desktop applications using Electron. If you didn't already know, many popular apps such as VS Code, Slack, and Skype are built on Electron!
Throughout this course, you'll be building 3 apps -
•	ImageShrink - An app to optimize images for websites
•	SystTop - A real-time CPU monitor with notifications and system tray
•	BugLogger - A CRUD app to track logs, which uses React and the MongoDB Atlas cloud database
In the first section of this course, you will start with an introduction to Electron and how it works. As you progress, you will start creating your first app- ImageShrink. You will also learn how to create menus with custom items.
The next section will take you through the steps to create the interface, log files, and IPC communication. In addition to this, you will go on to build a menu template.
In later sections, you'll get up to speed with working through 2 more applications, SystTop and BugLogger. The course will also help you focus on how to work with Interval/Dynamic System Stats.
By the end of this course, you will be able to build desktop apps with Electron and even establish communication between processes with IPCMain and IPCRenderer. All codes and supporting files are available at-
https://github.com/PacktPublishing/Electron-from-Scratch-Build-Desktop-Applications-with-JavaScript
What You Will Learn
Become well-versed with how to use IPC to communicate between Main and Renderer Processes
Understand how to create and package 3 complete cross-platform applications
Delve into working with local data as well as the MongoDB Atlas database
Audience
This course is designed for developers who are looking to build desktop apps with web technologies.
Approach
This is a hands-on, project-based course for learning how to build and package cross-platform desktop applications using Electron. It is carefully structured and contains effective explanations and examples to help you learn easily.
Key Features
Gain proficiency in building desktop applications with Electron * Understand how to use Vanilla JS and React with Electron * Create custom menu items, system tray apps, and more
Github Repo
https://github.com/packtpublishing/electron-from-scratch-build-desktop-applications-with-javascript
About the Author
Brad Traversy
Brad Traversy has been programming for around 12 years and teaching for almost 5 years. He is the owner of Traversy Media, which is a successful web development YouTube channel and specializes in everything from HTML5 to front-end frameworks such as Angular as well as server-side technologies such as Node.js, PHP, and Python. Brad has mastered explaining overly complex topics in a simple manner that is understandable. Invest in your knowledge by watching Brad's courses.
Course Outline
1. Introduction

1. Welcome To The Course
Introduction: Welcome To The Course
2. Electron: What & Why?
Introduction: Electron: What & Why?
3. How electron works
Introduction: How electron works
4. Environment & Code Repo
Introduction: Environment & Code Repo
2. Starting Project 1 - ImageShrink App

1. Project Intro
Starting Project 1 - ImageShrink App: Project Intro
2. Setup & BrowserWindow
Starting Project 1 - ImageShrink App: Setup & BrowserWindow
3. Loading a Window File & Adding an Icon
Starting Project 1 - ImageShrink App: Loading a Window File & Adding an Icon
4. Environment & Platform Check
Starting Project 1 - ImageShrink App: Environment & Platform Check
5. Using Nodemon With Electron
Starting Project 1 - ImageShrink App: Using Nodemon With Electron
3. Working with the menu

1. Creating a Menu Template
Working with the menu: Creating a Menu Template
2. Menu & Global Shortcuts
Working with the menu: Menu & Global Shortcuts
3. Menu Roles
Working with the menu: Menu Roles
4. Open Window From Menu
Working with the menu: Open Window From Menu
4. Interface, IPC, ImageMin & Packaging

1. Creating The Interface
Interface, IPC, ImageMin & Packaging: Creating The Interface
2. Renderer Node Integration
Interface, IPC, ImageMin & Packaging: Renderer Node Integration
3. IPC Communication
Interface, IPC, ImageMin & Packaging: IPC Communication
4. Implementing Imagemin & Plugins
Interface, IPC, ImageMin & Packaging: Implementing Imagemin & Plugins
5. Send Events To Renderer
Interface, IPC, ImageMin & Packaging: Send Events To Renderer
6. Creating Log Files
Interface, IPC, ImageMin & Packaging: Creating Log Files
7. Package & Test Our App
Interface, IPC, ImageMin & Packaging: Package & Test Our App
5. Project 2 - SysTop App

1. Project Intro
Project 2 - SysTop App: Project Intro
2. Boilerplate Setup
Project 2 - SysTop App: Boilerplate Setup
3. Template Assets Setup
Project 2 - SysTop App: Template Assets Setup
4. Creating The Interface
Project 2 - SysTop App: Creating The Interface
6. System Stats & Renderer Process

1. Static System Stats
System Stats & Renderer Process: Static System Stats
2. Interval/Dynamic System Stats
System Stats & Renderer Process: Interval/Dynamic System Stats
3. Progress Bar & CPU Overload
System Stats & Renderer Process: Progress Bar & CPU Overload
4. Notifications API
System Stats & Renderer Process: Notifications API
5. Notification Timing
System Stats & Renderer Process: Notification Timing
7. Storing local data

1. Creating a Store
Storing local data: Creating a Store
2. Set Default Settings To Renderer
Storing local data: Set Default Settings To Renderer
3. Saving Data To Our Store/File
Storing local data: Saving Data To Our Store/File
4. Use Settings Data In Monitor
Storing local data: Use Settings Data In Monitor
8. Tray Icon & Wrap Up

1. Creating a Tray Icon
Tray Icon & Wrap Up: Creating a Tray Icon
2. Tray Context Menu
Tray Icon & Wrap Up: Tray Context Menu
3. Nav Toggle Menu Item
Tray Icon & Wrap Up: Nav Toggle Menu Item
4. MainWindow Class
Tray Icon & Wrap Up: MainWindow Class
5. AppTray Class
Tray Icon & Wrap Up: AppTray Class
6. Package & Test Our App
Tray Icon & Wrap Up: Package & Test Our App
9. Project 3 - BugLogger App & Creating The React UI

1. Project Intro
Project 3 - BugLogger App & Creating The React UI: Project Intro
2. React-Electron Boilerplate Setup
Project 3 - BugLogger App & Creating The React UI: React-Electron Boilerplate Setup
3. Log State & Table
Project 3 - BugLogger App & Creating The React UI: Log State & Table
4. LogItem Component
Project 3 - BugLogger App & Creating The React UI: LogItem Component
5. Formatting Dates With Moment
Project 3 - BugLogger App & Creating The React UI: Formatting Dates With Moment
6. AddLogItem Component
Project 3 - BugLogger App & Creating The React UI: AddLogItem Component
7. Adding a Log (UI Only)
Project 3 - BugLogger App & Creating The React UI: Adding a Log (UI Only)
8. Displaying Alerts
Project 3 - BugLogger App & Creating The React UI: Displaying Alerts
9. Deleting a Log (UI Only)
Project 3 - BugLogger App & Creating The React UI: Deleting a Log (UI Only)
10. Main Process, IPC & MongoDB

1. Setup MongoDB Atlas
Main Process, IPC & MongoDB: Setup MongoDB Atlas
2. Connect To Database With Mongoose
Main Process, IPC & MongoDB: Connect To Database With Mongoose
3. Create Log Model
Main Process, IPC & MongoDB: Create Log Model
4. Get Logs From Database
Main Process, IPC & MongoDB: Get Logs From Database
5. Add Log To Database
Main Process, IPC & MongoDB: Add Log To Database
6. Delete Logs From Database
Main Process, IPC & MongoDB: Delete Logs From Database
7. Clear Logs Menu Item
Main Process, IPC & MongoDB: Clear Logs Menu Item
8. Package & Test Our App
Main Process, IPC & MongoDB: Package & Test Our App
9. Custom Icon
Main Process, IPC & MongoDB: Custom Icon

JavaScript

Programming

Create 3 useful desktop applications with web technologies using Electron

Electron from Scratch: Build Desktop Applications with JavaScript

<h4 style="color: rgb(51, 51, 51); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(51, 51, 51);">Learn the&nbsp;<em style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;"><strong style="color: inherit; font-weight: 700; box-sizing: border-box;" fr-original-style=" color: inherit;">Essentials of Gift Wrapping</strong></em>&nbsp;&amp; have some fun with your team this festive season</h4><p style="color: rgb(51, 51, 51); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);">&nbsp;<strong style="color: inherit; font-weight: 700; box-sizing: border-box;" fr-original-style=" color: inherit;">What&rsquo;s included (and how it will help):</strong></p><div style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);"><ul style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;"><li style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;"><span style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;">Step by step tuition covering all the&nbsp;</span><b fr-original-style="" style="box-sizing: border-box;">Essential Techniques</b><span style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;">&nbsp;of gift wrapping so they never need to grab a gift/bottle bag again&nbsp;</span></li><li style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;"><span style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;">Practical guidance on tying different styles of&nbsp;</span><b fr-original-style="" style="box-sizing: border-box;">Ribbon Bow&nbsp;</b><span style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;">so they can confidently use them on any gift (and when it&rsquo;s best to use each one)&nbsp;</span></li><li style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;"><span style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;">Learn&nbsp;</span><b fr-original-style="" style="box-sizing: border-box;">Pro tips</b><span style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;">&nbsp;so you feel less overwhelmed &amp; can gift wrap quickly at busy times&nbsp;</span></li></ul><p style="color: inherit !important; font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: inherit !important;"><b fr-original-style="" style="box-sizing: border-box;">Plus</b><span style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;">&nbsp;all materials are provided</span></p><p style="color: inherit !important; font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: inherit !important;"><span style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;">A class is a great opportunity for team building/bonding so that people get to know each other outside of a work setting and/or meet people in person.</span><span style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;"></span></p><p style="color: inherit !important; font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: inherit !important;"><span style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;">It&rsquo;s an inclusive alternative to a Christmas party (boozy meals/discos aren&rsquo;t for everyone) and everyone gets to take away a gift at the end of the class.</span></p><p style="color: inherit !important; font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: inherit !important;"><span style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;"></span><span style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;">Packages start from &pound;597 for groups of up to 10 people. &nbsp;Dates &amp; times can be booked to suit.</span></p><p style="color: inherit !important; font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: inherit !important;"><span style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;">Book a call below to discuss your requirements.</span></p></div>

Learn the Essentials of Gift Wrapping & have some fun with your team this festive season
 What’s included (and how it will help):
Step by step tuition covering all the Essential Techniques of gift wrapping so they never need to grab a gift/bottle bag again
Practical guidance on tying different styles of Ribbon Bow so they can confidently use them on any gift (and when it’s best to use each one)
Learn Pro tips so you feel less overwhelmed & can gift wrap quickly at busy times
Plus all materials are provided
A class is a great opportunity for team building/bonding so that people get to know each other outside of a work setting and/or meet people in person.
It’s an inclusive alternative to a Christmas party (boozy meals/discos aren’t for everyone) and everyone gets to take away a gift at the end of the class.
Packages start from £597 for groups of up to 10 people. Dates & times can be booked to suit.
Book a call below to discuss your requirements.

Gift Wrapping Class for teams

Groups of 10

<p><strong>48-Hour Knowledge Knockdown! Prices Reduced Like Never Before!</strong></p><p>Are you ready to embark on a journey of scientific discovery? The Organic Chemistry Diploma bundle is your passport to unlocking the secrets of the chemical world. Let these courses transport you to the very heart of organic chemistry, biochemistry, genetics, and more.</p><p>With a QLS-endorsed Organic Chemistry course as the star of the show, you'll receive a hardcopy certificate upon completion - a symbol of your dedication to the scientific field. And the best part? This is just the beginning. You'll have access to ten other courses, all of which are CPD-QS accredited, each offering a unique perspective on the fascinating world of organic chemistry.</p><p>From mastering the fundamentals of microbiology to understanding the intricacies of biomedical science, this bundle offers something for everyone. Discover the chemical building blocks of life, explore the secrets of genetics, and learn how to keep yourself and your lab safe with courses like Chemical Spill and Infection Prevention &amp; Control Training. And with remote teaching strategies and lesson planning for teaching, you'll even learn how to pass on your newfound knowledge to others.</p><p>So what are you waiting for? Dive into the world of organic chemistry with this exceptional bundle and join the ranks of the world's top chemists. The future is yours to discover!</p><p><strong>This </strong><strong>Organic Chemistry Diploma</strong><strong> Bundle Package includes:</strong></p><ul><li><strong>Course 01:</strong> Advanced Diploma in Organic Chemistry at QLS Level 7</li></ul><p><strong>10 Premium Additional CPD QS Accredited Courses -</strong></p><ul><li><strong>Course 01: </strong>Biomedical Science</li><li><strong>Course 02: </strong>Biochemistry</li><li><strong>Course 03: </strong>Lab Analyst Training</li><li><strong>Course 04: </strong>Chemical Spill</li><li><strong>Course 05: </strong>Microbiology Laboratory Technician</li><li><strong>Course 06: </strong>Chemistry for Everyone</li><li><strong>Course 07: </strong>Genetics</li><li><strong>Course 08: </strong>Infection Prevention &amp; Control Training</li><li><strong>Course 09: </strong>Remote Teaching Strategies</li><li><strong>Course 10:</strong> Lesson Planning for Teaching</li></ul><p><strong>Why Prefer This </strong><strong>Organic Chemistry Diploma</strong><strong> Bundle?</strong></p><ul><li>You will receive a completely free certificate from the Quality Licence Scheme</li><li>Option to purchase 10 additional certificates accredited by CPD</li><li>Get a free Student ID Card - (£10 postal charges will be applicable for international delivery)</li><li>Free assessments and immediate success results</li><li>24/7 Tutor Support</li></ul> <p><strong>After taking this </strong><strong>Organic Chemistry Diploma</strong><strong> bundle courses, you will be able to learn:</strong></p><ul><li>Develop a thorough understanding of organic chemistry, biochemistry, genetics, and more.</li><li>Master the fundamentals of microbiology and learn how to keep yourself and your lab safe.</li><li>Explore the chemical building blocks of life and discover the secrets of biomedical science.</li><li>Learn to plan and execute chemical experiments with confidence.</li><li>Develop critical thinking skills and the ability to analyse complex scientific data.</li><li>Learn how to teach others about the world of organic chemistry.</li><li>Gain a valuable QLS-endorsed certificate to enhance your CV.</li></ul><p><strong>***Curriculum breakdown of Organic Chemistry</strong><strong>***</strong></p><p><strong>Section 01: Alkane series</strong></p><ul><li>Introduction to the Alkane Series</li><li>Conjugation and Homologous Series of the Alkane</li><li>Nomenclature of the Alkane Series</li><li>Chemistry of the Alkane Series</li><li>Relevance and Importance of the Alkene Family</li><li>Section Wrap Up</li></ul><p><strong>Section 02: Alkene Series</strong></p><ul><li>Introduction to the Alkene series</li><li>Nomenclature of the Alkene Series</li><li>Chemistry of the Alkene Series</li><li>Relevance and Importance of the Alkene Family</li><li>Section Wrap Up</li></ul><p><strong>Section 03: Alkanol Series</strong></p><ul><li>Introduction to the Alkanol Series</li><li>Nomenclature of the Alkanol Series</li><li>Chemistry of the Alkanol Series</li><li>Relevance and Importance of the Alkanol Family</li><li>Section Wrap Up</li></ul><p><strong>Section 04: Alkyne series</strong></p><ul><li>Introduction to the Alkyne Series</li><li>Nomenclature of the Alkyne Series</li><li>Chemistry of the Alkene Series</li><li>Importance and Relevance of the Alkene Family</li><li>Section Wrap Up</li></ul><p><strong>Section 05: Alkanals and Aldehydes</strong></p><ul><li>Introduction to the Alkanals/Aldehydes and Ketones/Alkanones Family</li></ul><p><strong>How is the </strong><strong>Organic Chemistry Diploma </strong><strong>Bundle Assessment Process?</strong></p><p>You have to complete the assignment questions given at the end of the course and score a minimum of 60% to pass each exam. Our expert trainers will assess your assignment and give you feedback after you submit the assignment.</p><p>You will be entitled to claim a certificate endorsed by the Quality Licence Scheme after you successfully pass the exams.</p> <h2>
        
        <div>CPD</div>
    </h2>

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

                        <div id="who_is_this_course_for">
                            <p>This bundle of courses is ideal for:</p><ul><li>Students who want to pursue a career in the scientific field.</li><li>Professionals who wish to expand their knowledge of organic chemistry.</li><li>Teachers who want to enhance their teaching skills in the scientific field.</li><li>Anyone interested in gaining a deeper understanding of the chemical world.</li></ul>
                        </div> <h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>This bundle will be beneficial for anyone looking to pursue a career as:</p><ul><li>Laboratory Analyst: £20,000 - £35,000 per annum.</li><li>Microbiologist: £25,000 - £40,000 per annum.</li><li>Biomedical Scientist: £24,000 - £43,000 per annum.</li><li>Chemical Engineer: £30,000 - £60,000 per annum.</li><li>Genetics Counselor: £24,000 - £70,000 per annum.</li><li>Science Teacher: £25,000 - £45,000 per annum.</li></ul>
                        </div> <h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Advanced Diploma in Organic Chemistry at QLS Level 7</h4>
        <p>
            Hard copy certificate -
            Included
        </p>
            <div> <p>After successfully completing thecourse, you can order an original hardcopy Certificate of Achievement endorsed by the <strong>Quality Licence Scheme</strong>. This certificate will be delivered to your home, free of charge.</p><p>To obtain the additional Quality Licence Scheme Endorsed Certificate, you will need to pay the corresponding fee based on the level of the courses:</p><ul><li>Level 1: £59</li><li>Level 2: £79</li><li>Level 3: £89</li><li>Level 4: £99</li><li>Level 5: £119</li><li>Level 6: £129</li><li>Level 7: £139</li></ul> </div>
        <h4>CPD QS Accredited Certificate</h4>
        <p>
            Digital certificate -
            £10
        </p>
            <div> <p>Upon successfully completing the Bundle, you will need to place an order to receive a PDF Certificate for each course within the bundle. These certificates serve as proof of your newly acquired skills, accredited by CPD QS and will cost you £10 for each course. Also, the certificates are recognised throughout the UK and internationally.</p> </div>
        <h4>CPD QS Accredited Certificate</h4>
        <p>
            Hard copy certificate -
            £29
        </p>
            <div> <p>International students are subject to a £10 delivery fee for their orders, based on their location.</p> </div>

                        </div>

48-Hour Knowledge Knockdown! Prices Reduced Like Never Before!
Are you ready to embark on a journey of scientific discovery? The Organic Chemistry Diploma bundle is your passport to unlocking the secrets of the chemical world. Let these courses transport you to the very heart of organic chemistry, biochemistry, genetics, and more.
With a QLS-endorsed Organic Chemistry course as the star of the show, you'll receive a hardcopy certificate upon completion - a symbol of your dedication to the scientific field. And the best part? This is just the beginning. You'll have access to ten other courses, all of which are CPD-QS accredited, each offering a unique perspective on the fascinating world of organic chemistry.
From mastering the fundamentals of microbiology to understanding the intricacies of biomedical science, this bundle offers something for everyone. Discover the chemical building blocks of life, explore the secrets of genetics, and learn how to keep yourself and your lab safe with courses like Chemical Spill and Infection Prevention & Control Training. And with remote teaching strategies and lesson planning for teaching, you'll even learn how to pass on your newfound knowledge to others.
So what are you waiting for? Dive into the world of organic chemistry with this exceptional bundle and join the ranks of the world's top chemists. The future is yours to discover!
This Organic Chemistry Diploma Bundle Package includes:
Course 01: Advanced Diploma in Organic Chemistry at QLS Level 7
10 Premium Additional CPD QS Accredited Courses -
Course 01: Biomedical Science
Course 02: Biochemistry
Course 03: Lab Analyst Training
Course 04: Chemical Spill
Course 05: Microbiology Laboratory Technician
Course 06: Chemistry for Everyone
Course 07: Genetics
Course 08: Infection Prevention & Control Training
Course 09: Remote Teaching Strategies
Course 10: Lesson Planning for Teaching
Why Prefer This Organic Chemistry Diploma Bundle?
You will receive a completely free certificate from the Quality Licence Scheme
Option to purchase 10 additional certificates accredited by CPD
Get a free Student ID Card - (£10 postal charges will be applicable for international delivery)
Free assessments and immediate success results
24/7 Tutor Support
After taking this Organic Chemistry Diploma bundle courses, you will be able to learn:
Develop a thorough understanding of organic chemistry, biochemistry, genetics, and more.
Master the fundamentals of microbiology and learn how to keep yourself and your lab safe.
Explore the chemical building blocks of life and discover the secrets of biomedical science.
Learn to plan and execute chemical experiments with confidence.
Develop critical thinking skills and the ability to analyse complex scientific data.
Learn how to teach others about the world of organic chemistry.
Gain a valuable QLS-endorsed certificate to enhance your CV.
***Curriculum breakdown of Organic Chemistry***
Section 01: Alkane series
Introduction to the Alkane Series
Conjugation and Homologous Series of the Alkane
Nomenclature of the Alkane Series
Chemistry of the Alkane Series
Relevance and Importance of the Alkene Family
Section Wrap Up
Section 02: Alkene Series
Introduction to the Alkene series
Nomenclature of the Alkene Series
Chemistry of the Alkene Series
Relevance and Importance of the Alkene Family
Section Wrap Up
Section 03: Alkanol Series
Introduction to the Alkanol Series
Nomenclature of the Alkanol Series
Chemistry of the Alkanol Series
Relevance and Importance of the Alkanol Family
Section Wrap Up
Section 04: Alkyne series
Introduction to the Alkyne Series
Nomenclature of the Alkyne Series
Chemistry of the Alkene Series
Importance and Relevance of the Alkene Family
Section Wrap Up
Section 05: Alkanals and Aldehydes
Introduction to the Alkanals/Aldehydes and Ketones/Alkanones Family
How is the Organic Chemistry Diploma Bundle Assessment Process?
You have to complete the assignment questions given at the end of the course and score a minimum of 60% to pass each exam. Our expert trainers will assess your assignment and give you feedback after you submit the assignment.
You will be entitled to claim a certificate endorsed by the Quality Licence Scheme after you successfully pass the exams.
 CPD 
280 CPD hours / points  Accredited by CPD Quality Standards
 Who is this course for? 
This bundle of courses is ideal for:
Students who want to pursue a career in the scientific field.
Professionals who wish to expand their knowledge of organic chemistry.
Teachers who want to enhance their teaching skills in the scientific field.
Anyone interested in gaining a deeper understanding of the chemical world.
 Career path 
This bundle will be beneficial for anyone looking to pursue a career as:
Laboratory Analyst: £20,000 - £35,000 per annum.
Microbiologist: £25,000 - £40,000 per annum.
Biomedical Scientist: £24,000 - £43,000 per annum.
Chemical Engineer: £30,000 - £60,000 per annum.
Genetics Counselor: £24,000 - £70,000 per annum.
Science Teacher: £25,000 - £45,000 per annum.
 Certificates 
Advanced Diploma in Organic Chemistry at QLS Level 7
 Hard copy certificate - Included 
After successfully completing thecourse, you can order an original hardcopy Certificate of Achievement endorsed by the Quality Licence Scheme. This certificate will be delivered to your home, free of charge.
To obtain the additional Quality Licence Scheme Endorsed Certificate, you will need to pay the corresponding fee based on the level of the courses:
Level 1: £59
Level 2: £79
Level 3: £89
Level 4: £99
Level 5: £119
Level 6: £129
Level 7: £139
CPD QS Accredited Certificate
 Digital certificate - £10 
Upon successfully completing the Bundle, you will need to place an order to receive a PDF Certificate for each course within the bundle. These certificates serve as proof of your newly acquired skills, accredited by CPD QS and will cost you £10 for each course. Also, the certificates are recognised throughout the UK and internationally.
CPD QS Accredited Certificate
 Hard copy certificate - £29 
International students are subject to a £10 delivery fee for their orders, based on their location.

Academy for Health and Fitness

Higher Chemistry

Chemical Pathology

Level 7 Organic Chemistry Diploma

<div>
						<div>
				<div>
									<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
								<div>
				<p><span>Register on the SQL Server : Basic Microsoft SQL Server today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career.</span></p><p><span>The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials.</span></p><p><span>Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get an e-certificate as proof of your course completion.</span></p><p><span>The SQL Server : Basic Microsoft SQL Server is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones.</span></p><p><span>The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly!</span></p><h5><b>What You Get With The SQL Server : Basic Microsoft SQL Server </b></h5><ul><li><span>Receive a e-certificate upon successful completion of the course</span></li><li><span>Get taught by experienced, professional instructors</span></li><li><span>Study at a time and pace that suits your learning style</span></li><li><span>Get instant feedback on assessments </span></li><li><span>24/7 help and advice via email or live chat</span></li><li><span>Get full tutor support on weekdays (Monday to Friday)</span></li></ul>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
					<div>
							
					<div></div>
											<div></div>
														
							
					<div></div>
											<div></div>
														
							
					<div></div>
											<div></div>
														
							
					<div></div>
											<div></div>
														
					</div>
			</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>Course Design</h2>		</div>
				</div>
				<div>
				<div>
								<div>
				<div id="course-home"><div><p><span>The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.</span></p><p><span>You are taught through a combination of</span></p><ul><li><span>Video lessons</span></li><li><span>Online study materials</span></li></ul></div></div>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>Certification</h2>		</div>
				</div>
				<div>
				<div>
								<div>
				<p><span>Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99.</span></p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Who Is This Course For:</h2>		</div>
				</div>
				<div>
				<div>
								<div>
				<p><span>The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge.</span></p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>Requirements:</h2>		</div>
				</div>
				<div>
				<div>
								<div>
				<p><span>The online training is open to all students and has no formal entry requirements. To study the SQL Server : Basic Microsoft SQL Server, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16.</span></p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
									</div>
			</div>
					</div><div>
				<h3>Course Content</h3>

<div id="course_curriculum">
<table width="100%">				<tbody><tr>
					<td colspan="4">Unit 01: Course and Instructor Introduction</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Course and Instructor Introduction</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Unit 02: Laying out the foundation - Overview &amp; Installation</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Pre-requisites &amp; Different Editions of SQL Server</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Downloading Express Edition &amp; sample database</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Installing the downloads &amp; Configuration</td>
					<td> </td>
					<td><span><i></i> 00:19:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>The sa Login</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Wrap up - what we went over!</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Unit 03: Core concepts - Taming the RDBMS beast!</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>What is RDBMS?</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Where does SQL Server fit in?</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Basic database objects</td>
					<td> </td>
					<td><span><i></i> 00:16:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Different Files that got installed - MDF &amp; LDF</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Wrap up - what we went over!</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Unit 04: Tool of the trade - SQL Server Management Studio</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Getting started with SSMS</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Getting around Object Explorer</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Query Window</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Pre-built DB - system database</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Wrap up - what we went over!</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Unit 05: Simple SELECT</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Bare Minimum: SELECTING a literal</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Retrieving / querying data from a table - using FROM clause</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Playing with Column Names</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Rearranging columns to your liking</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Wrap up - what we went over!</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Unit 06: Filtering out unwanted data</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Narrowing down and ordering result set - WHERE and ORDER clause</td>
					<td> </td>
					<td><span><i></i> 00:17:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Narrowing down result set - BETWEEN / NOT BETWEEN</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Narrowing down result set - IN and NOT IN operator</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Narrowing down result set - Pattern Matching: LIKE and Wildcards</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Wrap up - what we went over!</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Unit 07: Expressions and Functions</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Dealing with nothing: NULL</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Working with strings: Concatenation and other string functions</td>
					<td> </td>
					<td><span><i></i> 00:15:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Working with dates: Date Functions</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Some System Functions</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Wrap up - what we went over!</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Unit 08: Getting data out of multiple tables</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Joining multiple tables - INNER JOIN</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Join types - OUTER JOIN - LEFT / RIGHT / FULL</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Join types - CROSS JOIN</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Holy UNION!</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Subqueries</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Wrap up - what we went over!</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Unit 09: Summarizing and Grouping data</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>DISTINCT and ALL Predicates</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Aggregate Functions</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>GROUP BY clause / HAVING clause</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>WHERE and ORDER BY in aggregate queries</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Wrap up - what we went over!</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Unit 10: Bonus</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Bonus_Section</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
				</tbody></table></div>

			</div>
			<h2>Frequently Asked Questions</h2>
                        <div>
                            <div>
                                <span>
                                    Are there any prerequisites for taking the course?
                                </span>
                                <div>
                                    <span></span>
                                </div>
                            </div>
                            <div>
                                <div>
                                    <p>
                                        There are no specific prerequisites for this course, nor
                                        are there any formal entry requirements. All you need is
                                        an internet connection, a good understanding of English
                                        and a passion for learning for this course.
                                    </p>
                                </div>
                            </div>
                        </div>
                        
                        <div>
                            <div>
                                <span>
                                    Can I access the course at any time, or is there a set
                                    schedule?
                                </span>
                                <div>
                                    <span></span>
                                </div>
                            </div>
                            <div>
                                <div>
                                    <p>
                                        You have the flexibility to access the course at any time
                                        that suits your schedule. Our courses are self-paced,
                                        allowing you to study at your own pace and convenience.
                                    </p>
                                </div>
                            </div>
                        </div>
                        
                        <div>
                            <div>
                                <span>
                                    How long will I have access to the course?
                                </span>
                                <div>
                                    <span></span>
                                </div>
                            </div>
                            <div>
                                <div>
                                    <p>
                                        For this course, you will have access to the course
                                        materials for 1 year only. This means you can review the
                                        content as often as you like within the year, even after
                                        you've completed the course. However, if you buy Lifetime
                                        Access for the course, you will be able to access the
                                        course for a lifetime.
                                    </p>
                                </div>
                            </div>
                        </div>
                        
                        <div>
                            <div>
                                <span>
                                    Is there a certificate of completion provided after
                                    completing the course?
                                </span>
                                <div>
                                    <span></span>
                                </div>
                            </div>
                            <div>
                                <div>
                                    <p>
                                        Yes, upon successfully completing the course, you will
                                        receive a certificate of completion. This certificate can
                                        be a valuable addition to your professional portfolio and
                                        can be shared on your various social networks.
                                    </p>
                                </div>
                            </div>
                        </div>
                        
                        <div>
                            <div>
                                <span>
                                    Can I switch courses or get a refund if I'm not satisfied
                                    with the course?
                                </span>
                                <div>
                                    <span></span>
                                </div>
                            </div>
                            <div>
                                <div>
                                    <p>
                                        We want you to have a positive learning experience. If
                                        you're not satisfied with the course, you can request a
                                        course transfer or refund within 14 days of the initial
                                        purchase.
                                    </p>
                                </div>
                            </div>
                        </div>
                        
                        <div>
                            <div>
                                <span>
                                    How do I track my progress in the course?
                                </span>
                                <div>
                                    <span></span>
                                </div>
                            </div>
                            <div>
                                <div>
                                    <p>
                                        Our platform provides tracking tools and progress
                                        indicators for each course. You can monitor your progress,
                                        completed lessons, and assessments through your learner
                                        dashboard for the course.
                                    </p>
                                </div>
                            </div>
                        </div>
                        
                        <div>
                            <div>
                                <span>
                                    What if I have technical issues or difficulties with the
                                    course?
                                </span>
                                <div>
                                    <span></span>
                                </div>
                            </div>
                            <div>
                                <div>
                                    <p>
                                        If you encounter technical issues or content-related
                                        difficulties with the course, our support team is
                                        available to assist you. You can reach out to them for
                                        prompt resolution.
                                    </p>
                                </div>
                            </div>
                        </div>

Register on the SQL Server : Basic Microsoft SQL Server today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career.
The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials.
Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get an e-certificate as proof of your course completion.
The SQL Server : Basic Microsoft SQL Server is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones.
The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly!
What You Get With The SQL Server : Basic Microsoft SQL Server
Receive a e-certificate upon successful completion of the course
Get taught by experienced, professional instructors
Study at a time and pace that suits your learning style
Get instant feedback on assessments
24/7 help and advice via email or live chat
Get full tutor support on weekdays (Monday to Friday)
Course Design
The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.
You are taught through a combination of
Video lessons
Online study materials
Certification
Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99.
Who Is This Course For:
The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge.
Requirements:
The online training is open to all students and has no formal entry requirements. To study the SQL Server : Basic Microsoft SQL Server, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16.
Course Content
Unit 01: Course and Instructor Introduction			
	Course and Instructor Introduction		00:05:00
Unit 02: Laying out the foundation - Overview & Installation			
	Pre-requisites & Different Editions of SQL Server		00:06:00
	Downloading Express Edition & sample database		00:03:00
	Installing the downloads & Configuration		00:19:00
	The sa Login		00:04:00
	Wrap up - what we went over!		00:01:00
Unit 03: Core concepts - Taming the RDBMS beast!			
	What is RDBMS?		00:12:00
	Where does SQL Server fit in?		00:02:00
	Basic database objects		00:16:00
	Different Files that got installed - MDF & LDF		00:03:00
	Wrap up - what we went over!		00:01:00
Unit 04: Tool of the trade - SQL Server Management Studio			
	Getting started with SSMS		00:07:00
	Getting around Object Explorer		00:05:00
	Query Window		00:06:00
	Pre-built DB - system database		00:04:00
	Wrap up - what we went over!		00:01:00
Unit 05: Simple SELECT			
	Bare Minimum: SELECTING a literal		00:05:00
	Retrieving / querying data from a table - using FROM clause		00:06:00
	Playing with Column Names		00:03:00
	Rearranging columns to your liking		00:01:00
	Wrap up - what we went over!		00:01:00
Unit 06: Filtering out unwanted data			
	Narrowing down and ordering result set - WHERE and ORDER clause		00:17:00
	Narrowing down result set - BETWEEN / NOT BETWEEN		00:09:00
	Narrowing down result set - IN and NOT IN operator		00:05:00
	Narrowing down result set - Pattern Matching: LIKE and Wildcards		00:11:00
	Wrap up - what we went over!		00:01:00
Unit 07: Expressions and Functions			
	Dealing with nothing: NULL		00:06:00
	Working with strings: Concatenation and other string functions		00:15:00
	Working with dates: Date Functions		00:07:00
	Some System Functions		00:05:00
	Wrap up - what we went over!		00:02:00
Unit 08: Getting data out of multiple tables			
	Joining multiple tables - INNER JOIN		00:09:00
	Join types - OUTER JOIN - LEFT / RIGHT / FULL		00:08:00
	Join types - CROSS JOIN		00:02:00
	Holy UNION!		00:03:00
	Subqueries		00:04:00
	Wrap up - what we went over!		00:02:00
Unit 09: Summarizing and Grouping data			
	DISTINCT and ALL Predicates		00:02:00
	Aggregate Functions		00:03:00
	GROUP BY clause / HAVING clause		00:04:00
	WHERE and ORDER BY in aggregate queries		00:04:00
	Wrap up - what we went over!		00:01:00
Unit 10: Bonus			
	Bonus_Section		00:01:00
Frequently Asked Questions
Are there any prerequisites for taking the course?
 There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. 
Can I access the course at any time, or is there a set schedule?
 You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. 
How long will I have access to the course?
 For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. 
Is there a certificate of completion provided after completing the course?
 Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. 
Can I switch courses or get a refund if I'm not satisfied with the course?
 We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. 
How do I track my progress in the course?
 Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. 
What if I have technical issues or difficulties with the course?
 If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution. 

Janets

Microsoft Certification

Microsoft SQL Server

Microsoft SQL

SQL Server

Microsoft AZ-303

SQL Server : Basic Microsoft SQL Server

Redhill

<h3><b>Total H.248 training course description</b></h3>
      <p> A course focusing purely on the H.248 protocol. Anyone working through the ITU standards documents can testify to the need of a training course to explain how H.248 really works. This course already assumes knowledge of other VoIP protocols and starts by positioning H.248 in relation to the other protocols. The course then looks at H.248 architectures and concepts before analysing H.248 messages and call flows. </p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
         <li>Describe what H.248 is</li>
              <li>Recognise where H.248 fits in relation to other VoIP protocols.</li>
              <li>Explain how H.248 works.</li>
              <li>Analyse H.248 packets</li>
                  </ul>
       
        <h5>
        <b>Total H.248 training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Technical staff working with H.248 </p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>Voice Over IP.</p>
              
							<li><b>Duration</b></li>
							
              <p>2 days
						</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>Total H.248 training course contents</b></h3>
      <ul>
				<li>What is H.248?</li><p> Review of VoIP protocols: RTP, RTCP, SIP, SDP, H.323. The PSTN and SS7. Where H.248 fits into the picture. H.248 history. MGCP. The IETF. Megaco. ITU standards. H.248v1, v2, v3. 
 
 
</p><li>H.248 architectures</li><p> Media Gateways, Media Gateway Controllers, Gateway Control functions, Signalling Gateways. Reference architectures: IMS/TISPAN: IBCF, IWF, I-BGF, SPDF. MSF: S-SBG-NC, D-SBG-NC. GSMA: IPX Proxy. Softswitches. 
 
 
</p><li>H.248 concepts</li><p> The connection model, terminations, streams, contexts. Termination properties: descriptors, context properties. Events, signals, packages. 
 
 
</p><li>H.248 messages</li><p> Protocol stack, UDP, TCP. Message structure. Transactions, actions, commands. Requests, replies, acknowledgements. Sample message flows. Binary encoding, ASN syntax, Text encoding. 
 
 
</p><li>H.248 commands</li><p> Termination manipulation: Add, Subtract, Move, Modify. Event reporting: Notify. Management: AuditCapability, AuditValue, ServiceChange. 
 
 
</p><li>H.248 Descriptors</li><p> What are descriptors? Relationship with messages and commands. Basic descriptors, Descriptors composed of other descriptors. The 19 descriptors. Defaults. 
 
 
</p><li>H.248 Transactions</li><p> Groups of commands, transaction Ids, relationship with actions and commands. Requests and replies. 
 
 
	</p><li>H.248 wrap up</li><p> What is a package? Basic packages. H.248 security. H.248 - SIP interoperation. H.248 interoperation with other protocols. 
 
</p>
      </ul>

Total H.248 training course description
 A course focusing purely on the H.248 protocol. Anyone working through the ITU standards documents can testify to the need of a training course to explain how H.248 really works. This course already assumes knowledge of other VoIP protocols and starts by positioning H.248 in relation to the other protocols. The course then looks at H.248 architectures and concepts before analysing H.248 messages and call flows. 
What will you learn
Describe what H.248 is
Recognise where H.248 fits in relation to other VoIP protocols.
Explain how H.248 works.
Analyse H.248 packets
Total H.248 training course details
Who will benefit:
Technical staff working with H.248 
Prerequisites:
Voice Over IP.
Duration
2 days 
Total H.248 training course contents
What is H.248?
 Review of VoIP protocols: RTP, RTCP, SIP, SDP, H.323. The PSTN and SS7. Where H.248 fits into the picture. H.248 history. MGCP. The IETF. Megaco. ITU standards. H.248v1, v2, v3. 
H.248 architectures
 Media Gateways, Media Gateway Controllers, Gateway Control functions, Signalling Gateways. Reference architectures: IMS/TISPAN: IBCF, IWF, I-BGF, SPDF. MSF: S-SBG-NC, D-SBG-NC. GSMA: IPX Proxy. Softswitches. 
H.248 concepts
 The connection model, terminations, streams, contexts. Termination properties: descriptors, context properties. Events, signals, packages. 
H.248 messages
 Protocol stack, UDP, TCP. Message structure. Transactions, actions, commands. Requests, replies, acknowledgements. Sample message flows. Binary encoding, ASN syntax, Text encoding. 
H.248 commands
 Termination manipulation: Add, Subtract, Move, Modify. Event reporting: Notify. Management: AuditCapability, AuditValue, ServiceChange. 
H.248 Descriptors
 What are descriptors? Relationship with messages and commands. Basic descriptors, Descriptors composed of other descriptors. The 19 descriptors. Defaults. 
H.248 Transactions
 Groups of commands, transaction Ids, relationship with actions and commands. Requests and replies. 
H.248 wrap up
 What is a package? Basic packages. H.248 security. H.248 - SIP interoperation. H.248 interoperation with other protocols. 

Systems & Network Training

Network & Security

Network Engineer

Total H.248 for Engineers

<h3><b>Lawful Intercept training course description</b></h3>
        <p>Packet based networks require a different approach to Lawful Intercept (LI) than that used in circuit switched networks. This course focuses on what Lawful Interception and Data Retention (DR) means to communications service providers in the IP and NGN areas. The course assumes a basic knowledge of IP networking (i.e. DNS, TCP/UDP, IP, RTP) and the building of services on an IP platform (e.g. SIP, SDP, FTP, HTTP). The course first looks at the regulatory context for LI and DR and how this is translated to a practical architecture.
</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
					<li>Recognise the legal and regulatory obligations to provide LI and DR.</li>
					<li>Identify the components of the handover architecture for each of LI and DR.</li>
					<li>Identify the preferred location of points of interception and points of retention in the IP network.</li>
					<li>Map intercepted material to handover protocols.</li>
					<li>Understand the data mapping defined in the available standards for both LI and DR.</li>
                  </ul>
        <h5>
        <b>Lawful Intercept training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Technical and managerial staff needing to implement public networks.</p>
              
							<li><b>Prerequisites:</b></li>
							
              <p> TCP/IP Foundation</p>
              
							<li><b>Duration</b></li>
							
              <p>1 day</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>Lawful Intercept training course contents</b></h3>
      <ul>
        <li>What is meant by LI and DR? </li><p>


Review of regulation: Data protection Directive; Data Retention Directive; RIPA.
</p><li>LI architectures </li><p>
Handover and Interception: ETSI standards ES 201 671 and TS 102 232.

</p><li>LI handover protocol </li><p>
IRI and CC handover; correlation; manual interfaces.

</p><li>DR architectures </li><p>
Handover of query results; points of retention.

</p><li>DR query command set </li><p>
	Retrieval of retained records.

</p><li>Security concerns </li><p>
Operation privacy; target privacy; storage and transmission integrity.

</p><li>Implementation </li><p>
Identifying PoI and PoR for provided services.

</p><li>LI and DR wrap up </li><p>
Interaction with other services, storage obligations (volume, time, availability).</p>
      </ul>

Lawful Intercept training course description
Packet based networks require a different approach to Lawful Intercept (LI) than that used in circuit switched networks. This course focuses on what Lawful Interception and Data Retention (DR) means to communications service providers in the IP and NGN areas. The course assumes a basic knowledge of IP networking (i.e. DNS, TCP/UDP, IP, RTP) and the building of services on an IP platform (e.g. SIP, SDP, FTP, HTTP). The course first looks at the regulatory context for LI and DR and how this is translated to a practical architecture.

What will you learn
Recognise the legal and regulatory obligations to provide LI and DR.
Identify the components of the handover architecture for each of LI and DR.
Identify the preferred location of points of interception and points of retention in the IP network.
Map intercepted material to handover protocols.
Understand the data mapping defined in the available standards for both LI and DR.
Lawful Intercept training course details
Who will benefit:
Technical and managerial staff needing to implement public networks.
Prerequisites:
 TCP/IP Foundation
Duration
1 day
Lawful Intercept training course contents
What is meant by LI and DR?
 Review of regulation: Data protection Directive; Data Retention Directive; RIPA.

LI architectures

Handover and Interception: ETSI standards ES 201 671 and TS 102 232. 
LI handover protocol

IRI and CC handover; correlation; manual interfaces. 
DR architectures

Handover of query results; points of retention. 
DR query command set
 Retrieval of retained records. 
Security concerns

Operation privacy; target privacy; storage and transmission integrity. 
Implementation

Identifying PoI and PoR for provided services. 
LI and DR wrap up

Interaction with other services, storage obligations (volume, time, availability).

3172 Wrap courses

Negotiation Skills - Professional 1 Day Workshop in Chester

By Mangates

Negotiation Skills - Professional 1 Day Workshop in Canterbury

By Mangates

Negotiation Skills - Professional 1 Day Workshop in Carlisle

By Mangates

Negotiation Skills - Professional 1 Day Workshop in Fleet

By Mangates

Negotiation Skills - Professional 1 Day Workshop in Glasgow

By Mangates

Negotiation Skills - Professional 1 Day Workshop in High Wycombe

By Mangates

Negotiation Skills - Professional 1 Day Workshop in Hamilton, UK

By Mangates

Negotiation Skills - Professional 1 Day Workshop in Gloucester

By Mangates

Negotiation Skills - Professional 1 Day Workshop in Guildford

By Mangates

Negotiation Skills - Professional 1 Day Workshop in Harrogate

By Mangates

Search By Location