Oldham

<div data-id="707b00e3" data-element_type="container" data-settings='{"content_width":"full"}' style="color: rgb(9, 13, 24); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(9, 13, 24);"><div data-id="1c97cfcc" data-element_type="widget" data-widget_type="woocommerce-product-content.default" style="color: rgb(50, 74, 109); box-sizing: border-box;" fr-original-style=" color: rgb(50, 74, 109);"><p style="color: rgb(50, 74, 109); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(50, 74, 109);">Are you a customs agent? Or does your company use customs agents and intermediaries to help you trade with the EU and the Rest of the World?</p><p style="color: rgb(50, 74, 109); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(50, 74, 109);">If so, you need to know how to meet customs requirements fast and efficiently now the new customs declaration system CDS is in place. We can help.</p><p style="color: rgb(50, 74, 109); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(50, 74, 109);">Our training will highlight what you need to know to be able to accurately complete a simple customs declaration and to understand the Customs regimes and will focus on completion of a customs declaration on CDS.</p><p style="color: rgb(50, 74, 109); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(50, 74, 109);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who is it for?</strong><br fr-original-style="" style="box-sizing: border-box;">Anyone who needs an understanding of Customs regimes and how to complete Customs declarations &ndash; shipping, exporting staff, importing staff, management at all levels, logistics, freight forwarders.</p><p style="color: rgb(50, 74, 109); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(50, 74, 109);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">What does it cover?</strong></p><ul style="color: rgb(50, 74, 109); box-sizing: border-box;" fr-original-style=" color: rgb(50, 74, 109);"><li fr-original-style="" style="box-sizing: border-box;">Introduction to Trade</li><li fr-original-style="" style="box-sizing: border-box;">Business Responsibilities</li><li fr-original-style="" style="box-sizing: border-box;">Export process</li><li fr-original-style="" style="box-sizing: border-box;">Import process.</li><li fr-original-style="" style="box-sizing: border-box;">Classification &ndash; determining the use of commodity codes.</li><li fr-original-style="" style="box-sizing: border-box;">Reliefs</li><li fr-original-style="" style="box-sizing: border-box;">Preferences</li><li fr-original-style="" style="box-sizing: border-box;">Origin</li><li fr-original-style="" style="box-sizing: border-box;">Customs procedures updates</li><li fr-original-style="" style="box-sizing: border-box;">Common difficulties when completing the customs declaration.</li></ul></div></div><div data-id="60285c8" data-element_type="container" data-settings='{"content_width":"full"}' style="color: rgb(9, 13, 24); box-sizing: border-box;" fr-original-style=" color: rgb(9, 13, 24);"><br fr-original-style="" style="box-sizing: border-box;"></div>

Are you a customs agent? Or does your company use customs agents and intermediaries to help you trade with the EU and the Rest of the World?
If so, you need to know how to meet customs requirements fast and efficiently now the new customs declaration system CDS is in place. We can help.
Our training will highlight what you need to know to be able to accurately complete a simple customs declaration and to understand the Customs regimes and will focus on completion of a customs declaration on CDS.
Who is it for?
Anyone who needs an understanding of Customs regimes and how to complete Customs declarations – shipping, exporting staff, importing staff, management at all levels, logistics, freight forwarders.
What does it cover?
Introduction to Trade
Business Responsibilities
Export process
Import process.
Classification – determining the use of commodity codes.
Reliefs
Preferences
Origin
Customs procedures updates
Common difficulties when completing the customs declaration.

Export Unlocked Limited

Trade & Commerce

Global Distribution Systems (GDS)

Shipping

Import/Export

Customs

Are you a customs agent/ Importer ? Or does your company use customs agents and intermediaries to help you trade with the EU and the Rest of the World? If so, you need to know how to meet customs requirements fast and efficiently now the new customs declaration system CDS is in place. We can help.



CDS: NEW CUSTOMS FOR EXPORTS/IMPORTS

General Admission

<p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(111, 114, 135);">We can come to your food business and deliver this course at your premises.&nbsp;</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">This Level 2 HACCP course is suitable for food and drink manufacturers, caterers, artisans, restaurants and more.&nbsp;</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Our customers include noodle, beer, pastry, bread, alcohol, biscuits, meat and canapes manufacturers. We also deliver this course regularly at catering businesses.&nbsp;</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">This <a href="https://www.kitchentonic.com/level-2-haccp-rsph-course" title="https://www.kitchentonic.com/level-2-haccp-rsph-course" target="_blank" data-msys-clicktrack="0" rel="nofollow noopener noreferrer" style="color: var(--eds-control,#3659e3); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: var(--eds-control,#3659e3);">RSPH Level 2 in Understanding HACCP course</a> introduces the concept of HACCP which helps the learner to develop an understanding of hazards, controls, monitoring and corrective action procedures for which they may be directly responsible in order to ensure effective food safety.</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">This course is ideal for anyone new to HACCP or has a basic knowledge and understanding of HACCP.&nbsp;</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Topics covered include:</strong></p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">The importance of HACCP - benefits, origins, legal requirements, due diligence.</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">To understand the fundamentals of HACCP - Hazards, Prerequisites, the process of developing HACCP based on CODEX HACCP Principles.</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Assessment method: 20 multiple choice questions</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Certificates are issued by the RSPH</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">To book HACCP Training or if you would like a quote, contact us by email.&nbsp;</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">We travel to most places to deliver this HACCP course. Trainer travel fees may be applicable.&nbsp;</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Prices start from &pound;250pp depending how many candidates attend the course.&nbsp;</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Contact us for a quote.&nbsp;</p>

On-Site Level 2 HACCP Training – Nationwide
We offer on-site delivery of the Level 2 HACCP course at your premises, providing convenience and flexibility for your team.
This course is suitable for a wide range of businesses, including food and drink manufacturers, caterers, artisan producers, restaurants, and more.
We have extensive experience delivering  this course to manufacturers of noodles, beer, pastries, pasta, bread, alcohol, biscuits, meat, and canapés, as well as catering businesses. We regularly deliver this course to a variety of sectors, ensuring that your staff are trained in food safety and HACCP principles.
This RSPH Level 2 in Understanding HACCP course introduces the concept of HACCP which helps the learner to develop an understanding of hazards, controls, monitoring and corrective action procedures for which they may be directly responsible in order to ensure effective food safety.
This course is ideal for anyone new to HACCP or has a basic knowledge and understanding of HACCP. 
Topics covered include:
The importance of HACCP - benefits, origins, legal requirements, due diligence.
To understand the fundamentals of HACCP - Hazards, Prerequisites, the process of developing HACCP based on CODEX HACCP Principles.
Assessment method: 20 multiple choice questions
Certificates are issued by the RSPH
If you wish to have this HACCP course delivered on-site at your business location, please get in touch to discuss your specific needs and secure your booking.
Although our base is in London, we deliver training throughout England. Please be aware that trainer travel fees may be applicable, depending on your business location.
Cost: £250 plus £30 per participant, inclusive of exam fees. We can train up to 20 candidates per session.
Autumn discount: Previously £300 plus £30 per participant.
All our courses are VAT exempt.
We have extensive experience delivering this course across diverse sectors, including meat processing, bakery production, ice cream manufacturing, cake and pastry creation, breweries, distilleries, noodle production, and more.
Next steps, call 07837655954 or email info@kitchentonic for a quote or to book training

Kitchen Tonic Training Company and Food Safety Consultants

Food Safety

Catering

Health & Safety

Food Handling

HACCP

HACCP Trainer - Level 2 HACCP Training Course - On-site Nationwide

Chesterfield

<div data-css="tve-u-17298e4b572" fr-original-style=" color: rgb(0, 0, 0);" id="isPasted" style="color: rgb(0, 0, 0); box-sizing: border-box;"><div data-css="tve-u-17298e4b56c" fr-original-style="" style="box-sizing: border-box;"><div data-css="tve-u-17298e4b56b" fr-original-style="" style="box-sizing: border-box;"><div data-css="tve-u-17298e4b573" fr-original-style=" color: rgb(0, 0, 0);" id="isPasted" style="color: rgb(0, 0, 0); box-sizing: border-box;"><div data-css="tve-u-17298e4b56e" fr-original-style="" style="box-sizing: border-box;"><p data-css="tve-u-17298e4b577" fr-original-style=" color: rgb(34, 177, 77) !important;" style="color: rgb(34, 177, 77) !important; font-size: 16px; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&pound; Enquire</strong></p></div></div><div data-css="tve-u-17298e4b51f" data-icon-code="icon-check" fr-original-style=" color: rgb(0, 0, 0);" style="color: rgb(0, 0, 0); box-sizing: border-box;"><ul fr-original-style="" style="box-sizing: border-box;"><li data-css="tve-u-16f8a5891e5" fr-original-style=" color: rgb(135, 145, 152);" style="color: rgb(135, 145, 152); box-sizing: border-box;"><span data-css="tve-u-17298e4b503" fr-original-style=" color: rgb(0, 0, 0) !important;" style="color: rgb(0, 0, 0) !important; box-sizing: border-box;">Highfield Level 3 Award in Delivering Training (RQF)</span></li><li data-css="tve-u-16f8a5891e5" fr-original-style=" color: rgb(135, 145, 152);" style="color: rgb(135, 145, 152); box-sizing: border-box;"><span data-css="tve-u-17298e4b503" fr-original-style=" color: rgb(0, 0, 0) !important;" style="color: rgb(0, 0, 0) !important; box-sizing: border-box;">Three day course</span></li></ul></div></div></div></div>

£ Enquire
Highfield Level 3 Award in Delivering Training (RQF)
Three day course

Pochat Training

Coaching Skills

Level 3 Award in Delivering Training

Manchester

Java Programming Beginners Course
This course is a beginner programmers course to intermediate level, starting from basics through to creating methods, classes, and objects. At the end of this course, one would be conversant with all the necessary basics of Java. This is a one-day course in the classroom, in Manchester.
Java programming course topics: 
Overview of Java:
This course covers Java Object-Oriented Programming (OOP) principles.
Java Data Types and using Variables in Java:
Here we learn to code using data types and variables of different data types: Primitives; Characters; Boolean; Variables and variable scope; String class; Type conversion and casting.
Java Operators and Expressions:
What are operators and how to use them? Arithmetic operators; Relational operators; assignment operators; logical operators; increment and decrement operators.
Decision Making:
The Java Syntax for the If-statement; If,else; If,else if,else; Nested if; Switch Statements;
Using Loops:
For loops, while loops, do while, Enhanced for loop; Nesting loops; break, continue; The return statement.
Arrays:
Working with arrays, 2-d arrays, iterating arrays. Using the for-each loop with Arrays
Lists:
Working with lists. Lists vs Arrays.
Files, streams with Java:
Open, Read and Write to CSV Files, txt files and bin files.
Exception Handling:
Fundamentals of exception handling; Exception types; Using try and catch; Multiple catch clauses; Nested try statements; throwing and throwing;  finally blocks
Using Methods:
Introduction of methods; Creating and calling methods; Parameters and return values; Overloading methods.
Introduction to Classes and Objects:
Creating a Class; Creating an Object; Using an object Adding Instance variables; Controlling accessibility; Class Constructors; Parameterized Constructors;
Inheritance. The dot operator, this keyword, the static keywords, the super keyword. Access control : private, public, and protected; the final keyword.
Override.
Polymorphism.
Abstraction. Interfaces and implementing interfaces.


PCWorkshops

City & Guilds

Java

Programming Fundamentals

Programming Languages

Computer Programming

This course is a beginners programmers course, to intermediate level, starting from basics through to creating methods, classes and objects. At the end of this course, one would be conversant with all the necessary basics of Java. This is a one day course in classroom, in Manchester.

Java Basics Course, Manchester

General admission

<div data-css="tve-u-17298e4b573" fr-original-style=" color: rgb(0, 0, 0);" id="isPasted" style="color: rgb(0, 0, 0); box-sizing: border-box;"><div data-css="tve-u-1788d4b1ad3" fr-original-style="" style="box-sizing: border-box;"><div data-css="tve-u-17298e4b574" fr-original-style=" color: rgb(0, 0, 0);" id="isPasted" style="color: rgb(0, 0, 0); box-sizing: border-box;"><div data-css="tve-u-1788d4b25a5" fr-original-style="" style="box-sizing: border-box;"><div data-css="tve-u-17298e4b572" fr-original-style=" color: rgb(0, 0, 0);" id="isPasted" style="color: rgb(0, 0, 0); box-sizing: border-box;"><div data-css="tve-u-17298e4b56c" fr-original-style="" style="box-sizing: border-box;"><div data-css="tve-u-1788d4b2e7e" fr-original-style="" style="box-sizing: border-box;"><div data-css="tve-u-17298e4b573" fr-original-style=" color: rgb(0, 0, 0);" id="isPasted" style="color: rgb(0, 0, 0); box-sizing: border-box;"><div data-css="tve-u-17298e4b56e" fr-original-style="" style="box-sizing: border-box;"><div data-css="tve-u-172e1d96552" fr-original-style=" color: rgb(0, 0, 0);" id="isPasted" style="color: rgb(0, 0, 0); box-sizing: border-box;"><p data-css="tve-u-17298e4b526" fr-original-style=" color: rgb(34, 177, 77) !important;" style="color: rgb(34, 177, 77) !important; font-size: 16px; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&pound; Enquire</strong></p></div><div data-css="tve-u-17298e4b521" data-icon-code="icon-check" fr-original-style=" color: rgb(0, 0, 0);" style="color: rgb(0, 0, 0); box-sizing: border-box;"><ul fr-original-style="" style="box-sizing: border-box;"><li data-css="tve-u-16f8a5891e5" fr-original-style=" color: rgb(135, 145, 152);" style="color: rgb(135, 145, 152); box-sizing: border-box;"><div data-css="tve-u-17298e4b524" fr-original-style="" style="box-sizing: border-box;"></div><span data-css="tve-u-17298e4b503" fr-original-style=" color: rgb(0, 0, 0) !important;" style="color: rgb(0, 0, 0) !important; box-sizing: border-box;">Highfields Level 1 Certificate in Digital Skills</span></li><li data-css="tve-u-16f8a5891e5" fr-original-style=" color: rgb(135, 145, 152);" style="color: rgb(135, 145, 152); box-sizing: border-box;"><div data-css="tve-u-17298e4b524" fr-original-style="" style="box-sizing: border-box;"></div><span data-css="tve-u-17298e4b503" fr-original-style=" color: rgb(0, 0, 0) !important;" style="color: rgb(0, 0, 0) !important; box-sizing: border-box;">140 - 217 hours</span></li></ul></div></div></div></div></div></div></div></div></div></div>

