1863 Environment courses in Radcliffe delivered Live Online

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.

Duration 3 Days 18 CPD hours This course is intended for Platform operators who are responsible for deploying and managing Tanzu Kubernetes clusters Overview By the end of the course, you should be able to meet the following objectives: Describe how Tanzu Kubernetes Grid fits in the VMware TanzuTM portfolio Describe the Tanzu Kubernetes Grid architecture Deploy and manage Tanzu Kubernetes Grid management clusters Deploy and manage Tanzu Kubernetes Grid workload clusters Deploy, configure, and manage Tanzu Kubernetes Grid packages Perform basic troubleshooting During this three-day course, you focus on installing VMware Tanzu© Kubernetes Grid? on a VMware vSphere© environment and then provisioning and managing Tanzu Kubernetes Grid clusters. The course covers how to install Tanzu Kubernetes Grid packages for image registry, authentication, logging, ingress, multi-pod network interfaces, service discovery, and monitoring. The concepts learned in this course are transferable for users who must install Tanzu Kubernetes Grid on other supported clouds. Course Introduction Introductions and course logistics Course objectives Introducing VMware Tanzu Kubernetes Grid Identify the VMware Tanzu products responsible for Kubernetes life cycle management and describe the main differences between them Explain the core concepts of Tanzu Kubernetes Grid, including bootstrap, Tanzu Kubernetes Grid management and workload clusters, and the role of Cluster API List the components of a Tanzu Kubernetes Grid instance Illustrate how to use the Tanzu CLI Identify the requirements for a bootstrap machine Define the Carvel Tool set Define Cluster API Identify the infrastructure providers List the Cluster API controllers Identify the Cluster API Custom Resource Definitions Management Clusters List the requirements for deploying a management cluster Differentiate between deploying on vSphere 6.7 Update 3 and vSphere 7 Describe the components of NSX Advanced Load Balancer Explain how Tanzu Kubernetes Grid integrates with NSX Advanced Load Balancer Explain how Kubernetes manages authentication Define Pinniped Define Dex Describe the Pinniped authentication workflow List the steps to install a Tanzu Kubernetes Grid management cluster Summarize the events of a management cluster creation Demonstrate how to use commands when working with management clusters Tanzu Kubernetes Clusters List the steps to build a custom image Describe the available customizations Identify the options for deploying Tanzu Kubernetes Grid clusters Explain how Tanzu Kubernetes Grid clusters are created Discuss which VMs make up a Tanzu Kubernetes Grid cluster List the pods that run on a Tanzu Kubernetes cluster Describe the Tanzu Kubernetes Grid core add-ons that are installed on a cluster Configuring and Managing Tanzu Kubernetes Grid Instances Define the Tanzu Kubernetes Grid packages Describe the Harbor Image Registry Define Fluent Bit Identify the logs that Fluent Bit collects Explain basic Fluent Bit configuration Describe the Contour ingress controller Demonstrate how to install Contour on a Tanzu Kubernetes Grid cluster Demonstrate how to install Service Discovery with ExternalDNS. Define Multus CNI Define Prometheus Define Grafana Troubleshooting Discuss the various Tanzu Kubernetes Grid logs Identify the location of Tanzu Kubernetes Grid logs Explain the purpose of crash diagnostics Demonstrate how to use SSH to connect to a Tanzu Kubernetes Grid VM Describe the steps for troubleshooting a failed cluster deployment Additional course details:Notes Delivery by TDSynex, Exit Certified and New Horizons an VMware Authorised Training Centre (VATC) Nexus Humans VMware Tanzu Kubernetes Grid: Install, Configure, Manage [V1.5] 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 Tanzu Kubernetes Grid: Install, Configure, Manage [V1.5] 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.

Corporate Process & Maintenance Course Overview: The "Corporate Process & Maintenance" course provides a comprehensive understanding of core administrative and operational processes within a corporate environment. It covers essential tasks such as managing priorities, maintaining office resources, and effectively communicating expectations. Learners will develop the skills necessary to initiate and complete tasks efficiently while managing administrative responsibilities. The course is designed to enhance organisational abilities and foster professional growth, making it valuable for anyone aiming to streamline corporate operations and improve workplace productivity. By the end of the course, learners will be equipped with the skills to manage office processes with confidence and precision. Course Description: This course delves into key aspects of corporate maintenance and process management, focusing on improving office operations. Key topics include prioritising and completing tasks, mastering communication and expectation management, and leveraging email software for strategic purposes. Learners will explore how to maintain office resources, provide administrative services like document production, and handle meeting necessities. Throughout the course, learners will gain valuable insights into effective office management, improving both individual and organisational performance. The course is structured to facilitate a deep understanding of corporate processes and ensure learners are prepared to handle various office-related responsibilities with efficiency and clarity. Corporate Process & Maintenance Curriculum: Module 01: Responsibility For Initiating And Completing Tasks Module 02: Managing Priorities And Time Module 03: Communicating And Managing The Expectations Module 04: Strategic Approach & Use Of Email Software Module 05: Maintenance Of Office Resources Module 06: Providing Administrative Services: Document Production Module 07: Meeting Necessaries & Documents (See full curriculum) Who is this course for? Individuals seeking to develop their office management skills Professionals aiming to enhance their organisational efficiency Beginners with an interest in corporate operations Those looking to improve administrative capabilities in the workplace Career Path Office Administrator Executive Assistant Administrative Coordinator Operations Manager Office Manager

