26224 Courses in Cardiff delivered Online

Digital marketing is the component of marketing that uses the internet and online-based digital technologies such as desktop computers, mobile phones and other digital media and platforms to promote products and services. Stay relevant in a digital-centric world. From Google Ads to social media, SEO to strategy, the Complete Digital Marketing Diploma covers all the essentials of a well-rounded skill set.  Start your journey to becoming a certified digital marketing professional today.  Before moving on to websites, email marketing and copywriting, blogging, and SEO, you’ll learn to define your business and target demographic, as well as establish a brand identity that will resonate with your clients (search engine optimization). Following that is a comprehensive look at social media, which includes YouTube, Twitter, Instagram, Pinterest, LinkedIn, Periscope, and, of course, Facebook, which is divided into many divisions due to its importance. The training also covers social media live streaming and podcasting, as well as Google Analytics and Google Plus. Upon completion, you will gain a solid understanding of digital media and be able to apply the acquired knowledge in the real world either for your business or for your clients. Learning Outcomes Develop a comprehensive digital marketing strategy tailored to your business goals. Create and establish a strong brand identity across various digital platforms. Design and optimise websites for enhanced user experience and increased conversion rates. Execute effective email marketing campaigns to engage and nurture leads. Craft compelling copy and blogs that resonate with your target audience. Utilise video marketing techniques to captivate and engage online audiences. Harness the power of social media platforms like Facebook, Twitter, Instagram, and LinkedIn for marketing purposes. Implement Google AdWords campaigns to drive targeted traffic and increase sales. Analyse website and campaign performance using Google Analytics data to make data-driven decisions. Utilise emerging digital marketing channels like podcasting, live streaming, and Quora for brand promotion. Why choose this course Affordable, Accessible, informative and well-structured study materials Earn a globally recognised accredited qualification Study in your own time, at your own pace, through any device Benefit from feedback through mock exams and multiple-choice assessments Excellent career advancement/career switch opportunities Get 24/7 help or advice from our email and live chat teams Who is this course for Entrepreneurs looking to establish or expand their online presence and drive business growth. Small business owners aim to improve their digital marketing efforts and reach wider audiences. Marketing professionals seek to enhance their skills and stay updated with the latest trends in digital marketing. Freelancers interested in offering digital marketing services to clients and building a successful career in the field. Students pursuing degrees or certifications in marketing or related fields who want to gain practical digital marketing skills. Entry requirements This course is available to learners of all academic backgrounds, but you must be 16 or above to undertake the qualification. Apart from that, all you need is an internet connection, a good understanding of English and a passion for learning. Certification CPD Accredited Certificate After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Career path Digital Marketing Manager Social Media Manager SEO Specialist Content Marketing Manager Email Marketing Specialist PPC Specialist Digital Marketing Consultant Brand Manager Course Contents Introduction Define Your Business & Target Audience Brand Identity Websites Email Marketing Copywriting, Blogging & SEO YouTube Video Marketing Facebook Groups (Social Media Marketing) Facebook Pages (Social Media Marketing) Facebook Ads (Social Media Marketing) Facebook Retargeting (Social Media Marketing) Facebook For Local Business (Social Media Marketing) Google Adwords Twitter (Social Media Marketing) Instagram (Social Media Marketing) Pinterest (Social Media Marketing) LinkedIn (Social Media Marketing) Periscope (Social Media Marketing) Social Media Live Streaming Podcasting Quora Google Analytics Google Plus (Social Media Marketing) Conclusion

