2789 Intelligence courses in Nottingham delivered Online

Get ready for an exceptional online learning experience with the Financial Engineering: Financial Advisor, Budgeting, Investment & Accounting bundle! This carefully curated collection of 20 premium courses is designed to cater to a variety of interests and disciplines. Dive into a sea of knowledge and skills, tailoring your learning journey to suit your unique aspirations. The Financial Advisor, Investment & Accounting package is dynamic, blending the expertise of industry professionals with the flexibility of digital learning. It offers the perfect balance of foundational understanding and advanced insights. Whether you're looking to break into a new field or deepen your existing knowledge, the Financial Advisor, Investment & Accounting package has something for everyone. As part of the Financial Advisor, Investment & Accounting, you will receive complimentary PDF certificates for all courses in this bundle at no extra cost. Equip yourself with the Financial Engineering: Financial Advisor, Budgeting, Investment & Accounting bundle to confidently navigate your career path or personal development journey. Enrol today and start your career growth! This Bundle Comprises the Following Financial Engineering: Financial Advisor, Budgeting, Investment & Accounting CPD-accredited courses: Course 01: Finance: Financial Advisor Course 02: Finance and Budgeting Diploma Course 03: Corporate Finance: Profitability in a Financial Downturn Course 04: Finance: Financial Risk Management Course 05: Financial Wellness: Managing Personal Cash Flow Course 06: Financial Statement Analysis Masterclass Course 07: Pension Course 08: Capital Budgeting & Investment Decision Rules Course 09: Corporate Finance: Working Capital Management Course 10: Financial Statements Fraud Detection Training Course 11: Presenting Financial Information Course 12: Financial Reporting Course 13: Financial Modeling Using Excel Course 14: Banking and Finance Accounting Statements Financial Analysis Course 15: Tax Accounting Diploma Course 16: Career Development Plan Fundamentals Course 17: CV Writing and Job Searching Course 18: Learn to Level Up Your Leadership Course 19: Networking Skills for Personal Success Course 20: Ace Your Presentations: Public Speaking Masterclass What will make you stand out? Upon completion of this online Financial Engineering: Financial Advisor, Budgeting, Investment & Accounting bundle, you will gain the following: CPD QS Accredited Proficiency with this Financial Advisor, Investment & Accounting bundle After successfully completing the Financial Advisor, Investment & Accounting bundle, you will receive a FREE PDF Certificate from REED as evidence of your newly acquired abilities. Lifetime access to the whole collection of learning materials in this Financial Advisor, Investment & Accounting bundle The online test with immediate results You can study and complete the Financial Advisor, Investment & Accounting bundle at your own pace. Study for the Financial Advisor, Investment & Accounting bundle using any internet-connected device, such as a computer, tablet, or mobile device. Each course in this Financial Engineering: Financial Advisor, Budgeting, Investment & Accounting bundle holds a prestigious CPD accreditation, symbolising exceptional quality. The materials, brimming with knowledge, are regularly updated, ensuring their relevance. This Financial Advisor, Investment & Accounting bundle promises not just education but an evolving learning experience. Engage with this extraordinary collection, and prepare to enrich your personal and professional development. Embrace the future of learning with Financial Engineering: Financial Advisor, Budgeting, Investment & Accounting , a rich anthology of 30 diverse courses. Our experts handpick each course in the Financial Advisor, Investment & Accounting bundle to ensure a wide spectrum of learning opportunities. This Financial Advisor, Investment & Accounting bundle will take you on a unique and enriching educational journey. The Financial Engineering: Financial Advisor, Budgeting, Investment & Accounting bundle encapsulates our mission to provide quality, accessible education for all. Whether you are just starting your career, looking to switch industries, or hoping to enhance your professional skill set, the Financial Advisor, Investment & Accounting bundle offers you the flexibility and convenience to learn at your own pace. Make the Financial Advisor, Investment & Accounting package your trusted companion in your lifelong learning journey. CPD 200 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Financial Engineering: Financial Advisor, Budgeting, Investment & Accountingbundle is perfect for: Aspiring Financial Advisors: Ideal for individuals aiming to provide expert financial advice to clients on investments, insurance, tax, and estate planning. Budget Analysts: Suitable for those interested in learning how to plan and manage budgets within organisations, ensuring financial efficiency and goal alignment. Investment Enthusiasts: Designed for people passionate about stock markets, mutual funds, and other investment vehicles, looking to deepen their knowledge and practical skills. Accountancy Candidates: Perfect for individuals planning a career in accounting or those already in the field seeking to enhance their knowledge of financial statements and reporting. Career Changers: Geared towards professionals looking to shift to a career in finance, providing the foundational knowledge and skills required for a smooth transition. Requirements You are warmly invited to register for this Financial Engineering: Financial Advisor, Budgeting, Investment & Accounting bundle. Please be aware that no formal entry requirements or qualifications are necessary. This curriculum has been crafted to be open to everyone, regardless of previous experience or educational attainment. Career path Upon Financial Engineering: Financial Advisor, Budgeting, Investment & Accounting course completion, you can expect to: Financial Advisor Budget Analyst Investment Analyst Accountant Tax Consultant Risk Manager Compliance Officer Corporate Treasurer Personal Finance Coach Entrepreneur Certificates CPD Certificates Digital certificate - Included

