• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

1076 Logic courses in Leeds delivered Online

Introduction Perl Programming Essentials (TT4925)

By Nexus Human

Duration 4 Days 24 CPD hours This course is intended for This course is appropriate for anyone who wants to create applications or modules to automate and simplify common tasks with Perl. Overview Working within in an engaging, hands-on learning environment, guided by our expert web development, PHP practitioner, students will learn to: Create a working script that gets input from the command line, the keyboard, or a file Use arrays to store and process data from files Create formatted reports Use regular expressions Use the appropriate types of variables and data structures Refactor duplicate code into subroutines and modules What is available in the standard library Use shortcuts and defaults, and what they replace Introduction to Perl Programming Essentials is an Introductory-level practical, hands-on Perl scripting training course that guides the students from the basics of writing and running Perl scripts to using more advanced features such as file operations, report writing, the use of regular expressions, working with binary data files, and using the extensive functionality of the standard Perl library. Students will immediately be able to use Perl to complete tasks in the real world. Session: An Overview of Perl What is Perl? Perl is compiled and interpreted Perl Advantages and Disadvantages Downloading and Installing Perl Which version of Perl Getting Help Session: Creating and running Perl Programs Structure of a Perl program Running a Perl script Checking syntax and warnings Execution of scripts under Unix and Windows Session: Basic Data and I/O Numeric and Text literals Math operators and expressions Scalar variables Default values Writing to standard output Command line arguments Reading from the standard input Session: Logic and Loops About flow control The if statement and Boolean values Using unless and elsif Statement modifiers warn() and die() The conditional construct Using while loop and its variants Using the for loop Exiting from loops Session: Lists and Arrays The list data type Accessing array elements Creating arrays List interpolation Arrays and memory Counting elements Iterating through an array List evaluation Slices and ranges Session: Reading and writing text files File I/O Overview Opening a file Reading text files Writing to a text file Arrays and file I/O Using the <> operator Session: List functions Growing and shrinking arrays The split() function Splitting on whitespace Assigning to literal lists The join() function The sort() function Alternate sort keys Reversing an array Session: Formatting output Using sprintf() and printf() Report formatting overview Defining report formats The write() function Advanced filehandle magic Session: Hashes Hash overview Creating hashes Hash attributes Traversing a hash Testing for existence of elements Deleting hash elements Session: References What is a reference? The two ways to create references References to existing data References to anonymous data Dereferencing scalar, array, and ash references Dereferencing elements of arrays and hashes Multidimensional arrays and other data structures Session: Text and Regular Expressions String length The substr() function The index() and rindex() functions String replication Pattern matching and substitution Regular expressions Session: Raw file and data access Opening and closing raw (binary) files Reading raw data Using seek() and tell() Writing raw data Raw data manipulation with pack() and unpack() Session: Subroutines and variable scope Understanding packages Package and Lexical variables Localizing builtin variables Declaring and calling subroutines Calling subroutines Passing parameters and returning values Session: Working with the operating system Determining current OS Environment variables Running external programs User identification Trapping signals File test operators Working with files Time of day Session: Shortcuts and defaults Understanding $_ shift() with no array specified Text file processing Using grep() and Using map() Command-line options for file processing Session: Data wrangling Quoting in Perl Evaluating arrays Understanding qw( ) Getting more out of the <> operator Read ranges of lines Using m//g in scalar context The /o modifier Working with embedded newlines Making REs more readable Perl data conversion Session: Using the Perl Library The Perl library Old-style library files Perl modules Modules bundled with Perl A selection of modules Getting modules from ActiveState Getting modules from CPAN Using Getopt::Long Session: Some Useful Tools Sending and receiving files with Net::FTP Using File::Find to search for files and directories Grabbing a Web page Some good places to find scripts Perl man pages for more information Zipping and unzipping files

Introduction Perl Programming Essentials (TT4925)
Delivered OnlineFlexible Dates
Price on Enquiry

Mastering Negotiation Skills: Strategies for Successful Outcomes

4.9(27)

By Apex Learning