Do your inner guts tell you to pursue a career in the hairdresser industry? Have you spent a lot of time watching videos on hair designs? If you are one of them, the Hairdressing Training course is one of the best online hairdressing courses for you. In the UK, the hairdressing sector has grown 35%. Luckily, a hairdresser's average income is more than £25,000 annually, making it a lucrative career in the UK.  The first module of this CPD-accredited online hairdressing course focuses on the role of hairdressers and how it evolves with the trend. This module will educate you to assess the human skull so that you can create fabulous hairstyles for your clients. You will also explore versatile hair types like curly, straight, and wavy. It will help you to understand hair properties and the impact of specific hair types on hairstyling. The first module ends with introducing you to the hair salon equipment and furniture. The second module will teach you how to create sleek and timeless one-length hairstyles. Moreover, you will discover the hidden technique that leads to a smooth, balanced, uniform layer. Furthermore, the skills to add volume and texture to the long hair will also be introduced. With the completion of module three, you will become a master in cutting and styling curly hair and fringe hair. Module three of this online hairdresser course for beginners focuses on hair braiding. You will learn about multiple types of hair braids and their applications. Besides, an in-depth lesson on health and safety will help you to ensure a safe & hygienic salon environment for the clients. Get enrolled in this online hairdressing course with certificates for a secure future in the hairdressing industry. Learning Outcome Ability to identify versatile hair types and to recommend suitable styling & products Gain expertise in analysing face shape to provide top-notch hairstyles to enhance client's facial shape Achieve the skills to perform multiple hair cutting along with precisions Acquire the proficiency to create intricate braided hairstyles Learn salon safety & hygiene to ensure the healthy well-being of clients Capable of doing creative hair styling for clients Entry Requirement Passionate about hairdressing Basic academic knowledge Fast internet connection Smartphone/Laptop/PC Career path Professional Hair Stylist Salon Manager Freelance Hairdresser Hair Educator Fashion Stylist Product Sales Representative Course Curriculum Introduction to Hairdressing Who are Hairdressers? 00:15:00 Anatomy of the skull 00:15:00 Hair Type 00:15:00 Face shapes, Characteristics & Style concepts 00:15:00 Hair Salon Equipments & Furnitures 00:15:00 Hair Cutting Cutting the Hair 00:15:00 Cutting hair - One length hair 00:15:00 Cutting hair - Uniform Layer 00:15:00 Cutting hair - Short graduation 00:15:00 Cutting hair - Long graduation 00:15:00 Cutting hair - Curly hair 00:15:00 Cutting hair - Fringes 00:15:00 Hair Braiding Braiding Hair 00:00:00 Applying Braiding Techniques 01:00:00 Finishing Hair 00:15:00 Health & Safety in Hairdressing 01:00:00 Hair Styling About Of Hair Style 00:30:00 Check Out Your Face Shape 01:00:00 Choosing Your Style On Your Shape 01:00:00 Best Hairstyles For A Long Face 00:30:00 Best Hairstyles For A Square Face 00:30:00 Best Hairstyles For A Round Face 00:30:00 Best Hairstyles For A Heart Shaped Face 01:00:00 How To Love Your Style 00:30:00 Wrapping Up 00:02:00 Recommended Materials Workbook - Hairdressing Training 00:00:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Photography is the art or practice of taking and processing photographs. The more you study and discover about photography the better you will become in it. And landscapes can be one of the easiest of all photographic themes to shoot. All you need to do is learn advanced tips and techniques of landscape photography. Taking this Level 3 Diploma in Landscape Photography will enhance your landscape photography skills to the advanced level so that you can create the beautiful photos. Discover how to capture your best ever landscape photos, learn to set up the camera, and use various filters. You will also understand the editing basics, including how to exclude unwanted objects from capturing perfect landscape photography. In addition to that, you will understand the necessity of finding visually compelling locations, and how to pick the right time of day as well as right season, so your photos look their absolute best. Who is this Course for? Level 3 Diploma in Landscape Photography is perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of the English language, numeracy and ICT are required to attend this course. CPD Certificate from Course Gate  At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Assessment: This course does not involve any MCQ exams. Students need to answer 3 assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Each answer needs to be 200 words (1 Page). Once the answers are submitted, the tutor will check and assess the work. Course Curriculum Module: 01 Promo Video FREE 00:02:00 Introduction 00:01:00 Gear for Landscape Photography 00:04:00 Module: 02 Planning Your Trip with Will 00:02:00 Our Gear - What's in Our Bag 00:05:00 Shooting at Sunrise 00:09:00 Landscape Basics & Composition 00:06:00 Camera Setting Refresher with Phil 00:08:00 Phil & Sam Go Over the Basics 00:09:00 Module: 03 How to shoot Panoramas 00:05:00 Wide vs. Telephoto Photographs 00:04:00 Using a Polarizer Filter 00:03:00 Sunset Photography 00:05:00 Module: 04 Intro to Editing 00:02:00 Adobe Lightroom Crash Course 00:14:00 Our Basic Landscape Editing Process 00:11:00 Quickly Straighten Horizons 00:01:00 Remove Unwanted Objects in Lightroom 00:02:00 Module: 05 Phil Edits a Landscape Photo 00:17:00 Sam's Editing Workflow 00:11:00 WiIII's Editing Process 00:19:00 All Three Edit the Same Photo 00:23:00 Sam Edits a Sunrise Photo 00:09:00 How to Create an HDR Photo in Lightroom 00:02:00 Stitch Together a Panorama in Lightroom 00:06:00 Stitch Together a Panorama in Photoshop 00:03:00 Exporting a Photo for Web or Print 00:10:00 Conclusion 00:01:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

