- Professional Development
- Medicine & Nursing
- Arts & Crafts
- Health & Wellbeing
- Personal Development
8564 Opera courses
Description Due to technology advancement and the increasing reliance on data, SQL developers are in high demand. Many find this path relatively easy in comparison to other technical careers. If you have completed SQL Developer 2014 beginner course and want to get more in-depth knowledge of SQL Server, then this SQL Developer 2014 Intermediate is just for you. Through this course, you will understand the structured query language (SQL) for manipulating business data in the most effective and sensible approach. Obtain the power of Microsoft SQL Server and grasp how to maximise the performance of any SQL that you draft. Take your knowledge to the next level to fully to perform the essential tasks within your business or employment to improve your prospects to succeed in the long run. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Module: 01 Topic A Aggregates FREE 00:27:00 Topic B User Defined Types 00:17:00 Topic C Table and Functions 00:10:00 Topic D Managing Code Modules 00:08:00 Module: 02 Topic A Introduction Data Tools 00:19:00 Topic B Connected Database Development 00:20:00 Topic C Updating a Connected Database 00:16:00 Module: 03 Topic A Creating New Objects with TSQL 00:12:00 Topic B Comparing Database Schemas 00:10:00 Topic C Offline Database Development 00:13:00 Topic D Database Project Settings 00:18:00 Module: 04 Topic A Using APPLY 00:15:00 Topic B MERGE Statement 00:23:00 Topic C Creating Recursive Queries 00:08:00 Topic D Grouping Sets 00:12:00 Module: 05 Topic A ROLLUP and CUBE Operators 00:12:00 Topic B Creating Pivot Queries 00:14:00 Topic C Executing Dynamic SQL 00:28:00 Module: 06 Topic A Complex Query Execution 00:26:00 Topic B Using Execution Plans 00:16:00 Topic C Execution Plan Operators 00:12:00 Topic D Common Join Operators 00:16:00 Module: 07 Topic A Hierarchy ID Data Type 00:12:00 Topic B Exploring a Hierarchy 00:09:00 Topic C Sparse Columns 00:16:00 Topic D Column Sets 00:12:00 Module: 08 Topic A Filtered Indexes 00:09:00 Topic B FILESTREAM Storage 00:22:00 Topic C Adding Sequences to Queries 00:22:00 Module: 09 Topic A Introduction to Spatial Data 00:13:00 Topic B Spatial Data in SQL Server 00:23:00 Topic C Manipulating Spatial Shapes 00:10:00 Topic D Interactions Between Objects 00:09:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00
[vc_row][vc_column][vc_column_text] Description Are you looking to advance your career prospects in social housing? This Social Housing Management Diploma Course is designed to help you familiarise with the role of a social housing manager, with a full overview of the origins and changes of social housing. This management course is ideal for staff, managers, and volunteers engaged in social housing operations or development, who want to gain practical skills in this field and progress in their career. The course covers all aspects of social housing management, covering topics such as homelessness, resident involvement, and anti-social behaviour. Throughout this course, you will develop essential management skills through a combination of theory and practical application. The interactive approach to learning encourages participants to test new ideas and share experiences and expertise with other housing managers in a supportive learning environment. The essential goal of the course is to help you 'think like a manager' in a social housing context, exploring the practical elements of social housing management. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Social Housing Management Diploma is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Social Housing Management Diploma is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market.[/vc_column_text][/vc_column][/vc_row] Module 1: Introduction to Social Housing Introduction 01:00:00 What is Social Housing 00:05:00 Why We Need More Social Housing 00:15:00 Social Housing Providers 00:30:00 Module 2: The Origins and Changes of Social Housing The Origins of Social Housing, the Purpose and Aims of Social Landlords 00:30:00 Changes and the Impact on Functions of Social Housing 00:05:00 Module 3: Supply and Demand What has Supply and Demand Got to do With Housing? 00:15:00 What is Affordable Housing? 00:05:00 Demand and Need 00:15:00 Acute Housing Need 00:15:00 The Management of Housing Need 00:30:00 Supply Issues 00:15:00 Areas of Oversupply 00:15:00 Module 4: Housing Management Managing Social Housing 00:30:00 Forms of Social Housing Tenancy 00:15:00 Managing the Patch 00:15:00 Special Needs Housing Management 00:30:00 Special Consideration Groups 00:15:00 Unfavourable Medical or Related Condition 00:15:00 Street Sleepers 00:05:00 Other Victims of Societal Prejudice 00:15:00 The Management of Temporary Accommodation 00:05:00 Self-Management 00:15:00 Repairs and Maintenance 00:30:00 Organisational Management Issues 00:30:00 Module 5: Housing Finance Understanding Housing Finance 00:30:00 Housing Balances 00:15:00 Capital Operations in the Social Housing Sector 00:30:00 Housing Association Capital Finance 00:15:00 Revenue Operations in the Social Housing Sector 00:30:00 Scope for HRA Subsidy Reform 00:30:00 Module 6: Housing Development Introduction to Housing Development 00:05:00 The Strategic Planning Process 00:15:00 Planning Policy Implications 01:30:00 The Importance of Sustainability 00:15:00 The Importance of Planning 00:30:00 The Development Process 01:00:00 Mock Exam Mock Exam - Social Housing Management Diploma 00:20:00 Final Exam Final Exam - Social Housing Management Diploma 00:20:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00
Looking to master the art of organising unforgettable events? Our CPD Accredited Event Management and Planning course offers a clear path to understanding the essentials behind every successful gathering. From intimate corporate meetings to grand celebrations, this course walks you through the core concepts of event design, budgeting, supplier coordination, and guest management. You'll discover how to craft memorable experiences that impress clients and guests alike, all while keeping an eye on efficiency and smooth execution. This course is designed with busy professionals in mind, offering flexible learning that fits around your schedule without the need for physical attendance. It’s perfect for those eager to refine their organisational flair and project management know-how, whether you’re aiming to boost your CV or explore a new career direction. Delivered online with engaging content and insightful guidance, it strikes the perfect balance between informative and enjoyable—making event planning approachable, even if you’re not the party type. Course Curriculum: Module 1: Types of Events Module 2: Brainstorming Module 3: Support Staff Module 4: Technical Staff Module 5: Vendors Module 6: Get Organized Module 7: Post Event Activities Module 8: Introduction to Hospitality Management Module 9: An Overview of Hotel Industry Module 10: Management of Front Office Operations Module 11: Management of Food and Beverage Operations Module 12: Customer Satisfaction Module 13: E-Hospitality and Technology Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing an online module. For each test, the pass mark will be set to 60%. Accredited Certificate After successfully completing this Event Management and Planning - CPD Accredited course, you will qualify for the CPD Quality Standards (CPD QS) certified certificate from Training Express. CPD 10 CPD hours / points Accredited by The CPD Quality Standards (CPD QS) Who is this course for? The Event Management and Planning - CPD Accredited training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our Event Management and Planning - CPD Accredited training.
Step into the intriguing realm of private investigation with the Private Detective Advance Diploma, a CPD accredited course designed to elevate your knowledge and confidence. This course delves into advanced investigative techniques, legal frameworks, and ethical considerations, all presented in a clear, structured manner ideal for those keen to sharpen their expertise remotely. Whether you’re aiming to build a career in private detection or simply curious about the craft, this diploma offers a solid foundation without the need for physical attendance. With an emphasis on theory and analysis, this course explores surveillance methods, report writing, and evidence handling, all within legal boundaries. Delivered entirely online, it suits learners who appreciate flexibility alongside expert guidance. Expect engaging content crafted to keep your curiosity alive while sharpening your intellect — with a touch of dry wit to keep things from feeling too much like a detective novel, but without the trench coats or magnifying glasses. A clever way to add serious skills without ever leaving your favourite armchair. Still not convinced? Take a glimpse of the key benefits you'll get with - Lessons prepared in collaboration with Professionals User-friendly Learner Management System (LMS) Syllabus designed in line with the standards of the UK Education System Updated Study Materials focusing both on Knowledge and Skill based training Guidance to expand in 'a' territory and move forward with Private Detective profession Free Assessment to test learners' knowledge and skills Course Curriculum: Module 01: An Introduction to the Concept of Being a Private Detective Module 02: Private Investigation Process Module 03: Classification of Crime Module 04: Starting an Investigation Module 05: Crime Scene Investigation and Photography (Part 1) Module 06: Crime Scene Investigation and Photography (Part 2) Module 07: Evidence Collection Module 08: Locating Missing People Module 09: Interview and Interrogation Techniques Module 10: Methods of identification and Sources of information Module 11: Fingerprint Verification Module 12: Handwriting Examination Module 13: Linking and Surveillance of Suspect Module 14: Counter-Espionage & Counter-Surveillance Module 15: Domestic Investigation and Types Module 16: Basic Operations of Firearms Module 17: Preparing Case Report Module 18: Code of Ethics Module 19: Operating a Private Investigation Business Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing the Private Detective Advance Diploma - CPD Accredited course. For each test, the pass mark will be set to 60%. Accredited Certificate After successfully completing this Private Detective Advance Diploma - CPD Accredited course, you will qualify for the CPD Quality Standards (CPD QS) certified certificate from Training Express. CPD 10 CPD hours / points Accredited by The CPD Quality Standards (CPD QS) Who is this course for? The Private Detective Advance Diploma - CPD Accredited training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our Private Detective Advance Diploma - CPD Accredited training.
Managing a supply chain isn’t just about moving goods from A to B—it’s a delicate balancing act of timing, resources, logistics, and strategy. This CPD-accredited course dives into the fundamentals of supply chain management, covering everything from sourcing and procurement to inventory control and distribution. It’s designed to give learners a clear understanding of how supply chains function, how they interconnect with global markets, and where efficiencies (or chaos) tend to hide. Whether you’re looking to refine existing knowledge or aiming to navigate the basics with confidence, this course offers a smart, structured path through the key concepts and challenges. You’ll gain insight into risk management, supplier relations, demand forecasting, and sustainable supply chain strategies—all without needing to leave your desk. Think of it as the logistical equivalent of playing chess with the economy—minus the stress, and with fewer spreadsheets. Course Curriculum: Module 01: An overview of Supply Chain Management Module 02: Role of logistics of Supply Chain Module 03: Customer Response Principles and Systems Module 04: Supply Chain System and Principles Module 05: Global Supply Chain Operations Module 06:Inventory Strategies for Supply Chain Module 07: Warehouse Management and Operations Module 08: Supply Chain Design and Monitoring Module 09: Supply Chain Network and Evaluating Module 10: Supply Chain Planning and New Business Concepts Module 11: Aligning your supply chain process with your business Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing an online module. For each test, the pass mark will be set to 60%. Accredited Certificate After successfully completing this Supply Chain Management - CPD Accredited course, you will qualify for the CPD Quality Standards (CPD QS) certified certificate from Training Express. CPD 10 CPD hours / points Accredited by The CPD Quality Standards (CPD QS) Who is this course for? The Supply Chain Management - CPD Accredited training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our Supply Chain Management - CPD Accredited training.