***Don't Spend More; Spend Smart*** Life Just Got Better This Summer! Save Up To £5,206 and get Hard Copy + PDF Certificates + Transcript + Student ID Card + e-Learning App as a Gift - Enrol Now Tired of browsing and searching for the course you are looking for? Can't find the complete package that fulfils all your needs? Then don't worry as you have just found the solution. Take a minute and look through this 14-in-1 extensive bundle that has everything you need to succeed in Mastering Negotiation Skills: Strategies for Successful Outcomes and other relevant fields! After surveying thousands of learners just like you and considering their valuable feedback, this all-in-one Mastering Negotiation Skills: Strategies for Successful Outcomesbundle has been designed by industry experts. We prioritised what learners were looking for in a complete package and developed this in-demand Mastering Negotiation Skills: Strategies for Successful Outcomescourse that will enhance your skills and prepare you for the competitive job market. Also, our Mastering Negotiation Skills: Strategies for Successful Outcomesexperts are available for answering your queries and help you along your learning journey. Advanced audio-visual learning modules of these courses are broken down into little chunks so that you can learn at your own pace without being overwhelmed by too much material at once. Furthermore, to help you showcase your expertise in Mastering Negotiation Skills: Strategies for Successful Outcomes, we have prepared a special gift of 1 hardcopy certificate and 1 PDF certificate for the title course completely free of cost. These certificates will enhance your credibility and encourage possible employers to pick you over the rest. This Mastering Negotiation Skills: Strategies for Successful Outcomes Bundle Consists of the following Premium courses: Course 01: Influencing and Negotiating Course 02: Facilities Management Level 3 Course 03: Sales Negotiation Training Course 04: Leadership & Management Diploma Course 05: Personal and Networking Skills Course 06: Psychology Advanced Training Course 07: Emotional Intelligence and Human Behaviour Course 08: Dealing With Difficult People Training Course Course 09: Motivation Skills Course 10: Setting and Achieving Goals Course 11: Assertiveness and Self Confidence Development Course 12: Equality and Diversity Course 13: Working Effectively Across Cultures Course 14: Time Management Benefits you'll get choosing Apex Learning for this Mastering Negotiation Skills: Strategies for Successful Outcomes: Pay once and get lifetime access to 14 CPD courses Free e-Learning App for engaging reading materials & helpful assistance Certificates, student ID for the title course included in a one-time fee Free up your time - don't waste time and money travelling for classes Accessible, informative modules designed by expert instructors Learn at your ease - anytime, from anywhere Study the course from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills How will I get my Certificate? After successfully completing the course, you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (For The Title Course) Hard Copy Certificate: Free (For The Title Course) Curriculum of Mastering Negotiation Skills: Strategies for Successful Outcomes Bundle Course 01: Influencing and Negotiating Unit 01: Influencing Influencing Influencing is about helping others understand Your Personality affects how you influence others Influence by Listening Exercise: Your Influencing Inventory Unit 02: Negotiating What is Negotiation? The Drivers of Success in Negotiation Information and Power in Negotiation Exercise: Prepare to Negotiate Successful Negotiation The Importance of Rapport Questions in Negotiation Reducing Stress in Negotiation Exercise: Examine your Trust Profile Bringing the Negotiation to a Close Dealing with Deadlock Negotiating Online Specific Negotiation Scenarios More Negotiation Scenarios The Negotiator's Toolkit Course 02: Facilities Management Level 3 Module 01: Introduction to Facility Management Module 02: Space Management Module 03: Managing Workplace Services Module 04: Human Resource and Contract Management Module 05: Lease Purchase and Vendor Management Module 06: Health and Safety at Work Module 07: Sustainable Facility Management Module 08: Maintenance and Repairs Module 09: Project Management Module 10: Business Development and Succession Planning Course 03: Sales Negotiation Training Sales Negotiation Training The Mind Of A Consultant Mastering Sales Is Mastering Life Skills The Continuous Journey Universal Laws Of Success The Three Pillars Of Success Personal Honesty Diligence Deferred Gratification Suppression Of Principle Emotional Intelligence Core Principles Of Emotional Intelligence The Problem Is Internal The Two Motivational Forces Product Confidence Negotiation Station - How To Negotiate Successfully The Negotiation Station Core Principles Of Negotiation Focusing On Them Everyone Has To Win Matching Values The Path Of Least Resistance Shifting The Weight The Persuasion Secret How To Persuade Someone The Electric Car The Fashionable Trainers Competency Levels Assessing Competency Levels Features Benefits And Values The Christmas Tree Negotiation B2B Value Propositions Deepening The Value Over Decorating The Tree The Big 12 Authority Social Proof Group Identity Deflecting Fault Ask For Advice Compliment Their Negotiations Reciprocity Scarcity Off Set Values Stepped Commitments Fear And Hope Ranked Priorities Negotiating A Price The Market Price The Anchor Price The Walk Away Price The First Offer The Counter Offer Activities To Complete Negotiation Skills Course 04: Leadership & Management Diploma Understanding Management and Leadership Leadership Theories Improving Management and Leadership Performance High Performance Teams Motivating Employees Organisational Skills Talent Management Succession Planning Business Process Management Communication Skills Negotiation Techniques Managing Meetings and Giving Feedback Managing Change Time Management Stress Management Emotional Intelligence in Leadership Managing Conflict Dealing with Office Politics Risk Management Corporate Responsibility and Ethics Course 05: Personal and Networking Skills Why Is Networking Powerful? Networking Paradigm Shifts You've Got To GIVE To GET The Power Of 'Likeability' Making The Connection Great Places To Network The Power Of Mentors Course 06: Psychology Advanced Training Intro By Prof. Paul - WHY This Course is SO Important To Your Life! Goals & Fundamentals Understanding HOW Feelings Work & How You Can USE This! 'The Imprint Period' - How You Were Created - How You Were Programmed The Amazing Truth About Values & Beliefs Do You Know The Difference Between Reality & Lies? Are You Sure? Personal Illusions That Are Holding You Back - Break Free! EGO - The Great Deceiver The Inner-Critic … How To WIN The INNER Battle Understanding Self-Image & Your Multiple Minds How To Defeat The PAST & The FUTURE Emotional Reasoning & Logic Systems - How To WIN! Understanding & Meeting Your Needs - The Hidden Secrets Understanding Motivation - The Ultimate Driving Force Defeat This Major Block …. And Free Your Mind! Discover 'The Source & Solution To All Your Problems' Agenda & Lies - How They impact Your Life Gambits - Games People Play Break Free From The Problems of 'Attachment' & 'The Sheep Mentality' 'The Dirty Secret Of Psychology' & How To Free Yourself! Tap Into The Power Of The Unconscious Mind How To Control Your Own Mind - And WHY Almost Nobody Does! Why FEAR Dominates Our Lives & How To Beat it! Final Thoughts, Tips & Suggestions To Radically Improve Your Life Course 07: Emotional Intelligence and Human Behaviour Module 01: Human Behaviour and Basic Psychological Process Module 02: Evolutionary Perspective of Human Behaviour Module 03: Human Intelligence Module 04: Intelligence Test and Variations in Intelligence Module 05: Learning and Conditioning Module 06: Language and Communication Module 07: Introduction to Emotion Module 08: Emotion Influences Cognition Module 09: Stress, Anger and Conflict Module 10: Emotional Intelligence Module 11: Self-Leadership Module 12: Neuro-Linguistic Programming (NLP) Course 08: Dealing With Difficult People Training Course Module 01: Difficult Promo Module 02: Fundamentals Module 03: Foundational Tips and Tools Module 04: Difficult People - Relationships Module 05: Difficult People - Solutions Module 06: Problem - Solving Module 07: Final Notes and Tips Module 08: Bonus Video - dealing With Emotions & Anger Course 09: Motivation Skills Introduction Motivational Skills Motivational Strategies Conclusion Course 10: Setting and Achieving Goals Module 01: Introduction to Setting and Achieving Outcomes Module 02: Another angle to the SMART Framework Module 03: Plan to achieve your Outcomes Module 04: Keeping Motivated Module 05: Bonus Module 06: The Project Course 11: Assertiveness and Self Confidence Development Self Confidence Introduction Ways to Find Yourself Positive Mindset vs Negative Mindset Do it, Feel it and Achieve it Believe it and Achieve it ESTEEM SELF ANALYSIS STILL STRUGGLING TO FIND AND TO BE CONFIDENT Course 12: Equality and Diversity Module 01: Introduction to Equality, Diversity and Discrimination Module 02: Equality and Diversity Legislation Module 03: Integrating Equality and Diversity into Policy Module 04: Human Rights Module 05: Promoting Diversity and Social Inclusion Module 06: Equality Analysis Module 07: Links between Values, Attitudes and Beliefs Module 08: Basics of Discrimination Module 09: Stereotypes, Prejudice, Discrimination and Bias Module 10: Institutional Discrimination Module 11: Unconscious Bias Module 12: Affirmative Action Module 13: Monitoring Equality and Diversity Course 13: Working Effectively Across Cultures Section 1: Introduction Section 2: Cultural identity Section 3: OBSERVE Section 4: Learn Section 5: APPLY Section 6: More practical TIPS Section 7: Wrap up Course 14: Time Management Identifying Goals Effective Energy Distribution Working with Your Personal Style Building Your Toolbox Establishing Your Action Plan CPD 140 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Mastering Negotiation Skills: Strategies for Successful Outcomesbundle. Persons with similar professions can also refresh or strengthen their skills by enrolling in this course. Students can take this course to gather professional knowledge besides their study or for the future. Requirements Our Mastering Negotiation Skills: Strategies for Successful Outcomesis fully compatible with PC's, Mac's, laptops, tablets and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so that 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 Having this various expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included

