• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

7582 Insights courses delivered Online

Private Investigator Crime Scene Analysis

5.0(1)

By Course Gate

Explore the essential skills and knowledge needed for a successful career in private investigation and crime scene analysis. This comprehensive course covers practical techniques, from interviews and interrogation to surveillance and records research, ensuring you are well-prepared for real-world challenges in criminal justice.

Private Investigator Crime Scene Analysis
Delivered Online On Demand11 hours
£29

Bach Flower Remedies

5.0(1)

By LearnDrive UK

Discover the holistic world of Bach Flower Remedies with our comprehensive course. Learn to prepare, preserve, and integrate these natural remedies for emotional balance and well-being across various age groups and emotional states.

Bach Flower Remedies
Delivered Online On Demand1 hour
£5

AutoCAD Level 1 - Essentials

By Nexus Human

Duration 3 Days 18 CPD hours This course is intended for Professionals who want unparalleled creative freedom, productivity, and precision for producing superb 3D modeling. Overview Navigate the AutoCAD user interfacesUse the fundamental features of AutoCADUse the precision drafting tools in AutoCAD to develop accurate technical drawingsPresent drawings in a detailed and visually impressive way In this course, you will learn to navigate the AutoCAD user interfaces and use the fundamental features of AutoCAD. You will learn to use the precision drafting tools in AutoCAD to develop accurate technical drawings. Getting Started with AutoCAD Starting the Software User Interface Working with Commands Cartesian Workspace Opening an Existing Drawing File Viewing Your Drawing Saving Your Work Basic Drawing & Editing Commands Drawing Lines Erasing Objects Drawing Lines with Polar Tracking Drawing Rectangles Drawing Circles Undo and Redo Actions Projects - Creating a Simple Drawing Create a Simple Drawing Create Simple Shapes Drawing Precision in AutoCAD Using Running Object Snaps Using Object Snap Overrides Polar Tracking at Angles Object Snap Tracking Drawing with Snap and Grid (Optional) Making Changes in Your Drawing Selecting Objects for Editing Moving Objects Copying Objects Rotating Objects Scaling Objects Mirroring Objects Editing with Grips Projects - Making Your Drawing More Precise Schematic Project: Electronics Diagram Architectural Project: Landscape Mechanical Project (with Polar & Tracking) Mechanical Project: Surge Protector Mechanical Project: Satellite Organizing Your Drawing with Layers Creating New Drawings With Templates What are Layers? Layer States Changing an Object's Layer Advanced Object Types Drawing Arcs Drawing Polylines Editing Polylines Drawing Polygons Drawing Ellipses Analzying Model and Object Properties Working with Object Properties Measuring Objects Projects - Drawing Organization & Information Architectural Project Mechanical Project Civil Project Advanced Editing Commands Trimming and Extending Objects Stretching Objects Creating Fillets and Chamfers Creating Arrays of Objects Inserting Blocks What are Blocks? Working with Dynamic Blocks Inserting Blocks Inserting Blocks using the Tool Palettes Inserting Blocks using the DesignCenter Inserting Blocks using the Content Explorer Projects - Creating More Complex Objects Mechanical Project 1 - Plate Mechanical Project 2 - Gasket Mechanical Project 3 - Plate Mechanical Project 4 - Rocker Arm Architectural Project 1 - Floor Plan Architectural Project 2 - Floor Plan Civil Project - Parking Lot Setting Up a Layout Printing Concepts Working in Layouts Creating Layouts Creating Layout Viewports Guidelines for Layouts Printing Your Drawing Printing Layouts Print and Plot Settings Projects - Preparing to Print Mechanical Project Architectural Project Text Working with Annotations Adding Text in a Drawing Modifying Multiline Text Formatting Multiline Text Adding Notes with Leaders to Your Drawing Creating Tables Modifying Tables Hatching Hatching Editing Hatches Adding Dimensions Dimensioning Concepts Adding Linear Dimensions Adding Radial and Angular Dimensions Editing Dimensions Projects - Annotating Your Drawing Mechanical Project Architectural Project 1 Architectural Project 2 Civil Project Additional course details: Nexus Humans AutoCAD Level 1 - Essentials 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 AutoCAD Level 1 - Essentials 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.