Get ready for an exceptional online learning experience with the Financial Advisor: Financial Analysis, Investment, Trading, Business Analysis & AML bundle! This carefully curated collection of 20 premium courses is designed to cater to a variety of interests and disciplines. Dive into a sea of knowledge and skills, tailoring your learning journey to suit your unique aspirations. The Financial Advisor: Financial Analysis, Investment, Trading, Business Analysis & AML is a dynamic package, blending the expertise of industry professionals with the flexibility of digital learning. It offers the perfect balance of foundational understanding and advanced insights. Whether you're looking to break into a new field or deepen your existing knowledge, the Financial Advisor & Financial Analysis package has something for everyone. As part of the Financial Advisor: Financial Analysis, Investment, Trading, Business Analysis & AML package, you will receive complimentary PDF certificates for all courses in this bundle at no extra cost. Equip yourself with the Financial Advisor & Financial Analysis bundle to confidently navigate your career path or personal development journey. Enrol today and start your career growth! This Bundle Comprises the Following Financial Advisor: Financial Analysis, Investment, Trading, Business Analysis & AML CPD-accredited courses: Course 01: Finance: Financial Advisor Course 02: Financial Management Course 03: Financial Analysis Course 04: Fundamentals of Business Analysis Course 05: Banking and Finance Accounting Statements Financial Analysis Course 06: Investment Course 07: Capital Budgeting & Investment Decision Rules Course 08: Tax Accounting Diploma Course 09: Forex Trading Diploma Course 10: Stock Market Investing for Beginners Course 11: Internal Audit Skills Diploma Course 12: Anti-Money Laundering (AML) Training Course 13: Commercial law Course 14: Xero Accounting and Bookkeeping Course 15: Microsoft Excel Complete Course Course 16: Career Development Plan Fundamentals Course 17: CV Writing and Job Searching Course 18: Learn to Level Up Your Leadership Course 19: Networking Skills for Personal Success Course 20: Ace Your Presentations: Public Speaking Masterclass What will make you stand out? Upon completion of this online Financial Advisor: Financial Analysis, Investment, Trading, Business Analysis & AML bundle, you will gain the following: CPD QS Accredited Proficiency with this Financial Advisor & Financial Analysis bundle After successfully completing the Financial Advisor & Financial Analysis bundle, you will receive a FREE PDF Certificate from REED as evidence of your newly acquired abilities. Lifetime access to the whole collection of learning materials of this Financial Advisor & Financial Analysis bundle The online test with immediate results You can study and complete the Financial Advisor & Financial Analysis bundle at your own pace. Study for the Financial Advisor & Financial Analysis bundle using any internet-connected device, such as a computer, tablet, or mobile device. Each course in this Financial Advisor: Financial Analysis, Investment, Trading, Business Analysis & AML bundle holds a prestigious CPD accreditation, symbolising exceptional quality. The materials, brimming with knowledge, are regularly updated, ensuring their relevance. This Financial Advisor & Financial Analysis bundle promises not just education but an evolving learning experience. Engage with this extraordinary collection, and prepare to enrich your personal and professional development. Embrace the future of learning with the Financial Advisor: Financial Analysis, Investment, Trading, Business Analysis & AML, a rich anthology of 30 diverse courses. Our experts handpick each course in the Financial Advisor & Financial Analysis bundle to ensure a wide spectrum of learning opportunities. This Financial Advisor & Financial Analysis bundle will take you on a unique and enriching educational journey. The Financial Advisor: Financial Analysis, Investment, Trading, Business Analysis & AML bundle encapsulates our mission to provide quality, accessible education for all. Whether you are just starting your career, looking to switch industries, or hoping to enhance your professional skill set, the Financial Advisor & Financial Analysis bundle offers you the flexibility and convenience to learn at your own pace. Make the Financial Advisor & Financial Analysis package your trusted companion in your lifelong learning journey. CPD 200 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Financial Advisor: Financial Analysis, Investment, Trading, Business Analysis & AML bundle is perfect for: Finance Fundamentals: Gain a broad understanding of financial markets, investments, and analysis. Early Career Boost: Enhance skills and knowledge for financial advisory roles. Business & Finance Experts: Deepen expertise in market analysis and compliance. Business Owners: Make informed financial decisions and manage risk. Career Changers: Build a solid foundation for entering finance. Requirements You are warmly invited to register for this Financial Advisor: Financial Analysis, Investment, Trading, Business Analysis & AML bundle. Please be aware that no formal entry requirements or qualifications are necessary. This curriculum has been crafted to be open to everyone, regardless of previous experience or educational attainment. Career path Upon Financial Advisor: Financial Analysis, Investment, Trading, Business Analysis & AML course completion, you can expect to: Junior Financial Advisor Investment Analyst Business Analyst Risk Management Specialist Portfolio Manager Certificates 20 CPD Quality Standard Pdf Certificates Digital certificate - Included

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents, and interests with our special Finance: Financial Investigator Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides the professional training that employers are looking for in today's workplaces. The Finance: Financial Investigator Course is one of the most prestigious training offered at Skillwise and is highly valued by employers for good reason. This Finance: Financial Investigator Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Finance: Financial Investigator Course, like every one of Skillwise's courses, is meticulously developed and well-researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At Skillwise, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from Skillwise, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Finance: Financial Investigator? Unlimited access to the course forever Digital Certificate, Transcript, and student ID are all included in the price Absolutely no hidden fees Directly receive CPD Quality Standard-accredited qualifications after course completion Receive one-to-one assistance every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Finance: Financial Investigator there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for free. Original Hard Copy certificates need to be ordered at an additional cost of £8. Who is this course for? This Finance: Financial Investigator course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skills. Prerequisites This Finance: Financial Investigator does not require you to have any prior qualifications or experience. You can just enroll and start learning. This Finance: Financial Investigator was made by professionals and it is compatible with all PCs, Macs, tablets, and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as a bonus, you will be able to pursue multiple occupations. This Finance: Financial Investigator is a great way for you to gain multiple skills from the comfort of your home.   Module 1: Introduction to Financial Investigator Introduction to Financial Investigator 00:21:00 Module 2: Introduction to Financial Investigation Introduction to Financial Investigation 00:14:00 Module 3: Characteristics of Financial Crimes Characteristics of Financial Crimes 00:13:00 Module 4: Categories of Financial Crimes Categories of Financial Crimes 00:20:00 Module 5: Financial Crime Response Plan Financial Crime Response Plan 00:18:00 Module 6: Collecting, Preserving and Gathering Evidence Collecting, Preserving and Gathering Evidence 00:13:00 Module 7: Laws against Financial Fraud Laws against Financial Fraud 00:18:00 Assignment Assignment - Finance: Financial Investigator 03:00:00

