10982 Courses delivered Online

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

Description: Priority Management is very important for any business or organisation. There are lots of people who neglect the importance of priority management in the organisation in its management, finance and budgeting etc. Priority Management is essential for smooth running of any business. The absence of prioritising management works can make or break the status of your business. In this course, you will learn how to set your priorities and differentiate the wants and needs. You will then know how to pay for yourself without sacrificing any budget to unnecessary activities. Moreover, this course will be providing you with tips for budgeting and prioritising where to put the budget on. Who is the course for? Professionals who want to improve their priority management skills. People who have an interest in budget and organisation plans through priority management. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: 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. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The Diploma in Priority Management is a useful qualification to possess, and would be beneficial for the following careers: Administrative Services Managers Financial Managers Human Resource Managers Sales Managers Top Executives Training and Development Managers. Diploma in Priority Management Identify Your Priorities 01:00:00 The Difference Between Wants And Needs 01:00:00 Hot to Get Spending Under Control 01:00:00 You Have To Pay Yourself 00:30:00 Tips To Budgeting 01:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: Do you experience sudden slow downs in your computer's performance, notwithstanding when you just have maybe a couple programs running? Have you seen a slack in your web surfing, despite the fact that you have a fast broadband connection? This is most likely because spyware or adware is taxing your framework, backing things off for you while sending data you may not need to be sent to places you probably don't need it sent to. The terrible news is that this stuff is everywhere now, including coming from sites of reputable companies that you have chosen to do business with. The best news is that our PC Safety Diploma helps you to malware-proof your PC. Who is the course for? Undergraduates Job seekers Anyone with an interest in cyber security Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment:  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. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The PC Safety Diploma is a useful qualification to possess, and would be beneficial for the following careers: Computer security specialists Software developers Professional practice working for educational, political or government organizations. Higher information technology-related degree. PC Safety Diploma Why You Need To Worry About 'Malware' 01:00:00 Viruses 01:00:00 Spyware/Adware 01:00:00 Safety & Security at the Browser Level 01:00:00 Glossary of Terms 01:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Effective communication doesn’t just happen—it’s crafted, refined, and strategically delivered. The Communication Manager Course is tailored for those who want to master the subtle art of message control, tone management, and brand voice alignment. Whether you're speaking to stakeholders, staff, or the entire internet, this course helps you command attention for the right reasons. We cover the essential principles of communication strategy, media handling, internal messaging, and audience engagement—without veering into waffle or word soup. Designed with modern digital workplaces in mind, this course explores how communication impacts leadership, morale, and reputation—without needing a PowerPoint and a coffee-stained conference room. You’ll discover how to tailor messages for different audiences, manage crises without melodrama, and ensure that every press release, social post or speech has a purpose. In short, we teach you how to say the right thing, in the right way, at the right time—without needing to apologise later. Also, upon completing our Communication Manager course, you will get a widely respected accreditation and a deeper knowledge of the topic. Key Benefits Accredited by CPD Instant e-certificate Fully online, interactive course Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Curriculum Module 01: Basic Communication Skills Module 02: Advance Communication (I) Module 03: Advance Communication (II) Module 04: Telephone Etiquette Module 05: Body Language and Effective Communication Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing an online module. For each test, the pass mark will be set to 60%. Certificate Once you've successfully completed your course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). Our certifications have no expiry dates, although we do recommend that you renew them every 12 months. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Communication Manager training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our Communication Manager training. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

20-in-1 Exclusive Bundle | CPD Accredited | Gifts: 20 Free PDF Certificates | Lifetime Access

20-in-1 Exclusive Bundle | CPD Accredited | Gifts: 20 Free PDF + Transcript Certificates | Lifetime Access

Explore the fascinating world of feline behavior and psychology with our comprehensive course, 'Feline Behaviour and Psychology: Understanding Cats.' Uncover the secrets behind your cat's actions, learn effective training techniques, and gain insights into promoting their overall well-being. From daily activities to emergencies, this course equips you with the knowledge to forge a stronger bond with your feline companion. Join us on this educational journey and unravel the mysteries of your cat's mind. Enroll now for a purr-fectly enriching experience!