AutoCAD Level 1 - Essentials
Delivered OnlineFlexible Dates
Price on Enquiry

Business Soft Skills

By Nexus Human

Duration 1.5 Days 9 CPD hours This course is intended for This course is intended for individuals who want to gain basic knowledge communicating, etiquette, professionalism and time management for the office environment. Overview Upon successful completion of this course, students will be able to communicate, be professional and manage their time effectively in a business environment. In this course, students will learn how to communicate, act and manage time effective in a business environment. Getting Started Icebreaker Housekeeping Items The Parking Lot Workshop Objectives The Big Picture What is Communication? How Do We Communicate? Other Factors in Communication Understanding Communication Barriers An Overview of Common Barriers Language Barriers Cultural Barriers Differences in Time and Place Paraverbal Communication Skills The Power of Pitch The Truth about Tone The Strength of Speed Non-Verbal Communication Understanding the Mehrabian Study All About Body Language Interpreting Gestures Speaking like a Star S = Situation T = Task A = Action R = Result Summary Listening Skills Seven Ways to Listen Better Today Understanding Active Listening Sending Good Signals to Others Asking Good Questions Open Questions Closed Questions Probing Questions Appreciative Inquiry The Purpose of AI The Four Stages Examples and Case Studies Mastering the Art of Conversation Level One: Discussing General Topics Level Two: Sharing Ideas and Perspectives Level Three: Sharing Personal Experiences Our Top Networking Tips Advanced Communication Skills Understanding Precipitating Factors Establishing Common Ground Using ?I? Messages Wrapping Up Words from the Wise Review of Parking Lot Lessons Learned Completion of Action Plans and Evaluations Principles of Professional Behavior Always be Your Best Meeting and Greeting Sending Social Invitations to Business Associates Interview Etiquette Interviewing Before the Interview In the Waiting Room During the Interview After the Interview Job Fair Interviews Planning & Attending Business Meetings Office Meetings Meal Meetings Electronic Etiquette Voicemail Cell Phones Email Multiculture Etiquette Defining the Challenge Five Steps to Dealing with Diversity Guidelines for Managing Diverse Relationships Time Management Concepts Benefits of better time utilization Who controls your schedule? Your Job: What You Are Responsible for Accomplishing? Your job responsibilities Setting objectives Setting priorities How to Use Your Time Gathering data-the time log Analyzing the data Delegation: Working Through Others Why some people don't delegate Levels of delegation How to delegate Benefits of delegation Getting started Planning: Keys to Achievement Planning: Keys to Achievement Coping with Common Time Wasters Coping with self-generated time wasters Coping with environmental time wasters Personal Needs that Get in the Way of Effective Time Utilization Needs profile analysis Self-assessment questionnaire Applying needs assessment results Planning for Improvement Six tips for effective time management Planning for improved time utilization Follow-Up: Staying on Track Time savings progress report Time savings progress chart Time management progress survey Additional course details: Nexus Humans Business Soft Skills 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 Business Soft Skills 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.

Business Soft Skills
Delivered OnlineFlexible Dates
Price on Enquiry

Entrepreneurship and Business Start-Up Essentials

4.3(43)

By John Academy

Discover the essential skills and strategies for launching and managing a successful business venture with our comprehensive Entrepreneurship and Business Start-Up Essentials course. From idea generation to sustainability, master market analysis, financial planning, legalities, sales, marketing, team building, and more. Get ready to embark on your entrepreneurial journey with confidence!

Entrepreneurship and Business Start-Up Essentials
Delivered Online On Demand3 hours
£23.99

Advanced Diploma in Anatomy and Physiology

4.3(43)

By John Academy

