1697 Courses delivered Online

Duration 3 Days 18 CPD hours This course is intended for The ideal audience for this course includes database enthusiasts, IT professionals, and developers who are eager to expand their knowledge and skill set in database management and optimization. Roles that would greatly benefit from attending this course include: Database Developers: Those who design, implement, and maintain databases as part of their primary responsibilities and want to improve their expertise in schema design, query optimization, and advanced database features. Backend Developers: Professionals who work on server-side application logic and require a strong understanding of database management to integrate data storage and retrieval processes into their applications. Overview Upon completing this course, database developers will be able to: Design and implement efficient database schemas by employing normalization techniques, appropriate indexing strategies, and partitioning methods to optimize data storage and retrieval processes. Develop advanced SQL queries, including joining multiple tables, utilizing subqueries, and aggregating data, to extract valuable insights and facilitate decision-making processes. Implement stored procedures, functions, and triggers to automate common database tasks, enforce data integrity, and improve overall application performance. Apply database performance tuning techniques, such as query optimization, index management, and transaction control, to ensure optimal resource usage and enhanced system responsiveness. Integrate databases with various programming languages and platforms, enabling seamless data access and manipulation for web, mobile, and desktop applications. PostgreSQL is a powerful, open-source object-relational database management system that emphasizes extensibility, data integrity, and high performance. Its versatility and robust feature set make it an ideal choice for developers working on projects of all sizes, from small-scale applications to enterprise-level systems. By learning PostgreSQL, developers can tap into its advanced capabilities, such as full-text search, spatial data support, and customizable data types, allowing them to create efficient and scalable solutions tailored to their unique needs. PostgreSQL for Database Developers is a three-day hands-on course that explores the fundamentals of database management, covering everything from installation and management to advanced SQL functions. Designed for beginners and enthusiasts alike, this course will equip you with the knowledge and skills required to effectively harness the power of PostgreSQL in today's data-driven landscape. Throughout the course you?ll be immersed in a variety of essential topics, such as understanding data types, creating and managing indexes, working with array values, and optimizing queries for improved performance. You?ll gain valuable hands-on experience with real-world exercises, including the use of the psql client, writing triggers and stored procedures with PL/pgSQL, and exploring advanced SQL functions like Common Table Expressions (CTE), Window Functions, and Recursive Queries. You?ll exit this course with a solid foundation in PostgreSQL, enabling you to confidently navigate and manage your databases with ease and efficiency. Installing & Managing PostgreSQL PostgreSQL installation process Optimal configuration settings User and role management Database backup and restoration Overview of PostgreSQL Database PostgreSQL architecture overview Understanding database objects Efficient data storage Transaction management basics Using the psql client Introduction to psql Essential psql commands Executing queries effectively Managing databases with psql Understanding PostgreSQL data types Numeric data types explored Character and binary types Date, time, and boolean values Array and other types Understanding sequences Sequence creation and usage Customizing sequence behavior Implementing auto-increment columns Sequence manipulation and control Creating & managing indexes PostgreSQL index fundamentals Designing partial indexes Utilizing expression-based indexes Index management techniques Using COPY to load data COPY command overview Importing and exporting data Handling CSV and binary formats Performance considerations Working with Array Values Array value basics Array manipulation functions Querying arrays efficiently Multidimensional array handling Advanced SQL Functions Mastering Common Table Expressions Utilizing Window Functions Regular Expressions in SQL Crafting Recursive Queries Writing triggers & stored procedures with PL/pgSQL PL/pgSQL variables usage Implementing loop operations PERFORM and EXECUTE statements Developing PostgreSQL triggers Using the PostgreSQL query optimizer Query analysis and optimization EXPLAIN command insights PostgreSQL query operators Identifying performance bottlenecks Improving query performance Query performance tuning Index optimization strategies Efficient database partitioning Connection and resource management Wrap Up & Additional Resources Further learning opportunities Staying up-to-date with PostgreSQL Community engagement and support Additional course details: Nexus Humans PostgreSQL for Database Developers (TTDB7024) 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 PostgreSQL for Database Developers (TTDB7024) 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.

Explore the intricacies of UK Politics with our comprehensive course, 'UK Politics Essentials: Understanding the Political Landscape.' Gain insights into the historical foundations, democratic principles, electoral systems, and the dynamic interplay of political parties and pressure groups. Navigate the post-Brexit era and examine the evolving relationship with the European Union. Enrich your understanding of governance, civic engagement, and the constitutional framework. Join us to delve into the heart of UK Politics and emerge with a nuanced perspective on one of the world's oldest democracies.

