3198 Courses in Leeds delivered Online

Learn how to use Macros in Excel to automate your work and start to see the power these can give you. Course overview Duration: 1 day (6.5 hours) Our Excel – Working with Macros course aims to show how macros can be used to automate commonly used commands and processes. This course is designed for existing experienced users of Excel. You should be confident creating and manipulating Excel spreadsheets and creating formulas before attending this course. Objectives By the end of the course you will be able to: Record and run macros Navigate within the Visual Basic Environment Edit pre-recorded macros Create your own functions Content Recording macros Accessing the Developer Tab Naming conventions and storage locations Recording macros Absolute and relative cell addressing Running macros Assigning macros to the Quick Access Toolbar Assigning macros to objects Creating new tabs Workbook macros Recording macros in a specific workbook Saving the workbook as an Excel Macro-Enabled Workbook Creating quick access items specific to workbooks Importing and manipulating data Importing Delimited Text Files Importing Fixed Width Text Files The Visual Basic environment Project explorer Code window Properties window Renaming modules Deleting modules Working with code Code structure Adding comments Navigating within your code Editing macro code Getting help with syntax Debugging Errors Using debug Function procedures Creating function macros

Uncovering Emotional Root Causes of Health Challenges Instructor Craig Weiner, DC, Licensed MetaHealth Foundation Trainer, EFT Master Trainer of Trainers. Learn to apply a method of analysis that effectively guides the application and integration of EFT, Matrix Reimprinting and other alternative healing modalities you may already currently use for yourself and on your clients. Discover how symptoms and disease are actually an intelligent process that is the body’s attempt to heal stress and trauma. With this knowledge, fear can be greatly reduced and a therapeutic intervention can then be utilized in a more precise way. You and your clients will achieve results faster and will be amazed at the insights, connections and progress they make in their healing journey. META-Health is the science, practice and art of Body-Mind-Social Health with a focus on how specific stress triggers, emotions and beliefs affect specific organ symptoms. META-Health is a methodology based on Integrative Medicine and Prevention and is practiced by all types of health professionals interested in a precise and effective Body-Mind-Social analysis and approach towards most effectively supporting individuals working to find emotional and physical healing. Your trainer for this Foundation weekend will be Craig Weiner, who has worked in the complementary health care field for over 30 years. He brings his professional clinical experience, his years as an educator and certified trainer in the Emotional Freedom Techqniques and Matrix Reimprinting and as a licensed META-Health Foundation Trainer. In the Foundation Course you will get the overview of the META-Health concepts and its implications for self-healing, assistance in transforming disease, and achieving sustainable health and resilience, including: Rhythms of life, and the organism’s self-regulating intelligence How the bio-logical needs change your perception and create life strategies How to decode the language of your organs Recognize the key points and phases of the healing process Experience the powerful META-Analytics questions Use the 8 milestones of META-Health to address the whole system and its soil Find META-meanings to create resilience Demonstrations and practical exercises will lead you to deeply integrate the wisdom of your body, and inspire you to actively claim and support your health. You will understand the natural, dynamic path of healing, and be empowered to lift your – and others’ – consciousness to make use of our potential! During this weekend we will spend time reviewing the core META-Health Principles: Our body-mind is highly intelligent Bio-logical survival and stress strategies, regeneration and resilience are at play in our brain, nervous system and hormonal system Significant emotional experiences shape our beliefs, personality and lifestyle Specific individual stress triggers influence typical organ tissues and functions The cycle of stress, regeneration and learning goes through distinct points and phases Awareness and imagination are capabilities of our brain which can recreate meaning and reprogram body-mind’s reactions There is no pre-requisite to taking this weekend course. Anyone who is interested can participate in the META-Health Foundation Training. The Foundation Training is the first step in becoming a certified META-Health Practitioner. Times: The course is a 12 hours training and will be held from 9:00 to 4:00 Seattle/Pacific time on both Friday and Saturday with a 60 minute lunch break held at approximately 12:30pm.

Get your Award for Personal Licence Holders qualification here with us at Knight Training! The Scottish Personal Licence Holders certificate (SCPLH) is the prerequisite for you to get your Personal Licence, aimed at anyone who wishes to sell or authorise the sale of alcohol. The course is a legal requirement, and it basically runs through the responsibilities that one must know in order to sell alcohol in a designated premises. Here at Knight Training we welcome our customers with open arms and provide the best service possible. Why waste more time? Call us now on 01524 388279 to get your SCPLH today!

