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

451 Consultant courses in Cardiff delivered Live Online

Train the Trainer - CPD Certified Diploma (copy)

By NextGen Learning

Overview In an era of constant learning and upskilling, the demand for efficient trainers is soaring. If you're passionate about sharing your knowledge and inspiring others to achieve their potential, then our Train the Trainer Level 5 QLS Endorsed Diploma course is tailor-made for you. Whether you're a professional trainer, manager, educator, or someone with a wealth of knowledge you wish to impart, becoming an effective trainer is both a rewarding journey and a valued skill. It’s not just about conveying information, it's about motivating, engaging and making a lasting impact on your learners. You’ll delve into the science of learning, discover how to train, and master the art of delivery and feedback with our Train the Trainer Masterclass Diploma. We believe that a great trainer is also a great storyteller, and we provide you with the tools to create compelling narratives that truly resonate with your audience. Perhaps you are a trainer seeking more knowledge in your field, or you aspire to be one. If so, don't waste any more time and have a look at our Train the Trainer course to get the best training from Nextgen Learning. Train the Trainer course is the opportunity to kickstart your exciting career and solidify your comprehensive knowledge. The best way for you to learn the subject thoroughly is through this Train the Trainer course. This Train the Trainer Level 5 QLS Endorsed Diploma course holds a prestigious CPD accreditation & QLS endorsement, symbolising exceptional quality. The materials, brimming with knowledge, are regularly updated, ensuring their relevance. This Train the Trainer course promises not just education but an evolving learning experience. Engage with this extraordinary Train the Trainer curriculum, and prepare to enrich your personal and professional development. So, if you are eager to see yourself in a gratifying career, then enrol in our Train the Trainer course today! What will make you stand out? On completion of this online Train the Trainer Level 5 QLS Endorsed Diploma course, you will gain: CPD QS Accredited After completing the Course, you will get the opportunity to order Accredited Certificate as evidence of your newly acquired abilities. Lifetime access to the whole collection of learning materials. The online test with immediate results You can study and complete the Train the Trainer course at your own pace. Study for the Train the Trainer Diploma course using any internet-connected device, such as a computer, tablet, or mobile device. ***ADDITIONAL GIFT*** Free Course: Leadership & Management Diploma - CPD Accredited Train the Trainer Course Curriculum : Module 01: Introduction and Welcome to Train the Trainer course Module 02: Make Them Feel Safe Before Class Module 03: Start with An Amazing Opener Module 04: Build Credibility and Rapport Qui Module 05: Workbook Assignment (Optional) - Train the Trainer Description The substantial Train the Trainer Diploma course is designed to help you demonstrate the preliminary to in-depth level of learning regarding this topic. Moreover, you will be provided with the most knowledgeable and informative modules for your lifetime by enrolling in this Train the Trainer Diploma course just once. Furthermore, as you proceed through the modules of this course, you will discover the fundamentals of Train the Trainer and explore the key topics. Therefore, reinforce your knowledge and furnish your skills by enrolling in our Train the Trainer course. Take one step closer to achieving your goal. Quality Licence Scheme Endorsed Certificate of Achievement: Upon successful completion of the course, you will be eligible to order QLS Endorsed Hardcopy Certificate titled ‘Diploma in Train the Trainer at QLS Level 5’. £109 GBP for addresses within the UK. Please note that delivery within the UK is free of charge. Please Note: NextGen Learning is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. Who is this course for? Is This Train the Trainer Course the Right Option for You? This Train the Trainer course is recommended for anyone who is interested in learning more about this topic. You'll learn the fundamental ideas and gain a comprehensive understanding of the topic by taking this Train the Trainer course. Career path This Train the Trainer Level 5 QLS Endorsed Diploma course aims to assist you in achieving your career goals. Including the potential careers: Corporate Trainer Training Manager Personal Coach Public Speaker Online Course Instructor Learning and Development Consultant Instructional Designer

Train the Trainer - CPD Certified Diploma (copy)
Delivered OnlineFlexible Dates
£14.99

SAP System Security Fundamentals

By Nexus Human

