17037 Other courses in Lewes delivered 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 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.

Data dashboards provide key information to stakeholders so that they can make informed decisions. While there are plenty of software solutions for building these essential data products, there is much less guidance on how to design dashboards to meet the diverse needs of users.  This course is for anyone who is building or implementing dashboards, and wants to know more about design principles and best practice. You could be using business intelligence software (such as Power BI or Tableau), or implementing bespoke solutions.  The course will give your team the ability to evaluate user needs and levels of understanding, make informed decisions about chart selections, and make effective use of interactivity dynamic data.  We’ll work with you before the course to ensure that we understand your organisation and what you’re hoping to achieve.  Sample learning content  Session 1: Data with a purpose Understanding the different types of dashboard. Information overload and other common dashboard pitfalls. Assessing user needs and levels of data fluency. Session 2: Planning a dashboard Assessing diverse user needs and levels of data fluency. Taking a User Experience (UX) approach to design and navigation. Applying an interative and collaborative approach to onboarding. Session 3: Graphs, charts and dials  Understanding how graphical perception informs chart choices. Making intelligent design choices to help users explore. Design principles for layout and navigation. Session 4: Using interactivity  Making effective use of filters to slice and dice data sets. Using layers of information to enable drilldown data exploration. Complenting dashboards with automated alerts and queries. Delivery We deliver our courses over Zoom, to maximise flexibility. The training can be delivered in a single day, or across multiple sessions. All of our courses are live and interactive – every session includes a mix of formal tuition and hands-on exercises. To ensure this is possible, the number of attendees is capped at 16 people.  Tutor Alan Rutter is the founder of Fire Plus Algebra. He is a specialist in communicating complex subjects through data visualisation, writing and design. He teaches for General Assembly and runs in-house training for public sector clients including the Home Office, the Department of Transport, the Biotechnology and Biological Sciences Research Council, the Health Foundation, and numerous local government and emergency services teams. He previously worked with Guardian Masterclasses on curating and delivering new course strands, including developing and teaching their B2B data visualisation courses. He oversaw the iPad edition launches of Wired, GQ, Vanity Fair and Vogue in the UK, and has worked with Condé Nast International as product owner on a bespoke digital asset management system for their 11 global markets. Testimonial “Alan was great to work with, he took us through the concepts behind data visualisation which means our team is now equipped for the future. He has a wide range of experience across the topic that is delivered in a clear, concise and friendly manner. We look forward to working with Alan again in the future.” John Masterson | Chief Product Officer | ImproveWell

Certified Associate in Project Management (CAPM)® Exam Prep: In-House Training: In-House Training This course gives you the knowledge you need to pass the exam and covers CAPM®-critical information on project management theory, principles, techniques, and methods Are you planning on taking the CAPM® examination? This course gives you the knowledge you need to pass the exam and covers CAPM®-critical information on project management theory, principles, techniques, and methods. You'll also have an opportunity for practical applications and time to review the kinds of questions you'll find in the CAPM® Exam. What you Will Learn Apply for the CAPM® Examination Develop a personal exam preparation plan Describe the structure, intent, and framework principles of the current edition of the PMBOK® Guide Explain the PMBOK® Guide Knowledge Areas, as well as their inter-relationships with the each other and the Process Groups Getting Started Program orientation The CAPM® certification process Certified Associate in Project Management (CAPM®) Examination Content Outline CAPM® eligibility requirements Code of Ethics and Professional Conduct Application options Foundation Concepts Skills and qualities of a project manager Project management terminology and definitions Relationship of project, program, portfolio, and operations management Project lifecycle approaches Project Integration Management Review Project Integration Management Knowledge Area Develop Project Charter Develop Project Management Plan Direct and Manage Project Work Manage Project Knowledge Monitoring and Controlling Perform Integrated Change Control Close Project or Phase Project Stakeholder Management Review Project Stakeholder Management Knowledge Area Identify Stakeholders Plan Stakeholder Engagement Manage Stakeholder Engagement Monitor Stakeholder Engagement Project Scope Management Review Project Scope Management Knowledge Area Plan Scope Management Collect Requirements Define Scope Create WBS Validate Scope Control Scope Project Schedule Management Review Project Schedule Management Knowledge Area Plan Schedule Management Define Activities Sequence Activities Estimate Activity Durations Develop Schedule Control Schedule Project Cost Management Review Project Cost Management Knowledge Area Plan Cost Management Estimate Costs Determine Budget Control Schedule Project Resource Management Review Project Resource Management Knowledge Area Plan Resource Management Estimate Activity Resources Acquire Resources Develop Team Manage Team Control Resources Project Quality Management Review Project Quality Management Knowledge Area Plan Quality Management Manage Quality Control Quality Project Risk Management Review Project Risk Management Knowledge Area Plan Risk Management Identify Risks Perform Qualitative Risk Analysis Perform Quantitative Risk Analysis Plan Risk Responses Implement Risk Responses Monitor Risks Project Communications Management Review Project Communications Management Knowledge Area Plan Communications Management Manage Communications Monitor Communications Project Procurement Management Review Project Procurement Management Knowledge Area Plan Procurement Management Conduct Procurements Control Procurements Summary and Next Steps Program Review Mock CAPM® Exam Getting Prepared for the CAPM® Exam After the CAPM® Exam