Overview This comprehensive course on Swift: Mac and iOS Development will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Swift: Mac and iOS Development comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? At the end of the course there will be an online written test, which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price. Who is This course for? There is no experience or previous qualifications required for enrolment on this Swift: Mac and iOS Development. It is available to all students, of all academic backgrounds. Requirements Our Swift: Mac and iOS Development is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 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 Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 8 sections • 24 lectures • 01:10:00 total length •Introduction to This Course: 00:03:00 •What Is Swift?: 00:03:00 •Print: 00:02:00 •Variables: 00:03:00 •Constants: 00:02:00 •Typecasting: 00:02:00 •Adding Variables Into Strings: 00:02:00 •Arrays: 00:05:00 •Conditional Statements: 00:05:00 •For Loop: 00:04:00 •For In Loop: 00:02:00 •While Loop: 00:03:00 •Do While Loop: 00:02:00 •Switch Statement: 00:04:00 •Break Statement: 00:03:00 •Continue Statement: 00:03:00 •Functions: 00:03:00 •Functions Parameters: 00:03:00 •Function Return Statement: 00:03:00 •Classes: 00:05:00 •Class Constructor: 00:04:00 •Enumerations: 00:04:00 •Resource: 00:00:00 •Assignment - Swift: Mac and iOS Development: 00:00:00