Overview Health careers are always in demand. And having sound knowledge of human anatomy and psychology is beneficial not only for healthcare jobs but also for your personal health. This Advanced Diploma in Anatomy and Physiology course will provide you with a comprehensive understanding of human anatomy and psychology. As a result, you can brace yourself with a promising career in the field of science.  In this Advanced Diploma in Anatomy and Physiology course, you'll discover the theoretical and practical functionalities of the human body. The course will provide you with valuable insights into the major body systems and how they interact with each other. Furthermore, you'll get excellent information on the major levels of organisation in the body, such as molecules, cells, tissues and organs. By the end of the training, you will know how the human body develops and changes throughout life.  Learning Outcomes Find a comprehensive overview of human psychology and anatomy Learn about the body systems and their functions Enrich your knowledge of the major level of organisations in the body Understand the chemical level of organisation Know the anatomy of the nervous system Determine the functions of the skeletal system Know the types of body movements Broaden your understanding of the cranial nerves Understand the anatomy of the heart Who is the Course for? This Advanced Diploma in Anatomy and Physiology course is suitable for anyone interested in understanding human anatomy and psychology. In addition, the training will open doors to various health career opportunities. 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 for 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 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. Why Choose Us? Affordable, well-structured and high-quality e-learning study materials Engaging tutorial videos, materials from the industry-leading experts Opportunity to study in a user-friendly, advanced online learning platform Efficient exam systems for the assessment and instant result UK & internationally recognised accredited qualification Access the course content on mobile, tablet, or desktop from anywhere, anytime Excellent career advancement opportunities 24/7 student support via email. Career Path Advanced Diploma in Anatomy and Physiology Course provides useful skills to possess and would be beneficial for the following professionals: Medical laboratory technician. Physical therapist assistant. MRI technologist. Medical technologist Nurse. Personal trainer. Massage therapist Science teacher Updated Version-Advanced Diploma in Anatomy and Physiology Module 01: The Chemistry of Cells The Chemistry of Cells 00:27:00 Module 02: Cells Cells 00:16:00 Module 03: Cell Division Cell Division 00:19:00 Module 04: Replication and Metabolism Replication and Metabolism 00:20:00 Module 05: Human Tissues Human Tissues 00:25:00 Module 06: Skin Skin 00:16:00 Module 07: Human Skeletal System Human Skeletal System 00:21:00 Module 08: The Muscular System The Muscular System 00:17:00 Module 09: Skeletal Muscle Fibre Skeletal Muscle Fibre 00:23:00 Module 10: Nervous System Nervous System 00:31:00 Module 11: The Brain The Brain 00:25:00 Module 12: Nervous System-Spinal Cord and Spinal Nerves Nervous System-Spinal Cord and Spinal Nerves 00:15:00 Module 13: Nervous System - Autonomic Nervous System and Cranial Nerves Nervous System - Autonomic Nervous System and Cranial Nerves 00:21:00 Module 14: Nervous System-The Eyes Nervous System-The Eyes 00:15:00 Module 15: Nervous System-The Ears, Hearing, and Equilibrium Nervous System-The Ears, Hearing, and Equilibrium 00:14:00 Module 16: Nervous System-Memory Nervous System-Memory 00:19:00 Module 17: Sensory Systems Sensory Systems 00:23:00 Module 18: Cardiovascular System Cardiovascular System 00:25:00 Module 19: Blood Blood 00:27:00 Module 20: Lymphatics Lymphatics 00:20:00 Module 21: Immune System Immune System 00:26:00 Module 22: Digestive System Digestive System 00:22:00 Module 23: Respiratory System Respiratory System 00:19:00 Module 24: Urinary System Urinary System 00:16:00 Module 25: Male Reproductive System Male Reproductive System 00:31:00 Module 26: Female Reproductive System Female Reproductive System 00:31:00 Order Your Certificate Order Your Certificates and Transcripts 00:00:00 Old Version-Advanced Diploma in Anatomy and Physiology Introduction to the Human Body Overview of Anatomy and Physiology 00:20:00 Structural Organization of the Human Body 00:15:00 Functions of Human Life 00:15:00 Requirements for Human Life 00:15:00 Homeostasis 00:15:00 Anatomical Terminology 00:15:00 Medical Imaging 00:15:00 The Chemical Level Elements and Atoms: The Building Blocks of Matter 00:25:00 Chemical Bonds 00:25:00 Chemical Reactions 00:20:00 Inorganic Compounds Essential to Human Functioning 00:15:00 Organic Compounds Essential to Human Functioning 00:20:00 The Cellular Level The Cell Membrane 00:20:00 The Cytoplasm and Cellular Organelles 00:15:00 The Nucleus and DNA Replication 00:15:00 Protein Synthesis 00:15:00 Cell Growth and Division 00:20:00 Cellular Differentiation 00:10:00 The Tissue Level Types of Tissues 00:15:00 Epithelial Tissue 00:20:00 Muscle Tissue and Motion 00:05:00 Nervous Tissue Mediates Perception and Response 00:05:00 Tissue Injury and Aging 00:15:00 The Integumentary System Layers of the Skin 00:20:00 Accessory Structures of the Skin 00:15:00 Functions of the Integumentary System 00:10:00 Diseases, Disorders, and Injuries of the Integumentary System 00:15:00 Bone Tissue and the Skeletal System The Functions of the Skeletal System 00:10:00 Bone Classification 00:10:00 Bone Structure 00:20:00 Bone Formation and Development 00:10:00 Fractures: Bone Repair 00:05:00 Exercise, Nutrition, Hormones, and Bone Tissue 00:15:00 Calcium Homeostasis: Interactions of the Skeletal System and Other Organ Systems 00:10:00 Axial Skeleton Divisions of the Skeletal System 00:05:00 The Skull 00:45:00 The Vertebral Column 00:20:00 The Thoracic Cage 00:05:00 Embryonic Development of the Axial Skeleton 00:10:00 Joints Classification of Joints 00:10:00 Fibrous Joints 00:10:00 Cartilaginous Joints 00:05:00 Synovial Joints 00:20:00 Types of Body Movements 00:20:00 Anatomy of Selected Synovial Joints 00:25:00 Development of Joints 00:05:00 Muscle Tissue Introduction to Muscle Tissue 00:05:00 Skeletal Muscle 00:15:00 Muscle Fiber Contraction and Relaxation 00:20:00 Nervous System Control of Muscle Tension 00:20:00 Types of Muscle Fibers 00:05:00 Exercise and Muscle Performance 00:10:00 Cardiac Muscle Tissue 00:05:00 Smooth Muscle 00:15:00 Development and Regeneration of Muscle Tissue 00:05:00 The Muscular System Interactions of Skeletal Muscles, Their Fascicle Arrangement, and Their Lever Systems 00:10:00 Naming Skeletal Muscles 00:10:00 Axial Muscles of the Head, Neck, and Back 00:20:00 Axial Muscles of the Abdominal Wall and Thorax 00:25:00 Muscles of the Pectoral Girdle and Upper Limbs 00:30:00 Appendicular Muscles of the Pelvic Girdle and Lower Limbs 00:15:00 The Nervous System and Nervous Tissue Basic Structure and Function of the Nervous System 00:15:00 Nervous Tissue 00:15:00 The Function of Nervous Tissue 00:10:00 The Action Potential 00:15:00 Communication Between Neurons 00:15:00 Anatomy of the Nervous System The Embryologic Perspective 00:15:00 The Central Nervous System 00:25:00 Circulation and the Central Nervous System 00:15:00 The Peripheral Nervous System 00:15:00 The Brain and Cranial Nerves Sensory Perception 00:30:00 Central Processing 00:30:00 Motor Responses 00:15:00 The Autonomic Nervous System Divisions of the Autonomic Nervous System 00:15:00 Autonomic Reflexes and Homeostasis 00:20:00 Central Control 00:10:00 Drugs that Affect the Autonomic System 00:15:00 The Endocrine System Introduction to Endocrine System 00:05:00 Hormones 00:15:00 The Pituitary Gland and Hypothalamus 00:15:00 The Thyroid Gland 00:15:00 The Parathyroid Glands 00:05:00 The Adrenal Glands 00:10:00 Gonadal and Placental Hormones 00:05:00 The Endocrine Pancreas 00:10:00 Organs with Secondary Endocrine Functions 00:05:00 Development and Aging of the Endocrine System 00:10:00 The Cardiovascular System: Blood Overview of Blood 00:20:00 Production of the Formed Elements 00:10:00 Erythrocytes 00:30:00 Leukocytes and Platelets 00:15:00 Hemostasis 00:20:00 Blood Typing 00:10:00 The Cardiovascular System: The Heart Heart Anatomy 00:50:00 Cardiac Muscle and Electrical Activity 00:30:00 Cardiac Cycle 00:20:00 Cardiac Physiology 00:20:00 Development of the Heart 00:10:00 Mock Exam Mock Exam - Advanced Diploma in Anatomy and Physiology 00:20:00 Final Exam Final Exam - Advanced Diploma in Anatomy and Physiology 00:20:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

