2844 Learning courses in Sheffield delivered Live Online

Duration 2 Days 12 CPD hours This course is intended for Data Modelers Participants will learn the full scope of the metadata modeling process, from initial project creation, to publishing a dynamic cube, and enabling end users to easily author reports and analyze data. Introduction to IBM Cognos Dynamic Cubes Define and differentiate Dynamic Cubes Dynamic Cubes characteristics Examine Dynamic Cube requirements Examine Dynamic Cube components Examine high level architecture IBM Cognos Dynamic Query Review Dimensional Data Structures Dynamic Cubes caching Create & Design a Dynamic Cube Explore the IBM Cognos Cube Designer Review the cube development process Examine the Automatic Cube Generation Manual development overview Create dimensions Model the cube Best practice for effective modeling Deploy & Configure a Dynamic Cube Deploy a cube Explore the Estimate Hardware Requirements Identify cube management tasks Examine Query Service administration Explore Dynamic Cube properties Schedule cube actions Use the DCAdmin comment line tool Advanced Dynamic Cube Modelling Examine advanced modeling concepts Explore modeling caveats Calculated measures and members Model Relative Time Explore the Current Period property Define period aggregation rules for measures Advanced Features of Cube Designer Examine multilingual support Examine ragged hierarchies and padding members Define Parent-Child Dimensions Refresh Metadata Import Framework Manager packages Filter measures and dimensions Optimize Performance with Aggregates Identify aggregates and aggregate tables In-memory aggregates Use Aggregate Advisor to identify aggregates User defined in-memory aggregates Optimize In-Memory Aggregates automatically Aggregate Advisor recommendations Monitor Dynamic Cube performance Model aggregates (automatically vs manually) Use Slicers to define aggregation partitions Define Security Overview of Dynamic Cube security Identify security filters The Security process - Three steps Examine security scope Identify scope rules Identify roles Capabilities and access permissions Cube security deep dive Model a Virtual Cube Explore virtual cubes Create the virtual cube Explore virtual cube objects Examine virtual measures and calculated members Currency conversion using virtual cubes Security on virtual cubes Introduction to IBM Cognos Analytics Define IBM Cognos Analytics Redefined Business Intelligence Self-service Navigate to content in IBM Cognos Analytics Interact with the user interface Model data with IBM Cognos Analytics IBM Cognos Analytics components Create reports Perform self-service with analysis and Dashboards IBM Cognos Analytics architecture (high level) IBM Cognos Analytics security Package / data source relationship Create Data modules Upload files Additional course details: Nexus Humans B6063 IBM Cognos Cube Designer - Design Dynamic Cubes (v11.0) 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 B6063 IBM Cognos Cube Designer - Design Dynamic Cubes (v11.0) 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 Overview In this course you?ll learn how to: Containerize and deploy a new Python script Configure the deployment with ConfigMaps, Secrets and SecurityContexts Understand multi-container pod design Configure probes for pod health Update and roll back an application Implement services and NetworkPolicies Use PersistentVolumeClaims for state persistence And more In this vendor agnostic course, you will use Python to build, monitor and troubleshoot scalable applications in Kubernetes. Introduction Objectives Who You Are The Linux Foundation Linux Foundation Training Preparing Your System Course Registration Labs Kubernetes Architecture What Is Kubernetes? Components of Kubernetes Challenges The Borg Heritage Kubernetes Architecture Terminology Master Node Minion (Worker) Nodes Pods Services Controllers Single IP per Pod Networking Setup CNI Network Configuration File Pod-to-Pod Communication Cloud Native Computing Foundation Resource Recommendations Labs Build Container Options Containerizing an Application Hosting a Local Repository Creating a Deployment Running Commands in a Container Multi-Container Pod readinessProbe livenessProbe Testing Labs Design Traditional Applications: Considerations Decoupled Resources Transience Flexible Framework Managing Resource Usage Multi-Container Pods Sidecar Container Adapter Container Ambassador Points to Ponder Labs Deployment Configuration Volumes Overview Introducing Volumes Volume Spec Volume Types Shared Volume Example Persistent Volumes and Claims Persistent Volume Persistent Volume Claim Dynamic Provisioning Secrets Using Secrets via Environment Variables Mounting Secrets as Volumes Portable Data with ConfigMaps Using ConfigMaps Deployment Configuration Status Scaling and Rolling Updates Deployment Rollbacks Jobs Labs Security Security Overview Accessing the API Authentication Authorization ABAC RBAC RBAC Process Overview Admission Controller Security Contexts Pod Security Policies Network Security Policies Network Security Policy Example Default Policy Example Labs Exposing Applications Service Types Services Diagram Service Update Pattern Accessing an Application with a Service Service without a Selector ClusterIP NodePort LoadBalancer ExternalName Ingress Resource Ingress Controller Labs Troubleshooting Troubleshotting Overview Basic Troubleshooting Steps Ongoing (Constant) Change Basic Troubleshooting Flow: Pods Basic Troubleshooting Flow: Node and Security Basic Troubleshooting Flow: Agents Monitoring Logging Tools Monitoring Applications System and Agent Logs Conformance Testing More Resource Labs Additional course details: Nexus Humans Kubernetes for App Developers 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 Kubernetes for App Developers 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.

