4162 Technology courses in Bradford delivered Online

Oracle SQL Advanced training course description The Oracle SQL Advanced course is designed to give delegates practical experience in using some of the more advanced features of Oracle SQL. Additional datatypes and the use of advanced SQL functions and expressions are covered together with enhanced table handling features. What will you learn Retrieve data using correlated subqueries, in-line views and multi-column subqueries. Use the WITH Clause. Inserting and Updating Rows Using Complex Subqueries Create Hierarchical Queries. Use ROLLUP, CUBE and GROUPING SETS group by enhancements. Implement the GROUPING and GROUPING_ID functions. Manage large data sets. Insert data conditionally and unconditionally. Merge Rows in a Table. Create TIMESTAMP and INTERVAL Datatypes. Use TIMESTAMP, TIMEZONE and INTERVAL functions and literals. Use regular expressions and implement related functions. Manage objects with the data dictionary. Manage schema objects. Perform flashback operations. Create and using external tables. Control user access to database objects. Oracle SQL Advanced training course details Who will benefit: Anyone who needs to use the more advanced features of SQL to improve their productivity in querying and updating an Oracle database. Prerequisites: Delegates should have attended the Oracle SQL course or have a similar level of experience. Duration 2 days Oracle SQL Advanced training course contents Retrieve data using subqueries ANY, ALL or SOME operators, Correlated subqueries, In-Line views, The Exists operator, The WITH clause, Multi-Column subqueries, Insert and update using a query, Correlated update and delete. Hierarchical queries Hierarchical data, The START WITH and CONNECT BY clauses, The LEVEL pseudo-column, Sequencing the output, Eliminating nodes and branches. Enhanced grouping features Review of basic grouping concepts, The ROLLUP and CUBE extensions, The GROUPING SETS extension, Using the GROUPING and GROUPING_ID functions. Manage large data sets Multi-table Inserts, Conditional and unconditional Inserts, Merging data into a table, Table and view based merge, A sub query based merge. Flashback technology Flashback query, The AS clause, Flashback table, Flashback drop. Date, time and time zone support Date, Timestamp and Interval datatypes, Handling dates and times, Handling intervals, Date, timestamp and interval functions and literals, Related NLS parameters. Regular expression support Regular expression notation, Character matching, Repetition operators, Sub expression grouping, Regular expression functions. Manage objects with the Data Dictionary The Data Dictionary, Useful Data Dictionary tables, Using the Data Dictionary. Manage schema objects Column operations, Constraint operations, Creating and dropping Indexes, B-Tree indexes, Function based indexes, Descending indexes, Creating and using external tables. Access control System privileges and roles, Create users, Alter user details, Grant and revoke object privileges.

