3704 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.

Overview of Medical Terminology Training Join our Medical Terminology Training course and discover your hidden skills, setting you on a path to success in this area. Get ready to improve your skills and achieve your biggest goals. The Medical Terminology Training course has everything you need to get a great start in this sector. Improving and moving forward is key to getting ahead personally. The Medical Terminology Training course is designed to teach you the important stuff quickly and well, helping you to get off to a great start in the field. So, what are you looking for? Enrol now! This Medical Terminology Training Course will help you to learn: Learn strategies to boost your workplace efficiency. Hone your skills to help you advance your career. Acquire a comprehensive understanding of various topics and tips. Learn in-demand skills that are in high demand among UK employers This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Medical Terminology Training. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-To-One Support from a Dedicated Tutor Throughout Your Course. Study Online - Whenever and Wherever You Want. Instant Digital/ PDF Certificate. 100% Money Back Guarantee. 12 Months Access. Process of Evaluation After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement Certificate of Completion - Digital / PDF Certificate After completing the Medical Terminology Training course, you can order your CPD Accredited Digital / PDF Certificate for £5.99.  Certificate of Completion - Hard copy Certificate You can get the CPD Accredited Hard Copy Certificate for £12.99. Shipping Charges: Inside the UK: £3.99 International: £10.99 Who Is This Course for? This Medical Terminology Training is suitable for anyone aspiring to start a career in relevant field; even if you are new to this and have no prior knowledge, this course is going to be very easy for you to understand.  On the other hand, if you are already working in this sector, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements You don't need any educational qualification or experience to enrol in the Medical Terminology Training course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course. Career Path The certification and skills you get from this Medical Terminology Training Course can help you advance your career and gain expertise in several fields, allowing you to apply for high-paying jobs in related sectors. Course Curriculum Module 1 : Human Body Vocabulary with Pictures Module 01: Human Body Vocabulary with Pictures 00:47:00 Module 2 : Equipment, Instruments and Lab Tests Module 02: Equipment, Instruments and Lab Tests 00:19:00 Module 3 : Acronyms and Abbreviation Module 03: Acronyms and Abbreviation 00:36:00 Module 4 : Digestive System Module 04: Digestive System 00:25:00 Module 5 : Cardiovascular System Module 05: Cardiovascular System 00:20:00 Module 6 : Blood and Immunity System Module 06: Blood and Immunity System 00:15:00 Module 7 : Respiratory System Module 07: Respiratory System 00:17:00 Module 8 : Musculoskeletal System Module 08: Musculoskeletal System 00:17:00 Module 9 : Central Nervous System Module 09: Central Nervous System 00:14:00 Assignment Assignment - Medical Terminology Training 00:00:00

Duration 2 Days 12 CPD hours This course is intended for This basic course is for persons needing an introductory knowledge of DB2, and persons preparing for advanced and specialized DB2 education. Overview List and describe the major components of IBM's relational database, DB2 Explain the characteristics of a DB2 table Relate the basic concepts of data modeling Comprehend the processing instructions given to DB2 via simple SQL statements List and describe several ways to build (write) and execute SQL statements List and describe steps needed to imbed SQL statements in an application program Explain some of the functions performed by, and the responsibilities of, database and system administrators Establish a base for more specialized DB2 education This course provides information about the functions of IBM's DB2, a relational database manager which may be installed under a variety of operating systems on many hardware platforms (e.g., z/OS, VM, Linux, UNIX, Windows, etc.) Understanding a Table Identify the advantages of a relational database Define a relation Name the language used to talk to a relational database manager (RDBM) List three characteristics assigned to each column Define the tasks performed by DB2 when running an application Defi Data Modeling and Database Design State the purpose of a business model Identify an Entity-Relational Diagram (ERD) model List several DB2 column data types Identify non-standard column and table names Identify the characteristics of a primary key and a foreign key State the purpose of re How does a User use DB2? List several ways to talk to DB2 List multiple ways to generate an SQL statement List several ways to ADD, REMOVE, or CHANGE table rows List several ways to READ data and produce reports How does a Programmer use DB2? List the steps needed to create a test environment List the necessary steps to coding SQL in a program Describe the purpose of SQL delimiters Describe the purpose of an SQLCA List the steps involved in preparing a program for execution State the differenc What does an Administrator do in DB2? List some of the tasks performed by a DB2 System Administrator: Identifying the DB2 product, Installing DB2, Creating subsystems/instances, databases and table spaces, Authorizing, and Monitoring List some of the tasks performed by a DB2 Database Administ Information Management with DB2 List several planning considerations for distributing data List some of the skills required to successfully distribute data Differentiate between remote unit of work, distributed unit of work, and distributed request List some of the security concerns whe

Master essential skills in medical administration with our comprehensive Medical Secretary Course. From communication skills to medical terminology and billing, this course covers all aspects of the role. Enroll now!

