8271 Online Education courses

Duration 3 Days 18 CPD hours In this 3 day customized Intermediate SQL course students will learn additional commands and functions using labs/activities/content that correlates with this content. By understanding SQL, you get the knowledge of fundamental queries associated with data management so that you can verify, monitor, and control all the activities operating in the database. Lesson 1 Substring Instr / CharIndex Convert (data types and with Formatting) Replace RowCount / RowNum / Top )n) ÿ(Oracle/SQL Server functions) Case / If Then Else statements Exists Clause Find Duplicates using Group by and have clause (and other tips for analyzing data) Lesson 2 Set operations (UNION, UNION ALL, INTERSECT, MINUS) GROUP BY extensions (ROLLUP, CUBE, and GROUPING SETS) Loops / Cursors Common Table Expressions (CTEs) Lesson 3 Temp Tables / Views Advanced Subqueries Regular Expressions (RegEx) Linked Server Queries Qualified subquery predicates Aggregate functions Optimizing queries SQL Injection Lesson 4 JSON Parsing With Partition By With Over Fuzzy Logic - MDS.mdq.[Similarity]ÿ Additional course details: Nexus Humans Intermediate SQL Custom 3-Day Private Class Outline 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 Intermediate SQL Custom 3-Day Private Class Outline 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.

The Real Estate Appraiser is a wonderful learning opportunity for anyone who has a passion for this topic and is interested in enjoying a long career in the relevant industry. It's also for anyone who is already working in this field and looking to brush up their knowledge and boost their career with a Certificate of Achievement.  This Real Estate Appraiser consists of several modules that take around 5 hours to complete. The course is accompanied by instructional videos, helpful illustrations, how-to instructions and advice. The course is offered online at a very affordable price. That gives you the ability to study at your own pace in the comfort of your home. You can access the modules from anywhere and from any device. Why Choose this Course? Earn a digital Certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full tutor support on weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Mock exams Multiple-choice assessment This course has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course is not regulated by Ofqual and is not an accredited lesson. Your training provider will be able to advise you on any further recognition, for example progression routes into further higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website. Method of Assessment To verify your enhanced skills in the subject, we recommend that you also complete the assignment questions. These can be completed at any time which is convenient for yourself and will be assessed by our in-house specialised tutors. Full feedback will then be given on your current performance, along with any further advice or support. Course Content Module 1 - Property Development Property Development 00:21:00 Module 2 - Different Types of Property Different Types of Property 00:16:00 Module 3 - Land Law Principles- Rights and Interests Land Law Principles- Rights and Interests 00:20:00 Module 4 - Ownership, Co-ownership and Possession of the Property Ownership,Co-ownership and Possession of the Property 00:35:00 Module 5 - Lease Bailment, License, Mortgage and Insurance Related Law Lease Bailment, License,Mortgage and Insurance Related Law 00:58:00 Module 06 - Real Estate Investment Real Estate Investment 00:18:00 Module 07 - Strategies for a Real Estate Investor Strategies for a Real Estate Investor 00:19:00 Module 08 - Marketing Your Property Marketing Your Property 00:14:00 Module 09 - Introduction to Property Management Introduction to Property Management 00:14:00 Module 10 - The Property Management Process The Property Management Process 00:34:00 Module 11 - The Role and Responsibilities of a Property Manager The Role and Responsibilities of a Property Manager 00:13:00 Module 12 - Listing Properties and Marketing Listing Properties and Marketing 00:26:00 Mock Exam Mock Exam-Real Estate Appraiser 00:20:00 Final Exam Final Exam-Real Estate Appraiser 00:20:00 Assignment Assignment - Real Estate Appraiser 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Leading People through Change (Virtual) Research shows that 70% of change initiatives fail in large organizations. The largest factor contributing to this failure rate is leadership - the inability to plan and lead people through change. In many change situations, tremendous focus is put on strategy, processes, and systems, while the issue of changing people's behavior is assumed it will 'just happen'. In this interactive course, you will learn why the people side of change is crucial. We will begin by understanding why and how people resist change, and how important it is to become strong and effective change champions. Next, we will focus on critical change management practices - creating our vision of the future state, planning for acceptance in our change audience and stakeholders, mitigating threats, and capitalizing on opportunities. We will use metrics to plan, show progress, and confirm success. Lastly, we will focus on the need to reinforce and sustain change, and to prevent relapse to old ways and methods. What you will Learn At the end of this program, you will be able to: Realize the nature of change and describe how resistance manifests in people Compare prevalent change models and categorize their similarities Identify and rate the skills, traits, and behaviors of effective change champions Envision the future state and assess stakeholders Plan for change communication, training, and risks Evaluate change effectiveness using feedback and metrics Develop reinforcement practices for benefits and communication Getting Started Foundation Concepts What is Change? Resistance to Change Common Change Management Theories Becoming a Change Champion Plan Envisioning the future state Planning for people Change management plan Do Change communication Training Piloting Risks Study Feedback Metrics Variance analysis Act Benefits realization Change sustainment Reinforcement messaging and communications Summary and Next Steps

