304 Courses in Cardiff delivered Online

Business and Data Analysis with SQL is a comprehensive training in the theoretical and practical study of Data analysis and SQ language. This module is open to the people who want to elevate their business growth. Secure your position as an asset to the organization by learning SQL. Make your professional skill more productive by learning data analysis and SQL communication. The course exposes to you the details on computational and data investigational methods. It also highlights the basics of extracting data from the database storage. On completion of this online course, you will have an extensive understanding of how the database works and ways to function them properly, and thus be able to make critical decisions like a professional. What you'll learn At the end of this course, you will have the ability to run your own data projects, work with databases and manage large datasets and provide meaningful business intelligence reports to your team. Requirements Be familiar with reports and data-based projects. Who this course is for: This course is aimed at business professionals who work with data of all sizes. You will learn the fundamentals of business intelligence and basic data warehouse development. Introduction Business and Data Analysis with SQL FREE 00:06:00 Database and Datawarehouse Design Introduction to Databases- A History 00:04:00 SQL Statement Categories 00:02:00 Capture data requirements 00:09:00 Physical Vs Logical Data Representations 00:03:00 Normalise data 00:07:00 Fact Tables 00:04:00 Aggregate data 00:07:00 Entity Relationship Diagrams (ERD's) 00:07:00 Extract, Transform and Load (ETL) 00:13:00 Structured Query Language (SQL) - Fundamentals MySQL Server Setup 00:05:00 MySQL Server Start and stop Service 00:02:00 Connect to database 00:07:00 Comments in SQL 00:05:00 Select data from a table 00:16:00 Table Indexes 00:08:00 Table and Column Aliases 00:05:00 Inner Join Tables 00:02:00 Left and Right Outer Table Joins 00:04:00 Union (all) Results 00:04:00 Project Management Project Management (Agile Methodology) 00:11:00 Kanban boards 00:09:00 Prioritise Requirements using MoSCoW 00:04:00 Sales Project Sales Project - Introduction 00:05:00 Create and Drop Database 00:05:00 Query Workflow 00:09:00 Sales Project - Part 1 - Data Capture 00:15:00 Sales Project - Part 2 - Data Analysis 00:08:00 Sales Project - Part 3 - Data Summary 00:12:00 Sales Project - Part 4 - Send to production 00:09:00 MySQL Query Explain Plan 00:07:00 Common Table Expressions (WITH) 00:14:00 Data Control Language (DCL) User Administration 00:13:00 MySQL Programs MySQL Set Windows Environment Variable 00:05:00 MySQL Command Line 00:17:00 Visualising Data Export results to Excel 00:06:00 Setup MySQL ODBC (Open Database Connector) 00:11:00 Creating a report in Microsoft Excel 00:21:00 Course Certification

