3974 Courses delivered Live Online

Duration 2.5 Days 15 CPD hours This course is intended for This course is intended to help participants learn basic principles and techniques of providing PC, mobile, applications, and network support. Overview Upon successful completion of this course, students will have introductory knowledge of computer systems and mobile devices. In this course, students will identify and set up: computer hardware, software, networks, files, wireless devices and discuss safety. Identifying Computer Hardware Identify Types of Computing Devices Identify Internal Computer Components Common Computer Connector Types Identify Common Peripheral Devices Identifying Computer Software Compare Functions and Features of Common Operating Systems Identify Application Software Setting Up a Basic Workstation Connect Hardware Install and Configure Operating Systems Install and Configure Applications Configure Accessibility Options Configuring Network Access Network Connection Types Install and Configure a SOHO Router Network and Alternative Technologies Sharing and Storage Methods Working with Files, Folders, and Applications Create Files Navigate a File Structure Manage Files and Folders Compress and Extract Files Create Screen Captures Configuring and Using Wireless Devices Configuring Wireless Devices Use Wireless Devices Securing Computing Devices Identify Security Threats Apply Security Best Practices Perform Secure Web Browsing Supporting Computers and Users Environmental and Safety Concepts Back Up and Restore Data Manage Software Implement Basic Support Measures

The need for key staff to have commercial skills is paramount, as the public sector is increasingly opened up as a commercial market, in which organisations compete against each other and the private sector for contracts. Generating additional income and being commercially aware is vital for this to be a success, and is what many public sector organisations are looking to do. This programme will help you: See commercial awareness as not just another skill-set, but as a different mind-set Use a variety of tried-and-tested commercial, analytical decision-making techniques and tools Define your commercial objectives Develop a strategic focus Start looking at service clients as market segments Analyse, in a competitive context, your service offering Plan a commercial strategy, prepare for its implementation and see it through to execution 1 What is commercial thinking? Understand what it means to be a commercial thinker Identifying commercial opportunities often involves not only a different skill set but also a different mindset; looking at the services that you provide 2 Defining strategic commercial objectives Defining your key commercial objectives Prioritising your strategic objectives Two key strategic planning tools:Resource and Competency MatrixPESTLE How to apply these tools to your particular situation 3 Developing a strategic focus Decision-making on how to compete in the markets identified by your strategic objectives requires a strategic focus Developing strategic focus A tool for helping you to make those decisions: using the Ansoff Matrix 4 Defining customer targets How to think more commercially by understanding who all your customers are and how they differ from each other how to apply the principles to your areas to identify the type of customers you have and their key characteristics - Customer segmentation Who are your customers? How do their needs vary? - Scenarios 5 The competitive market place Understanding the competitive forces at play Different types of competition Analysing your competitive environment using Porter's 5 Forces model 6 Meeting stakeholder expectations Two simple models to help you identify the key stakeholders who could influence your commercial environment How to use your stakeholders to help you achieve your commercial objectives 7 Implementation - systems, structures and processes Effective commercial activity involves working with others to implement ideas and strategies What do you need to have in place before you implement your commercial strategy? How to health-check your organisation prior to implementation using the McKinsey 7S framework 8 Implementation - people and culture A good commercial strategy only works if the people involved buy in to the ideas and if the culture of the organisation is conducive to the effective implementation How the latest thinking in behavioural economics can help you develop your culture and people to work commercially 9 Tools and checklists Be more commercial within your sphere of influence using a commercial checklist to help you Using the checklist as a benchmark against the most commercially aware organisations Using the checklist as a health check - both corporately and individually