Excel 2016 Formulas and Functions Course Overview: This course is designed to provide learners with a comprehensive understanding of Excel 2016 formulas and functions. By covering essential tools and techniques, the course enables learners to confidently navigate the Excel environment and utilise formulas for data analysis, calculations, and reporting. With a focus on both fundamental and advanced functions, learners will gain the skills needed to streamline their tasks and improve efficiency in the workplace. The course’s practical value lies in its application across various industries, allowing professionals to enhance their data handling and reporting capabilities, making it an invaluable addition to any skill set. Course Description: The "Excel 2016 Formulas and Functions" course covers the core concepts of using Excel formulas and functions to manage and analyse data. It starts with the basics, such as SUM, AVERAGE, and IF functions, before advancing to more complex tools like VLOOKUP and conditional formatting.Through each module, learners will explore how to use these features to automate calculations, create dynamic reports, and manipulate datasets. The course offers a structured approach to mastering Excel, with clear guidance on how to use each function effectively in a business context. Learners will come away with the knowledge to work more efficiently in Excel, enabling them to make informed data-driven decisions and enhance productivity. Excel 2016 Formulas and Functions Curriculum: Module 01: Getting Started with Microsoft Excel 2016 Module 02: Basic Formulas and Functions Module 03: Formulas and Functions Activities (See full curriculum) Who is this course for? Individuals seeking to improve their Excel skills Professionals aiming to enhance their data analysis capabilities Beginners with an interest in data management and analysis Any other individuals looking to gain proficiency in Excel Career Path: Data Analyst Administrative Assistant Financial Analyst Business Analyst Project Coordinator

Basic Business Communication Skills Course Overview This course on Basic Business Communication Skills is designed to equip learners with essential communication techniques for effective interaction in the business world. Covering key areas such as written communication, verbal communication, and non-verbal cues, it ensures that learners understand the importance of clarity, tone, and professionalism in business settings. By the end of the course, participants will be able to communicate more confidently and effectively with colleagues, clients, and stakeholders, enhancing their overall career prospects. Course Description The Basic Business Communication Skills course delves deeper into the foundations of business communication, focusing on email etiquette, telephone communication, meetings, and presentations. Learners will explore various communication channels and how to adapt their style for different audiences, whether in a formal or informal setting. By engaging with practical examples and scenarios, learners will develop the ability to express ideas clearly and professionally, strengthen relationships, and improve team dynamics. This course is invaluable for anyone looking to improve their ability to communicate effectively in a professional environment. Basic Business Communication Skills Curriculum: Module 01: Introduction to Business Communication Module 02: Effective Written Communication Module 03: Telephone and Digital Communication Etiquette Module 04: Non-Verbal Communication and Body Language Module 05: Communicating in Meetings and Presentations Module 06: Communicating Across Cultures Module 07: Conflict Resolution and Difficult Conversations (See full curriculum) Who is this course for? Individuals seeking to enhance their communication skills in the workplace. Professionals aiming to improve their career prospects through stronger communication. Beginners with an interest in business communication. Those looking to refine their interpersonal communication abilities. Career Path Office Administrator Customer Service Representative HR Assistant Project Coordinator Marketing Specialist Sales Executive

