10247 Office courses

What Will I Learn? Understand how projects work and be able to control your project process Deploy some of the main ways to avoid budget and schedule over-runs Define your project precisely, for your benefit and everyone else's Establish a clear scope, so you can combat the dreaded 'scope creep' Deal effectively with supporters, critics and bystanders Create time scales on getting the job done using milestone planning Be able to use the world's favourite project planning tool: the Gantt chart Achieve fair and effective allocation of project responsibilities Get the most from your team: motivation, collaboration and communication Predict problems and plan your responses Be able to assess which risks to deal with first Assess which risks to deal with first Apply all six strategies for action on risks available to use Stay in control when people change their minds Deliver your project on budget, on target, and on time Complete the three key tasks to finally close down your project Requirements You won't need any software or materials other than your preferred note-taking device (pen & paper, Evernote or OneNote, or anything in between. You can even use Udemy's built-in note-taking tools (which are private to you). If you have n experience of projects at all, that is absolutely fine. If you do have experience, bring it with you as you watch the videos. If you don't, bring your common sense. Description If you are new to project management, then this Project Management Certificate Course for Manager provides you all the fundamental information of project management that enables you to deliver a project on time, on a budget, and to requirement. Project management is an indispensable component of business life. In order to achieve benefit for both your career and your organization relies on good project management skills and abilities. This course confers you the practical tools, techniques and advice you need for managing a project efficiently. Understand project management fundamentals along with project definition and planning stages, project delivery stage and closure stage so that you get set up to succeed. What will I get? You will get over two and a half hours of high quality video - not just a PowerPoint with a voice over. It is based on Mike's best selling three-hour live seminar and contains over two and a half hours of video, and a wealth of additional templates for you to download and adapt to your work. These will help you to manage your projects practically, for greater control and more success. If you want to deliver your next project on time, on budget and to specification, you can't afford not to take this course. What people say about Mike's live seminar... 'This did what it said on the box - a great deal of practical ideas for planning and managing tasks, along with understanding of key principles for successful delivery' Andrea Duncan, PDP Co-ordinator - University of Northampton 'One of the best seminars I've attended in the last 17 years. Enjoyable practical and useful. I would highly recommend this course' Diane Massey - DSM Legal Solicitors 'If you've never had formal training in project management - you'll learn a huge amount about processes and the secrets to succeeding in your projects' Paul Foxall, Senior Project Officer - Sandwell MBC 'Excellent seminar. I have been on previous project management course. This one seemed very different and much better due to brilliant examples Mike gave.' Emma Oliver, Marketecture 'Excellent content, clearly delivered. Really enjoyed Mike's course and found it exceptionally useful.' Nick Osborn, Fenland RP Ltd 'Very useful. Many excellent strategies to help guide project managers.' Rob Simpson, Basis (Registration) Ltd 'A great overall introduction to project management. I learnt a lot and have a lot I can start to implement tomorrow!' Catherine Mendham, Content Consultants 'Very practical, very useful. Gives confidence in knowing what is important and what is not. Mike is a very engaging speaker.' Louisa Davison, Secret Agent Marketing 'An excellent introduction and a reminder of some of the fundamentals of project management.' Chris Price, Pulse PM Ltd Dr Mike Clayton Mike is on of the UK's leading project delivery experts. He has many years experience of managing projects and integrating change in many companies of varying sizes. Mike has had key roles in managing multi-million pound projects for Vodafone, General Motors, BAA and Transport for London. Organisations of all sizes have benefited from his skills in integrating complex change. You will get real results as his highly practical approach simplifies complex ideas. Mike also has over 20 years' experience of training project managers, throughout the UK and in Europe and the US. He is the author of thirteen top-selling business, management, and personal effectiveness books, including four on project management topics: How to Manage a Great Project On budget. On target. On time. (Pearson, 2014) The Influence Agenda A systematic approach to aligning stakeholders in times of change (Palgrave Macmillan, 2014) Brilliant Project Leader What the best project leaders know, do and say to get results, every time (Pearson, 2012) Risk Happens! Managing risk and avoiding failure in business projects (Marshall Cavendish, 2011) Your Unconditional, No-questions, 30-Day Guarantee The best way to assess how valid this material is in you culture is to try it out. I am so confident that this course will change your life that I offer you an unconditional, no questions asked, full 30 day money-back-in-full guarantee. If you don't think this will give you a real sense of understanding and being in control of your project, then just ask me for your money back. What if you have questions? I will be on hand to answer your questions if you get stuck, puzzled, or just want to know more. As a professional trainer, this is what I do, and I promise to respond within 24 hours of your question arriving with me from Udemy. Enroll Now Enroll for this course now, so you can start to gain control of your projects straight away. Who is the target audience? new and want-to-be project managers project managers who have had no formal training and who want to start to formalise what you have learned on the job beginners and also for intermediates with a few projects under your belt managers and professionals who are starting to need to deliver projects as a part of your day-to-day responsibilities This course will give you a great legup if you need to get involved in your first project... in any capacity Assessment & Certification: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. After you have successfully passed the test, you will be able to buy an internationally recognised Accredited Certificate of Achievement from iStudy. You can however also buy a Course Completion Certificate following the course completion without sitting for the test. Project Management Fundamentals: Know the Principles and Get it Right What is a Project? FREE 00:04:00 The Four Stage Project Lifecycle 00:08:00 Project Stages and Boundaries 00:08:00 One Reason why Projects go Wrong 00:05:00 Terminology used in the Project Stages 00:05:00 More on Project Gateways / Stage Gates 00:02:00 Project Definition Stage: The Vital Foundation to Your Success Define your Project: Goals and Objectives 00:10:00 Understanding Project Scope 00:06:00 Dealing with Scope Creep FREE 00:06:00 Project Definition: Summary 00:03:00 Project Planning Stage: Failing to Plan = Planning to Fail The Book of the Plan 00:05:00 The Stakeholder Engagement Process 00:04:00 Stakeholder Analysis 00:06:00 Milestones are your Best Friends 00:08:00 The Work Breakdown Structure 00:08:00 The Gantt Chart 00:06:00 Tools for Creating a Gantt Chart 00:04:00 The Linear Responsibility Chart (LRC) aka The RACI Chart 00:09:00 The Risk Management Process FREE 00:04:00 Risk Analysis 00:08:00 The Six Strategies for Managing Risks 00:09:00 The Risk Register (or Risk Log) 00:06:00 Project Delivery Stage: Don't you Love it When a Plan Comes Together! The Four Essentials of Leading your Team 00:07:00 Project Delivery - The Three Key Cycles 00:12:00 Project Closure Stage: Deep Sigh - You're Nearly Done Closing your Project in an Orderly Manner 00:08:00 Closing Words 00:01:00