Advanced Diploma in Anatomy and Physiology
Delivered Online On Demand35 hours
£14.99

GRC300 SAP Access Control Implementation and Configuration

By Nexus Human

Duration 5 Days 30 CPD hours This course is intended for The primary audience for this course are Application Consultants, Business Process Architects, and Business Process Owners/Team Leads/Power Users. Overview This course will prepare you to:Describe tasks performed by a typical SAP Access Control userDiscuss Harmonization topics as they relate to SAP Access ControlExplain how SAP GRC helps you to address business challengesIdentify authorization risks in typical business processesDescribe the Segregation of Duties Risk Management ProcessDescribe and configure functionality and features for SAP Access Control 10.1Use the SAP Access Control 10.1 application to analyze and manage risk, design and manage roles, and provision and manage usersDescribe the SAP Access Control 10.1 architecture and landscape, SAP Access Control Repository, and Object Level SecurityDescribe the Periodic Access Review processPlan for and manage emergency accessDiscuss the reporting frameworkConfigure workflows, including multi-stage multi-path (MSMP) workflows and BRF+Describe how the different applications of the SAP GRC Solution integrate with each otherDiscuss key steps in the SAP Access Control implementation process In this course, students gain hands-on configuration and implementation experience of SAP Access Control 10.1, as well as important concepts they will need to know in order to prepare for implementation and ongoing access risk prevention. Introduction to SAP Access Control Discussing Business Challenges and Solutions Using SAP Access Control Architecture, Security, and Authorizations Describing the System Architecture Describing Security and Authorizations Shared Configuration Settings Configuring Shared GRC Settings Configuring Shared SAP Access Control Settings Authorization Risks and the Segregation of Duties (SoD) Management Process Identifying Authorization Risks Managing Risk by Segregating Duties SAP Access Control Repository Synchronizing Objects into the Repository Scheduling and Viewing Background Jobs Risk Analysis Maintaining Shared Master Data Configuring and Maintaining the Rule Set Configuring and Using Audit Trail Tracking Using the Risk Analysis Framework Remediating Risks Mitigating Risks Mitigating Multiple Risks at One Time Business Rule Framework Creating Rules in the Business Rule Framework (BRF) Defining Business Rules Multi-Stage, Multi-Path (MSMP) Workflow Describing Multi-Stage, Multi-Path (MSMP) Workflow Maintaining MSMP Workflow Building MSMP Workflow User Provisioning Configuring User Provisioning Settings Configuring Access Request Forms Requesting Access Preparing Roles and Owner Data for MSMP Workflow Creating Simplified Access Requests Reviewing Search Request Results SAP Fiori User Experience (UX) for GRC Describing SAP Fiori UX Role Design and Management Configuring Role Management Configuring Role Methodology Configuring Role Search Attributes Planning for Technical Role Definition Planning for Business Role Definition Consolidating Roles Through Role Mining Performing Role Mass Maintenance Operations Emergency Access Management Describing Emergency Access Management Planning for Emergency Access Monitoring Emergency Access Periodic Access Review Process Planning Periodic Review Monitoring Periodic Review Reports and Custom Fields Use the Reporting Framework SAP Access Control Implementation Using the SAP Access Control Implementation Process Designing the SAP Access Control Solution Planning Upgrade and Migration Configuring SAP Access Control Implementing the SAP Access Control solution Optimizing the SAP Access Control Suite Additional course details: Nexus Humans GRC300 SAP Access Control Implementation and Configuration 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 GRC300 SAP Access Control Implementation and Configuration 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.