£ Enquire
Highfields Level 1 Certificate in Digital Skills
140 - 217 hours

Digital Skills

Digital Skills Certificate, Level 1

<div data-css="tve-u-17298e4b573" fr-original-style=" color: rgb(0, 0, 0);" id="isPasted" style="color: rgb(0, 0, 0); box-sizing: border-box;"><div data-css="tve-u-1788d4b1ad3" fr-original-style="" style="box-sizing: border-box;"><div data-css="tve-u-17298e4b574" fr-original-style=" color: rgb(0, 0, 0);" id="isPasted" style="color: rgb(0, 0, 0); box-sizing: border-box;"><div data-css="tve-u-1788d4b25a5" fr-original-style="" style="box-sizing: border-box;"><div data-css="tve-u-17298e4b572" fr-original-style=" color: rgb(0, 0, 0);" id="isPasted" style="color: rgb(0, 0, 0); box-sizing: border-box;"><div data-css="tve-u-17298e4b56c" fr-original-style="" style="box-sizing: border-box;"><div data-css="tve-u-1788d4b2e7e" fr-original-style="" style="box-sizing: border-box;"><div data-css="tve-u-17298e4b573" fr-original-style=" color: rgb(0, 0, 0);" id="isPasted" style="color: rgb(0, 0, 0); box-sizing: border-box;"><div data-css="tve-u-17298e4b56e" fr-original-style="" style="box-sizing: border-box;"><p data-css="tve-u-17298e4b577" fr-original-style=" color: rgb(34, 177, 77) !important;" style="color: rgb(34, 177, 77) !important; font-size: 16px; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&pound; Enquire</strong></p></div></div><div data-css="tve-u-17298e4b51f" data-icon-code="icon-check" fr-original-style=" color: rgb(0, 0, 0);" style="color: rgb(0, 0, 0); box-sizing: border-box;"><ul fr-original-style="" style="box-sizing: border-box;"><li data-css="tve-u-16f8a5891e5" fr-original-style=" color: rgb(135, 145, 152);" style="color: rgb(135, 145, 152); box-sizing: border-box;"><div data-css="tve-u-17298e4b524" fr-original-style="" style="box-sizing: border-box;"></div><span data-css="tve-u-17298e4b503" fr-original-style=" color: rgb(0, 0, 0) !important;" style="color: rgb(0, 0, 0) !important; box-sizing: border-box;">Highfields Level 1 Award in Digital Skills</span></li><li data-css="tve-u-16f8a5891e5" fr-original-style=" color: rgb(135, 145, 152);" style="color: rgb(135, 145, 152); box-sizing: border-box;"><div data-css="tve-u-17298e4b524" fr-original-style="" style="box-sizing: border-box;"></div><span data-css="tve-u-17298e4b503" fr-original-style=" color: rgb(0, 0, 0) !important;" style="color: rgb(0, 0, 0) !important; box-sizing: border-box;">50 - 83 hours</span></li></ul></div></div></div></div></div></div></div></div>

£ Enquire
Highfields Level 1 Award in Digital Skills
50 - 83 hours

Digital Skills Award, Level 1

<div data-css="tve-u-17298e4b573" fr-original-style=" color: rgb(0, 0, 0);" id="isPasted" style="color: rgb(0, 0, 0); box-sizing: border-box;"><div data-css="tve-u-1788d4b1ad3" fr-original-style="" style="box-sizing: border-box;"><div data-css="tve-u-17298e4b574" fr-original-style=" color: rgb(0, 0, 0);" id="isPasted" style="color: rgb(0, 0, 0); box-sizing: border-box;"><div data-css="tve-u-1788d4b25a5" fr-original-style="" style="box-sizing: border-box;"><div data-css="tve-u-17298e4b572" fr-original-style=" color: rgb(0, 0, 0);" id="isPasted" style="color: rgb(0, 0, 0); box-sizing: border-box;"><div data-css="tve-u-17298e4b56c" fr-original-style="" style="box-sizing: border-box;"><div data-css="tve-u-1788d4b2e7e" fr-original-style="" style="box-sizing: border-box;"><div data-css="tve-u-17298e4b573" fr-original-style=" color: rgb(0, 0, 0);" id="isPasted" style="color: rgb(0, 0, 0); box-sizing: border-box;"><div data-css="tve-u-17298e4b56e" fr-original-style="" style="box-sizing: border-box;"><div data-css="tve-u-172e1d96552" fr-original-style=" color: rgb(0, 0, 0);" id="isPasted" style="color: rgb(0, 0, 0); box-sizing: border-box;"><div data-css="tve-u-17298e4b572" fr-original-style=" color: rgb(0, 0, 0);" id="isPasted" style="color: rgb(0, 0, 0); box-sizing: border-box;"><div data-css="tve-u-17298e4b56c" fr-original-style="" style="box-sizing: border-box;"><div data-css="tve-u-172e1d94e31" fr-original-style="" style="box-sizing: border-box;"><p data-css="tve-u-17298e4b576" fr-original-style=" color: rgb(34, 177, 77) !important;" style="color: rgb(34, 177, 77) !important; font-size: 16px; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&pound; Enquire</strong></p></div></div></div><div data-css="tve-u-17298e4b520" data-icon-code="icon-check" fr-original-style=" color: rgb(0, 0, 0);" style="color: rgb(0, 0, 0); box-sizing: border-box;"><ul fr-original-style="" style="box-sizing: border-box;"><li data-css="tve-u-16f8a5891e5" fr-original-style=" color: rgb(135, 145, 152);" style="color: rgb(135, 145, 152); box-sizing: border-box;"><div data-css="tve-u-17298e4b524" fr-original-style="" style="box-sizing: border-box;"></div><span data-css="tve-u-17298e4b503" fr-original-style=" color: rgb(0, 0, 0) !important;" style="color: rgb(0, 0, 0) !important; box-sizing: border-box;">Highfields Level 2 Award in Digital Skills</span></li><li data-css="tve-u-16f8a5891e5" fr-original-style=" color: rgb(135, 145, 152);" style="color: rgb(135, 145, 152); box-sizing: border-box;"><div data-css="tve-u-17298e4b524" fr-original-style="" style="box-sizing: border-box;"></div><span data-css="tve-u-17298e4b503" fr-original-style=" color: rgb(0, 0, 0) !important;" style="color: rgb(0, 0, 0) !important; box-sizing: border-box;">70 - 120 hours</span></li></ul></div></div></div></div></div></div></div></div></div></div></div>

£ Enquire
Highfields Level 2 Award in Digital Skills
70 - 120 hours

Digital Skills Award, Level 2

<div data-css="tve-u-17298e4b573" fr-original-style=" color: rgb(0, 0, 0);" id="isPasted" style="color: rgb(0, 0, 0); box-sizing: border-box;"><div data-css="tve-u-1788d4b1ad3" fr-original-style="" style="box-sizing: border-box;"><div data-css="tve-u-17298e4b574" fr-original-style=" color: rgb(0, 0, 0);" id="isPasted" style="color: rgb(0, 0, 0); box-sizing: border-box;"><div data-css="tve-u-1788d4b25a5" fr-original-style="" style="box-sizing: border-box;"><div data-css="tve-u-17298e4b572" fr-original-style=" color: rgb(0, 0, 0);" id="isPasted" style="color: rgb(0, 0, 0); box-sizing: border-box;"><div data-css="tve-u-17298e4b56c" fr-original-style="" style="box-sizing: border-box;"><div data-css="tve-u-1788d4b2e7e" fr-original-style="" style="box-sizing: border-box;"><div data-css="tve-u-17298e4b573" fr-original-style=" color: rgb(0, 0, 0);" id="isPasted" style="color: rgb(0, 0, 0); box-sizing: border-box;"><div data-css="tve-u-17298e4b56e" fr-original-style="" style="box-sizing: border-box;"><div data-css="tve-u-172e1d96552" fr-original-style=" color: rgb(0, 0, 0);" id="isPasted" style="color: rgb(0, 0, 0); box-sizing: border-box;"><div data-css="tve-u-17298e4b572" fr-original-style=" color: rgb(0, 0, 0);" id="isPasted" style="color: rgb(0, 0, 0); box-sizing: border-box;"><div data-css="tve-u-17298e4b56c" fr-original-style="" style="box-sizing: border-box;"><div data-css="tve-u-172e1d94e31" fr-original-style="" style="box-sizing: border-box;"><div data-css="tve-u-17298e4b56e" fr-original-style=" color: rgb(0, 0, 0);" id="isPasted" style="color: rgb(0, 0, 0); box-sizing: border-box;"><p data-css="tve-u-17298e4b577" fr-original-style=" color: rgb(34, 177, 77) !important;" style="color: rgb(34, 177, 77) !important; font-size: 16px; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&pound; Enquire</strong></p></div><div data-css="tve-u-17298e4b51f" data-icon-code="icon-check" fr-original-style=" color: rgb(0, 0, 0);" style="color: rgb(0, 0, 0); box-sizing: border-box;"><ul fr-original-style="" style="box-sizing: border-box;"><li data-css="tve-u-16f8a5891e5" fr-original-style=" color: rgb(135, 145, 152);" style="color: rgb(135, 145, 152); box-sizing: border-box;"><div data-css="tve-u-17298e4b524" fr-original-style="" style="box-sizing: border-box;"></div><span data-css="tve-u-17298e4b503" fr-original-style=" color: rgb(0, 0, 0) !important;" style="color: rgb(0, 0, 0) !important; box-sizing: border-box;">Highfields Level 2 Certificate in Digital Skills</span></li><li data-css="tve-u-16f8a5891e5" fr-original-style=" color: rgb(135, 145, 152);" style="color: rgb(135, 145, 152); box-sizing: border-box;"><div data-css="tve-u-17298e4b524" fr-original-style="" style="box-sizing: border-box;"></div><span data-css="tve-u-17298e4b503" fr-original-style=" color: rgb(0, 0, 0) !important;" style="color: rgb(0, 0, 0) !important; box-sizing: border-box;">180 - 270 hours</span></li></ul></div></div></div></div></div></div></div></div></div></div></div></div></div></div>

£ Enquire
Highfields Level 2 Certificate in Digital Skills
180 - 270 hours

Digital Skills Certificate, Level 2

<div data-css="tve-u-17298e4b573" fr-original-style=" color: rgb(0, 0, 0);" id="isPasted" style="color: rgb(0, 0, 0); box-sizing: border-box;"><div data-css="tve-u-1788d4b1ad3" fr-original-style="" style="box-sizing: border-box;"><div data-css="tve-u-17298e4b574" fr-original-style=" color: rgb(0, 0, 0);" id="isPasted" style="color: rgb(0, 0, 0); box-sizing: border-box;"><div data-css="tve-u-1788d4b25a5" fr-original-style="" style="box-sizing: border-box;"><div data-css="tve-u-17298e4b572" fr-original-style=" color: rgb(0, 0, 0);" id="isPasted" style="color: rgb(0, 0, 0); box-sizing: border-box;"><div data-css="tve-u-17298e4b56c" fr-original-style="" style="box-sizing: border-box;"><div data-css="tve-u-1788d4b2e7e" fr-original-style="" style="box-sizing: border-box;"><div data-css="tve-u-17298e4b573" fr-original-style=" color: rgb(0, 0, 0);" id="isPasted" style="color: rgb(0, 0, 0); box-sizing: border-box;"><div data-css="tve-u-17298e4b56e" fr-original-style="" style="box-sizing: border-box;"><div data-css="tve-u-172e1d96552" fr-original-style=" color: rgb(0, 0, 0);" id="isPasted" style="color: rgb(0, 0, 0); box-sizing: border-box;"><div data-css="tve-u-17298e4b572" fr-original-style=" color: rgb(0, 0, 0);" id="isPasted" style="color: rgb(0, 0, 0); box-sizing: border-box;"><div data-css="tve-u-17298e4b56c" fr-original-style="" style="box-sizing: border-box;"><div data-css="tve-u-172e1d94e31" fr-original-style="" style="box-sizing: border-box;"><div data-css="tve-u-17298e4b56e" fr-original-style=" color: rgb(0, 0, 0);" id="isPasted" style="color: rgb(0, 0, 0); box-sizing: border-box;"><div data-css="tve-u-17298e4b572" fr-original-style=" color: rgb(0, 0, 0);" id="isPasted" style="color: rgb(0, 0, 0); box-sizing: border-box;"><div data-css="tve-u-17298e4b56c" fr-original-style="" style="box-sizing: border-box;"><div data-css="tve-u-17298e4b56b" fr-original-style="" style="box-sizing: border-box;"><p data-css="tve-u-17298e4b576" fr-original-style=" color: rgb(34, 177, 77) !important;" style="color: rgb(34, 177, 77) !important; font-size: 16px; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&pound; Enquire</strong></p></div></div></div><div data-css="tve-u-17298e4b520" data-icon-code="icon-check" fr-original-style=" color: rgb(0, 0, 0);" style="color: rgb(0, 0, 0); box-sizing: border-box;"><ul fr-original-style="" style="box-sizing: border-box;"><li data-css="tve-u-16f8a5891e5" fr-original-style=" color: rgb(135, 145, 152);" style="color: rgb(135, 145, 152); box-sizing: border-box;"><div data-css="tve-u-17298e4b524" fr-original-style="" style="box-sizing: border-box;"></div><span data-css="tve-u-17298e4b503" fr-original-style=" color: rgb(0, 0, 0) !important;" style="color: rgb(0, 0, 0) !important; box-sizing: border-box;">Highfield Functional Skills Qualification in Mathematics, level 1</span></li><li data-css="tve-u-16f8a5891e5" fr-original-style=" color: rgb(135, 145, 152);" style="color: rgb(135, 145, 152); box-sizing: border-box;"><div data-css="tve-u-17298e4b524" fr-original-style="" style="box-sizing: border-box;"></div><span data-css="tve-u-17298e4b503" fr-original-style=" color: rgb(0, 0, 0) !important;" style="color: rgb(0, 0, 0) !important; box-sizing: border-box;">45 - 50 hours</span></li></ul></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>

