3130 Development courses in Edinburgh 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.

Montessori Education for Early Childhood Course Overview The Montessori Education for Early Childhood course provides an in-depth exploration of the Montessori philosophy and its application to early childhood education. This course covers key principles, activities, and teaching strategies designed to foster independent learning in young children. Learners will gain a comprehensive understanding of how to implement Montessori techniques in both classroom and home environments, empowering children to take initiative in their learning. The course is ideal for those looking to develop a well-rounded understanding of Montessori education and its practical value in nurturing the intellectual and emotional growth of children. Course Description This course delves into the core principles of Montessori education, covering everything from the basics of Montessori teaching to specific tools and activities. Learners will explore how to create an effective Montessori learning environment, design educational materials like Montessori mobiles, and teach children about emotions and mathematics. Emphasis is placed on the creation of Montessori-friendly spaces at home and in educational settings. By the end of the course, participants will acquire the skills to implement Montessori methods that encourage self-discovery, problem-solving, and emotional development in children, setting the foundation for lifelong learning. Montessori Education for Early Childhood Curriculum Module 01: Introduction Module 02: Basic Principles Module 03: Montessori Mobiles Module 04: Montessori Activities Module 05: Designing Montessori Home Module 06: Setting Rules in the Montessori Approach Module 07: Teaching Children About Emotions Module 08: Mathematics Montessori Module 09: Montessori Screen (See full curriculum) Who is this course for? Individuals seeking to understand Montessori education for early childhood. Professionals aiming to enhance their skills in early years teaching. Beginners with an interest in Montessori principles and methods. Parents or caregivers interested in implementing Montessori techniques at home. Career Path Montessori Teacher Early Childhood Educator Montessori School Administrator Child Development Specialist Educational Consultant Parenting Coach

Train the Trainer - Part 2 Course Overview: "Train the Trainer - Part 2" is designed for individuals who wish to elevate their training and presentation skills to the next level. This course offers in-depth guidance on how to maintain participant engagement, ensure clarity, and use effective communication techniques. Learners will explore advanced strategies for building rapport with their audience, refining their delivery style, and ensuring their messages are understood. By the end of this course, learners will be equipped with the tools to create more dynamic and impactful training sessions, fostering a deeper level of understanding and retention among participants. Course Description: This course delves into essential training strategies that enhance delivery and participant involvement. Learners will explore techniques for keeping the audience engaged, presenting material in a way that aids comprehension, and using non-verbal cues such as body language and tone to reinforce their message. The course covers strategies to help learners follow along, assess their understanding, and improve retention. By examining these core aspects, participants will develop advanced skills for delivering clear and memorable training. Upon completion, learners will be able to create a more effective learning environment and be prepared to engage with diverse audiences across various training settings. Train the Trainer - Part 2 Curriculum: Module 01: Introduction Module 02: Keep Them Engaged Module 03: Help Them Follow Along Module 04: Ensure They Understand Module 05: Use Effective Body Language and Tone (See full curriculum) Who is this course for? Individuals seeking to improve their training and presentation skills. Professionals aiming to enhance their teaching effectiveness. Beginners with an interest in becoming a more effective trainer. Anyone looking to engage audiences more effectively in a training environment. Career Path: Corporate Trainer Training and Development Specialist Learning & Development Coordinator Public Speaker Instructional Designer

Day-to-Day Leadership Course Overview: This course on Day-to-Day Leadership equips learners with the essential tools and strategies to effectively lead on a daily basis. Covering key leadership principles and real-world applications, it focuses on enhancing decision-making, communication, and team management. Learners will explore situational leadership, practical models, and adaptable leadership styles that can be applied to diverse organisational settings. The course provides learners with the confidence to implement leadership strategies that foster collaboration, productivity, and team morale in their daily work. Course Description: The Day-to-Day Leadership course delves deeper into various leadership theories, including Situational Leadership, and offers a structured framework for leading teams effectively. Throughout the course, learners will engage with key concepts, including how to adapt leadership styles to different situations, develop key skills for motivating teams, and apply leadership strategies to ensure productivity and engagement. With an emphasis on real-world applications, learners will be guided through practical models and gain valuable insights into team dynamics, communication, and problem-solving. This course is ideal for individuals looking to enhance their leadership capabilities and progress in their professional development. Day-to-Day Leadership Curriculum: Module 01: Introduction to this Course Module 02: Introduction to Situational Leadership Module 03: A Practical Model for Day-to-Day Leadership Module 04: The Skills for Day-to-Day Leadership Styles Module 05: Bonus Content Module 06: Closing Section (See full curriculum) Who is this course for? Individuals seeking to develop leadership capabilities. Professionals aiming to enhance their team management skills. Beginners with an interest in leadership and management. Those interested in improving day-to-day workplace leadership. Career Path: Team Leader Operations Manager Project Manager Department Head Leadership Coach Organisational Development Specialist