GRC300 SAP Access Control Implementation and Configuration
Delivered OnlineFlexible Dates
Price on Enquiry

Writing Analytical Queries for Business Intelligence

By Nexus Human

Duration 3 Days 18 CPD hours This course is intended for This course is intended for information workers and data science professionals who seek to use database reporting and analysis tools such as Microsoft SQL Server Reporting Services, Excel, Power BI, R, SAS and other business intelligence tools, and wish to use TSQL queries to efficiently retrieve data sets from Microsoft SQL Server relational databases for use with these tools. Overview Identify independent and dependent variables and measurement levels in their own analytical work scenarios. Identify variables of interest in relational database tables. Choose a data aggregation level and data set design appropriate for the intended analysis and tool. Use TSQL SELECT queries to produce ready-to-use data sets for analysis in tools such as PowerBI, SQL Server Reporting Services, Excel, R, SAS, SPSS, and others. Create stored procedures, views, and functions to modularize data retrieval code. This three-day instructor-led course is about writing TSQL queries for the purpose of database reporting, analysis, and business intelligence. Specifically, this course presents TSQL within the context of data analysis in other words, making meaning from the data rather than transaction-oriented data-tier application development. The course starts with a brief discussion of levels of measurement and quantitative research methodogy, and integrates these concepts into each TSQL topic presented. The goal is to provide a consistent, direct, and purposeful learning path from RDBMS data retrieval through analytical tools such as SQL Server Reporting Services, PowerBI, Excel, R, SAS, and SPSS. Module 1: Introduction to TSQL for Business Intelligence Two Approaches to SQL Programming TSQL Data Retrieval in an Analytics / Business Intelligence Environment The Database Engine SQL Server Management Studio and the CarDeal Sample Database Identifying Variables in Tables SQL is a Declarative Language Introduction to the SELECT Query Module 2: Turning Table Columns into Variables for Analysis: SELECT List Expressions, WHERE, and ORDER BY Turning Columns into Variables for Analysis Column Expressions, Data Types, and Built-in Functions Column aliases Data type conversions Built-in Scalar Functions Table Aliases The WHERE clause ORDER BY Module 3: Combining Columns from Multiple Tables into a Single Dataset: The JOIN Operators Primary Keys, Foreign Keys, and Joins Understanding Joins, Part 1: CROSSJOIN and the Full Cartesian Product Understanding Joins, Part 2: The INNERJOIN Understanding Joins, Part 3: The OUTERJOINS Understanding Joins, Part 4: Joining more than two tables Understanding Joins, Part 5: Combining INNER and OUTERJOINs Combining JOIN Operations with WHERE and ORDER BY Module 4: Creating an Appropriate Aggregation Level Using GROUP BY Identifying required aggregation level and granularity Aggregate Functions GROUP BY HAVING Order of operations in SELECT queries Module 5: Subqueries, Derived Tables and Common Table Expressions Non-correlated and correlated subqueries Derived tables Common table expressions Module 6: Encapsulating Data Retrieval Logic Views Table-valued functions Stored procedures Creating objects for read-access users Creating database accounts for analytical client tools Module 7: Getting Your Dataset to the Client Connecting to SQL Server and Submitting Queries from Client Tools Connecting and running SELECT queries from: Excel PowerBI RStudio Exporting datasets to files using Results pane from SSMS The bcp utility The Import/Export Wizard Additional course details: Nexus Humans Writing Analytical Queries for Business Intelligence 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 Writing Analytical Queries for Business Intelligence 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.