★★ FREE PDF Certificate| PDF Transcript| Student ID| Assessment| Lifetime Access| Enrolment Letter ★★ Explore our comprehensive Health and Social Care course designed to equip you with the knowledge and skills needed for a rewarding career in the healthcare sector. Learn about patient care, community health, medical ethics, and social support systems through interactive modules and hands-on training. Ideal for aspiring healthcare professionals and those looking to enhance their expertise, this course provides a solid foundation for roles in nursing, social work, and healthcare administration. Enroll now to make a meaningful impact on individuals and communities. Ready to make a difference in healthcare? Our Health and Social Care course offers in-depth training on patient care, medical ethics, and community health. Perfect for aspiring nurses, social workers, and healthcare professionals. Start your journey today and help create healthier communities! #Healthcare #SocialCare #CareerInHealthcare #Nursing #SocialWork #CommunityHealth

Pharmacy Assistant and Pharmacy Course Do you want to develop your career as a pharmacy assistant or technician? If yes, ensure that you make a substantial contribution to the UK healthcare system by working as a certified expert Pharmacy Assistant and Pharmacy Course by providing excellent customer service. You will learn everything you need to know in this Pharmacy Assistant and Pharmacy Course to become a Pharmacy Technician and support and stabilise your team. Pharmacy Assistant and Pharmacy Course covers the capacity to counsel, advise, and dispense medical expertise is only one of the crucial duties. Our Pharmacy Assistant and Pharmacy Course will also teach you fundamental medical procedures and prescription writing methods. Also, the duties for stock control and patient confidentiality are covered in this Pharmacy Assistant and Pharmacy Course, along with standard pharmaceutical language. You may reduce dispensing errors in pharmacies and maintain standard operating procedures after finishing this training for Pharmacy Assistant and Pharmacy Course. So why are you waiting? To gain a bit of an advantage on a career in healthcare, enrol in this Pharmacy Assistant and Pharmacy Course. Learning Outcomes After completing this Pharmacy Assistant and Pharmacy Course, the learner will be able to: Understand the requirements needed to be a Pharmacy Assistant and Pharmacy Course understand how to give advice to or interact with customers and patients. Get the skill to quickly prescribe and administer medication. understand how to manage and regulate a medical inventory. Gain a solid understanding of the Standard Operating Procedures and medical assessment in a medical environment. Main Course: Pharmacy Assistant & Technician Course Free Courses are including with this Pharmacy Assistant and Pharmacy Course Course 01: Level 2 Certificate in Understanding the Safe Handling of Medication in Health and Social Care Special Offers of this Pharmacy Assistant and Pharmacy Course This Pharmacy Assistant and Pharmacy Course includes a FREE PDF Certificate. Lifetime access to this Pharmacy Assistant and Pharmacy Course Instant access to this Pharmacy Assistant and Pharmacy Course Get FREE Tutor Support to this Pharmacy Assistant and Pharmacy Course Pharmacy Assistant and Pharmacy Course You can learn about the duties and responsibilities of a Pharmacy Assistant or Technician by enrolling in our course on pharmacy assistants and technicians.You will learn the essential skills of a pharmacy worker in this extensive course on pharmacy assistant and technician, including how to successfully diagnose and counsel patients.Acquiring expertise in the areas of medication prescription and dispensing, stock control, and inventory management will also be acquired.You will also learn about the security procedures and medical health and safety requirements related to authorized drus.Start your career as a pharmacy assistant and technician in the UK by enrolling in this course right now. Who is this course for? Pharmacy Assistant and Pharmacy Course For those who want to work in the medical industry or as pharmacy technicians, this Pharmacy Assistant and Pharmacy Course is appropriate. Requirements Pharmacy Assistant and Pharmacy Course To enrol in this Pharmacy Assistant and Pharmacy Course, students must fulfil the following requirements. To join in our Pharmacy Assistant and Pharmacy Course, you must have a strong command of the English language. To successfully complete our Pharmacy Assistant and Pharmacy Course, you must be vivacious and self driven. To complete our Pharmacy Assistant and Pharmacy Course, you must have a basic understanding of computers. A minimum age limit of 15 is required to enrol in this Pharmacy Assistant and Pharmacy Course. Career path Pharmacy Assistant and Pharmacy Course You will be prepared for a variety of healthcare careers with this Pharmacy Assistant and Pharmacy Course, including: Pharmacist’s Assistant Pharmacy Technician Hospital Clerk Pharmacist

CPD Accredited | Career Oriented Learning Modules | 24x7 Tutor Support | Lifetime Access