Mastering Negotiation Skills: Strategies for Successful Outcomes
Delivered Online On Demand
£65

The Complete Solidity Course - Zero to Advanced for Blockchain and Smart Contracts

By Packt

This comprehensive Solidity course is designed for individuals seeking to expand their understanding of Ethereum, blockchain, and smart contract development. Whether you are an aspiring blockchain developer or an Ethereum enthusiast, this course covers all the essential topics including Solidity programming, DApp development, cryptocurrency, and more.

The Complete Solidity Course - Zero to Advanced for Blockchain and Smart Contracts
Delivered Online On Demand16 hours 21 minutes
£82.99

Arduino OOP-Object-Oriented Programming

By Packt

Learn to program Arduino using object-oriented programming (OOP) principles in this comprehensive course. Develop efficient and organized Arduino code for any hardware component or functionality. A project-based practical course that will help you build an entire Arduino project from start to finish.

Arduino OOP-Object-Oriented Programming
Delivered Online On Demand4 hours 20 minutes
£41.99

Diploma in Spiritual & Mental Development

4.3(43)

By John Academy

Are you interested in dealing with your spiritual development? How about mental development? Are you curious how your spiritual mental development is going? If so, then this diploma course will help you and your needs. Description: Considering your practices, convictions, contemplation and so forth and transforming those agnostic musings into helpful implies that you are propelling yourself to exchange. Handle what is overloading your mental, physical, and spiritual states. Take the terrible dilemma and direct it into something suitable. A little diversion to your circumstance now and again, affiliation play does an incredible arrangement for our psyche, soul, and body. You also have to bear in mind that spiritual is your arrangement of convictions, standards, values, ethics, benchmarks, and so on. Attempt to avoid over being invigorated. Build up your interests, convictions, ethics, measures, standards, values, exercises, fellowships and begin figuring out how to carry on with the enthusiastic torment to demand to vanquish your own inconveniences and further settle your reasoning propensities. Advancing overthrow will put you making progress toward accomplishment by setting aside the opportunity to build up your abilities, inspiration, and so on. You need to develop inborn status, re-establishing your faculties back to its unique states to feel your spiritual, mental, and physical being feel restored that you will be able to understand in this course. Who is the course for? Anyone regardless if they have prior knowledge or not in spiritual and mental health development Anyone who thinks they possess a maturity to reflect their own development as a person, both mentally and spiritually. 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 a cost of £39 or in PDF format at a 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 Diploma in Spiritual Mental Development will be very beneficial and helpful, especially to health and mental-related careers like: Clinical Psychologists Counsellors Mental Health Experts Music Therapists Psychologists Psychotherapists And Much More! Module-1 Introduction 00:15:00 Understanding your Mental and Physical Mind to Development of Self Spiritual 00:30:00 Spiritual Acceleration Mental Learning in Physical Self Development 00:15:00 Physical Acceleration Mental Learning in Spiritual Self Development 00:30:00 Self Development through Speed Learning in Mental Physical and Spiritual Awakenings 00:30:00 Motivation Self Development Techniques for Mental Physical and Spiritual States 01:00:00 Module-2 Self Development in Improving Mental Physical and Spiritual High Court 00:30:00 Growing in Mental Physical Spiritual through Self Development 00:30:00 Relationships in Self Development of Mental Physical and Spiritual States 00:30:00 Planning your Future in Mental Physical and Spiritual Self Development 01:00:00 Benefiting from Subliminal Mental Physical and Spiritual Self Development 00:30:00 Benefiting from Mind Attitude Fleshly and Spiritual Aplomb Development 00:30:00 Module-3 Innate Mental Physical and Spiritual Self Development Intimate Positive self-image in Personality Physical and Glorified Inner strength Development 01:00:00 Self Development Tactics in Mental Physical and Spiritual Subliminal Training 01:00:00 Concentrating on Self Development of Mental Physical and Spiritual Improvement 00:30:00 Suggestology in Self Development of Spiritual Mental and Physical States 00:30:00 Optimism Strengths in Self Development of Mental Spiritual and Physical States 00:15:00 Self Development of Awareness in Mental Spiritual and Physical Learning 01:00:00 Module-4 Routine Self Development in Mental Spiritual and Physical Recovery 00:30:00 Viewpoints in Mental Spiritual and Physical Self Development 00:15:00 Breaking Down Mental Spiritual and Physical Self Development 00:15:00 Logic in Mental Spiritual and Physical Self Development 00:15:00 Aspects in Mental Spiritual and Physical Self Development 00:15:00 Emotions in Development Mental Spiritual and Physical Self 00:15:00 Module-5 Self Development of Mental Spiritual and Physical Meditation 00:15:00 Development of Mental Untainted and Physical Self 00:15:00 Battle Common Problems in Mental Spiritual and Physical Self Development 00:30:00 Exploring the Past in Mental Spiritual and Physical Self Development 00:15:00 Reducing Stress in Mental Spiritual and Physical Self Development 01:00:00 Reviewing You in Mental Spiritual and Physical Self Development 00:15:00 Module-6 Discovering Humanity in Mental Spiritual and Physical Self Development 01:00:00 Self-Headway Tactics in Mind Physical and Spiritual 00:15:00 Mental Structures in Physical and Spiritual Self Development 00:30:00 Mental Spiritual and Physical Self Development Processes 00:15:00 Unzipping the Subliminal in Mental Spiritual and Physical Self Development 00:15:00 Beneficial of Positive Mental Spiritual and Physical Self Development 00:30:00 Module-7 Success in Mental Spiritual and Physical Self Development 00:15:00 Abolishing the Master of Failure in Mental Spiritual and Physical Self Development 00:15:00 Suggestions in Mental Spiritual and Physical Self Development Suggestions 00:15:00 Hypnosis in Mental Spiritual and Physical Self Development 00:15:00 Thinking Processes in Mental Spiritual and Physical Self Development 00:15:00 Mental Power in Spiritual and Physical Self Development 00:15:00 Module-8 Optimising your Power to Mental Spiritual and Physical Self Development 00:30:00 Diaries of the Mind in Mental Spiritual and Physical Self Development 00:15:00 Persuading Resources in Mental Spiritual and Physical Self Development 00:15:00 Building Inner Strengths in Mental Spiritual and Physical Self Development 00:15:00 Reforming your Mental Spiritual and Physical Self through Development 00:15:00 Brain Enhancers in Mental Spiritual and Physical Self Development 00:30:00 Module-9 Innate Relaxation Control to Mental Spiritual and Physical Self Development 00:15:00 Enhancing Techniques in Mental Spiritual and Physical Self Development 00:15:00 Holistic Training in Mental Spiritual and Physical Self Development 00:30:00 Commonsense Practices in Mental Spiritual and Physical Self Development 00:15:00 Conclusion 00:15:00 Mock Exam Mock Exam- Diploma in Spiritual & Mental Development 00:20:00 Final Exam Final Exam- Diploma in Spiritual & Mental Development 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Diploma in Spiritual & Mental Development
Delivered Online On Demand23 hours 25 minutes
£23.99