Sale Ends Today Office Management for Professional Secretary Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Step into the centre of action where every decision you make impacts the flow and success of the business. Reportedly, skilled office managers can increase workplace productivity by up to 40%. The Office Management for Professional Secretary course bundle equips you with more than just the essentials; it transforms you into the strategic backbone of your workplace. This is where ambitious professionals become the orchestrators of efficiency and innovation in their offices, across any industry in the UK. Join in this immersive learning experience with the Office Management for Professional Secretary course. This program covers everything from the core competencies of effective Office Administration to advanced skills in managing complex projects and corporate events. You'll learn to navigate through tasks with precision in courses like Secretary & PA Diploma and Administration: Office Administration, while developing critical leadership skills in Inspirational Leadership Skills and Change Management. This curriculum is designed to refine your professional abilities, ensuring you can excel in both your daily responsibilities and long-term career goals. Courses Are Included in this Bundle: Course 01: Office Management for Professional Secretary Course 02: Legal Secretary Course 03: Administration: Office Administration Course 04: Office Skills Course 05: Receptionist Diploma Course 06: Professional Certificate in Front Office Course 07: Professional Skills for Hotel Management Training Course 08: Level 5 Diploma in Business Management Course 09: Corporate Paralegal Course 10: Business Plan for Entrepreneurs Course 11: Agile Project Management Course 12: Workplace Performance Management Course 13: Diploma in Operations Management Course 14: Research Methods in Business Course 15: Strategic Business Management Course 16: Change Management Course 17: Business Improvement Course 18: International Business Principles Course 19: Level 3 Diploma in Business Etiquette Course 20: Effective Communication Skills Diploma Course 21: Assertiveness Skills Course 22: Time Management Course 23: Public Speaking: Presentations like a Boss Course 24: Email Writing Training Course 25: Customer Service Management: Recovering Difficult Customers Course 26: Transcription Skills Course 27: Business Networking Skills Course 28: Document Control and Workflow Management Course 29: Diary Management Course 30: Touch Typing Complete Training Diploma Enrol in the Office Management for Professional Secretary bundle today and start your transformation into an office management expert. With skills that transcend ordinary administrative tasks, you will open new doors to career advancement and personal growth. Don't just be part of the office-become the reason it succeeds. Start your journey now and forge your path to becoming an essential asset to any business! Learning Outcomes of this Bundle: Cultivate advanced organisational and management skills essential for top-tier secretaries. Develop strategic abilities for handling complex administrative functions. Elevate your communication prowess to effectively liaise with all company levels. Harness project and time management skills to boost office productivity. Strengthen negotiation and conflict resolution skills within a corporate setting. Master the art of professional networking and relationship management. Why Prefer This Office Management Course? Opportunity to earn a certificate endorsed by the Quality Licence Scheme & another accredited by CPD QS after completing the course Get a Free Student ID Card with this training program (£10 postal charge will be applicable for international delivery) The course is Affordable and Simple to understand Get Lifetime Access to the course materials The training program comes with 24/7 Tutor Support Start your learning journey straight away! The Office Management for Professional Secretary course is designed to transform capable individuals into exceptional office managers and secretaries, well-versed in the nuances of modern business administration. By cultivating advanced organisational and management skills, this course prepares participants to oversee complex operations and workflows with ease. This foundational prowess is critical for anyone aspiring to excel in top-tier administrative roles, where precision and efficiency are essential. Participants will also develop strategic abilities for handling complex administrative functions, enhancing their capacity to manage diverse tasks ranging from scheduling and coordination to managing corporate documents. Coupled with the ability to elevate your communication prowess, this training ensures that you can effectively liaise with all levels of company staff and external partners, making you an indispensable link within your organisation. Moreover, this diploma offers learners the opportunity to acquire skills that are highly valued in the field of Professional Secretary. With this Certification, graduates are better positioned to pursue career advancement and higher responsibilities within the Professional Secretary setting. The skills and knowledge gained from this course will enable learners to make meaningful contributions to Professional Secretary related fields impacting their Professional Secretary experiences and long-term development. Course Curriculum Course 01: Office Management for Professional Secretary Module 01: Personal Assistant Module 02: Admin Support Module 03: Organisational Skills Module 04: Telephone Etiquette Module 05: Business Writing Module 06: Time Management Module 07: Body Language and Effective Communication Module 08: Meeting Administration Course 02: Legal Secretary Module 01: Understanding the Concept of Paralegal Module 02: Key Legal Terminology Module 03: Effective Communication Skills for Paralegals Module 04: The Legal Workplace &#038; Professionals Module 05: Law & Legal Systems Module 06: Contract & Business Law Module 07: Property Law Module 08: Wills, Probate, Estate Law Module 09: Criminal Law Module 10: Common Paralegal Legal Matters Module 11: Human Rights Module 12: Conflict and Conflict Resolution Module 13: Professional Conduct and Ethics of Paralegals Module 14: Mandatory Knowledge Fields and Survival Tips for Paralegals Course 03: Administration: Office Administration Module 01: Introduction to Office Administration Module 02: Skills of an Effective Administrator Module 03: Business Etiquette Module 04: Business Telephone Skills Module 05: Mail Services and Shipping Module 06: Travel Arrangements Module 07: Organising Meeting and Conferences Module 08: Record Keeping and Filing Systems Module 09: Effective Planning and Scheduling Module 10: Invoicing/Petty Cash Module 11: Business Writing Skills Module 12: Time Management Module 13: Organisational Skills Module 14: Communication Skills Module 15: Negotiation Techniques Module 16: Conflict Management =========>>>>> And 27 More Courses <<<<<========= How will I get my Certificate? After successfully completing the course, you will be able to order your Certificates as proof of your achievement. PDF Certificate: Free (Previously it was £12.99*30 = £390) CPD Hard Copy Certificate: Free (For The First Course: Previously it was £29.99) CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this bundle. This bundle is ideal for: Ambitious administrative professionals. Current office managers. Emerging team leaders. Career-focused secretaries. Executive assistants seeking advancement. Administrative staff upgrading skills. Requirements You will not need any prior background or expertise to enrol in this course. Career path After completing this bundle, you are to start your career or begin the next phase of your career. Executive Secretary: $35,000 - $65,000 Senior Administrative Assistant: $32,000 - $58,000 Chief of Staff: $50,000 - $100,000 Operations Manager: $40,000 - $75,000 Business Administrator: $36,000 - $68,000 Client Relations Manager: $40,000 - $75,000 Certificates CPD Accredited Digital Certificate Digital certificate - Included CPD Accredited e-Certificate - Free Enrolment Letter - Free Student ID Card - Free CPD Accredited Hard Copy Certificate Hard copy certificate - Included Please note that International students have to pay an additional £10 as a shipment fee.

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents, and interests with our special Advanced Diploma in PHP Web Development with MySQL, GitHub & Heroku Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides the professional training that employers are looking for in today's workplaces. The Advanced Diploma in PHP Web Development with MySQL, GitHub & Heroku Course is one of the most prestigious training offered at Skillwise and is highly valued by employers for good reason. This Advanced Diploma in PHP Web Development with MySQL, GitHub & Heroku Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Advanced Diploma in PHP Web Development with MySQL, GitHub & Heroku Course, like every one of Skillwise's courses, is meticulously developed and well-researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At Skillwise, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from Skillwise, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Advanced Diploma in PHP Web Development with MySQL, GitHub & Heroku? Unlimited access to the course forever Digital Certificate, Transcript, and student ID are all included in the price Absolutely no hidden fees Directly receive CPD-accredited qualifications after course completion Receive one-to-one assistance every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Advanced Diploma in PHP Web Development with MySQL, GitHub & Heroku there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for free. Original Hard Copy certificates need to be ordered at an additional cost of £8. Who is this course for? This Advanced Diploma in PHP Web Development with MySQL, GitHub & Heroku course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skills. Prerequisites This Advanced Diploma in PHP Web Development with MySQL, GitHub & Heroku does not require you to have any prior qualifications or experience. You can just enroll and start learning. This Advanced Diploma in PHP Web Development with MySQL, GitHub & Heroku was made by professionals and it is compatible with all PCs, Macs, tablets, and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as a bonus, you will be able to pursue multiple occupations. This Advanced Diploma in PHP Web Development with MySQL, GitHub & Heroku is a great way for you to gain multiple skills from the comfort of your home. Unit 01: Introduction Introduction 00:06:00 Unit 02: Environment Configuration Module 01: Setup a PHP Environment using XAMPP 00:16:00 Module 02: Install Composer Package Manager 00:03:00 Module 03: Visual Studio Code - Web Development Add ons 00:12:00 Module 04: Create a GitHub Account 00:13:00 Module 05: Create a Heroku Account 00:08:00 Unit 03: PHP Basics and Syntax Module 01: How PHP Works 00:29:00 Module 02: IF...ELSE Statements 00:19:00 Module 03: Switch Statements 00:09:00 Module 04: FOR Loop 00:10:00 Module 05: WHILE AND DO...WHILE Loops 00:14:00 Module 06: PHP Arrays and Manipulation 00:13:00 Module 07: String Manipulation Functions 00:28:00 Module 08: Date and Time Manipulation Functions 00:15:00 Module 09: User Defined Functions 00:22:00 Module 10: PHP Include and Require 00:22:00 Module 11: PHP Website Layout - With Bootstrap 00:23:00 Module 12: Add Project to Github 00:08:00 Module 13: Publish Website to Heroku 00:20:00 Unit 04: PHP Forms and MySQL and User Authentication Module 01: Project and Website Setup 00:21:00 Module 02: Create a Bootstrap 4 Form 00:28:00 Module 03: PHP Form - $_GET Action 00:23:00 Module 04: PHP Form - $_POST Action 00:11:00 Module 05: Design Database with phpMyAdmin 00:19:00 Module 06: Connect to Database using PHP PDO 00:18:00 Module 07: Save Records to Database 00:38:00 Module 08: View Database Records 00:36:00 Module 09: View One Record's Details 00:28:00 Module 10: Update Database Records 00:34:00 Module 11: Delete Database Records 00:11:00 Module 12: Final Touches: Form Validation, Error Messages, Success Messages 00:17:00 Module 13: Create Heroku App and Remote Database 00:21:00 Module 14: Setup Authentication Tables in Database 00:20:00 Module 15: Setup Login and Authentication 00:29:00 Module 16: Control User Access 00:08:00 Module 17: Sending Confirmation Emails 00:31:00 Module 18: Upload Profile Pictures 00:31:00 Module 19: Final Touches 00:14:00 Resources Resources - Modern PHP Web Development w/ MySQL GitHub & Heroku Assignment Assignment - Advanced Diploma in PHP Web Development with MySQL, GitHub & Heroku 10:13:00 Certificate Order Your Certificate QLS