The Special Educational Needs Teaching Assistant Diploma is a professional qualification focussed on the practical application of theoretical knowledge. You will gain knowledge of classroom methodologies, communication skills for teaching and how to safeguard children, along with role-specific competencies such as the SEN code of practice, understanding learning difficulties, supporting children on the autistic spectrum, and managing ADHD and dyslexia in the classroom. We've taken this comprehensive course and broken it down into several manageable modules which we believe will assist you to easily grasp each concept - from the fundamental to the most advanced aspects of the course. It really is a sure pathway to success. Who is the course for? Educators who want to improve their interactive teaching course. People who have an interest in teaching and studying. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Module 1: Fundamentals of Teaching Understanding the Development of Children and Young Person 01:00:00 Communication and Professional Relationships with Pupils and Family 01:00:00 Safeguarding the Welfare of Children and Young Person 01:00:00 Module 2: Teaching in UK Teaching in the UK 00:10:00 Teachers' Standards in UK 00:10:00 Teachers Pay 00:30:00 The English School System 00:10:00 Evaluation of Schools and Teachers 00:30:00 School Governance 00:15:00 Inclusive Teaching 00:15:00 Module 3: Teacher Training Module 01: Getting Started 00:22:00 Module 02: Understanding Training and Facilitation 00:25:00 Module 03: Gathering Materials 00:12:00 Module 04: Creating a Lesson Plan 00:15:00 Module 05: Choosing Activities 00:15:00 Module 06: Preparing for the Workshop 00:10:00 Module 07: Getting Off on the Right Foot 00:10:00 Module 08: Delivery Tips and Tricks 00:30:00 Module 09: Keeping it Interactive 00:08:00 Module 10: Dealing With Difficult Participants 00:12:00 Module 11: Tackling Tough Topics 00:16:00 Module 12: Wrapping Up 00:12:00 Activities 00:00:00 Module 4: Teaching Methodologies Education - A Group Enterprise 00:20:00 Traits to Develop 00:30:00 Grow the Attention 00:30:00 Learning Good Habits 00:25:00 Importance of Memory 00:30:00 Imagination is Important 00:16:00 Breakdown of Thinking Process 00:30:00 Appreciation - An Aesthetic Emotion 00:20:00 Learning Reflexive Activities 00:35:00 Differing Individuals 01:00:00 Morality Matters 00:30:00 Different Learning Methods 00:15:00 Different Psychological Exercises 00:30:00 Problems, Situations & Solutions 00:20:00 Measuring the Achievements 01:00:00 Module 5: Psychology of Teaching Why Young People Do Not Learn to Study Properly? 00:20:00 The Nature of Study, and Its Principal Factors 00:30:00 Provision for Specific Purposes, as One Factor of Study 00:40:00 The Supplementing of Thought, as a Second Factor of Study 00:15:00 The Organization of Ideas, as a Third Factor in Study 00:30:00 Judging of the Soundness and General Worth of Statements, as a Fourth Factor in Study 00:25:00 Memorizing, as a Fifth Factor in Study 02:00:00 The Using of Ideas, as a Sixth Factor in Study 00:25:00 Provision for a Tentative Rather Than a Fixed Attitude Toward Knowledge, as a Seventh Factor in Study 01:00:00 Provision for Individuality, as an Eighth Factor in Study 00:15:00 Full Meaning of Study: Relation of Study to Children and to the School 00:15:00 Module 6: SEN Teaching Introduction to Special Educational Needs (SEN) 00:05:00 Understand Constructivism in the Classroom and know your role as a teacher 00:10:00 SEN Code of Practice 00:15:00 Get an understanding on SENCO 00:10:00 Classroom Management Strategies for Children with Special Needs 00:05:00 Physical Difficulties, Sensory Difficulties, Cognitive Impairments of Pupils 00:10:00 How to Deal with Pupils with Autism 00:10:00 Understanding Learning Difficulties 00:10:00 Anger Management Methods for Pupils With Special Needs 00:10:00 Teaching Children with Down Syndrome 00:10:00 Conclusion SEN 00:05:00 Module 7: SEN in USA INTRODUCTION to SEN USA 02:00:00 PRINCIPLES OF SPECIAL EDUCATION 01:00:00 SEN CURRICULUM 01:00:00 SEN TEACHING 01:00:00 CONCLUSION to SEN USA 00:15:00 Module 8: ADHD What is ADHD? 00:05:00 Causes of ADHD 00:05:00 Diagnosing ADHD 00:05:00 Treating ADHD 00:05:00 ADHD and Education 00:05:00 Reasonable Adjustments: ADHD 00:10:00 Adults with ADHD 00:10:00 Module 9: Dyslexia What is Dyslexia? 00:10:00 Identifying Dyslexia 00:05:00 Co-occurring Conditions 00:05:00 Diagnosing Dyslexia 00:05:00 Creating Dyslexia Friendly Environment 00:05:00 Solutions for Dyslexia 00:30:00 Module 10: Dealing with Troubled Children YOU AND YOUR CHILD STUDY 01:30:00 THE PROBLEM OF PUNISHMENT 00:30:00 WHEN YOUR CHILD IMAGINES THINGS 00:30:00 WHY KIDS LIE AND WHAT TO DO ABOUT IT 01:00:00 BEING AFRAID 00:30:00 THE FIRST GREAT LAW 00:30:00 THE TRAINING OF THE WILL 01:00:00 HOW CHILDREN REASON ABOUT FUTURE 00:30:00 WORK AND PLAY 01:00:00 CHILDREN'S GANGS, CLUBS, AND FRIENDSHIPS 00:15:00 CHILDREN'S IDEALS AND AMBITIONS 01:00:00 THE STORK OR THE TRUTH 00:30:00 THE GOLDEN AGE OF TRANSITION 00:15:00 HEREDITY AND ENVIRONMENT 01:00:00 FREEDOM AND DISCIPLINE 00:15:00 Mock Exam Mock Exam- Advanced Diploma in Teaching 00:30:00 Final Exam Final Exam- Advanced Diploma in Teaching 00:30:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Duration 4 Days 24 CPD hours This course is intended for Developers who have: At least two years of experience with Java or JavaScript programming Familiarity with the jQuery library and JSON syntax Overview When you complete this course, you will be able to: Create cartridges to add reusable functionality to a site. Use JavaScript controllers to add business logic to a site. Create reusable code using ISML templates. Use content slots and page designer to improve the appearance and flexibility of a site. Use B2C Commerce Script in ISML templates and script files. Use the Forms Framework to control the validation, rendering, and storing of consumer-entered values. Create hooks to configure functionality that is called a specific event. Measure and ensure site performance. Install and use SFRA command line tools to perform testing. This course introduces the core programming concepts, relevant files, and scripting language for Salesforce B2C Commerce. It is a must for developers new to Salesforce B2C Commerce and experienced developers looking to ramp up on Storefront Reference Architecture. Using real-world scenarios, this course covers how to customize the Storefront Reference Architecture and modify a B2C Commerce Cloud storefront. Overview of B2C Commerce Salesforce B2C Commerce Overview Storefront Reference Architecture Overview Business Manager Organization Getting Started Accessing Storefront Reference Architecture Creating a Workspace Creating a Server Connection Navigating Cartridges CartridgesCartridges Cartridge Types Cartridge Path Working with Plugin Cartridges Using a Custom Storefront Cartridge Controllers Introduction to JavaScript Controllers Creating a JavaScript Controller Script & JavaScript Controller Debugging Middleware Functions B2C Commerce Script API Models Introduction to Models Extending Models ISML ISML Tags and Expressions Reusing Code in Templates Conditional Statements & Loops Resource API & Resource Bundles Content Slots Creating & Configuring Content Slots Content Link Functions Page Designer Introduction to Page Designer Business & Developer Tasks Creating Custom Components Forms Framework Custom & System Objects XML Metadata File Server-Side Validation Script ISML Form Template Custom Logging Client-Side Validation Script Site Maintenance Site and Page Caching Site Performance Storefront Reference Architecture Tools GitHub NPM Tools Functional and Unit Tests