Getting Started The ILM Level 3 Leadership and Management course is perfect for individuals who have management responsibilities but lack formal training and are committed to enhancing their skills. The course is especially beneficial for team leaders looking to advance to the next management level and managers who must guide their teams through organisational changes, budget reductions, or other challenging situations. Through this ILM Level 3 Leadership and Management course, you will develop leadership skills, improve decision-making capabilities, hone management techniques, enhance team performance, and gain a deeper understanding of organisational behaviour. The course will also provide opportunities for practical application of skills in real-world scenarios and open doors to further career advancement. You will have the flexibility to tailor your learning experience to align with your career aspirations and professional development goals through an extensive selection of units. Key Benefits For Learners Acquire a range of management skills and apply them in your current role Strengthen your leadership capabilities to inspire and empower teams, and skilfully navigate relationships Elevate your leadership and management proficiency by leveraging your personal knowledge, values, and driving force For Organisations Effective and confident First line managers Better relationships and healthy communication within teams Proven skills: Managers will demonstrate the ability to apply their new skills to drive success in your organisation Equip your managers with the tools to continuously develop their own skills and abilities Career Pathways The ILM Level 3 Leadership and Management can open many career pathways including, but not limited to: Team Leader, with an estimated average salary of £30,051 per annum Supervisor, with an estimated average salary of £33,000 per annum Shift Manager, with an estimated average salary of £35,216 per annum Project Officer, with an estimated average salary of £36,451 per annum About Awarding Body Institute of Leadership & Management (ILM) is a professional body that helps people worldwide improve their leadership capabilities and advance their careers. All ILM qualifications are awarded by The City and Guilds of London Institute, founded in 1878 and incorporated into the Royal Charter. ILM qualifications are regulated and approved by Ofqual, the governing body for qualifications in the UK. 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 ILM-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 ILM Membership - You will receive 12 months of the Institute of Leadership & Management membership, bringing access to a wealth of resources to support your leadership development. ILM Digital credentials - Validate your skills and share achievements anywhere, anytime using Digital Credentials Assessment For each module you study, you will complete a written assignment of 2000 to 2500 words and submit it online at your MyLearnDirect learning portal. The submitted assignments will be assessed by your ILM-approved tutor. Entry Requirements ILM Level 3 Leadership and Management is designed for new aspiring team leaders, which gives an in-depth introduction to the role and responsibilities of a team leader. To be eligible for this course, you must: Be 18 years of age and over Have considerable work experience as a team leader or supervisor or a similar role Possess the ability to complete the Level 3 course Our friendly admissions advisors will provide the best advice, considering your needs and goals.  Progression Successful learners may progress to a range of qualifications including the following: ILM Level 3 Diploma in Facilities Management ILM Level 4 Award, Certificate or Diploma in Leadership and Management Why gain a ILM Qualification? The Level 3 Certificate in Leadership and Management is ideal for individuals with management responsibilities who need formal training and are serious about developing their abilities. The course is made up of a wide range of units covering core management skills - such as understanding how to organise and delegate - plus skills in communication, team leadership, change, innovation and managing people and relationships. This flexibility in unit choice allows the coourse to be tailored to meet the needs of the individual and employer. Successful completion of the course could lead you to progression to a range of qualifications including: ILM Level 3 Diploma in Leadership and Management ILM Level 3 Certificate in Coaching and Mentoring ILM Level 4 Award, Certificate or Diploma in Leadership and Management ILM graduates achieve remarkable things: An impressive 70,000 people take ILM qualifications every year, with 93% of employers agreeing that their managers improved after completion. ILM Membership - All ILM learners receive a minimum of 12 months membership of the Institute of Leadership & Management, bringing access to a wealth of resources to support their leadership development ILM Digital credentials - Validate skills and share achievements anywhere, anytime using Digital Credentials 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 Risk in the Workplace Reference No : 8600-403 Credit : 3 || TQT : 30 UNIT2- Developing People in the Workplace Reference No : 8600-405 Credit : 5 || TQT : 50 UNIT3- Understand How to Lead Effective Meetings Reference No : 8600-328 Credit : 2 || TQT : 20 UNIT4- Leading and Motivating a Team Effectively Reference No : 8600-341 Credit : 2 || TQT : 20 UNIT5- Developing Own Leadership Capability Using Action Learning (Diploma only) Reference No : 8600-342 Credit : 10 || TQT : 100 UNIT6- Understanding Change in the Workplace Reference No : 8600-209 Credit : 2 || TQT : 20 UNIT7- Developing Yourself as an Effective Team Member Reference No : 8600-230 Credit : 3 || TQT : 30 UNIT8- Managing Equality and Diversity in Own Area Reference No : 8600-402 Credit : 4 || TQT : 40 UNIT9- Understanding Innovation and Change in an Organisation Reference No : 8600-301 Credit : 2 || TQT : 20 UNIT10- Planning Change in the Workplace Reference No : 8600-302 Credit : 2 || TQT : 20 UNIT11- Giving Briefings and Making Presentations Reference No : 8600-307 Credit : 2 || TQT : 20 UNIT12- Understanding Performance Management Reference No : 8600-323 Credit : 2 || TQT : 20 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. 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.