Workplace Innovation Are You A Leader Who Wants To Enhance Your Team’s Accountability, Adaptability, Resilience, And Well-Being? Consider joining our newly launched Growth Leadership Programme: Workplace Innovation, subsided by Scottish Enterprise, which offers a unique approach to leadership development and workplace Innovation, emphasising Motivational Intelligence (MQ). Our programme will help you build on your leadership capabilities and confidence while creating a more innovative, productive, and fair workplace for employee development and growth. Growth Leadership: Workplace Innovation Leading with Motivational Intelligence (MQ) You’ll learn to: Develop MQ leadership skills that encourage fair and innovative workplace practices and inclusive economic growth. Increase engagement, innovation, and productivity among your team. Enhance your strategic decision-making skills. Build a resilient, agile, and change-driven team culture. Identify and integrate organisational values into your workplace culture. Create a successful business that is also a fair place to work. Session Overview Our comprehensive programme, consisting of eight engaging and insightful sessions, is meticulously crafted to provide a world-class education in Leadership, Workplace Innovation and Motivational Intelligence (MQ). We combine some of the most potent, powerful and cutting-edge research in workplace innovation, neuroscience and the most promising discoveries in cognitive and social psychology of the 20th century. 01 Self-Leadership and The Secret to Personal Success Session 1: Self-Leadership and The Secret to Personal Success This comprehensive kick-off session delves into the foundations of self-leadership and personal success. Participants will explore various aspects, from setting course expectations and creating a conducive learning environment to understanding motivational intelligence and managing negative thoughts. Through essential resources like the Leadership Reference Manual and Roadmap Workbook, multi-sensory perception, and spaced repetition learning techniques, participants will solidify their learnings and enhance personal and professional growth. Key Learning Outcomes: Understand the critical role of self-leadership in personal and professional success and the impact of external and internal factors on performance Develop strategies to optimise motivation, communication, and effectiveness within teams and organisations, leveraging diverse learning styles and adult learning techniques Utilise essential resources like the Leadership Reference Manual and Roadmap Workbook for ongoing growth and development while implementing practical tools like the Start, Stop, Continue plan for self-reflection and improvement Explore the power of adaptability, self-awareness, and resilience in navigating through challenging times and maintaining a positive mindset Discover the importance of a positive mental diet, gratitude, and consistent small decisions that compound over time, leading to personal and professional growth 02 The Role of Intelligence in Leadership and Management Session 2: The Role of Intelligence in Leadership and Management It's time to delve into Motivational Intelligence and its role in our personal and professional lives. In this comprehensive and interactive session, participants will explore the multifaceted aspects of intelligence in Leadership and management, focusing on IQ, EQ, and MQ. Participants will learn how to cultivate a growth mindset and motivational intelligence within themselves and their teams, fostering a culture of learning and resilience. The session will also cover the importance of crafting a clear vision for the team or organisation and provide practical strategies for effectively communicating the vision to internal and external stakeholders. Key Learning Outcomes: Understand the roles of IQ, EQ, and MQ in Leadership and management and their impact on individual and team performance Develop strategies to improve your levels of intelligence and foster a growth mindset within individuals and teams Discover the importance of vision in Leadership and management and learn to craft it using the WHERE (performance), HOW (perception), and WHY (purpose) perspectives Gain insights into effectively communicating the vision to stakeholders, ensuring alignment, ownership, and motivation Reflect on the role of a growth mindset and motivational intelligence in achieving the team's vision and fostering a culture of continuous improvement and adaptability 03 The Pillars of Human Performance: Unlocking Potential Session 3: The Pillars of Human Performance: Unlocking Unlimited Potential Discover the keys to unlocking your unlimited potential and becoming a more effective leader in this interactive course. Through engaging discussions and self-reflection, participants will dive deep into unlimited potential, understand its significance in Leadership, and learn to overcome challenges in their teams or businesses. Participants will gain insights into the characteristics of influential leaders, the importance of asking the right questions, and the value of embracing failure as a part of success. With a focus on personal and professional growth, this session will equip you with the tools and techniques to become a better manager and leader. Key Learning Outcomes: Understand the concept of unlimited potential and its importance in Leadership and personal growth Identify personal and team visions, challenges, and the role of asking the right questions in gaining insights Recognise the role of practice and reflection in transforming weaknesses into strengths Explore the characteristics and impact of great leaders and learn how to apply these traits in your leadership style Embrace the importance of failure as a crucial part of success and create a supportive environment for personal and team development 04 Defining Management and Vertical Alignment Session 4: Defining Management and Vertical Alignment In this engaging session, participants will delve into the essential differences between management and Leadership and discover how understanding these distinctions can significantly impact team culture and performance. We'll examine common management mistakes and their effects, uncover the best practices of excellent management, and discuss the development of management skills and the management hierarchy. This interactive session will provide valuable insights and actionable strategies that can be applied to personal and professional life, helping participants become more effective and successful managers and leaders. Key Learning Outcomes: Differentiating between management and Leadership: Gain a deeper understanding of how these concepts differ and their impact on team culture and performance Identifying common management mistakes: Learn about these pitfalls and their consequences on team culture and performance and develop strategies to avoid them Mastering the best practices of excellent management: Discover the five essential techniques to help you become a more effective manager Developing management skills and understanding the management hierarchy: Enhance your ability to grow as a leader and manager Embracing Ultimate Responsibility: Learn the importance of taking ownership and responsibility for your and your team's success and understand the role of motivational intelligence in achieving this 05 Workplace Innovation and High-Payoff Activities Session 5: Workplace Innovation and High-Payoff Activities n (Job Crafting) This session provides a comprehensive overview of the critical principles of workplace innovation, job crafting, people leadership, and coaching in the workplace. Participants will learn about job crafting, our MQ workplace innovation process, and the crucial role of Leadership in managing and monitoring performance in the workplace. By adopting a proactive and creative approach to their work, individuals can improve their job satisfaction, contribute to their organisation's success, and drive economic health for the nation. Key Learning Outcomes: Understanding of Leadership in the job crafting innovative process Skills in job crafting and workplace innovation Knowledge of the critical role of Leadership in performance management Techniques for effective coaching and positive feedback, through trust and mutual respect in the workplace Helping individuals reflect on their role in the success of the team and company and developing a written plan to achieve their goals 06 Defining and Exploring Leadership Session 6: Defining and Exploring Leadership In this session, we will define and explore the essence of Leadership, dispelling the myths and providing a definition that will guide you through the course. We will also explore the three-tier hierarchy of success and how leaders can influence MQ (motivational intelligence) by doing five things consistently. As a manager or leader, you may have found that your team's success is not guaranteed even with the best plans, processes, and strategies. This is because not all team members will adopt new ideas or changes unless they first believe they can achieve the desired outcome. Key Learning Outcomes: Understanding the essence of Leadership to provide an in-depth understanding of the essence of successful Leadership, dispelling the myths and providing a definition that will guide you through the course Psychology of your team: Leaders understand that to achieve their goals, they need to focus on the psychology of their team Power of questions in Leadership: Leaders can gain insight into the minds of their team members and unlock the key to motivating and developing them by asking the right questions Explore the three-tier hierarchy of success and the importance of each level in determining a person's likelihood of success Five things great leaders do each day to influence a culture of responsibility, consistently build esteem and confidence, and always work on coaching and mentoring employees 07 Building a Leadership Toolbox Session 7: Building a Leadership Toolbox: Trust & Inspiration Fostering Adaptability, Responsibility, Resilience, and Courage, this step focuses on leaders' tools and techniques to promote greater team accountability and ownership. It starts to delve into the critical role of self-esteem in a person's motivational intelligence and adaptability. We also explore how self-esteem is formed and influences a person's interpretation of feedback. We also look at self-esteem's critical role in a person's motivational intelligence and adaptability, examining how self-esteem is formed and influences a person's interpretation of feedback. Key Learning Outcomes: Understanding the tools and techniques leaders can use to foster greater team accountability and ownership Delving into the critical role of self-esteem in a person's motivational intelligence and adaptability Exploring how self-esteem is formed and influences a person's interpretation of feedback Examining the levels of self-esteem and associated behaviours of each group Understanding the influence of comfort zones and tools leaders can use to help people overcome the fear of change 08 Developing a Healthy Perspective and Resilient Attitude Session 8: Developing a Healthy Perspective and Resilient Attitude This step explores how developing a healthy perspective and resilient attitude is crucial for success as a leader. In this session, we will explore the critical role of self-reflection in building motivation and adaptability. We will examine how self-esteem is formed and how it influences a person's interpretation of feedback. We will also delve into the levels of self-esteem and the associated behaviours of each class. We will provide practical strategies for cultivating resilience and adaptability in facing challenges and setbacks. Through reflection and analysis of your moments of surprise, frustration, and failure, you will develop a growth mindset that fosters continuous learning and improvement. Key Learning Outcomes: The critical role of self-reflection in building motivation and adaptability How self-esteem is formed and influences a person's interpretation of feedback The levels of self-esteem and the associated behaviours of each class Strategies for cultivating resilience and adaptability in the face of challenges and setbacks The influence of affirmations and tools leaders can use to help people overcome the fear of change