Duration 3 Days 18 CPD hours This course is intended for This course is designed for existing Python programmers who have at least one year of Python experience and who want to expand their programming proficiency in Python 3. Overview In this course, you will expand your Python proficiencies. You will: Select an object-oriented programming approach for Python applications. Create object-oriented Python applications. Create a desktop application. Create data-driven applications. Create and secure web service-connected applications. Program Python for data science. Implement unit testing and exception handling. Package an application for distribution. Python continues to be a popular programming language, perhaps owing to its easy learning curve, small code footprint, and versatility for business, web, and scientific uses. Python is useful for developing custom software tools, applications, web services, and cloud applications. In this course, you'll build upon your basic Python skills, learning more advanced topics such as object-oriented programming patterns, development of graphical user interfaces, data management, creating web service-connected apps, performing data science tasks, unit testing, and creating and installing packages and executable applications. Lesson 1: Selecting an Object-Oriented Programming Approach for Python Applications Topic A: Implement Object-Oriented Design Topic B: Leverage the Benefits of Object-Oriented Programming Lesson 2: Creating Object-Oriented Python Applications Topic A: Create a Class Topic B: Use Built-in Methods Topic C: Implement the Factory Design Pattern Lesson 3: Creating a Desktop Application Topic A: Design a Graphical User Interface (GUI) Topic B: Create Interactive Applications Lesson 4: Creating Data-Driven Applications Topic A: Connect to Data Topic B: Store, Update, and Delete Data in a Database Lesson 5: Creating and Securing a Web Service-Connected App Topic A: Select a Network Application Protocol Topic B: Create a RESTful Web Service Topic C: Create a Web Service Client Topic D: Secure Connected Applications Lesson 6: Programming Python for Data Science Topic A: Clean Data with Python Topic B: Visualize Data with Python Topic C: Perform Linear Regression with Machine Learning Lesson 7: Implementing Unit Testing and Exception Handling Topic A: Handle Exceptions Topic B: Write a Unit Test Topic C: Execute a Unit Test Lesson 8: Packaging an Application for Distribution Topic A: Create and Install a Package Topic B: Generate Alternative Distribution Files

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

Register on the Estate Management today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get a digital certificate as a proof of your course completion. The Estate Management is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Estate Management Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certification Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the Estate Management, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Course Content Module 1: Introduction to Property Management Introduction to Property Managemen 00:14:00 Module 2: The Role and Responsibilities of a Property Manager The Role and Responsibilities of a Property Manager 00:13:00 Module 3: The Property Management Proces The Property Management Process 00:34:00 Module 4: Introduction to Handyperson Introduction to Handyperson 00:21:00 Module 5: Basic Tools and Equipment Basic Tools and Equipment 00:23:00 Module 6: Electrical Work Electrical Work 00:24:00 Module 7: Plumbing Skills Plumbing Skills 00:20:00 Module 8: Appliances Appliances 00:19:00 Module 9: General Carpentry General Carpentry 00:27:00 Module 10: Basic Maintenance Skills Basic Maintenance Skills 00:15:00 Module 11: Walls and Floors Walls and Floors 00:20:00 Module 12: Painting and Decorating Painting and Decorating 00:18:00 Module 13: Drilling, Tiling and Welding Drilling, Tiling and Welding 00:23:00 Module 14: Construction Projects Construction Projects 00:17:00 Mock Exam Mock Exam- Estate Management 00:20:00 Final Exam Final Exam- Estate Management 00:20:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Duration 1 Days 6 CPD hours This course is intended for This course is intended for organizations engaged with remote workforce teams. Overview Upon successful completion of this course, participants will be able to identify and create high performance teams. In this course, teams will learn the importance of developing performance skills while working remotely. Getting Started Workshop Objectives Action Plan Remote Workforce What is a Remote Workforce? Types of Remote Workforce Benefits of a Remote Workforce Materials for Remote Workforce Practical Illustration High Performance Teams What is a High-Performance Team? Benefits of High-Performance Teams Leadership for High Performance Team Understanding Team Dynamics Practical Illustration Characteristics of High-Performance Teams Excellent Communication Goal-Oriented Flexibility Committed Practical Illustration How to Create Teamwork Identify Group & Individual Responsibilities Give Permission to Take Action Build Relationships between Team Members and Management Give Feedback Practical Illustration Types of Communication Virtual Team Meetings Telephone Conferences Email Communication Intranet, Webpage, and Social Media Communication Practical Illustration Training Your Team Telecommute Training Web-based Training Peer Training Training Assessment and Retraining Practical Illustration Types of Communication Tracking Team Performance Counseling Employees Positive Recognition for Employees Training Never Stops! Practical Illustration Effective Team Meeting How-to 43 Have a Clear Agenda Have a Clear Agenda Use Screen Shots or References Create a Safe Place Team Meeting Don?ts Practical Illustration Keep a Happy and Motivated High-Performance Team Watch for Signs of Conflict or Unhappiness Employee Feedback and Concerns Give Opportunities for Additional Education Impart Opportunities for Career Growth Practical Illustration Don?ts? with High Performance Teams Don't Forget to Share Success Don't Delay in Responding Don?t Assign Vague Responsibilities Don?t Lead as a Dictator Practical Illustration Wrapping Up Words from the Wise