Course Overview Discover new levels of self-awareness and show conviction in your beliefs and values when you take this training to Become the Best Version of Yourself. It's all too easy to let life and events change our characteristics or for us to put up a façade that hides our true feelings. Move away from that behaviour by taking this inspiring course that empowers you to feel your best, live your life as you want to, and be a better person. This Personal Improvement tutorial specifically looks at the way that we perceive ourselves and how we can do this in a more positive way. You will be taught how to be 'authentic', perform activities that you want to do without feeling judged or uncomfortable, live the lifestyle that you have chosen, interact with other individuals in a natural way, and so much more. This is an eye-opening journey into the truth of oneself and how being honest about your feelings leads to new kinds of personal freedom. Enrol now and start living the life you deserve. This best selling Become the Best Version of Yourself has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Become the Best Version of Yourself is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Become the Best Version of Yourself 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 Become the Best Version of Yourself 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 Become the Best Version of Yourself, 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 Become the Best Version of Yourself 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 Become the Best Version of Yourself 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. 

The underlying patterns in your data hold vital insights; unearth them with cutting-edge clustering and classification techniques in R

Level 3 QLS Endorsed Course | Endorsed Certificate Included | Plus 5 Career Guided Courses | CPD Accredited

This Advanced Diploma in Public Relation at QLS Level 7 course is endorsed by The Quality Licence Scheme and accredited by CPDQS (with 180 CPD points) to make your skill development & career progression more accessible than ever! Are you looking to improve your current abilities or make a career move? If yes, our unique Public Relation at QLS Level 7 course might help you get there! It is an expertly designed course which ensures you learn everything about the topic thoroughly. Expand your expertise with high-quality training from the Public Relation at QLS Level 7 course. Due to Public Relation at QLS Level 7's massive demand in the competitive market, you can use our comprehensive course as a weapon to strengthen your knowledge and boost your career development. Learn Public Relation at QLS Level 7 from industry professionals and quickly equip yourself with the specific knowledge and skills you need to excel in your chosen career. The Public Relation at QLS Level 7 course is broken down into several in-depth modules to provide you with the most convenient and rich learning experience possible. Upon successful completion of the Public Relation at QLS Level 7 course, an instant e-certificate will be exhibited in your profile that you can order as proof of your skills and knowledge. Add these amazing new skills to your resume and boost your employability by simply enrolling in this Public Relation at QLS Level 7 course. This Public Relation at QLS Level 7 training can help you to accomplish your ambitions and prepare you for a meaningful career. So, join us today and gear up for excellence! Why Prefer This Public Relation at QLS Level 7 Course? Opportunity to earn a certificate endorsed by the Quality Licence Scheme & another accredited by CPDQS which is completely free. Get a free student ID card! (£10 postal charge will be applicable for international delivery) Innovative and engaging content. Free assessments 24/7 tutor support. Take a step toward a brighter future! *** Course Curriculum *** Here is the curriculum breakdown of the Public Relation at QLS Level 7 course: Module 01: Introduction to Public Relations Module 02: Concepts of Public Relations Module 03: Management and Organisation of Public Relations Module 04: Public Relations Tactics and Research Module 05: Major Fields of Public Relations Practice Part I Module 06: Major Fields of Public Relations Practice Part II Module 07: Social Media and PR Module 08: Public Speaking Module 09: Power of Storytelling Module 10: Becoming an Influencer Module 11: Importance of Body Language Module 12: Implementing CSR Module 13: Performance Evaluation and Performance Reporting Module 14: Cross-Cultural Awareness Module 15: Cross-Cultural Communication Module 16: Corporate Cross-Cultural Awareness Module 17: Cultural Values Module 18: Working with and Managing a Culturally Diverse Team Module 19: Defamation Module 20: Crisis management Module 21: Media Regulatory Bodies Module 22: Ethics & Professionalism in Public Relations Module 23: Decision Making with Critical Thinking Assessment Process After completing an online module, you will be given immediate access to a specially designed MCQ test. The results will be immediately analysed, and the score will be shown for your review. The passing score for each test will be set at 60%. You will be entitled to claim a certificate endorsed by the Quality Licence Scheme after you have completed all of the Advanced Diploma in Public Relation at QLS Level 7exams. CPD 180 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Public Relation at QLS Level 7 course is perfect for highly motivated people who want to improve their technical skills and prepare for the career they want! Requirements No prior background or expertise is required. Career path The Public Relation at QLS Level 7 course will boost your CV and aims to help you get the job or even the long-awaited promotion of your dreams. Certificates Advanced Diploma in Public Relation at QLS Level 7 Hard copy certificate - Included Show off Your New Skills with a Certificate of Completion After successfully completing the Advanced Diploma in Public Relation at QLS Level 7, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme andalso you can order CPDQSAccredited Certificate that is recognised all over the UK and also internationally. The certificates will be home-delivered, completely free of cost. CPDQS Accredited Certificate Digital certificate - Included

