13731 Courses

This training based on leading teams will help you to develop anyone that leads a team or is involved in a leadership role. It is also useful for those that are about to embark on a position of leadership or need to develop their leadership skills.

Unleash Your Inner Bird! Sky Riders Elementary Pilot Course. Learn to paraglide with our beginner-friendly course.

So often change fails because of our own pursuit of perfection. Learning to love imperfect change will improve your resilience and help you deliver positive change.

Learn how to create people and planet strategies that identify the lifecycles that exist within your business, and promote them widely, helping your business and the planet flourish.

This course will help you and your employees gain the necessary vocabulary, grammar, and conversational abilities from our qualified instructors. Additionally, our interactive lessons and hands-on activities will improve your BSL proficiency and comprehension. This Course At A Glance Live Zoom classes with an expert BSL tutor, Adam Linsdell. Gain an extensive understanding of deaf awareness. Acquire knowledge of several commonly used vocabulary words. CPD Accredited certificates are recognized by employers and professional organisations. Enhance your communication skills through practical exercises. BSL Training Course Overview This BSL training course, CPD certified workplace oriented classes, is an immersive 18-hour duration (3 hours per week) course designed to enhance your communication skills with deaf colleagues and customers in a specific workplace setting. This comprehensive program will equip you with the necessary tools to establish effective interactions and bridge the communication gap. Throughout the course, you will learn essential vocabulary, grammar, and conversational skills in British Sign Language (BSL). Additionally, you will gain insights into deaf culture and develop a deeper understanding of the challenges faced by individuals with hearing impairments in the workplace. By the end of this course, you will be able to confidently communicate using BSL and contribute to a more inclusive and accessible work environment. BSL Training for Workplace, Autumn 2025 Please book your place in advance Weekly via Zoom Online Live Class. You can attend the class online from home/workplace. Total Duration: 18 Hours Class Starts: August 08, 2025-October 10, 2025 Day & Time: 10:00 am – 12:00 pm (Thursday, 2 hours per week) Venue: Zoom Online Teacher: Adam Linsdell Who should take this course? BSL for the Workplace is perfect for individuals, employees, large or small businesses. Those who are seeking to improve their communication with deaf colleagues and customers in their professional environment can opt for this course. Whether you work in health and healthcare, retail and shopping, hospitality, cultural settings, or public services, this course will provide you with the skills needed to connect and engage with the deaf community. Learning Outcomes: Upon completing the BSL for the Workplace course, participants will achieve the following learning outcomes: Learn fingerspelling alphabets and words with accuracy Develop simple conversations and confidently ask questions on a range of everyday topics Fostering meaningful interactions with deaf colleagues and customers. Demonstrate basic vocabulary related to various topics, allowing for effective expression of ideas and needs. Discover workplace-specific vocabularies relevant to their professional setting Help you engage in specialised conversations and enhance workplace communication. Invest in your communication skills and create an inclusive workplace environment. Enrol in a BSL training course CPD certified workplace oriented classes today and unlock new opportunities for effective communication with the deaf community. Course Curriculum Greetings Learn essential BSL greetings to initiate conversations and create a welcoming atmosphere. These greetings include basic phrases such as “hello,” “good morning,” “how are you?” and more which are essential for establishing rapport and building relationships with deaf individuals. The BSL Alphabet and Fingerspelling Master the BSL alphabet and develop the ability to fingerspell words accurately, enabling effective communication of names, technical terms, and unfamiliar vocabulary. This skill is particularly useful in situations where there may be unfamiliar vocabulary or technical terms that need to be spelled out. Meeting People / Questions Enhance your conversational skills by learning how to introduce yourself, engage in small talk, and ask questions in BSL. These skills will allow you to confidently interact with Deaf individuals and create meaningful connections. Additionally, understanding how to ask questions in BSL will enable you to gather information and participate actively in conversations. Numbers and Number Related Vocabulary Acquire the knowledge to express age, money, and dates accurately in BSL, enabling seamless interactions in various contexts. Mastering numbers and number-related vocabulary in BSL will also help you navigate everyday situations such as shopping, making appointments, and discussing schedules. Being able to accurately express age, money, and dates will enhance your ability to communicate effectively and independently in the Deaf community. Transport / Travel Explore BSL vocabulary related to transportation and travel, enabling you to provide clear directions and discuss travel arrangements. You will learn signs for different modes of transportation such as cars, buses, trains, and aeroplanes, as well as how to ask for and give directions. Additionally, you will be able to discuss travel plans, including booking tickets and discussing itineraries. Telling the Time / Calendar Develop proficiency in expressing time and discussing calendar events in BSL, ensuring effective scheduling and time management. You will also become familiar with discussing different calendar events such as birthdays, holidays, and appointments. This will enable you to effectively manage your schedule and plan your activities accordingly. Weather Expand your vocabulary to discuss weather conditions, enabling you to engage in casual conversations and make relevant inquiries. This skill will also allow you to understand weather forecasts and prepare for any upcoming changes in the weather. Colours Learn the BSL signs for various colours, facilitating discussions about visual elements and enhancing your ability to describe objects accurately. This knowledge will enable you to express yourself more effectively and engage in a wider range of conversations. Describing People Develop the skills to describe individuals’ appearance and characteristics in BSL, allowing you to effectively communicate observations and share information. This skill will not only enhance your ability to interact with deaf individuals but also improve your overall communication skills. Additionally, being able to describe people accurately in BSL can help you navigate social situations and build stronger connections with others. Directions Master directional vocabulary in BSL, empowering you to provide clear instructions and navigate through spaces confidently. This skill will also boost your confidence when navigating unfamiliar spaces, as you will have the ability to clearly communicate directions and understand them yourself. Workplace-Specific Vocabulary Discover workplace-specific vocabulary tailored to your professional setting, such as health and healthcare, retail and shopping, hospitality, cultural settings, and public services. Use this vocabulary to develop simple conversations and strengthen your workplace communication skills. Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field. Certificate of Achievement Certificate of Achievement from Lead Academy After successfully completing the live training, you will be eligible to receive your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version as well as hardcopy version at a free of cost.