Complete Python Course with 10 Real-World Projects

By Packt

This beginner's course exclusively delivers Python programming from basic to advanced. You will learn Python concepts in real-life programming examples by building real-world applications. Learn the syntax of Python language and understand the logic behind the programming process to create your Python programs successfully and master Python coding.

Complete Python Course with 10 Real-World Projects
Delivered Online On Demand27 hours 7 minutes
£82.99

PostgreSQL for Database Developers (TTDB7024)

By Nexus Human

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.

PostgreSQL for Database Developers (TTDB7024)
Delivered OnlineFlexible Dates
Price on Enquiry

Django A-Z: Build and Deploy Web Application with Python and Django

By Packt

Are you eager to learn Django and build real web applications? Do you want to gain hands-on experience with Python, Django, and Git? Look no further! This beginner-friendly course has got you covered. Discover the secrets of Django applications, templates, models, and migrations as we guide you through the process step-by-step. Tired of struggling with deployment? We will show you how to deploy your applications on a Railway Server effortlessly.

Django A-Z: Build and Deploy Web Application with Python and Django
Delivered Online On Demand7 hours 1 minutes
£131.99

Become a Confident RPA UiPath Developer - Build Real-World Projects

By Packt

Supercharge your career with our comprehensive RPA UiPath developer course and dive into real projects to master UiPath, gain unwavering confidence, and pave your way to success. Elevate your career prospects with access to an extensive resource of 100+ RPA UiPath interview questions and become a highly proficient RPA expert today.

Become a Confident RPA UiPath Developer - Build Real-World Projects
Delivered Online On Demand15 hours 20 minutes
£67.99

SwiftUI and Node.js Full Stack - Build Twitter - iOS 16

By Packt

Do you want to create outstanding apps with SwiftUI? Moreover, are you eager to build up your professional portfolio and show up in your next job interview with confidence? This complete iOS application development course is designed to teach you how to become an advanced multiplatform app developer using Apple's native user interface framework: SwiftUI.

SwiftUI and Node.js Full Stack - Build Twitter - iOS 16
Delivered Online On Demand21 hours 13 minutes
£59.99