10163 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.

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.

Duration 1 Days 6 CPD hours This course is intended for This course is intended for Administrator, Database Administrator, End User, Network Administrator, and Systems Administrator. Overview Upon completion of this course, students will be able to Describe and determine database security requirements, Understand Oracle security solutions to help meet security requirements, Implement basic database security, Configure network security, and Discover basic security configuration issues. This Introduction to Oracle Database Security Ed 1 training teaches you how to use Oracle Database features to help meet the security, privacy and compliance requirements of your organization. Introduction Course Objectives Course Schedule Detective Security Controls Preventive Security Controls Your Learning Aids Basic Workshop Architecture Understanding Security Requirements Fundamental Data Security Requirements Security Risks Techniques to Enforce Security Choosing Security Solutions Database Access Control: Authentication Protecting Against Database Bypass with Encryption Protecting Sensitive Data Protecting against Application Bypass Detecting Threats Compliance Implementing Basic Database Security Database Security Checklist Reducing Administrative Effort Principle of Least Privilege Objects Protection Configuring Network Security Network Access Control Listener Security Listener Usage Control Manage fine-grained access to external network services Discovering Basic Configuration Issues Accessing Enterprise Manager Security Reports Using Various Security Reports

Duration 1 Days 6 CPD hours This course is intended for Report authors wanting to develop interactive report content, or content disconnected from IBM Cognos servers. In this course, participants increase their IBM Cognos Analytics experience by building interactive reports using Active Report controls, which can be distributed to and consumed by users in a disconnected environment, including mobile devices. Introduction to IBM Cognos Active Reports Examine IBM Cognos Active Reports Convert an existing report into an Active Report Add interactions in Active Reports using Active Report connections Create a basic Active Report Examine interactive behavior of Active Report controls Save a report in the IBM Cognos Analytics portal Save an Active Report to an MHT file Save an Active Report as a report template Use an Active Report as a prompt page Understand Active Report security Use Active Report Connections Examine Active Report connections Filter and select in controls using Active Report connections Examine variables Use a single variable to control multiple controls Use multiple variables to show different data in different controls Use Active Report controls to support mobile device usage Active Report Charts & Decks Add charts to active reports Understand and optimize chart behavior Examine decks and data decks Optimize use of decks Review Master Detail relationships Examine RAVE visualizations

Duration 4.375 Days 26.25 CPD hours This course is intended for The target audience for this course is all Oracle professionals. Among the specific groups for whom this course will be helpful are: Application designers and database developers Database administrators Web server administrators Overview This eTextbook begins with an explanation of the intent and usage of the PL/SQL programming language for database applications. Important reasons why one should incorporate PL/SQL modules within the application architecture right from the initial design and planning phase are presented. Next one learns how to begin building executable PL/SQL program units. One learns about each of the major segments of a working program and how these interact with each other during program execution, including the important error or exception handling capabilities of the language. The final section goes beyond the basics and begins to explore advanced topics that will be useful later in the Sideris Oracle PL/SQL developer textbook series. One learns techniques and features that allow modular and reusable programs to be developed, increasing productivity and maintainability of database applications. his eTextbook introduces one to Oracle database programming using the PL/SQL programming language. One will learn the syntax, structure and features of the language. This textbook will also lay the foundation for the entire Sideris 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. his eTextbook introduces one to Oracle database programming using the PL/SQL programming language. One will learn the syntax, structure and features of the language. This textbook will also lay the foundation for the entire Sideris 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.