Description: If you already have the basic skills and knowledge of Microsoft Word 2010 and you are able to create, edit, and print word documents on Windows then this [course_tite] is designed for you. This series builds on the skills and concepts taught in Word 2010 Basic. You will learn advanced formatting, use Word's drawing tools, create and manage tables, and work with column layouts. Here, you will work with styles, sections, and columns and will use the Navigation pane to work with outlines. By this course, you will learn to use Word's advanced editing tools, work with images, including placing and sizing images, wrapping text around images, and using borders and effects, how to adjust page orientation an layout, how to work with columns and with page and section breaks, and more. This intermediate level will pull up your basic knowledge and skills so don't delay to try this. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2010 Word Intermediate - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it 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. Requirements Our Microsoft Office 2010 Word Intermediate - Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Styles and Outlines Examining Formatting FREE 00:07:00 Creating Styles 00:17:00 Modifying Styles 00:11:00 Working with Outlines 00:13:00 Sections and Columns Creating and Formatting Sections 00:13:00 Working with Columns 00:08:00 Formatting Tables Table Formatting Basics 00:09:00 Borders and Shading 00:06:00 Table Data 00:10:00 Table Styles 00:09:00 Printing Labels and Envelopes Labels 00:06:00 Envelopes 00:05:00 Templates and Building Blocks Template Basics 00:11:00 Building Blocks 00:02:00 Document Properties 00:14:00 Graphics Creating Diagrams 00:02:00 Using the Drawing Tools 00:13:00 Formatting Text Graphically 00:06:00 Managing Document Revisions Tracking Changes 00:21:00 Working with Comments 00:02:00 Web Features Web Pages 00:03:00 Hyperlinks 00:10:00 Mock Exam Mock Exam- Microsoft Office 2010 Word Intermediate - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2010 Word Intermediate - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: Microsoft Office Visio is a vector graphics and diagramming application. Its latest iteration, Microsoft Office Visio 2016, brings a lot of updates and functionality. Microsoft Visio 2016 Beginner to Advanced Course has been designed deliberately for the ease of learning in an efficient way. This course will help you get started from the basics; you will get accustomed with the interface, tools and features, simple diagrams, floor plans, flowcharts, etc. As you move up the skillset, you will be exposed to advanced stuff: organization chart, making a floor plan, cross-functional flowchart, network diagram, shapes, stencils, templates, leveraging development tools, etc. This course will give you an overall outlook from basic to advanced level aspects of this application. Learning Outcomes: Working with shape styles, utilizing 3D shapes, apply backgrounds, borders and titles in order to make your work stand out Creating custom stencils, simple custom shapes, master shapes and custom templates Connecting features, like pivot tables and data, from other Microsoft Office programs and using them Utilizing macros, ShapeSheets and advanced shape tools Sharing your drawings across multiple platforms Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Visio 2016 Advanced is certified by CPD Qualifications Standards and CiQ. This makes it 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. Requirements Our Microsoft Visio 2016 Advanced is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Work with Shape Styles 00:30:00 Use 3D Shapes 00:30:00 Apply Backgrounds, Borders, and Titles 00:30:00 Create Custom Stencils 00:30:00 Create Simple Custom Shapes 00:30:00 Create Master Shapes 00:30:00 Create Custom Templates 00:30:00 Generate a Pivot Diagram from an Excel Spreadsheet 00:30:00 Create a Chart from a Project File 00:30:00 Create a Timeline from a Project File 00:30:00 Connect to an Access Database 00:30:00 Create Macros 00:30:00 Modify ShapeSheets 00:30:00 Use Advanced Shape Tools 00:30:00 Save and Share Drawings with One Drive 00:30:00 Review Drawings 00:30:00 Insert Drawings into Other Office Files 00:30:00 Export Drawings 00:30:00 Print Drawings 00:30:00 Activities Activities - Microsoft Visio 2016 Advanced 00:00:00 Mock Exam Mock Exam- Microsoft Visio 2016 Advanced 00:20:00 Final Exam Final Exam- Microsoft Visio 2016 Advanced 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

The Microsoft Certified Fundamentals, Associate, and Expert is a new breed of Microsoft certification. It is referred to as a ‘role-based certification’. According to Microsoft, role-based certifications show that individuals that possess them are keeping pace with today’s technical roles and requirements. They allow a learner to skill up and prove their expertise to employers and peers, plus get the recognition and opportunities they’ve earned

This course is designed for beginners, although we will go deep gradually, and is a highly focused course designed to master your Python skills in probability and statistics, which covers the major part of machine learning or data science-related career opportunities.

