3035 Courses delivered Online

Are you passionate about creating unforgettable celebrations? Do you dream of turning your love for parties into a thriving business? Look no further! Our "Everything on Party Planning" course is your ultimate guide to becoming a professional party planner. With comprehensive modules covering every aspect of party planning, you'll gain the skills and knowledge needed to make every event a spectacular success. Key Features: CPD Certified Free Certificate from Reed CIQ Approved Developed by Specialist Lifetime Access In the "Everything on Party Planning" course, learners will explore the essentials of being a successful party planner. They will develop key skills needed to organize different types of parties, considering the preferences and demographics of guests. The course covers how to choose engaging themes, manage food and beverages, and work effectively with various vendors. Students will learn about venue selection and how to meet specific requirements for different events. The curriculum also includes practical aspects such as initial planning, budgeting, and starting a party planning business. Additionally, learners will discover strategies to build a client base, network effectively, and handle various business functions. By the end of the course, participants will be equipped with the knowledge and skills to make any event memorable and successful. Course Curriculum Module 01: Introduction to Party Planner Module 02: Skills You Need to Be a Party Planner Module 03: Types of Parties - Overview Module 04: Guest Demographics Module 05: Choosing a Theme Module 06: Food and Beverage Module 07: Vendors Every Party Planner Should Know Module 08: Venue Requirements Module 09: Initial Planning and Budgeting Module 10: Starting Your Party Planning Business Module 11: Generating a Client Base Module 12: Networking Module 13: Party Planning Business Functions Module 14: Making the Day Memorable Learning Outcomes: Understand the role and responsibilities of a party planner. Identify essential skills needed for successful party planning. Recognize different types of parties and their unique requirements. Analyse guest demographics to tailor party elements. Create themed parties with appropriate food and beverages. Plan and budget effectively for party events. CPD 10 CPD hours / points Accredited by CPD Quality Standards Everything on Party Planning 2:23:33 1: Module 01: Introduction to Party Planner 07:20 2: Module 02: Skills You Need to Be a Party Planner 09:51 3: Module 03: Types of Parties - Overview 08:07 4: Module 04: Guest Demographics 08:12 5: Module 05: Choosing a Theme 09:30 6: Module 06: Food and Beverage 07:28 7: Module 07: Vendors Every Party Planner Should Know 10:51 8: Module 08: Venue Requirements 10:23 9: Module 09: Initial Planning and Budgeting 11:34 10: Module 10: Starting Your Party Planning Business 08:10 11: Module 11: Generating a Client Base 13:49 12: Module 12: Networking 10:39 13: Module 13: Party Planning Business Functions 10:41 14: Module 14: Making the Day Memorable 15:58 15: CPD Certificate - Free 01:00 Who is this course for? Aspiring party planners. Event management students. Individuals interested in hosting parties. Entrepreneurs starting a party planning business. Professionals in the hospitality industry. Career path Event Planner Party Consultant Wedding Coordinator Corporate Event Coordinator Venue Manager Catering Manager Certificates Digital certificate Digital certificate - Included Reed Courses Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

