Duration 3 Days 18 CPD hours This course is intended for This is an introductory level SQL course, appropriate for anyone needing to interface with an Oracle database or those needing a general understanding of Oracle database functionality. That would include end users, business analysts, application developers and database administrators. Overview Working in a hands on learning environment led by our expert practitioner, attendees will explore: Basic RDBMS Principles The SQL Language and Tools Using SQL Developer SQL Query Basics WHERE and ORDER BY Functions ANSI 92 Joins ANSI 99 Joins Subqueries Regular Expressions Analytics A company?s success hinges on responsible, accurate database management. Organizations rely on highly available data to complete all sorts of tasks, from creating marketing reports and invoicing customers to setting financial goals. Data professionals like analysts, developers and architects are tasked with creating, optimizing, managing and analyzing data from databases ? with little room for error. When databases aren?t built or maintained correctly, it?s easy to mishandle or lose valuable data. Our SQL Programming and Database Training Series provides students with the skills they require to develop, analyze and maintain data and in correctly structured, modern and secure databases. A full presentation of the basics of relational databases and their use are also covered. Basic RDBMS Principles Relational design principles Accessing data through a structured query language Entity relationship diagrams Data Domains Null values Indexes Views Denormalization Data Model Review The SQL Language and Tools Using SQL*Plus Why Use SQL*Plus When Other Tools Are Available? Starting SQL*Plus EZConnect SQL Commands PL/SQL Commands SQL*Plus Commands The COLUMN Command The HEADING Clause The FORMAT Clause The NOPRINT Clause The NULL Clause The CLEAR Clause Predefined define variables LOGIN.SQL Command history Copy and paste in SQL*Plus Entering SQL commands Entering PL/SQL commands Entering SQL*Plus commands Default output from SQL*Plus Entering Queries What about PL/SQL? Using SQL Developer Choosing a SQL Developer version Configuring connections Creating A Basic Connection Creating A TNS Connection Connecting Configuring preferences Using SQL Developer The Columns Tab The Data Tab The Constraints Tab The Grants Tab The Statistics Tab Other Tabs Queries In SQL Developer Query Builder Accessing Objects Owned By Other Users The Actions Pulldown Menu Differences between SQL Developer and SQL*Plus Reporting Commands Missing In SQL Developer General Commands Missing In SQL Developer Data Dictionary report User Defined reports Using scripts in SQL Developer WHERE and ORDER BY WHERE clause basics Comparison operators Literals and Constants in SQL Simple pattern matching Logical operations The DUAL table Arithmetic operations Expressions in SQL Character operators Pseudo columns Order by clause basics Ordering Nulls Accent and case sensitive sorts Sampling data WHERE and ORDER BY in SQL Developer All, Any, Some Functions The basics of Oracle functions Number functions Character functions Date functions Conversion functions Other functions Large object functions Error functions The RR format mode; Leveraging your knowledge ANSI 92 JOINS Basics of ANSI 92 Joins Using Query Builder with multiple tables Table Aliases Outer joins Outer Joins In Query Builder Set operators Self-referential joins Non-Equijoins ANSI 99 Joins Changes with ANSI99 CROSS Join NATURAL Join JOIN USING JOIN ON LEFT / RIGHT OUTER JOIN FULL OUTER JOIN Subqueries Why use subqueries? WHERE clause subqueries FROM clause subqueries HAVING clause subqueries CORRELATED subqueries SCALAR subqueries DML and subqueries EXISTS subqueries Hierarchical queries TOP N AND BOTTOM N queries Creating subqueries using Query Builder Regular Expressions Available Regular Expressions Regular Expression Operators Character Classes Pattern matching options REGEX_LIKE REGEXP_SUBSTR REGEXP_INSTR REGEXP_REPLACE REGEXP_COUNT Analytics The WITH clause Reporting aggregate functions Analytical functions User-Defined bucket histograms The MODEL clause PIVOT and UNPIVOT Temporal validity More Analytics RANKING functions RANK DENSE_RANK CUME_DIST PERCENT_RANK ROW_NUMBER Windowing aggregate functions RATIO_TO_REPORT LAG / LEAD Linear Regression functions Inverse Percentile functions Hypothetical ranking functions Pattern Matching Additional course details: Nexus Humans Introduction to SQL Programming Basics (TTSQL002) 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 Introduction to SQL Programming Basics (TTSQL002) 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.
Duration 5 Days 30 CPD hours This course is intended for Data Warehouse AdministratorDatabase Administrators Overview Use the Oracle Database tuning methodology appropriate to the available toolsUtilize database advisors to proactively tune an Oracle Database InstanceUse the tools based on the Automatic Workload Repository to tune the databaseDiagnose and tune common SQL related performance problemsDiagnose and tune common Instance related performance problemsUse Enterprise Manager performance-related pages to monitor an Oracle DatabaseGain an understanding of the Oracle Database Cloud Service In the Oracle Database 12c: Performance Management and Tuning course, learn about the performance analysis and tuning tasks expected of a DBA: proactive management through built-in performance analysis features and tools, diagnosis and tuning of the Oracle Database instance components, and diagnosis and tuning of SQL-related performance issues. In this course, you will be introduced to Oracle Database Cloud Service. Introduction Course Objectives Course Organization Course Agenda Topics Not Included in the Course Who Tunes? What Does the DBA Tune? How to Tune Tuning Methodology Basic Tuning Diagnostics Performance Tuning Diagnostics Performance Tuning Tools Tuning Objectives Top Timed Events DB Time CPU and Wait Time Tuning Dimensions Time Model Dynamic Performance Views Using Automatic Workload Repository Automatic Workload Repository Overview Automatic Workload Repository Data Enterprise Manager Cloud Control and AWR Snapshots Reports Compare Periods Defining the Scope of Performance Issues Defining the Problem Limiting the Scope Setting the Priority Top SQL Reports Common Tuning Problems Tuning During the Life Cycle ADDM Tuning Session Performance Versus Business Requirements Using Metrics and Alerts Metrics and Alerts Overview Limitation of Base Statistics Benefits of Metrics Viewing Metric History Information Viewing Histograms Server-Generated Alerts Setting Thresholds Metrics and Alerts Views Using Baselines Comparative Performance Analysis with AWR Baselines Automatic Workload Repository Baselines Moving Window Baseline Baselines in Performance Page Settings Baseline Templates AWR Baseslines Creating AWR Baselines Managing Baselines with PL/SQL Using AWR-Based Tools Automatic Maintenance Tasks ADDM Performance Monitoring Using Compare Periods ADDM Active Session History New or Enhanced Automatic Workload Repository Views Emergency Monitoring Real-time ADDM Real-Time Database Operation Monitoring Overview Use Cases Defining a Database Operation Scope of a Composite Database Operation Database Operation Concepts Identifying a Database Operation Enabling Monitoring of Database Operations Identifying, Starting, and Completing a Database Operation Monitoring Applications What is a Service? Service Attributes Service Types Creating Services Managing Services in a Single-Instance Environment Where are Services Used? Using Services with Client Applications Services and Pluggable Databases Identifying Problem SQL Statements SQL Statement Processing Phases Role of the Oracle Optimizer Identifying Bad SQL Top SQL Reports SQL Monitoring What is an Execution Plan? Methods for Viewing Execution Plans Uses of Execution Plans Influencing the Optimizer Functions of the Query Optimizer Selectivity Cardinality and Cost Changing Optimizer Behavior Optimizer Statistics Extended Statistics Controlling the Behavior of the Optimizer with Parameters Enabling Query Optimizer Features Reducing the Cost of SQL Operations Reducing the Cost Index Maintenance SQL Access Advisor Table Maintenance for Performance Table Reorganization Methods Space Management Extent Management Data Storage Using SQL Performance Analyzer Real Application Testing: Overview Real Application Testing: Use Cases SQL Performance Analyzer: Process Capturing the SQL Workload Creating a SQL Performance Analyzer Task SQL Performance Analyzer: Tasks Parameter Change SQL Performance Analyzer Task Page SQL Performance Management Maintaining SQL Performance Maintaining Optimizer Statistics Automated Maintenance Tasks Statistic Gathering Options Setting Statistic Preferences Restore Statistics Deferred Statistics Publishing Automatic SQL Tuning Using Database Replay Using Database Replay The Big Picture System Architecture Capture Considerations Replay Considerations: Preparation Replay Considerations Replay Options Replay Analysis Tuning the Shared Pool Shared Pool Architecture Shared Pool Operation The Library Cache Latch and Mutex Diagnostic Tools for Tuning the Shared Pool Avoiding Hard Parses Reducing the Cost of Soft Parses Sizing the Shared Pool Tuning the Buffer Cache Oracle Database Architecture: Buffer Cache Buffer Cache: Highlights Database Buffers Buffer Hash Table for Lookups Working Sets Buffer Cache Tuning Goals and Techniques Buffer Cache Performance Symptoms Buffer Cache Performance Solutions Tuning PGA and Temporary Space SQL Memory Usage Performance Impact Automatic PGA Memory SQL Memory Manager Configuring Automatic PGA Memory Setting PGA_AGGREGATE_TARGET Initially Limiting the size of the Program Global Area (PGA) SQL Memory Usage Automatic Memory Oracle Database Architecture Dynamic SGA Granule Memory Advisories Manually Adding Granules to Components Increasing the Size of an SGA Component Automatic Shared Memory Management: Overview SGA Sizing Parameters: Overview Performance Tuning Summary with Waits Commonly Observed Wait Events Additional Statistics Top 10 Mistakes Found in Customer Systems Symptoms Oracle Database Cloud Service: Overview Database as a Service Architecture, Features and Tooling Software Editions: Included Database Options and Management Packs Accessing the Oracle Database Cloud Service Console Automated Database Provisioning Managing the Compute Node Associated With a Database Deployment Managing Network Access to Database as a Service Scaling a Database Deployment Performance Management in the Database Cloud Environment Performance Monitoring and Tuning What Can be Tuned in a DBCS Environment?
Duration 3 Days 18 CPD hours This course is intended for This course is designed for broadcast engineers. It might also be of interest to technical solution architects, network engineers, and network administrators. Overview After taking this course, you should be able to: Describe the overall solution and how it works, and identify all components of the solution and their functions Understand initial sizing and capacity Understand the basic requirements for IPFM Understand how Non-Blocking Multicast (NBM) and multicast function in the IPFM Understand and verify Precision Time Protocol (PTP) clocking Describe the DCNM Media Controller Demonstrate the DCNM Media Controller configuration and verification Explain how to deploy an IPFM solution in a high-availability manner Use the DCNM Media Controller to monitor fabric and to troubleshoot basic connectivity and performance issues Understand the approach and basic steps involved in responding to alarms and other notifications The Operating Cisco IP Fabric for Media Solution(IPFMSN) v2.0 course introduces you to the Cisco© IP Fabric for Media (IPFM) solution. The course is designed for broadcast engineers who will use IP technologies to replace Serial Digital Interface (SDI)-based deployments. You will learn about Cisco IPFM deployment, operation, and troubleshooting.The course also covers the Data Center Network Manager (DCNM) Media Controller, a core component of the Cisco IPFM solution. Through lab exercises that focus on building IP fabric as a baseline for a complete IPFM solution, you will learn how to deploy and troubleshoot the DCNM Media Controller to control flows through the fabric. Course Outline Introducing Cisco IP Fabric for Media Media over IP Standardization Designing Cisco IPFM Solution Building Cisco IP Fabric for Media Exploring Non-Blocking Multicast in Cisco IPFM Describing Cisco DCNM Introducing Cisco DCNM PowerOn Auto Provisioning (POAP) Process Implementing Cisco DCNM Flow and Host Policies Precision Time Protocol Cisco IPFM Operations, Administration, and Management Cisco IPFM High Availability Monitoring and Troubleshooting Cisco IPFM Operation
24 Hours Left! Don't Let the Winter Deals Slip Away - Enrol Now! Risk Assessment and Management is important for any business to grow and succeed. Learn the importance of risk assessment and management in this course. Explore the hazards and risks to update the necessary control measures for your organisation. Know the fundamentals of accident reports and the appropriate risk management techniques. Make a disaster recovery plan that will help in your business Risk Assessment actions. If you are someone who wants to pursue a career in risk management, then this Risk Assessment course is very suitable for you. Learning Outcomes of Risk Assessment: After completing this risk assessment course, learners will be able to: Gain in-depth knowledge about risk assessment and its types Know more about the risk evaluation process Learn how to manage risk at the workplace Get to know what are the benefits of risk assessment Increase your financial and technological risk assessment skills So, join our comprehensive risk assessment course before the offer ends and complete it at your earliest convenience. Why Choose Our Risk Assessment Course? Opportunity to earn a certificate accredited by CPD. Get a free student ID card with this Risk Assessment Get instant access to this Risk Assessment course. Learn Risk Assessment from anywhere in the world Risk Assessment is affordable and simple to understand Risk Assessment is entirely online, interactive lesson with voiceover audio Lifetime access to the Risk Assessment course materials Risk Assessment comes with 24/7 tutor support *** Course Curriculum of the Risk Assessment Course *** Module 01: Risk and Types of Risk Overview of various risks, including financial, operational, strategic, and compliance risks, and their potential impacts on businesses. Module 02: The Risk Evaluation Process Introduction to the process of evaluating risks, including identification, assessment, and prioritisation of risks. Module 03: Risk Analysis & Assessment Covers techniques for analysing and assessing risks, focusing on qualitative and quantitative methods. Module 04: Risk Assessment and Common Risks Discussion on conducting risk assessments and identifying common risks faced by organisations. Module 05: Introduction to Risk Management Provides a foundation in risk management, including key concepts, principles, and the importance of managing risks effectively. Module 06: Risk Management Process Detailed overview of the risk management process, from risk identification to monitoring and review. Module 07: Benefits of Risk Management Highlights the advantages of effective risk management, such as improved decision-making, reduced losses, and enhanced business resilience. Module 08: Enterprise Risk Management Explores enterprise risk management (ERM) frameworks and their application in managing risks across an organisation. Module 09: Managing Financial Risks Focuses on identifying and managing financial risks, including market, credit, and liquidity risks. Module 10: Managing Technology Risks Discusses strategies for managing technology risks, including cybersecurity, data protection, and IT system failures. Assessment Start your learning journey straight away with this Risk Assessment course and take a step toward a brighter future! The Risk Assessment course is designed to provide participants with a comprehensive understanding of the principles, methodologies, and techniques involved in effectively assessing and managing risks. In today's dynamic business environment, organisations face a wide range of risks that can have a significant impact on their operations, finances, and reputation. This Risk Assessment course equips learners with the knowledge and skills needed to identify, analyse, evaluate, and mitigate risks across various domains. CPD 10 CPD hours / points Accredited by CPD Quality Standards Module 1: Risk and Types of Risk 11:15 1: Risk and Types of Risk Preview 11:15 Module 2: The Risk Evaluation Process 20:16 2: The Risk Evaluation Process 20:16 Module 3: Risk Analysis & Assessment 15:04 3: Risk Analysis & Assessment 15:04 Module 4: Risk Assessment and Common Risks 11:31 4: Risk Assessment and Common Risks 11:31 Module 5: Introduction to Risk Management 13:06 5: Introduction to Risk Management 13:06 Module 6: Risk Management Process 08:38 6: Risk Management Process 08:38 Module 7: Benefits of Risk Management 08:47 7: Benefits of Risk Management 08:47 Module 8: Enterprise Risk Management 15:39 8: Enterprise Risk Management 15:39 Module 9: Managing Financial Risks 20:22 9: Managing Financial Risks 20:22 Module 10: Managing Technology Risks 14:04 10: Managing Technology Risks 14:04 Order Your Certificate 02:00 11: Order Your CPD Certificate 01:00 12: Order Your QLS Endorsed Certificate 01:00 Who is this course for? Risk Assessment This risk assessment course is available to all. So, if you are interested in learning more about this topic, enrol and start your learning journey now. Requirements Risk Assessment You don't need any prior knowledge or qualifications to join this risk assessment course. Career path Risk Assessment After the completion of this risk assessment course. Certificates Certificate Accredited by CPD Digital certificate - Included Cademy certificate of completion Digital certificate - Included Will be downloadable when all lectures have been completed Certificate Accredited by CPD Hard copy certificate - £29 If you are an international student, then you have to pay an additional 10 GBP as an international delivery charge.
Embark on a journey to establish a successful cleaning business in the UK with our comprehensive course. Learn start-up costs, business models, legal aspects, and client satisfaction strategies. Ideal for entrepreneurs eager to thrive in the cleaning industry.
Discover the exciting area of fraud detection, mitigation, and prevention with our engaging online course, designed for tomorrow's digital defenders.
Boost Your Career with Apex Learning and Get Noticed By Recruiters in this Hiring Season! Get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £160 as a Gift - Enrol Now Are you planning for your special day? Have you an interest in working in the events and planning industry? Take steps to become a certified wedding planner with this Professional Wedding Planner course and learn how to plan the perfect event for you or your clients. The wedding is a milestone event for anyone, symbolising the start of a new phase of life. However, planning for a wedding takes a lot of time and preparation, which is why couples request the help of an industry professional who knows the planning process inside and out. In this course, you will be guided step-by-step on key areas of planning, such as choosing the right venue and negotiating with suppliers. You will explore the role of a professional wedding planner in detail, with tips on how to plan your or your client's dream wedding on a budget. This online wedding planning course is ideal for those who are pursuing a career in the event sector and would benefit anyone who wants to become an event planner or bridal consultant. What's more, you will learn how to get clients and launch your own wedding planning business from scratch. Along with this Professional Wedding Planner, you will get 10 Premium courses specially designed for Event/ Wedding Planners. Also, you will get an original hardcopy certificate, a transcript and a student ID card which will allow you to get discounts on things like music, food, travel and clothes etc. Courses are included in this Professional Wedding Planner Bundle Course 01: Wedding Planner Course 02: Wedding Photography Course 03: Catering Management Course 04: Event Planning Course 05: Bridal and Occasional Makeup Artist Masterclass Course 06: Customer Relationship Management Course 07: Interior Design Professional Diploma Course 08: Effective Communication Skills Course 09: Leisure Management Course 10: Time Management Course 11: Health and Safety at Workplace Make every wedding magical and become a sought after wedding planner, by joining the Professional Wedding Planner course. Learning Outcomes: Understand the role and responsibilities Know how to plan weddings of all types, budgets and sizes Get tips on how to market your wedding planning business Develop your understanding of wedding etiquette and dress code Gain excellent client management and communication skills Deepen your knowledge of the different types of weddings Know how to choose the right venue and location for your clients Learn bridal makeup techniques from professional makeup artists and much more... Benefits you'll get choosing Apex Learning: One payment, but lifetime access to 11 CPD courses Certificates, student ID for the title course included in a one-time fee Full tutor support available from Monday to Friday Free up your time - don't waste time and money travelling for classes Accessible, informative modules taught by expert instructors Learn at your ease - anytime, from anywhere Study the course from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills Gain valuable knowledge without leaving your home As a professional wedding planner, you will require both creativity and management skills. In this innovative course, you will gain the expertise and fundamental skills to plan themed and traditional wedding programs on a minimal budget. Course design The Professional Wedding Planner is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Written assignment Course Curriculum of Professional Wedding Planner Bundle: Course 1: Wedding Planner Module 01: An Overview of Wedding Industry Module 02: Profession of a Wedding Planner Module 03: Wedding Timelines Module 04: Wedding Budgets Module 05: The Vision, Venue, and Theme Determining Module 06: Food and Beverage and the Wedding Cake Module 07: Music, Photography and Floral Décor Module 08: Wedding Attire Module 09: Setting the Stage: Choosing, Equipping and Decorating Venue Module 10: Wedding Day Details Module 11: Post Wedding Activity and Evaluation Module 12: Starting your Own Wedding Planning Business Course 2: Bridal and Occasional Makeup Artist Module 01: The Base Module 02: Eye Makeup Module 03: Lips, Cheeks and Brows Module 04: Special Considerations for Weddings and Events Module 05: Bridal & Special Occasion Makeup as a Business Course 3: Wedding Photography Unit 1- Introduction Unit 2- The Bride Getting Ready Module 1- Applying Makeup Module 2- Dress and Shoes Module 3- Doing Up the Dress Module 4- Doing Up Other Things Module 5- Bouquet in Foreground Module 6- Bride on Sofa Module 7- Bride Formals Module 8- Bride by Window Part 1 Module 9- Bride by Window Part 2 Module 10- Bride Walking Down Stairs Unit 3- The Ceremony Module 1- Arriving at Church Module 2- Cake in the Background Module 3- Parents Seeing the Bride Module 4- Walking the Aisle Module 5- Ceremony Moments Part 1 Module 6- Ceremony Moments Part 2 Module 7- Groom's First Sight of Bride Module 8- Signing the Register Module 9- The Rings Unit 4- After the Ceremony Module 1- Bride and Groom Relaxed Module 2- Details Module 3- Congratulations Module 4- The Speeches Module 5- Through a Door Module 6- Going Over the Speeches Module 7- Groom Groom on His Own Module 8- Groom Against the Church Wall Module 9- Groom and Best Man Module 10- Groomsmen and Bridesmaids Module 11- Drinks in Foreground Module 12- First Dance Module 13- Group Formals Module 14- Kissing with Friends Module 15- Leaving by Church Doorway Module 16- Confetti Throwing Module 17- Leaving in Car Unit 5- Conclusion Course 4: Catering Management Module 1: An Overview of Catering Business Module 2: Laws and Legislations Regarding food Safety and Hygiene Module 3: Food Safety and Hygiene Module 4: Food Safety in Catering Module 5: Management of Food and Beverage Operations Module 6: Marketing and Human Resource Course 5: Event Planning Module 1: Introduction to Event Management Module 2: Role of an Event Planner Module 3: Event Classification Module 4: Events and Clients Module 5: Steps to Plan an Event Module 6: Invitation to the Event Module 7: Event Marketing Module 8: Catering at Events Module 9: Event Decorations Module 10: Cleaning and Waste Disposal Module 11: Event Security Module 12: Developing an Event Planning Business Course 6: Interior Design Professional Diploma Module 1: Introduction to Interior Design Module 2: Design Principles Module 3: Project Overview Module 4: Design Elements Module 5: Design Elements Practical Components Module 6: Room by Room Design Module 7: Popular Interior Designs Module 8: Sustainable Design Module 9: Presenting Your Ideas Module 10: Managing Interior Design Business Course 7: Customer Relationship Management Module 01: Introduction to Customer Relationship Management (CRM) Module 02: CRM Fundamentals Module 03: CRM Strategies CRM Strategies Module 04: Data Analysis in CRM Module 05: CRM Databases Module 06: Deepening Customer Relationship Module 07: Handling Customer Complaints Module 08: Future of CRM Course 8: Performance Management Performance Management Section 01: Introduction Section 02: Performance Section 03: Key Performance Indicators Section 04: Reporting Section 05: Rewarding Section 06: Conclusion Course 9: Leisure Management Module 01: Introduction to Leisure Management Module 02: Managing and Maintaining a Leisure Facility Module 03: Travel, Tourism and Leisure Module 04: Managing Hotel and Lodging Module 05: Planning for Leisure Services Module 06: Leadership in Leisure Industry Module 07: Human Resource Management in Leisure Industry Module 08: Marketing of Leisure and Recreation Module 09: Health, Safety and Welfare Course 10: Effective Communication Skills Module 01: Business Communication Module 02: Verbal and Non-verbal Communication Module 03: Written Communication Module 04: Electronic Communication Module 05: Communicating with Graphic Module 06: Effectively Working for Your Boss Course 11: Health and Safety at Workplace Module 01: Health and Safety at Work and the Laws Module 02: Managing for Health and Safety Module 03: Risk Assessment and Common Risks Module 04: Workplace Health, Safety and Welfare Module 05: Accidents and Ill Health at Work Module 06: Electrical, Fire and Gas Safety Module 07: Safety in Different Work Settings Module 08: Work Equipment Hazards and Risk Control Module 09: Other Health and Safety Hazards at Work How will I get my Certificate? After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £10 * 11 = £110) Hard Copy Certificate: Free (For The Title Course) If you want to get hardcopy certificates for other courses, generally you have to pay £20 for each. But this Fall, Apex Learning is offering a Flat 50% discount on hard copy certificates, and you can get each for just £10! P.S. The delivery charge inside the U.K. is £3.99 and the international students have to pay £9.99. CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? There is no experience or previous qualifications required for enrolment on this course. It is available to all students, of all academic backgrounds. Requirements Our course is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path These skills can be used to add value to your CV when exploring career opportunities in events planning. It will equip learners with the core skills required to work in the following professions: Wedding Planner Special Events Coordinator Events Manager Events & Party Planner Certificates Certificate of completion Digital certificate - Included
Learn to build chatbots for various platforms such as Facebook, Slack, Skype, Kik, Telegram and others with the Chatbots for Multiple Platforms - Without Coding course. A chatbot is a computer program or an artificial intelligence which is designed to simulate a conversation with human users, especially over the Internet via auditory or textual methods. In the course, you will learn to create chatbots for various platforms without coding. The course shows you the techniques of developing sophisticated chatbots that use button and Ai to ensure great customer experience. You will learn to build a chatbot in Gupshup.io, Motion.ai, and more. The course helps you to develop the first bot. Upon completion, you will be able to create chatbots that can able to perform various operations. What Will I Learn? By the end of the course you will be able to build an iBeacon enabled mobile app ready to be submitted to the app stores (Apple and Google Play) You will understand what an iBeacon is and what are some of the potential uses. You will understand what programs are needed to build beacon apps and where to download them (for free). You will understand the different types of beacons, what are the costs involved, what services are provided by the various beacon makers. You will know how to build an app for testing and giving to your clients for testing. Requirements You need to have a MAC computer to build the apps - currently PC is not supported. It is also possible to do this on a Windows machine if you install a Virtual machine and run the MAC OS in a window on your PC. Take a look at this for an overview: https://blog.udemy.com/xcode-on-windows/ For testing iBeacon functionality you will need 2 things. 1) a device to act as a beacon, and 2) an i Device or an Andoid Device (details in the course). A desire to learn! This is not difficult, it only takes following instructions and havign a desire to learn. Who is the target audience? Web and Mobile designers, marketing people, and business ownvers who want to learn how to leverage the next level of mobile interactions by incorporating iBeacons. No programming background needed - this is really a course for anyone - you really do not need to have any coding background. Marketing and retial people are also encouraged to take this course to understand the potential for greater customer interactions made possible with iBeacons. Mobile phone app makers who want to learn how to incorporate iBeacons into existing apps the easy and fast way. Introduction to Chatbots 1. Introduction 00:03:00 2. Chatbot Examples 00:06:00 Building a Chatbot in Gupshup.io 2. Introduction to Gupshup 00:02:00 3. Gupshup Travel Bot Part 1 00:11:00 4. Gupshup Improving the User Experience 00:02:00 5. Gupshup Order an Uber 00:02:00 7. Gupshup Helsinki Weather 00:04:00 8. Gupshup Publishing Your Bot 00:02:00 Gobot Easy and Powerful Ready Made Chatbot Services 1. Gobot Introduction 00:01:00 3. GoBot Site Example 00:02:00 4. Gobot Parts of the System 00:01:00 5. Gobot Make a bot Part 1 00:08:00 6. Gobot Make a bot Part 2 00:03:00 7. Gobot Publishing your Bot 00:08:00 A Facebook Messenger Bot 1. Introducing Chatfuel 00:02:00 2. Understanding A Chatfuel Bot - Test Bot 00:05:00 3. Building Our Own Facebook Messenger Bot - A Retail Example part 1 00:02:00 4. Catfuel and Images - Getting them right 00:06:00 5. Chatfuel Product Gallery with More Information 00:09:00 6. Chatfuel - Plugins - Adding an RSS feed with Subscription 00:07:00 7. Chatfuel - Plugins - YouTube Integration 00:07:00 8. Chatfuel - Collecting Uder Input via Email 00:06:00 9. Chatfuel - Advanced Features 00:09:00 10. Chatfuel - Work Around for Button Linking Problem 00:02:00 11. Chatfuel - Add a Site Search - Bing or Google Search 00:07:00 12. Chatfuel - Publish Your Bot - Two Options 00:03:00 UPDATE - MiniApp Chatbot Building System 1. Introduction to MiniApp 00:02:00 2. Connecting a MiniApps Bot to the Microsoft Bot Framework 00:10:00 3. MiniApps Creating the Bot Interactions 00:04:00 4. MiniApps Connecting your bot to Skype 00:02:00 5. MiniApps Simple now but other options are possible 00:01:00 6. MiniApps Conslusion 00:02:00 Building a Chatbot in Motion.ai 2. Looking at the Motion.ai Interface 00:02:00 3. Motion.ai Interface Part 2 00:02:00 Building Our First Bot - A travel bot 1. Part 1 - Setting up the Travel Bot 00:01:00 2. Part 2 - Looking at The Connections 00:02:00 3. Part 3 - Adding Buttons via HTML and Cards 00:07:00 4. Part 4 - Adding Other Content with Widgets - Weather Example 00:03:00 5. Part 5 - Connecting Your Bot to Another Bot - Uber Example 00:03:00 6. Part 6 - Creating Multiple Cards - Travel Sights Bot 00:10:00 7. Part 7 - Clean-up - Global Settings and Help 00:03:00 Entertainment bot Example - The Bender Bot 1. Bender Bot Part 1 - Looking at how the bot works 00:04:00 2. Bender Bot Part 2 - Advanced - Adding a new interaction 00:06:00 3. Bender Bot Part 3 - Final connnections and things to think about with Motion.ai 00:09:00 Thank You 1. Thank you and contacts 00:01:00