Advertise your product better and improve its Marketing draw Do you feel your product is of genuine quality but isn't getting the sales it deserves? That's because advertising and marketing of the product is falling short. But you don't need to worry as this course will solve your problem. People who work in Advertising are in charge of creating marketing communication that persuades an audience to buy a product or service. These people may create advertisements for the company that employs them, prepare advertisements for a company's customers, or both. Advertising includes the people who create the advertisements as well as those who execute the design, creating the graphic, dialogue, or text for the concept the creative staff develops. A modern marketing team is built from a variety of roles from marketing managers and directors, through technical officers, analysts and more. The scope of these teams can range from market analysis and product promotion to pricing, distribution planning. There is plenty to learn in the world of advertising and marketing. And with this course it will guide you and improve your advertising and marketing ability and most of all boost your sales. Course Highlights Advertising and Marketing Diploma is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Advertising and Marketing Diploma into 83 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 1 day, 20 hours hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Advertising and Marketing Diploma Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Advertising and Marketing Diploma is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Advertising and Marketing Diploma is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Marketing Basics Module One - Getting Started FREE 00:30:00 Module Two - What is Marketing FREE 00:30:00 Module Three - Common Marketing Types (I) 00:30:00 Module Four - Common Marketing Types (II) 00:30:00 Module Five - The Marketing Mix 00:30:00 Module Six - Communicating the Right Way 01:00:00 Module Seven - Customer Communications 00:30:00 Module Eight - Marketing Goals 00:30:00 Module Nine - The Marketing Funnel 01:00:00 Module Ten - Marketing Mistakes (I) 01:00:00 Module Eleven - Marketing Mistakes (II) 01:00:00 Module Twelve - Wrapping Up 00:30:00 Advanced Marketing Diploma- Activities 00:00:00 Mastering Digital Marketing Introduction to Internet Marketing and Reputation Management FREE 00:30:00 How to Optimize Your Site for Every Stage of the Buy Cycle FREE 00:30:00 Build Impression on Your Site 00:30:00 Types of Link Building 01:00:00 Importance of Landing Pages 00:30:00 Difference Between Internet Marketing and Online Customer Service 01:00:00 Concept Of Affiliate Programs 01:30:00 About Of Google Analytics 01:00:00 Online Press Releases 00:15:00 How to Get Traffic from Twitter 00:30:00 Importance of Testing E-Mail Messages 00:15:00 What is Viral Marketing 01:00:00 What is EMail Marketing 00:30:00 Difference Between Images and Video 00:15:00 How to Internet Marketing on Facebook 02:00:00 What is Search Engine Optimization(SEO)? 00:30:00 Understanding Search Results 00:15:00 How to Attract Customer on Your Product? 00:15:00 Time Makes Money 00:30:00 How to Test a Landing Page 00:30:00 Best Web Writing 01:00:00 Ways to Use of Humor in You Internet Marketing 00:15:00 Coupon Codes 00:15:00 When to Pull the Plug 00:15:00 Internet Advertising Techniques INTRODUCTION: WHAT IS AFFILIATE MARKETING? 01:00:00 WHY AFFILIATE MARKETING IS AWESOME 00:30:00 FINDING A PROFITABLE NICHE 00:30:00 CHOOSING AN AFFILIATE PRODUCT 00:30:00 THE ADVANTAGES OF CLICK BANK 00:30:00 ANALYZING THE CLICK BANK MARKETPLACE 00:30:00 CREATING YOUR HOP LINK 00:30:00 CREATING A FREE BLOG 00:30:00 PERFORMING EFFECTIVE KEYWORD RESEARCH 00:30:00 CREATING AN OPTIMIZED POST 01:00:00 POSTING TO YOUR BLOG 00:30:00 PROMOTING YOUR BLOG: AN OVERVIEW 00:30:00 PROMOTION: ARTICLE MARKETING 00:30:00 PROMOTION: SOCIAL BOOKMARKING 00:30:00 PROMOTION: BLOG COMMENTING 00:30:00 ADDITIONAL PROMOTION TIPS 00:30:00 CREATING YOUR OWN WEBSITE 00:30:00 Email Marketing Introduction to Email Marketing 00:30:00 Using Email Marketing Software 00:30:00 Building Email Lists by Quantity 00:30:00 Building Email Lists by Quality 00:30:00 Crafting an Email 01:00:00 Analyzing and Tracking Your Email Marketing Strategy 00:30:00 Facebook Marketing Basics Introduction to Facebook 00:15:00 Why You Should Care 00:15:00 Setting up a Facebook Page 00:30:00 How to Get More Likes for Your Facebook Page 00:30:00 Facebook Advertising 00:30:00 How Much Does Facebook Advertising Cost? 00:30:00 Marketing on Facebook 01:00:00 Create a content calendar 00:15:00 Understanding Edge Rank & the Art of Engagement 00:15:00 Twitter Marketing TWITTER FOR BUSINESS 00:15:00 TOP TWITTER TIPS 00:15:00 TWITTER IS 00:15:00 BUSINESS TERMS 00:15:00 WHY USE TWITTER FOR MARKETING 00:15:00 TWITTER MARKETING BASICS 01:00:00 TWITTER METRICS 00:30:00 YOUR BIO 00:15:00 WHEN TO TWEET 00:15:00 BUILDING YOUR COMMUNITY 00:15:00 GENERATING LEADS 00:15:00 REAL-TIME TWITTER MARKETING 00:15:00 ENGAGEMENT 00:15:00 TWETIQUETTE (TWEETING ETIQUETTE) 00:15:00 Mock Exam Final Exam