Duration 2 Days 12 CPD hours This course is intended for This is an intermediate and beyond level SQL course geared for experienced end users, data scientists, business analysts, application developers and database administrators. Students should have recently attended a basic SQL class or have equivalent experience. Overview This course is approximately 50% hands-on, combining expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Our engaging instructors and mentors are highly experienced practitioners who bring years of current 'on-the-job' experience into every classroom. Working in a hands-on learning environment led by our expert practitioner, attendees will learn advanced skills needed to: Advanced Query Techniques Manipulating Table Data Using SQL's Data Manipulation Language (DML) User-Defined Functions Stored Procedures Triggers A company?s success hinges on responsible, accurate database management. Organizations rely on highly available data to complete all sorts of tasks, from creating marketing reports and invoicing customers to setting financial goals. Data professionals like analysts, developers and architects are tasked with creating, optimizing, managing and analyzing data from databases ? with little room for error. When databases aren?t built or maintained correctly, it?s easy to mishandle or lose valuable data. Our SQL Programming and Database Training Series provides students with the skills they require to develop, analyze and maintain data and in correctly structured, modern and secure databases. Next Level SQL explores how to identify and use advanced querying techniques to manipulate and index tables. All hands-on work in this course is ANSI SQL compliant and should work with most SQL databases such as Oracle, SQL Server, MySQL, MS Access, Informix, Sybase, or any other ANSI SQL compliant database. Advanced Query Techniques Join inner outer (Left, Right, Full) Subqueries Simple Correlated Using the Exists Operator Tips for Developing Complex Queries Performing Set Operations Aggregating Results Using Group by Creating Temporary Tables Manipulating Table Data Using SQL's Data Manipulation Language (DML) Inserting Data into Tables Updating Existing Data Deleting Records Truncating Tables Implementing Data Integrity with Transactions Beginning Explicit Transactions Committing Transactions Rolling Back Transactions User-Defined Functions Definition and Benefits of Use CREATE FUNCTION Syntax RETURN Clause and the RETURNS Statement Scalar vs. Table Functions Comparison with Stored Procedures Returning Scalar Values and Tables ALTER and DROP FUNCTION Stored Procedures Definition and Benefits of Use CREATE PROCEDURE Syntax Variables and Parameters Control of Program Flow ALTER and DROP PROCEDURE Implementation Differences Triggers Definition and Benefits of Use Alternatives (e.g., Constraints) CREATE TRIGGER Syntax Trigger Types 'Inserted' (or 'NEW') and 'Deleted' (or 'OLD') Tables Event Handling and Trigger Execution ALTER and DROP TRIGGER Additional course details: Nexus Humans Advanced SQL Programming (TTSQL005) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Advanced SQL Programming (TTSQL005) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Our telephone training takes place in your normal working situation, using the actual telephones and software, and the programming software clients that trainees will use when fully trained. Our trainers will travel anywhere in the world to train you face to face, or if you prefer, we can offer our whole training catalogue remotely using Teams or Zoom. On-site and live remote telecoms training sessions have a general reputation as most effective for trainees to continue to efficiently carry out their telecoms usage, programming and own in-house training of future new employees. On-site training involves employees training at their place of work while they are doing their actual job, or in pre-organised classroom training sessions, based around hands-on interaction, trainer Q&A and all carried out using your own site telephone system. Our telephone trainers also offer consultations on your new or current telephone systems: looking into how you currently use your system, making suggestions on how programming could be tweaked and changed to improve your current usage, how to improve on call handling methods, and informing you of additional products which may be available on your system that you may not be aware of. This could help improve the level of communication across your company and interactions with your customers. We believe telephone handset and voicemail training sessions are essential to the smooth and efficient running of your company, making sure your staff are aware of all the features and benefits that the telephone handsets can offer, and ensuring calls are dealt with quickly and effectively. System administration training is available to teach new administrators how to manage and control a variety of system features. This type of training is especially important when new administrators have little or no previous telecom knowledge or experience, but it is equally important at all levels to ensure the new system is utilised to its maximum capability. Administration days or Call Centre Software training days take one full day to complete. Full Day Example: 9:30 - 16:00 Day Structure  09:30 - 10:45 Handset & VM session for up to 8 people 10:45 - 12:00 Handset & VM session for up to 8 people 12:00 - 12:45 Lunch  12:45 - 14:00 Handset & VM session for up to 8 people 14:00 - 15:15 Handset & VM session for up to 8 people 15:15 - 16:30 Handset & VM session for up to 8 people Half Day Example: 9:30 - 13:00 Switchboard training takes half a day (3-4 hours for up to 3 people). If you want to train more than 3 people, you may need to extend the day to a full day, to ensure everyone gets to have hands-on training on the switchboard. Super Users and Train the Trainer Sessions Super User sessions can also be organised to show advanced system features in order to provide an ongoing training service to their colleagues, once the trainers have left the site.