Are you looking to enhance your Data Analysis with Excel skills? If yes, then you have come to the right place. Our comprehensive course on Data Analysis with Excel will assist you in producing the best possible outcome by mastering the Data Analysis with Excel skills. The Data Analysis with Excel is for those who want to be successful. In the Data Analysis with Excel, you will learn the essential knowledge needed to become well versed in Data Analysis with Excel. Our Data Analysis with Excel starts with the basics of Data Analysis with Excel and gradually progresses towards advanced topics. Therefore, each lesson of this Data Analysis with Excel is intuitive and easy to understand. Why would you choose the Data Analysis with Excel from Compliance Central: Lifetime access to Data Analysis with Excel materials Full tutor support is available from Monday to Friday with the Data Analysis with Excel Learn Data Analysis with Excel skills at your own pace from the comfort of your home Gain a complete understanding of Data Analysis with Excel Accessible, informative Data Analysis with Excel learning modules designed by expert instructors Get 24/7 help or advice from our email and live chat teams with the Data Analysis with Excel bundle Study Data Analysis with Excel in your own time through your computer, tablet or mobile device. A 100% learning satisfaction guarantee with your Data Analysis with Excel Improve your chance of gaining in demand skills and better earning potential by completing the Data Analysis with Excel Data Analysis with Excel Curriculum Breakdown of the Data Analysis with Excel Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows Search for and Replace Data Use Proofing and Research Tools Working with Lists Sort Data Filter Data Query Data with Database Functions Outline and Subtotal Data Analyzing Data Apply Intermediate Conditional Formatting Apply Advanced Conditional Formatting Visualizing Data with Charts Create Charts Modify and Format Charts Use Advanced Chart Features Using PivotTables and PivotCharts Create a PivotTable Analyze PivotTable Data Present Data with PivotCharts Filter Data by Using Timelines and Slicers Working with Multiple Worksheets and Workbooks Use Links and External References Use 3-D References Consolidate Data Using Lookup Functions and Formula Auditing Use Lookup Functions Trace Cells Watch and Evaluate Formulas Automating Workbook Functionality Apply Data Validation Search for Invalid Data and Formulas with Errors Work with Macros Creating Sparklines and Mapping Data Create Sparklines MapData Forecasting Data Determine Potential Outcomes Using Data Tables Determine Potential Outcomes Using Scenarios Use the Goal Seek Feature Forecasting Data Trends CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Data Analysis with Excel helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career in Data Analysis with Excel. It is also great for professionals who are already working in Data Analysis with Excel and want to get promoted at work. Requirements To enrol in this Data Analysis with Excel, all you need is a basic understanding of the English Language and an internet connection. Career path The Data Analysis with Excel will enhance your knowledge and improve your confidence in exploring opportunities in various sectors related to Data Analysis with Excel. Certificates CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99

Bring data to life with the D3.js data visualization library, and get up to speed with JavaScript, HTML, and CSS to build stunning data visuals

Boost Your Career By Enrolling In This IT Support Technician Bundle To Overcome Your Challenges! 07 in 1 IT Support Technician Bundle Improve your knowledge and enhance your skills to succeed with this IT Support Technician bundle. This IT Support Technician bundle is designed to build your competent skill set and enable the best possible outcome for your future. Our bundle is ideal for those who aim to be the best in their fields and are always looking to grow. This IT Support Technician Bundle Contains 07 of Our Premium Courses for One Discounted Price: Course 01: Learn Programming with Python Course 02: Cloud Computing / CompTIA Cloud+ (CV0-002) Course 03: Mastering SQL Programming Course 04: IT: Ethical Hacking & IT Security Course 05: CompTIA CySA+ Cybersecurity Analyst (CS0-002) Course 06: Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query Course 07: Building Your Computer Course All the courses under this IT Support Technician bundle are split into a number of expertly created modules to provide you with an in-depth and comprehensive learning experience. Upon successful completion of the IT Support Technician bundle, an instant e-certificate will be exhibited in your profile that you can order as proof of your new skills and knowledge. Stand out from the crowd and get trained for the job you want. With this comprehensive IT Support Technician bundle, you can achieve your dreams and train for your ideal career. This IT Support Technician bundle covers essential aspects in order to progress in your chosen career. Why Prefer Us? All-in-one package of 07 premium courses IT Support Technician bundle Earn a certificate accredited by CPD. Get a free student ID card! (£10 postal charges will be applicable for international delivery) Globally accepted standard lesson planning Free Assessments 24/7 tutor support. Start your learning journey straightaway! *** Course Curriculum *** Our IT Support Technician bundle courses consist of the following learning modules: Course 01: Learn Programming with Python Module 01: An Installing Python FREE Documentation Command Line Variables Simple Python Syntax Keywords Import-Module Module 02: Additional Topics If Elif Else Iterable For Loops Execute Exceptions Module 03: Data Types Number Types More Number Types Strings More Strings Files Lists Dictionaries Tuples Sets Module 04: Comprehensions Definitions Functions Default Arguments Doc Strings Variadic Functions Factorial Module 05: Function Objects Lambda Generators Closures Classes Object Initialization Class Static Members Classic Inheritance Data Hiding Assessment Process Once you have completed all the courses in the IT Support Technician bundle, you can assess your skills and knowledge with an optional assignment. Our expert trainers will assess your assignment and give you feedback afterwards. CPD 70 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This IT Support Technician bundle is suitable for everyone. Requirements You will not need any prior background or expertise. Career path This IT Support Technician bundle will allow you to kickstart or take your career in the related sector to the next stage. Certificates Accredited Certificate by CPD QS Digital certificate - £10 Upon passing the Bundle, you need to order to receive a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD QS Accredited Certificate by CPD QS Hard copy certificate - £29 Upon passing the Bundle, you need to order to receive a Hard copy Certificate for each of the courses inside this bundle. If you are an international student, then you have to pay an additional 10 GBP as an international delivery charge.