Duration 2 Days 12 CPD hours This course is intended for System Security Administrator Security Architect Technology Consultant Overview This course will prepare you to Understand SAP Security fundamentals Get an overview of the main SAP concepts for security Be prepared to learn more in detail about each SAP concept for security This course will prepare you to Understand SAP Security fundamentals. Get an overview of the main SAP concepts for security. Be prepared to learn more in detail about each SAP concept for security. SAP Access Governance and Control Overview of Security Fundamentals Introduction to SAP Access Governance SAP NetWeaver Application Security Overview Describe SAP User Experience Explain Basic User Administration for AS ABAP Explain Basic Role Administration for AS ABAP Describe SAP Fiori Catalog and Group Administration Concept Describe AS JAVA Security Discuss Custom Development and Security SAP Access Governance and Compliance Describe SAP Access Governance Explain SAP GRC Access Control Describe SAP Identity Management Describe SAP Cloud Identity Access Governance Infrastructure Security Explaining Network Topology Enabling Secure Network Communication (SNC) Enabling Secure Sockets Layer (SSL) Implementing Single Sign-On (SSO) in SAP Systems Security Monitoring with SAP Solution Manager Monitoring Security with SAP Solution Manager SAP Data Privacy Governance and Cybersecurity Introduce EU General Data Privacy Regulation (GDPR) Discuss SAP Support for GDPR Compliance Additional course details: Nexus Humans SAP System Security Fundamentals 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 SAP System Security Fundamentals 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.

SAP System Security Fundamentals
Delivered OnlineFlexible Dates
Price on Enquiry

Oracle Database: Backup and Recovery Workshop

By Nexus Human

Duration 5 Days 30 CPD hours This course is intended for Oracle Database Administrator Data Warehouse Administrator Support Engineer Technical Consultant Technical Administrator Overview The student benefits by gaining a deeper understanding of possibly the most important job of a DBA - backup and recovery. The concepts and architecture that support backup and recovery, along with implementation steps in various ways and situations, are presented in detail. Students gain knowledge of the Recovery Manager (RMAN) command-line interface for various backup, failure, restore, and recovery scenarios, including data duplication. The student begins by gaining a deeper understanding of possibly the most important job of a DBA - backup and recovery. The concepts and architecture that support backup and recovery, along with implementation in various ways and situations are covered in detail. Students gain knowledge of the Recovery Manager (RMAN) command-line interface for various backup, failure, restore, and recovery scenarios, including data duplication. Introduction and Configuration Introduction Getting Started Configuring for Recoverablility Using the RMAN Recovery Catalog Backup Backup Strategies and Terminology Performing Backups Improving Your Backups Using RMAN-Encrypted Backups Recovery Diagnosing Failures Restore and Recovery Concepts Performing Complete Recovery Performing Point-in-Time Recovery Performing Additional Recovery Operations Additional Technologies Using Flashback Technologies Using Flashback Database Transporting Data Duplicating a Database RMAN Troubleshooting and Tuning Hands-On Backup and Recovery Workshop Additional course details: Nexus Humans Oracle Database: Backup and Recovery Workshop 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 Oracle Database: Backup and Recovery Workshop 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.

Oracle Database: Backup and Recovery Workshop
Delivered OnlineFlexible Dates
Price on Enquiry

C10M02 - Actuation of door release mechanisms - BS 7273-4 (online)

5.0(1)

By Ember Compliance

Learners will develop knowledge from the FD&FA foundation courses (C01 modules 1 and 2) and/or industry experience with specific regard to more complex system design considerations.

C10M02 - Actuation of door release mechanisms - BS 7273-4 (online)
Delivered Online
£230

Arabic Legal Writing and Drafting Skills

By EMG Associates UK Limited

