3780 Courses

Duration 5 Days 30 CPD hours This course is intended for Workspace ONE UEM and Workspace ONE Access operators and administrators, account managers, solutions architects, solutions engineers, sales engineers, and consultants Overview By the end of the course, you should be able to meet the following objectives: Explain and apply the fundamental techniques for launching and maintaining an intelligence-driven, multiplatform endpoint management solution with Workspace ONE UEM Outline the components of Workspace ONE UEM Explain the general features and functionality enabled with Workspace ONE UEM Summarize the basic Workspace ONE administrative functions Explain and deploy common Workspace ONE integrations Securely deploy configurations to Workspace ONE UEM managed devices Onboard device endpoints into Workspace ONE UEM Summarize the alternative management methodologies for rugged devices Discuss strategies to maintain environment and device fleet health Configure and deploy applications to Workspace ONE UEM managed devices Analyze a Workspace ONE UEM deployment Enable email access on devices Integrate Workspace ONE UEM with content repositories and corporate file shares Explain the general features and functionalities that Workspace ONE Access enables Demonstrate how to integrate Workspace ONE UEM with Workspace ONE Access Summarize and implement Workspace ONE productivity services into the digital workspace environment Explain the methods of enabling mobile single sign-on for mobile endpoints managed in the digital workspace Configure Workspace ONE Access to support SAML 2.0 for federated authentication across the workforce In this five-day course, you learn how to apply the fundamental techniques for launching and maintaining an intelligence-driven, multiplatform, endpoint management solution with VMware Workspace ONE© UEM. Through a combination of hands-on labs, simulations, and interactive lectures, you will configure and manage the endpoint life cycle. After the course, you will have the foundational knowledge for effectively implementing Workspace ONE UEM.Also, you learn how to apply the fundamental techniques for integrating VMware Workspace ONE© Access? with Workspace ONE UEM to securely distribute business-critical applications from any device and to configure access management controls. Through a combination of hands-on labs, simulations, and interactive lectures, you configure Workspace ONE Access and Workspace ONE UEM system and productivity integrations.You will leave with a foundational understanding of how Workspace ONE uses various authentication methods and protocols to determine user access permissions and enable single sign-on. Overall, the course lays out the foundational principles of identity and access management.Please note - This course is a combination of the VMware Workspace ONE: Skills for UEM and the VMware Workspace ONE: Integrations course. Course Introduction Introductions and course logistics Course objectives Platform Architecture Summarize the features and functionality of Workspace ONE UEM Outline the benefits of leveraging Workspace ONE UEM Recognize the core and productivity components that make up the Workspace ONE UEM platform Summarize high availability and disaster recovery for the Workspace ONE solution Administration Navigate and customize the Workspace ONE UEM console Summarize the hierarchical management structure Explain the features and functions of Workspace ONE Hub Services Outline account options and permissions Enterprise Integrations Outline the process of integrating with directory services Explain certificate authentication and practical implementation with Workspace ONE Explain the benefits of integrating an email SMTP service into the Workspace ONE UEM console Describe VMware Dynamic Environment Manager and its architecture Onboarding Outline the prerequisite configurations in the Workspace ONE UEM environment for onboarding devices for management Outline the steps for setting up autodiscovery in the Workspace ONE UEM console Enroll an endpoint through the VMware Workspace ONE© Intelligent Hub app Summarize the platform onboarding options Managing Endpoints Explain the differences between device and user profiles Describe policy management options for Windows and macOS Describe the functions and benefits of using compliance policies Explain the use case for Freestyle Orchestrator Describe the capabilities that sensors and scripts enable. Alternative Management Methods Describe the function and benefits of device staging Configure product provisioning in the Workspace ONE UEM console Understand the benefits of deploying a VMware Workspace ONE© Launcher? configuration to Android devices List the system and device requirements for Linux device management in Workspace ONE UEM Applications Describe the features, benefits, and capabilities of application management in Workspace ONE UEM Understand and configure deployment settings for public, internal, and paid applications in the Workspace ONE UEM console Describe the benefits of using Apple Business Manager content integration Describe the benefits of using server-to-client software distribution List the functions and benefits of VMware Workspace ONE© SDK Device Email List the email clients supported by Workspace ONE UEM Configure an Exchange Active Sync profile in the Workspace ONE UEM console Configure VMware Workspace ONE© Boxer settings Summarize the available email infrastructure integration models and describe their workflows Configure email compliance policies and notifications services Content Sharing Describe the benefits of using Content Gateway Describe the Content Gateway workflows Describe the benefits of integrating content repositories with Workspace ONE UEM Configure a repository in the Workspace ONE UEM console Maintenance Manage endpoints from the Device List view and the Details view. Analyze endpoint deployment and compliance data from the Workspace ONE UEM Monitor page. Workspace ONE Access Summarize the benefits of Workspace ONE Access Outline the core features and functions enabled by Workspace ONE Access Navigate the Workspace ONE Access console Explain the functions of directory integration with Workspace ONE Access Explain the various types of authentication protocols enabled by Workspace ONE Access Integrating Workspace ONE UEM and Workspace ONE Access Explain the rationale for integrating Workspace ONE UEM and Workspace ONE Access Outline the process of connecting Workspace ONE UEM and Workspace ONE Access Examine the workflow of integrations Summarize the key features of an integrated solution Productivity Integrations Identify the functions enabled by VMware Unified Access Gateway? Outline the purpose of the VMware AirWatch© Secure Email Gateway? edge service Explain the features enabled by the VMware Workspace ONE© Tunnel? edge service Summarize the capabilities enabled by the Content Gateway edge service SAML 2.0 Authentication Outline the authentication methods supported by Workspace ONE Access Summarize the main properties of the SAML protocol Summarize the SAML authentication workflow Explain the application SSO authentication workflow with SAML Mobile Single Sign-On Describe the concept of mobile SSO Outline the mobile SSO workflows Intelligence and Automation Summarize the features of Workspace ONE© Intelligence? Outline the benefits of using Workspace ONE Intelligence Additional course details:Notes Delivery by TDSynex, Exit Certified and New Horizons an VMware Authorised Training Centre (VATC) Nexus Humans VMware Workspace ONE: Deploy and Manage [V22.x] 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 VMware Workspace ONE: Deploy and Manage [V22.x] 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.