Getting Started The CMI Level 5 Extended Diploma in Management and Leadership course is designed for practising or aspiring middle managers and leaders at operations, division, departmental or specialist level, who are typically accountable to a senior manager or business owner. Leading and managing individuals and teams to deliver in line with the organisational strategy is the primary role of a practising manager. You'll develop the core strategic skills and competencies required to manage teams and individuals effectively, enabling you to deliver long-lasting results. The CMI Level 5 Extended Diploma in Management and Leadership is an extensive course focusing on improving your capabilities and core management skills such as planning, problem-solving, leadership, strategy, communication, conflict, resource management and organisation. Achieving the CMI Level 5 Extended Diploma in Management and Leadership qualification will enhance your credibility and enable you to outperform in demanding roles and situations. 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 For Learners: Improve your capabilities and core management skills Develop the knowledge and skills required for managing and leading individuals and teams Provide an extensive knowledge of skills to excel in specific management areas For Organisations: Deliver aims and objectives in line with wider organisational strategy Provide you with a fully wider range of skills and knowledge required to be a manager as part of an organisation Focus on the areas that are most appropriate to your role and organisation. Key Highlights Are you an aspiring Manager or Leader looking for career development? Then, the CMI Level 5 in Management and Leadership qualification offered by the School of Business and Technology London is the right solution for you. 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 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 5 Management & Leadership can open many career pathways including, but not limited to: Operations Manager, with an estimated salary of £51,577 per annum Divisional Manager, with an estimated salary of £48,613 per annum Departmental Manager, with an estimated salary of £34,997 per annum Regional Manager, with an estimated salary of £51,372 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 18 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 3000 to 4,000 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 current or aspiring mid-level managers. You don't need any formal qualifications to study this course. However, to be eligible for this course, you must:  Be 19 years of age and over Have some team leading or supervisory experience or managerial experience in the junior or middle management level Possess the ability to complete the Level 5 course Our friendly admissions advisors will provide the best advice, considering your needs and goals.  Progression A possible progression route on successful completion of a CMI Level 5 in Management and Leadership would be to, Progress to other qualifications at the next level (e.g. from Level 5 Certificate to level 6 or 7 Certificate) Progression to Bachelor Degree Top Up in Business Management. Why gain a CMI Qualification? This online CMI Level 5 Extended Diploma in Management and Leadership course is perfect if you are a current or aspiring mid-level manager looking to advance in your career. The globally recognised CMI Level 5 Extended Diploma is perfect for you if you want to increase your opportunities for obtaining a middle management position. The substantial leadership skills and knowledge you'll develop with this course will be remarkably effective. You can fast-track to apply for Chartered Manager status, the ultimate professional accolade for managers, after completing the CMI Level 5 Diploma or Extended Diploma in Management and Leadership course and with 3+ years of experience in a managerial role. You may also wish to further your ongoing personal and professional development by accessing other CMI courses, such as the CMI Level 6 or Level 7 courses in Management and Leadership. Studying for a CMI qualification offers you more than just academic standing. When you enrol with us for the CMI Level 5 Extended Diploma in Management and Leadership, you will have access to CMI Membership and Support for the duration of your study alongside your qualification. 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 complete a combination to a minimum of 540 TUT hours, 54 credits to achieve this qualification. There is a barred combination of units - learners taking 502 cannot select 503, 505 or 511 and learners taking 526 cannot select 501 or 502. 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- Managing Performance Reference No : CMI 504 Credit : 5 || TQT : 50 LEARNING OUTCOME 1. Understand the rationale for managing performance within organisations. 2. Know how to manage performance. 3. Understand frameworks, diagnostic and evaluation tools used for performance management. UNIT2- Principles of Developing, Managing and Leading Individuals and Teams to Achieve Success Reference No : CMI 502 Credit : 6 || TQT : 60 LEARNING OUTCOME 1. Understand approaches to developing, managing and leading teams 2. Understand approaches to achieving a balance of skills and experience in teams. 3. Know techniques for leading individuals and teams to achieve success. UNIT3- Principles of Management and Leadership in an Organisational Context Reference No : CMI 501 Credit : 7 || TQT : 70 LEARNING OUTCOME 1. Understand factors which impact on an organisation's internal environment. 2. Understand the application of management and leadership theories. 3. Understand the knowledge, skills and behaviours to be effective in a management and leadership role. UNIT4- Principles of Delivering Coaching and Mentoring Reference No : CMI 507 Credit : 5 || TQT : 50 LEARNING OUTCOME 1. Understand the role and purpose of coaching and mentoring within an organisation. 2. Understand the use of models and processes used in workplace coaching and mentoring. 3. Know how to manage the delivery of effective coaching and mentoring. UNIT5- Managing Stakeholder Relationships Reference No : CMI 509 Credit : 4 || TQT : 40 LEARNING OUTCOME 1. Understand the different types and value of stakeholder relationships. 2. Understand the frameworks for stakeholder management. 3. Know how to manage stakeholder relationships. UNIT6- Managing Conflict Reference No : CMI 510 Credit : 5 || TQT : 50 LEARNING OUTCOME 1. Understand the types, causes, stages and impact of conflict within organisations. 2. Understand how to investigate conflict situations in the workplace. 3. Understand approaches, techniques, knowledge, skills and behaviours for managing conflict. UNIT7- Planning, Procuring and Managing Resources Reference No : CMI 516 Credit : 6 || TQT : 60 LEARNING OUTCOME 1. Understand the importance of effective and efficient resource use in organisations. 2. Know how to plan resources to meet organisational objectives. 3. Know how to procure resources. UNIT8- Principles of Innovation Reference No : CMI 517 Credit : 5 || TQT : 50 LEARNING OUTCOME 1. Understand the role of innovation within organisations. 2. Understand the process of managing innovation in an organisation. UNIT9- Principles of Marketing Products and Services Reference No : CMI 523 Credit : 6 || TQT : 60 LEARNING OUTCOME 1. Understand the role of marketing to support the achievement of organisational objectives. 2. Understand the factors in the organisation's marketing environment which impact on the marketing of a product or service. 3. Know how to market a product or service. UNIT10- Conducting a Management Project Reference No : CMI 524 Credit : 10 || TQT : 100 LEARNING OUTCOME 1. Know how to plan a management project. 2. Be able to conduct a management project. UNIT11- Managing Finance Reference No : CMI 520 Credit : 6 || TQT : 60 LEARNING OUTCOME 1. Understand finance within organisations. 2. Know how to set and manage budgets. UNIT12- Using Data and Information for Decision Making Reference No : CMI 521 Credit : 5 || TQT : 50 LEARNING OUTCOME 1. Understand the use of data and information in decision making. 2. Be able to interpret data and information to support decision making. 3. Know how to present data and information used for decision making. UNIT13- Managing Change Reference No : CMI 514 Credit : 5 || TQT : 50 LEARNING OUTCOME 1. Understand the reasons for change in organisations. 2. Understand approaches to change management. 3. Understand how to initiate, plan and manage change in an organisation. UNIT14- Creating and Delivering Operational Plans Reference No : CMI 515 Credit : 6 || TQT : 60 LEARNING OUTCOME 1. Understand the principles of operational planning in an organisation. 2. Know how to create an operational plan in line with organisational objectives. 3. Know how to manage and lead the delivery of an operational plan. UNIT15- Principles of Managing and Leading Individuals and Teams to Achieve Reference No : CMI 503 Credit : 5 || TQT : 50 LEARNING OUTCOME 1. Understand approaches to managing and leading teams. 2. Know how to achieve a balance of skills and experience in teams. 3. Know techniques for managing and leading individuals and teams to achieve success. UNIT16- Forming Successful Teams Reference No : CMI 505 Credit : 4 || TQT : 40 LEARNING OUTCOME 1. Understand the purpose and characteristics of successful teams. 2. Understand approaches to team formation. 3. Know how to analyse and respond to the challenges of team formation. UNIT17- Managing Equality, Diversity and Inclusion Reference No : CMI 506 Credit : 5 || TQT : 50 LEARNING OUTCOME 1. Understand legal and organisational approaches to equality, diversity and inclusion. 2. Understand the role and responsibilities of a manager in relation to equality, diversity and inclusion. 3. Know how to develop and implement plans which support equality, diversity and inclusion within an organisation. UNIT18- Principles of Developing a Skilled and Talented Workforce Reference No : CMI 508 Credit : 4 || TQT : 40 LEARNING OUTCOME 1. Understand the benefits of developing a skilled and talented workforce. 2. Understand the factors which influence workforce development. 3. Understand the scope of learning and development as part of a workforce development strategy. UNIT19- Principles of Recruiting, Selecting and Retaining Talent Reference No : CMI 511 Credit : 5 || TQT : 50 LEARNING OUTCOME 1. Understand the factors that impact on recruitment and selection. 2. Know how to plan for recruitment and selection. 3. Understand approaches to the recruitment and selection of a diverse and talented workforce. UNIT20- Workforce Planning Reference No : CMI 512 Credit : 4 || TQT : 40 LEARNING OUTCOME 1. Understand the rationale for workforce planning. 2. Understand the principles and practices of workforce planning. UNIT21- Managing Projects to Achieve Results Reference No : CMI 513 Credit : 6 || TQT : 60 LEARNING OUTCOME 1. Understand the role of projects in delivering organisational strategy. 2. Understand processes for initiating, planning and managing projects. 3. Understand the factors which contribute to effective project management. UNIT22- Managing Risk Reference No : CMI 518 Credit : 6 || TQT : 60 LEARNING OUTCOME 1. Understand the scope of business risk management. 2. Understand the process for managing business risk. UNIT23- Managing Quality and Continuous Improvement Reference No : CMI 519 Credit : 6 || TQT : 60 LEARNING OUTCOME 1. Understand the scope and purpose of quality management within organisations. 2. Understand approaches for managing quality. 3. Understand the application of continuous improvement within organisations. UNIT24- Managing the Customer Experience Reference No : CMI 522 Credit : 5 || TQT : 50 LEARNING OUTCOME 1. Understand the principles of managing the customer experience. 2. Understand the customer journey in the context of an organisation. 3. Know how to manage the customer experience. UNIT25- Using Reflective Practice to Inform Personal and Professional Development Reference No : CMI 525 Credit : 5 || TQT : 50 LEARNING OUTCOME 1. Understand the value of reflective practice to inform personal and professional development. 2. Know how to apply reflective practice to inform personal and professional development. UNIT26- Principles of Leadership Practice Reference No : CMI 526 Credit : 8 || TQT : 80 LEARNING OUTCOME 1. Understand leadership practice in an organisation. 2. Understand leadership styles 3. Understand the impact of leadership within organisations. UNIT27- 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. 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.