Course Overview The "Handyperson/Handyman (From Basic Tools to Plumbing, Painting and Decorating)" course is designed to provide learners with a comprehensive understanding of a wide range of essential skills. This course covers everything from basic tool usage to more advanced tasks such as plumbing, painting, decorating, and general maintenance. Learners will gain the confidence to undertake various home improvement projects, enhance their professional toolkit, and apply their new skills in everyday situations. By the end of the course, learners will have developed a strong foundation in essential handyperson tasks and be well-equipped to handle minor repairs and maintenance work across different environments. Course Description In this course, learners will explore an extensive range of handyperson skills, beginning with the fundamentals of basic tools and equipment. They will progress to more complex topics such as electrical work, plumbing, and general carpentry. The course covers crucial areas such as appliance repair, wall and floor maintenance, as well as painting and decorating techniques. Learners will gain valuable knowledge of health and safety practices, ensuring they work efficiently and safely. This course is designed to provide learners with a solid skill set that can be applied across a wide range of tasks, from minor repairs to larger construction projects. Throughout the course, learners will be guided on how to establish their own handyperson business, providing them with essential entrepreneurial knowledge to further their career. Course Modules Module 01: Introduction to Handyperson Module 02: Basic Tools and Equipment Module 03: Electrical Work Module 04: Plumbing Skills Module 05: Appliances Module 06: General Carpentry Module 07: Basic Maintenance Skills Module 08: Walls and Floors Module 09: Painting and Decorating Module 10: Drilling, Tiling and Welding Module 11: Construction Projects Module 12: Health and Safety at Work Module 13: Starting Own Business for Handyperson (See full curriculum) Who is this course for? Individuals seeking to develop diverse handyperson skills Professionals aiming to expand their knowledge in home improvement and maintenance Beginners with an interest in the construction or maintenance industry Anyone looking to start their own handyperson business or freelance career Career Path Handyperson Maintenance Technician Property Manager Independent Handyman/Handyperson DIY Consultant Home Improvement Specialist Construction Worker Small Business Owner (Handyperson Services)

Course Overview The 120 Hours TEFL (TESOL) Masterclass is a comprehensive programme designed for individuals aspiring to teach English as a foreign or second language. This course provides a robust foundation in teaching methodologies, linguistics, grammar, pronunciation, and classroom management. Learners will develop the confidence and competence needed to deliver engaging and effective English lessons across diverse cultural and educational settings. By the end of the course, participants will be equipped with the theoretical knowledge and instructional strategies to teach English successfully to learners of all ages and proficiency levels. This qualification opens the door to teaching opportunities worldwide, enhancing employability in an ever-expanding global market. Whether seeking to start a new career, travel while teaching, or advance existing skills, this course offers valuable expertise and an internationally recognised credential. Course Description This professionally structured TEFL (TESOL) Masterclass covers all the essential aspects of English language teaching. Modules explore topics such as second language acquisition, teaching receptive and productive skills, lesson planning, classroom management, and the integration of technology into teaching. Learners will gain a solid grounding in linguistics, master techniques for teaching grammar, vocabulary, pronunciation, and discover innovative ways to motivate students through games and activities. Throughout the course, participants will build essential skills for creating dynamic learning environments and adapting teaching methods to different learner needs. With a focus on academic excellence and professional development, this course prepares learners for a rewarding career in English language teaching across schools, private institutions, and online platforms. Upon completion, learners will possess a deep understanding of English teaching practices, ready to inspire students and contribute meaningfully to educational communities around the world. Course Modules Module 01: Introduction to English Language Teaching and Learning Module 02: Linguistics Module 03: English Pronunciation Module 04: Teaching Grammar and Vocabulary Module 05: Language Teaching Methodologies Module 06: Teaching Receptive Skills: Reading Module 07: Teaching Productive Skills: Writing Module 08: Teaching Receptive Skills: Listening Module 09: Teaching Productive Skills: Speaking Module 10: Lesson Planning Module 11: Use of Games and Activities Module 12: Technology in Second Language Teaching Learning Module 13: Classroom Management and Student Motivation Module 14: Teaching English: Situational Approach Module 15: Professional Development and Employment (See full curriculum) Who is this course for? Individuals seeking to teach English to speakers of other languages. Professionals aiming to transition into the education sector or broaden their teaching credentials. Beginners with an interest in English language teaching and global communication. Travellers and expatriates looking to pursue international teaching opportunities. Recent graduates considering a career in education and language instruction. Career Path English as a Foreign Language (EFL) Teacher English as a Second Language (ESL) Instructor Online English Tutor Academic English Teacher English Language Programme Coordinator English Curriculum Developer Private Language Institute Teacher International School English Teacher