Mosaic Summer School

Masterclasses? Refreshers? Introductions? It depends what you're looking for and where you want to pitch them, but here are six tried-and-tested highly focused sessions that organisations can take individually or as a series, to help develop their teams' project management capabilities one topic at a time. Objectives for each individual session are set out below, as part of the session outlines. Taken together, as a series, however, these modules are an ideal opportunity to develop your team's levels of project management capability maturity, whether that's by introducing them to the basic principles, refreshing them on best practice, or giving them the opportunity to really drill down into a specific area of challenge in your particular operating environment. Session outlines 1 Stakeholder management Session objectives This session will help participants: Understand why stakeholders matter to projects Be able to identify and engage stakeholders Be able to categorise stakeholders by their significance 1 Key principles What does 'stakeholder' mean - in theory? What does this mean in practice? Why stakeholders matter Consequences of missing stakeholders The stakeholder management process:IdentifyAssessPlanEngage 2 Identifying stakeholders Rapid listing CPIG analysis PESTLE analysis Drawing on the knowledge and experience of others Other ways to identify stakeholders 3 Assessing stakeholders Which stakeholders are significant? Stakeholder radar Power-interest maps Power-attitude maps 4 Planning The adoption curve Dealing with obstacles Who should engage which stakeholder? How should the project's organisation be structured? How will communication happen? 5 Engaging Seven principles of stakeholder engagement 2 Requirements and prioritisation Session objectives This session will help participants: Understand how clarity of requirements contributes to project success Use different techniques for prioritising requirements Agree requirements with stakeholders Manage changes to requirements 1 Understanding and managing stakeholder needs and expectations What are 'requirements'? What is 'requirements management'? Sources of requirements - and the role of stakeholders Are stakeholders sufficiently expert to specify their needs? Do they understand the detail of what they want, or do they need help to tease that out? What do stakeholders want to achieve? Working within constraints Prioritising requirements - three techniques 2 MoSCoW prioritisation 'Must have', should have', 'could have, 'won't have this time' When to use MoSCoW 3 The Kano Model Customer satisfaction - 'attractive' and 'must-be' qualities When to use Kano 4 Value-based prioritisation Understanding risk v value Using risk v value to prioritise features and schedules 5 Agreeing requirements Perfect v 'good enough' Establishing acceptance criteria Requirements traceability Agreeing project scope 6 Changing requirements Why requirements change Why change control matters Impact on projects A formal change control process Paying for change - managing change for different types of project 3 Estimating Session objectives This session will help participants: Understand the different purposes estimates satisfy Be able to use different estimating techniques Understand how to achieve different levels of accuracy 1 Key principles What's an estimate? Informed guesswork What needs to be estimated? Costs, resources, effort, duration Tolerances Precision v accuracy 2 Estimating through the lifecycle Start Plan Do 3 Early estimates Comparative ('analogous') estimating Parametric estimating Using multiple estimating techniques 4 Bottom-up estimating Bottom-up ('analytical') estimating Pros Cons 5 Three-point estimating Three-point ('PERT': Programme Evaluation and Review Technique) estimating Uncertainty and the range of estimates Calculating a weighted average Three-point with bottom-up 4 Scheduling Session objectives This session will help participants: Understand how to create a viable schedule Be able to use different forms of schedule Understand the concept of the critical path 1 Key principles The planning horizon Rolling wave planning Release planning 2 Viable scheduling Creating a viable schedule Define the scope Sequence the work Identify the risks and build in mitigations Identify the resources Estimate the effort and durations Check resource availability Refine until a workable schedule is produced 3 Critical path analysis The critical path Network diagrams Sequence logic Practical application:Network diagram with estimated durationsThe 'forward pass'The 'backward pass'Calculating total floatIdentifying the critical pathCalculating free float Gantt charts 5 Risk and issue management Session objectives This session will help participants: Understand the difference between risks and issues Be able to identify and assess risks Understand ways of mitigating risks Manage issues 1 Key principles Understanding risk Threats and opportunities The risk management processPreparation - proactive risk managementThe process - identify, assess, plan, implementStakeholder communication Roles and responsibilities Risk management strategy The risk register Risk appetite 2 Risk identification Brainstorming Interviews Assumption analysis Checklists 3 Risk assessment and prioritisation Probability, impact and proximity Triggers Qualitative risk assessment Qualitative impact assessment Qualitative probability assessment Probability / impact grid Bubble charts Risk tolerance 4 Planning countermeasures To mitigate or not to mitigate? Categories of risk response Avoid and exploit Reduce and enhance Transfer Share Accept Contingency Secondary risks 5 Issue management What is an issue? Tolerances Issues and tolerances The PRINCE2 view of issues Ownership of issues An issue management process Issue register 6 Budgeting and cost control Session objectives This session will help participants: Understand what to include in a budget - and why Choose - and use - the appropriate estimating technique Align the budget with the schedule Understand how to monitor spend and control costs Trouble-shoot effectively to get projects back within budget Session format Flexible. The session can be tailored to the participants' average level of project management maturity - a 60-minute session (delivered virtually) is an effective introduction. A 90-minute session allows for more in-depth treatment. A half-day session (face-to-face or virtual) gives time for a more challenging workshop, particularly to discuss specific cost control issues with any of the participants' current projects. 1 Where is the money coming from? Can we pay from revenue? Do we need to borrow? How long will the project take to pay back? The lifecycle of the budget Through-life costs Stakeholder involvement 2 Estimating costs Reminder: the relationship between estimates Reminder: possible estimating techniques What do we need to estimate?PeopleEquipmentMaterialsFacilities and operating costsWork package estimateEstimated project costs Estimating agile projects 3 Aligning budget and schedule Scheduling and financial periods Spreading the budget 4 Reserves and agreeing the budget Contingency reserve Management reserve Agreeing the budget 5 Cost control Planned spend over time Actual spend over time Work completed over time Evaluating different scenarios: delivery v spend 6 Trouble-shooting Why are we where we are? What has caused the project to spend at the rate it is? Why is it delivering at the rate it is? What are the root causes? What can we do about it?