Duration 3 Days 18 CPD hours This course is intended for The ideal audience for this course includes database enthusiasts, IT professionals, and developers who are eager to expand their knowledge and skill set in database management and optimization. Roles that would greatly benefit from attending this course include: Database Developers: Those who design, implement, and maintain databases as part of their primary responsibilities and want to improve their expertise in schema design, query optimization, and advanced database features. Backend Developers: Professionals who work on server-side application logic and require a strong understanding of database management to integrate data storage and retrieval processes into their applications. Overview Upon completing this course, database developers will be able to: Design and implement efficient database schemas by employing normalization techniques, appropriate indexing strategies, and partitioning methods to optimize data storage and retrieval processes. Develop advanced SQL queries, including joining multiple tables, utilizing subqueries, and aggregating data, to extract valuable insights and facilitate decision-making processes. Implement stored procedures, functions, and triggers to automate common database tasks, enforce data integrity, and improve overall application performance. Apply database performance tuning techniques, such as query optimization, index management, and transaction control, to ensure optimal resource usage and enhanced system responsiveness. Integrate databases with various programming languages and platforms, enabling seamless data access and manipulation for web, mobile, and desktop applications. PostgreSQL is a powerful, open-source object-relational database management system that emphasizes extensibility, data integrity, and high performance. Its versatility and robust feature set make it an ideal choice for developers working on projects of all sizes, from small-scale applications to enterprise-level systems. By learning PostgreSQL, developers can tap into its advanced capabilities, such as full-text search, spatial data support, and customizable data types, allowing them to create efficient and scalable solutions tailored to their unique needs. PostgreSQL for Database Developers is a three-day hands-on course that explores the fundamentals of database management, covering everything from installation and management to advanced SQL functions. Designed for beginners and enthusiasts alike, this course will equip you with the knowledge and skills required to effectively harness the power of PostgreSQL in today's data-driven landscape. Throughout the course you?ll be immersed in a variety of essential topics, such as understanding data types, creating and managing indexes, working with array values, and optimizing queries for improved performance. You?ll gain valuable hands-on experience with real-world exercises, including the use of the psql client, writing triggers and stored procedures with PL/pgSQL, and exploring advanced SQL functions like Common Table Expressions (CTE), Window Functions, and Recursive Queries. You?ll exit this course with a solid foundation in PostgreSQL, enabling you to confidently navigate and manage your databases with ease and efficiency. Installing & Managing PostgreSQL PostgreSQL installation process Optimal configuration settings User and role management Database backup and restoration Overview of PostgreSQL Database PostgreSQL architecture overview Understanding database objects Efficient data storage Transaction management basics Using the psql client Introduction to psql Essential psql commands Executing queries effectively Managing databases with psql Understanding PostgreSQL data types Numeric data types explored Character and binary types Date, time, and boolean values Array and other types Understanding sequences Sequence creation and usage Customizing sequence behavior Implementing auto-increment columns Sequence manipulation and control Creating & managing indexes PostgreSQL index fundamentals Designing partial indexes Utilizing expression-based indexes Index management techniques Using COPY to load data COPY command overview Importing and exporting data Handling CSV and binary formats Performance considerations Working with Array Values Array value basics Array manipulation functions Querying arrays efficiently Multidimensional array handling Advanced SQL Functions Mastering Common Table Expressions Utilizing Window Functions Regular Expressions in SQL Crafting Recursive Queries Writing triggers & stored procedures with PL/pgSQL PL/pgSQL variables usage Implementing loop operations PERFORM and EXECUTE statements Developing PostgreSQL triggers Using the PostgreSQL query optimizer Query analysis and optimization EXPLAIN command insights PostgreSQL query operators Identifying performance bottlenecks Improving query performance Query performance tuning Index optimization strategies Efficient database partitioning Connection and resource management Wrap Up & Additional Resources Further learning opportunities Staying up-to-date with PostgreSQL Community engagement and support Additional course details: Nexus Humans PostgreSQL for Database Developers (TTDB7024) 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 PostgreSQL for Database Developers (TTDB7024) 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.