24-Hour Knowledge Knockdown! Prices Reduced Like Never Before Did you know that poor communication costs UK businesses an estimated £40 billion a year? Struggling to get your point across or misread body language can lead to misunderstandings, missed deadlines, and frustrated colleagues. Effective communication is the key to a successful career - are you ready to unlock your potential? This comprehensive bundle equips you with the skills you need to become a powerful communicator in any workplace setting. You'll learn effective communication strategies for different situations, from giving clear presentations to delivering constructive feedback. Discover the secrets of nonverbal communication, understand how to build rapport with colleagues, and gain the confidence to lead and manage teams effectively. Our Bundle contains 5 of our premium courses for one discounted price: Course 01: Workplace Communication Management Course 02: Communication Skills Course 03: Business Communication Course 04: The Secrets of Body Language Course 05: Leadership & Management Invest in your future and gain a competitive edge by mastering productive communication strategies, building stronger professional relationships, and contributing to a more collaborative and successful work environment. Enrol Today! Learning Outcomes of Productive Communication Develop strategies for effective workplace communication management. Enhance verbal, non-verbal, and written communication skills. Apply business communication best practices in professional settings. Interpret and utilize body language effectively in communication. Implement leadership and management principles for clear communication. Foster a productive and collaborative work environment through communication. Why Choose Us? Get a Free CPD Accredited Certificate upon completion of Productive Communication Get a free student ID card with Productive Communication Training program (£10 postal charge will be applicable for international delivery) The Productive Communication is affordable and simple to understand This course is entirely online, interactive lesson with voiceover audio Get Lifetime access to the Productive Communication course materials The Productive Communication comes with 24/7 tutor support Start your learning journey straightaway! *** Course Curriculum *** Course 01: Workplace Communication Management Module 01: Information And Communication For Stakeholders Module 02: Communication & Barriers Module 03: Culture And Communication In The Workplace Module 04: Language And Effective Communication Module 05: Business Communication & Interpersonal Relationships Module 06: Communication Improvement At Workplace Course 02: Communication Skills Module 01: Effective Communication Module 02: How to Talk to Anyone Module 03: Power of Storytelling Module 04: Becoming an Influencer Module 05: Importance of Body Language Module 06: Communication Skills for Job Interviews Module 07: Public Speaking Course 03: Business Communication Business Communication Verbal And Non-Verbal Communication Written Communication Electronic Communication Communicating With Graphics Effectively Working For Your Boss =========>>>>> And 2 More Courses <<<<<========= How will I get my Certificate? After successfully completing the course, you will be able to order your Certificates as proof of your achievement. PDF Certificate: Free (Previously it was £12.99*5 = £65) CPD Hard Copy Certificate: £29.99 CPD 50 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this bundle. This bundle is ideal for: Managers and team leaders. Business professionals and executives. Human resources and training professionals. Aspiring leaders and communicators. Requirements You will not need any prior background or expertise to enrol in this bundle. Career path After completing this bundle, you are to start your career or begin the next phase of your career. Communication Manager Corporate Trainer Public Speaker Leadership Coach Business Consultant HR Professional Certificates CPD Accredited Digital Certificate Digital certificate - Included Upon passing the Course, you need to order a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD QS for Free. CPD Accredited Hard Copy Certificate Hard copy certificate - £29.99 Please note that International students have to pay an additional £10 as a shipment fee.