Business Startup Course Overview This course is designed for aspiring entrepreneurs and business professionals looking to gain essential knowledge and skills for launching a successful startup. It covers key concepts such as identifying business models, creating innovative ideas, building a brand, and implementing both active and passive sales strategies. Learners will explore the stages of business creation from conception to execution and develop a clear business action plan. By the end of the course, participants will be equipped with the tools necessary to develop their own business and take confident steps toward growth and sustainability. Course Description The "Business Startup" course delves into the fundamental components required to start and run a successful business. Topics include the Adonis Business Model, which provides a framework for building a profitable business, the steps involved in creating a viable business idea, and the methods for constructing a strong brand identity. The course also covers effective sales techniques, both active and passive, to drive revenue. Additionally, learners will be guided through the process of creating a comprehensive business and action plan to set the foundation for long-term success. This course is ideal for anyone looking to start their own business or develop their entrepreneurial mindset. Business Startup Curriculum: Module 01: Adonis Business Model – The Model of Successful Businesses Module 02: Creation of A Business Idea Module 03: Building A Successful Brand Module 04: Active Sales Module 05: Passive Sales Module 06: Create A Business and Action Plan (See full curriculum) Who is this course for? Individuals seeking to start their own business. Professionals aiming to expand their entrepreneurial skills. Beginners with an interest in business development. Entrepreneurs looking to refine their business strategies. Career Path Business Owner Entrepreneur Brand Manager Sales Manager Marketing Manager Business Development Executive

Are you a teacher that wants to improve your classroom environment? Do you have questions about supporting children with their behaviour, communication and relationships? Book a 30 minute / 1 hour 1:1 coaching call. My coaching model will provide you with practical solutions to help you create a calm classroom environment. Discounts offered to subscribers.

Historical Association webinar series: Making history accessible Presenters: Cat Priggs This webinar will provide an overview of recent key developments in SEND, including statutory guidance and regulations from Ofsted’s latest Education Inspection Framework and the SEND improvement plan. Drawing on SEND toolkits, we will reflect on how to embed inclusive practice. This will be explored in the context of the history classroom as we draw upon the Historical Association’s Secondary Committee ‘Making History Accessible’ resources to consider how to develop and support SEND students’ historical learning. At the end of this session, participants will be introduced to an optional small-scale action research project. This project will prompt reflection on a specific aspect of participants’ practice, which will be explored and reviewed through the webinar series. Image: A Squire "Old English" padlock on a gate latch in Devon (Image: Partonez/Wikimedia Commons)

Duration 4 Days 24 CPD hours This course is intended for Designed for individuals interested in obtaining information about the CBAP and CCBA exam process especially potential exam candidates interested in pursuing business analysis certification from IIBA in the next 3 to 6 months. Overview Review the 6 Knowledge Areas of the BABOK Guide and discuss the business analysis tasks performed in each. Understand the relationships between the business analysis processes and how each defines an important aspect of the business analysis discipline. Review key terms, business analysis techniques, and competencies important to business analysis. Discuss the 5 business analysis Perspectives presented in BABOK Guide, v3. Complete simulated exam questions to assess personal readiness for taking the exam. Obtain key tips and techniques for effectively preparing for and successfully completing the CBAP or CCBA exam. This course provides you with a clear and detailed understanding of the concepts covered within the CBAP© and CCBA© exams. You will gain valuable tips and techniques to help prepare, study, and assess your personal readiness. In addition, you will earn valuable professional development hours toward meeting the exam criteria. CBAP© and CCBA© Overview Discuss the benefits of professional certification Present the CBAP©/CCBA© eligibility requirements Explain the exam process Discuss the exam blueprints Understand the recertification process Introduction to BABOK© Guide v3 Define the purpose of A Guide to the Business Analysis Body of Knowledge© (BABOK© Guide) Present the structure/components of the BABOK© Guide Identify the six business analysis Knowledge Areas Discuss the supporting areas of the BABOK© Guide BABOK© Guide Key Concepts Define key concepts from the BABOK© Guide Present the Business Analysis Core Concept Model? Discuss the requirements classification scheme Explain Requirements and Designs Present the 5 Business Analysis Perspectives Business Analysis Planning and Monitoring Identify the 5 tasks in Business Analysis Planning and Monitoring Understand the work performed in each of these tasks Explain the significance of the outputs produced within this knowledge area Elicitation and Collaboration Identify the 5 tasks in Elicitation and Collaboration Understand the work performed in each of these tasks Explain the significance of the outputs produced within this knowledge area Requirements Life Cycle Management Identify the 5 tasks in Requirements Life Cycle Management Understand the work performed in each of these tasks Explain the significance of the outputs produced within this knowledge area Strategy Analysis Identify the 5 tasks in Strategy Analysis Understand the work performed in each of these tasks Explain the significance of the outputs produced within this knowledge area Requirements Analysis and Design Definition Identify the 6 tasks in Requirements Analysis and Design Definition Understand the work performed in each of these tasks Explain the significance of the outputs produced within this knowledge area Solution Evaluation Identify the 6 tasks in Solution Evaluation Understand the work performed in each of these tasks Explain the significance of the outputs produced within this knowledge area Underlying Competencies Describe and understand the importance of the underlying competencies (UCs) Understand how to prepare for questions about UCs on the exam Business Analysis Techniques More clearly understand the 50 techniques presented in the BABOK© Guide Understand how to study techniques for the exam Assess Your Readiness 1 hour mock-exam to assess personal readiness Strategies for Success Utilize 8 strategies for preparing for the CBAP© or CCBA© certification exams Develop study tools and a plan to assist you in preparing for the exams Understand the tools and resources available to help you be successful Wrap-up Take Your Questions Next Steps Additional course details: Nexus Humans BACP02 - Certified Business Analysis Professional (CBAP) Exam Preparation 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 BACP02 - Certified Business Analysis Professional (CBAP) Exam Preparation 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.