Writing Analytical Queries for Business Intelligence
Delivered OnlineFlexible Dates
Price on Enquiry

VMware Cloud on AWS: Deploy, Configure, Manage 2021

By Nexus Human

Duration 4 Days 24 CPD hours This course is intended for Experienced system administrators, system engineers, and system integrators Overview By the end of the course, you should be able to meet the following objectives:Describe the architecture of VMware Cloud on AWS, Deploy a VMware Cloud on AWS SDDC and virtual machines (VMs),Configure internal, external, and inter-SDDC networking, Describe and configure storage integrations and solutions for VMware Cloud on AWS,Configure a connection between an on-premises vSphere SDDC and a VMware Cloud on AWS SDDC,Configure the scale-up and scale-down of a VMware Cloud on AWS SDDC,Migrate virtual machines between on-premises vSphere and VMware Cloud on AWS SDDCs,Describe and configure disaster recovery solutions,Describe additional services that add value to a VMware Cloud on AWS SDDC,Describe lifecycle, troubleshooting scenarios, and support resources for a VMware Cloud on AWS SDDC This four-day, hands-on training course provides you with the knowledge, skills, and tools for deploying and managing a VMware Cloud? on AWS infrastructure. You explore the common use cases of the VMware Cloud on AWS infrastructure that allows you to modernize, protect, and scale applications based on VMware vSphere© that leverage AWS.In this course, you are introduced to various rapid and easy migration options for workloads based on vSphere to VMware Cloud on AWS. In addition, you are presented with VMware Cloud Disaster Recovery?, which is a Disaster Recovery as-a-service (DRaaS) solution, with fast recovery capabilities, that can be used to cost-effectively protect a broad set of your virtualized applications. Course Introduction Introductions and course logistics Course objectives Introduction to VMware Cloud on AWS Why choose VMware Cloud on AWS Management and operational structure VMware Cloud on AWS Platform and SDDC Deployment Preparation Getting started with VMware Cloud on AWS Preparing AWS infrastructure for a VMware Cloud on AWS deployment Setting up a VMware on Cloud AWS account Billing and pricing on VMware Cloud services Deploying and Scaling and SDDC Deploying and examining SDDC configurations Sizing the SDDC SDDC cluster management SDDC host management Optimizing and maintaining an SDDC cluster using Elastic DRS for VMware Cloud? on AWS Accessing and Analyzing vCenter Configurations Accessing vCenter Server in the Cloud SDDC from the public internet Creating virtual machines in the Cloud SDDC Analyzing HA, DRS, and resource pools settings in the SDDC Analyzing vSphere permissions Networking in VMware Cloud on AWS Internal SDDC network Networking and security options Inter-SDDC networking Storage on VMware Cloud on AWS vSAN storage in VMware Cloud on AWS Attaching external storage to a VM running on an SDDC Working with On-Premises vSphere Hybrid linked mode VMware Cloud on AWS migration solutions Virtual machine migration with VMware Hybrid Cloud Extension Maintaining and Troubleshooting VMware Cloud on AWS Accessing API with VMware Cloud on AWS Maintenance and support Common troubleshooting steps Disaster Recovery Solution Site Recovery add-on service VMware Cloud Disaster Recovery Using Other VMware Products with the SDDC VMware vRealize© Log Insight Cloud? VMware Horizon© with VMware Cloud on AWS VMware vRealize© Automation Cloud? add-on Additional course details:Notes Delivery by TDSynex, Exit Certified and New Horizons an VMware Authorised Training Centre (VATC) Nexus Humans VMware Cloud on AWS: Deploy, Configure, Manage 2021 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 Cloud on AWS: Deploy, Configure, Manage 2021 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.