Are You Prepared to Save a Life? Discover the Power of First Aid At Work & BLS Training! Imagine a workplace where every employee is ready to act in emergencies. With 142,000 workplace injuries reported in the UK last year, the need for comprehensive training is clear. This First Aid At Work & BLS Training can be the difference between life and death. Gain essential knowledge that impacts your career and ensures you can respond effectively in critical situations. This First Aid At Work course is a quick and easy way to learn the essentials of first aid at work. With its step by step lessons and no fluff method of content delivery, First Aid At Work course saves you time and money as it's available at a discounted price at the moment. Get 3 CPD Accredited Courses- Course 01: Emergency First Aid at Work Certificate: Learn essential first aid skills to respond to workplace emergencies effectively. Course 02: Oxygen First Aid Training - Online Course: Understand the critical role of oxygen in first aid and how to administer it safely. Course 03: Anaphylaxis & BLS: Gain knowledge on recognizing and responding to anaphylactic emergencies and basic life support techniques. Key Highlights for First Aid At Work Course: Lifetime access to the First Aid At Work course materials Full tutor support is available from Monday to Friday with the First Aid At Work course Gain a complete understanding of the First Aid At Work course Accessible, informative First Aid At Work learning modules designed by experts Get 24/7 help or advice from our email and live chat teams with the First Aid At Work course Study First Aid At Work in your own time through your computer, tablet or mobile device A 100% learning satisfaction guarantee with your First Aid At Work course Emergency First Aid at Work Course Curriculum: Module 01: Introduction to First Aid At Work Module 02: Legal Framework for First Aid At Work Module 03: Incident Management at Work Module 04: Primary Survey Module 05: Secondary Survey Module 06: Basic First-Aid Techniques Module 07: Dealing with Minor Injuries at Workplace Module 08: Secondary Illness: Loss of Responsiveness and CPR Module 09: Secondary Illness: Breathing Problems Module 10: Secondary Illnesses and Injuries Module 11: Dealing With Fractures and Dislocations Module 12: Call for an Emergency in First Aid At Work First Aid At Work Learning Outcomes: Upon successful completion of this highly appreciated First Aid At Work course, you'll be a skilled professional, besides- The learner will acquire the theoretical knowledge necessary to provide First Aid At Work. Identifying the First Aider's duties and doing an emergency scenario assessment First aid for an unconscious victim who is breathing properly (recovery position) First aid for an unconscious and inbreathing victim (CPR & the use of AED) Treatment for a victim experiencing a seizure Initial treatment for breathing issues Treatment for fractures and dislocations using first aid First aid for a victim with minor wounds Certificates: CPD Quality Standard Certificate Digital certificate - CPD Accredited Certificate - Free Hardcopy Certificate (FREE UK Delivery) CPD Hard copy certificate - £9.99 CPD Hardcopy Transcript: £9.99 CPD 30 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this course. Besides, First Aid At Work course is particularly recommended for - Students related to First Aid At Work Recent graduates Job Seekers in related fields. Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skills. Requirements Learners seeking to enrol for the First Aid At Work Course should meet the following requirements; Basic knowledge of English Language, which already you have Be age 16 years or above Basic Knowledge of Information & Communication Technologies for studying online or digital platform. Stable Internet or Data connection in your learning devices. Career path After completing this First Aid At Work course, you can explore trendy and in-demand jobs related to this course, such as - First Aider Child Care Providers Coaches and Athletes Trainers Construction Workers Electricians Firefighters Flight Attendants Explore each of the roles available and how you can start your career in First Aid At Work course. Certificates CPD Certificate Digital certificate - Included After successfully completing this course, you can get CPD accredited digital PDF certificate for free.