Motorsport is as much a business as it is a sport. Our new Master’s Degree programme will provide students with a broad range of modules which examine the national and international aspects of the industry from a commercial perspective. Study an individual module from the MA Business of Motorsport for Continuing Professional Development (CPD).

ISO 22301:2019 is an international standard of Security and resilience – Business continuity management systems (BCMS), its existence of it requires competent personnel to interpret its requirements, address those to integrate BCMS in an organization, and audit the organization to assess the implementation and effectiveness of overall implementation. This course is designed for professionals who are responsible for any aspect of Business continuity management systems (BCMS) as well as for those, specifically, who are pursuing their career in the field of auditing and certification. This course enhances the knowledge and skills of delegates to understand the standard and audit it effectively. The course is consisting of study material in form of self-study type written and exercises. Attendees of this course will be, on completion, competent to implement BCMS, Plan, Conduct & Report 1st, 2nd & 3rd party audits.   Features of Couse ✔ 100% Online Self-paced: Considering busy schedules, we have designed this course to be attended online without bounding with the timings. To make it interactive, we have created different communication groups where candidates can discuss the points with other fellows as well as the trainers of course. Also, they can interact with trainers on monthly demonstration classes. ✔ Testing the Learning: Each section of course is covered with exercise to check your knowledge in real-time, and overall result is affected by exercises you complete. ✔ Self-Scheduling: This 40 Hours full fledge course is designed to match your schedule. You will get a life time access to this course and complete it on your ease. ✔ Superlative Material: The training is designed, developed and reviewed by competent auditors with extensive experience of auditing in different regions of world. ✔ Approved Course: The course is approved by one of the well-known personal certifying body “Exemplar Global”. With the approved course, you will get many benefits from Exemplar global which includes but not limited to; Exemplar Global graduate certificate with being listed on their website as auditor as well as badge of auditor from Exemplar Global. Extended learning content from Exemplar Global Complimentary access to online events, online magazine, newsletters, and low-cost professional Access to an exclusive LinkedIn Community Opportunity to explore career enhancement and employment opportunities   Who should attend this? This course is recommended to be attended by those who are involved in implementation and/ or auditing of Business continuity management systems (BCMS), specifically BCMS Managers, Auditors and others willing to add credibility with a widely accepted qualification for auditing. Also, recommended to satisfy the applicable requirement of training and competence, if any. This course can add values to your profile if you are Intending to perform audits of Business continuity management systems (BCMS). A BCMS Executive/ Management Representative An Existing Internal Auditor A Business continuity management systems (BCMS) Consultant Responsible for implementing the Business continuity management systems (BCMS) standard. Responsibility to evaluate the outcome of internal ISO 22301:2019 – Business continuity management systems (BCMS) audits and have responsibility/ authority to improve the effectiveness of the Business continuity management systems (BCMS). Pursuing to make career in Business continuity management systems (BCMS) auditing.   Course Duration: 40 Learning Hours and extended time of exercise & Exam.   Certificate: Those who pass all exercises with 50% at least in each exercise will be awarded with successfully completion certificate with approval of Exemplar Global and a Lifetime validity. Note: Each exercise have 2 retakes, if a candidate fails in all 3 terms, the course will be block there and candidate will have to purchase it again by paying 20% of original price.   Language of Course: English   Pre-Requisites: ISO 22301:2019 awareness training course.

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

This is a very comprehensive introduction to Spring Boot Test, which includes Mockito, JUnit, JSONassert, Spring Data JPA, REST, design pattern, and many more. You will learn to write JUnit tests with Spring Boot and Mockito for RESTful services.