3139 Development courses in Leeds delivered Live Online

Duration 1 Days 6 CPD hours This course is intended for Individuals with basic computer skills, familiar with concepts related to database structure and terminology, and who want to use SQL to query databases. Overview Upon successful completion of this course, students will be able to: - connect to the SQL Server database and execute a simple query. - include a search condition in a simple query. - use various functions to perform calculations on data. - organize data obtained from a query before it is displayed on-screen. - retrieve data from tables. - format an output, save a result, and generate a report. In this course, students will compose SQL queries to retrieve desired information from a database. 1 - Executing a Simple Query Connect to the SQL Database Query a Database Save a Query Modify a Query Execute a Saved Query 2 - Performing a Conditional Search Search Using a Simple Condition Compare Column Values Search Using Multiple Conditions Search for a Range of Values and Null Values Retrieve Data Based on Patterns 3 - Working with Functions Perform Date Calculations Calculate Data Using Aggregate Functions Manipulate String Values 4 - Organizing Data Sort Data Rank Data Group Data Filter Grouped Data Summarize Grouped Data Use PIVOT and UNPIVOT Operators 5 - Retrieving Data from Tables Combine Results of Two Queries Compare the Results of Two Queries Retrieve Data by Joining Tables Check for Unmatched Records Retrieve Information from a Single Table Using Joins 6 - Presenting Query Results Save the Query Result Generate an XML Report

Hiring the right staff is one of the most important management and HR skills and it is critical to get it right. This course is designed for managers and HR specialists who either want to improve their interviewing skills or who are just now starting a recruitment role in the organisation.

Designed to help individuals and their organisations develop new products, services and ways of working to create sustainable value. The EFQM Innovation Leader Training is designed to help individuals and their organisations understand what innovation means for them and challenge them to focus on developing new products, services and ways of working to add new value. The training will focus on how to: Develop your understanding of innovation and how it can be successfully implemented using a structured innovation management approach Demonstrate the ability to effectively manage innovation activities to achieve the intended outcomes Course Content Overview of the EFQM Lens Concept Introduction to Innovation Lens Groupwork – Megatrends and how they impact on you Innovation Lens Framework – Structure and Content Groupwork – Completion of Innovation Questionnaire Discussion – Feedback on the Questionnaire and Outcomes How to manage the Innovation process Using Assess Base to baseline performance/conduct a gap analysis Pre-course Work Pre-reading on the new EFQM Model. Delivery The course is delivered through virtual trainer led live workshop. Upon registration, you will receive a link to the workshop. Cost £450 + VAT which includes the training course, the Innovation Lens e-book and your EFQM Innovation Leader Certificate. If you are not yet a member but are already thinking about joining CforC, you can find more information on how to become a member and the benefits by clicking here.

Designed to help individuals and their organisations develop new products, services and ways of working to create sustainable value. The EFQM Innovation Leader Training is designed to help individuals and their organisations understand what innovation means for them and challenge them to focus on developing new products, services and ways of working to add new value. The training will focus on how to: Develop your understanding of innovation and how it can be successfully implemented using a structured innovation management approach Demonstrate the ability to effectively manage innovation activities to achieve the intended outcomes Course Content Overview of the EFQM Lens Concept Introduction to Innovation Lens Groupwork – Megatrends and how they impact on you Innovation Lens Framework – Structure and Content Groupwork – Completion of Innovation Questionnaire Discussion – Feedback on the Questionnaire and Outcomes How to manage the Innovation process Using Assess Base to baseline performance/conduct a gap analysis Pre-course Work Pre-reading on the new EFQM Model. Delivery The course is delivered through virtual trainer led live workshop. Upon registration, you will receive a link to the workshop. Cost £450 + VAT which includes the training course, the Innovation Lens e-book and your EFQM Innovation Leader Certificate. If you are not yet a member but are already thinking about joining CforC, you can find more information on how to become a member and the benefits by clicking here.

Simply speaking, Life Coaching is about raising awareness of how we can move from A to B. Sometimes we don't know what place B is, and we can use Coaching to gain clarity on what B looks and feels like. Life Coaching is non-directive, which means as a Coach, I help you to unlock your potential rather than tell you what to do. The experience creates a space for accountability and motivation to take positive action. ​ My role as your Holistic Coach is to provide you with a safe space for you to ground, explore & embrace your emotions, claim your personal power to design & live your dream life.

Enhance your ability to apply a range of techniques and tools to help improve management of emotions under stress, make more effective decisions in difficult scenarios and manage your energy more effectively in stressful situations.

Duration 1 Days 6 CPD hours This course is intended for Students should have basic computer skills, SQL skills, and be familiar with concepts related to database structure and terminology. Overview Upon successful completion of this course, students will be able to: - Use subqueries to generate query output. - Manipulate table data by inserting, updating, and deleting records in a table. - Manipulate the table structure. - Create views, manipulate data through views, modify the view structure, and drop views. - Create indices on table columns and drop inefficient indices. - Mark the beginning of a transaction, create a savepoint within a transaction, rollback a transaction, and commit a transaction. In this course, students will work with advanced queries to manipulate and index tables. Students will also create transactions so that you can choose to save or cancel data entry process. Prerequisites SQL Querying Fundamentals - Part 1 1 - Using Subqueries to Perform Advanced Querying Search Based on Unknown Values Compare a Value with Unknown Values Search Based on the Existence of Records Generate Output Using Correlated Subqueries Filter Grouped Data Within Subqueries Perform Multiple-Level Subqueries 2 - Manipulating Table Data Insert Data Modify and Delete Data 3 - Manipulating the Table Structure Create a Simple Table Create a Table with Constraints Add or Drop Table Columns Add or Drop Constraints Modify the Column Definition Back Up Tables Delete Tables 4 - Working with Views Create a View Manipulate Data in Views Create Aliases Modify and Drop Views 5 - Indexing Data Create Indices Drop Indices 6 - Managing Transactions Create Transactions Commit Transactions