An accredited qualification to prepare supervisors and team leaders for a future management role. This programme gives Team Leaders & Managers the skills, disciplines and confidence to manage their team effectively and add a great deal more value to the organisation - where they have to apply their learning in order to achieve the highly coveted ILM qualification. In order for a business to obtain maximum results, it is important that employees are motivated and supported in their job roles. It is the responsibility of the team leader or supervisor to lead their team effectively and present feedback to management. This 3-day programme will guarantee to boost your performance as a team leader and help you make the transition from working in a team to leading a team. We use a combination of theory and practical to help you develop yourself, and a toolkit of resources to use in the workplace. This is an internationally accredited course which not only carries kudos but it ensures you apply the learning back into the workplace for an immediate impact. All of our ILM Programmes are provided in partnership with BCF Group Limited, which is the ILM Approved Centre we deliver under. Course Syllabus The syllabus of the ILM Level 2 Award in Leadership and Team Skills course is split into three main modules, covering the following: Module One Developing Yourself as a Team Leader Learning the various roles, functions and responsibilities of a team leader - depending on workplace Recognising limits of authority and accountability, and how these are defined Developing personal skills and abilities for effective team leading Using reflective learning skills to improve performance Identifying areas of strength and possible improvement Finding ways of obtaining feedback from others Receiving and responding positively to feedback Module Two Workplace Communications Learning stages in the communication process Consideration of the recipient's needs Spotting barriers to communication and how to overcome them Establishing a range of direct communication methods relevant to the team Collating a range of direct communication methods relevant to people outside own area of responsibility. This includes written, telephone, e-mail and face-to-face Recognising the aspects of face-to-face communication, including appearance, impact, body language Realising the importance of succinct and accurate records of one-to-one oral communication Reasons for maintaining records of one-to-one communication (e.g. potential disciplinary or legal issues) Module Three Managing Yourself Setting SMART objectives and using them to prioritise own actions Learning simple time management techniques Developing an awareness of own skills and abilities Giving yourself personal objectives in relation to team objectives Developing flexibility and responding to daily changing circumstances Diagnosing the causes and impacts of stress at work Identifying symptoms of stress in yourself Knowing the implications of stress for workplace and non-work activities/relationships Developing simple stress management techniques Available sources of support Action planning and review techniques Accreditation As with all ILM accredited programmes, participants will need to complete the post-programme activity in order to achieve their full ILM Level 2 Award in Team Leading. This element is designed to show to ILM that you are able to apply what you have learned in the workplace. Who Is It For? This programme is ideal for practising or aspiring team leaders, in any industry sector, who is looking to gain a solid foundation or develop their existing skills as a team leader. This internationally recognised course will give you a solid understanding of what is needed to be a successful team leader, how to delegate, motivate and how to implement these skills in to your work place. What Will I Learn? At the end of the course, successful candidates will: Have a good understanding of the team leader role Apply a range of effective communication skills to overcome barriers Know how to motivate, build confidence and gain the best from their teams Identify, build and encourage effective team behaviours Apply practical skills and knowledge to be transferred to the workplace Gain an internationally recognised qualification What Is Required? There are no formal entry requirements, but participants will normally be either practising or aspiring team leaders, with the opportunity to meet the assessment demands and have a background that will enable them to benefit from the programme. Scheduled Courses Unfortunately this course is not one that is currently scheduled as an open course, and is only available on an in-house basis. For more information about running this course in-house at your premises, please contact us for more information.