Kids Riso printing workshop. Learn to print with GOOD STUDIO Brixton!

Duration 1 Days 6 CPD hours This course is intended for This course is intended for: Developers responsible for developing Deep Learning applications Developers who want to understand concepts behind Deep Learning and how to implement a Deep Learning solution on AWS Overview This course is designed to teach you how to: Define machine learning (ML) and deep learning Identify the concepts in a deep learning ecosystem Use Amazon SageMaker and the MXNet programming framework for deep learning workloads Fit AWS solutions for deep learning deployments In this course, you?ll learn about AWS?s deep learning solutions, including scenarios where deep learning makes sense and how deep learning works. You?ll learn how to run deep learning models on the cloud using Amazon SageMaker and the MXNet framework. You?ll also learn to deploy your deep learning models using services like AWS Lambda while designing intelligent systems on AWS. Module 1: Machine learning overview A brief history of AI, ML, and DL The business importance of ML Common challenges in ML Different types of ML problems and tasks AI on AWS Module 2: Introduction to deep learning Introduction to DL The DL concepts A summary of how to train DL models on AWS Introduction to Amazon SageMaker Hands-on lab: Spinning up an Amazon SageMaker notebook instance and running a multi-layer perceptron neural network model Module 3: Introduction to Apache MXNet The motivation for and benefits of using MXNet and Gluon Important terms and APIs used in MXNet Convolutional neural networks (CNN) architecture Hands-on lab: Training a CNN on a CIFAR-10 dataset Module 4: ML and DL architectures on AWS AWS services for deploying DL models (AWS Lambda, AWS IoT Greengrass, Amazon ECS, AWS Elastic Beanstalk) Introduction to AWS AI services that are based on DL (Amazon Polly, Amazon Lex, Amazon Rekognition) Hands-on lab: Deploying a trained model for prediction on AWS Lambda Additional course details: Nexus Humans Deep Learning on AWS 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 Deep Learning on AWS 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 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.