The aim of the Introduction to Commercial Banks course is to provide students with a foundational understanding of commercial banking operations and their role in the economy. The course will equip students with the knowledge and skills to evaluate the risks and opportunities associated with banking, as well as the regulatory framework that governs banks. After the successful completion of the course, you will be able to learn about the following, Identify types of commercial banks and their roles. Analyze the evolution of commercial banks. Evaluate services provided by commercial banks. Assess the relationship between commercial banks and competitors. Evaluate the impact of key trends on banks. Explain the functions of central banks. Compare central banks and commercial banks. Analyze the concept of Central Bank Digital Currency (CBDC). Evaluate the role of commercial banks in CBDCs. Recognize the significance of commercial banks. The Introduction to Commercial Banks course provides an overview of the role of commercial banks in the economy, including their functions, products, and services. Students will learn about the regulatory environment that governs banks, as well as the risks and opportunities involved in banking operations. By the end of the course, students will have a comprehensive understanding of how commercial banks operate and their impact on the financial system. Introduction to Commercial Banks is a comprehensive course designed to provide an understanding of the role and function of commercial banks in the financial system. The course covers the basics of banking, including the types of commercial banks, their operations, and their regulatory framework. Students will gain practical knowledge of banking practices, such as loans, deposits, and investment management. VIDEO - Course Structure and Assessment Guidelines Watch this video to gain further insight. Navigating the MSBM Study Portal Watch this video to gain further insight. Interacting with Lectures/Learning Components Watch this video to gain further insight. Introduction to Commercial Banks Self-paced pre-recorded learning content on this topic. Introduction to Commercial Banks 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. Bank Teller Personal Banker Loan Officer Credit Analyst Commercial Bank Manager Investment Banker Treasury Analyst Financial Consultant Risk Manager Compliance Officer. 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.

Duration 3.5 Days 21 CPD hours This course is intended for This course is aimed at students new to the language who may or may not have experience with other programming languages. Overview Learn how Python works and what it's good for. Understand Python's place in the world of programming languages Learn to work with and manipulate strings in Python. Learn to perform math operations with Python. Learn to work with Python sequences: lists, arrays, dictionaries, and sets. Learn to collect user input and output results. Learn flow control processing in Python. Learn to write to and read from files using Python. Learn to write functions in Python. Learn to handle exceptions in Python. Learn to work with dates and times in Python. In this Python training course by Webucator, Inc, students learn to program in Python. Python Basics Running Python Hello, World! Literals Python Comments Data Types Variables Writing a Python Module print() Function Named Arguments Collecting User Input Getting Help Functions and Modules Defining Functions Variable Scope Global Variables Function Parameters Returning Values Importing Modules Math Arithmetic Operators Modulus and Floor Division Assignment Operators Built-in Math Functions The math Module The random Module Seeding Python Strings Quotation Marks and Special Characters String Indexing Slicing Strings Concatenation and Repetition Common String Methods String Formatting Built-in String Functions Iterables: Sequences, Dictionaries, and Sets Definitions Sequences Unpacking Sequences Dictionaries The len() Function Sets *args and **kwargs Flow Control Conditional Statements The is and is not Operators Python's Ternary Operator Loops in Python The enumerate() Function Generators List Comprehensions File Processing Opening Files The os and os.path Modules Exception Handling Wildcard except Clauses Getting Information on Exceptions The else Clause The finally Clause Using Exceptions for Flow Control Exception Hierarchy Dates and Times Understanding Time The time Module The datetime Module Running Python Scripts from the Command Line The sys Module sys.argv