Overview of MySql Masterclass The digital world has changed how businesses work in the UK, and database management is now a key part of every successful company. MySQL is one of the most popular tools for this job, used by over 40% of websites around the world. In the UK, big names like BBC, Sky, and many tech startups in London’s Silicon Roundabout rely on MySQL. The MySql Masterclass is designed to help people learn the skills needed to build a strong career in this growing field. Database experts in the UK earn an average salary of £45,000 each year, making it a smart career choice. The MySql Masterclass has 41 helpful modules that start with the basics and move up to more advanced topics. Students will learn how to create databases, write MySQL commands, use joins, and manage stored procedures. The course also teaches how to make systems run faster and safer with performance and security tools. Other important topics include handling JSON data, using full-text search, and working with replication. These are all things that modern companies look for in a database specialist. This MySql Masterclass is made for beginners and gives them the knowledge they need to handle real business databases. It helps students build strong skills in design, optimisation, and administration. The UK’s tech industry is worth £150 billion a year, and the MySql Masterclass helps learners get ready for job opportunities in many areas like retail, health, and finance. Learning Outcomes By the end of the MySql Masterclass, learners will be able to: Build and manage MySQL databases from the ground up Use SELECT, INSERT, UPDATE, and DELETE commands with confidence Work with advanced joins, unions, and stored procedures Design and use indexes, views, and full-text search for better performance Set up MySQL replication, backups, and basic system administration Handle JSON data and manage time zone settings within databases Who is this course for? Aspiring Database Administrators who want full MySQL training to manage databases, user access, and backups in organisations needing strong data systems. Software Developers who want to improve their backend development by learning MySQL queries, stored procedures, and database performance skills. Data Analysts who need advanced SQL to pull useful data from complex tables using joins, group functions, and reporting tools. IT Professionals looking to build database knowledge, including how to configure, tune, and fix issues in MySQL systems. Career Changers with little or no tech background who want to start in database roles, learning from the basics to advanced MySQL tasks. Process of Evaluation After studying the MySql Masterclass Course, your skills and knowledge will be tested with an MCQ exam or assignment. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement Certificate of Completion - Digital / PDF Certificate After completing the MySql Masterclass Course, you can order your CPD Accredited Digital / PDF Certificate for £5.99. (Each) Certificate of Completion - Hard copy Certificate You can get the CPD Accredited Hard Copy Certificate for £12.99. (Each) Shipping Charges: Inside the UK: £3.99 International: £10.99 Requirements You don’t need any educational qualification or experience to enrol in the MySql Masterclass course. Career Path Completing this MySql Masterclass course could lead to rewarding jobs like: Database Administrator – £35K to £65K per year MySQL Developer – £30K to £55K per year Data Analyst – £25K to £45K per year Backend Developer – £35K to £60K per year Database Consultant – £40K to £70K per year Course Curriculum: MySql Masterclass Module 1: Introduction on MySQL 01:00:00 Module 2: Data Types 00:51:00 Module 3: SELECT Statements 00:59:00 Module 4: Backticks 00:15:00 Module 5: NULL 00:18:00 Module 6: Limit and Offset 00:13:00 Module 7: Creating databases 00:18:00 Module 8: Using Variables 00:25:00 Module 9: Comment MySQL 00:14:00 Module 10: INSERT Statements 00:29:00 Module 11: DELETE Statements 00:21:00 Module 12: UPDATE Statements 00:20:00 Module 13: ORDER BY Clause 00:08:00 Module 14: Group By 00:18:00 Module 15: Errors in MySQL 00:10:00 Module 16: Joins 00:37:00 Module 17: Joins continued 00:11:00 Module 18: UNION 00:18:00 Module 19: Arithmetic 00:20:00 Module 20: String operations 00:33:00 Module 21: Date and Time Operations 00:08:00 Module 22: Handling Time Zones 00:07:00 Module 23: Regular Expressions 00:19:00 Module 24: VIEWS 00:20:00 Module 25: Table Creation 00:23:00 Module 26: ALTER TABLE 00:23:00 Module 27: Drop Table 00:05:00 Module 28: MySQL LOCK TABLE 00:10:00 Module 29: Error codes 00:08:00 Module 30: Stored routines (procedures and functions) 00:29:00 Module 31: Indexes and Keys 00:24:00 Module 32: Full-Text search 00:18:00 Module 33: PREPARE Statements 00:09:00 Module 34: JSON 00:11:00 Module 35: Extract values from JSON type 00:05:00 Module 36: MySQL Admin 00:08:00 Module 37: TRIGGERS 00:12:00 Module 38: Configuration and tuning 00:07:00 Module 39: Events 00:08:00 Module 40: ENUM 00:09:00 Module 41: Collations, Transactions, Log files, Replication, Backup 00:41:00