Arabic Legal Writing and Drafting Skills Why Attend This course focuses on clear legal writing in Arabic. Effective communication with lawyers is about more than simply words. It entails understanding the unique way lawyers think and approach the legal, political, and business world. During this Arabic course, a number of legal documents are discussed, including drafting contracts, letters, policies and company bylaws. Participants also look at a wide variety of commercial agreements during practical drafting sessions. This course helps participants to draft confidently and effectively in Arabic regardless of the governing law. Course Methodology The course consists of group discussions as well as individual and team tasks. There will be writing practice throughout the exercises. Course Objectives By the end of the course, participants will be able to: Apply a plain Arabic style of writing to all legal documents Recognize the need for legal clarity in different types of legal documents: legal letters, emails, memorandum and opinions Apply good legal writing practice Use best practice techniques to write contracts, letters, policies and company bylaws Correct common mistakes in legal writing Address and deal with challenges and issues relating to the use of legal jargon Proofread effectively Target Audience The course is suitable for Arabic speakers looking for a better understanding of how to write Arabic legal documents. This course is for lawyers, legal secretaries, commercial managers, contract managers, HR executives and managers, purchasing managers, tender executives and anyone who must draft, amend or update contracts, legal letters and company policies and bylaws.  Target Competencies Drafting letters, policies, company bylaws and contracts Proofreading Writing in plain Arabic Understanding legal terms Legal writing practice Note The Dubai Government Legal Affairs Department has introduced a Continuing Legal Professional Development (CLPD) programme to legal consultants authorised to practice through a licensed firm in the Emirate of Dubai. We are proud to announce that the Dubai Government Legal Affairs Department has accredited EMG Associates as a CLPD provider. In addition, all our legal programmes have been approved. Basic legal writing concepts and contract drafting The various types of legal documents Tips in writing bilingual legal documents Signs of a well drafted contract; the simple rules! The language of drafting Identifying the legal formalities for a binding contract Structure and formation of a commercial contract: following the formula The importance of Boilerplate clauses Plain Arabic in legal correspondence and writing a legal letter Good legal writing practice Pitfalls and issues relating to the use of legal jargon in legal writing Writing different types of emails Layout of a letter Body of a letter Putting a letter together Typical sentences in legal letters The letter writing clinic: looking at the ten most common problems Writing a legal policy or company bylaw and legal writing troubleshooting Layout of a policy or bylaw Body of a policy or bylaw How to write the best policy or bylaw Understanding the principles of legal interpretation The four defects that affect legal writing Use of consistent terminology Easily confused words How courts react to legal writing and what to expect

Arabic Legal Writing and Drafting Skills
Delivered OnlineFlexible Dates
£2,964

Arbitration and Dispute Resolution

By EMG Associates UK Limited

Arbitration and Dispute Resolution Why Attend Effective dispute resolution helps minimize the costs and adverse effects to relationships that often arise from commercial disputes. If informal negotiation fails to resolve a dispute, mediation or arbitration can often be the next best option in order to avoid litigation in court. This course will give participants an insight into dispute resolution from the perspective of a lawyer. Participants will gain an in-depth understanding of the main differences between the various dispute resolution techniques with a particular focus on arbitration, in order to reduce the likelihood of disputes leading to court cases. Course Methodology In this interactive training course participants will frequently work in pairs as well as in larger groups to complete exercises as well as regional and international case studies. Course Objectives By the end of the course, participants will be able to: Identify the right course of action to resolve a legal dispute Reduce the possibility of disputes leading to legal action Apply national and international legal requirements for dispute resolution Employ arbitration knowledge to negotiate terms Use case law to achieve a favorable outcome for their organization Target Audience This course is suitable for professionals within all industries who are involved in contract management and resolving disputes including, but not limited to, project managers, contract managers, procurement managers, supply chain managers, contractors, architects, developers and engineers. This course would also highly benefit in-house council and legal advisors new to the region who require the fundamentals of dispute resolution in the GCC. Target Competencies Litigation Arbitration Mediation Negotiation GCC Dispute Resolution Frameworks Note The Dubai Government Legal Affairs Department has introduced a Continuing Legal Professional Development (CLPD) programme to legal consultants authorised to practise through a licensed firm in the Emirate of Dubai. We are proud to announce that the Dubai Government Legal Affairs Department has accredited EMG Associates as a CLPD provider. In addition, all our legal programmes have been approved. This PLUS Specialty Training Legal course qualifies for 4 elective CLPD points. Fundamentals of dispute resolution Overview of the dispute resolution process Adjudicative process Consensual process Introduction to the English High Court litigation processes Why do international businesses take their dispute to the English High Court? English civil courts Legal practitioners who are involved in resolving disputes  Importance of jurisdiction clause How do you decide? Exclusive or non-exclusive? Differences between the Civil law system and the Common law system Principles of the common law system Principles of the civil law system The importance of these systems in dispute resolution Importance of Alternative Dispute Resolution ( ADR) Types of ADR Arbitration Mediations Conciliation Negotiation Arbitration - the best form of ADR The object of Arbitration The role of an Arbitrator Advantages and disadvantages of Arbitration Requirement of an Arbitration agreement The importance of the New York convention The role of UNCITRAL in dispute resolution Preparing for an arbitration hearing Types of Arbitration Institutional arbitration v Ad hoc arbitration Advantages and disadvantages of Institutional arbitration Advantages and disadvantages of Ad hoc arbitration Drafting international Arbitration agreement Checklist for drafting an Arbitration agreement Practical consideration with 'Seat' of Arbitration Model Arbitration clauses ICC LCIA Arbitral awards Enforcement of an Arbitral awards Grounds for challenging Arbitral awards Recent international case law Arbitration terms and terminology Other ADR methods: Advantages and disadvantages of each method: Mediation Conciliation Negotiation Ambiguity in an Arbitration clause What to avoid Importance of the language used in an Arbitration clause Dubai International Arbitration Centre (DIAC) Examining the rules of DIAC