Duration 3 Days 18 CPD hours This course is intended for This course is appropriate for anyone needing to interface with an Oracle database or those needing a general understanding of Oracle database functionality. That would include end users, business analysts, application developers and database administrators. Overview Working in a hands-on learning environment led by our expert pracitioner you'll learn how to: Add Data, Retrieve, Sort and Organize a SQL Database Combine Data, Set Operators and Subqueries Manipulate Data and Data Definition Languages in SQL Work with Data Dictionary Views and Create Sequences, Indexes and Views Use Database Objects and Subqueries Perform Data and access control Perform other Advanced Level Database operations. Oracle 19C SQL Programming Fundamentals Is a three-day, hands-on course designed to equip you with the fundamental skills needed to set up, run and manage SQL databases using Oracle Database Technology. You will also be discovering all the tools and concepts required to organize data efficiently. Our engaging instructors and mentors are highly-experienced practitioners who bring years of current 'on-the-job' experience into every classroom. Working within in a hands-on learning environment, guided by our expert team, attendees will develop a practical approach to Oracle Database Technology. Throughout the course, you will learn the key elements of a database, and the way Oracle systems facilitate their induction in the system. You?ll also learn the tools and strategies you can implement to store, retrieve, compare and organize data according to your requirements. You?ll also explore the process of creating simple to complex reports from existing data. By the end of this course, you will also have hands-on knowledge of SQL systems that are required to proceed to other advanced to professional programs. Adding Data, Retrieving, Sorting and Organizing a SQL Database The building blocks of a database. How to add data to the database. The process of retrieving data using SQL functions. Multiple methods of sorting and organizing data. Using SQL functions to get the required simple to complex output. Various strategies for using functions and conditions to organize data. Combining Data, Set Operators And Subqueries Consolidating data using multiple functions and group operators. Fetching intelligent data reports using simple functions. Fetching data from multiple sources in the tables. Using Subqueries to compile data as required. Using Set operators to create smart data reports. Data Manipulation and Data Definition Languages in SQL Describing and managing data transaction using Data Definition Language. Categorize and review data tables using Data Definition Language. Data Dictionary Views and Creating Sequences, Indexes and Views How to manage and query Data Dictionary Views. The process of creating and using Sequences. How to create various types of Synonyms and Indexes. Creating simple and complex views and retrieving data. Understanding and using Database Objects and Subqueries Core concept and application of Schema Objects. Fetching required data with Subqueries. Using Subqueries to organize Data in SQL. Data and access control Assigning and revoking data access. Managing data access control according to user levels. Performing Advanced Level Database operations. Using advanced functions and performing data queries. Creating and managing time zone-based databases.

