3227 Courses in Leeds delivered Online

Duration 2 Days 12 CPD hours This course is intended for This is an intermediate and beyond level SQL course geared for experienced end users, data scientists, business analysts, application developers and database administrators. Students should have recently attended a basic SQL class or have equivalent experience. Overview This course is approximately 50% hands-on, combining expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Our engaging instructors and mentors are highly experienced practitioners who bring years of current 'on-the-job' experience into every classroom. Working in a hands-on learning environment led by our expert practitioner, attendees will learn advanced skills needed to: Advanced Query Techniques Manipulating Table Data Using SQL's Data Manipulation Language (DML) User-Defined Functions Stored Procedures Triggers A company?s success hinges on responsible, accurate database management. Organizations rely on highly available data to complete all sorts of tasks, from creating marketing reports and invoicing customers to setting financial goals. Data professionals like analysts, developers and architects are tasked with creating, optimizing, managing and analyzing data from databases ? with little room for error. When databases aren?t built or maintained correctly, it?s easy to mishandle or lose valuable data. Our SQL Programming and Database Training Series provides students with the skills they require to develop, analyze and maintain data and in correctly structured, modern and secure databases. Next Level SQL explores how to identify and use advanced querying techniques to manipulate and index tables. All hands-on work in this course is ANSI SQL compliant and should work with most SQL databases such as Oracle, SQL Server, MySQL, MS Access, Informix, Sybase, or any other ANSI SQL compliant database. Advanced Query Techniques Join inner outer (Left, Right, Full) Subqueries Simple Correlated Using the Exists Operator Tips for Developing Complex Queries Performing Set Operations Aggregating Results Using Group by Creating Temporary Tables Manipulating Table Data Using SQL's Data Manipulation Language (DML) Inserting Data into Tables Updating Existing Data Deleting Records Truncating Tables Implementing Data Integrity with Transactions Beginning Explicit Transactions Committing Transactions Rolling Back Transactions User-Defined Functions Definition and Benefits of Use CREATE FUNCTION Syntax RETURN Clause and the RETURNS Statement Scalar vs. Table Functions Comparison with Stored Procedures Returning Scalar Values and Tables ALTER and DROP FUNCTION Stored Procedures Definition and Benefits of Use CREATE PROCEDURE Syntax Variables and Parameters Control of Program Flow ALTER and DROP PROCEDURE Implementation Differences Triggers Definition and Benefits of Use Alternatives (e.g., Constraints) CREATE TRIGGER Syntax Trigger Types 'Inserted' (or 'NEW') and 'Deleted' (or 'OLD') Tables Event Handling and Trigger Execution ALTER and DROP TRIGGER Additional course details: Nexus Humans Advanced SQL Programming (TTSQL005) 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 Advanced SQL Programming (TTSQL005) 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.

In the Microsoft Excel for Beginners course, learners will be given a full introduction to the features and functions of Excel, taking their proficiency from beginner to advanced level in no time. We offer step-by-step guidance for managing everyday tasks, such as modifying a worksheet, managing workbooks, performing calculations and entering financial data. The principles and practices of SEN teaching and supporting children with learning difficulties is also covered in this comprehensive course. Learning Objectives: Master day-to-day office tasks and manage important work data with Microsoft Excel Learn how to modify and format worksheets in Excel Get step-by-step guidance on how to print and manage workbooks Be able to perform basic calculations and data-inputting tasks Who is this Course for? Microsoft Excel For Beginners is 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 Microsoft Excel For Beginners 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. CPD Certificate from Course Gate  At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Microsoft Excel Getting Started with Microsoft Office Excel 2016 Navigate the Excel User Interface 00:28:00 Use Excel Commands 00:10:00 Create and Save a Basic Workbook 00:19:00 Enter Cell Data 00:12:00 Use Excel Help 00:05:00 Performing Calculations Create Worksheet Formulas 00:15:00 Insert Functions 00:17:00 Reuse Formulas and Functions 00:17:00 Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Formatting a Worksheet Apply Text Formats 00:17:00 Apply Number Format 00:08:00 Align Cell Contents 00:09:00 Apply Styles and Themes 00:12:00 Apply Basic Conditional Formatting 00:11:00 Create and Use Templates 00:07:00 Printing Workbooks Preview and Print a Workbook 00:10:00 Set Up the Page Layout 00:08:00 Configure Headers and Footers 00:07:00 Managing Workbooks Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views 00:07:00 Manage Workbook Properties 00:05:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Learn bike maintenance from the comfort of your home with our comprehensive Bike Maintenance course. Understand your bike's components and functions, master essential tools, and develop skills for regular maintenance tasks. Gain insights into tyre, wheel, brake, saddle, chain, steering system, and gear maintenance for optimal performance.