The IPAF operator course instructs a candidate to prepare and safely operate various types of MEWPs, also referred to as cherry pickers, aerial lifts or scissor lifts. Categories include Static Vertical (1a), Static Boom (1b), Mobile Vertical (3a), Mobile Boom (3b), Specialist Machines (SPECIAL), Push Around Vehicle (PAV), Insulated Aerial Device (IAD).Categories include Static Vertical (1a), Static Boom (1b), Mobile Vertical (3a), Mobile Boom (3b),

This course covers the basics of dog grooming. In addition to 5 days at our school, there are 2 written modules, grooming diaries and 1 assessment at the end of the 5 days. The 5 days on this course count as part of the 15 day Certificate or the 30 day Diploma if you wish to upgrade. This qualification is aimed to introduce students to dog grooming, and give you a taste of what being a dog groomer could be.

Getting Started The CMI Level 7 Certificate in Strategic Management and Leadership Practice is an ideal course for individuals wishing to develop the necessary skills required for effective senior managers and leaders. This CMI Level 7 Certificate course is designed for those desiring to develop strategic management and leadership practices who will have the knowledge, skills and behaviours to drive business activities in a senior, regional, specialist, director or CEO management and leadership role. You will gain the expertise and significantly improve your potential to implement fundamental management and leadership models within an organisation's strategic framework. Depending on your career goals, you will learn various aspects of strategic management and leadership practices. The Level 7 Certificate in Strategic Management and Leadership Practice is a shorter course that will give you key skills and competencies to become a competent manager and deliver effective results for your organisation. You'll have a wide range of modules to choose from, and depending on your career goals, you can select the modules that will be most effective for your progression. Key Benefits Demonstrate to employers that you possess substantial senior management and leadership skills required to drive business activities and achieve organisational success. Develop the professionalism to deliver impact and behave ethically Demonstrate a commitment to continual learning and development Build strategic management and leadership skills to focus on the requirements of embedding the organisation's strategy Provide skills and behaviours to drive core business activities Key Highlights Do you want to develop strategic management and leadership skills and drive business activities in a senior, regional, director or CEO management and leadership role? The CMI Level 7 Strategic Management & Leadership Practice offered by the School of Business and Technology London is the ideal starting point for your career journey. Remember! The assessment for the qualification is done based on assignments only, and you do not need to worry about writing any exam. With the School of Business and Technology London, you can complete the qualification at your own pace, choosing online or blended learning from the comfort of your home. Learning and pathway materials and study guides developed by our CMI-approved tutors will be available around the clock in our cutting-edge learning management system. Most importantly, at the School of Business and Technology London, we will provide you with comprehensive tutor support through our dedicated support desk. If you choose your course with blended learning, you will also enjoy live sessions with an assigned tutor, which you can book at your convenience.   Career Pathways The CMI Level 7 Strategic Management & Leadership Practice can open many career pathways including, but not limited to: Senior Manager - With an estimated average salary of £ 75,270 per annum Regional Manager - With an estimated average salary of £ 52,379 per annum Specialist Manager With an estimated average salary of £56,872 per annum Regional Director, with an estimated average salary of £110,000 per annum Director, with an estimated average salary of £135,397 per annum CEO, with an estimated average salary of £155,000 per annum About Awarding Body Chartered Management Institute established over 60 years ago as the British Institute of Management back then; it has developed the UK's very first diploma in management studies. In the years that followed CMI has consistently been at the forefront of all aspects of management and leadership. Today CMI is the only chartered professional awarding body committed to offering the highest standards in management and leadership excellence. Presently over 100,000 managers use its unique services daily. CMI qualifications aim for managers and leaders at any level, and it remains the only Awarding Body which can award Chartered Manager status - the ultimate management accolade. Employers highly value the qualifications awarded by CMI, and boost your career prospects. What is included? Learn 100% online at your own pace Dedicated support from expert tutors Dedicated Support Desk Portal: You can raise queries, request tutor support and ask for a call back whenever you need guidance and assistance. Elevate Knowledge: Your tutors will provide formative assessment feedback for each module, helping you improve your achievements throughout the program Schedule online personal tutor meetings whenever you want, which will help you get the most out of your studies and provide guidance, support and encouragement 10 months support period 24-hour access to the online learning platform 'MyLearnDirect' Schedule live online classes for each module at your convenience. (Blended learning only) Quality learning resources and study guides developed by CMI-approved tutors. All assessment materials are conveniently accessible through the online learning platform 'MyLearnDirect' Induction: We offer online and flexible learning induction to help you settle in and prepare for your online studies Get Foundation Chartered Manager status upon course completion Fast Track to Chartered Manager status. You will be eligible to apply for Chartered Manager status, the ultimate professional accolade for managers, after completing the course and with 3+ years of experience in a managerial role. Access to CMI Management Direct. It has 100,000s of reliable and validated management and leadership resources, including company and industry reports, videos, checklists, E-books, and journals. You have access to CMI Membership and Support for the duration of your study. Assessment For each module you study, you will complete a written assignment of 3500 to 4500 words and submit it online at your MyLearnDirect learning portal. The submitted assignments will be assessed by your CMI-approved tutor. Entry Requirements This course is designed for practising or aspiring senior managers, regional managers, specialist managers, or directors.  You don't need any formal qualifications to study the CMI Level 7 Certificate in Strategic Management and Leadership Practice. However, to be eligible for this course, you must:  Be 21 years of age and over Have some management experience in the junior, middle or senior level Possess the ability to complete the Level 7 course Our friendly admissions advisors will provide the best advice, considering your needs and goals.  Progression Upon successful completion of their qualification, learners are able to progress to further learning within the suite of Level 7 Qualifications in Strategic Management and Leadership in Practice - i.e. completing the certificate and topping up to the Diploma. Why gain a CMI Qualification? Achieving the globally recognised CMI Level 7 qualification will demonstrate to employers that you possess substantial senior management and leadership skills required to drive business activities and achieve organisational success. The CMI Level 7 Certificate in Strategic Management and Leadership Practice is ideal for senior managers, regional managers, directors and CEOs who want to develop skills to drive business activities and deliver long-term outcomes. With this CMI Level 7 Certificate, you will develop skills and knowledge to manage people, projects, change, services, operations, and strategies for delivering organisational success. You will build your strategic management and leadership skills to focus on the requirements of embedding the organisation's strategy. Upon completing this course, you can progress to further learning within the suite of Level 7 courses in Management and Leadership - i.e. achieving a Certificate and topping up to a Diploma. Studying for a CMI qualification offers you more than just academic standing. When you enrol with us for the CMI Level 7 Certificate in Strategic Management and Leadership Practice, you will have access to CMI Membership and Support for the duration of your study alongside your qualification. You can fast-track to apply for Chartered Manager status, the ultimate professional accolade for managers, after completing the CMI Level 7 Certificate in Strategic Management and Leadership Practice course and with 3+ years of experience in a managerial role. CMI graduates achieve remarkable things: 72% agree that their CMI qualification gave them a competitive edge in the job application process. 89% agree they use the skills learnt on their accredited qualification in their current role. 88% agree that the accredited qualification gave them good career prospects. Recent CMI graduates earn a median of 28k compared to just 21k for a typical business studies graduate. Employers highly value the qualifications awarded by CMI, and over 80% of managers agree that a CMI qualification is essential to becoming a professional manager. Learners must request before enrolment to interchange unit(s) other than the preselected units shown in the SBTL website because we need to make sure the availability of learning materials for the requested unit(s). SBTL will reject an application if the learning materials for the requested interchange unit(s) are unavailable. Learners are not allowed to make any request to interchange unit(s) once enrolment is complete. UNIT1- Strategic Risk Management Reference No : CMI 708 Credit : 8 || TQT : 80 LEARNING OUTCOME 1. Understand strategies for managing risk. 2. Know how to develop risk management strategies. UNIT2- Leading Strategic Change Reference No : CMI 705 Credit : 8 || TQT : 80 LEARNING OUTCOME 1. Understand the scope and context of strategic change. 2. Know how to propose a strategy for leading strategic change. UNIT3- Finance for Strategic Leaders Reference No : CMI 706 Credit : 9 || TQT : 90 LEARNING OUTCOME 1. Understand the scope of the Finance function within an organisational context. 2. Understand the role of Finance in strategic decision making. UNIT4- Organisational Design and Development Reference No : CMI 707 Credit : 8 || TQT : 80 LEARNING OUTCOME 1. Understand organisational design and development. 2. Understand how to apply the principles of organisational design and development. UNIT5- Developing Organizational Strategy Reference No : CMI 704 Credit : 9 || TQT : 90 LEARNING OUTCOME 1. Understand how to develop strategy. 2. Know how to develop strategy. UNIT6- Strategic Leadership Reference No : CMI 701 Credit : 11 || TQT : 110 LEARNING OUTCOME 1. Understand the role and context for strategic leadership. 2. Understand the behaviours and skills for strategic leadership. UNIT7- Leading and Developing People to Optimise Performance Reference No : CMI 702 Credit : 10 || TQT : 100 LEARNING OUTCOME 1. Understand the principles for leading and developing people. 2. Understand leadership and development strategy. UNIT8- Collaboration and Partnerships Reference No : CMI 703 Credit : 7 || TQT : 70 LEARNING OUTCOME 1. Understand the role of collaboration and partnerships. 2. Know how collaboration and partnerships further organisational success. UNIT9- Strategic Management of Data and Information Reference No : CMI 709 Credit : 8 || TQT : 80 LEARNING OUTCOME 1. Understand the strategic management of data and information UNIT10- Marketing Strategy Reference No : CMI 710 Credit : 8 || TQT : 80 LEARNING OUTCOME 1. Understand the context in which a marketing strategy is developed. 2. Know how to develop a marketing strategy. UNIT11- Entrepreneurial Practice Reference No : CMI 711 Credit : 9 || TQT : 90 LEARNING OUTCOME 1. Understand entrepreneurship in strategic contexts. 2. Understand the principles of entrepreneurial practice. UNIT12- Strategic Management Project Reference No : CMI 712 Credit : 10 || TQT : 100 LEARNING OUTCOME 1. Know how to develop a strategic management project. 2. Know how to conduct a strategic management project. UNIT13- Applied Research for Strategic Leaders Reference No : CMI 713 Credit : 7 || TQT : 70 LEARNING OUTCOME 1. Understand the research process 2. Know how to develop a research proposal of strategic benefit. UNIT14- Personal and Professional Development for Strategic Leaders Reference No : CMI 714 Credit : 9 || TQT : 90 LEARNING OUTCOME 1. Understand approaches for personal and professional development. 2. Know how to develop as a strategic leader through personal and professional development. UNIT15- Strategic Approaches to Equality, Diversity and Inclusion Reference No : CMI 715 Credit : 8 || TQT : 80 LEARNING OUTCOME 1. Understand equality, diversity and inclusion at a strategic level. 2. Know how to develop strategic priorities for equality, diversity and inclusion. UNIT16- Strategic Approaches to Mental Health and Wellbeing Reference No : CMI 716 Credit : 7 || TQT : 70 LEARNING OUTCOME 1. Understand the impact of managing mental health and wellbeing on organisational performance. 2. Know how to develop a culture of mental health and wellbeing. UNIT17- Strategic Corporate Social Responsibility and Sustainability Reference No : CMI 608 Credit : 6 || TQT : 60 LEARNING OUTCOME 1. Understand corporate social responsibility and sustainability in organisational contexts. 2. Know how corporate social responsibility and sustainability is applied in an organisational setting. UNIT18- Leading Quality Management Reference No : CMI 609 Credit : 7 || TQT : 70 LEARNING OUTCOME 1. Understand the factors which influence organisational approaches to quality management. 2. Know how to lead quality management to achieve strategic objectives. UNIT19- Principles and Practices of Policy Development Reference No : CMI 610 Credit : 6 || TQT : 60 LEARNING OUTCOME 1. Understand the context in which a policy is developed. 2. Know how to develop, implement and evaluate policy. UNIT20- Coaching Skills for Leaders Reference No : CMI 612 Credit : 7 || TQT : 70 LEARNING OUTCOME 1. Understand the benefits, types and application of coaching used by leaders. 2. Know the skills, techniques and approaches required by leaders to coach. UNIT21- Principles and Practices of Ethical Decision Making Reference No : CMI 614 Credit : 6 || TQT : 60 LEARNING OUTCOME 1. Understand ethical decision making within organisational contexts. 2. Know how to make an ethical decision. Delivery Methods School of Business & Technology London provides various flexible delivery methods to its learners, including online learning and blended learning. Thus, learners can choose the mode of study as per their choice and convenience. The program is self-paced and accomplished through our cutting-edge Learning Management System. Learners can interact with tutors by messaging through the SBTL Support Desk Portal System to discuss the course materials, get guidance and assistance and request assessment feedbacks on assignments. We at SBTL offer outstanding support and infrastructure for both online and blended learning. We indeed pursue an innovative learning approach where traditional regular classroom-based learning is replaced by web-based learning and incredibly high support level. Learners enrolled at SBTL are allocated a dedicated tutor, whether online or blended learning, who provide learners with comprehensive guidance and support from start to finish. The significant difference between blended learning and online learning methods at SBTL is the Block Delivery of Online Live Sessions. Learners enrolled at SBTL on blended learning are offered a block delivery of online live sessions, which can be booked in advance on their convenience at additional cost. These live sessions are relevant to the learners' program of study and aim to enhance the student's comprehension of research, methodology and other essential study skills. We try to make these live sessions as communicating as possible by providing interactive activities and presentations. Resources and Support School of Business & Technology London is dedicated to offering excellent support on every step of your learning journey. School of Business & Technology London occupies a centralised tutor support desk portal. Our support team liaises with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receives a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and streamline all the support processes efficiently. Quality learning materials made by industry experts is a significant competitive edge of the School of Business & Technology London. Quality learning materials comprised of structured lecture notes, study guides, practical applications which includes real-world examples, and case studies that will enable you to apply your knowledge. Learning materials are provided in one of the three formats, such as PDF, PowerPoint, or Interactive Text Content on the learning portal. Management Direct As part of the program, you will get access to CMI Management Direct, which provides a rich foundation of management and resource for students. The Management Direct is packed with content, including: E-Books Articles Leader videos Idea for leaders Models and so much more... How does the Online Learning work at SBTL? We at SBTL follow a unique approach which differentiates us from other institutions. Indeed, we have taken distance education to a new phase where the support level is incredibly high.Now a days, convenience, flexibility and user-friendliness outweigh demands. Today, the transition from traditional classroom-based learning to online platforms is a significant result of these specifications. In this context, a crucial role played by online learning by leveraging the opportunities for convenience and easier access. It benefits the people who want to enhance their career, life and education in parallel streams. SBTL's simplified online learning facilitates an individual to progress towards the accomplishment of higher career growth without stress and dilemmas. How will you study online? With the School of Business & Technology London, you can study wherever you are. You finish your program with the utmost flexibility. You will be provided with comprehensive tutor support online through SBTL Support Desk portal. How will I get tutor support online? School of Business & Technology London occupies a centralised tutor support desk portal, through which our support team liaise with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receive a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and to streamline all the support process efficiently. Learners should expect to receive a response on queries like guidance and assistance within 1 - 2 working days. However, if the support request is for assessment feedback, learners will receive the reply with feedback as per the time frame outlined in the Assessment Feedback Policy.

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 After completing this course, students will be able to: - 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 course is about writing TSQL queries for the purpose of database reporting, analysis, and business intelligence. 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 Lab 1: Introduction to TSQL for Business Intelligence 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 Lab 1: Write queries 3 - COMBINING COLUMNS FROM MULTIPLE TABLES INTO A SINGLE DATASET: THE JOIN OPERATORS Primary Keys, Foreign Keys, and Joins Understanding Joins, Part 1: CROSS JOIN and the Full Cartesian Product Understanding Joins, Part 2: The INNER JOIN Understanding Joins, Part 3: The OUTER JOINS Understanding Joins, Part 4: Joining more than two tables Understanding Joins, Part 5: Combining INNER and OUTER JOINs Combining JOIN Operations with WHERE and ORDER BY Lab 1: Write SELECT queries 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 Lab 1: Write queries 5 - SUBQUERIES, DERIVED TABLES AND COMMON TABLE EXPRESSIONS Non-correlated and correlated subqueries Derived tables Common table expressions Lab 1: Write queries 6 - ENCAPSULATING DATA RETRIEVAL LOGIC Views Table-valued functions Stored procedures Creating objects for read-access users Creating database accounts for analytical client tools Lab 1: Encapsulating Data Retrieval Logic 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 Lab 1: Getting Your Dataset to the Client Additional course details: Nexus Humans 55232 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 55232 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.

Master the essentials of workplace confidentiality with our comprehensive training course. Learn about business etiquettes, UK legislation, and international standards to safeguard sensitive information. Ideal for professionals committed to maintaining a trusted and secure work environment.