Duration 3 Days 18 CPD hours This course is intended for This course is geared for experienced Scala developers who are new to the world of machine learning and are eager to expand their skillset. Professionals such as data engineers, data scientists, and software engineers who want to harness the power of machine learning in their Scala-based projects will greatly benefit from attending. Additionally, team leads and technical managers who oversee Scala development projects and want to integrate machine learning capabilities into their workflows can gain valuable insights from this course Overview Working in a hands-on learning environment led by our expert instructor you'll: Grasp the fundamentals of machine learning and its various categories, empowering you to make informed decisions about which techniques to apply in different situations. Master the use of Scala-specific tools and libraries, such as Breeze, Saddle, and DeepLearning.scala, allowing you to efficiently process, analyze, and visualize data for machine learning projects. Develop a strong understanding of supervised and unsupervised learning algorithms, enabling you to confidently choose the right approach for your data and effectively build predictive models Gain hands-on experience with neural networks and deep learning, equipping you with the know-how to create advanced applications in areas like natural language processing and image recognition. Explore the world of generative AI and learn how to utilize GPT-Scala for creative text generation tasks, broadening your skill set and making you a more versatile developer. Conquer the realm of scalable machine learning with Scala, learning the secrets to tackling large-scale data processing and analysis challenges with ease. Sharpen your skills in model evaluation, validation, and optimization, ensuring that your machine learning models perform reliably and effectively in any situation. Machine Learning Essentials for Scala Developers is a three-day course designed to provide a solid introduction to the world of machine learning using the Scala language. Throughout the hands-on course, you?ll explore a range of machine learning algorithms and techniques, from supervised and unsupervised learning to neural networks and deep learning, all specifically crafted for Scala developers. Our expert trainer will guide you through real-world, focused hands-on labs designed to help you apply the knowledge you gain in real-world scenarios, giving you the confidence to tackle machine learning challenges in your own projects. You'll dive into innovative tools and libraries such as Breeze, Saddle, DeepLearning.scala, GPT-Scala (and Generative AI with Scala), and TensorFlow-Scala. These cutting-edge resources will enable you to build and deploy machine learning models for a wide range of projects, including data analysis, natural language processing, image recognition and more. Upon completing this course, you'll have the skills required to tackle complex projects and confidently develop intelligent applications. You?ll be able to drive business outcomes, optimize processes, and contribute to innovative projects that leverage the power of data-driven insights and predictions. Introduction to Machine Learning and Scala Learning Outcome: Understand the fundamentals of machine learning and Scala's role in this domain. What is Machine Learning? Machine Learning with Scala: Advantages and Use Cases Supervised Learning in Scala Learn the basics of supervised learning and how to apply it using Scala. Supervised Learning: Regression and Classification Linear Regression in Scala Logistic Regression in Scala Unsupervised Learning in Scala Understand unsupervised learning and how to apply it using Scala. Unsupervised Learning:Clustering and Dimensionality Reduction K-means Clustering in Scala Principal Component Analysis in Scala Neural Networks and Deep Learning in Scala Learning Outcome: Learn the basics of neural networks and deep learning with a focus on implementing them in Scala. Introduction to Neural Networks Feedforward Neural Networks in Scala Deep Learning and Convolutional Neural Networks Introduction to Generative AI and GPT in Scala Gain a basic understanding of generative AI and GPT, and how to utilize GPT-Scala for natural language tasks. Generative AI: Overview and Use Cases Introduction to GPT (Generative Pre-trained Transformer) GPT-Scala: A Library for GPT in Scala Reinforcement Learning in Scala Understand the basics of reinforcement learning and its implementation in Scala. Introduction to Reinforcement Learning Q-learning and Value Iteration Reinforcement Learning with Scala Time Series Analysis using Scala Learn time series analysis techniques and how to apply them in Scala. Introduction to Time Series Analysis Autoregressive Integrated Moving Average (ARIMA) Models Time Series Analysis in Scala Natural Language Processing (NLP) with Scala Gain an understanding of natural language processing techniques and their application in Scala. Introduction to NLP: Techniques and Applications Text Processing and Feature Extraction NLP Libraries and Tools for Scala Image Processing and Computer Vision with Scala Learn image processing techniques and computer vision concepts with a focus on implementing them in Scala. Introduction to Image Processing and Computer Vision Feature Extraction and Image Classification Image Processing Libraries for Scala Model Evaluation and Validation Understand the importance of model evaluation and validation, and how to apply these concepts using Scala. Model Evaluation Metrics Cross-Validation Techniques Model Selection and Tuning in Scala Scalable Machine Learning with Scala Learn how to handle large-scale machine learning problems using Scala. Challenges of Large-Scale Machine Learning Data Partitioning and Parallelization Distributed Machine Learning with Scala Machine Learning Deployment and Production Understand the process of deploying machine learning models into production using Scala. Deployment Challenges and Best Practices Model Serialization and Deserialization Monitoring and Updating Models in Production Ensemble Learning Techniques in Scala Discover ensemble learning techniques and their implementation in Scala. Introduction to Ensemble Learning Bagging and Boosting Techniques Implementing Ensemble Models in Scala Feature Engineering for Machine Learning in Scala Learn advanced feature engineering techniques to improve machine learning model performance in Scala. Importance of Feature Engineering in Machine Learning Feature Scaling and Normalization Techniques Handling Missing Data and Categorical Features Advanced Optimization Techniques for Machine Learning Understand advanced optimization techniques for machine learning models and their application in Scala. Gradient Descent and Variants Regularization Techniques (L1 and L2) Hyperparameter Tuning Strategies

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.