Duration 2 Days 12 CPD hours This course is intended for This course is relevant to anyone who needs to work with and understand data including: Business Analysts, Data Analysts, Reporting and BI professionals Marketing and Digital Marketing professionals Digital, Web, e-Commerce, Social media and Mobile channel professionals Business managers who need to interpret analytical output to inform managerial decisions Overview This course will cover the basic theory of data visualization along with practical skills for creating compelling visualizations, reports and dashboards from data using Tableau. Outcome: After attending this course delegates will understand - How to move from business questions to great data visualizations and beyond How to apply the fundamentals of data visualization to create informative charts How to choose the right visualization type for the job at hand How to design and develop basic dashboards in Tableau that people will love to use by doing the following: Reading data sources into Tableau Setting up the roles and data types for your analysis Creating new data fields using a range of calculation types Creating the following types of charts - cross tabs, pie and bar charts, geographic maps, dual axis and combo charts, heat maps, highlight tables, tree maps and scatter plots Creating Dashboards that delight using the all of the features available in Tableau. The use of analytics, statistics and data science in business has grown massively in recent years. Harnessing the power of data is opening actionable insights in diverse industries from banking to tourism. From Business Questions to Data Visualisation and Beyond The first step in any data analysis project is to move from a business question to data analysis and then on to a complete solution. This section will examine this conversion emphasizing: The use of data visualization to address a business need The data analytics process ? from business questions to developed dashboards Introduction to Tableau ? Part 1 In this section, the main functionality of Tableau will be explained including: Selecting and loading your data Defining data item properties Create basic calculations including basic arithmetic calculations, custom aggregations and ratios, date math, and quick table calculations Creating basic visualizations Creating a basic dashboard Introduction to Tableau ? Part 2 In this section, the main functionality of Tableau will be explained including: Selecting and loading your data Defining data item properties Create basic calculations including basic arithmetic calculations, custom aggregations and ratios, date math, and quick table calculations Creating basic visualizations Creating a basic dashboard Key Components of Good Data Visualisation and The Visualisation Zoo In this section the following topics will be covered: Colour theory Graphical perception & communication Choosing the right chart for the right job Data Exploration with Tableau Exploring data to answer business questions is one of the key uses of applying good data visualization techniques within Tableau. In this section we will apply the data visualization theory from the previous section within Tableau to uncover trends within the data to answer specific business questions. The types of charts that will be covered are: Cross Tabs Pie and bar charts Geographic maps Dual axis and combo charts with different mark types Heat maps Highlight tables Tree maps Scatter plots Introduction to Building Dashboards with Tableau In this section, we will implement the full process from business question to final basic dashboard in Tableau: Introduction to good dashboard design Building dashboards in Tableau