Do you love books? Do you love the feel of a new book, the smell of the pages, and the way they look on your shelf? But do you wish that you could create your own books? We have just what you need! Our Bookbinding Workshop is a beginner course that will teach you how to make canvas bound, Japanese bound, and journal style books in the comfort of your own home. We provide all of the materials and full instruction is provided by our expert staff. You will be able to create a small library of books that are sure to impress anyone who sees them!

Here in this Sketchbook Workshop, we believe that art should be fun and accessible to everyone. That's why we have a wide variety of materials and techniques to choose from, so you can find your own style and approach. Our workshops are centered around your interests and needs, so whether you want to learn new skills or gain inspiration for your next project, we'll help you find it. You can find inspiration in the studio or the beautiful countryside it sits in. You'll leave feeling confident to carry on at home

Overview Education and training can significantly influence one's ability to flourish. This Focus Awards Level 4 Certificate in Education and Training (RQF) qualification will encourage you to think strategically and critically, allowing you to perform successfully.This 36-credit Level 4 Certificate in Education and Training (RQF) qualification is offered by Focus Awards. This honourable awarding organisation is regulated by Ofqual and assures competence and recognition of your qualifications.The remarkable course is crafted into mandatory and optional units so you can acknowledge the concepts better. It starts with the basic insights and proceeds towards advanced levels to encourage you to focus. It covers almost every aspect of education and training. You will discover ingenious ways to teach, learn, and assess alongside other professional practices. You'll become a useful employee capable of innovating, tackling challenges, and progressing on your own. So what are you waiting for? Roll up your sleeves and get yourself enrolled in this thriving certification! Benefits You Will Gain Top-notch e-learning materials Modules availability 24/7 An easy-to-use online learning platform Flexible learning hours Recognised qualification Exquisite customer service Qualification Focus Awards Level 4 Certificate in Education and Training (RQF) Description Learners must complete all mandatory units totalling 21 credits along with 15 credits from the remaining optional units to create a total credit value of 36.From this qualification, you will: Know the roles, responsibilities and relationships in education and training. Understand how to assess learners in education and training. Develop and prepare resources for learning and development. Meet the needs of learners. Qualification Purpose The Focus Awards Level 4 Certificate in Education and Training (RQF) qualification is designed to provide students with knowledge and understanding of delivering education and training, assessing learners, using resources, and understanding the roles and responsibilities in relevant fields. Who is this course for? Individuals interested in pursuing a career as an Education and Training Specialist, Teacher or other related fields. Requirements This qualification has no specific entry requirements. However, the learners must be at least 18 or above. Progression Upon successfully completing this qualification, learners may wish to continue their development by undertaking the following qualification. Level 5 Diploma in Education and Training (RQF) Total Qualifications Time  Total Qualification Time is comprised of GLH and an estimate of the number of hours a learner is likely to spend in preparation, study or any other learning, including assessment, which takes place as directed by, but not under the supervision of a lecturer, supervisor or tutor. Total Qualification Time for this qualification is 360 hours.The credit for this qualification is 36. Guided Learning Hours These hours are made up of all contact time, guidance or supervision of a learner by a lecturer, supervisor, tutor, trainer or other appropriate providers of education or training. Guided Learning Hours for this qualification is 140. Method of Assessment The Focus Awards Level 4 Certificate in Education and Training (RQF) is internally assessed, and each student must construct a portfolio of evidence demonstrating the achievement of all learning outcomes and assessment criteria linked with each unit, like- Assessor observation - completed observational checklists on related action plans. Witness testimony Learner product Worksheets Assignments / projects / reports Record of oral and written questioning Learner and peer reports Recognition of prior learning (RPL) Career Path Education and Training Specialist Child and Youth Program Assistant Academic Advisor English Educator Teacher Professional Trainer Course Curriculum 42 sections • 187 lectures • 00:00:00 total length •Induction Form: 00:00:00 •Registration Entry Form: 00:00:00 •0 - Certificate Units - Information for Delivery: 00:00:00 •0 - Resource Information and Terms and Conditions of Use: 00:00:00 •At018c - Pre Course Assessment Certificate: 00:00:00 •At050c - Sample Action Plan for the Certificate in Education and Training: 00:00:00 •Pgu1c - Guidance for Evidencing Achievement - Understanding Roles , Responsibilities and Relationships: 00:00:00 •Sau1c - Self Assessment Grid - Understanding Roles, Responsibilities and Relationships: 00:00:00 •G9001C - Information leaflet - An introduction to the Certificate in Education and Training: 00:00:00 •G9002C - Information leaflet - Teaching Roles, Responsibilites, Relationships and Boundaries: 00:00:00 •G9003C - Information leaflet - Legislation, Regulatory Requirements, Codes of Practice: 00:00:00 •G9007C - Information leaflet - Promoting Equality and Valuing Diversity: 00:00:00 •G9008C - Information leaflet - Promoting Appropriate Behaviour and Respect: 00:00:00 •I0001A - PP - Learner Needs and Points of Referral: 00:00:00 •I9001C - Information leaflet - Learner Needs and Points of Referral: 00:00:00 •M9063a - Information Leaflet - Beginners Guide to Referencing: 00:00:00 •G0001C - PP - An Introduction to the Certificate in Education and Training: 00:00:00 •G0002A - PP - Teaching Roles, Responsibilities, Relationships and Boundaries: 00:00:00 •G0003A - PP - Legislation, Regulatory Requirements and Codes of Practice: 00:00:00 •G0007A - PP - Promoting Equality and Valuing Diversity: 00:00:00 •G0008A - PP - Promoting Appropriate Behaviour and Respect: 00:00:00 •H9001 - Handout - Identifying Inequality: 00:00:00 •H9002 - Handout - Learner Differences: 00:00:00 •H9003 - Handout - Ways to promote and advance equality: 00:00:00 •H9004 - Glossary of educational terms: 00:00:00 •H9005 - Educational abbreviations and acronyms: 00:00:00 •H9007 - Demonstrating good practice to promote inclusion: 00:00:00 •H9008 - Handout - Safeguarding Prevent British Values: 00:00:00 •H9010 - Handout - Table of examples of teaching roles and responsibilities: 00:00:00 •H9011a - Handout - Boundaries of Teaching: 00:00:00 •H9014C - Verbs used in the Certificate in Education and Training units: 00:00:00 •H9015 - Handout - the Teaching and Learning Cycle: 00:00:00 •H9020a - Handout - Table of Examples of Potential Needs and Points of Referral: 00:00:00 •H9051 - Handout - Tips for New Teachers and Trainers: 00:00:00 •HC004 - Checklist for Equality and Diversity: 00:00:00 •Hc012 - Checklist for Teaching: 00:00:00 •I9011- Handout - Equality and Diversity - Glossary of Terms: 00:00:00 •0 - Certificate Units - Information for Delivery: 00:00:00 •0 - Resource Information and Terms and Conditions of Use: 00:00:00 •Pgu2c - Guidance for Evidencing Achievement - Planning to Meet the Needs of Learners: 00:00:00 •Sau2c - Self Assessment Grid - Planning to Meet the Needs of Learners: 00:00:00 •Atmc01 - Checklist - Minimum Core Personal Skills: 00:00:00 •Hc012 - Checklist for Teaching: 00:00:00 •Hc014 - Checklist for Reviewing Own Practice - Planning: 00:00:00 •AT005 - Template - Reflective Learning Journal: 00:00:00 •At007 - Template - Session Plan Pro-forma: 00:00:00 •At013 - Template - Scheme of Work Rationale: 00:00:00 •At014 - Template - Scheme of Work: 00:00:00 •At022 - Template - Initial and Diagnostic Assessment: 00:00:00 •At023 - Template - Individual Learning Plan: 00:00:00 •At024 - Template - Group Profile: 00:00:00 •At025 - Template - Workshop Plan: 00:00:00 •C9007 - Information leaflet - Initial and Diagnostic Assessment: 00:00:00 •C9008 - Information leaflet - Devising a Scheme of Work: 00:00:00 •C9009 - Information Leaflet - Designing a Session Plan: 00:00:00 •C9010 - Information Leaflet - the Minimum Core Planning: 00:00:00 •C9011 - Information Leaflet - Reviewing Own Practice Planning: 00:00:00 •C0007 - Pp - Initial and Diagnostic Assessment: 00:00:00 •C0008 - Pp - Devising a Scheme of Work: 00:00:00 •C0009 - Pp - Designing a Session Plan: 00:00:00 •C0010 - PP - The Minimum Core Planning: 00:00:00 •C0011 - PP - Reviewing own Practice Planning: 00:00:00 •C9054 - Group Profile Completed Example: 00:00:00 •A9051a - Handout - Table of Assessment Methods, Approaches and Activities: 00:00:00 •A9058 - Handout - Table of Strengths and Limitations of Teaching and Learning Approaches: 00:00:00 •H9012 - Handout - Table of Resources: 00:00:00 •I9015A - Handout - Example Completed Reflective Learning Journal: 00:00:00 •M9060 - Handout - Example Completed Scheme of Work: 00:00:00 •M9061 - Handout - Completed Example Scheme of Work Rationale: 00:00:00 •M9062 - Handout - Example Completed Session Plan: 00:00:00 •M9064 - Handout - Five Minute Session Plan: 00:00:00 •M9065 - Handout - Example Three Stage Session Plan: 00:00:00 •U9053a - Handout - Table of Objectives at Different Levels: 00:00:00 •0 - Certificate Units - Information for Delivery: 00:00:00 •0 - Resource Information and Terms and Conditions of Use: 00:00:00 •Pgu3c - Guidance for Evidencing Achievement - Delivering Education and Training: 00:00:00 •Sau3c - Self Assessment Grid - Delivering Education and Training: 00:00:00 •Atmc01 - Checklist - Minimum Core Personal Skills: 00:00:00 •Hc003 - Checklist for Verbal, Listening, Non Verbal and Written Communication: 00:00:00 •Hc004 - Checklist for Equality and Diversity: 00:00:00 •Hc005 - Checklist for Demonstrating a Task: 00:00:00 •Hc012 - Checklist for Teaching: 00:00:00 •Hc013 - Observation Checklist - Certificate Units: 00:00:00 •Hc015 - Checklist for Reviewing Own Practice - Delivery: 00:00:00 •AT003 - Template - Personal Development Plan: 00:00:00 •AT005 - Template - Reflective Learning Journal: 00:00:00 •At009 - Template - Self Evaluation of a Delivered Session Pro-forma: 00:00:00 •At021 - Template - Teaching Practice Log: 00:00:00 •At026 - Template - Tutorial Review: 00:00:00 •C9006 - Information Leaflet - Reviewing Own Practice Delivering: 00:00:00 •C9012 - Information Leaflet - Observations and Teaching Practice: 00:00:00 •C9016 - Information Leaflet - Communication With Learners and Others: 00:00:00 •C9022 - Information Leaflet - the Minimum Core Delivering: 00:00:00 •C9023 - Information Leaflet - Teaching and Learning Approaches: 00:00:00 •C9024 - Information Leaflet - an Inclusive Teaching and Learning Environment: 00:00:00 •C9025 - Information Leaflet - Teaching and Learning Theories: 00:00:00 •C9026 - Information Leaflet - Using Technologies in Teaching and Learning: 00:00:00 •C0006 - Pp - Reviewing Own Practice Delivering: 00:00:00 •C0012 - Pp - Observations and Teaching Practice: 00:00:00 •C0016 - Pp - Communication With Learners and Others: 00:00:00 •C0022 - Pp - the Minimum Core Delivering Education and Training: 00:00:00 •C0023 - Pp - Teaching and Learning Approaches: 00:00:00 •C0024 - Pp - an Inclusive Teaching and Learning Environment: 00:00:00 •C0025- Pp - Teaching and Learning Theories: 00:00:00 •C0026 - Pp - Using Technologies in Teaching and Learning: 00:00:00 •A9058 - Handout - Table of Strengths and Limitations of Teaching and Learning Approaches: 00:00:00 •A9060 - Handout - Example Completed Personal Development Plan: 00:00:00 •H9006 - the Environment - Examples of Physical, Social and Learning Aspects: 00:00:00 •H9012 - Handout - Table of Resources: 00:00:00 •H9016 - Handout - Teaching Practice Log Information: 00:00:00 •H9019 - Handout - List of Technologies: 00:00:00 •H9021 - Handout - Advantages and Disadvantages of Using Technology: 00:00:00 •H9022 - Handout - Online Safety: 00:00:00 •H9025 - Examples of Verbal and Non Verbal Communication: 00:00:00 •H9026 - Handout Examples of CPD activities: 00:00:00 •H9027 - Handout Working with an LSA: 00:00:00 •H9031 - Handout Starter and closing activities: 00:00:00 •H9032 - Handout Reviewing Learner Progress: 00:00:00 •H9033 - Handout Individual and Group Tutorials: 00:00:00 •H9034 - Handout Facilitating Group Learning: 00:00:00 •H9035 - Handout Facilitating Individual Learning: 00:00:00 •H9036 - Handout Extension Activities: 00:00:00 •I9015a - Handout - Example Completed Reflective Learning Journal: 00:00:00 •M9057 - Handout - Example Completed Self Evaluation Form: 00:00:00 •0 - Certificate Units - Information for Delivery: 00:00:00 •0 - Resource Information and Terms and Conditions of Use: 00:00:00 •Pgu4c - Guidance for Evidencing Achievement - Assessing Learners in Education and Training: 00:00:00 •Sau4c - Self Assessment Grid - Assessing Learners in Education and Training: 00:00:00 •Atmc01 - Checklist - Minimum Core Personal Skills: 00:00:00 •Hc012 - Checklist for Teaching: 00:00:00 •Hc013 - Observation Checklist - Certificate Units: 00:00:00 •Hc016 - Checklist for Reviewing Own Practice - Assessment: 00:00:00 •AT001 - Templates - Assessment Records: 00:00:00 •AT005 - Template - Reflective Learning Journal: 00:00:00 •At021 - Template - Teaching Practice Log: 00:00:00 •C9012 - Information Leaflet - Observations and Teaching Practice: 00:00:00 •C9017 - Information Leaflet - the Minimum Core Assessing: 00:00:00 •C9018 - Information Leaflet - Reviewing Own Practice Assessment: 00:00:00 •C9019 - Information leaflet - Types of Assessment: 00:00:00 •C9020 - Information Leaflet - Assessment Methods: 00:00:00 •C9021 - Information Leaflet - Making Decisions Giving Feedback and Keeping Records: 00:00:00 •C0012 - Pp - Observations and Teaching Practice: 00:00:00 •C0017 - Pp - The Minimum Core Assessment: 00:00:00 •C0018 - Pp - Reviewing Own Practice Assessment: 00:00:00 •C0019 - Pp - Types of Assessment: 00:00:00 •C0020 - PP - Assessment Methods: 00:00:00 •C0021 - Pp - Making Assessment Decisions, Giving Feedback and Keeping Records: 00:00:00 •A9050 - Handout - Table of Assessment Types: 00:00:00 •A9051a - Handout - Table of Assessment Methods, Approaches and Activities: 00:00:00 •A9053 - Handout - Table of Assessment Requirements: 00:00:00 •A9057 - Handout - Assessor Roles and Responsibilities: 00:00:00 •A9059 - Handout - Completed Example of Assessment Records: 00:00:00 •G9052 - Handout - Table of Advantages and Limitations of Peer and Self Assessment: 00:00:00 •H9016 - Handout - Teaching Practice Log Information: 00:00:00 •H9050 - Handout - Table of Example Teaching Records: 00:00:00 •I9015a - Handout - Example Completed Reflective Learning Journal: 00:00:00 •0 - Certificate Units - Information for Delivery: 00:00:00 •0 - Resource Information and Terms and Conditions of Use: 00:00:00 •Pgu5c - Guidance for Evidencing Achievement - Using Resources for Education and Training: 00:00:00 •Sau5c - Self Assessment Grid - Using Resources for Education and Training: 00:00:00 •Atmc01 - Checklist - Minimum Core Personal Skills: 00:00:00 •Hc012 - Checklist for Teaching: 00:00:00 •Hc013 - Observation Checklist - Certificate Units: 00:00:00 •Hc017 - Checklist for Reviewing Own Practice - Resources: 00:00:00 •AT005 - Template - Reflective Learning Journal: 00:00:00 •At021 - Template - Teaching Practice Log: 00:00:00 •C9012 - Information Leaflet - Observations and Teaching Practice: 00:00:00 •C9013 - Information Leaflet - Using Resources: 00:00:00 •C9014 - Information Leaflet - the Minimum Core Resources: 00:00:00 •C9015 - Information Leaflet - Reviewing Own Practice Resources: 00:00:00 •C0012 - Pp - Observations and Teaching Practice: 00:00:00 •C0013 - PP - Using Resources: 00:00:00 •C0014 - PP - The Minimum Core Resources: 00:00:00 •C0015 - Pp - Reviewing Own Practice Resources: 00:00:00 •H9012 - Handout - Table of Resources: 00:00:00 •H9016 - Handout - Teaching Practice Log Information: 00:00:00 •H9018 - Handout - Hints and Tips for Creating and Using Handouts and Visual Presentations: 00:00:00 •H9023 - Handout - Resource Box: 00:00:00 •H9024 - Handout - Assistive Resources: 00:00:00 •I9015a - Handout - Example Completed Reflective Learning Journal: 00:00:00 •Policy and Regulatory Frameworks on Inclusive Practice: 00:00:00 •Maintaining Inclusive Learning Environment: 00:00:00 •Inclusive Practice Roles and Responsibilities: 00:00:00 •Factors-Influencing-Learning: 00:00:00 •Evaluating Own Inclusive Practice: 00:00:00 •Assignment: Optional Unit 34 - Inclusive Practice: 00:00:00 •Submit Your Assignments: 00:00:00