Duration 4 Days 24 CPD hours This course is intended for Application Consultant Data Consultant / Manager Developer Consultant Technology Consultant Program / Project Manager Business Analyst Developer User Business Process Owner / Team Lead / Power User Overview This course will prepare you to: Outline SAP Transportation Management business processes Identify and examine the SAP TM building blocks necessary for processing shipments of goods. Engage in Transportation network maintenance, order/requirements integration and management, transportation planning, shipment execution, and freight invoicing and settlement. Use both the SAP ERP and SAP TM systems using the NetWeaver Business Client interface This course will help you to prepare for the blueprinting stage of your SAP Transportation Management implementation or enable you to use the system in your role as a business user. You will gain an overview of the key business transactions and system capabilities to enable you to design the processes you will use within your own organization. You will learn how SAP TM can help you to support Order Management, Transportation Planning, Subcontracting, Execution, Charge Calculation and Settlement. This course is the mandatory foundational prerequisite for all follow-on SAP TM training courses. SAP Transportation Management (SAP TM) Evaluating SAP Transportation Management Evaluating the SAP TM System Landscape SAP TM User Interface Identifying NetWeaver Business Client Components Personalizing Object Worklists Transportation Management Master Data Identifying Master Data Requirements for SAP TM Evaluating the Organizational Structures Used in SAP TM Defining Conditions Determining Freight Incompatibilities Determining Dangerous Goods Shipping Requirements Transportation Order Management Triggering the Transportation Management Process Integrating SAP ERP with SAP TM Managing the Freight Forwarding Process Booking Capacities Transportation Planning Defining the Transportation Planning Process Viewing Freight Units Building Packages Defining Selection Profiles Determining Planning Profiles Accessing the Transportation Cockpit Creating Transportation Proposals Creating Freight Orders Optimizing Loads Transportation Execution Performing Carrier Selection Tendering Freight Orders Triggering Delivery Creation from SAP TM Executing Transportation in SAP ERP Integration between SAP TM and SAP EWM Generating Outputs Monitoring Transportation Events Exporting Freight Orders Analyzing Transportation Management Performance Charge Calculation and Freight Settlement Managing Charge Calculation Master Data Calculating Supplier Charges in Freight Orders Settling Supplier Freight Charges Calculating and Settling Customer Charges in Forwarding Orders Distributing Costs Settling Freight Charges in Group Logistics Companies Managing Freight Contracts