Unlock a deeper understanding of the human mind with our Psychology of Anxiety & Stress Diploma. Explore the intricacies of anxiety and stress, learn effective coping mechanisms, and gain valuable insights into mental well-being. This comprehensive online course offers expert guidance, empowering you to navigate the complexities of psychological stressors. Elevate your knowledge, enhance your emotional intelligence, and embark on a journey towards a healthier, more resilient mindset. Enroll now for a transformative learning experience in the fascinating realm of psychology.

Duration 2 Days 12 CPD hours This course is intended for Anyone with the need to understand how business analysis is performed to support agile projects or who must transition their existing business analysis skills and practices from waterfall to agile. Overview In this course, students will: Understand the fundamentals of agile delivery and agile business analysis Compare and contrast business analysis on waterfall and agile projects Explain the value proposition for agile product development Define the 4 main types of project life cycles Complete an in-depth walkthrough of the agile delivery life cycle Explain the major flavors of agile Understand the major standards available to assist in transition of skills Define business analysis tailoring and understand how to apply it Learn over 20 business analysis techniques commonly used on agile projects In this course, students will gain an understanding about agile business analysis. Students will learn how business analysis on an agile project is ?the same? and ?different? than business analysis performed on waterfall projects. Students will understand how the business analysis role changes on an agile team. A number of business analysis techniques suited for supporting agile teams will be introduced as will the various standards available to the community to help teams and organizations transition. Since few organizations are pure agile, students will also learn about delivery approaches that use a combination of practices from waterfall and agile and will also be introduced to the important concept of business analysis tailoring ? the key skill used to adapt business analysis skills to all environments ? regardless of the delivery life cycle selected. Introduction What is agile The Agile Manifesto Agile principles Agile benefits Hands-on activity Learning and course objectives The current state of agile Agile trends Agile skills Value proposition The business case for agile The BA role changes on an agile project Hands-on activity Understanding project life cycles Project life cycle Product life cycle Incremental versus Iterative Hybrid approaches to delivery Choosing a project life cycle An in-depth look at Agile The agile development life cycle A sequence of iterations Essential concepts Inside each iteration Iteration goal Iteration planning Sequence of tasks Work period Testing End of iteration activities Evaluation and feedback Structured walkthroughs Evaluation guidelines The BA role in structured walkthroughs Scripting scenarios Defect list Retrospectives Hands-on exercise Type of Agile Delivery Approaches The flavors of agile Scrum Scrum roles Extreme Programming (XP) Dynamic System Development Method (DSDM) Feature Driven Development (FDD) Testing Best practices used by FDD Kanban Kanban Boards Agile Unified Process Scaling Frameworks Introduction to Agile Business Analysis What is business analysis? What is agile business analysis? Framework for agile business analysis Business analysis components International Institute of Business Analysis (IIBA©) Project Management Institute (PMI©) Context to business analysis Our industry BA standards Our industry Agile BA standards Product Owners What stays the same What is expected to change Agile requirements deliverables Lightweight documentation Requirements repository Where business analysis fits in The BA workload Hands-on exercise Business Analysis Tailoring Business analysis tailoring (defined) Tailoring considerations What tailoring looks like The PMI Guide to Business Analysis Determining the ?best? BA approach Methodology vs Standard Why use methodologies Determining your methodology Business analysis impacts Tools and techniques for agile business analysis Agile BA techniques Backlog refinements Behavior Driven Development (BDD) Burndown chart Collaborative games Definition of done Definition of ready INVEST Iteration planning Kanban board Minimum marketable features (MMF) Minimum viable product (MVP) MoSCoW Narrative writing Persona analysis Product roadmap Progressive Elaboration Prototyping Purpose alignment model Retrospectives Story slicing Hands-on Exercise Prioritization Techniques Requirements prioritization Prioritizing on agile projects Prioritization criteria Business benefit MoSCoW Pair-choice comparison Setting priorities with multi-voting Cost to acquire and operate Determining business value Story point estimating Planning poker Project velocity Hands-on activity Course wrap-up Making the transition to agile How my role will be different Course summary Retrospective Questions Additional course details: Nexus Humans BA08 - Agile for Business Analysts 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 BA08 - Agile for Business Analysts course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 1 Days 6 CPD hours This course is intended for This course is intended for: Data platform engineers Architects and operators who build and manage data analytics pipelines Overview In this course, you will learn to: Compare the features and benefits of data warehouses, data lakes, and modern data architectures Design and implement a batch data analytics solution Identify and apply appropriate techniques, including compression, to optimize data storage Select and deploy appropriate options to ingest, transform, and store data Choose the appropriate instance and node types, clusters, auto scaling, and network topology for a particular business use case Understand how data storage and processing affect the analysis and visualization mechanisms needed to gain actionable business insights Secure data at rest and in transit Monitor analytics workloads to identify and remediate problems Apply cost management best practices In this course, you will learn to build batch data analytics solutions using Amazon EMR, an enterprise-grade Apache Spark and Apache Hadoop managed service. You will learn how Amazon EMR integrates with open-source projects such as Apache Hive, Hue, and HBase, and with AWS services such as AWS Glue and AWS Lake Formation. The course addresses data collection, ingestion, cataloging, storage, and processing components in the context of Spark and Hadoop. You will learn to use EMR Notebooks to support both analytics and machine learning workloads. You will also learn to apply security, performance, and cost management best practices to the operation of Amazon EMR. Module A: Overview of Data Analytics and the Data Pipeline Data analytics use cases Using the data pipeline for analytics Module 1: Introduction to Amazon EMR Using Amazon EMR in analytics solutions Amazon EMR cluster architecture Interactive Demo 1: Launching an Amazon EMR cluster Cost management strategies Module 2: Data Analytics Pipeline Using Amazon EMR: Ingestion and Storage Storage optimization with Amazon EMR Data ingestion techniques Module 3: High-Performance Batch Data Analytics Using Apache Spark on Amazon EMR Apache Spark on Amazon EMR use cases Why Apache Spark on Amazon EMR Spark concepts Interactive Demo 2: Connect to an EMR cluster and perform Scala commands using the Spark shell Transformation, processing, and analytics Using notebooks with Amazon EMR Practice Lab 1: Low-latency data analytics using Apache Spark on Amazon EMR Module 4: Processing and Analyzing Batch Data with Amazon EMR and Apache Hive Using Amazon EMR with Hive to process batch data Transformation, processing, and analytics Practice Lab 2: Batch data processing using Amazon EMR with Hive Introduction to Apache HBase on Amazon EMR Module 5: Serverless Data Processing Serverless data processing, transformation, and analytics Using AWS Glue with Amazon EMR workloads Practice Lab 3: Orchestrate data processing in Spark using AWS Step Functions Module 6: Security and Monitoring of Amazon EMR Clusters Securing EMR clusters Interactive Demo 3: Client-side encryption with EMRFS Monitoring and troubleshooting Amazon EMR clusters Demo: Reviewing Apache Spark cluster history Module 7: Designing Batch Data Analytics Solutions Batch data analytics use cases Activity: Designing a batch data analytics workflow Module B: Developing Modern Data Architectures on AWS Modern data architectures