£ Enquire
Highfield Functional Skills Qualification in Mathematics, level 1
45 - 50 hours

Functional Skills

Maths

Functional Skills in Maths, Level 1

<div data-css="tve-u-17298e4b573" fr-original-style=" color: rgb(0, 0, 0);" id="isPasted" style="color: rgb(0, 0, 0); box-sizing: border-box;"><div data-css="tve-u-1788d4b1ad3" fr-original-style="" style="box-sizing: border-box;"><div data-css="tve-u-17298e4b574" fr-original-style=" color: rgb(0, 0, 0);" id="isPasted" style="color: rgb(0, 0, 0); box-sizing: border-box;"><div data-css="tve-u-1788d4b25a5" fr-original-style="" style="box-sizing: border-box;"><div data-css="tve-u-17298e4b572" fr-original-style=" color: rgb(0, 0, 0);" id="isPasted" style="color: rgb(0, 0, 0); box-sizing: border-box;"><div data-css="tve-u-17298e4b56c" fr-original-style="" style="box-sizing: border-box;"><div data-css="tve-u-1788d4b2e7e" fr-original-style="" style="box-sizing: border-box;"><div data-css="tve-u-17298e4b573" fr-original-style=" color: rgb(0, 0, 0);" id="isPasted" style="color: rgb(0, 0, 0); box-sizing: border-box;"><div data-css="tve-u-17298e4b56e" fr-original-style="" style="box-sizing: border-box;"><div data-css="tve-u-172e1d96552" fr-original-style=" color: rgb(0, 0, 0);" id="isPasted" style="color: rgb(0, 0, 0); box-sizing: border-box;"><div data-css="tve-u-17298e4b572" fr-original-style=" color: rgb(0, 0, 0);" id="isPasted" style="color: rgb(0, 0, 0); box-sizing: border-box;"><div data-css="tve-u-17298e4b56c" fr-original-style="" style="box-sizing: border-box;"><div data-css="tve-u-172e1d94e31" fr-original-style="" style="box-sizing: border-box;"><div data-css="tve-u-17298e4b56e" fr-original-style=" color: rgb(0, 0, 0);" id="isPasted" style="color: rgb(0, 0, 0); box-sizing: border-box;"><div data-css="tve-u-17298e4b572" fr-original-style=" color: rgb(0, 0, 0);" id="isPasted" style="color: rgb(0, 0, 0); box-sizing: border-box;"><div data-css="tve-u-17298e4b56c" fr-original-style="" style="box-sizing: border-box;"><div data-css="tve-u-17298e4b56b" fr-original-style="" style="box-sizing: border-box;"><div data-css="tve-u-17298e4b573" fr-original-style=" color: rgb(0, 0, 0);" id="isPasted" style="color: rgb(0, 0, 0); box-sizing: border-box;"><div data-css="tve-u-17298e4b56e" fr-original-style="" style="box-sizing: border-box;"><p data-css="tve-u-17298e4b577" fr-original-style=" color: rgb(34, 177, 77) !important;" style="color: rgb(34, 177, 77) !important; font-size: 16px; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&pound; Enquire</strong></p></div></div><div data-css="tve-u-17298e4b51f" data-icon-code="icon-check" fr-original-style=" color: rgb(0, 0, 0);" style="color: rgb(0, 0, 0); box-sizing: border-box;"><ul fr-original-style="" style="box-sizing: border-box;"><li data-css="tve-u-16f8a5891e5" fr-original-style=" color: rgb(135, 145, 152);" style="color: rgb(135, 145, 152); box-sizing: border-box;"><div data-css="tve-u-17298e4b524" fr-original-style="" style="box-sizing: border-box;"></div><span data-css="tve-u-17298e4b503" fr-original-style=" color: rgb(0, 0, 0) !important;" style="color: rgb(0, 0, 0) !important; box-sizing: border-box;">Highfield Functional Skills Qualification in Mathematics, level 2</span></li><li data-css="tve-u-16f8a5891e5" fr-original-style=" color: rgb(135, 145, 152);" style="color: rgb(135, 145, 152); box-sizing: border-box;"><div data-css="tve-u-17298e4b524" fr-original-style="" style="box-sizing: border-box;"></div><span data-css="tve-u-17298e4b503" fr-original-style=" color: rgb(0, 0, 0) !important;" style="color: rgb(0, 0, 0) !important; box-sizing: border-box;">45 - 50 hours</span></li></ul></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>

£ Enquire
Highfield Functional Skills Qualification in Mathematics, level 2
45 - 50 hours

Functional Skills in Maths, level 2

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>This course is designed for software developers, testers, and architects who design and develop software in various programming languages and platforms, including desktop, web, cloud, and mobile, and who want to improve their ability to deliver software that is of high quality, particularly regarding security and privacy.<br />This course is also designed for students who are seeking the CertNexus Cyber Secure Coder (CSC) Exam CSC-210 certification</p>Overview<p>In this course, you will employ best practices in software development to develop secure software.You will:<br />Identify the need for security in your software projects.<br />Eliminate vulnerabilities within software.<br />Use a Security by Design approach to design a secure architecture for your software.<br />Implement common protections to protect users and data.<br />Apply various testing methods to find and correct security defects in your software.<br />Maintain deployed software to ensure ongoing security...</p><p>The stakes for software security are very high, and yet many development teams deal with software security only after the code has been developed and the software is being prepared for delivery. As with any aspect of software quality, to ensure successful implementation, security and privacy issues should be managed throughout the entire software development lifecycle. <br />This course presents an approach for dealing with security and privacy throughout the entire software development lifecycle. You will learn about vulnerabilities that undermine security, and how to identify and remediate them in your own projects. You will learn general strategies for dealing with security defects and misconfiguration, how to design software to deal with the human element in security, and how to incorporate security into all phases of development.<br /></p></div><div id="course-pills-2"><h4>Identifying the Need for Security in Your Software Projects</h4><ul><li>Identify Security Requirements and Expectations</li><li>Identify Factors That Undermine Software Security</li><li>Find Vulnerabilities in Your Software</li><li>Gather Intelligence on Vulnerabilities and Exploits</li></ul><h4>Handling Vulnerabilities</h4><ul><li>Handle Vulnerabilities Due to Software Defects and Misconfiguration</li><li>Handle Vulnerabilities Due to Human Factors</li><li>Handle Vulnerabilities Due to Process Shortcomings</li></ul><h4>Designing for Security</h4><ul><li>Apply General Principles for Secure Design</li><li>Design Software to Counter Specific Threats</li></ul><h4>Developing Secure Code</h4><ul><li>Follow Best Practices for Secure Coding</li><li>Prevent Platform Vulnerabilities</li><li>Prevent Privacy Vulnerabilities</li></ul><h4>Implementing Common Protections</h4><ul><li>Limit Access Using Login and User Roles</li><li>Protect Data in Transit and At Rest</li><li>Implement Error Handling and Logging</li><li>Protect Sensitive Data and Functions</li><li>Protect Database Access</li></ul><h4>Testing Software Security</h4><ul><li>Perform Security Testing</li><li>Analyze Code to find Security Problems</li><li>Use Automated Testing Tools to Find Security Problems</li></ul><h4>Maintaining Security in Deployed Software</h4><ul><li>Monitor and Log Applications to Support Security</li><li>Maintain Security after Deployment</li></ul></div>

Duration
3 Days
18 CPD hours
This course is intended for
This course is designed for software developers, testers, and architects who design and develop software in various programming languages and platforms, including desktop, web, cloud, and mobile, and who want to improve their ability to deliver software that is of high quality, particularly regarding security and privacy.
This course is also designed for students who are seeking the CertNexus Cyber Secure Coder (CSC) Exam CSC-210 certification
Overview
In this course, you will employ best practices in software development to develop secure software.You will:
Identify the need for security in your software projects.
Eliminate vulnerabilities within software.
Use a Security by Design approach to design a secure architecture for your software.
Implement common protections to protect users and data.
Apply various testing methods to find and correct security defects in your software.
Maintain deployed software to ensure ongoing security...
The stakes for software security are very high, and yet many development teams deal with software security only after the code has been developed and the software is being prepared for delivery. As with any aspect of software quality, to ensure successful implementation, security and privacy issues should be managed throughout the entire software development lifecycle. 
This course presents an approach for dealing with security and privacy throughout the entire software development lifecycle. You will learn about vulnerabilities that undermine security, and how to identify and remediate them in your own projects. You will learn general strategies for dealing with security defects and misconfiguration, how to design software to deal with the human element in security, and how to incorporate security into all phases of development.

Identifying the Need for Security in Your Software Projects
Identify Security Requirements and Expectations
Identify Factors That Undermine Software Security
Find Vulnerabilities in Your Software
Gather Intelligence on Vulnerabilities and Exploits
Handling Vulnerabilities
Handle Vulnerabilities Due to Software Defects and Misconfiguration
Handle Vulnerabilities Due to Human Factors
Handle Vulnerabilities Due to Process Shortcomings
Designing for Security
Apply General Principles for Secure Design
Design Software to Counter Specific Threats
Developing Secure Code
Follow Best Practices for Secure Coding
Prevent Platform Vulnerabilities
Prevent Privacy Vulnerabilities
Implementing Common Protections
Limit Access Using Login and User Roles
Protect Data in Transit and At Rest
Implement Error Handling and Logging
Protect Sensitive Data and Functions
Protect Database Access
Testing Software Security
Perform Security Testing
Analyze Code to find Security Problems
Use Automated Testing Tools to Find Security Problems
Maintaining Security in Deployed Software
Monitor and Log Applications to Support Security
Maintain Security after Deployment

Nexus Human

Certified in Cybersecurity (CC)

Certificate in Information Security Management Principles (CISMP)

Cyber Security

Cyber Security Foundation

Certified Cyber Professional (CCP)

CompTIA Security+

CertNexus Certified Cyber Secure Coder (CSC-210)

London

<article id="cincluded">
					<div>
						<h5>SQL Course Summary.</h5>
					</div>
					<div></div>
					<p>
						
						<br />Practical SQL course, to leavy you full conversant with queries, DML and DDL statements.
						<br />Hands-on, Practical SQL course. 
						<br />PCWorkshops SQL Course Certificate.
						<br />Max 4 people per course, we keep it personalised. 
						
				  	</p>
	    		</article>