Duration 5 Days 30 CPD hours This course is intended for The target audience for this textbook is all Oracle professionals, both business and systems professionals. Among the specific groups for whom this textbook will be helpful are: ? Business and non-IT professionals ? Application designers and database developers ? Business Intelligence (BI) analysts and consumers ? Database administrators ? Web server administrators Overview The first portion of this textbook considers the logical models upon which a relational database is based and the various configurations and environments in which you may work with the Oracle database. The next segment focuses on the actual SQL syntax for writing database queries. You will begin with the simplest of queries and then proceed onto moderately complex query scenarios. Finally, this textbook covers the DDL, DML and transaction control portions of the SQL language that allow one to create, maintain and manipulate application database objects and application data. This textbook takes a unique approach to SQL training in that it incorporates data modeling theory, relational database theory, graphical depictions of theoretical concepts and numerous examples of actual SQL syntax into one learning vehicle. Relational Databases & Data Models About Data Models About the Relational Model The Electronics Data Model About the Relational DBMS Selection & Setup of the Database Interface Considering Available Tools Selecting the Appropriate Tool Oracle Net Database Connections Oracle PAAS Database Connections Setup SQL Developer Setup SQL*Plus Setup Jdeveloper Using the Database Interface About Bind & Substitution Variables Using SQL Developer Using SQL*Plus Introduction to the SQL Language About the SQL Language Characteristics of SQL Introducing SQL Using Select SQL Rules The Select Statement The Select Statement Distinct/Unique Keyword Using Alias Names Restricting Results with the Where Clause About Logical Operators Equality Operator Boolean Operators REGEXP_LIKE() In Operator Sorting Data with the Order By Clause About the Order by Clause Multiple Column Sorts Specify the Sort Sequence About Null Values within Sorts Using Column Aliases Pseudo Columns, Functions & Top-N Queries Rowid Pseudo Column ORA_ROWSCN PSEUDO Column ROWNUM Pseudo Column About the Built-In Functions SYSDATE User & UID SESSIONTIMEZONE Function Using the Dual Table Row Limiting & Top-N Queries FETCH First x Rows Only Clause OFFSET x Rows Clause FETCH?PERCENT Clause The WITH TIES Option Joining Tables About Joins Inner Joins Reflexive Join Non-Key Join Outer Join Using the Set Operators About the Set Operators SQL Set Operator Examples UNION Example INTERECT Example MINUS Example UNION All Summary Functions Using Sub-Queries Finding Data with Sub-Queries Standard Sub-Queries Correlated Sub-Queries The EXISTS Operator Aggregating Data within Groups About Summary Groups Find Groups within the Tables Select Data From the Base Tables Select Groups from the Results Use DDL to Create & Manage Tables Create Table Statement Column Data Types Not Null Default Describe Alter Table Statement Drop Table Statement Table DDL Using SQL Developer Alter User Statement Alter Session Statement NLS_Language NLS_Date Use DML to Manipulate Data The Insert Statement The Delete Statement The Update Statement About Transactions Transaction Rollback Transaction Commit Transaction Savepoint The Set Transaction Statement Set Transaction Read Only Statement Rules Understanding the Data Models The Company Data Model The Electronics Data Model About the SQL-99 Standard SQL-92 & SQL-99 Cross Joins Natural Joins Inner Joins Implicit Inner Join Outer Joins Anti Joins Named Sub-Queries Enhancing Groups with Rollup & Cube Using Rollup The Grouping() Function Using Cube SQL Functions: Character Handling What are the SQL Functions? String Formatting Functions UPPER(), LOWER() Example INITCAP() Example Character Codes Functions CHR((), ASCII() Examples PAD & TRIM Functions RPAD() Example RTRIM() Example TRIM() Example String Manipulation Functions DECODE () Example SUBSTR() Example INSTR() Example TRANSLATE() Example REPLACE() Example String Comparison Functions LEAST() Example Phonetic Search Function SOUNDEX() Example SQL Functions: Numeric Handling About the Numeric Data Functions GREATEST() Example ABS() Example ROUND() Example TRUNC() Example SIGN() Example TO_NUMBER() Example & Data ype Conversions NULL VALUES FUNCTIONS NVL() & NVL2() Function NVL() Example (Character) NVL() Example (Numeric Loss of Data) NVL() Example (Numeric Output) NVL2() Example COALESCE() Function NULLIF() Function SQL Functions: Date Handling Date Formatting Functions TO_CHAR() & TO_DATE() Format Patterns TO_CHAR() Examples TO_DATE() Examples EXTRACT() Example Date Arithmetic Functions MONTHS_BETWEEN() Example ADD_MONTHS() Example LAST_DAY() Example NEXT_DAY() Example TRUNC(), ROUND() Dates Example NEW_ TIME() Example About V$TIMEZONE_NAMES CAST() FUNCTION & TIME ZONES Database Objects: About Database Objects About Database Objects About Schemas Making Object References Database Objects: Relational Views About Relations Views The Create View Statement Why Use Views? Accessing Views with DML Maintaining View Definitions Alter View Drop View DDL Using SQL Developer Database Objects: Indexes About Indexes Create & Drop Index Statements Indexes & Performance Data Dictionary Storage Database Objects: Creating Other Objects About Sequences Referencing NEXTVAL Referencing CURRVAL Within the DEFAULT Clause Alter Sequence & Drop Sequence ALTER SEQUENCE DROP SEQUENCE About Identity Columns CREATE TABLE?GENERATED AS IDENTITY ALTER TABLE?GENERATED AS IDENTITY Start With Limit Value ALTER TABLE...DROP IDENTITY About Synonyms CREATE & DROP SYNONYM Statements CREATE SYNONYM DROP SYNONYM Public Vs Private Synonyms CREATE SCHEMA AUTHORIZATION Database Objects: Object Management Using DDL The RENAME Statement TABLESPACE Placement CREATE TABLE?TABLESPACE The Comment Statement The TRUNCATE TABLE Statement Database Objects: Security About Object Security Grant Object Privileges Revoke Object Privileges Object Privileges & SQL Developer Data Integrity Using Constraints About Constraints NOT NULL Constraint NOT NULL Example CHECK Constraint UNIQUE Constraint PRIMARY KEY Constraint REFERENCES Constraint ON DELETE CASCADE Example ON DELETE SET NULL Example Constraints on Existing Tables Constraints & SQL Developer Managing Constraint Definitions RENAMING & DROPPING Constraints ENABLING & DISABLING Constraints DEFERRED Constraint Enforcement SET CONSTRAINTS Handling Constraint Exceptions Constraints with Views DATA Dictionary Storage The Data Dictionary Structure More About the Data Dictionary OBJECT-SPECIFIC Dictionary Views USER_UPDATABLE_COLUMNS The Dictionary Structure METADATA & SQL Developer Additional course details: Nexus Humans Oracle 12c SQL Fundamentals 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 SQL Fundamentals 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.

Are you interested in learning how to make polymer clay jewellery? Join us for a fun and informative workshop that will teach you everything you need to know about conditioning the clay, texturing, cutting, shaping the clay, forming and moulding. You'll create a range of finished jewellery pieces that you can take home with you afterwards. This is a great way to learn some new skills and explore a wide variety of style and techniques that are easy enough for beginners but also have room for more advanced learners!

An Essential Sewing & Making Skills Course for Teachers of GCSE & A Level Fashion & Textiles for both Art & Design and D&T.

An immersive and creative cross curricular experience with art, drama, science and exploration.