Document Control: Complete Document Control Course Online Do you wish to strengthen your document control abilities? If so, you are welcome to enrol in our specially created Document Control Course, which is intended to provide participants an in-depth understanding. You will learn about the advantages of document management as well as the document control lifecycle in this Document Control course. The Document Control course also explains how to make a document control system more efficient. Additionally, the Document Control course places a strong emphasis on the underlying expertise, best practices, and legal ideas related to document control. Following your completion of our Document Control programme, you'll be more efficient at work. Join in our Document Control programme to get the skills you need to become more productive and structured. Learning Outcome of Document Control Course After completing the Document Control, learners will know about: Introduction to document control. The basics of document control. Keep document identification as a Document Control expert. Document classifying, filing & information security for Document Controlling. Document Control also explains documents lifecycle and document distribution. Project document control, prepare final documentation controlling and specifications for Document Control in an organisation. The Document Control course teaches electronic document management systems. Interactions with project teams, engineering teams, managers described in other modules of Document Control course. Special Offers of this Document Control: Complete Document Control Course This Document Control: Complete Document Control Course includes a FREE PDF Certificate. Lifetime access to this Document Control: Complete Document Control Course Instant access to this Document Control: Complete Document Control Course Get FREE Tutor Support to this Document Control: Complete Document Control Course Document Control: Complete Document Control Course Online You will learn the fundamentals of document control as well as how to recognize it in this course on document control. The classification and security of the document management system are also covered in the Document management course. Furthermore, the course on document control has a strong emphasis on the document control lifecycle, legal ideas, best practices, and underlying expertise. After completing our Document Control program, you will be more efficient at creating the final paperwork and management. You may manage teams, engineering, and document control as a document control specialist. Who is this course for? Document Control: Complete Document Control Course Online This Document Control course is open to students without any prior understanding of Document Control. Requirements Document Control: Document Control Course Online To enrol in this Document Control: Complete Document Control Course, students must fulfil the following requirements. To join in our Document Control: Complete Document Control Course, you must have a strong command of the English language. To successfully complete our Document Control: Complete Document Control Course, you must be vivacious and self driven. To complete our Document Control: Complete Document Control Course, you must have a basic understanding of computers. A minimum age limit of 15 is required to enrol in this Document Control: Complete Document Control Course. Career path Document Control: Complete Document Control Course Online Training in Document Control: Complete Document Control is a special chance to develop important abilities and progress your career.

Overview Gain the core office skills by enrolling in the Office Skills & Management Level 3course. No matter which industry you work in, office skills and management techniques is a must for everyone. This expert-designed Office Skills & Management Level 3 course will teach you core competencies in business writing, professional communication and organisational skills and more. It will provide ambitious professionals like you with all the fundamental abilities you need to have a successful career.So feed your passion for learning and reach the top of the career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this Office Skills & Management Level 3. It is available to all students, of all academic backgrounds. Requirements Our Office Skills & Management Level 3 is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 12 sections • 54 lectures • 19:19:00 total length •Personal Assistant: 01:23:00 •Admin Support: 01:54:00 •Administrative Management: 01:00:00 •Organisational Skills: 01:16:00 •Telephone Etiquette: 01:07:00 •Business Writing: 01:24:00 •Time Management: 01:09:00 •Body Language and Effective Communication: 01:23:00 •Meeting Management: 01:24:00 •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 •Create Worksheet Formulas: 00:15:00 •Insert Functions: 00:17:00 •Reuse Formulas and Functions: 00:17:00 •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 •Apply Text Formats: 00:16: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:08:00 •Preview and Print a Workbook: 00:10:00 •Set Up the Page Layout: 00:09:00 •Configure Headers and Footers: 00:07:00 •Manage Worksheets: 00:05:00 •Manage Workbook and Worksheet Views: 00:07:00 •Manage Workbook Properties: 00:06:00 •Customize the User Interface: 00:19:00 •Set PowerPoint 2016 Options: 00:07:00 •Modify Slide Masters and Slide Layouts: 00:16:00 •Add Headers and Footers: 00:05:00 •Modify the Notes Master and the Handout Master: 00:04:00 •Create SmartArt: 00:09:00 •Modify SmartArt: 00:05:00 •Write Math Equations: 00:07:00 •Add Audio to a Presentation: 00:09:00 •Add Video to a Presentation: 00:10:00 •Customize Animations and Transitions: 00:14:00 •Review a Presentation: 00:15:00 •Store and Share Presentations on the Web: 00:06:00 •Annotate a Presentation: 00:07:00 •Set Up a Slide Show: 00:08:00 •Create a Custom Slide Show: 00:03:00 •Add Hyperlinks and Action Buttons: 00:07:00 •Record a Presentation: 00:05:00 •Secure a Presentation: 00:11:00 •Broadcast a Slide Show: 00:07:00 •Create a Video or a CD: 00:08:00 •Assignment - Office Skills & Management Level 3: 00:00:00

Master essential Microsoft Office applications, enhance communication, and develop problem-solving skills with the Microsoft Office Complete Training. Suitable for new entrants and professionals alike, gain practical knowledge, expert guidance, and a CPD certificate for career advancement.