<div id="#">
							<div>
								<h5>Where is the SQL Course?</h5>
							</div>
							<article>
								<div>
								<ul>  
									 <li><b>Online: </b>Instructor-led.</li>
									 <li><b>Classroom: </b>Request per email.</li> 
								</ul>
								</div>
							</article>
						</div>
						
					   	<div id="#">
							<div>
								<h5>SQL Course Materials</h5>
							</div>
							<article>
								<div>
								<ul>  
									 <li><b>SQL Coding Examples </b>   </li>
									 <li><b>SQL Course Manuals and Notes: </b>In-depth reference materials </li>
									 <li><b>Exercises:</b> Practical exercises  </li> 
								</ul>
								</div>
							</article>
						</div>
						 
						
						<div id="#">
							<div>
								<h5>Payment Options</h5>
							</div>
							<article>
								<div>
								<ul>
									<li>→  £750, Follow the booking link </li>	 
									<li>Arrange for installments</li>
								</ul>
								</div>
							</article>
						</div>
						
						<div id="#">
							<div>
								<h5>Included with SQL Course:</h5>
							</div>
							<article>
								<div>
								<ul>
									<li>SQL Course Certificate on completion.
									</li><li>SQL Course Manual.
									</li><li>Practical SQL Course exercises, SQL Code Samples/ SQL Course Revision work.
									</li><li>After the course, 1 free session for questions.
									</li><li>Max group size, online and in classroom, on this SQL Course is 4.</li>
								</ul>
								</div>
							</article>
						</div>
						

			   	<div id="cdetails">
					<div>
						<h5>Course Details</h5>
					</div>
					<article>
						<div>
							<h5>SQL Intermediate Course summary</h5>
						</div>
						<div></div>
						<div>
					 	<ul>
					    	 <br /><br /><b><li>DAY 1:</li></b>
						    <li><b>Session 1: </b>Database Concepts
							 
							<br />What is a database? 
							<br />Tables, rows and columns, Indexes, primary keys, unique constraints and foreign keys, Client-Server architecture, Supported data types, table types,. The Information_Schema

							</li>	<li><b>Session 2: </b>Using the SQL client
							SQL Getting started and Logging in, Selecting a database, 
							Client commands, Entering and executing SQL statements, 
							Retrieving previous commands, Creating, editing and executing SQL files, Redirecting output into a file, 
							Command line execution of SQL Scripts

							</li><li><b>Session 3: </b>Basic SQL SELECT statement
							<br />The SQL SELECT statement, Case sensitivity, Quotes, Statement terminator, Syntax conventions.  
							<br />Conditions and the WHERE clause, Boolean operators (AND and OR) and SQL conditional operators.
							<br />Column aliases.
							<br />Arithmetic expressions.
							<br />Null functions ('IS NULL,' 'IS NOT NULL,' , "Isnull",'Coalesce').
							<br />The ORDER BY clause.
							
							
							</li><li><b>Session 4:</b> 
							<br />LIMIT / TOP  and Distinct Queries 
							<br />SQL AGGREGATE Functions (Sum, Average, Maximum, Minimum, Count),
							<br />Group By, 
							<br />Rollup with Group By, 
							<br />Having.
							</li>
							<li><b>Session 5:</b> Joins
							<br />SQL Cartesian products.
							<br />SQL Joins (Inner join, Left join, Right join, Full join).
							<br />Table aliases.
							<br />Natural joins, Multi-table joins.
							<br />Union, Union All queries.
							<br />Except/Minus, Simulating join with Intersect.
							</li>
							<br /><br /><b><li>DAY 2:</li></b>
							<li><b>Session 6:</b>
							<br />SQL Subqueries, Nested Subqueries, 
							<br />Correlated and uncorrelated subqueries. 
							<br />Global and Local Temp Tables.
							</li>
							<li><b>Session 7:</b>
							SQL Built-in Functions: <br />Numeric Functions (ABS, SIGN, MOD, etc.)
							<br />and String Functions (Locate, Left, Right, Concat, etc),
							<br />DATE and TIME functions.
							</li>
							<li><b>Session 8:</b>
							SQL Views (Create, alter and drop), 
							<br />Stored Procedures (Create, alter and drop, Input and Output parameters);
							<br /> Custom Functions (Create, alter and drop).
							</li>
							<br /><br /><b><li>DAY 3:</li></b>
							<li><b>
							Session 9: </b>Managing Data
							<br />Inserting rows, Replacing rows, Updating rows, Deleting rows,
<br />							The truncate statement, 
<br />The COMMIT and ROLLBACK commands, Savepoints, Implicit commits.
							</li>
							<li><b>
							Session 10:</b>
							SQL Indexes (Create, alter and drop).
							</li>
							<li><b>
							Session 11:</b>
							<br />Creating Databases and Tables (Create, alter and drop); <br />Constraints (Add, alter and drop).
							</li>
							<li><b>
							Session 12:</b>
							<br />Import data into SQL and Export from SQL.
							<br />Exporting using SQL, Importing using SQL.
														</li> 
							
							
						</ul>
						</div>
					</article>
				</div>

		<div> 
						 

						
				     
	                  <div></div>
 		</div>
	                
				     
				   <div id="booking">
	                  <div>
	                     <h5>Book the SQL Course</h5>
	                  </div>
							 
							 
<div id="eventbrite-widget-container-12009778571"></div>




					 
							 
							 
	               </div>
				   <div id="#">
	                  <div>
	                     <h5>About us</h5>
	                  </div>



	                  	<article>
					    <div>
					    	<div>
					    		<div>
					    			
					    			<h5>Our experienced trainers are award winners. </h5> 
					    			<ul>
										<li>
											More about us
										</li>
										<li>
											FAQ's
										</li>
										<li>
											Client Comments  
										</li>
										<li>
										<div id="LTF_ST_7KBtchhl8SMxqQ8TquAE3BxAGh2waJl4jxQdXEubLKJcmvn6ak"></div>
										</li>	
									 </ul>
					    		</div>
					    		<div>
					    			
					    				
					    			
					    		</div>
					    	</div>
	                     
					    </div>
					    </article>						
	               </div>

SQL Course Intermediate 
 
This Practical SQL course, is designed make you fully conversant with queries, DML and DDL statements.  Hands-on, Practical SQL course.  
You will get the PCWorkshops SQL Course Certificate. 
Max 4 people per course, to keep it personalised. 
Where is the SQL Course?
Online: Instructor-led.
Classroom: Request per email.
SQL Course Materials
SQL Coding Examples
SQL Course Manuals and Notes: In-depth reference materials
Exercises: Practical exercises
Included with SQL Intermediate Course:
SQL Course Certificate on completion.
SQL Course Manual.
Practical SQL Course exercises, SQL Code Samples/ SQL Course Revision work.
After the course, 1 free session for questions.
Max group size, online and in classroom, on this SQL Course is 4.
SQL Intermediate Course summary
DAY 1:
Session 1: Database Concepts 
What is a database? 
Tables, rows and columns, Indexes, primary keys, unique constraints and foreign keys, Client-Server architecture, Supported data types, table types,. The Information_Schema
Session 2: Using the SQL client SQL Getting started and Logging in, Selecting a database, Client commands, Entering and executing SQL statements, Retrieving previous commands, Creating, editing and executing SQL files, Redirecting output into a file, Command line execution of SQL Scripts
Session 3: Basic SQL SELECT statement 
The SQL SELECT statement, Case sensitivity, Quotes, Statement terminator, Syntax conventions. 
Conditions and the WHERE clause, Boolean operators (AND and OR) and SQL conditional operators. 
Column aliases. 
Arithmetic expressions. 
Null functions ('IS NULL,' 'IS NOT NULL,' , "Isnull",'Coalesce'). 
The ORDER BY clause.
Session 4: 
LIMIT / TOP and Distinct Queries 
SQL AGGREGATE Functions (Sum, Average, Maximum, Minimum, Count), 
Group By, 
Rollup with Group By, 
Having.
Session 5: Joins 
SQL Cartesian products. 
SQL Joins (Inner join, Left join, Right join, Full join). 
Table aliases. 
Natural joins, Multi-table joins. 
Union, Union All queries. 
Except/Minus, Simulating join with Intersect.
DAY 2:
Session 6: 
SQL Subqueries, Nested Subqueries, 
Correlated and uncorrelated subqueries. 
Global and Local Temp Tables.
Session 7: SQL Built-in Functions: 
Numeric Functions (ABS, SIGN, MOD, etc.) 
and String Functions (Locate, Left, Right, Concat, etc), 
DATE and TIME functions.
Session 8: SQL Views (Create, alter and drop), 
Stored Procedures (Create, alter and drop, Input and Output parameters); 
 Custom Functions (Create, alter and drop).
DAY 3:
Session 9: Managing Data 
Inserting rows, Replacing rows, Updating rows, Deleting rows,

 The truncate statement, 
The COMMIT and ROLLBACK commands, Savepoints, Implicit commits.
Session 10: SQL Indexes (Create, alter and drop).
Session 11: 
Creating Databases and Tables (Create, alter and drop); 
Constraints (Add, alter and drop).
Session 12: 
Import data into SQL and Export from SQL. 
Exporting using SQL, Importing using SQL.
 
About us

Our SQL Intermediate trainers are experienced award winners.
13 years in business
We keep it practical and customised

Oracle SQL

Azure SQL Database

Microsoft SQL Server

Microsoft SQL

Database Programming

Computer Skills

SQL Server

MySQL

This Practical SQL course, is designed make you fully conversant with queries, DML and DDL statements.  Hands-on, Practical SQL course.  
You will get the PCWorkshops SQL Course Certificate. 
Max 4 people per course, to keep it personalised. 

SQL Intermediate Course, 3 Days

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p>This course is intended for business users who have been using Power BI to build analytic solutions and are ready to take advantage of the power and flexibility that DAX provides. Learning DAX is a very common 'next step' for experienced Power BI users.</p>Overview<p>At course completion, you should be able to<br />describe DAX syntax, data types, and errors<br />use DAX to create calculated columns, measures, and tables<br />explain how DAX calculations are evaluated, along with the differences between row context and filter context<br />configure and use Time Intelligence to perform common time-based calculations, for example to-date calculations, year-over-year analysis, moving averages, etc.<br />create calculated columns and measures that use data from multiple tables in the data model<br />write measures that handle error conditions gracefully<br />use DAX to enhance the Power BI user experience<br />use DAX Studio to connect to a Power BI data model and execute simple queries</p><p>Welcome to Introduction to DAX for Power BI. This two-day instructor-led course is intended for business users who have been using Power BI and want to use DAX to create custom calculations in their data models. In this class, you will be introduced to using Data Analysis Expressions (DAX), which is the expression language that is used to create custom calculations in the Power BI Data model. The course covers some of the theoretical underpinnings of the data model and the DAX language, but the emphasis is on using DAX to solve common business problems. You will learn how to write your own calculated columns, measures, and tables, how to visualize the way Power BI computes DAX calculations, and how to troubleshoot custom code.</p></div><div id="course-pills-2"><h4>MODULE 1: GETTING STARTED WITH DAX </h4><ul><li>INTRODUCTION TODAX </li><li>CREATING OBJECTS WITHDAX </li><li>CONTEXT AND RULES OF EVALUATION</li><li>VARIABLES,COMMENTS,AND TESTING</li></ul><h4>MODULE 2: PERFORMING BASIC CALCULATIONS</h4><ul><li>GETTING STARTED</li><li>IMPLICIT MEASURES </li><li>ADDING QUICK MEASURES </li><li>WORKING WITH DAX DATA TYPES .</li><li>DOING BASIC MATH </li><li>USING LOGIC IN YOUR CALCULATIONS </li><li>USING THE IF() FUNCTION </li><li>NESTED IF()</li><li>USING THE SWITCH() FUNCTION </li><li>ADVANCED SWITCH()</li><li>LOGICAL OPERATORS &amp; FUNCTIONS: ||, OR(), &amp;&amp;, AND(), NOT()</li><li>AGGREGATING AND SUMMARIZING DATA </li><li>THE SUM() FUNCTION</li></ul><h4>MODULE 3: WORKING WITH CONTEXT IN THE DATA MODEL </h4><ul><li>CONTEXT DEFINED </li><li>DATA MODELING BASICS </li><li>INTRODUCTION TO DIMENSIONAL MODELING </li><li>RELATIONSHIPS AND THEIR EFFECT ON THE EVALUATION CONTEXT </li><li>GETTING DATA FROM OTHER TABLES USING RELATED() AND RELATEDTABLE</li><li>LOOKING UP DATA WITHOUT USING RELATIONSHIPS </li><li>MODIFYING THE CONTEXT USING CALCULATE()</li></ul><h4>MODULE 4: PERFORMING MORE ADVANCED CALCULATIONS </h4><ul><li>THE DAX ITERATOR FUNCTIONS </li><li>USING TABLE MANIPULATION FUNCTIONS</li></ul><h4>MODULE 5: WORKING WITH TIME</h4><ul><li>PERFORMING DATE CALCULATIONS </li><li>WORKING WITH DATE TABLES </li><li>GENERATING A DATE TABLE WITH THE CALENDAR() FUNCTION </li><li>DEFINING CUSTOM OPERATING PERIODS </li><li>YTD, QTD, AND MTD CALCULATIONS </li><li>CUSTOM TO-DATE CALCULATIONS </li><li>FINDING YEAR-OVER-YEAR CHANGE </li><li>FINDING MOVING AVERAGES </li></ul><h4>MODULE 6: ENHANCING THE USER EXPERIENCE</h4><ul><li>CONTROLLING VISIBILITYOF YOUR MEASURES</li><li>USING WHAT-IF PARAMETERS </li><li>ADDING BANDING </li><li>USING DAX TO PROVIDE ROW-LEVEL SECURITY </li></ul></div>