Goal Setting, Motivation, and Resilience for Life Course Overview: "Goal Setting, Motivation, and Resilience for Life" equips learners with the essential tools to master personal development. This course delves into the principles of goal setting, mental toughness, and resilience, offering practical strategies for overcoming challenges and achieving success. Learners will gain a deeper understanding of how motivation works and how to use it effectively in their daily lives. Upon completion, participants will have the skills to remain resilient in the face of adversity, set and accomplish meaningful goals, and develop a positive mindset that supports long-term success. Course Description: This course covers the science of mental toughness and the power of resilience, providing learners with the framework to build mental strength and navigate life’s challenges. Topics include positive thinking, visualisation techniques, building a resilient mindset, and managing stress effectively. Learners will also explore the role of goal setting in success and how to achieve personal growth. By studying the strategies behind mental fitness, learners will develop an expert understanding of how to cultivate long-lasting motivation. Ultimately, this course empowers learners to create and achieve their personal and professional goals while fostering a positive, resilient mindset. Goal Setting, Motivation, and Resilience for Life Curriculum: Module 01: Introduction Module 02: Science of Mental Toughness Module 03: Positive Thinking and Visualization Module 04: Building a Resilient Mindset Module 05: Surviving and Thriving with Stress Module 06: Goal Setting and Developing Expertise Module 07: Solving the Happiness Equation Module 08: Implementing Mental Fitness (See full curriculum) Who is this course for? Individuals seeking to improve personal resilience. Professionals aiming to develop better goal-setting strategies. Beginners with an interest in self-improvement and mental toughness. Anyone looking to build a more positive mindset for personal and career growth. Career Path: Personal development coach Motivational speaker Human resources consultant Well-being programme manager Corporate trainer Stress management consultant Life coach

Train the Trainer Recharge: The Healthy Trainer Course Overview This course offers an essential refresh for trainers aiming to enhance their personal wellbeing alongside their professional skills. It focuses on maintaining a healthy balance between the demands of training others and self-care, ensuring trainers remain effective, energised, and confident. Learners will develop strategies to manage their own stress, address challenges confidently, and create positive learning environments. This course equips participants with the ability to engage audiences meaningfully, foster productive feedback, and maintain resilience in dynamic training settings. By the end, trainers will be better prepared to sustain their motivation and deliver impactful sessions while prioritising their own health and wellbeing. Course Description The programme delves into key areas crucial for trainers to maintain optimal performance and wellbeing. It covers techniques for self-management, including stress reduction and emotional regulation, alongside strategies to resolve common challenges encountered in training roles. Emphasis is placed on managing classroom dynamics and engaging diverse audiences effectively. Additionally, learners will explore ways to interpret and respond to feedback constructively to improve delivery and participant outcomes. This course combines reflective learning with evidence-based methods to build resilience, boost trainer confidence, and support continuous professional growth in a balanced, healthy manner. Participants will leave with renewed skills to enhance both their training impact and personal wellbeing. Train the Trainer Recharge: The Healthy Trainer Curriculum Module 01: Welcome to Healthy Trainer Module 02: Manage Yourself Module 03: Manage Your Issues Module 04: Manage Your Classroom Module 05: Manage Your Audience Module 06: Manage Your Feedback (See full curriculum) Who is this course for? Individuals seeking to enhance their trainer wellbeing and effectiveness. Professionals aiming to develop sustainable training practices. Beginners with an interest in personal development and training skills. Trainers wanting to improve audience engagement and feedback management. Career Path Corporate Trainer Learning and Development Specialist Workshop Facilitator Training Coordinator Education Consultant