Duration 2 Days 12 CPD hours This course is intended for Built for IT Professionals working with Citrix Content Collaboration, with little or no previous Content Collaboration experience. Potential students include networking administrators, engineers, and architects interested in learning how to deploy or manage Citrix Content Collaboration. Overview Understand Enterprise File Synchronization, Sharing, and Citrix Content Collaboration architecture How to navigate the Citrix Content Collaboration administration interface and build StorageZones How to manage Citrix Content Collaboration users in an Active Directory environment Different StorageZone deployment considerations and scenarios In this course, you?ll learn about how to use Citrix Content Collaboration to share, sync, and secure content for your organization. You?ll understand the Content Collaboration architecture, StorageZone configurations and deployment options available, how to manage and administer your Content Collaboration environment, Citrix Files applications, and how single sign-on, and how to use the User Management Tool for Content Collaboration Content Collaboration Architecture Overview Introduction to Enterprise File Sync and Sharing (EFSS) including its use cases, legal, and data security considerations Review Content Collaboration architecture, components and storage features Management and Administration Getting Started in Content Collaboration How to configure and manage users, folders, permissions and administrative settings Additional cloud-based features and integrations Storage Zone Deployments and Configuration Overview of Storage Zones architecture and deployment options for customer-managed storage including proof-ofconcept, high-availability, and multi-site deployments Review system, networking, and hosting requirements including steps for server preparation, installation and configuration Manage, monitor, and upgrade Storage Zone deployments for optimal performance Single Sign-on and User Management Overview of SAML 2.0 protocol and single-sign on use cases,security and benefits Single Sign-on settings for Content Collaboration and supported identity provider configurations User provisioning with User Management Tool (UMT) and task scheduling for automated updates synchronization with Active Directory Citrix Files Applications Citrix Files application system requirements, configuration and settings Compare features and functionalities for various use case applications and workflows Lifecycle product version considerations Additional course details: Nexus Humans CSF-202: Citrix Content Collaboration Enterprise 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 CSF-202: Citrix Content Collaboration Enterprise 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.