Want to know more about landscaping? Want to learn how to do landscaping in a more organised way without spending a lot of money? If yes, then enrol now to learn in detail about landscaping and benefit from all the information provided. Description:  Landscaping has been practised by individuals for centuries. People were using the garden for both decorative and practical reasons. Nowadays landscaping is all about planning, setting and constructions of gardens. A landscape which is outlined legitimately is a source of happiness for the whole family. In this course, you will learn the steps for drawing the base plans. The most important thing is to design the site. It is critical to select the design, location, placement and the landscape development all at once. In this course, you will also learn about diagrams, how to create the designs according to your needs and satisfaction. For the best looking garden and for a good landscaping you need to plan and select your plants wisely. In this course, you will be guided on how to select and purchase the right plants for your garden and how and where to place them, which will help you save time and energy. You will also learn to enhance your landscaping by adding backyard pond. You will learn about essential skills and lessons related to landscaping by our professional mentors through our course. Who is the course for? Individuals who want to start a landscaping business. Individuals who want to find a landscaping job. Anyone interested in learning about landscaping. 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. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: Diploma in Landscaping is a useful qualification to possess, and would be beneficial for the following professionals: Landscaping designer. Landscaping planner. Landscaping architect. Horticultural consultant. Horticultural therapist. Environmental consultant. Landscape architectural assistant. Landscape Drafter. Computer-aided design technician. Diploma in Landscaping Planning The Home Landscape 00:30:00 The Base Plan 00:15:00 Steps For Drawing The Base Plan 01:00:00 Planning For Your Needs 00:15:00 Studying The Site 00:30:00 Landscaping Materials 01:00:00 Placing Your Plants 00:30:00 Choosing And Planting Your Plants 02:00:00 Landscape Construction 00:15:00 Terracing 00:30:00 Backyard Ponds 01:00:00 Landscaping For Energy Savings 01:00:00 Refer A Friend Refer A Friend 00:00:00 Mock Exam Mock Exam- Diploma in Landscaping 00:20:00 Final Exam Final Exam- Diploma in Landscaping 00:20:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

Ideal for the Duke of Edinburgh Skills You will complete the sections over multiple weeks and ideally consolidate the learning with a practical course. On completion, email me the login to the edofe portal and I will check progress and complete the online assessment. The course will take approximately 12 hours to complete when engaging in all elements of the training and spreading the content over multiple weeks. If you are buying this course for someone else to complete - please put their name into the course, as they would like it to appear on their certificate. You can make payment under a different name. (If you would like a practical course: www.firstaidforlife.org.ukrun hands-on courses for groups of friends throughout the UK, alternatively individuals can join one of our open scheduled courses at our training centre in London). First aid for teenagers covering adult, baby and child first aid: This course is designed to give you the knowledge to learn how to keep yourself and others safe and to know how to help should an accident happen. This course does not seek to replace a practical course but allows you to learn these vital skills at a time and place to suit you. The course is ideal for babysitting, Duke of Edinburgh Award (Skills section and very useful content for the expedition too), sports leadership and as a vital life skill to equip teenagers with the skills to help themselves or friends if faced with a medical emergency. The course consists of illustrated step-by-step directions, flow charts, diagrams, videos and a short test yourself section fully compatible with all computers and mobile devices. You will be able to stop and start as often as you like and on completion you will be able to print your certificate. It is impossible to cover all eventualities within this course, or to equip you with the knowledge and skills to appropriately diagnose and treat in unpredictable real life situations. If you suspect serious illness or injury, you should always seek immediate professional medical advice. The author has made every effort to ensure the accuracy of the information contained within the course, however this course is merely a guide and the author does not accept any liability or responsibility for any inaccuracies or for any mistreatment or misdiagnosis of any person, however caused. The course material has been written by Emma Hammett, qualified nurse, first aid trainer and founder of First Aid for Life in conjunction with other medical and first aid professionals. If you have any queries concerning this course, please contact emma@firstaidforlife.org.uk Course contents: Action in an emergency What to put in your first aid kit Vital information to give the emergency services The primary survey – What to do in those first few minutes Unresponsive and breathing How to put someone into the recovery position Unconscious and not breathing - Resuscitation CPR Resuscitating an adult, baby and child Heart attack and angina Choking Drowning Asthma Panic attacks and hyperventilation Anaphylactic shock Wounds and bleeding Shock Internal bleeding Amputated parts Knocked out teeth Eye injuries Nose bleeds Fainting Bites and stings Burns Poisoning Alcohol poisoning Breaks, sprains and dislocations Head injuries Spinal injuries Fitting/seizures/convulsions Extremes of body temperature Useful advice Final lesson and certificates