VMware Cloud on AWS: Deploy, Configure, Manage 2021
Delivered OnlineFlexible Dates
Price on Enquiry

ICSDWAN-CT-Implementing, Configuring, Monitoring, and Troubleshooting Cisco (Viptela)SDWAN

By Nexus Human

Duration 5 Days 30 CPD hours Overview SDWAN Overview Cisco SDWAN Hardware Deploying the Overlay Configuring vManage Deploying using Templates Creating Policies Monitoring vManage vAnalytics Troubleshooting Tools for VManage In this Implementation and Configuration SDWAN Course, students will deploy and configure SD-WAN Controllers, vEdge Devices, and Cisco IOS-XE Devices. Students will create Multiple Device and CLI Templates that will allow Hundreds of devices to be deployed using only a few Centralized Templates. Students will create Security Policies to enable the Enterprise Firewall, IDS/IPS, URL Filtering, and Web Layer Security to protect and allow Enterprises to deploy Cloud applications as well as Direct Internet Access (DIA). Students will also create Local and Central Policies that enable a Centralized Policy control of WAN Routing and device QOS configuration and enforcement. Students will also learn how Cisco SD-WAN allows Enterprises to deploy an effective Cloud Solutions such as Amazon AWS, Microsoft Azure, and Google Cloud. Students will also learn how to Monitor and Troubleshoot the SD-WAN Solution. SDWAN Overview Describe what a Software-Defined Wide Area Network (SD-WAN) is Describe the secure extensible network Describe the function of the virtual IP fabric created in the SD-WAN solution What is SDWAN Cisco Cloud vs On-premises vs private cloud management Cisco IWAN vs Viptela SDWAN IWAN Migration to SDWAN SDWAN Integration with Cisco Cisco SDWAN Licensing Deploying Cisco SDWAN Controllers On-Prem vs Cloud deployment vManage NMS vBond Orchestrator Deploy the vSmart Controller Controller High Availability Cluster Management Cisco SDWAN Certificates and Whitelists On-Prem vs Cloud Certificate deployment Controller Certificates Hardware Device Certificates Software Device Certificates Certificates Device Whitelists Controller Whitelists Cisco SDWAN Edge Devices vEdge Appliances vEdge Cloud Cisco IOS-XE Platforms Cisco CSR 1000V Router Cisco 54xx Enterprise Network Compute System (ENCS) Cisco SDWAN Fabric and Overview Virtual Fabric Overview Overlay Management Protocol Transport Locators (TLOCs) Multicast TCP Optimization Opening Firewall Ports Software Installation and Upgrade vEdge Routers Deploying vEdge Routers Migrating IOS-XE Devices to Cisco SD-WAN Zero Touch Provisioning Deploy AWS Gateway using the AWS Wizard Cisco SD-WAN Security Solution Security SDWAN IOS-XE Security SDWAN vEdge Security Firewall Ports Control Plane Security Data Plane Security Traffic Segmentation Service Chaining Cloud Security Enterprise Firewall Quality of Service Application Visibility and Recognition Differentiated Services-Quality of Service Critical Applications SLA Path MTU Discovery TCP Performance Optimization Bidirectional Forwarding Detection (BFD) vEdge Router Queuing Configuring vManage Using the vManage Interface Using the vManage Dashboard Administration Configuration SD-WAN Templates Templates Wide Area Application Server (WAAS) Maintenance Configure Cisco Umbrella Quality of Service (QoS) SD-WAN Policies Local Policies vs Central Policies Policies Smart policies (Control, Data, AppRoute, cflowd) SD-WAN Cloud OnRamp SAAS Cloud OnRamp IAAS vAnalytics Applications Network Availability Network Health vAnalytics Dashboard Monitoring vManage Network ACL Log Alarms Audit Log Events Geography View Device Information View Link Information Configure Geographic Coordinates for a Device Troubleshooting Tools for vManage Using vManage to Troubleshoot the environment Operational Commands Rediscover Network CLI Command to troubleshoot the environment. SSH Terminal Additional course details: Nexus Humans ICSDWAN-CT-Implementing, Configuring, Monitoring, and Troubleshooting Cisco (Viptela)SDWAN 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 ICSDWAN-CT-Implementing, Configuring, Monitoring, and Troubleshooting Cisco (Viptela)SDWAN 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.

ICSDWAN-CT-Implementing, Configuring, Monitoring, and Troubleshooting Cisco (Viptela)SDWAN
Delivered OnlineFlexible Dates
Price on Enquiry