Duration 3 Days 18 CPD hours This course is intended for This course is geared for anyone needing to interface with an Oracle database such as end users, business analysts, application developers and database administrators / DBAs. Overview Working within in a hands-on learning environment, guided by our expert team, attendees will develop a practical approach to Oracle Database Technology. Throughout the course participants will explore: Using PL/SQL programming language for database applications and development incorporating PL/SQL modules within the application architecture from the initial design and planning phase The essentials of building executable PL/SQL program units Each of the major segments of a working program and how these interact with each other during program execution Important error or exception handling capabilities of the language. How database-resident program units can be used as part of the overall database application architecture Applying these new skills to the development of PL/SQL packages. Advanced database programming capabilities and benefits How database triggers can be used as part of an advanced database application design Oracle 19c PL/SQL Fundamentals is a three-day, hands-on course that introduces Oracle database programming using the PL/SQL programming language. Throughout the course students will explore the core syntax, structure and features of the language. This course will also lay the foundation for the entire Oracle PL/SQL programming series, allowing one to progress from introductory topics to advanced application design and programming and finally onto writing complex high-performance applications. The course also explores applying the newly learned skills to the development of database applications. Participants will learn how to use database-resident stored program units such as procedures, functions, packages and database triggers. Students will also learn about the latest features in Oracle 19c. Selection & Setup of the Database Interface Considering Available Tools Selecting the Appropriate Tool Oracle Net Database Connections Oracle PAAS Database Connections Setup SQL Developer Setup SQL *Plus Setup JDeveloper About BIND and Substitution Variables Using SQL Developer Using SQL *Plus Choosing a Database Programming Language What is Database Programming PL/SQL Programming PL/SQL Performance Advantages Integration with Other Languages PL/SQL Language Essentials PL/SQL Program Structure Language Syntax Rules Embedding SQL Writing Readable Code Generating Readable Code Generating Database Output SQL * Plus Input of Program Block DECLARE Section About the Declare Section Declare Primitive Types Declaration Options Not Null Constant Data Dictionary Integration % Type Declare Simple User-Defined Types Type ? Table Type ? Record Extended User Defined Types BEGIN Section About the Begin Section Manipulating Program Data Logic Control & Braching GOTO LOOP IF-THEN-ELSE CASE EXCEPTION Section About the Exception Section Isolating the Specific Exception Pragma Exception_INIT SQLCODE &SQLERRM Example SQL%ROWCOUNT & Select ? Into Beyond the Basics : Explicit Cursors About Explicit Cursors Extend Cursor Techniques For Update of Clause Where Current of Clause Using for ? Loop Cursors Introduction Database Resident Programming Units About Database ? Resident Programs Physical Storage & Execution Types of Stored Program Units Stored Program Unit Advantages Modular Design Principles Creating Stored Procedures and Functions Stored Procedures & Functions Create Procedure / Create Function Creating Procedures & Functions Raise_Salary() Procedure Salary_Valid() function The Parameter Specification Default Clause System & Object Privileges Using the Development Tools Executing Stored Procedures and Functions Calling Procedures & Functions Unit Testing with Execute Anonymous Block Unit Testing Specifying a Parameter Notation SQL Worksheet Unit Testing Calling Functions from SQL Maintaining Stored Programming Units Recompiling Programs Mass Recompilation Using UTL_RECOMP() Dropping Procedures & Functions Drop Procedures & Functions Drop Procedure / Function Data Dictionary Metadata Using USER_OBJECTS Using USER_SOURCE Using USER_ERRORS Using USER_OBJECT_SIZE Using USER_DEPENDENCIES Managing Dependencies Dependency Internals Tracking Dependencies The Dependency Tracking Utility SQL Developer Dependency Info Dependency Strategy Checklists Creating & Maintaining About Packages Creating Packages Maintaining Packages Performance Considerations Advanced Package Capabilities Definer & Invoker Rights White Lists & Accessible By Persistent Global Objects Defining Initilization Logic Object Orientation Support Advanced Cursor Techniques Using Cursor Variables Using SYS_REFCURSOR Using Cursor Expressions Using System Supplied Packages DBMS_OUTPUT() UTL_FILE() FOPEN() Example Database Trigger Concepts About Database Triggers DML Event Trigger Sub-Types Database Trigger Scenario Trigger Exhaustion Mechanisms Trigger within SQL Worksheet Creating Database Triggers Statement Level Triggers Using Raise Application_Error() Row-Level Triggers Examples of Triggers Employee_Salary_Check Example Employee_Journal Example Budget_Event Example Instead of Triggers Triggers within and Application Maintaining Database Triggers Call Syntax Trigger Maintenance Tasks Show Errors Trigger Drop Trigger Alter Trigger Multiple Triggers for a Table Handling Mutating Table Issues Implementing System Event Triggers What are System Event Triggers Defining the Scope Available System Events System Event Attributes