Description: Computer programming is the practice where using the original formulation of computing of a computing problem turns into a computer program. If you want to learn about computer programming, you need to take training or enroll in an institution. This course will provide you with the lessons you need to know about computer programming. By the end of this course, you will be able to handle issues in computer programming and learn the concepts easily. In this course, you will learn necessary skills, information, and knowledge of computer programming.  Who is the course for? Intermediate level users who want to acquire or upgrade their programming skills People who have the interest to learn more about programming Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The Computer Programming Intermediate Level is a very useful qualification to possess, and will be very helpful to have especially for these careers: Computer Maintenance Staff IT Department Manager IT Specialists Computer Engineer Computer Specialist Programmers. Computer Programming at a Glance COMPUTER PROGRAMMING AT A GLANCE 01:00:00 UNDERSTANDING THE LANGUAGE OF THE COMPUTER 00:30:00 Choosing a Language 00:30:00 Basic Programming Language BASIC Programming Language 01:00:00 Getting Started with BASIC Programming Language 01:00:00 BASIC Overview of BASIC Components 01:00:00 BASIC Special Variables 01:00:00 BASIC Probability Functions 01:00:00 Filtering the Data Set or Splitting the Data Set 01:00:00 DATA Blocks 01:00:00 DELETE Statement 01:00:00 FORNEXT Statement 01:00:00 IF. . . THEN Statement 01:00:00 PHP Programming Welcome to the world of programming! 00:30:00 Getting Started 01:00:00 Let's Start Coding! 01:00:00 PHP Strings 01:00:00 PHP Variables 01:00:00 Useful Variables 00:30:00 PHP Includes & Problem Solving 01:00:00 Tip When Creating Inc Pages 00:30:00 Redirecting Using PHP 00:30:00 Multiple Conditions 01:00:00 PHP Arrays 01:00:00 PHP Loops 01:00:00 Note on PHP Math Functions: 00:30:00 Functions 01:00:00 PHP Sessions 00:30:00 Cookies 01:00:00 Introduction to MySQL 01:00:00 Making The Connection 01:00:00 Inserting Data 01:00:00 Deleting / Removing Data 00:15:00 Mock Exam Mock Exam- Computer Programming Intermediate Level 00:30:00 Final Exam Final Exam- Computer Programming Intermediate Level 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Assembly is the foundation for all applications, mobile to desktop. It is used in Raspberry Pi, Arm, Intel and much more