The Professional Certificate Course in Understanding Sales Promotion and Management is designed to provide a thorough understanding of sales management and its importance. The course covers the sales management process, effective sales promotion techniques for hotels, analyzing hotel sales and methods to improve sales. Participants will learn about the role of a manager in the hotel industry and the use of information technology in boosting a hotel's sales. Upon completion of the course, participants will have the knowledge and skills to implement effective sales promotion strategies, manage sales teams, and use technology to enhance hotel sales. The Professional Certificate Course in Understanding Sales Promotion and Management is a comprehensive program that covers topics such as sales management process, effective sales promotion techniques for hotels, and the role of a manager in the hotel industry. Participants will learn how to analyze hotel sales and use information technology to boost sales.After the successful completion of the course, you will be able to learn about the following, What is sales management? Importance of sales management. Sales management process. Effective Sales Promotion Techniques for Hotels. Analysing Hotel Sales and methods to improve sales. Role of Manager in Hotel Industry. Use of Information Technology in boosting Hotel's Sales. The Professional Certificate Course in Understanding Sales Promotion and Management is designed to provide a thorough understanding of sales management and its importance. The course covers the sales management process, effective sales promotion techniques for hotels, analyzing hotel sales and methods to improve sales. Participants will learn about the role of a manager in the hotel industry and the use of information technology in boosting a hotel's sales. Upon completion of the course, participants will have the knowledge and skills to implement effective sales promotion strategies, manage sales teams, and use technology to enhance hotel sales. VIDEO - Course Structure and Assessment Guidelines Watch this video to gain further insight. Navigating the MSBM Study Portal Watch this video to gain further insight. Interacting with Lectures/Learning Components Watch this video to gain further insight. Understanding Sales Promotion and Management Self-paced pre-recorded learning content on this topic. Professional Certificate Course in Understanding Sales Promotion and Management Put your knowledge to the test with this quiz. Read each question carefully and choose the response that you feel is correct. All MSBM courses are accredited by the relevant partners and awarding bodies. Please refer to MSBM accreditation in about us for more details. There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course. The certificate is designed to enhance the learner's knowledge in the field. This certificate is for everyone eager to know more and get updated on current ideas in their respective field. We recommend this certificate for the following audience. Business owners and entrepreneurs Sales and marketing professionals Anyone interested in developing sales promotion and management skills Average Completion Time 2 Weeks Accreditation 3 CPD Hours Level Advanced Start Time Anytime 100% Online Study online with ease. Unlimited Access 24/7 unlimited access with pre-recorded lectures. Low Fees Our fees are low and easy to pay online.

2 QLS Endorsed Course | CPD Certified | Free PDF + Hardcopy Certificates | 80 CPD Points | Lifetime Access

Leading Cross-Cultural Virtual Teams: In-House Training High-performing teams are a must in this world of intense competition and higher expectations. Global virtual teaming has become a necessity as organizations become increasingly distributed and suppliers and clients actively engage in joint projects. Teams work across geographical and organizational boundaries to deliver solutions and services to global users where distance and differences, both geographic and cultural, amplify the effect of issues and factors that are relatively straightforward when managing a team of people in the same location. This course delivers practical concepts and techniques that participants will start using immediately on their global projects. What you will Learn At the end of this program, you will be able to: Define relationships among foundational concepts (leadership and three dimensions of diversity) and explain their potential impacts on project performance Describe key components of successful project leadership and build selected Transformational Leadership skills Prepare to convert project challenges stemming from personal or cultural diversity into potential competitive advantage Implement selected best practices to meet key challenges facing virtual project teams Foster and grow an environment that supports continued success for CCVTs Foundation Concepts Basic definitions Critical success factors for leading cross-cultural virtual teams (CCVTs) A roadmap to success for leading CCVTs Leadership Excellence in Any Project Environment Leading effectively in a global environment Transformational leadership The four components of Transformational Leadership Leveraging Personal Diversity Overview of personal diversity Mind styles The theory of multiple intelligences Connecting Transformational Leadership and personal diversity Embracing Cultural Diversity Introduction to cultural intelligence The impact of culture Cultural Dimensions Theory The Culture Map Managing Virtual Diversity Overview of virtual diversity Virtual time management Virtual processes and technology Virtual leadership Creating an Environment for Success Supporting a cross-cultural virtual-team (CCVT-) friendly environment Building a foundation of trust Developing a team charter Recap and review Summary and Next Steps Personal action plan