The OWASP Zed Attack Proxy is an open source means of testing web applications manually. It is one of the leading tools for identifying web application vulnerabilities. The Penetration Testing with OWASP ZAP course will take you through the basic functions of ZAP, equipping you with a range of ethical hacking skills needed to become a successful Web Developer or Penetration Tester. It will take you through the very basics, from how to install ZAP, to the steps for configuring your browser to use AP as a proxy.  By the end of this course, you will be able to use ZAP to assess web applications and conduct penetration testing to identify vulebrailities and uncover hidden bugs. You will also be able to identify opportunities to strengthen your company's and create reports of your results. This best selling Penetration Testing with OWASP ZAP has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Penetration Testing with OWASP ZAP is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Penetration Testing with OWASP ZAP is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Penetration Testing with OWASP ZAP is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Penetration Testing with OWASP ZAP, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Penetration Testing with OWASP ZAP will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Penetration Testing with OWASP ZAP to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device. Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

If you’ve ever considered working within the cyber security industry, but felt you lacked the knowledge or skills to launch your career, this course might be what you’re looking for.

Python 3 is one of the most popular programming languages. Companies like Facebook, Microsoft, and Apple all want Python

Description Medical Aesthetics Diploma A comprehensive online course tailored for those eager to embark on a journey into the dynamic and growing world of medical aesthetics. With the world increasingly prioritising self-care and beauty, there's never been a better time to equip oneself with the knowledge and skills this course offers. This course provides a deep understanding of the foundations of medical aesthetics. Learners will gain insights into the skin's intricate anatomy and physiology, paving the way for a better comprehension of the treatments and procedures that follow. Knowledge of the skin's structure and functions is crucial in this field, ensuring every procedure is conducted safely and effectively. To cater to the varied interests of our students, the course encompasses both non-surgical aesthetic treatments and surgical aesthetic procedures. Non-surgical treatments are gaining traction due to their minimally invasive nature, quick recovery time, and cost-effectiveness. On the other hand, surgical procedures, while more invasive, can offer longer-lasting and more transformative results. Our Medical Aesthetics Diploma ensures students get a balanced view of both domains. For those passionate about enhancing the natural glow of the skin, the section on skin rejuvenation techniques will be of immense value. The methods taught here target the revitalisation of the skin, bringing out its inherent vibrancy and youthfulness. Scars and stretch marks often cause distress, affecting individuals' confidence. The Medical Aesthetics Diploma course introduces techniques to minimize these imperfections, ensuring students can offer solace and solutions to those seeking a clearer skin appearance. Hair plays a significant role in shaping our overall appearance. Hence, the course takes a keen interest in imparting knowledge on both hair restoration for those grappling with hair loss, and hair removal techniques for those seeking smoother, hair-free skin. The world of aesthetics is not just skin deep. Aesthetic dentistry has become a prominent part of the beauty industry. This course introduces learners to the nuances of aesthetic dentistry, ensuring a holistic approach to the world of medical aesthetics. An essential part of any profession is understanding its commercial aspect. The Business of Medical Aesthetics section of the course offers guidance on how to set up, manage, and grow a successful practice. Students will learn the ropes of business management, marketing, client relations, and more, ensuring they're well-prepared to venture out on their own or elevate existing establishments. Lastly, as with any evolving field, it's crucial to stay ahead of the curve. The Future of Medical Aesthetics section offers a glimpse into the innovations and trends poised to shape this industry in the coming years. By acquainting themselves with future directions, students will be better prepared to adapt, innovate, and thrive in their professional journey. In essence, the Medical Aesthetics Diploma online course offers a robust, comprehensive, and future-ready curriculum for aspiring professionals. With the tools, techniques, and knowledge gained from this course, graduates will be well-equipped to make a meaningful impact in the world of medical aesthetics. So, whether you're a beginner eager to step into this world or a seasoned professional looking to enhance your skills, this course has something invaluable to offer. What you will learn 1:Foundations of Medical Aesthetics 2:Skin Anatomy and Physiology 3:Non-Surgical Aesthetic Treatments 4:Surgical Aesthetic Procedures 5:Skin Rejuvenation Techniques 6:Minimizing Scars and Stretch Marks 7:Hair Restoration and Removal 8:Aesthetic Dentistry 9:The Business of Medical Aesthetics 10:The Future of Medical Aesthetics 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.