Feeling overwhelmed by multiple tasks? Ready to enhance your product management strategy with AI technology? It’s time to meet your new AI partner! Our course, “Unlocking the Power of AI,” will demonstrate how cutting-edge tools like Generative Pre-trained Transformers (GPTs) can simplify your workflow and bolster your decision-making process. In modern-day fast paced commercial enterprise world, adaptability is vital for success. As a product manager, you oversee the entire product lifecycle—from concept to launch and beyond. With Certified Product Management techniques, you can navigate changing market dynamics, prioritize features efficiently, and deliver value to customers quickly. However, agility alone isn’t sufficient. To excel in your role, embrace the potential of AI. By integrating AI into your practices, you can automate tasks, analyze data effortlessly, and make informed decisions. Picture having a virtual assistant capable of analyzing data and predicting market trends. With AI as your ally, you can focus on engaging customers, innovating, and strategic planning. Don’t hesitate. Embrace the future of product management now. Join us on this journey to unlock the full potential of AI, revolutionizing your workflow and achieving your goals faster than ever before. What You'll Learn (in just 3 hours!) AI 101 for Product Managers We'll break down the buzzwords and get you up to speed on how AI (especially those clever GPTs) can transform your work life. Market Research Master Think of your new AI pal as a super-powered market researcher. Learn how to analyze competitor data, customer feedback, and trends faster than you can say "pivot!" AI-Powered Strategy Say goodbye to gut feelings and hello to data-driven insights. Discover how AI helps you strategize, prioritize features, and build roadmaps that will make your product shine. Hands-on Workshop Dive into real-world scenarios and use GPT tools to tackle market analysis, craft user stories, and nail down your product roadmap. Ethics in the AI Age We'll explore responsible AI use and make sure you understand the potential pitfalls. Because with great power comes great responsibility! Our AI + Your Workflow = Dream Team We'll cover how to access our Product Management tool, how to use it effectively and fit it seamlessly into your existing processes. The future of Product Management is here, don’t get left behind. This course is perfect for Product managers and owners are essential drivers of product success, constantly challenged to balance priorities, navigate complex decisions, and foster innovation in competitive markets. With technology advancing rapidly and consumer preferences evolving, staying ahead can be daunting. Our training programs offer a solution. Designed for product managers and owners, they equip you with the tools, insights, and strategies to enhance productivity, make informed decisions, and ignite innovation. Our courses empower you to navigate modern challenges successfully. Whether you seek to refine strategic planning, optimize product development, or enhance customer engagement, our tailored programs cater to your needs. Join us on a journey to unlock your full potential and propel your career to new heights as a product manager or owner. The Takeaway Empowerment: Leave this workshop feeling empowered, armed with a potent toolkit for achieving product success. AI in Product Management: Recognize that AI is the future of product management, and this course will equip you to leverage its potential effectively. Leadership Position: Position yourself as a leader in product management by embracing AI and staying ahead of industry trends. Innovation: Embrace innovation and drive change within your organization with the insights gained from this course. Confidence: Approach the future with confidence, knowing that you have the skills and knowledge to navigate the evolving landscape of product management.

Duration 2 Days 12 CPD hours This course is intended for The primary audience for this course are persons who are new to reporting with Microsoft© SQL Server© Report Builder and SSRS, persons who are transitioning from another reporting software application, and persons who are existing Report Builder and SSRS report authors. Overview Navigate the Report Builder Environment. - Create table reports. - Format reports. - Create basic and complex expressions. - Group report data. - Create matrix reports. - Sort and filter data. - Summarize data with charts. - Print and export reports. In this course, students will continue their learning on the foundations of report writing with Microsoft© SQL Server© Report Builder and SSRS. Prerequisites ?Familiarity with Windows. ?Creating and navigating folders. ?Opening programs. ?Manipulating windows. ?Copying and pasting objects. ?Formatting text. ?Saving files. 1 - Exploring the Report Builder Environment Introducing the Report Builder Environment Working with Existing Reports Lab 1: Exploring the Report Builder Application 2 - Adding Data to Table Reports Create Report Data Sources Create Report Datasets Work with the Tablix Data Region Create a Table Report Lab 1: Creating Table Reports 3 - Formatting Data and Creating Expressions in Reports Formatting Reports Sorting and Filtering Report Data Adding Data to a Dataset Creating Simple Expressions Creating Complex Expressions Lab 1: Formatting Reports 4 - Grouping Report Data Group Data in Reports Group Data Using an Expression Creating Subgroups and Group Aggregates Lab 1: Creating Reports with Groups and Aggregates 5 - Matrix Reports Creating and Modifying Matrix Data Regions Creating and Modifying Column Groups Lab 1: Creating Matrix Reports 6 - Charts Create and Modify Chart Wizard Reports Add Charts to Existing Reports Modify Charts in Reports Lab 1: Creating Charts and Chart Reports 7 - Printing and Exporting Reports Print Features and Print Options Export Reports Lab 1: Printing and Exporting Reports

A short course in Wellbeing Coaching for individuals who would like to develop coaching skills to support others in improving their wellbeing.