Duration 5 Days 30 CPD hours This course is intended for This intermediate-level course requires students have incoming experience working with Oracle Database 18 or higher. Overview Working in a hands-on learning environment led by our expert facilitator, you'll explore: The Oracle Database Architecture Query Optimizer Tuning Container Databases and Pluggable Databases Oracle 19c Tuning features Evaluating Execution Plans Oracle Tuning Tools Using Automatic Workload Repository Join Types AWR Using Baselines Additional AWR performance tools Optimizer Statistics Monitoring a Service Bind Variables and database parameters Oracle's Real Application Testing (RAT) SQL Tuning Advisor Automatic Sql Tuning Sql Plan Management Shared Pool Tuning Tuning the database buffer cache Tuning the PGA (Program Global Area) Automatic Memory Management (AMM) Tuning Segment Space Utilization (ASSM) Automatic Storage Management Oracle 19C Database Tuning is an intermediate level course for Oracle database experienced attendees that explores core tuning skills such as Database parameters, SQL Tuning Advisor, SQL Access Advisor, Adaptive SQL plans and more. Overview Oracle Database Architecture Instance Definition Define SGA Define Background Processes Datafile Definition Query Optimizer SQL Parsing Optimizing Terms Optimizing Methods Query Plan Generation Query Plan Control Tuning Container Databases and Pluggable Databases Pluggable tuning parameters Define Container tuning structure Using PDB$SEED Create a new PDB Plug and unplug a PDB Oracle 12c Tuning features Identifying and Using Oracle's Heat Map 12c Compression Levels and Types Evaluating Execution Plans Defining SQL execution plans Automatic Workload Repository Reading execution plans Oracle Tuning Tools Monitoring tools overview Enterprise Manager Dynamic Performance Views Automatic Workload Repository Automatic Database Diagnostic Monitor Sql Tuning Advisor SQL Access Advisor Sql Access Advisor DB operation Tuning DB operation Active Reporting Using Automatic Workload Repository Defining AWR AWR Settings Creating AWR Baselines Metrics, Alerts, and Thresholds Defining Metrics Setting Alerts Setting Corrective Actions User Defined Metrics Metric Dynamic Views Join Types Nested Loops Join Sort Merge join Hash Join and Cartesian Join Equijoins and Nonequijoins Outer Joins Semijoins AWR Using Baselines Creating AWR baselines Creating AWR Repeating baselines Moving Window Baseline Additional AWR performance tools Automatic Maintenance Tasks Segment Advisor Statistics Gathering Automatic Tuning Optimizer Automatic Database Diagnostic Monitor Active Session History (ASH) Optimizer Statistics Optimizer Statistics Overview Table and Index Statistics Statistic Preferences Statistics Gathering e) Locking Statistics, Export/Import Statistics Pending and published statistics Optimizer Hints Optimizer Paths Cost Base Optimization Monitoring a Service Overview of what is an Oracle Service Creating an Oracle Service for Single instance and RAC Monitoring a Service Resource Management and a Service Enterprise Manager and a Service Bind Variables and database parameters Bind variable definition Cursor_sharing parameter Adaptive Cursor Sharing Oracle's Real Application Testing (RAT) Sql Performance Analyzer overview Sql Performance Analyzer Options Database Parameter changes Database version changes Creating SQL Tuning Sets Database Replay Overview Database Replay Configuration Database Replay Options SQL Tuning Advisor SQL Tuning Advisor: Overview SQL Tuning Advisor Limited Mode Sql Tuning Advisor Comprehensive mode Sql Tuning Profiles SQL Access Advisor SQL Access Advisor: Overview Sql Access Advisor options SQL Access Advisor and Sql Tuning Sets Sql Access Advisor and AWR Results and Implementation Automatic Sql Tuning Automatic Sql Tuning Maintenance Task Automatic Tuning Optimization implementation(ATO) Automatic Tuning Optimization Results Enable/Disable Automatic Tuning Optimization Sql Plan Management Sql plan Management and baseline overview Enable sql plan management Loading Sql Plan baselines into the SGA Adaptive plan management Shared Pool Tuning Shared pool architecture Shared pool parameters Library Cache Dictionary cache Large pool considerations and contents Tuning the database buffer cache Database buffer cache overview Database buffer cache parameters Oracle and Dirty reads and writes Automatic Shared Memory Management (ASMM) Buffer Cache goals and responsibility Buffer Cache pools Tuning the PGA (Program Global Area) PGA Overview PGA Database Parameters Temporary Segments Temporary Tablespace Sizing the PGA Automatic Memory Management (AMM) Oracle's Automatic Memory Management Overview Database Auto-tuned Parameters Database Non Auto-tuned Parameters Automatic Memory Management Hints and Sizing suggestions AMM versus ASMM Tuning Segment Space Utilization (ASSM) Overview of Automatic Segment Space Management Defining the DB_BLOCK_SIZE Defining DB_nk_CACHE_SIZE parameter The DB_BLOCK_SIZE Parameter Overview of table compression, block chaining, and block migration Automatic Storage Management Overview of ASM Definition of Grid Infrastructure ASM Instance ASM Diskgroups ASM Diskgroup parameters and templates ASMCMD

