Duration 5 Days 30 CPD hours This course is intended for This course is intended for individuals who are Application designers and database developers, database administrators and web server administrators. Overview Upon successful completion of this course, students will be able to work with Oracle database programming using the PL/SQL programming language. They will learn the syntax, structure and features of the language. In this course, students will learn the foundation for the programming series and the use of database-resident stored program units for Oracle 12c. 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 & Substitution Variables Using SQL Developer Using SQL*Plus Choosing a Database Programming Language What is Database Programming? PL?SQL Performance Advantages Integration wth Other Languages PL/SQL Language Fundamentals PL/SQL Program Structure LANGUAGE SYNTAX RULES EMBEDDING SQL WRITING READABLE CODE GENERATING DATABASE OUTPUT SQL*PLUS INPUT OF A 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 & Branching 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 EXTENDED CURSOR TECHNIQUES FOR UPDATE OF Clause WHERE CURRENT OF Clause Using FOR?LOOP Cursors Beyond the Basics: Nested BlocksBeyond the Basics: Declared Subprograms USING DECLARED SUBPROGRAMS DECLARED PROCEDURE DECLARED FUNCTION Introducing Databse-Resident Program Units ABOUT DATABASE---RESIDENT PROGRAMS PHYSICAL STORAGE & EXECUTION TYPES OF STORED PROGRAM UNITS STORED PROGRAM UNIT ADVANTAGES MODULAR DESIGN PRINCIPLES Creating Stored Procedures & 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 & 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 Program Units RECOMPILING PROGRAMS Mass Recompilation Using UTL_RECOMP() DROPPING 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 Packages ABOUT PACKAGES CREATING PACKAGES MAINTAINING PACKAGES PERFORMANCE CONSIDERATIONS Advanced Package Capabilities DEFINER & INVOKER RIGHTS WHITE LITS & ACCESSIBLE BY PERSISTENT GLOBAL OBJECTS DEFINING INITIALIZATION LOGIC OBJECT ORIENTATION SUPPORT Advanced Cursor Techniques USING CUSROS VARIABLES USING SYS_REFCURSOR USING CURSOR EXPRESSIONS Using System-Supplied Package DBMS_OUTPUT() UTL_FILE() FOPEN() EXAMPLE Database Trigger Concepts ABOUT DATABASE TRIGGERS DML EVENT TRIGGER SUB---TYPES DATABASE TRIGGER SCENARIO TRIGGER EXECUTION MECHANISMS TRIGGERS 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 AN 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? DEFININGTHE SCOPE AVAILABLE SYSTEM EVENTS SYSTEM EVENT ATTRIBUTES
ð¢ Online Shipping Course: Mastering the Maritime World Are you ready to set sail on a journey towards expertise in the dynamic realm of shipping? Welcome aboard the 'Online Shipping Course,' a comprehensive program designed to equip you with the knowledge and skills necessary to navigate the intricate waters of the shipping industry successfully. Course Overview: ð Module 1: Introduction to Shipping Embark on your educational voyage by gaining a deep understanding of the fundamentals of shipping. From the history of maritime trade to the different types of vessels, this module sets the stage for a holistic exploration of the shipping industry. ð Module 2: Shipping Documents and Procedures Unravel the complexities of shipping documentation and procedures, essential for smooth and efficient operations. Learn how to navigate bills of lading, invoices, and other critical documents, ensuring compliance and minimizing the risk of errors. Module 3: Maritime Safety and Security Safety is paramount at sea. Delve into the intricacies of maritime safety and security, understanding the protocols, regulations, and technologies that safeguard vessels, crew, and cargo. Stay ahead of the curve with the latest industry best practices. ð° Module 4: Shipping Economics Navigate the economic currents of the shipping world. Explore pricing strategies, market trends, and economic factors influencing the industry. Gain insights into making informed business decisions, optimizing costs, and maximizing profitability. ð¦ Module 5: Containerization and Intermodal Transportation Unlock the secrets of modern shipping with an in-depth look at containerization and intermodal transportation. Understand how containers revolutionized the industry, fostering global trade. Explore the seamless integration of various modes of transportation, from ships to trucks and trains. Why Choose Our Course: ð Global Perspective: Our course provides a global perspective, reflecting the interconnected nature of the shipping industry in today's world. ð Expert Faculty: Learn from industry experts and seasoned professionals with real-world experience, ensuring that you receive the most relevant and up-to-date knowledge. ð» Flexible Learning: Access the course from anywhere in the world, allowing you to learn at your own pace. Engage with interactive content, quizzes, and discussions to reinforce your understanding. Who Should Enroll: Professionals seeking to enhance their skills in the shipping and logistics sector. Students aspiring to enter the maritime industry. Entrepreneurs and business owners involved in international trade. Embark on a transformative learning experience with our 'Online Shipping Course' and become a master navigator in the ever-evolving world of shipping. Enroll now to chart your course to success! ð Course Curriculum Module 1_ Introduction to Shipping Introduction to Shipping 00:00 Module 2_ Shipping Documents and Procedures Shipping Documents and Procedures 00:00 Module 3_ Maritime Safety and Security Maritime Safety and Security 00:00 Module 4_ Shipping Economics Shipping Economics 00:00 Module 5_ Containerization and Intermodal Transportation Containerization and Intermodal Transportation 00:00
This course enables the participants delve into the integration of business ethics and corporate governance, highlighting their synergistic role in fostering responsible corporate behavior. After the successful completion of the course, you will be able to learn about the following, ⦠Analyse the interconnection between business ethics and corporate governance and the impact of each on responsible corporate behaviour. ⦠Discuss the importance of combining strong business ethics and effective corporate governance in achieving responsible corporate behaviour. ⦠Discuss the role of individuals, organizations, and society in promoting business ethics and effective corporate governance. ⦠Analyse the impact of business ethics and corporate governance on various stakeholders. ⦠Apply ethical decision-making frameworks and tools to real-world business scenarios. ⦠Discuss the role of ethical leadership in promoting business ethics and effective corporate governance. ⦠Analyse the impact of ethical leadership on various stakeholders. The course aims to analyze the intricate relationship between business ethics and corporate governance, underscoring their joint impact on cultivating responsible corporate behavior. Participants will explore the pivotal role of individuals, organizations, and society in advancing business ethics and effective governance. The impact of these principles on diverse stakeholders will be scrutinized, and practical application will be emphasized through the use of ethical decision-making frameworks. Additionally, the course will examine the significance of ethical leadership in driving business ethics and effective corporate governance, elucidating its effects on various stakeholders in the business landscape. This course aims to comprehensively analyze the interconnection between business ethics and corporate governance, emphasizing their collective influence on fostering responsible corporate behavior. Participants will delve into the importance of combining robust business ethics and effective corporate governance as integral components in achieving responsible corporate conduct. The role of individuals, organizations, and society in actively promoting business ethics and effective corporate governance will be discussed, along with a detailed analysis of their impact on various stakeholders. Course Structure and Assessment Guidelines Watch this video to gain further insight. Navigating the MSBM Study Portal Watch this video to gain further insight. Business Ethics, Corporate Governance and Organizational Behaviour Self-paced pre-recorded learning content on this topic. Ethics and Governance Dynamics within Organizational Behaviour Put your knowledge to the test with this quiz. Read each question carefully and choose the response that you feel is correct. All MSBM courses are accredited by the relevant partners and awarding bodies. Please refer to MSBM accreditation in about us for more details. There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course. The certificate is designed to enhance the learner's knowledge in the field. This certificate is for everyone eager to know more and get updated on current ideas in their respective field. We recommend this certificate for the following audience. Business Ethics Analyst Corporate Governance Specialist Organizational Behavior Consultant Ethics and Compliance Manager Governance and Risk Analyst Organizational Culture Coordinator Chief Ethics Officer Corporate Social Responsibility Manager Compliance and Ethics Investigator Organizational Development Strategist Average Completion Time 2 Weeks Accreditation 3 CPD Hours Level Advanced Start Time Anytime 100% Online Study online with ease. Unlimited Access 24/7 unlimited access with pre-recorded lectures. Low Fees Our fees are low and easy to pay online.
This course is designed to guide you through Selenium WebDriver and Java, right from the basic to the advanced aspects. Loaded with exercises and examples, this course provides an interactive learning experience.
Learn The Art of Smudging Learn everything you need to know to confidently begin incorporating this powerful Smudging Ceremony into your life today! Smudging is a practice of connecting with the Spirit of specific plants and herbs to help cleanse, uplift, protect, and unite the physical and spiritual planes. Ancient traditions all around the world have incorporated the practice of smudging into their ceremonies. Now is your time to connect with “that which is greater than us”.
Elevate your expertise with our Conference Event Masterclass – your definitive guide to planning and executing flawless events. Dive into essential topics like pre-event planning, programme design, marketing strategies, onsite management, and more. Gain insights into sustainability, international conferences, and the future of hybrid and virtual events. Master sponsorship and fundraising strategies. Ideal for aspiring event managers and seasoned professionals. Unlock the keys to success in conference event management with our comprehensive masterclass.
Master the intricate world of food science with our comprehensive certification course. Explore topics such as food quality, microbiology, preservation, and packaging, gaining practical insights and expertise. Elevate your understanding of the science behind the food we consume, positioning yourself as a knowledgeable professional in this dynamic industry. Join us to embark on a transformative journey in food science and unlock a world of opportunities. Enroll now for a fulfilling and rewarding learning experience!
In the UK, the demand for skilled professionals in Enterprise Resource Planning (ERP) is soaring as companies strive to stay ahead of the competition. Our ERP Diploma is tailored to equip you with the knowledge and expertise to navigate the intricate world of ERP systems, propelling your career to new heights. Through this comprehensive Enterprise Resource Planning (ERP) program, you'll embark on a transformative journey, exploring the intricacies of ERP implementation, integration, and optimization. Gain a deep understanding of critical business processes, from supply chain management to financial operations, and unlock the secrets to maximizing operational efficiency. Courses Are Included in this Enterprise Resource Planning (ERP) - CPD Certified Bundle: Course 01: Diploma in Enterprise Resource Planning (ERP) Course 02: Online Entrepreneurship Training Course 03: Business Productivity Training Course 04: Lean Process and Six Sigma Training Course Course 05: SAP Controlling (CO) - Product Costing S4HANA Course 06: Quality Management and Strategic Training - ISO 9001 Learning Objectives of Enterprise Resource Planning (ERP) Master enterprise resource planning systems implementation and optimization. Develop entrepreneurial mindset for business growth using ERP. Streamline processes and enhance productivity through ERP strategies. Apply Lean and Six Sigma methodologies for efficiency. Gain expertise in SAP product costing using S4HANA. Implement quality management systems aligned with ISO 9001 and much more... Why Choose Our Enterprise Resource Planning (ERP) Course? FREE Enterprise Resource Planning (ERP) certificate accredited Get a free student ID card with Enterprise Resource Planning (ERP) Training Get instant access to this Enterprise Resource Planning (ERP) course. Learn Enterprise Resource Planning (ERP) from anywhere in the world Enterprise Resource Planning (ERP) is affordable and simple to understand Enterprise Resource Planning (ERP) is an entirely online, interactive lesson with voiceover audio Lifetime access to the Enterprise Resource Planning (ERP) course materials Enterprise Resource Planning (ERP) comes with 24/7 tutor support So enrol now in this Enterprise Resource Planning (ERP) Today to advance your career! Start your learning journey straightaway with Enterprise Resource Planning (ERP) - CPD Certified! This Enterprise Resource Planning (ERP) curriculum has been designed by Enterprise Resource Planning (ERP) experts with years of experience behind them. The Enterprise Resource Planning (ERP) course is extremely dynamic and well-paced to help you understand Enterprise Resource Planning (ERP) with ease. You'll discover how to master the Enterprise Resource Planning (ERP) skill while exploring relevant and essential topics. Assessment Process of Enterprise Resource Planning (ERP) - CPD Certified Once you have completed all the courses in the Enterprise Resource Planning (ERP) bundle, you can assess your skills and knowledge with an optional assignment. Our expert trainers will assess your assignment and give you feedback afterward. CPD 60 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Enterprise Resource Planning (ERP) - CPD Certified This Enterprise Resource Planning (ERP) - CPD Certified bundle is suitable for everyone. Requirements Enterprise Resource Planning (ERP) - CPD Certified You will not need any prior background or expertise to enrol in this Enterprise Resource Planning (ERP) - CPD Certified. Career path Enterprise Resource Planning (ERP) - CPD Certified This Enterprise Resource Planning (ERP) - CPD Certified bundle will allow you to kickstart or take your career in the related sector to the next stage. Certificates Certificate Of Completion Digital certificate - Included Certificate Of Completion Hard copy certificate - £29 If you are an international student, you will be required to pay an additional fee of 10 GBP for international delivery, and 4.99 GBP for delivery within the UK, for each certificate