Duration 5 Days 30 CPD hours This course is intended for Consultants, Support, System Administrators Overview Upon completion of the course, students will be able to: Run a business process. Create a business process using the Graphical Process Modeler. Explain how to create a service configuration. Explain how to track an executable business process. Discuss the basics of Sterling B2B Integrator. This course teaches students techniques, tools, and recommended practices that can be used to run a business process, create a business process using the Graphical Process Modeler, explain how to create a service configuration, explain how to track an executable business process, and discuss the basics of Sterling B2B Integrator through a combination of lecture and hands-on labs. About IBM Sterling B2B Integrator High level overview of the Admin Console with an exercise to start the application XML and XPath Basics Review the basics of XML and XPath which is heavily used in the application Basic Business Process Concepts Reviewing what XML and XPath components are used to build business processes Reviewing how to manually execute a business process within the application Tracking and Troubleshooting Business Processes Exercises to demonstrate how to work with business process instances Graphical Process Modeler (GPM) Overview of the Graphical Process Modeler Exercises to walk through the development of a business process in the GPM Exercises for checking in, executing, and modifying business processes Introduction to Service Management Several exercises showcasing specific services/adapters and other functionality Best Practices Covers specific business process development methods that are best practice Mapping Introduction to the Map Editor and Standards Exercises to build and use an XML Encoder Map Typing Map Exercises to build and use a Typing Map Case Study Exercise to build an end-to-end solution using what was learned in previous exercises Tracking System Health Review of archiving, migrating, and deleting business processes Additional course details: Nexus Humans IBM Sterling B2B Integrator 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 IBM Sterling B2B Integrator 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.