This course bundle is made up of three separate certification courses: 1. PRINCE2® Foundation; 2. PRINCE2® Practitioner; 3. IASSC Lean Six Sigma Black Belt. The PRINCE2® Foundation And Practitioner course includes the official certification exams. By passing the Foundation and Practitioner exams, you will be an officially certified PRINCE2® Practitioner. The IASSC Lean Six Sigma Black Belt course includes the official IASSC Six Sigma Black Belt exam. By passing this exam, you will be officially certified by the IASSC as a Six Sigma Black Belt. You have 14 months to complete all of the courses in this bundle and take the exams. Read below to find out more about the courses contained within this bundle.

Duration 5 Days 30 CPD hours This course is intended for Application Developers; Programmers, Sales and Pre Sales, Technical Support, Project Managers, Cisco customers, partners and employees involved in UCCE/CVP or CVP stand alone deployments Overview Upon completing this course, the learner will be able to meet these overall objectives: Introduction to the Java API, its capabilities and limitations - Practice - This course is applicable for any version of CVP and Studio. Introduction to Voice Elements and their complexity - creating every different Java component to extend Studio (see below) Overview of a UCCE with CVP Comprehensive Call Flow Module 1 Overview of a UCCE with CVP Comprehensive Call Flow Module 2 ICM routing scripts to route calls to CVP VXML Server applications Passing data (e.g., global variables) Parsing and evaluating data returned Queueing Assigning data to send to Finesse. Module 3 Writing Call Studio scripts (applications) Prompting Callers ? using pre-recorded audio; TTS text-to-speech; Say it Smart to format audio as digits, date, time, currency; input error reprompting Menus Collecting and confirming caller input, such as account numbers, dates of birth, etc Working with variables ? Session data, Element data, Call data, Local data (CVP11) Introduction to retrieving data from back end systems: SQL Database interaction ? using the Studio Database element to select data Web service interaction- Studio Web Services element for SOAP-web services and calling a simple REST web service Playing audio to callers during back-end data retrieval Catch events Working with counters, decisions, math Introduction to javascript for substrings and string length Setting VoiceXML properties affecting the gateway Multi-Language applications Module 4 Working with Version Control Module 5 ÿImplementing a Post Call Survey Module 6 Using the Studio Debugger to test applications within Studio Module 7 CVP Reporting Server and CVP CUIC Reports Best practices regarding naming elements and variables Configuring data to pass to the Reporting Server using OAMP Understanding Reporting Server tables Understanding the Application Summary CUIC reports Module 8 Administration covered throughout the course OAMP Operations Console to deploy applications to VXML Server Using Studio Documenter to print Visio-like diagrams of the application Configuring log file properties Using logs for debugging applications Administrative scripts for graceful updates or suspensions of the server Important log, debug, administration files Module 9 Cisco Courtesy Callback Detailed discussion of the CCB Call flow, the ICM script, and the 5 Studio scripts used for Courtesy Callback.