HR Management Course Overview: This HR Management Course is designed to equip learners with essential knowledge and skills required to effectively manage human resources within any organisation. Covering key aspects of HR management, including recruitment, performance management, employee relations, and legal considerations, the course offers a comprehensive understanding of the core responsibilities of HR professionals. Learners will gain the confidence to tackle HR challenges in the workplace, improve organisational culture, and ensure compliance with employment laws. By the end of the course, participants will be well-prepared to contribute to HR strategy and operational efficiency in various sectors. Course Description: This course delves deeper into HR functions, offering insights into crucial topics such as employee engagement, talent acquisition, workforce development, and conflict resolution. Learners will explore modern HR practices, the role of HR in organisational development, and the application of HR policies within different industries. The course provides a solid foundation in understanding HR operations, helping learners develop the skills needed to manage employee lifecycle processes effectively. Emphasis is placed on understanding legal frameworks, diversity and inclusion, and managing change within the workforce, preparing learners for dynamic HR roles in any business environment. HR Management Course Curriculum: Module 01: Introduction to HR Management Module 02: Recruitment and Selection Strategies Module 03: Employee Engagement and Retention Module 04: Performance Management and Development Module 05: Employment Law and Ethical Considerations Module 06: Compensation and Benefits Management Module 07: Workforce Diversity and Inclusion Module 08: Managing Change in the Workforce (See full curriculum) Who is this course for? Individuals seeking to build a career in HR management. Professionals aiming to enhance their HR skills for career progression. Beginners with an interest in human resources and organisational development. HR specialists looking to update their knowledge and practices. Career Path: HR Manager Recruitment Specialist Employee Relations Manager Talent Acquisition Specialist HR Consultant Learning and Development Coordinator

Learn to Make a Fresh Start in Your Life Course Overview "Learn to Make a Fresh Start in Your Life" is an empowering course designed to guide individuals in making significant life changes. Through structured modules, learners will explore a variety of strategies and techniques that can help transform their mindset, improve decision-making, and embrace new opportunities. This course offers clear, actionable advice and valuable tools to aid in navigating transitions, whether personal or professional. By the end, learners will have the confidence to initiate positive changes and take charge of their futures, with a deeper understanding of self-improvement and growth. Course Description This course takes an in-depth approach to the process of starting anew, covering key topics such as goal setting, overcoming obstacles, building resilience, and managing change. Learners will explore methods for clarifying their values, identifying priorities, and creating a step-by-step plan for success. Emphasis is placed on the importance of mental and emotional well-being when making life transitions. The course fosters a reflective learning environment, encouraging learners to apply concepts to their personal situations, ultimately equipping them with skills to make informed decisions and embrace new possibilities with confidence. Learn to Make a Fresh Start in Your Life Curriculum Module 01: Starting Fresh Module 02: Understanding Your Values and Goals Module 03: Building Resilience for Change Module 04: Overcoming Mental Barriers Module 05: Creating and Implementing a Personal Plan Module 06: Navigating Obstacles and Staying Motivated Module 07: Embracing New Opportunities (See full curriculum) Who is this course for? Individuals seeking to make positive life changes. Professionals aiming to pivot or grow in their careers. Beginners with an interest in self-improvement. Anyone looking to enhance their personal development. Career Path Life Coach Personal Development Consultant HR or Organisational Development Specialist Career Coach Motivational Speaker Wellness and Mental Health Practitioner

Listening Course - The Power of Listening Course Overview The "Listening Course - The Power of Listening" equips learners with essential listening skills, enabling them to effectively engage in conversations and enhance communication. By exploring various listening techniques and understanding the difference between active and passive listening, this course helps individuals sharpen their ability to listen attentively. It will empower learners to build stronger relationships, improve professional communication, and foster a more understanding environment. Upon completion, participants will have developed advanced listening abilities that will enhance both personal and professional interactions. Course Description In this comprehensive course, learners will delve into the different types of listening and explore the distinct approaches of active versus passive listening. Through examining key listening techniques, they will discover ways to improve their skills and recognise the difference between simply hearing and truly listening. Learners will also gain an understanding of the benefits of strong listening skills, such as enhanced decision-making and improved relationships. This course will provide learners with valuable insights into refining their communication, both in everyday conversations and in professional settings, making them more effective listeners. Listening Course - The Power of Listening Curriculum Module 01: Introduction Module 02: Lead Generation with Attraction Marketing for Business Module 03: Types of Listening Module 04: Difference Between Active and Passive Listening Module 05: Difference Between Listening and Hearing Module 06: Ways to Improve Your Listening Skills Module 07: What are Good Listening Skills Module 08: Benefits of Good Listening Skills Module 09: Conclusion (See full curriculum) Who is this course for? Individuals seeking to improve their communication skills. Professionals aiming to enhance their leadership and interpersonal abilities. Beginners with an interest in developing effective listening techniques. Anyone wanting to build stronger relationships through better communication. Career Path Customer Service Representative HR Professional Communications Specialist Sales and Marketing Expert Leadership and Management Roles Mediation and Conflict Resolution Specialist

This program is tailored for Seniors (over the age of 65) who already speak Greek and would like to be given the chance to speak Greek MORE, to connect with people of similar background and interests and to expand their social network from the comfort of their home! Within a welcoming, lively, relaxed and fun atmosphere, we are focusing on discussion and activities about Greek music, cinema, history, society, nature, everyday life, travel, food and lots more!