Duration 5 Days 30 CPD hours This course is intended for The primary audience for this course are Application Consultants, Data Consultants/Managers, Developers, Program/Project Managers, and System Administrators. Overview This course is designed to give you the comprehensive skills needed to work with the Information Design Tool. The Information Design Tool enables designers to extract, define, and manipulate metadata from relational and OLAP sources to create and deploy SAP BusinessObjects universes.In this course you learn how to use data from different source systems (SAP and non-SAP) with the SAP BusinessObjects BI client tools. This five-day course is designed to give you the comprehensive skills and in-depth knowledge needed to create SAP BusinessObjects universes using the SAP BusinessObjects Information Design Tool. Basic SAP BusinessObjects Universe Design Describing Universes Defining the Components of a Universe Data Connections Defining connections Data Foundations Creating Data Foundations Using Joins Business Layers Accessing Data through the Business Layer Integrating the Business Layer Components Validating Objects Creating Measure Objects Creating Shortcut Joins Loops in a Data Foundation Resolving Loops with Joined Tables Resolving Loops Using Aliases Resolving Loops Using Contexts Detecting Contexts Editing Contexts Testing Contexts Resolving Recursive Loops Data Restrictions Defining Data Restrictions Applying Mandatory Data Restrictions Applying Optional Data Restrictions Lists of Values (LOV) Providing a List of Values Parameters Illustrating Runtime Parameters Object @functions Using Object @functions in Queries Applying the Aggregate Awareness Optimization Method Using Other @ Functions Navigation Paths Defining Drill Down Navigation Paths Derived Tables Creating Derived Tables Key Awareness Defining Numeric Keys Universe Management with Data Foundation and Business Layer Views Managing a Universe using the Data Foundation View Managing a Universe using the Business Layer View Universe Optimization Optimizing Universes Using Parameters Universe Deployment and Security Deploying a Universe Securing a Published Universe Creating Data Security Profiles Creating Business Security Profiles Assigning Security Profiles to Users Identifying the Priority of Security Settings Updating a Published Universe SQL Clause Processing Problems Determining How the Order of SQL Clauses Affects Data Returned Detecting Ambiguity Caused by SQL Requests Run Against Joined Tables Resolving Ambiguity Caused by SQL Requests Run Against Joined Tables Identifying Fan Traps Resolving Ambiguity Caused by SQL Requests Run Against Joined Tables Outer Join Problem Resolution Resolving an Ambiguous Outer Join Using @AggregateAware Universe Creation from Different Data Sources Identifying the Different Data Sources Creating an OLAP Universe Creating a Multi-source Universe Shared Projects Using Shared Projects Manipulating Other Designers' Resources Universe Conversion Converting Existing .unv Universes Translation Deploying Universes in Different Languages