Diploma in Business Studies - Level 3 (Fast-Track mode) The objective of the Diploma in Business Studies - Level 3 qualification (Accredited by OTHM) is to provide learners with an in depth understanding of the operations and structure of businesses. Successful completion of this qualification will equip learners with the underpinning knowledge and skills required to succeed in employment or further studies. Diploma in Business Studies Key Highlights Program Duration: 6 Months (Regular Mode available) Program Credits: 60 Credits Designed for working Professionals Course Delivery: Online No Written Exam. The Assessment is done via Submission of Assignment Tutor Assist available Dedicated Student Success Manager Timely Doubt Resolution Regular Networking Events with Industry Professionals Direct entry into Year 1 of a three-year UK Bachelor's degree LSBR Alumni Status No Cost EMI Option Understanding of operations and structure of businesses. Underpinning knowledge and skills required to succeed in employment or further studies. Successful completion of the Program enables learners' direct entry into Year 1 of a three-year UK Bachelor's degree or pursue Level 4 Diplomas Mandatory units (Total Credits: 40) The Level 3 Diploma in Business Studies qualification consists of 4 mandatory units plus 2 optional unit for a combined total of 60 credits, 600 Total Qualification Hours (TQT) and 360 Guided Learning Hours (GLH) for the completed qualification. Introduction to Research and Academic Skills (10 credits) Using IT for Business (10 credits) Introduction to Economics and Accounting (10 credits) Introduction to the Business Environment (10 credits) Optional Units (Total Credit: 20) Choose any two of the below Optional Units Introduction to Customer Service (10 credits) Managing Business Events (10 credits) Introduction to Marketing (10 credits) Introduction to People Management (10 credits) Who is this course for? Working Professionals O-Level holders, Sales Marketing Professionals Requirements Open Entry. No formal qualification is required Career path Completion of your Level 3 Diploma in Business Studies qualification will meet the University standard academic entry requirements. However, each applicant will be subject to individual assessment and other entry requirements which may affect university entry.