Cake / Cupcake Decorating Course: Unleash Your Creative Potential 🍰 Are you ready to turn your passion for baking into a beautiful art form? The Cake / Cupcake Decorating Course is your gateway to mastering the techniques and skills needed to create stunning and delectable desserts. Whether you're a novice looking to learn the basics or an experienced baker aiming to refine your skills, this course has something for everyone. Benefits of Taking the Cake / Cupcake Decorating Course 1. Discover Your Creativity Express Yourself: Cake and cupcake decorating is a fantastic way to express your creativity. With various techniques and styles, you can create unique designs that reflect your personality and artistic flair. Stress Relief: Engaging in a creative activity like decorating cakes and cupcakes can be a great way to relax and unwind. The process of designing and decorating can be therapeutic and enjoyable. 2. Enhance Your Baking Skills Master the Basics: Learn the fundamental techniques of cake and cupcake decorating, including icing, piping, and fondant work. Advanced Techniques: For those with some experience, this course will introduce advanced decorating methods such as sculpting, airbrushing, and creating intricate sugar art. 3. Impress Your Friends and Family Celebrate Special Occasions: Imagine the joy of presenting a beautifully decorated cake at birthdays, weddings, or holiday gatherings. Your creations will be the highlight of any event. Unique Gifts: Handmade cakes and cupcakes make thoughtful and personalized gifts for your loved ones. Your custom creations will be cherished and remembered. 4. Start a New Hobby or Career Hobby: Cake and cupcake decorating is a rewarding and enjoyable hobby that allows you to continually learn and grow. Career Opportunities: This course can be the first step towards a career in baking and cake decorating. With the skills you acquire, you can start your own business or work in a professional bakery. Who is this for? Beginners: If you're new to cake and cupcake decorating, this course will provide you with the essential skills and knowledge to get started. Home Bakers: Enhance your home baking skills and create professional-looking desserts for your family and friends. Aspiring Professionals: If you're considering a career in baking or cake decorating, this course will give you a solid foundation and help you build a portfolio of impressive creations. Event Planners: Learn how to create stunning centerpieces for weddings, birthdays, and other special events. Craft Enthusiasts: If you enjoy crafting and creating, cake and cupcake decorating is another medium to explore and enjoy. Career Path Completing the Cake / Cupcake Decorating Course opens up a variety of career opportunities in the culinary and creative industries. Here are some potential paths you can pursue: Professional Cake Decorator: Work in bakeries, patisseries, or cake shops as a professional cake decorator. Bakery Owner: Start your own bakery or cake decorating business, offering custom cakes and cupcakes for various occasions. Catering Services: Expand your services by providing decorated cakes and cupcakes for catered events. Pastry Chef: Work as a pastry chef in restaurants, hotels, or catering companies, specializing in cake and cupcake decoration. Online Business: Start an online business selling decorated cakes and cupcakes or offering virtual cake decorating classes. Instructor: Share your knowledge and passion by teaching cake and cupcake decorating classes, either in-person or online. FAQ Section Q: Do I need any prior experience in baking or decorating to take this course? A: No prior experience is necessary. This course is designed to cater to all skill levels, from beginners to advanced decorators. Q: What materials and tools will I need for the course? A: You will need basic baking tools such as mixing bowls, spatulas, and baking pans. For decorating, you will need piping bags, tips, fondant tools, and food coloring. A detailed list will be provided upon enrollment. Q: Can I take this course online? A: Yes, this course is available online, allowing you to learn at your own pace and from the comfort of your home. Q: How long does it take to complete the course? A: The course duration varies depending on your pace. On average, it can be completed in 4-8 weeks. Q: Will I receive a certificate upon completion? A: Yes, you will receive a certificate of completion, which can be a valuable addition to your portfolio or resume. Q: Can I access course materials after completing the course? A: Yes, you will have lifetime access to the course materials, allowing you to revisit and review the content whenever you need. Q: Are there any live sessions or one-on-one coaching available? A: The course includes pre-recorded video lessons, but live Q&A sessions and one-on-one coaching may be available for an additional fee. Q: What kind of support is available if I have questions during the course? A: You will have access to a community forum where you can ask questions and interact with instructors and fellow students. Additionally, email support is available for specific queries. Q: Can I use the skills learned in this course to start my own business? A: Absolutely! This course provides you with the foundational skills and knowledge to start your own cake decorating business. Why Enroll in the Cake / Cupcake Decorating Course? Comprehensive Learning: From basic techniques to advanced decorating methods, this course covers all aspects of cake and cupcake decorating. Flexible Learning: Learn at your own pace with online access to course materials. Expert Instruction: Benefit from the expertise of professional cake decorators and pastry chefs. Community Support: Join a community of like-minded individuals who share your passion for cake and cupcake decorating. Career Advancement: Open doors to new career opportunities in the culinary and creative industries. Enroll Today and Start Decorating! 🎨 Transform your baking into an art form with the Cake / Cupcake Decorating Course. Whether you want to impress your loved ones, start a new hobby, or embark on a professional career, this course is your ticket to achieving your goals. Enroll now and take the first step towards creating stunning, delicious masterpieces! Course Curriculum Module 1 Introduction to Cake and Cupcake Decorating Introduction to Cake and Cupcake Decorating 00:00 Module 2 Basic Decorating Techniques Basic Decorating Techniques 00:00 Module 3 Fondant Basics Fondant Basics 00:00 Module 4 Buttercream Techniques Buttercream Techniques 00:00 Module 5 Advanced Piping Techniques Advanced Piping Techniques 00:00 Module 6 Working with Chocolate Working with Chocolate 00:00