Duration 2 Days 12 CPD hours This course is intended for Application Developers Business Analysts Developer End Users Functional Implementer Java Developer System Analysts Technical Administrator Overview Create administrator-level personalizations Personalize configurable pages Utilize advanced personalization features Implement flexfields on OA Framework-based pages Create custom look and feel definitions Create user-level personalizations This course will be applicable for customers who have implemented Oracle E-Business Suite Release 12 or Oracle E-Business Suite 12.1. This course will be applicable for customers who have implemented Oracle E-Business Suite Release 12 or Oracle E-Business Suite 12.1.

Duration 5 Days 30 CPD hours This course is intended for This course is intended for Database Administrators, Database Developers, BI professionals, and Business reporting users. Overview Upon successful completion of this course, students will be able to run Queries and retrieve results, perform conditional searches, and retrieve data from multiple tables. Before starting this course, make sure you meet at least one of the following prerequisites: Basic knowledge of the Microsoft Windows operating system and its core functionality. Basic working knowledge of Relational Databases. In this course, students will gain a good understanding of the Transact-SQL language. They will be able to create queries, sort, filter the data, execute procedures with T-SQL. Course Outline 1.Introduction to Microsoft SQL Server 2.Introduction to T-SQL Querying 3.Writing SELECT Queries 4.Querying Multiple Tables 5.Sorting and Filtering Data 6.Working with SQL Server Data Types 7.Using DML to Modify Data 8.Using Built-In Functions 9.Grouping and Aggregating Data 10.Using Subqueries 11.Using Table Expressions 12.Using Set Operators 13.Using Windows Ranking, Offset, and Aggregate Functions 14.Pivoting and Grouping Sets 15.Executing Stored Procedures 16.Programming with T-SQL