Duration 2 Days 12 CPD hours This course is intended for This SQL training course is designed for students new to writing SQL queries. Overview Upon successful completion of this course, students will be able to: - Understand how relational databases work - Use SQL to output reports - Write queries to obtain data from multiple tables. Students will learn SQL to build applications or to generate business reports.The SQL learned in the course is applicable to all major databases. Relational Database Basics Brief History of SQL Relational Databases Popular Databases SQL Statements Simple SELECTs Introduction to the Northwind Database Some Basics SELECTing All Columns in All Rows Exploring the Tables SELECTing Specific Columns Sorting Records The WHERE Clause and Operator Symbols Using the WHERE clause to check for equality or inequality Using the WHERE clause to check for greater or less than Checking for NULL Using WHERE and ORDER BY Together The WHERE Clause and Operator Words More SELECTs with WHERE Checking Multiple Conditions Writing SELECTs with Multiple Conditions Advanced SELECTs Calculated Fields Calculating Fields Aggregate Functions and Grouping Working with Aggregate Functions Built-in Data Manipulation Functions Data Manipulation Functions Subqueries, Joins and Unions Subqueries Joins Using Joins Outer Joins Unions Working with Unions If time allows, one or more of the following may be covered: Conditional Processing with CASE INSERT, UPDATE, DELETE Student Challenges - Design your own reports

Everywhere, from tiny businesses to major corporations, needs people skilled in SQL. In light of this, our online training course has been developed to help you succeed by equipping you with all the necessary skills. The importance of mastering SQL increases if you're looking for your first job in the data industry. You will learn about topics such as SQL fundamentals, data wrangling, SQL analysis, AB testing, distributed computing with Apache Spark, Delta Lake, and more through four increasingly more challenging SQL projects with data science applications. These subjects will equip you with the skills necessary to use SQL creatively for data analysis and exploration, write queries quickly, produce datasets for data analysis, conduct feature engineering, integrate SQL with other data analysis and machine learning toolsets, and work with unstructured data. This Specialisation is designed for a learner with little or no prior coding expertise who wants to become proficient with SQL queries. Experts have meticulously planned out the curriculum for the SQL Skills Training course with years of expertise. As a result, you will find it simple to learn the course material. Learning outcome After finishing the course, you'll Learn to utilise the tools for view creation Become familiar with updating columns and indexed views Be able to test and debug Be able to search a database using SQL Become more familiar with inline table-valued functions Learn the fundamentals of transactions and multiple statements Why Prefer US? Opportunity to earn a certificate accredited by CPD after completing this course Student ID card with amazing discounts - completely for FREE! (£10 postal charges will be applicable for international delivery) Standards-aligned lesson planning Innovative and engaging content and activities Assessments that measure higher-level thinking and skills Complete the program in your own time, at your own pace Each of our students gets full 24/7 tutor support *** Course Curriculum *** SQL Programming Course Module 01: Course Introduction Introduction Course Curriculum Overview Overview of Databases Module 02: SQL Environment Setup MySQL Installation MySQL Workbench Installation Connecting to MySQL using Console Module 03: SQL Statement Basics Overview of Challenges SQL Statement Basic SELECT Statement SELECT DISTINCT Column AS Statement COUNT built-in Method usage SELECT WHERE Clause - Part One SELECT WHERE Clause - Part Two Statement Basic Limit Clause Statement Using BETWEEN with Same Column Data How to Apply IN Operator Wildcard Characters with LIKE and ILIKE Module 04: GROUP BY Statements Overview of GROUP BY Aggregation function SUM() Aggregation MIN() and MAX() GROUP BY - One GROUP BY - Two HAVING Clause Module 05: JOINS Overview of JOINS Introduction to JOINS AS Statement table INNER Joins FULL Outer Join LEFT Outer JOIN RIGHT JOIN Union Module 06: Advanced SQL Commands / Statements Timestamps EXTRACT from timestamp Mathematical Functions String Functions SUBQUERY Module 07: Creating Database and Tables Basic of Database and Tables Data Types Primary key and Foreign key Create Table in SQL Script Insert Update Delete Alter Table Drop-Table NOT NULL Constraint UNIQUE Constraint Module 08: Databases and Tables Creating a Database backup 10a Overview of Databases and Tables 10c Restoring a Database CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The course can be helpful for anyone working in the SQL fields, whether self-employed or employed, regardless of their career level. Requirements You will not need any prior background or expertise to enrol in this course. Career path The vocation of SQL Skills Training moves very quickly but pays well. This position provides unparalleled satisfaction. This is your opportunity to learn more and start changing things. Query Language Developer Server Database Manager Python Developer Technical Consultant Project Implementation Manager Software Developer (SQL) Certificates Certificate of completion Digital certificate - £10