Duration 5 Days 30 CPD hours This course is intended for This course is for all Oracle Professionals. Specifically Database Administrators, Web Server Administrators, System Administrators, CIOs and other IT Management Professionals. Overview Upon successful completion of this course, students will be able to perform many of the day-to-day administration tasks required of an Oracle database administrator. This course introduces many of the powerful capabilities of the Oracle database. In this course, students will learn about day-to-day administration tasks. It will also address administration sub-specialties. Introduction: Managing the Database Instance The Database Management Tools EM Database Express EM Cloud Control SQL Developer Database Administrator Introduction: Database Architecture Review Database Instance Configurations Memory Structures Process Structures Storage Architecture Introduction: Starting & Stopping Databse Services Start & Stop the Database Listener ABOUT DATABASE STARTUP/SHUTDOWN SYSOPER SYSDBA DATABASE STATE & STAGES STARTUP WITH EM CLOUD CONTROL STARTUP WITH SQL*PLUS SHUTDOWN WITH EM CLOUD CONTROL SHUTDOWN WITH SQL*PLUS USING MS WINDOWS SERVICES Introduction: Oracle Network Environment Oracle Net Services Architecture ORACLE NET CONFIGURATION ASSISTANT ORACLE NET MANAGER USING EM CLOUD CONTROL ADVANCED NETWORK COMPRESSION TROUBLESHOOTING NETWORK PROBLEMS Introduction: Diagnostics & Oracle Support About Database Diagnostics Fault Diagnosability Infrastructure DATABASE INSTANCE HEALTH SNAPSHOT THE SUPPORT WORKBENCH PROACTIVE DATABASE HEALTH CHECKS PACKAGE DIAGNOSTIC DATA WORKING WITH THE KNOWLEDGE BASE Storage: Tablespace Management Starter Tablespaces CREATE TABLESPACE WITH EM CC CREATE TABLESPACE WITH SQL MANAGE TABLESPACES WITH EM CC MANAGE TABLESPACES WITH EM DE MANAGE TABLESPACES WITH SQL DROP TABLESPACE ALTER TABLESPACE Storage: Advanced Tablespace Management Managing Temporary Tablespaces TEMP TABLESPACE GROUPS WITH EM TEMP TABLESPACE GROUPS WITH SQL DEFAULT PERMANENT TABLESPACES BIGFILE TABLESPACES MANAGING THE SYSAUX TABLESPACE Storage: Data Files & Temp Files Management Manage Data Files with EM ACCESS METADATA WITH SQL MANAGE DATA FILES WITH SQL MANAGE TEMP FILES ORACLE-MANAGED FILES (OMF) Storage: UNDO Data & UNDO Tablespaces About UNDO Space Management GUARANTEE UNDO RETENTION MONITOR UNDO SPACE WITH SQL USE THE EM UNDO ADVISOR Security & Schemas: Security Overview & Database Privileges Database Security Principles DATABASE SYSTEM PRIVILEGES DATABASE OBJECT PRIVILEGES SUPER ADMINISTRATOR ROLES PRIVILEGE ANALYSIS Security & Schemas: User Security Create & Manage User Accounts MANAGE USERS WITH EM MANAGE USERS WITH SQL CREATE USER ALTER USER DROP USER GRANT & REVOKE PRIVILEGES RESOURCE LIMITS VIA PROFILES ALTER PROFILE DROP PROFILE PASSWORD MANAGEMENT VIA PROFILES ROLE-BASED SECURITY MANAGEMENT ALTER USER...DEFAULT ROLE SET ROLE DELEGATING PRIVILEGE AUTHORIZATION WITH ADMIN OPTION & System Privileges WITH GRANT OPTION & Object Privileges PRINCIPLE OF LEAST PRIVILEGE CHECKLIST Security & Schemas: Database Auditing Auditing Database Activity Traditional Auditing Unified Auditing Create Audit Policy Security & Schemas: SQL Loader Loader Concepts Loader From the Command Line control File Options Load Methods Loader Express Mode Loader From EM Security & Schemas: Export & Import Manage Directory Objects The Data Pump Architecture Data Pump Export Data Pump Import Data Pump Dictionary Views Using the EM CC Interface Performance & Availability: Managing Performance & SQL Tuning Management Advisory Framework Performance Monitoring & AWR The SQL Tuning Advisor Monitoring Exceptions with Metrics Performance & Availability: Data Concurrency About System & User Locks Monitor & Manage User Locks Moitor Locks with Data Dictionary Manage Locks with EM Performance & Availability: Backup & Recovery Concepts Backup & Recovery Structures Managing REDO Data Configuring for Recoverability Instance Recovery Recoverability Checklist Additional course details: Nexus Humans Oracle 12c Administration II 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 Oracle 12c Administration II 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.