Vectorworks Evening Course face to face One to one

Person Centred Planning (PCP) is a powerful tool for visioning, future planning and team building. It gets everyone on the same page and creates a progressive, constructive atmosphere so it is especially useful for people who are feeling ‘stuck’ or in a really desperate situation. The PCP processes we teach are called “PATH” and “MAPs”, and are both used for different situations. “To facilitate a group, family, team or organisation in thinking together around a given challenge or issue. Here is an opportunity to experience for real the person centred, futures planning tool – MAP/PATH” (Pearpoint, Forest, O’Brien. 1989). PCP can focus on an individual, with family and friends in the room supporting them, or focus on a group who want to set goals, and realise their potential as a team. PCP focuses on hopes and dreams, so is a very positive approach to planning, and utilises graphic facilitation, making it a very friendly way of working that is accessible to everyone.  This unique, hands on PCP training course explores the difference between ‘person-centred thinking’ and ‘service-centred thinking’. Traditionally, we have not always listened deeply enough to the needs of those we are planning for. Often ‘medical model’ thinking dominates our planning for those with the most complex needs. Typically we plan ‘about’ rather than ‘with’ children and adults.  We examine this ‘service centred’ approach that most professionals are used to, and question its limitations. This values based approach to inclusion will give participants the ‘theory’ behind why thinking and working in a person centred way is so important, and challenges people to strive for more for the people we are planning around. In addition to the knowledge and theory, this course empowers participants to facilitate their own Person Centred Plans using the PATH or MAPs process and provides the skills to do this effectively. Learning objectives  Strengthen understanding of how to think in a person centred way Knowledge of the steps of PATH / MAPs process Ability to facilitate PATH/MAPs process Ability to graphically facilitate a PCP meeting Develop problem solving and planning skills Inclusive Solutions offer: We could provide training for a team of staff, or we could facilitate a PATH or MAP around a disabled person. We can also offer bespoke training packages, please enquire for more details.  1 day “Introduction to PCP” with up to 100 attendees focusing on ‘Person Centred Thinking’ – includes live demonstration of PATH or MAPs Process (for a member of the group / with a student and their family/friends). 2 day “PCP Skills training” – More skills focused, lots of practice. Includes Graphics academy, Process academy and Coaching (Best with under 30 attendees). 2 day “Introduction to PCP with Skills training” – includes live demonstration of PATH or MAPs process, Graphics academy, Process academy and Coaching (Best with under 30 attendees). Half day PATH or MAP for a disabled person, led by two experienced Inclusive Solutions facilitators. Full day PATH or MAP for a team, organisation or group such as a full school staff led by two experienced Inclusive Solutions facilitators. Typical Structure of 2-Day “Introduction to PCP with Skills” Training This course is most useful when delivered over 2 days so we have time to cover the ‘skills’ behind facilitating a PATH or a MAP. Here is an example of what usually happens. If you need us to, we can tailor any of our courses to suit your specific needs.  Day 1 AM What makes a good welcome?Service centred thinking and working – what does it involve, how does it make people feel?Reflections on current practices – what is useful and what is harmful?Introduction to underpinning values of person centred thinking and working In depth exploration of the fundamentals of inclusion – encouraging identity, focusing on gifts and capacities Sharing success stories, and personal insight from experienced psychologistsShowcasing a number of practical PCP process in actionIntroduction to the “5 service accomplishments”, or “5 ordinary needs” PM  Full PATH process demonstration, led by 2 experienced facilitators – one process facilitator and one graphic facilitatorVolunteers will make notes on what they see the facilitators doing and feedback at the end of the dayFeedback, Q&A Day 2 AM Graphics Academy – we will ease you into the world of graphic facilitation and show you how simple it really is – includes live coaching and graphics tutorial, then participants will practice on each other by facilitating the first 1 or 2 sections of the PATH Process Academy – we will give you some pointers about holding the group, and facilitating in an inclusive way, this is another chance to practice your new graphics skills PM The group is divided up, and volunteers are selected to facilitate PATH meetings The group then run the PATH’s simultaneously with an experienced coaches in the room to guide and to be available for questionsWe reconvene to feedback about the process and digest all we have learntBrief Q&A session and then final reflections