Why Learn Bespoke AutoCAD Mac Basic-Intermediate Course? Learn AutoCAD using your projects and learn how to use powerful tools and techniques for drawing, dimensioning, and printing 2D drawings with our Intermediate AutoCAD course. Check our Website How long is the training? 10 hours, Choose and split 10 hrs Mon to Sat 9 am to 7 pm. Book online or call 02077202581 or 07970325184.   Method? 1-on-1, available in both in-person and Live Online. Course Topics Include: Building Fundamental Shapes Working with Lines, Arcs, and Polylines Utilizing Grip Tools Precision Object Alignment Data Management and Backups Exploring File Formats Ensuring Disaster Recovery Mastering Object Creation Handling Measurement Units Dynamic Input Techniques Inquiring Commands and Measurement Tools Effective Object Viewing Navigating Zoom and Pan Object Manipulation Strategies Object Selection Methods Swift Object Management Object Transformation Techniques Scaling and Altering Objects Trim, Extend, and Offset Functions Creating Geometric Variations Object Joining and Editing Corner Filleting and Chamfering Stretching Objects Organizing Your Drawings Layer Management Customizing Object Properties Applying Linetypes Layout Design and Setup Efficient Page Configurations Scaling Drawing Views Adding Annotations Multiline and Single-Line Text Creation Text Styling and Editing Dimensioning Concepts Customizing Dimension Styles Dimension Editing Implementing Multileaders Object Hatching Hatching Editing Reusable Content Management Blocks and Symbols Tool Palette Usage Working with Groups Model Space and Paper Space Understanding Layout Creation and Viewports Viewport Scaling Plotting and PDF Output Managing Multiple Sheet Drawings Utilizing Plotstyles Crafting Custom Drawing Templates Download AutoCAD Mac https://www.autodesk.co.uk After completing the AutoCAD for Mac course, learners can expect the following learning outcomes: Proficiency in AutoCAD: Participants will acquire the skills and knowledge needed to confidently use AutoCAD for Mac, including creating and editing drawings, managing objects, and applying precision techniques. Effective Design Skills: They will gain the ability to produce accurate 2D drawings, making them valuable assets in design-related professions. Jobs that individuals can pursue after completing this course include: Draftsperson: Working in architectural, engineering, or construction firms to create technical drawings and plans. CAD Technician: Assisting in the development of designs for various projects, such as product design or urban planning. Interior Designer: Using AutoCAD for space planning and layout design in the interior design industry. Architectural Designer: Collaborating on architectural projects, including creating floor plans and elevations. Mechanical Designer: Participating in the design and development of mechanical components and systems. Civil Engineering Technician: Supporting civil engineers in designing infrastructure projects, such as roads and bridges. Electrical or Electronics Designer: Assisting in the creation of electrical schematics and electronic circuit diagrams. Landscape Designer: Planning and visualizing outdoor spaces, gardens, and landscapes. Completing this AutoCAD course opens doors to various industries where precise and detailed 2D drawing skills are highly valued. The AutoCAD Mac Bespoke 1 on 1 Basics to Intermediate Level Training Course provides participants with a comprehensive skill set, enabling them to attain proficiency in using AutoCAD Mac. This course covers a wide range of functionalities and caters to individuals at all skill levels, whether they are beginners or experienced users. Participants will begin by learning fundamental features such as drawing, editing, annotations, and dimensioning. As they progress, they will delve into more advanced topics like object manipulation, customizing workspaces, and streamlining workflows. Key Benefits of the Course: Mastery of Mac-AutoCAD: Acquire expertise in both essential and advanced techniques for creating precise 2D drawings. Enhanced Productivity: Increase efficiency by implementing time-saving tips and optimizing your work processes. Versatile Design Abilities: Develop the skills to undertake diverse projects in fields such as architecture, engineering, and more. Industry-Relevant Competencies: Elevate your career prospects across various industries by gaining in-demand AutoCAD skills. Access to Recorded Lessons: Review and reinforce your learning at your convenience with access to recorded lesson sessions. Ongoing Email Support: Receive continuous assistance and guidance via email even after completing the course. Enroll today to benefit from interactive learning experiences guided by experienced instructors. Choose between flexible in-person or online sessions, gain access to lesson recordings, and enjoy a lifetime of email support.  Tailored Guidance: Get personalized coaching and instruction tailored to your unique learning needs and objectives. Convenient Scheduling: Choose from flexible training slots available Monday to Saturday from 9 am to 7 pm, accommodating your busy schedule. Versatile Learning Options: Select between in-person training at our location, conveniently situated just 5 minutes away from Oval Tube Station, or participate in live online sessions from anywhere. Engaging Interactions: Participate in interactive sessions designed for questions, discussions, and problem-solving, creating an immersive learning experience. Effective Progression: Accelerate your learning with focused guidance, allowing you to advance at your own pace while mastering the material. Tailored Curriculum: Customize the course content to align with your prior knowledge and specific areas of interest, ensuring a relevant and engaging learning experience. Real-Time Guidance: Receive immediate feedback from the instructor, enhancing your comprehension and skill development. Comprehensive Support: Enjoy ongoing assistance and clarification opportunities through email or additional sessions beyond the course for an in-depth learning experience.