There is a lot to learn in Power BI, this course takes a comprehensive look at the fundamentals of analysing data and includes a balanced look at the four main components that make up Power BI Desktop: Report view, Data view, Model view, and the Power Query Editor. It also demonstrates how to utilise the online Power BI service. It looks at authoring tools that enable you to connect to and transform data from a variety of sources, allowing you to produce detailed reports through a range of visualisations, in an interactive and dynamic way. It also includes a detailed look at formulas by writing both M functions in Power Query, and DAX functions in Desktop view. This knowledge will allow you to take your reports to the next level. The aim of this course is to provide a complete introduction to understanding the Power BI analysis process, by working hands-on with examples that will equip you with the necessary skills to start applying your learning straight away. 1 Getting Started The Power BI ecosystem Opening Power BI Desktop Power BI's four views Introduction to Dashboards 2 Importing Files Importing data sources Importing an Excel file Importing a CSV file Importing a database Connect to an SQL Server Database Import vs. Direct Query Importing from the web Importing a folder of files Managing file connections 3 Shape Data in the Query Editor The process of shaping data Managing data types Keeping and removing rows Add a custom column Appending tables together Hiding queries in reports Fixing error issues Basic maths operations 4 The Data Model Table relationships Relationship properties 5 Merge Queries Table join kinds Merging tables 6 Inserting Dashboard Visuals Things to keep in mind Inserting maps Formatting Maps Inserting charts Formatting Charts Inserting a tree map Inserting a table, matrix, and card Controlling number formats About report themes Highlighting key points Filter reports with slicers Sync slicers across dashboards Custom web visuals 7 Publish and share Reports Publishing to Power BI service Editing online reports Pinning visuals to a dashboard What is Q&A? Sharing dashboards Exporting reports to PowerPoint Exporting reports as PDF files 8 The Power Query Editor Fill data up and down Split column by delimiter Add a conditional column More custom columns Merging columns 9 The M Functions Inserting text functions Insert an IF function Create a query group 10 Pivoting Tables Pivot a table Pivot and append tables Pivot but don't aggregate Unpivot tables Append mismatched headers 11 Data Modelling Expanded Understanding relationships Mark a date table 12 DAX New Columns New columns and measures New column calculations Insert a SWITCH function 13 Introduction to DAX Measures Common measure functions Insert a SUM function Insert a COUNTROWS function Insert a DISTINCTCOUNT function Insert a DIVIDE function DAX rules 14 The CALCULATE Measure The syntax of CALCULATE Insert a CALCULATE function Control field summarisation Things of note 15 The SUMX measure X iterator functions Anatomy of SUMX Insert a SUMX function When to use X functions 16 Time Intelligence Measures Importance of a calendar table Insert a TOTALYTD function Change financial year end date Comparing historical data Insert a DATEADD function 17 Hierarchies and Groups Mine data using hierarchies Compare data in groups

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