The objective of the fast track Level 4 Diploma in Information Technology qualification (accredited by Othm, UK) is to provide learners with an excellent foundation for a career in a range of organisations. It is designed to ensure that each learner is 'business ready': a confident, independent thinker with a detailed knowledge of Information Technology, and equipped with the skills to adapt rapidly to change. This fast track Level 4 Diploma in Information Technology qualification is ideal for those who have started, or are planning to move into, a career in private or public sector business. Successful completion of the Level 4 Diploma in Information Technology in fast track mode will provide learners with the opportunity to progress to further study or employment. Some of the Key Highlights of this fast track Diploma in Information Technology - Level 4 are: Program Duration: 6 Months (Regular duration mode also available) Program Credits: 120 Designed for working Professionals Format: Online No Written Exam. The Assessment is done via Submission of Assignment Tutor Assist available Dedicated Student Success Manager Timely Doubt Resolution Regular Networking Events with Industry Professionals Direct entry into Year 1 of a three-year UK Bachelor's degree LSBR Alumni Status No Cost EMI Option Who is this course for? Working Professionals, A-Level holders, learners who are looking for Career Progression and a formal undergraduate qualification leading to award of degrees in future. Requirements For entry onto the fast track Level 4 Diploma in Information Technology qualification, learners must possess: Relevant NQF/QCF/RQF Level 3 Award/Diploma or at the level of GCE/GCSE or equivalent qualification Learner must be 18 years or older at the beginning of the course OR No formal qualification is required from Mature learners who are over 21 years of age and having management experience Career path Progress to: Year 2 of a Three-year UK Bachelor's degree Completion of your qualification will meet the University standard academic entry requirements. However, each applicant will be subject to individual assessment and other entry requirements which may affect university entry. Certificates Certificate of Achievement Digital certificate - Included Othm courses: Once you complete the course, you would be receiving a digital copy of your Diploma along with its Transcript which can be downloaded from the awarding body website without any additional charge. You can also order Hard copy certificate by paying a nominal cost directly to the awarding body.