Arbitration and Dispute Resolution
Delivered OnlineFlexible Dates
£2,964

Legal Writing and Drafting Skills

By EMG Associates UK Limited

Legal Writing and Drafting Skills Why Attend There is a misconception that legal writing and legal drafting is the same but there is a substantial difference between the two. While legal writing typically deals with persuasive documents such as court briefs and legal letters, legal drafting involves creating documents such as contracts. They are both equally important in legal practice.  Legal writing is an important skill needed in every practice area of law. Words are used to advocate, inform, persuade and instruct. Are you giving the right impression? Are your clients receiving the right message? This course focuses on clear legal writing for a global audience. Effective communication with English speaking lawyers is about more than simply words. It entails understanding the unique way these speakers think and approach the legal, political, and business world. Did you know that most international commercial agreements are drafted in English, irrespective of the nationality of the contracting parties. Drafting contract skills is ideal for lawyers working in English as a foreign language who need to draft, explain or interpret contract clauses written in English. During the course, delegates will look at a wide variety of commercial agreements through to practical drafting sessions. This course will help participants to draft confidently and effectively in English regardless of the governing law. This is a practical course with many exercises and examples in order to achieve an interactive and stimulating outcome. The course's activities involve the production of typical work-place legal documents. Course Methodology The course consists of group discussions as well as individual and team tasks. There will be writing practice throughout the exercises. Course Objectives By the end of the course, participants will be able to: Apply plain English style of writing to all legal documents Recognize the need for legal clarity in different types of legal documents: legal letters, emails, memorandum and opinions Apply good legal writing practice Demonstrate the register of legal writing Correct common mistakes in legal writing Dispense and deal with pitfalls and issues relating to the use of legal jargon Proofread effectively Target Audience This course is for lawyers, legal secretaries, commercial managers, contract managers and anyone who must draft, amend or update contracts, legal letters and legal opinion. The course is suitable for non-native English speakers looking for a better understanding of English legal terms. Target Competencies Drafting letters Proofreading Writing in plain English Understanding legal terms Legal writing practice Note The Dubai Government Legal Affairs Department has introduced a Continuing Legal Professional Development (CLPD) programme to legal consultants authorised to practice through a licensed firm in the Emirate of Dubai. We are proud to announce that the Dubai Government Legal Affairs Department has accredited EMG Associates as a CLPD provider. In addition, all our legal programmes have been approved. Legal Drafting Signs of a well drafted contract: The simple rules! The language of drafting: Will v Shall v Must Identifying the legal formalities for a binding contract Structure and formation of a commercial contract: follow the formula and you won't go wrong The importance of Boilerplate clauses: No waiver Notices Assignment v Novation Governing v Jurisdiction Force majeure - are we covered for viruses (covid19)? Dispute resolution clause: Litigation v Arbitration v Mediation The preliminary documents in international transaction - using Heads of Terms effectively Vague words and expressions in commercial contracts- know the pitfalls! Best endeavors v All reasonable endeavors v reasonable endeavors Overview of cross border contracts: Distribution v Joint venture v Agency agreements Share Purchase Agreements Warranties and indemnities Allocating risks and liabilities between the buyer and seller Negotiating warranties from a Share Purchase Agreement Plain English in Legal Correspondence Good legal writing practice Moving from legalese to Plain English Unnecessary archaic and meaningless phrases Collocations Importance of collocations in legal writing Pitfalls and issues relating to the use of legal jargon in legal writing Writing short emails Writing long emails Writing formal emails Writing A Legal Letter Layout of a letter Body of a letter Putting a letter together The register of letter writing Typical sentences in legal letters The letter writing clinic: looking at the ten most common problems Rewriting letters Rewriting informal sentences to modern alternatives Correcting common mistakes in letter writing Legal Writing Troubleshooting The problem of English idioms Rephrasing English idioms Easily confused words Cutting unnecessary words Use of consistent terminology Ambiguity: how to avoid it Vagueness: how to avoid it Misuse of preposition in dates Problem words Constantly litigated words Rewriting sentences to remove gender specific language