The Sales Accelerator programme is a fresh approach to improving business development productivity. It focuses on identifying and using a series of business productivity metrics in order to build a clear action plan for improving sales results - typically within 90 days. The metrics are grouped under three headings: The basic principle is that a small improvement in each area can lead to a significant increase in sales results and productivity. And the object of the programme is to show how best to achieve that. The programme therefore looks at each of these three areas in turn, spending a day on each. Suitable for any and all businesses and all levels of experience and expertise, this is a remarkably practical and hands-on programme. During the workshop, participants discuss, review and apply many proven sales and marketing techniques and personal selling ideas. The goal is to generate and commit to changes and actions that can lead to a 10-30% increase in the next three to six months. There's also a consultancy option, rather than the workshop-based programme. See below for details. Day one - Activity Key objective This first module introduces the Sales Accelerator model. The goal here is to show participants how to increase their pro-active activity levels by around 10%. It covers all aspects of creating new business opportunities, from existing customers and non-customers alike, and is linked to personal activity improvement goals. Main elements Improve the productivity, accuracy and effectiveness of your business approach by using new and unique models and techniques. Different methods of creating and generating new business opportunities in the short, medium and long term. This includes sourcing new business, up-selling, cross-selling, warm calling and gaining referrals. Using organised persistence to track and build new customer revenue. Managing your sales time effectively. Key learning points Sales productivity - understand the dynamics of increasing the combination of activity levels, deal value and conversion rate of proposals/quotations to orders and implement an improvement plan. Sales goal setting: setting business development objectives for quantity and quality - plus tips and tricks of top performers. Maintain a peak activity level, on a consistent basis using 'organised persistence' and structured business development tracking methodology. How to prioritise opportunities and manage your time when sourcing new business. Identify potential new customers - and particularly the decision-makers and influencers - with greater accuracy. Make outbound business or appointment calls with improved confidence, control and results. Day two - Value Key objective To be able to better anticipate, identify, create, and develop business opportunities using a customer / client-focused communication-based business model and consultative skills. Main elements How to develop sales more effectively from new and existing customers; and managing the first appointment with a new customer. Use structured and assertive drawing-out skills to identify, develop and formalise business opportunities and to gain commitment. How to better position your company and your products and services against your main competitors. Create and deliver persuasive business messages based on specific need areas, criteria and value. Key learning points Advanced consultative selling - use a variety of structured and advanced questioning techniques to confidently and efficiently uncover opportunities, need areas and business criteria - confidently and efficiently. Involve the customer/client at all times, and to a far greater degree, and keep better control of business development process. Value message - differentiate your solutions clearly and accurately with customer/client-matched value statements. Presenting the right USPs, features and benefits and making them relevant and real to the customer. Qualification and reading buying signals. Day three (held around four weeks after the first module) - Conversion Key objective This module looks at how to improve the final qualification, progression and conversion of opportunities in your sales pipeline. Also includes price negotiation, overcoming objections and obstacles to gaining agreement. The module begins with a learning review, sharing participants' experiences over the last four weeks in applying the new techniques and skills acquired during the first two modules. This is an opportunity to revisit particularly challenging areas as well as to share and celebrate successes. Main elements Structuring and preparing for negotiating a deal and knowing when and how to move into the 'end-game' mode. Anticipate and answer customer objections and questions more confidently. Build more credibility and proof into your business process to reduce 'buyer's remorse' and speed-up decision-making. Being more assertive and developing better instincts and strategic thinking in progressing quotations and proposals. Key learning points Smart ways to position price, emphasise value and be a strong player without being the cheapest. Becoming more assertive in closing deals, and the importance of organised follow-up on the telephone. Qualify pipeline opportunities with more accuracy, using a proven check-list. Use an 'option generator' to simplify complex proposals, increase business value and close business faster. Writing more effective sales proposal documents and quotations. How best to draw-out, understand, isolate and answer customer objections, negotiate points and concerns. Practical methods of asking for agreement and closing a sale