Description Neuroplasticity Diploma Neuroplasticity Diploma offers a comprehensive online journey into the fascinating world of the brain's ability to change and adapt. This innovative course is designed for those who wish to deepen their understanding of how the brain works, evolves, and reshapes itself throughout a person's lifetime. Beginning with an Introduction to Neuroplasticity, this diploma breaks down the complexities of the brain's dynamic nature. Rather than seeing the brain as a static organ, participants will come to appreciate the nuances of its growth, adaptation, and its boundless potential for transformation. In the Sensory Substitution section, learners will explore how the brain can repurpose one sense to compensate for the loss or inefficiency of another. Imagine a world where the blind can 'see' using their sense of touch or where the deaf might 'hear' via visual cues. The marvels of sensory substitution make such wonders possible, and this section unpacks the science behind it. Developmental Plasticity addresses the evolution of the brain during different stages of human growth. From infancy to adulthood, the brain undergoes significant changes, constantly adapting and learning. This section provides invaluable insights into how early experiences can shape our cognitive abilities and behaviours for years to come. In Synaptic Plasticity, the course delves into the cellular level of brain adaptation. Unravel how individual neural connections strengthen or weaken in response to experiences, laying the foundation for memory, learning, and behavioural change. The Seven Rules of Neuroplasticity is an illuminating segment, guiding learners through the fundamental principles governing how the brain changes. With these rules, one can better understand the underlying mechanisms and perhaps even harness them to foster positive personal growth. Brain Training, a popular topic in today's digital age, seeks to explore the tools and techniques that claim to enhance cognitive functions. With so many apps and programmes promising to 'train' the brain, this section offers a scientific lens to evaluate their efficacy and potential. One cannot discuss neuroplasticity without addressing Nerve Injury and Brain Damage. This section offers insights into how the brain recovers and compensates after trauma, showcasing its resilience and adaptability. Addiction and Pain, two formidable challenges in neuroscience, are scrutinised in the context of neuroplasticity. This section seeks to offer an understanding of how repeated behaviours can reshape the neural pathways, leading to addiction, and how pain, both physical and emotional, can change the brain's structure and function. Lifelong Changes in the Brain provides hope and inspiration by highlighting that the brain's ability to adapt isn't confined to the early years but is a lifelong phenomenon. Be it learning a new skill in one's golden years or adapting to unforeseen life changes; the brain's plasticity supports us throughout our journey. The course rounds up with a Conclusion, where learners are equipped with a holistic understanding of neuroplasticity. The Neuroplasticity Diploma doesn't just offer knowledge; it provides a foundation for learners to apply this knowledge in their personal and professional lives, be it in therapy, education, or personal development. In essence, the Neuroplasticity Diploma is an online treasure trove for anyone keen on grasping the immense capabilities of the human brain. Enrol today and embark on a journey of discovery, wonder, and infinite possibilities. What you will learn 1:Introduction to Neuroplasticity 2:Sensory Substitution 3:Developmental Plasticity 4:Synaptic Plasticity 5:The Seven Rules of Neuroplasticity 6:Brain Training 7:Nerve Injury and Brain Damage 8:Addiction and Pain 9:Lifelong Changes in the Brain 10:Conclusion 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.

Unlock the world of data entry with our comprehensive course for beginners. Master Microsoft Word and Excel, delve into advanced techniques and tools, and learn best practices for accuracy. Build a successful data entry career with hands-on guidance and create a professional portfolio. Join us for a transformative journey into the heart of data entry excellence.

This course delves into system safety principles and techniques, equipping participants with the knowledge and skills to manage safety functions in various industries effectively. After the successful completion of the course, you will be able to learn about the following; Explore Rationale, Nature and Role of Motivation Theories. Learn and Apply Motivation Theories. Understand Organisational Environment and the Safety Culture. Implement Processes Focusing on Improving Safety Behaviour. Explore Workplace Safety Behavior and Conflict Management. Participants will learn about the nature and role of system safety, management strategies, elements of a system safety program plan, and tools and techniques for implementing system safety measures. The course covers job safety analysis techniques and explores effective methods for managing the safety function within organizations. Through practical examples and case studies, participants will develop the expertise needed to create and maintain a safe working environment. 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. Psychology and Safety; the Human Element in Loss Prevention Self-paced pre-recorded learning content on this topic. The Human Element in Loss Prevention 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 an 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 who is eager to know more and get updated on current ideas in their respective field. We recommend this certificate for the following audience. System Safety Engineer Safety Program Manager Occupational Health and Safety Specialist Safety Compliance Officer Risk Management Analyst Safety Consultant Safety Coordinator Environmental Health Officer Safety Training Instructor Safety Program Coordinator 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.