Duration 5 Days 30 CPD hours This course is intended for If you are getting ready for a career as an entry-level information technology (IT) professional or personal computer (PC) service technician, the CompTIA© A+© Certification course is the first step in your preparation. Overview In this course, you will install, configure, optimize, troubleshoot, repair, upgrade, and perform preventive maintenance on personal computers, digital devices, and operating systems. You will:Identify the hardware components of personal computers and mobile digital devices.Identify the basic components and functions of operating systems.Identify networking and security fundamentals.Identify the operational procedures that should be followed by professional PC technicians.Install, configure, and troubleshoot display devices.Install and configure peripheral components.Manage system components.Manage data storage.Install and configure Microsoft Windows.Optimize and maintain Microsoft Windows.Work with other operating systems.Identify the hardware and software requirements for client environment configurations.Identify network technologies.Install and configure networking capabilities.Support mobile digital devices.Support printers and multifunction devices.Identify security threats, vulnerabilities, and controls.Implement security controls.Troubleshoot system-wide issues. In this course, you will acquire the essential skills and information you will need to install, upgrade, repair, configure, troubleshoot, optimize, and perform preventative maintenance of basic personal computer hardware and operating systems. Hardware Fundamentals Topic A: Personal Computer Components Topic B: Storage Devices Topic C: Mobile Digital Devices Topic D: Connection Interfaces Operating System Fundamentals Topic A: PC and Mobile Operating Systems Topic B: PC Operating System Tools and Utilities Networking & Security Fundamentals Topic A: Network Types Topic B: Network Components Topic C: Common Network Services Topic D: Cloud Concepts Topic E: Security Fundamentals Safety & Operational Procedures Topic A: Basic Maintenance Tools and Techniques Topic B: Personal and Electrical Safety Topic C: Environmental Safety and Materials Handling Topic D: Professionalism and Communication Topic E: Organizational Policies and Procedures Topic F: Troubleshooting Theory Supporting Display Devices Topic A: Install Display Devices Topic B: Configure Display Devices Topic C: Troubleshoot Video and Display Devices Installing & Configuring Peripheral Components Topic A: Install and Configure Input Devices Topic B: Install and Configure Output Devices Topic C: Install and Configure Input/Output Devices Topic D: Install and Configure Expansion Cards Managing System Components Topic A: Identify Motherboard Components and Features Topic B: Install and Configure CPUs and Cooling Systems Topic C: Install Power Supplies Topic D: Troubleshoot System Components Managing Data Storage Topic A: Identify RAM Types and Features Topic B: Troubleshoot RAM Issues Topic C: Install and Configure Storage Devices Topic D: Configure the System Firmware Topic E: Troubleshoot Hard Drives and RAID Arrays Installing & Configuring Microsoft Windows Topic A: Implement Client-Side Virtualization Topic B: Install Microsoft Windows Topic C: Use Microsoft Windows Topic D: Configure Microsoft Windows Topic E: Upgrade Microsoft Windows Optimizing & Maintaining Microsoft Windows Topic A: Optimize Microsoft Windows Topic B: Back Up and Restore System Data Topic C: Perform Disk Maintenance Topic D: Update Software Working with Other Operating Systems Topic A: The OS X Operating System Topic B: The Linux Operating System Customized Client Enviroments Topic A: Types of Common Business Clients Topic B: Custom Client Environments Networking Technologies Topic A: TCP/IP Properties and Characteristics Topic B: TCP/IP Topic C: Internet Connections Topic D: Ports and Protocols Topic E: Networking Tools Installing & Configuring Networking Capabilities Topic A: Configure Basic Windows Networking Topic B: Configure Network Perimeters Topic C: Using Windows Networking Features Topic D: Install and Configure SOHO Networks Supporting Mobile Digital Devices Topic A: Install and Configure Exterior Laptop Components Topic B: Install and Configure Interior Laptop Components Topic C: Other Mobile Devices Topic D: Mobile Device Accessories and Ports Topic E: Mobile Device Connectivity Topic F: Mobile Device Synchronization Topic G: Troubleshoot Mobile Device Hardware Supporting Printers & Multifunction Devices Topic A: Printer and Multifunction Technologies Topic B: Install and Configure Printers Topic C: Maintain Printers Topic D: Troubleshoot Printers Security Threats, Vulnerabilities, and Controls Topic A: Common Security Threats and Vulnerabilities Topic B: General Security Controls Topic C: Mobile Security Controls Topic D: Data Destruction and Disposal Methods Implementing Security Controls Topic A: Secure Operating Systems Topic B: Secure Workstations Topic C: Secure SOHO Networks Topic D: Secure Mobile Devices Troubleshooting System-Wide Issues Topic A: Troubleshoot PC Operating Systems Topic B: Troubleshoot Mobile Device Operating Systems and Applications Topic C: Troubleshoot Wired and Wireless Networks Topic D: Troubleshoot Common Security Issues