Duration
2 Days
12 CPD hours
This course is intended for
This course is intended for business users who have been using Power BI to build analytic solutions and are ready to take advantage of the power and flexibility that DAX provides. Learning DAX is a very common 'next step' for experienced Power BI users.
Overview
At course completion, you should be able to
describe DAX syntax, data types, and errors
use DAX to create calculated columns, measures, and tables
explain how DAX calculations are evaluated, along with the differences between row context and filter context
configure and use Time Intelligence to perform common time-based calculations, for example to-date calculations, year-over-year analysis, moving averages, etc.
create calculated columns and measures that use data from multiple tables in the data model
write measures that handle error conditions gracefully
use DAX to enhance the Power BI user experience
use DAX Studio to connect to a Power BI data model and execute simple queries
Welcome to Introduction to DAX for Power BI. This two-day instructor-led course is intended for business users who have been using Power BI and want to use DAX to create custom calculations in their data models. In this class, you will be introduced to using Data Analysis Expressions (DAX), which is the expression language that is used to create custom calculations in the Power BI Data model. The course covers some of the theoretical underpinnings of the data model and the DAX language, but the emphasis is on using DAX to solve common business problems. You will learn how to write your own calculated columns, measures, and tables, how to visualize the way Power BI computes DAX calculations, and how to troubleshoot custom code.
MODULE 1: GETTING STARTED WITH DAX
INTRODUCTION TODAX
CREATING OBJECTS WITHDAX
CONTEXT AND RULES OF EVALUATION
VARIABLES,COMMENTS,AND TESTING
MODULE 2: PERFORMING BASIC CALCULATIONS
GETTING STARTED
IMPLICIT MEASURES
ADDING QUICK MEASURES
WORKING WITH DAX DATA TYPES .
DOING BASIC MATH
USING LOGIC IN YOUR CALCULATIONS
USING THE IF() FUNCTION
NESTED IF()
USING THE SWITCH() FUNCTION
ADVANCED SWITCH()
LOGICAL OPERATORS & FUNCTIONS: ||, OR(), &&, AND(), NOT()
AGGREGATING AND SUMMARIZING DATA
THE SUM() FUNCTION
MODULE 3: WORKING WITH CONTEXT IN THE DATA MODEL
CONTEXT DEFINED
DATA MODELING BASICS
INTRODUCTION TO DIMENSIONAL MODELING
RELATIONSHIPS AND THEIR EFFECT ON THE EVALUATION CONTEXT
GETTING DATA FROM OTHER TABLES USING RELATED() AND RELATEDTABLE
LOOKING UP DATA WITHOUT USING RELATIONSHIPS
MODIFYING THE CONTEXT USING CALCULATE()
MODULE 4: PERFORMING MORE ADVANCED CALCULATIONS
THE DAX ITERATOR FUNCTIONS
USING TABLE MANIPULATION FUNCTIONS
MODULE 5: WORKING WITH TIME
PERFORMING DATE CALCULATIONS
WORKING WITH DATE TABLES
GENERATING A DATE TABLE WITH THE CALENDAR() FUNCTION
DEFINING CUSTOM OPERATING PERIODS
YTD, QTD, AND MTD CALCULATIONS
CUSTOM TO-DATE CALCULATIONS
FINDING YEAR-OVER-YEAR CHANGE
FINDING MOVING AVERAGES
MODULE 6: ENHANCING THE USER EXPERIENCE
CONTROLLING VISIBILITYOF YOUR MEASURES
USING WHAT-IF PARAMETERS
ADDING BANDING
USING DAX TO PROVIDE ROW-LEVEL SECURITY

Powerbi

Business Analytics & Intelligence

Microsoft Power BI

Excel Analytics

Data Analysis Expressions

Data Skills

Introduction to DAX for Power BI

<article>
<div>
<h5>Java EVENINGS Course</h5>
</div>
<div></div>
<p>  						 
	</p><div>
	<ul>
		<p>
		<b>Python EVENINGS Course. </b>Basic Python syntax and principles of Object Orientated Programming. 
		<br />Most attendees are in-work IT Professional.
		<br />Private individuals are also very welcome. 
		<br />Evening courses also running.
		<br /><b>Our Style: </b>Hands-on, Practical  
		<br /><b>Location:  </b>Online, Instructor-led  
		<br /><b>Download:  </b>anaconda.com
		<br /><b>Duration:  </b>6 weeks, 1 evening per week, 6pm - 8pm
		<br /><b>Times: </b>arrange a time for your time zone
	    </p>
	</ul>	

<p></p>
</div></article>

<div>
	  <div>
		 <h5>Python Basics EVENINGS Course </h5>
	  </div>
	  <div></div>
	  <p> 
 
				This Python course London Evening covers the essential Python Basics, in our interactive, instructor led Live Virtual Classroom.
				This Python Basics course is a very good introduction to essential fundamental programming concepts using Python as programming language.
				These concepts are daily used by programmers and is your first step to working as a programmer.
				By the end, you'll be comfortable in programming Python code.
				You will have done small projects.
				This will serve for you as examples and samples that you can use to build larger projects.
				You can publish your code online to keep as a portfolio.

<br />
This Python Programming course is hands-on and practical, to give you in-depth, practical experience of the topics covered.

	  </p>
	<div>
	<h5>Week 1: Basics</h5>
	</div>
	<div></div>
	<div> 
					<p>  <strong>Python Data Types and Variables:</strong>  
					<br />  Primitive types; Characters &amp; Strings; Boolean; Working with variables and its scope; Conversion and casting types in Python.	 
					<br /> <strong>Operators and Expressions: </strong>   
					<br />  Introduction of operators; Arithmetic operators; Relational operators; Assignment operator; Logical operators; Increment and decrement operators.
					</p> 
			 
				<p><strong> Decision Making:</strong>
				<br />If statement; If - else statement; If- elif - else statement; Nested if - else.
				</p><p><strong>Using Loops:</strong>
				<br />The while, while-else.
				<br />For loop;
				<br />Jump statements: break, continue;
				<br />Nesting loops.				
				</p>
			</div>
	<div>
	<h5>Week 2: Data Structures</h5>
	</div> <div></div>
	<div> 
				<p> Lists.
					<br />Tuples.
					<br />Sets.
					<br />Dictionary. Nested Dictionary.
					<br />Json Files.
				</p>
			</div>
	<div>
	<h5>Week 3: Python built-in functions</h5>
	</div> <div></div>
	<div> 
				<p>  
				<br />Using Built-in modules and functions:
				<br />Strings Functions.
				<br />Pattern matching with Regex.
				<br />Maths Functions.
				<br />Random Functions.
				<br />Python Date functions.
				</p>
			</div>
	<div>
	<h5>Week 4: OOP: Using Modules, functions, classes</h5>
	</div> <div></div>
	<div>
				<p>  Creating and using custom Functions.
					<br />Creating functions;
					<br />Using parameters and return values;
					<br />
					<br />Introduction to Classes and Objects:
					<br />Creating a Class; 
					<br />Creating an Object; Using an Object; 
					<br />Adding Instance variables; Controlling accessibility; Naming conventions for class members. 
					<br /> Class Constructors; Parameterized Constructors.
					<br />Inheritance. Overload.
				</p>
			</div>

	<div>
	<h5>Week 5: Pandas DataBase Basics</h5>
	</div> <div></div>
	<div>	 
		<p> <b>Connection details:</b>
				Connect to a database using access codes. 
				<br /><b>Select Queries:</b>
				Retrieving records and iterating results sets, using variables and parameters in queries. 
				<br />Working with DDL comands:
				Create a database, drop a database.
				Create a table, alter tables, drop a table. 
				<br />Working with DML Commands:
				Insert, delete, update records.
		</p>
	</div>
	
	 
	<div>
	<h5>Week 6: Pandas Dataframe Basics</h5>
	</div> <div></div>
	<div>	 
		<p> Getting data into a dataframe:
			<br />Dict to Dataframe, Dataframe to Dict.
			<br />Excel To Dict, Dict to Excel , working with Excel data, multiple Excel sheets.

			<br />Dataframe basics:
			<br />Slicing Dataframes,
			<br />Getting information about the dataframe,
			<br />Filter, sort and query a Dataframes,
			<br />Duplicate values,
			<br />Working with null-values,
			<br />Sampling,
			<br />Group by,
			<br />Join.

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

<div>   

	   <div id="cincluded">
		  <div>
			 <h5>What is included</h5>
		  </div>

		  <article>
		  <div>
			 <ul>
				<li>PCWorkshops Course Certificate on completion  </li>
									   
				<li>Python Course Notes</li>
				<li>Python Code Examples</li>
				<li>Practical Python Course exercises and Code Samples</li>
				<li>After the course: 1-Hour personalised online revision session</li>
			 </ul>
		  </div>
		  </article>
	   </div>
				    
<div>
	                  <div>
	                     <h5 id="cincluded2">Book the Python  Course</h5>
	                  </div>
 
<div id="eventbrite-widget-container-60636103217"></div>




							 
</div>
				   <div id="caboutus">
	                  <div>
	                     <h5>About us</h5>
	                  </div> 
	                  	<article>
					    <div>
					    	<div>
					    		<div>
					    			
					    			<h5>Our experienced trainers are award winners. </h5> 
					    			<ul>
										<li>
											More about us
										</li>
										<li>
											FAQ's
										</li>
										<li>
											Client Comments  
										</li>
									 </ul>
					    		</div>
					    		<div>
					    			
					    				
					    			
					    		</div>
					    	</div>
	                     
					    </div>
					    </article>						
	               </div>
				   
				   
	        </div>

Python EVENINGS Course
Basic Python syntax and principles of object-oriented programming. 
Most attendees are in-work IT Professional. 
Private individuals are also very welcome. 
Evening courses also running. 

Details:
Our Style: Hands-on, Practical 
Location: Online, Instructor-led 
Download: anaconda.com 
Duration: 4 weeks, 1 evening per week, 6pm - 8pm 
Times: arrange a time for your time zone 
How to attend:  
Connection Link For the course: https://meet.goto.com/910697125
Once you have made the payment, use the above link on the date booked, to connect with the trainer. 
Python Basics EVENINGS Course
 This Python course London Evening covers the essential Python Basics, in our interactive, instructor led Live Virtual Classroom. This Python Basics course is a very good introduction to essential fundamental programming concepts using Python as programming language. These concepts are daily used by programmers and is your first step to working as a programmer. By the end, you'll be comfortable in programming Python code. You will have done small projects. This will serve for you as examples and samples that you can use to build larger projects. You can publish your code online to keep as a portfolio. 

This Python Programming course is hands-on and practical, to give you in-depth, practical experience of the topics covered. 
Week 1: Basics
 Python Data Types and Variables: 
Primitive Data types; Working with variables and its scope; Conversion and casting types in Python. 
 Operators and Expressions:  
 Introduction of operators; Arithmetic operators; Relational operators; Assignment operator; Logical operators; Increment and decrement operators. 
 Decision Making: 
If statement; If - else statement; If- elif - else statement; Nested if - else. 
Using Loops: 
The while, while-else. 
For loop; 
Jump statements: break, continue; 
Nesting loops. 
Week 2: Data Structures & Database
Lists.  
Tuples. 
Sets. 
Dictionary. Nested Dictionary. 
Json Files. 
Reading csv and text files
Connecting with a database and run SQL Queries. 
Week 3: Python built-in functions &  Pandas Dataframe Basics
 
Using built-in modules and functions: 
Strings Functions. 
Maths Functions. 
Random Functions. 
Data Frames; 
Getting data into a dataframe: 
Dict to Dataframe, Dataframe to Dict.  
Dataframe basics: 
Slicing Dataframes, 
Getting information about the dataframe, 
Filter and query a Dataframes, 
Working with null-values.
Week 4: OOP: Using Modules, functions, classes
 Creating and using custom Functions. 
Creating functions; 
Using parameters and return values; 
 
Introduction to Classes and Objects: 
Creating a Class; 
Creating an Object; Using an Object; 
Adding instance variables; controlling accessibility; and naming conventions for class members. 
 Class Constructors; Parameterized Constructors. 
Inheritance. Overload. 

What is included
PCWorkshops Course Certificate on completion
Python Course Notes
Python Code Examples
Practical Python Course exercises and Code Samples
After the course: 1-Hour personalised online revision session
  

Online Course Creation

Professional Skills Course (PSC)

Instructor

Python

Basic Python syntax and principles of Object Orientated Programming. 
Most attendees are in-work IT Professional. 
Private individuals are also very welcome. 
Evening courses also running. 
Our Style: Hands-on, Practical 
Location: Online, Instructor-led 
Download: anaconda.com 
Duration: 6 weeks, 1 evening per week, 6pm - 8pm 
Times: arrange a time for your time zone 