Description Drama And Theatre Studies Diploma For individuals with a deep-rooted passion for the world of theatre and an eagerness to study its multifaceted dimensions, the Drama And Theatre Studies Diploma offers a comprehensive journey into the heart of drama and theatre arts. Delivered through a dynamic online platform, this course has been meticulously crafted to ensure learners get the most immersive experience possible, right from the comfort of their homes. From understanding the essence of drama and theatre to exploring the iconic stages of classical theatres that span from Greece to the Renaissance, the course covers it all. Students embark on a voyage through time, tracing the evolution of theatre, studying various movements that have shaped modern theatre, and immersing themselves in the tales of notable playwrights whose works have left an indelible mark on the world of theatre. The Drama And Theatre Studies Diploma is not just about understanding the history and the classics; it is equally about the art that breathes life into scripts - the art of acting. As part of this diploma, students gain insight into what it takes to embody a character, the nuances of emotion, and the techniques that distinguish good acting from great acting. Behind every successful play or drama, there is a visionary, and in theatre, that visionary is often the director. This course provides a detailed look into the intricate world of directing and production, throwing light on how ideas are birthed, nurtured, and then brought to life on stage. In a world that is constantly evolving, so is theatre. It reflects societal changes, challenges norms, and often serves as a mirror to society. The Drama And Theatre Studies Diploma provides a keen understanding of how drama has been used as a powerful tool for social commentary, influencing change and challenging the status quo. But theatre is not confined to a particular region or culture. It is a global phenomenon. With this course, learners will journey across continents, exploring global theatre traditions, understanding how diverse cultures interpret and represent drama, and how regional nuances can give a completely different dimension to a play or performance. In the contemporary era, technology plays an undeniable role in enhancing the theatre experience. From lighting to sound to visual effects, the integration of technology has transformed the way audiences experience theatre. This diploma sheds light on this symbiotic relationship, elaborating on how technology and theatre have come together to create magic on stage. Lastly, any art form is incomplete without criticism. It is what shapes, refines, and sometimes even redefines art. The Drama And Theatre Studies Diploma introduces learners to the world of theatre criticism and reception. Here, they will understand the importance of critical reception, how critiques can influence a play's success, and the role they play in the continuous evolution of theatre. In summary, the Drama And Theatre Studies Diploma is not just a course; it's an expedition into the mesmerising world of theatre. It's designed for both beginners and seasoned theatre enthusiasts, providing a comprehensive, online, and engaging look into every aspect of drama and theatre studies. For those keen on delving deep into this art form, the journey begins here. What you will learn 1:The Essence of Drama and Theatre 2:Classical Theatres: Greece to Renaissance 3:Modern Theatre Movements 4:Notable Playwrights and Their Impact 5:The Art of Acting 6:Directing and Production 7:Drama as Social Commentary 8:Global Theatre Traditions 9:Theatre and Technology 10:Theatre Criticism and Reception Course Outcomes After completing the course, you will receive a diploma certificate and an academic transcript from Elearn college. Assessment Each unit concludes with a multiple-choice examination. This exercise will help you recall the major aspects covered in the unit and help you ensure that you have not missed anything important in the unit. The results are readily available, which will help you see your mistakes and look at the topic once again. If the result is satisfactory, it is a green light for you to proceed to the next chapter. Accreditation Elearn College is a registered Ed-tech company under the UK Register of Learning( Ref No:10062668). After completing a course, you will be able to download the certificate and the transcript of the course from the website. For the learners who require a hard copy of the certificate and transcript, we will post it for them for an additional charge.

Become an expert in the art of nail technology with our Nail Technician Course. Learn about manicures, pedicures, acrylics, safety, and business strategies. Begin now!

LAN training course description A concise overview course covering Local Area Networks with particular emphasis on the use of Ethernet and Wireless LANS. As well as explaining buzzwords we cover how the technology works at a simple level. After defining LANs the course moves onto Ethernet and switching also covering VLANs. WiFi is then covered, with coverage of 802.11 standards and frequencies along with integrating WiFi with Ethernet. The course then covers routers and their role in connecting networks and the course finishes with a comparison of Ethernet vs WiFi and when to use them. What will you learn Describe how Ethernet works (in simple terms) and when to use Ethernet. Explain the difference between a switch and a router. Describe how WiFi works (in simple terms). Describe the role of Access points. Evaluate wireless technologies and when to use them. List the speeds of various LAN technologies. LAN training course details Who will benefit: Sales staff, managers and other non technical staff. Prerequisites: None. Duration 1 day LAN training course contents LANS What is a LAN? LAN standards, LAN choices, choosing the media, copper, UTP, cat5e, fibre, RF, bandwidth speeds, link aggregation, Full/half duplex. Ethernet What is Ethernet? 802.3, parts of Ethernet, Ethernet evolution, MAC addresses, frames, broadcasts. Ethernet switches What are switches, switches versus hubs, how switches work, ways to configure switches, Loops, STP. VLANs What are VLANs? Why have VLANs, impact of VLANs, Tagging (aka trunking), 802.1Q Wireless LANS Type of wireless LAN, RF frequencies, 2.4GHz, 5GHz, others, interference, standards, 802.11 and variants, CSMA/CA. Wireless LANS NICs, Access points, integration with Ethernet, multiple access points, mesh networks, WiFi security. Interconnecting LANs Routers, connecting networks, interconnecting VLANs, IP addressing, Layer 3 switches. Summary WiFi vs Ethernet.

Explore capture-the-flag exercises that will strengthen your ethical hacking skills

Get hands-on with advanced Microsoft Windows Server 2019 administration