Course Overview This course on Accounts Payable Management (Purchase Ledger) offers an in-depth exploration of the essential functions and responsibilities within the purchase ledger department. Learners will gain a solid understanding of purchase ledger processes, from basic concepts to advanced management techniques, making it ideal for those looking to enhance their financial accounting knowledge. Throughout the course, learners will explore the significance of accurate and efficient ledger management, its impact on overall financial operations, and how these skills contribute to business success. Upon completion, learners will be equipped with the knowledge required to manage purchase ledgers confidently and contribute effectively to an organisation’s financial management practices. Course Description This comprehensive course covers key topics related to the accounts payable function, such as managing purchase ledger accounts, controlling and reconciling transactions, and understanding the importance of accurate ledger management. Learners will explore the role of purchase ledger in business finance, developing core skills like reconciliation techniques and managing supplier relationships. In addition, the course includes a focus on the shift towards paperless operations, equipping learners with the tools to optimise processes using modern software solutions. By the end of the course, participants will possess the necessary skills to manage purchase ledgers efficiently, making them valuable assets to any accounting or finance team. Course Modules Module 01: Introduction to Purchase Ledger Module 02: Importance of Purchase Ledger Module 03: Skills for Purchase Ledger Management Module 04: Purchase Ledger Control Account Module 05: Managing Purchase Ledger Successfully Module 06: Reconciliation Module 07: The Key to a Paperless Purchase Ledger World (See full curriculum) Who is this course for? Individuals seeking to enhance their accounting and finance skills. Professionals aiming to manage purchase ledger operations effectively. Beginners with an interest in accounts payable and financial management. Those looking to progress in the accounts payable or finance departments. Career Path Accounts Payable Manager Purchase Ledger Supervisor Finance Assistant Financial Controller Accounting Technician

Duration 4 Days 24 CPD hours This course is intended for This is an intermediate level course for students that will perform Database Administration tasks, who plan, implement, and maintain D22 11.1 databases. Overview These skills can be developed by taking: DB2 SQL Workshop DB2 Fundamentals This course teaches database administrators to perform basic database administrative tasks using Db2 11.1. These tasks include creating database objects like tables, indexes and views, and loading data into the database with Db2 utilities like LOAD and INGEST. Various diagnostic methods will be presented, including using db2pd command options, and monitoring with SQL statements that reference Db2 monitor functions. Students will learn how to implement automatic archival for database logs and how to recover a database to a specific point in time using the archived logs. The course covers using EXPLAIN tools to review the access plans for SQL statements and adding indexes to improve SQL performance. We will cover the locking performed by Db2 and the effect the application isolation level has on locking and lock wait conditions. Students will learn how to implement database security, including adding a security administrator, SECADM user, and implement database roles to simplify security management. We will also describe implementing Db2 native encryption for a database. Overview of Db2 11.1Db2 Command Line Processor (CLP) and GUI toolsThe Db2 database manager instanceCreating Databases and Data PlacementCreating Database ObjectsMoving DataBackup and RecoveryDatabase Maintenance, Monitoring and Problem DeterminationLocking and concurrencySecurity