Course Overview: The Office Skills and Administration Level 3 course covers everything from business writing and phone etiquette to body language interpretation and minute-taking methods. You will not only learn to improve your communication and organisational aptitudes, but you will also even be trained to get the most out of Microsoft's Excel and PowerPoint. Maximise your career potential and take your office abilities to a new standard. Key Features of the Course: CPD certificate upon completion 24/7 learning assistance for continuous support Engaging and interactive learning materials A comprehensive curriculum covering various aspects of Office Skills and Administration Level 3 Learn at your own pace, anywhere and anytime Who is This Course For? The Office Skills and Administration Level 3 course is for individuals looking to improve their office skills and administrative capabilities. It's suitable for office professionals, administrators, and those aspiring to enhance their office management expertise, whether you're new to the field or have some experience. What You Will Learn: This Office Skills and Administration Level 3 course covers: Efficient personal assistant skills. Effective admin support techniques. Administrative management strategies. Enhanced organisational skills. Professional telephone etiquette. Business writing proficiency. Time management, effective communication, meeting management, and basic Excel and PowerPoint skills. Why Enrol in This Course: Taking part in the Office Skills and Administration Level 3 course has several advantages. It is a highly popular programme that was recently upgraded to reflect modern office management trends and practices. By staying current with industry standards, you will increase your employability and open the door to great career opportunities in the administrative profession. Requirements: To enrol in the Quality Tools and Problem Solving Methods course, you typically need: Basic office management knowledge. Interest in advanced administrative skills. Computer and internet proficiency. Proficiency in English. Completion of the course provider's requirements. Career Path: Upon completing the Office Skills and Administration Level 3 course, you can pursue diverse and rewarding career opportunities. Here are five related professions, along with their average UK salaries: Office Manager (£30,000-£50,000 per year) Administrative Coordinator (£25,000-£40,000 per year) Executive Assistant (£30,000-£55,000 per year) Data Entry Specialist (£20,000-£30,000 per year) Customer Service Representative (£20,000-£35,000 per year) Certification: After successfully completing the Office Skills and Administration Level 3 course, you will be issued a CPD certificate that is acknowledged across many sectors. This recognised accreditation can help you improve your professional reputation and broaden your employment opportunities.Take part now for proficiency in office skills and administration, and join a global community of learners on this transforming educational adventure. Course Curriculum 12 sections • 54 lectures • 18:19:00 total length •Personal Assistant: 01:23:00 •Admin Support: 01:54:00 •Administrative Management: 00:00:00 •Organisational Skills: 01:16:00 •Telephone Etiquette: 01:07:00 •Business Writing: 01:24:00 •Time Management: 01:09:00 •Body Language and Effective Communication: 01:23:00 •Meeting Management: 01:24:00 •Navigate the Excel User Interface: 00:28:00 •Use Excel Commands: 00:10:00 •Create and Save a Basic Workbook: 00:19:00 •Enter Cell Data: 00:12:00 •Use Excel Help: 00:05:00 •Create Worksheet Formulas: 00:15:00 •Insert Functions: 00:17:00 •Reuse Formulas and Functions: 00:17:00 •Insert, Delete, and Adjust Cells, Columns, and Rows: 00:10:00 •Search for and Replace Data: 00:09:00 •Use Proofing and Research Tools: 00:07:00 •Apply Text Formats: 00:16:00 •Apply Number Format: 00:08:00 •Align Cell Contents: 00:09:00 •Apply Styles and Themes: 00:12:00 •Apply Basic Conditional Formatting: 00:11:00 •Create and Use Templates: 00:08:00 •Preview and Print a Workbook: 00:10:00 •Set Up the Page Layout: 00:09:00 •Configure Headers and Footers: 00:07:00 •Manage Worksheets: 00:05:00 •Manage Workbook and Worksheet Views: 00:07:00 •Manage Workbook Properties: 00:06:00 •Customize the User Interface: 00:19:00 •Set PowerPoint 2016 Options: 00:07:00 •Modify Slide Masters and Slide Layouts: 00:16:00 •Add Headers and Footers: 00:05:00 •Modify the Notes Master and the Handout Master: 00:04:00 •Create SmartArt: 00:09:00 •Modify SmartArt: 00:05:00 •Write Math Equations: 00:07:00 •Add Audio to a Presentation: 00:09:00 •Add Video to a Presentation: 00:10:00 •Customize Animations and Transitions: 00:14:00 •Review a Presentation: 00:15:00 •Store and Share Presentations on the Web: 00:06:00 •Annotate a Presentation: 00:07:00 •Set Up a Slide Show: 00:08:00 •Create a Custom Slide Show: 00:03:00 •Add Hyperlinks and Action Buttons: 00:07:00 •Record a Presentation: 00:05:00 •Secure a Presentation: 00:11:00 •Broadcast a Slide Show: 00:07:00 •Create a Video or a CD: 00:08:00 •Assignment - Office Skills and Administration Level 3: 00:00:00