Duration 2 Days 12 CPD hours This course is intended for This course is designed for developers who want to learn about Git and GitHub. Overview Upon completion of this course, participants will be able to: ? Install and run Git ? Describe basic concepts of Git version control ? Work on multiple branches ? Optimize merging and fixing merge conflicts ? Create and manage GitHub repositories ? Collaborate using GitHub This hands-on course teaches participants how to integrate Git and GitHub into their daily command-line workflow. Git operations, customizations of Git functionality, and how to connect to Git via Eclipse are covered as well. Introduction Introduction to Version Control Systems The Birth of Git and Why Git? What is GitHub? GitHub Repository Concepts Getting Started With Git Installing and Running Git The Git command Line Configuration Files Creating your First Git Repository Staging Area Git Commit Viewing History Creating Aliases and Shortcuts Hands-on Lab Session Getting Started with GitHub Creating and Configuring a Repository in GitHub Uploading your Repository to GitHub Understand Repository?s Main Page Using the README Hands-on Lab Session File Management in Git Locally The Index File Classifications in Git Rename a File Delete a File Ignore Files using .gitignore File Hands-on Lab Session Collaboration on Pull Requests Cloning and Forking Repositories Creating a Pull Request Collaborating a Pull Request Merging on a Pull Request Working with Branches Hands-on Lab Session Integrating GitHub with Eclipse Introducing EGit Plugin Configuring GitHub in Eclipse Working with Eclipse Hands-on Lab Session Reviewing and Configuring a Project on GitHub Configuring a Repository Adding Collaborators Creating Organizations Managing Teams Introducing Issues Merging, Rebasing and Resolving Conflicts Merging Branches Git diff and Commit Ranges Working with Merge Conflicts Merge Strategies Introduction to Rebasing Rebasing Branches Reverting and Fixing Bad Commits Hands-on Lab Session Additional course details: Nexus Humans Learning Git and GitHub 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 Learning Git and GitHub 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.

You can gain the relevant skills to become a counsellor for children and adolescents by completing this course. This course includes psychological approaches to human development. You will gain knowledge of the effectiveness behind therapy and its effectiveness. Upon completion, you will know more about the different methods discussed in therapy. You will also learn about various complex experiences which impact children and adolescents. Additionally, this Certificate in Counselling Children & Adolescents will guide you through the best ways to open your own counselling practice. If you are interested in becoming a child and adolescent counsellor, then this course is for you. Certificate in Counselling Children & Adolescents is a best selling course developed by industry experts and already helped tons of students like you. It is suitable for anyone who wants to improve their knowledge and skills in the [course_category] or relevant sector. This course is accredited by CPD, so you will get a career boost upon completing this course. Our Certificate in Counselling Children & Adolescents is packed with 25 modules and 1 day, 23 hours of study. You will be awarded with a certificate of completion, the proof of your expertise in this field. If you want to get a job or looking for professional skills to excel in this field, a certificate from this course will help you appear as a strong candidate. You can also validate your certification from our website. It doesn't matter if you are willing to study full-time or part-time. This course is designed for any type of student and you can even complete it at your own pace. The materials are accessible from anyplace, any device and anytime.  Besides that, our experienced tutors will help you throughout the comprehensive syllabus of this course and answer all your queries through email.

Register on the Cyber Security Law Online Course today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get a digital certificate as a proof of your course completion. The Cyber Security Law Online Course is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Cyber Security Law Online Course Receive an e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certification Upon successful completion of the course, you will be able to obtain your course completion e-certificate. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Who Is This Course For The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements The online training is open to all students and has no formal entry requirements. To study the Cyber Security Law Online Course, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Course Content Module 01: Introduction to Cyber Law Introduction to Cyber Law 00:05:00 Module 02: Cyber Law, Cyber Ethics and Online Gambling Cyber Law Cyber Ethics and Online Gambling 00:05:00 Module 03: Cyber Crime, Cyber Security and Trust in Cyberspace Cyber Security and Trust in Cyberspace 00:10:00 Module 04: Threat Factors: Computer as a Target Threat Factors Computer as a Target 00:10:00 Module 05: Threats to Cyber Security by Criminals and Organised Crimes Threats to Cyber Security by Criminals and Organised Crimes 00:05:00 Module 06: Threats to Cybersecurity by Hacktivists and Nation-States Threats to Cybersecurity by Hacktivists and Nation-States 00:15:00 Module 07: Cyberterrorism Cyberterrorism 00:10:00 Module 08: An Evolving Threat: The Deep Web An Evolving Threat The Deep Web 00:10:00 Module 09: Fraud Fraud 01:00:00 Module 10: Jurisdiction Jurisdiction 00:05:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.