Python EVENINGS Course, Online Instructor-led

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p></p><p>The audience for this course are data professionals and business intelligence professionals who want to learn how to accurately perform data analysis using Power BI. This course is also targeted toward those individuals who develop reports that visualize data from the data platform technologies that exist on both in the cloud and on-premises.</p><p></p><p></p><p>This course covers the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will show how to access and process data from a range of data sources including both relational and non-relational sources. Finally, this course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution.</p><p></p>Prerequisites<p></p><li>Understanding core data concepts.</li>  <li>Knowledge of working with relational data in the cloud.</li>  <li>Knowledge of working with non-relational data in the cloud.</li>   <li>Knowledge of data analysis and visualization concepts.</li>   <li>DP-900T00 Microsoft Azure Data Fundamentals is recommended<p></p></li></div><div id="course-pills-2"><h3>1 - Discover data analysis</h3> <ul> <li>Overview of data analysis</li> <li>Roles in data</li> <li>Tasks of a data analyst</li> </ul> <h3>2 - Get started building with Power BI</h3> <ul> <li>Use Power BI</li> <li>Building blocks of Power BI</li> <li>Tour and use the Power BI service</li> </ul> <h3>3 - Get data in Power BI</h3> <ul> <li>Get data from files</li> <li>Get data from relational data sources</li> <li>Create dynamic reports with parameters</li> <li>Get data from a NoSQL database</li> <li>Get data from online services</li> <li>Select a storage mode</li> <li>Get data from Azure Analysis Services</li> <li>Fix performance issues</li> <li>Resolve data import errors</li> </ul> <h3>4 - Clean, transform, and load data in Power BI</h3> <ul> <li>Shape the initial data</li> <li>Simplify the data structure</li> <li>Evaluate and change column data types</li> <li>Combine multiple tables into a single table</li> <li>Profile data in Power BI</li> <li>Use Advanced Editor to modify M code</li> </ul> <h3>5 - Design a semantic model in Power BI</h3> <ul> <li>Work with tables</li> <li>Create a date table</li> <li>Work with dimensions</li> <li>Define data granularity</li> <li>Work with relationships and cardinality</li> <li>Resolve modeling challenges</li> </ul> <h3>6 - Add measures to Power BI Desktop models</h3> <ul> <li>Create simple measures</li> <li>Create compound measures</li> <li>Create quick measures</li> <li>Compare calculated columns with measures</li> </ul> <h3>7 - Add calculated tables and columns to Power BI Desktop models</h3> <ul> <li>Create calculated columns</li> <li>Learn about row context</li> <li>Choose a technique to add a column</li> </ul> <h3>8 - Use DAX time intelligence functions in Power BI Desktop models</h3> <ul> <li>Use DAX time intelligence functions</li> <li>Additional time intelligence calculations</li> </ul> <h3>9 - Optimize a model for performance in Power BI</h3> <ul> <li>Review performance of measures, relationships, and visuals</li> <li>Use variables to improve performance and troubleshooting</li> <li>Reduce cardinality</li> <li>Optimize DirectQuery models with table level storage</li> <li>Create and manage aggregations</li> </ul> <h3>10 - Design Power BI reports</h3> <ul> <li>Design the analytical report layout</li> <li>Design visually appealing reports</li> <li>Report objects</li> <li>Select report visuals</li> <li>Select report visuals to suit the report layout</li> <li>Format and configure visualizations</li> <li>Work with key performance indicators</li> </ul> <h3>11 - Configure Power BI report filters</h3> <ul> <li>Apply filters to the report structure</li> <li>Apply filters with slicers</li> <li>Design reports with advanced filtering techniques</li> <li>Consumption-time filtering</li> <li>Select report filter techniques</li> <li>Case study - Configure report filters based on feedback</li> </ul> <h3>12 - Enhance Power BI report designs for the user experience</h3> <ul> <li>Design reports to show details</li> <li>Design reports to highlight values</li> <li>Design reports that behave like apps</li> <li>Work with bookmarks</li> <li>Design reports for navigation</li> <li>Work with visual headers</li> <li>Design reports with built-in assistance</li> <li>Tune report performance</li> <li>Optimize reports for mobile use</li> </ul> <h3>13 - Perform analytics in Power BI</h3> <ul> <li>Explore statistical summary</li> <li>Identify outliers with Power BI visuals</li> <li>Group and bin data for analysis</li> <li>Apply clustering techniques</li> <li>Conduct time series analysis</li> <li>Use the Analyze feature</li> <li>Create what-if parameters</li> <li>Use specialized visuals</li> </ul> <h3>14 - Create and manage workspaces in Power BI</h3> <ul> <li>Distribute a report or dashboard</li> <li>Monitor usage and performance</li> <li>Recommend a development life cycle strategy</li> <li>Troubleshoot data by viewing its lineage</li> <li>Configure data protection</li> </ul> <h3>15 - Manage semantic models in Power BI</h3> <ul> <li>Use a Power BI gateway to connect to on-premises data sources</li> <li>Configure a semantic model scheduled refresh</li> <li>Configure incremental refresh settings</li> <li>Manage and promote semantic models</li> <li>Troubleshoot service connectivity</li> <li>Boost performance with query caching (Premium)</li> </ul> <h3>16 - Create dashboards in Power BI</h3> <ul> <li>Configure data alerts</li> <li>Explore data by asking questions</li> <li>Review Quick insights</li> <li>Add a dashboard theme</li> <li>Pin a live report page to a dashboard</li> <li>Configure a real-time dashboard</li> <li>Set mobile view</li> </ul> <h3>17 - Implement row-level security</h3> <ul> <li>Configure row-level security with the static method</li> <li>Configure row-level security with the dynamic method</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans PL-300T00: Microsoft Power BI Data Analyst training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the PL-300T00: Microsoft Power BI Data Analyst course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Duration
3 Days
18 CPD hours
This course is intended for

The audience for this course are data professionals and business intelligence professionals who want to learn how to accurately perform data analysis using Power BI. This course is also targeted toward those individuals who develop reports that visualize data from the data platform technologies that exist on both in the cloud and on-premises.


This course covers the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will show how to access and process data from a range of data sources including both relational and non-relational sources. Finally, this course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution.

Prerequisites

Understanding core data concepts.
Knowledge of working with relational data in the cloud.
Knowledge of working with non-relational data in the cloud.
Knowledge of data analysis and visualization concepts.
DP-900T00 Microsoft Azure Data Fundamentals is recommended
1 - Discover data analysis
Overview of data analysis
Roles in data
Tasks of a data analyst
2 - Get started building with Power BI
Use Power BI
Building blocks of Power BI
Tour and use the Power BI service
3 - Get data in Power BI
Get data from files
Get data from relational data sources
Create dynamic reports with parameters
Get data from a NoSQL database
Get data from online services
Select a storage mode
Get data from Azure Analysis Services
Fix performance issues
Resolve data import errors
4 - Clean, transform, and load data in Power BI
Shape the initial data
Simplify the data structure
Evaluate and change column data types
Combine multiple tables into a single table
Profile data in Power BI
Use Advanced Editor to modify M code
5 - Design a semantic model in Power BI
Work with tables
Create a date table
Work with dimensions
Define data granularity
Work with relationships and cardinality
Resolve modeling challenges
6 - Add measures to Power BI Desktop models
Create simple measures
Create compound measures
Create quick measures
Compare calculated columns with measures
7 - Add calculated tables and columns to Power BI Desktop models
Create calculated columns
Learn about row context
Choose a technique to add a column
8 - Use DAX time intelligence functions in Power BI Desktop models
Use DAX time intelligence functions
Additional time intelligence calculations
9 - Optimize a model for performance in Power BI
Review performance of measures, relationships, and visuals
Use variables to improve performance and troubleshooting
Reduce cardinality
Optimize DirectQuery models with table level storage
Create and manage aggregations
10 - Design Power BI reports
Design the analytical report layout
Design visually appealing reports
Report objects
Select report visuals
Select report visuals to suit the report layout
Format and configure visualizations
Work with key performance indicators
11 - Configure Power BI report filters
Apply filters to the report structure
Apply filters with slicers
Design reports with advanced filtering techniques
Consumption-time filtering
Select report filter techniques
Case study - Configure report filters based on feedback
12 - Enhance Power BI report designs for the user experience
Design reports to show details
Design reports to highlight values
Design reports that behave like apps
Work with bookmarks
Design reports for navigation
Work with visual headers
Design reports with built-in assistance
Tune report performance
Optimize reports for mobile use
13 - Perform analytics in Power BI
Explore statistical summary
Identify outliers with Power BI visuals
Group and bin data for analysis
Apply clustering techniques
Conduct time series analysis
Use the Analyze feature
Create what-if parameters
Use specialized visuals
14 - Create and manage workspaces in Power BI
Distribute a report or dashboard
Monitor usage and performance
Recommend a development life cycle strategy
Troubleshoot data by viewing its lineage
Configure data protection
15 - Manage semantic models in Power BI
Use a Power BI gateway to connect to on-premises data sources
Configure a semantic model scheduled refresh
Configure incremental refresh settings
Manage and promote semantic models
Troubleshoot service connectivity
Boost performance with query caching (Premium)
16 - Create dashboards in Power BI
Configure data alerts
Explore data by asking questions
Review Quick insights
Add a dashboard theme
Pin a live report page to a dashboard
Configure a real-time dashboard
Set mobile view
17 - Implement row-level security
Configure row-level security with the static method
Configure row-level security with the dynamic method
Additional course details:
Nexus Humans PL-300T00: Microsoft Power BI Data Analyst training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. 

This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts.

Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.

While we feel this is the best course for the PL-300T00: Microsoft Power BI Data Analyst course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.

Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.


Microsoft Power Platform

Microsoft BI

Data Analyst

PL-300T00 Microsoft Power BI Data Analyst

<article>
<div>
<h5>Learn SQL Course, 1-Day</h5>
</div>
<div></div>
<p>  						 
	</p><div>
	<ul>
		<p>
		<b>SQL Queries Course, 1-Day. </b>Basic SQL syntax. 
		<br />Most attendees are in-work IT Professional.
		<br />Private individuals are also very welcome. 
		<br />Evening courses also running.
		<br /><b>Our Style: </b>Hands-on, Practical  
		<br /><b>Location:  </b>Online, Instructor-led  
		<br /><b>Download:  </b>anaconda.com
		<br /><b>Duration:  </b>6 weeks, 1 evening per week, 6pm - 8pm
		<br /><b>Times: </b>arrange a time for your time zone
	    </p>
	</ul>	

<p></p>
</div></article>

<div>
	  <div>
		 <h5>Learn SQL Course, 1-Day</h5>
	  </div>
	  <div></div>
	  <p> With SQL Queries, you could learn SQL in a day, and master the basics of SQL, get interesting, insightful and essential business intelligence from data by using SQL queries on this SQL Course London, UK. 
	  <br />Queries are made easy and simple, saving hours of online training.
 
		<br />This 1 Day course is packed with power query techniques.

<br /><br />This SQL Introduction Course is hands-on, practical with many excellent query examples.
<br /><br />This course is Platform Independent.
<br /><br />This SQL course is hands-on and practical, to give you in-depth, practical experience of the topics covered.
<br /><br />Ask your SQL questions in small, friendly classroom SQL Course. 
<br /><br />Online, Instructor-led, Interactive, full screen sharing.

	  </p>
	<div>
	<h5> Learn SQL Relational Database Concepts:</h5>
	</div>
	<div></div>
	<div> 
					<p>  <strong>Database:</strong>  
					<br />What is a Relational Database?
<br />Tables, Rows and Columns
<br />Indexes, Primary Keys and Foreign Keys
<br />Data Types  
					</p> 
			 
				 
			</div>
	<div>
	<h5>Learn SQL Essentials:</h5>
	</div> <div></div>
	<div> 
				<p> <strong>Basics.</strong>
					<br />SQL Language Essentials:
<br />The SQL Select Statement, the Where Clause, SQL Order By Clause, Working with Null Values
<br />SQL Arithmetic Operations, Expression Queries
<br />SQL Column Aliases
<br />Limit/Top, Distinct

				 
				</p>
			</div>
	<div>
	<h5>Summarizing and Grouping Data:</h5>
	</div> <div></div>
	<div> 
				<p>  <strong>Group by</strong>
				<br />
Aggregate Functions (Sum, Avg, Count, Max, Min)
<br />The Group By Clause
<br />The Having Clause
				 
				</p>
			</div>
	<div>
	<h5>Querying Multiple Tables:</h5>
	</div> <div></div>
	<div>
				<p>   <strong>Joins</strong>
					<br />
Joining Tables
<br />Inner Joins, Outer Joins, Self Joins, Full Joins, 
<br />Cross Joins
<br />Alternative Join Syntax
				</p>
			</div>

	 
	
	 
	<div>
	<h5>Basic Subqueries</h5>
	</div> 
	<div></div>
	<div>	 
		<p> <strong>Sub-queries</strong>
			<br />Basics of CTE tables
			<br />SQL subqueries 
			<br />Using subqueries in the from clause
			<br />Using subqueries in the where clause
			<br />Using subqueries in the select clause
			<br />Using subqueries in the having clause 
			
		</p>
	</div>
	<div>
	<h5>Combine Queries</h5>
	</div> 
	<div></div>
	<div>	 
		<p> <strong>Combine Queries</strong>
			<br />The Union Operator
			<br /> Intersect and Minus Operators
			<br /> Simulating combine Intersect and Minus queries by using sub-queries
					   

			 

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

<div>   

	   <div id="cincluded">
		  <div>
			 <h5>What is included</h5>
		  </div>

		  <article>
		  <div>
			 <ul>
				<li>PCWorkshops Course Certificate on completion  </li>
									   
				<li>SQL Course Notes</li>
				<li>SQL Code Examples</li>
				<li>Practical SQL Course exercises and Code Samples</li>
				<li>After the course: 1-Hour personalised online revision session</li>
			 </ul>
		  </div>
		  </article>
	   </div>
				    
<div>
	                  <div>
	                     <h5 id="cincluded2">Book the SQL Course</h5>
	                  </div>
 
	 
 <div id="eventbrite-widget-container-100389112538"></div>




									
					
					 
</div>
				   <div id="caboutus">
	                  <div>
	                     <h5>About us</h5>
	                  </div> 
	                  	<article>
					    <div>
					    	<div>
					    		<div>
					    			
					    			<h5>Our experienced trainers are award winners. </h5> 
					    			<ul>
										<li>
											More about us
										</li>
										<li>
											FAQ's
										</li>
										<li>
											Client Comments  
										</li>
										<li>
										<div id="LTF_ST_m8v4lCcicRynaFxnT4tD2JOVCitkIkMwzh0sIQRc9Toth01PZo"></div>
										</li>	
									 </ul>
					    		</div>
					    		<div>
					    			
					    				
					    			
					    		</div>
					    	</div>
	                     
					    </div>
					    </article>						
	               </div>
				   
				   
	        </div>