Duration 3 Days 18 CPD hours This course is intended for This course is appropriate for anyone needing to interface with an Oracle database or those needing a general understanding of Oracle database functionality. That would include end users, business analysts, application developers and database administrators. Overview Working in a hands-on learning environment led by our expert pracitioner you'll learn how to: Add Data, Retrieve, Sort and Organize a SQL Database Combine Data, Set Operators and Subqueries Manipulate Data and Data Definition Languages in SQL Work with Data Dictionary Views and Create Sequences, Indexes and Views Use Database Objects and Subqueries Perform Data and access control Perform other Advanced Level Database operations. Oracle 19C SQL Programming Fundamentals Is a three-day, hands-on course designed to equip you with the fundamental skills needed to set up, run and manage SQL databases using Oracle Database Technology. You will also be discovering all the tools and concepts required to organize data efficiently. Our engaging instructors and mentors are highly-experienced practitioners who bring years of current 'on-the-job' experience into every classroom. Working within in a hands-on learning environment, guided by our expert team, attendees will develop a practical approach to Oracle Database Technology. Throughout the course, you will learn the key elements of a database, and the way Oracle systems facilitate their induction in the system. You?ll also learn the tools and strategies you can implement to store, retrieve, compare and organize data according to your requirements. You?ll also explore the process of creating simple to complex reports from existing data. By the end of this course, you will also have hands-on knowledge of SQL systems that are required to proceed to other advanced to professional programs. Adding Data, Retrieving, Sorting and Organizing a SQL Database The building blocks of a database. How to add data to the database. The process of retrieving data using SQL functions. Multiple methods of sorting and organizing data. Using SQL functions to get the required simple to complex output. Various strategies for using functions and conditions to organize data. Combining Data, Set Operators And Subqueries Consolidating data using multiple functions and group operators. Fetching intelligent data reports using simple functions. Fetching data from multiple sources in the tables. Using Subqueries to compile data as required. Using Set operators to create smart data reports. Data Manipulation and Data Definition Languages in SQL Describing and managing data transaction using Data Definition Language. Categorize and review data tables using Data Definition Language. Data Dictionary Views and Creating Sequences, Indexes and Views How to manage and query Data Dictionary Views. The process of creating and using Sequences. How to create various types of Synonyms and Indexes. Creating simple and complex views and retrieving data. Understanding and using Database Objects and Subqueries Core concept and application of Schema Objects. Fetching required data with Subqueries. Using Subqueries to organize Data in SQL. Data and access control Assigning and revoking data access. Managing data access control according to user levels. Performing Advanced Level Database operations. Using advanced functions and performing data queries. Creating and managing time zone-based databases.