Legal Writing and Drafting Skills
Delivered OnlineFlexible Dates
£2,964

MySQL server administration

5.0(3)

By Systems & Network Training

MySQL server admins training course description This MySQL Server administration course is designed for MySQL Server administrators who have a basic understanding of a MySQL database and a good working knowledge of SQL commands. The course provides an understanding of MySQL Architecture and practical experience in setting up, configuring and maintaining a MySQL server, backing up and recovering data and optimising query performance. This MySQL Server administration course also covers MySQL replication and its role in high availability and scalability. What will you learn Use MySQL Workbench. Install and configure a MySQL Server . Administer and tune a MySQL server. Configure log files and interpret error messages.. Secure the Server. Administer a replication topology. MySQL server admin training course details Who will benefit: Database administrators, Database developers and Technical consultants. Prerequisites: Introduction to MySQL Duration 5 days MySQL server admin training course contents Introduction to Oracle Application Express APEX concepts APEX main components Workspaces, database applications and websheet applications Creating a workspace The Workspace Administrator Upgrading APEX Logging into APEX Running an application SWL Workshop Use APEX to browse, create and modify objects Process ad hoc SQL statements Manage scripts in APEX Create, run and save SQL queries Build a database application Application components Create an application Create an application from a spreadsheet Create reports Create reports using wizards Edit report attributes Add links to reports Create a link to a printer-friendly version of a report Save and print reports in different formats Using files Uploading images Creating cascading stylesheet files Uploading static files Adding an Image as an application logo Adding a reference to a Javascript file Pages and regions Web form behaviour in APEX Create a form based on a table Create a form based on a procedure Create a form with a report Create a tabular form Format a form Locking in APEX forms Creating lists of values Overview of application express shared Components Dynamic and static lists of values Create a dynamic list of values Create a static list of values Use a list of values to control data in a report Create a cascading list of values Items and buttons Understand the different Types of items Create items Understand and edit item attributes Use Javascript with item Manipulate items in tabular forms Add dynamic items to a report Create and edit buttons Page Processing Page rendering and page processing Create computations Validate input data Process Data Understand application branching Create conditional branches Shared components Overview of application express navigation components Manage parent and standard tabs Create navigation bar entries Create and use lists and list items Manage breadcrumbs Create shortcuts Shared component subscription User interface defaults Display dynamic content Filter reports with dynamic queries Create charts with a wizard Format charts Create calendars Add links to calendars Create hierarchical trees State and debugging Understand session state Set a session state value Clear the session state Review the session state Review the messages in debug mode Enabling feedback Managing feedback and team development Themes and templates Switch to a different theme View existing templates Understand and manage templates Create a new template Add references to cascading stylesheet and Javascript files Dynamic actions and plug-in components Identify plug-in components and their types Plug In a component Create dynamic actions Use a plug-in in a dynamic action Building website applications Websheet applications and their components Create a websheet application Enable SQL and PL/SQL in a websheet application Add sections and pages to a websheet application Add links on a websheet page Add a data grid to a websheet application Create SQL reports ion websheet applications Add annotations to a websheet application Implementing security Authentication and authorization Provide an authentication scheme Create an authorization scheme using access control Enable and configure session state protection Deploy an appliction Define supporting objects Package an application Export an application Import an application Install supporting objects Administer Apex workspaces Manage workspaces and users Request a schema or storage Purge session state Monitor developer activity log Monitor workspace activity View activity reports Import a workspace Utility programs Import and export data Generate DDL statements View objects reports