Learn SQL Course, 1-Day
This SQL course is platform independent.
SQL Queries Course, 1-Day. Basic SQL syntax.  This course is good for any database, covering standard SQL. Most attendees are in-work IT Professional. 
Private individuals are also very welcome. 
Evening courses also running. 

Details
Our Style: Hands-on, Practical 
Location: Online, Instructor-led 
Download: anaconda.com 
Duration: 6 weeks, 1 evening per week, 6pm - 8pm 
Times: arrange a time for your time zone 
Join us on your booked dates on https://meet.goto.com/910697125
Learn SQL Course, 1-Day Online Instructor-led
With SQL Queries, you could learn SQL in a day, and master the basics of SQL, and get interesting, insightful, and essential business intelligence from data by using SQL queries on this SQL Course in London, UK. 
Queries are made easy and simple, saving hours of online training. 
This 1 Day course is packed with power query techniques. 

This SQL Introduction Course is hands-on, practical with many excellent query examples.
This SQL course is hands-on and practical to give you in-depth, practical experience of the topics covered.
Ask your SQL questions in a small, friendly classroom SQL course. 

Learn SQL. Relational Database Concepts:
 Database: 
What is a Relational Database?

Tables, Rows and Columns

Indexes, Primary Keys and Foreign Keys

Data Types 
Learn SQL Essentials:
 Basics. 
SQL Language Essentials:

The SQL Select Statement, the Where Clause, SQL Order By Clause, Working with Null Values

SQL Arithmetic Operations, Expression Queries

SQL Column Aliases

Limit/Top, Distinct 
Summarizing and Grouping Data:
 Group by 

Aggregate Functions (Sum, Avg, Count, Max, Min)

The Group By Clause

The Having Clause 
Querying Multiple Tables:
 Joins 

Joining Tables

Inner Joins, Outer Joins, Self Joins, Full Joins, 
Cross Joins

Alternative Join Syntax 
Basic Subqueries
 Sub-queries 
Basics of CTE tables 
SQL subqueries 
Using subqueries in the from clause 
Using subqueries in the where clause 
Using subqueries in the select clause 
Using subqueries in the having clause 
 
 Combine Queries 
The Union Operator 
 Intersect and Minus Operators 
 Simulating combined Intersect and Minus queries by using sub-queries 

What is included
PCWorkshops Course Certificate on completion
SQL Course Notes
SQL Code Examples
Practical SQL Course exercises and Code Samples
After the course: 1-Hour personalised online revision session
  



IT Skills

SQL Queries Course, 1-Day. Basic SQL syntax.  This course is good for any database, covering standard SQL. Most attendees are in-work IT Professional. 
Private individuals are also very welcome. 

Learn SQL Basics, 1-day Course, Online Instructor-Led

<article id="cincluded">
					<div>
						<h5>SQL Advanced Course Summary.</h5>
					</div>
					<div></div>
					<p>
						
						<br />Practical SQL Advanced Intensive Course
						, exploring the advanced and less commonly used SQL Statements and techniques.
						<br />We also learn Data Definition Language and Data Manipulation Language statements, 
						<br />as well as course automation of queries using T-SQL.
						<br />Hands-on, Practical SQL Advanced Course. 
						<br />PCWorkshops SQL Advanced Course Certificate.
						<br />Max 4 people per course, we keep it personalised. 
						
				  	</p>
	    		</article>

<div id="#">
							<div>
								<h5>Where is the SQL Advanced Course?</h5>
							</div>
							<article>
								<div>
								<ul>  
									 <li><b>Online: </b>Instructor-led.</li>
									 <li><b>Classroom: </b>Request per email.</li> 
								</ul>
								</div>
							</article>
						</div>
						
					   	<div id="#">
							<div>
								<h5>SQL Advanced Course Materials</h5>
							</div>
							<article>
								<div>
								<ul>  
									 <li><b>SQL Coding Examples </b>   </li>
									 <li><b>Manuals and Notes: </b>In-depth reference materials </li>
									 <li><b>Exercises:</b> Practical exercises  </li> 
								</ul>
								</div>
							</article>
						</div>
						 
						
						<div id="#">
							<div>
								<h5>Payment for SQL Course Advanced </h5>
							</div>
							<article>
								<div>
								<ul>
									<li>→  £600, Follow the booking link </li>	 
									<li>Arrange for installments</li>
								</ul>
								</div>
							</article>
						</div>
						
						<div id="#">
							<div>
								<h5>Included with SQL Advanced Course:</h5>
							</div>
							<article>
								<div>
								<ul>
									<li>SQL Advanced Course Certificate on completion.
									</li><li>SQL Advanced Course Manual.
									</li><li>Practical SQL Advanced Course exercises
									</li><li>SQL Code Samples.
									</li><li>After the course, 1 free session for questions.
									</li><li>Max group size, online and in classroom, on this SQL Advanced Course is 4.</li>
								</ul>
								</div>
							</article>
						</div>
						

			   	<div id="cdetails">
					<div>
						<h5>SQL Course Advanced Topics</h5>
					</div>
					<article>
						<div>
							<h5>SQL ADVANCED COURSE TOPICS</h5>
						</div>
						<div></div>
						<div>
					 	<ul>
					    	<li>Database Concepts Revision:
								<br />What is a database, Tables, rows and columns, Indexes, primary keys, foreign keys,

								</li><li>SQL Sub-queries:

								<br />·Sub-queries in the WHERE, SELECT, From or Having clauses
								<br />·Using SOME, ALL, ANY and IN clauses in the Where Clause <br />·Self-contained sub-queries
								<br />·Correlated sub-queries
								<br />·Sub-queries with the EXISTS predicate

								</li><li>Derived Tables and CTEs:
								<br />·Using SQL derived tables
								<br />·SQL Common Table Expressions (CTEs)
								<br />·Recursive CTEs

								</li><li>Views:
								<br />Create, alter and drop Views, Indexes

								</li><li>SQL Stored Procedure Basics:
								<br />·Stored Procedure Principles
								<br />·Creating stored procedures
								<br />·Executing stored procedures
								<br />·System stored procedures

								</li><li>Variables:
								<br />·Declaring variables
								<br />·SET versus SELECT
								<br />Parameters and Return Values
								<br />·Passing parameters
								<br />·Default values and WHERE clauses
								<br />·Output parameters
								<br />·Using RETURN
								<br />·Testing Conditions
								<br />·The IF/ELSE statement
								<br />·CASE
								<br />·CHOOSE

								</li><li>Looping:
								<br />·Syntax of SQL WHILE
								<br />·Breaking out of a loop
								<br />·Basic transactions
								<br />·Beginning a transaction
								<br />·Committing/rolling back
								<br />·Deleting and updating
								<br />·Using DELETE and UPDATE
								<br />·Sys.Objects
								<br />·Dropping objects

								</li><li>User defined Functions:
								<br />Table Valued Functions
								<br />·In-line table-valued functions
								<br />·Multi- Statement table-valued functions
								<br />·Limitations of user-defined functions
								<br />Scalar Functions
								<br />·What are scalar functions?
								<br />·Some examples
								<br />·Disadvantages of scalar functions
								<br />·Three advantages

								</li><li>Cursors:
								<br />·Syntax of fetching rows
								<br />·When to use (and when not to)

								</li><li>Triggers:
								<br />·Create or replace triggers

								</li><li>Creating Tables in SQL:

								<br />·Create, alter and drop Tables
								<br />·Inserting values, single rows and multiple rows using queries
								</li><li>Constraints:
								<br />·Not Null, Unique,Default,Check,Primary Key,Foreign Key,Identity / Auto-increments

								</li><li>Sequencing
								</li><li>Indexes

								</li><li>SQL Temporary Tables and Table Variables:
								<br />·Create and use SQL temporary tables
								<br />·Create and use SQL table variables
								<br />·SQL Tables vs. Table Variables

								</li><li>Error-Handling:
								<br />·SQL TRY/CATCH
								<br />·SQL System error functions
								<br />·Customizing SQL error messages
								<br />·@@ error function

								</li><li>Debugging:
								<br />·The SQL Server debugger, Debugging (breakpoints, etc.)
							
							 
							
							</li>
						</ul>
						</div>
					</article>
				</div>

		<div> 
						 

						
				     
	                  <div></div>
 		</div>
	                
				     
				   <div id="booking">
	                  <div>
	                     <h5>BOOK THE SQL Course Advanced COURSE</h5> 
	                  </div>
							 
							 <div id="eventbrite-widget-container-48063008753"></div>




					 
	               </div>
				   <div id="#">
	                  <div>
	                     <h5>About SQL Course Advanced</h5>
	                  </div>



	                  	<article>
					    <div>
					    	<div>
					    		<div>
					    			
					    			<h5>Our experienced trainers are award winners. </h5> 
					    			<ul>
										<li>
											More about us
										</li>
										<li>
											FAQ's
										</li>
										<li>
											Client Comments  
										</li>
									 </ul>
					    		</div>
					    		<div>
					    			
					    				
					    			
					    		</div>
					    	</div>
	                     
					    </div>
					    </article>						
	               </div>

SQL Advanced Course 
 
Practical SQL Advanced Intensive Course , exploring the advanced and less commonly used SQL Statements and techniques. 
We also learn Data Definition Language and Data Manipulation Language statements, 
as well as course automation of queries using T-SQL. 
Hands-on, Practical SQL Advanced Course. 
PCWorkshops SQL Advanced Course Certificate. 
Max 4 people per course; we keep it personalised. 
Where is the SQL Advanced Course?
Online: Instructor-led.
Classroom: Request per email.
SQL Advanced Course Materials
SQL Coding Examples
Manuals and Notes: In-depth reference materials
Exercises: Practical exercises
 
Included with SQL Advanced Course:
SQL Advanced Course Certificate on completion.
SQL Advanced Course Manual.
Practical SQL Advanced Course exercises
SQL Code Samples.
After the course, 1 free session for questions.
Max group size, online and in classroom, on this SQL Advanced Course is 4.
SQL Course Advanced Topics
SQL ADVANCED COURSE TOPICS
Database Concepts Revision: 
What is a database, Tables, rows and columns, Indexes, primary keys, foreign keys,
SQL Sub-queries: 
·Sub-queries in the WHERE, SELECT, From or Having clauses 
·Using SOME, ALL, ANY and IN clauses in the Where Clause 
·Self-contained sub-queries 
·Correlated sub-queries 
·Sub-queries with the EXISTS predicate
Derived Tables and CTEs: 
·Using SQL derived tables 
·SQL Common Table Expressions (CTEs) 
·Recursive CTEs
Views: 
Create, alter and drop Views, Indexes
SQL Stored Procedure Basics: 
·Stored Procedure Principles 
·Creating stored procedures 
·Executing stored procedures 
·System stored procedures
Variables: 
·Declaring variables 
·SET versus SELECT 
Parameters and Return Values 
·Passing parameters 
·Default values and WHERE clauses 
·Output parameters 
·Using RETURN 
·Testing Conditions 
·The IF/ELSE statement 
·CASE 
·CHOOSE
Looping: 
·Syntax of SQL WHILE 
·Breaking out of a loop 
·Basic transactions 
·Beginning a transaction 
·Committing/rolling back 
·Deleting and updating 
·Using DELETE and UPDATE 
·Sys.Objects 
·Dropping objects
User defined Functions: 
Table Valued Functions 
·In-line table-valued functions 
·Multi- Statement table-valued functions 
·Limitations of user-defined functions 
Scalar Functions 
·What are scalar functions? 
·Some examples 
·Disadvantages of scalar functions 
·Three advantages
Cursors: 
·Syntax of fetching rows 
·When to use (and when not to)
Triggers: 
·Create or replace triggers
Creating tables in SQL: 
·Create, alter and drop Tables 
·Inserting values, single rows and multiple rows using queries
Constraints: 
·Not Null, Unique,Default, Check,Primary Key,Foreign Key,Identity / Auto-increments
Sequencing
Indexes
SQL Temporary Tables and Table Variables 
·Create and use SQL temporary tables 
·Create and use SQL table variables 
·SQL Tables vs. Table Variables
Error-Handling: 
·SQL TRY/CATCH 
·SQL System error functions 
·Customizing SQL error messages 
·@@ error function
Debugging: 
·The SQL Server debugger, Debugging (breakpoints, etc.)

About SQL Course Advanced
Our experienced trainers are award winners.
More about us
FAQ's
Client Comments

Practical SQL Advanced Intensive Course , exploring the advanced and less commonly used SQL Statements and techniques. 
We also learn Data Definition Language and Data Manipulation Language statements. 
as well as course automation of queries using T-SQL. 
Hands-on, Practical SQL Advanced Course. 
PCWorkshops SQL Advanced Course Certificate. 
Max 4 people per course; we keep it personalised. 

SQL Course Advanced, 2 Days