Duration 3 Days 18 CPD hours This course is intended for Students in this course are experienced AWS developers interested in Azure development. A three-day course designed to teach AWS (Amazon Web Services) developers how to prepare end-to-end solutions in Microsoft Azure. In this course you will construct Azure App Service Web App solutions and Azure Functions, use blob or Cosmos DB storage in solutions, implement secure cloud solutions that include user authentication and authorization, implement API management, and develop event- and message-based solutions, and monitor, troubleshoot, and optimize your Azure solutions. You will learn how developers use Azure services, with additional focus on features and tasks that differ from AWS, and what that means for you as you develop applications that will be hosted by using Azure services Create Azure App Service Web Apps Azure App Service core concepts Creating an Azure App Service Web App Configuring and Monitoring App Service apps Scaling App Service apps Azure App Service staging environments Implement Azure functions Azure Functions overview Developing Azure Functions Implement Durable Functions Develop solutions that use blob storage Azure Blob storage core concepts Managing the Azure Blob storage lifecycle Working with Azure Blob storage Create an Azure Resource Manager Template Develop solutions that use Cosmos DB storage Azure Cosmos DB overview Azure Cosmos DB data structure Working with Azure Cosmos DB resources and data Create and deploy ARM templates Implement user authentication and authorization Microsoft Identity Platform v2.0 Authentication using the Microsoft Authentication Library Using Microsoft Graph Authorizing data operations in Azure Storage Implement secure cloud solutions Manage keys, secrets, and certificates by using the KeyVault API Implement Managed Identities for Azure resources Secure app configuration data by using Azure App Configuration Implement API Management API Management overview Defining policies for APIs Securing your APIs Develop event-based solutions Implement solutions that use Azure Event Grid Implement solutions that use Azure Event Hubs Implement solutions that use Azure Notification Hubs Develop message-based solutions Implement solutions that use Azure Service Bus Implement solutions that use Azure Queue Storage queues Monitor and optimize Azure solutions Overview of monitoring in Azure Instrument an app for monitoring Analyzing and troubleshooting apps Implement code that handles transient faults Additional course details: Nexus Humans AZ-020T00 - Microsoft Azure solutions for AWS Developers 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 AZ-020T00 - Microsoft Azure solutions for AWS Developers 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.

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.