MySQL server administration
Delivered in Internationally or OnlineFlexible Dates
£2,797

Oracle BI 11g R1 - Build Repositories

By Nexus Human

Duration 5 Days 30 CPD hours This course is intended for Application DevelopersBusiness AnalystsBusiness Intelligence DeveloperData ModelersData Warehouse AdministratorData Warehouse AnalystReports DeveloperTechnical Consultant Overview Build and run analyses to test and validate a repositorySet up query logging for testing and debuggingSet up a multiuser development environmentUse the Administration Tool wizards and utilities to manage, maintain, and enhance repositoriesEnable usage tracking to track queries and database usage, and improve query performancePerform a patch merge in a development-to-production scenarioDescribe Exalytics machine and the Summary Advisor tool used in the machineBuild simple and calculated measures for a fact tableCreate logical dimension hierarchies and level-based measuresCheck the model and then model aggregate tables to speed query processingModel partitions and fragments to improve application performance and usabilityUse variables to streamline administrative tasks and modify metadata content dynamicallyUse time series functions to support historical time comparison analysesSet up security to authenticate users and assign appropriate permissions and privilegesBuild the Physical, Business Model and Mapping, and Presentation layers of a repositoryApply cache management techniques to maintain and enhance query performance This Oracle BI 11g R1: Build Repositories training is based on OBI EE release 11.1.1.7. Expert Oracle University instructors will teach you step-by-step procedures for building and verifying the three layers of an Oracle BI repository. This Oracle BI 11g R1: Build Repositories training is based on OBI EE release 11.1.1.7. Expert Oracle University instructors will teach you step-by-step procedures for building and verifying the three layers of an Oracle BI repository. Additional course details: Nexus Humans Oracle BI 11g R1 - Build Repositories 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 Oracle BI 11g R1 - Build Repositories 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.

Oracle BI 11g R1 - Build Repositories
Delivered OnlineFlexible Dates
Price on Enquiry

HA150 SAP HANA 2.0 SPS05 SQLScript for SAP HANA

By Nexus Human

Duration 3 Days 18 CPD hours This course is intended for Application Developer Data Modeler BI / BW Consultant Data Scientist Database Administrator SAP HANA Support Personnel Overview This course will prepare you to: Push down data intensive tasks to the SAP HANA database using SQL and SQLScript Understand how to code using advanced SQLScript techniques Follow recommended practices for writing optimal SQL and SQLScript Debug and analyze SQL and SQLScript code This course provides students with basic SQL knowledge or refreshes their SQL knowledge, and enables them to use basic and some advanced SQL techniques for querying and manipulating data in an SAP HANA database. Getting Started What is SQL and SQLScript? Understanding how ABAP developers work with SQLScript Understanding XS Advanced and HDI Working with Web IDE for SAP HANA Understanding the course data SQL Logic Container Creating user-defined functions Creating database procedures Trapping errors in SQLScript User defined libraries Declarative Logic Using declarative logic Imperative Logic Using imperative Logic Transactional Savepoints How to implement transactional savepoints Analytic Operations Using OLAP Analytic features Implementing Temporal Tables Working with Hierarchies Working with Hierarchies Troubleshooting and Best Practices Tools for troubleshooting Best Practices Appendix Starting from the beginning with SQL fundamentals Additional course details: Nexus Humans HA150 SAP HANA 2.0 SPS05 SQLScript for SAP HANA 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 HA150 SAP HANA 2.0 SPS05 SQLScript for SAP HANA 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.

HA150 SAP HANA 2.0 SPS05 SQLScript for SAP HANA
Delivered OnlineFlexible Dates
Price on Enquiry