<div>
	                  <h5>Oracle SQL Fundamentals Course Summary</h5>
	               </div>
	               <div></div>
	               <p> 
				   
				  At this Oracle SQL Fundamentals couse, we cover SQL  queries, group by's , aggregates, joins, date-functions, String Functions, Random Functions, Math Functions, Insert, update and delete, Creating and changing tables, sub-queries in detail, views, stored procedures, custom funtions, table variables.		  
					<br />Course level is beginners to intermediate.
				   
					 
					 
					 
				  </p>
				   
				   
	               <div>
	                  <div>
	                     <h5>Oracle SQL Fundamentals Course Outline</h5>
	                  </div>
	                  <div></div>
	                   
	    <div>
			<strong>Session 1: Database Concepts Revision: </strong> 
			 <p>  What is a database, Tables, rows and columns, Indexes, primary keys, foreign keys,
	 
			</p>
		</div>
		<div>
			<strong>Session 2: </strong>  
			<p> 	
			</p><ul>
			<li>
			  The SQL SELECT statement:WHERE clause, Boolean operators (AND and OR) and SQL conditional operators (=,!=,smaller and bigger than ,IN, and BETWEEN).The ORDER BY clause, Column aliases, LIMIT  TOP, Distinct 
			</li>
			</ul> 
			<p></p>
		</div>	 
		<div>
			<strong>Session 3:</strong>  
			<p> 
			</p><li> Expression queries: Arithmetic expressions, Null functions ('IS NULL,' 'IS NOT NULL,' , 'Coalesce')

			</li>
			<p></p>
		</div>	
	 
		<div>
			<strong>Session 4: </strong>  
			<p></p><ul>
				<li>SQL AGGERGATE Functions: Sum, Average, Maximum, Minimum, Count, Group By, Having.
				</li> 
				</ul>
			<p></p>
		</div>	
	 
		<div>
			<strong>Session 5:</strong>  
			<p></p><ul> <li> Joins: SQL Cartesian products, 
			 </li><li>SQL Joins (Inner join, Left join, Right join, Full join
			 </li><li>Table aliases, Natural joins, Multi-table joins. 
			 </li><li>Union, Union All, Except, Intersect
			 </li></ul>
			<p></p>
		</div>	
		<div>
			<strong>Session 6:</strong>  
			<p></p><ul> <li>
			Sub-queries: SQL Subqueries, Nested Subqueries, 
			</li><li>'WITH AS',
			</li><li>			Correlated and uncorrelated subqueries.  
			 </li></ul>
			<p></p>
		</div>

		<div>
			<strong>Session 7:</strong>  
			<p></p><ul> <li>
			 Numeric Functions, 
			 </li><li>String Functions, 
			</li><li>			 Date Functions
			Date, time and timezone support,  
			</li><li>Conversion and 
			</li><li>Formatting
			 </li></ul>
			<p></p>
		</div>
		<div>
			<strong>Session 8:</strong>  
			<p></p><ul> <li>
			SQL Views: Create, alter and drop Views 
			 </li></ul>
			<p></p>
		</div>
		<div>
			<strong>Session 9:</strong>  
			<p></p><ul> <li>
			Inserting rows, 
			</li><li>Replacing rows, 
			</li><li>Updating rows, 
			</li><li>Deleting rows
			 </li></ul>
			<p></p>
		</div>
		<div>
			<strong>Session 10:</strong>  
			<p></p><ul> <li>
			Session 10: Managing indexes 
			 </li></ul>
			<p></p>
		</div>
		<div>
			<strong>Session 11:</strong>  
			<p></p><ul> <li>
			 Creating Databases and 
			 </li><li>Creating Tables (Create, alter and drop); </li><li>Constraints (Add, alter and drop)  
			 </li><li>Temp tables
			</li><li>Managing sequences and synonyms 
			 </li></ul>
			<p></p>
		</div>
		<div>
					<strong>Session 12:</strong>  
					<p></p><ul> <li>
					 Import data into SQL and Export from SQL
					
					 </li></ul>
					<p></p>
		</div>		
		 
		 
		 
 
 
 
 
	               </div>
	               <div id="cincluded">
	                  <div>
	                     <h5>What is included in the SQL Advanced Course:</h5>
	                  </div>
	                  <div>
	                     <ul>
	                        <li>SQL Advanced Course Certificate on completion  </li>
	                        <li>SQL Advanced Course notes</li>
	                        <li>Practical SQL Course exercises, SQL Code Sample</li>
	                         
	                        <li>After the course, 1 free session for questions online SQL Course via Gotomeeting.com.</li>
	                        <li>Max group size, online and in classroom, on this SQL Course is 4. </li>
	                     </ul>
	                  </div>
	               </div>

Oracle SQL Fundamentals Course 
 At this Oracle SQL Fundamentals course, we cover SQL queries, group by's , aggregates, joins, date-functions, String Functions, Random Functions, Math Functions, Insert, update and delete, Creating and changing tables, sub-queries in detail, views, stored procedures, custom functions, and table variables. 
Course level is beginners to intermediate. 
Oracle SQL Fundamentals Course Outline
Session 1: Database Concepts Revision:
 What is a database? Tables, rows and columns, Indexes, primary keys, foreign keys, 
Session 2:
 The SQL SELECT statement: WHERE clause, Boolean operators (AND and OR), and SQL conditional operators (=,!=, smaller and bigger than, IN, and BETWEEN).The ORDER BY clause, Column aliases, LIMIT TOP, Distinct

Session 3:
Expression queries: Arithmetic expressions, Null functions ('IS NULL,' 'IS NOT NULL,' , 'Coalesce')

Session 4:
SQL AGGERGATE Functions: Sum, Average, Maximum, Minimum, Count, Group By, Having.

Session 5:
Joins: SQL Cartesian products,
SQL Joins (Inner join, Left join, Right join, Full join)
Table aliases, Natural joins, Multi-table joins.
Union, Union All, Except, Intersect

Session 6:

Sub-queries: SQL Subqueries, Nested Subqueries,
'WITH AS',
Correlated and uncorrelated subqueries.

Session 7:

Numeric Functions,
String Functions,
Date Functions Date, time and timezone support,
Conversion and
Formatting

Session 8:

SQL Views: Create, alter and drop Views

Session 9:

Inserting rows,
Replacing rows,
Updating rows,
Deleting rows

Session 10:

Session 10: Managing indexes

Session 11:

Creating Databases and
Creating Tables (Create, alter and drop);
Constraints (Add, alter and drop)
Temp tables
Managing sequences and synonyms

Session 12:

Import data into SQL and Export from SQL

What is included in the Oracle SQL Course:
Oracle SQL Course Certificate on completion
Oracle SQL Course notes
Practical Oracle SQL Course exercises, Oracle SQL Code Sample
After the course, 1 free session for questions online Oracle SQL Course 
Max group size, online and in classroom, on this Oracle SQL Course is 4.

Database Design & Development

Database Administration

 At this Oracle SQL Fundamentals course, we cover SQL queries, group by's , aggregates, joins, date-functions, String Functions, Random Functions, Math Functions, Insert, update and delete, Creating and changing tables, sub-queries in detail, views, stored procedures, custom functions, and table variables. 
Course level is beginners to intermediate. 

Oracle SQL Fundamentals, 3 Days

<p style="color: rgb(50, 74, 109); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(50, 74, 109);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Module 11</strong></p><p style="color: rgb(50, 74, 109); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(50, 74, 109);">This module aims to develop knowledge and understanding of the importance of customs documentation in the world of international trade to ensure both parties clearly understand the documentation that will be required in the import or export of goods or services. This includes evidence of delivery, proof payment, export and import documentation, customs clearance, intellectual property rights, mitigating risk and dispute resolution.</p><p style="color: rgb(50, 74, 109); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(50, 74, 109);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Agenda</strong></p><ul style="color: rgb(50, 74, 109); box-sizing: border-box;" fr-original-style=" color: rgb(50, 74, 109);"><li fr-original-style="" style="box-sizing: border-box;">Certificate of origin</li><li fr-original-style="" style="box-sizing: border-box;">Licences</li><li fr-original-style="" style="box-sizing: border-box;">Labelling</li><li fr-original-style="" style="box-sizing: border-box;">CMR</li><li fr-original-style="" style="box-sizing: border-box;">Proof of delivery</li><li fr-original-style="" style="box-sizing: border-box;">Certificate of origin</li><li fr-original-style="" style="box-sizing: border-box;">Health certificates</li><li fr-original-style="" style="box-sizing: border-box;">Proof of customs entry</li><li fr-original-style="" style="box-sizing: border-box;">Commodity codes</li><li fr-original-style="" style="box-sizing: border-box;">Certification</li><li fr-original-style="" style="box-sizing: border-box;">WTO</li><li fr-original-style="" style="box-sizing: border-box;">Chambers of commerce</li><li fr-original-style="" style="box-sizing: border-box;">International bodies</li></ul><p style="color: rgb(50, 74, 109); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(50, 74, 109);">&nbsp;</p><p style="color: rgb(50, 74, 109); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(50, 74, 109);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Examination:</strong><br fr-original-style="" style="box-sizing: border-box;">Certificate on completion and Pass on Multiple Choice<br fr-original-style="" style="box-sizing: border-box;">Multiple choice questionnaire<br fr-original-style="" style="box-sizing: border-box;">Credits: 1</p>

Module 11
This module aims to develop knowledge and understanding of the importance of customs documentation in the world of international trade to ensure both parties clearly understand the documentation that will be required in the import or export of goods or services. This includes evidence of delivery, proof payment, export and import documentation, customs clearance, intellectual property rights, mitigating risk and dispute resolution.
Agenda
Certificate of origin
Licences
Labelling
CMR
Proof of delivery
Certificate of origin
Health certificates
Proof of customs entry
Commodity codes
Certification
WTO
Chambers of commerce
International bodies
 
Examination:
Certificate on completion and Pass on Multiple Choice
Multiple choice questionnaire
Credits: 1

Documentary

International Trade

This module aims to develop knowledge and understanding of the importance of customs documentation in the world of international trade to ensure both parties clearly understand the documentation that will be required in the import or export of goods or services.

IMPORTANCE OF INTERNATIONAL DOCUMENTATION

<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p>Looking for a way to extend your business operations? Look no further than the App in a Day workshop!<br />In this one day course you will learn to build a custom, secure business application that you can share across your organise and will run across multiple platforms including tablets and mobile devices. Power Platform is a secure and scalable platform for building your own applications. In this course, you will learn how to build an application from the ground up by building the required UX, Backend, and frontend. All this without writing any code.</p>Overview<p>Some of the applications of the Power Platform you will learn to build will allow you to potentially:<br />A) Share information with trusted colleagues and associates<br />B) Monitor and manage your business operations<br />C) Monitor and manage your customers<br />D) Share business news on social media<br />E) Share business photos and footage</p><p>This course will teach you how to build your own application that is completely secure and private.</p></div><div id="course-pills-2"><h4>Power Apps Canvas App</h4><ul><li>Connect to data sources and filter results based on specified criteria</li><li>Work with screens and navigation</li><li>Use controls, properties, formulas, and actions to customize the user experience</li><li>Display the logged in user?s name</li><li>Configure app settings</li><li>Save and share an app</li><li>Run an app on a mobile device</li></ul><h4>Microsoft Dataverse</h4><ul><li>Create and customize a custom table</li><li>Use the Form control</li><li>Save data into the Microsoft Dataverse using the Form control</li></ul><h4>Microsoft Dataverse</h4><ul><li>Create a standalone Model-driven app.</li><li>Customize forms for the Model-driven app</li><li>Use a Business Process Flow to guide users through a process</li></ul><h4>Microsoft Dataverse</h4><ul><li>Create a flow that is triggered when a new Microsoft Dataverse row is created</li><li>Automate sending approval requests</li><li>Customize the approval based on the Microsoft Dataverse row</li><li>Use the Approval centre</li></ul></div>

Duration
1 Days
6 CPD hours
This course is intended for
Looking for a way to extend your business operations? Look no further than the App in a Day workshop!
In this one day course you will learn to build a custom, secure business application that you can share across your organise and will run across multiple platforms including tablets and mobile devices. Power Platform is a secure and scalable platform for building your own applications. In this course, you will learn how to build an application from the ground up by building the required UX, Backend, and frontend. All this without writing any code.
Overview
Some of the applications of the Power Platform you will learn to build will allow you to potentially:
A) Share information with trusted colleagues and associates
B) Monitor and manage your business operations
C) Monitor and manage your customers
D) Share business news on social media
E) Share business photos and footage
This course will teach you how to build your own application that is completely secure and private.
Power Apps Canvas App
Connect to data sources and filter results based on specified criteria
Work with screens and navigation
Use controls, properties, formulas, and actions to customize the user experience
Display the logged in user?s name
Configure app settings
Save and share an app
Run an app on a mobile device
Microsoft Dataverse
Create and customize a custom table
Use the Form control
Save data into the Microsoft Dataverse using the Form control
Microsoft Dataverse
Create a standalone Model-driven app.
Customize forms for the Model-driven app
Use a Business Process Flow to guide users through a process
Microsoft Dataverse
Create a flow that is triggered when a new Microsoft Dataverse row is created
Automate sending approval requests
Customize the approval based on the Microsoft Dataverse row
Use the Approval centre

190 Code courses in Manchester

CDS: NEW CUSTOMS FOR EXPORTS/IMPORTS

By Export Unlocked Limited

HACCP Trainer - Level 2 HACCP Training Course - On-site Nationwide

By Kitchen Tonic Training Company and Food Safety Consultants

Level 3 Award in Delivering Training

By Pochat Training

Java Basics Course, Manchester

By PCWorkshops

Digital Skills Certificate, Level 1

By Pochat Training

Digital Skills Award, Level 1

By Pochat Training

Digital Skills Award, Level 2

By Pochat Training

Digital Skills Certificate, Level 2

By Pochat Training

Functional Skills in Maths, Level 1

By Pochat Training

Functional Skills in Maths, level 2

By Pochat Training

Search By Location