Accounting and finance are at the very heart of business operations. From banking to manufacturing, from huge service industries to micro businesses, the ability to manage, plan and account for money is still the ultimate measure of business success and the key driver of growth. The objective of the Level 5 Diploma in Accounting and Business (fast track) qualification accredited by OTHM is to provide learners with the knowledge and skills required by a middle manager in an organisation that may be involved in financial management, financial planning and control, financial reporting, taxation and people management. Key Highlights of fast track Level 5 Diploma in Accounting and Business qualification are: Program Duration: 6 Months (Regular mode also available) Program Credits: 120 Designed for working Professionals Format: Online No Written Exam. The Assessment is done via Submission of Assignment Tutor Assist Available Dedicated Student Success Manager Timely Doubt Resolution Regular Networking Events with Industry Professionals Direct entry into Year 1 of a three-year UK Bachelor's degree LSBR Alumni Status No Cost EMI Option Who is this course for? Working Professionals, A-Level / Level 4 / Year 1 of a three-year UK Bachelor's degree holders or learners who are looking for Career Progression and a formal undergraduate qualification leading to award of degrees in future. Requirements For entry onto the OTHM Level 5 Diploma in Accounting and Business (fast track) qualification, learners must possess: Relevant NQF / QCF / RQF Level 4 diploma or equivalent recognised qualification OR Learner must be 18 years or older at the beginning of the course, OR Mature learners (over 21) with management experience (learners must check with Admission Counsellors at LSBR regarding this experience prior to registering for the programme) Career path After completion of your fast track Course, you can progress to Year 3 of a Three-year UK Bachelor's degree Completion of your fast track Level 5 Diploma in Accounting and Business qualification will meet the University standard academic entry requirements. However, each applicant will be subject to individual assessment and other entry requirements which may affect university entry. Certificates Certificate of Achievement Digital certificate - Included Once you complete the course, you would be receiving a digital copy of your Diploma along with its Transcript which can be downloaded from the awarding body website without any additional charge. You can also order Hard copy certificate by paying a nominal cost directly to the awarding body.