Duration 1.875 Days 11.25 CPD hours This course is intended for Allied Health Professionals. No prerequisites required Overview Upon completion of this course, students will - Learn the structure of the system and how to use the ICD-10-CM. - Learn how to map ICD-9-CM and ICD-10-CM codes. CEU?s Available :AAPC 4 Units (must have a current certification) AHIMA 6 Units (must have a current certification) - Become familiar with outpatient coding and reporting guidelines The focus of this class is learning the coding rules for the ICD-10-CM coding system and then applying the rules to code patient services. An Overview of ICD-10-CMUsing ICD-10-CMICD-10-CM Outpatient Coding and Reporting GuidelinesChapter Specific Guidelines Chapters 1-10Chapter Specific Guidelines Chapters 11-14Chapter Specific Guidelines Chapters 15-21

Duration 2.75 Days 16.5 CPD hours This course is intended for Complete beginners who have never programmed before to experienced developers coming from another programming language. Overview You will learn how to leverage the power of Python to solve tasks. You will build games and programs that use Python libraries. You will be able to use Python for your own work problems or personal projects. You will create a portfolio of Python based projects you can share. Learn to use Python professionally, learning both Python 2 and Python 3! Create games with Python, like Tic Tac Toe and Blackjack! Learn advanced Python features, like the collections module and how to work with timestamps! Learn to use Object Oriented Programming with classes! Understand complex topics, like decorators. Understand how to use both the Jupyter Notebook and create .py files Get an understanding of how to create GUIs in the Jupyter Notebook system! Build a complete understanding of Python from the ground up! Our Introduction to Python course is designed to take complete beginners or experienced developers up to speed on Python?s capabilities, setting up students for success in using Python for their specific field of expertise. Whether you have never programmed before, already know basic syntax, or want to learn about the advanced features of Python, this course is for you! In this course we will teach you Python 3. Learn how to use Python for real-world tasks, such as working with PDF Files, sending emails, reading Excel files, scraping websites for information, working with image files, and much more! This course will teach you Python in a practical manner and provides a full coding screencast and a corresponding code notebook to review the concepts and exercises conducted in class. Please note, this course is able to be offered in either 3 full day sessions or 5 partial day sessions. See the schedule below. This course includes 6-months access to the full course content in on-demand format to support post-class reference and review. Command Line Basics Python System Setup Jupyter Notebooks Python Data Types Key Data Structures Logic and Control Flow Functions Debugging Modules Object Oriented Programming File I/O Testing Decorators Generators Automation of Tasks Web Scraping Graphical User Interfaces Additional course details: Nexus Humans Introduction to Python training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Introduction to Python 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.