BGP training course description A study of BGP for non engineers working in the Internet. The course starts with a review of the basics of routers and routing tables and then moves on to a simple overview of how BPG works with a focus on BGP metrics influencing the route traffic takes through the Internet. Hands on with routers follow the major sessions to reinforce the theory. Note these hands on sessions are more demonstrations by the trainer but some can be followed along and done by delegates (e.g. looking at Internet routing tables.) What will you learn Explain how routing tables influence Internet traffic. Describe how BGP works. Explain the methods BGP can use to influence Internet traffic. Use traceroute, peeringdb, route collectors and looking glasses to analyse traffic flows. Explain the difference between bi lateral and multilateral peering using a route server. BGP training course details Who will benefit: Non technical staff wishing to know more about BGP. Prerequisites: None. Duration 1 day BGP training course contents Networks, routers and routing tables What is a network, what is a router, routing tables, static routes, routing protocols. When an ISP uses static routes and when they use BGP. IP addresses, subnet masks, groups of IP addresses. IPv6. Hands on: Showing a full routing table. Seeing traceroute being used. Basic BGP What's BGP? BGP versus other routing protocols, ASs, AS numbers. RIPE database, peeringdb. Hands on: Finding AS numbers. Showing simple BGP configuration and routing tables in an EVENG example. How BGP works Simple walk through of BGP incremental updates and how routes change when links go down. Hands on: Showing packets and route changes when a link goes down/comes up. BGP path selection Transit, peering, routing policy and route filtering. Longest matching rule in routing tables, route selection order, Local preference, AS prepend, MEDs. Hands on: Seeing BGP influencing traffic. Looking at peering policies in RIPE and peeringdb. Route servers What are route servers? LINX route servers, route server policy control and communities, What are route collectors, Looking glasses. Hands on: Seeing the LINX route server details in peeringdb, using a looking glass.