33380 Courses in Birmingham delivered Online

Do you long for transforming your thoughts and plan a reality? Are you inspired to create innovative products but you don't know where and how to start? Or would you just like to get into outsourcing to become more efficient? If yes, then the Diploma in Outsourcing is perfect for you! Description: In this course, you will develop an understanding of the common characteristics of being an outsourcer. You will gain a good knowledge of the development process and the planning process involved in outsourcing. You will also have a good understanding of the business ecosystem and knowledge of successful business models. Moreover, this is your opportunity to utilise your creativeness with recently gained specialised skills to figure out how to create innovative and useful products. Who is the course for? Professionals who want to learn about outsourcing. Beginners who have an interest in learning how to become effective through outsourcing. 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 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 Outsourcing will be very beneficial and helpful to individuals who are interested in designing and creating products who also want to venture into new business. Diploma in Outsourcing WHY WOULD YOU OUTSOURCE? 00:15:00 DECIDING WHAT TO OUTSOURCE 00:30:00 FINDING CONTENT WRITERS 00:30:00 GRAPHIC DESIGNERS, WEBSITE DESIGNERS, ETC 00:30:00 CODERS AND PROGRAMMERS 01:00:00 VIRTUAL ASSISTANTS AND CUSTOMER SERVICE 00:30:00 OUTSOURCING SEO & PROMOTION 00:15:00 FREELANCE SITES AND HOW THEY WORK 01:00:00 OUTSOURCING ISSUES 00:30:00 Mock Exam Mock Exam-Diploma in Outsourcing 00:20:00 Final Exam Final Exam-Diploma in Outsourcing 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: Composed of a wide range of childcare offices and homes, this course will help you give a solid and safe condition for youthful youngsters. This course covers indoor and outside security concerns, safe nourishment taking care of, universal precautions and different parts of sickness counteractive action, and perceiving and revealing kid mishandle. Incorporates particular systems to fortify families so as to diminish the danger of manhandling and disregard. See the course themes recorded beneath for more data on what is secured. After finishing the Diploma in Child Safety, you will have the capacity to clarify why ecological poisons are destructive to people, and particularly youngsters; recognize approaches to limit kids' introduction to poisons and forestall harming mishaps; clarify safe nourishment taking care of strategies; depict a solid and safe diaper evolving technique; portray the suitable reactions when a transferable sickness is suspected or analyzed and the rules for managing transmittable maladies at your office; and clarify the significance of and process for using Standard Precautions to avert presentation to bloodborne pathogens. Who is the course for? Health Professionals and Workers who are into child health and safety Anyone who wants to know how to take care of children and their safety 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 Diploma in Child Safety will be useful and would be beneficial for every kind of occupations and careers like: Child Care Specialists Nanny Paediatrician Infant Massage Therapist Labour and Delivery Nurse Paediatric Nurse Pediatric Physical Therapist Lactation Consultant Midwife And Many More. Diploma in Child Safety Public Safety Basics 00:30:00 Stranger Danger! 01:00:00 School Bus Safety 01:00:00 Playground Safety 00:15:00 Public Hygiene Safety 00:30:00 Internet Safety 00:30:00 Latest Tech Gadgets For Child Safety 01:00:00 The Issues With Not Teaching Your Child Public Safety Rules 00:15:00 Wrapping Up 00:15:00 Mock Exam Mock Exam- Diploma in Child Safety 00:20:00 Final Exam Final Exam- Diploma in Child Safety 00:20:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

Do you want to learn how to write effectively a business plan for your organisation? Do you want to learn how to write an effective and efficient business plan? If yes, then join now and learn the basic principles of effective business plan writing. Description: Drafting a business proposal is fundamental to your success as a business person. This course will help you to acquire the skills to deliver that plan. In this course, you will have built up a business proposal prepared to actualize your thought. This course will provide you with all fundamentals to writing a business plan. It will help you express your one of a kind selling position, examine check potential, create client profiles, set up a financial plan, and also decide your underlying publicising and promotion systems. So enrol now! Who is the course for? Business owners and entrepreneurs who are ready to create a business plan. 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 the cost of £39 or in PDF format at the 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 Business Proposal Writing will be very beneficial and helpful, especially to the following careers: Businessmen. Marketing and Promotions Specialists. Top Executives. Business writer. Grant writer. Project manager. And Much More! Module One - Getting Started 01:00:00 Module Two - Understanding Proposals 01:00:00 Module Three - Beginning the Proposal Writing Process 00:30:00 Module Four - Preparing An Outline 01:00:00 Module Five - Finding Facts 01:00:00 Module Six - Writing Skills (I) 01:00:00 Module Seven - Writing Skills (II) 00:30:00 Module Eight - Writing the Proposal 01:00:00 Module Nine - Checking for Readability 01:00:00 Module Ten - Proofreading and Editing 00:30:00 Module Eleven - Adding the Final Touches 01:00:00 Module Twelve - Wrapping Up 01:00:00 Activities Diploma in Business Proposal Writing- Activities 00:00:00 Mock Exam Mock Exam- Diploma in Business Proposal Writing 00:20:00 Final Exam Final Exam- Diploma in Business Proposal Writing 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Special Discount Offer Are you looking to enhance your Administrative Skills? If yes, then you have come to the right place. Our comprehensive courses on Administrative Skills Training will assist you in producing the best possible outcome by learning the Administrative Skills. Get 6 CPD Accredited Courses with 6 Free PDF Certificates worth £24! Course 01: Administrative Management Course 02: Document Control Course 03: Email Etiquette Course 04: Business Writing Course 05: Contract Management Course 06: Meeting Management Online The Administrative Skills Training bundle is for those who want to be successful. In the Administrative Skills Training bundle, you will learn the essential knowledge needed to become well versed in Administrative Skills Training. Our Administrative Skills Training bundle starts with the basics of Administrative Skills Training and gradually progresses towards advanced topics. Therefore, each lesson of this Administrative Skills Training is intuitive and easy to understand. Why would you choose the Administrative Skills Training course from Compliance Central: Lifetime access to Administrative Skills Training courses materials Full tutor support is available from Monday to Friday with the Administrative Skills Training course Learn Administrative Skills at your own pace from the comfort of your home Gain a complete understanding of Administrative Skills Training course Accessible, informative Administrative Skills Training learning modules designed by expert instructors Get 24/7 help or advice from our email and live chat teams with the Administrative Skills Training bundle Study Administrative Skills Training in your own time through your computer, tablet or mobile device. A 100% learning satisfaction guarantee with your Administrative Skills Training Course Improve your chance of gaining in demand skills and better earning potential by completing the Administrative Skills Training Curriculum Breakdown of the Administrative Skills Training Curriculum Breakdown of Document Control Module 01: Introduction to Office Administration Module 02: Skills of an Effective Administrator Module 03: Business Etiquette Module 04: Business Telephone Skills Module 05: Representing Your Boss and Company Module 06: Mail Services and Shipping Module 07: Travel Arrangements Module 08: Organising Meeting and Conferences Module 09: Time Management Module 10: Record Keeping and Filing Systems Module 11: Business Writing Skills Module 12: Organisational Skills Module 13: Communication Skills Module 14: Customer Service Module 15: Effective Planning and Scheduling Module 16: Invoicing/Petty Cash CPD 30 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Administrative Assistant Training bundle helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career in Administrative Assistant Training . It is also great for professionals who are already working in Administrative Assistant Training and want to get promoted at work. Requirements To enrol in this Administrative Assistant Training course, all you need is a basic understanding of the English Language and an internet connection. Career path The Administrative Assistant Training course will enhance your knowledge and improve your confidence in exploring opportunities in various sectors related to Administrative Assistant Training. Certificates 6 CPD Accredited PDF Certificate Digital certificate - Included Get 6 CPD accredited PDF certificate for Free. Certificate of completion Hard copy certificate - £10.79 CPD Accredited Hardcopy Certificate Deliver Charge: Inside the UK: Free Outside the UK: £9.99 each

Are you planning to start a small service based business? Perhaps you're as of now in a business and you need to know how to better present, showcase and promote your business. Yes? Then this is the course for you. Description: Our Diploma in Service Business Synergy introduces the topic of managing business services, how to make business benefits more compelling and proficient, how organisations can accomplish greatness in client connections by planning and creating powerful and productive services for their clients. The course starts by acquainting you with the point of service management and the components of administration, for example, how best to serve clients in the present day business condition, what the product service system are, what the services act contains, and how to guarantee consistent services to clients both inside and outside an association. You will then figure out how businesses can utilise promoting components to shape. Who is the course for? Individuals who own a small service based business or are planning to start a new business Business owners looking for new marketing and advertising strategies that actually work 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 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: Diploma in Service Business Synergy is a useful qualification to possess, and would be beneficial for the following careers: Freelancing businesses. Diploma in Service Business Synergy Service Business Basics 00:30:00 Use Market Research To Choose The Best Service Based Company 00:30:00 Beef Up Your Marketing Skills 00:30:00 Put Together Up Your Website 01:00:00 Brainstorming Unique Advertising Ideas 00:30:00 Stay On Top Of Customer Service 00:30:00 Types Of Service Based Companies 00:30:00 Wrapping Up 00:15:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: Learning both time and priority management at the same time is very practical since they are both related. This is an example of exercising time and priority management. In this course, not only you would not waste time, but it will maximize your efforts to know about how to manage your time and priorities wisely. This would help you figure out how to do priority management for yourself and your company or organization as well. Since this course could provide you with all of these, then you don't have to think about it and register now to start. This course will provide you with the skills, knowledge and information of effective time and priority management.  Who is the course for? Anyone is interested in learning about time and priority management. People who have an interest in knowing how managing time and priority works. 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 the cost of £39 or in PDF format at the 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 Advanced Diploma in Time and Priority Management is a useful qualification to possess, and would be beneficial for the following careers: Businessmen Entrepreneur Executive Director Management Consultant Top Executive. Managing Time Module One - Getting Started 00:30:00 Module Two - Setting SMART Goals 01:00:00 Module Three - Prioritizing Your Time 01:00:00 Module Four - Planning Wisely 01:00:00 Module Five - Tackling Procrastination 01:00:00 Module Six - Crisis Management 01:00:00 Module Seven - Organizing Your Workspace 01:00:00 Module Eight - Delegating Made Easy 01:00:00 Module Nine - Setting a Ritual 01:00:00 Module Ten - Meeting Management 01:00:00 Module Eleven - Alternatives to Meetings 00:30:00 Module Twelve - Wrapping Up 01:00:00 Level 3 Diploma in Time Management- Activities 00:00:00 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 Managing Time & Priority Where Do You Spend Your Time 01:00:00 Managing Tasks 01:00:00 Planning 01:00:00 Goals 01:00:00 Tips From The Gurus 01:00:00 Wrapping Up 00:15:00 Mock Exam Mock Exam - Advanced Diploma in Time Priority Management 00:20:00 Final Exam Final Exam - Advanced Diploma in Time Priority Management 00:20:00

The Sales and Digital Marketing Diploma course is designed to help you to grow your business through proper sales and digital marketing. The course is split into two sections: Sales and Digital Marketing. In sales part, you will be introduced to the recent practical techniques for increasing your sales. You will learn the secrets of sales, sales management, sales strategies, and more. On the other hand, you will learn the advanced digital marketing strategies such as SEO ( Search Engine Optimization) techniques, social media marketing like Facebook, Twitter, Instagram, Pinterest marketing, Google Adwords, viral marketing, network marketing and others. Upon completion, you will gain enough knowledge to use the sales and digital marketing strategies in your business. Who is the course for? Professionals of the sales industry who wants to learn and become an expert in sales management and be able to maintain or increase the sales of the business. People who have an interest in learning about sales 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 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 Sales and Digital Marketing Diploma is a useful qualification to possess, and would be beneficial for the following careers: Businessmen Business Development Specialist Entrepreneur Marketing and Promotions Officer Sales Executive Sales Manager Strategist.

Are you someone who loves children and would like to know about child development? If yes, then this diploma course will be perfect for you and your needs! Description: This diploma course will teach you various important aspects of child development which would no doubt equip you with the necessary skills and information to deal with child development issues. In a perfect world setting, all parents and guardians ought to have a thought of what's in store at different advancement or development of their children. Equipped with the learning to be imparted in this course, you will surely be better arranged to guarantee the development the kids will encounter with the minimum conceivable issues as could be allowed. Information on the exercises and accomplishments will, for the most part, be great reported for the participants to make simple reference should they require information. Through the information picked up on child improvement, you will have the capacity to help the child when things are not going as it ought to be. It will enable you to pull back in the event that they are expecting excessively from the child at any given stage. More of this kind of issues will be taught in this diploma course. Who is the course for? Teachers or professionals who are working with children. Anyone who loves to become a teacher and likes children in general. Entry Requirement: This course is available to all learners, of all academic backgrounds. However, an educational background and experience in child care is an advantage. Learners should be ages 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. Certificate of Achievement After completing this course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates & Transcripts can be obtained either in Hardcopy at £14.99 or in PDF format at £11.99. 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 Child Development will be useful and would be beneficial for children-related kind of occupations and careers like: Child Care Specialists Child and Family Social Worker Early Educators Paediatric Nurse Pediatric Physical Therapist And Many More. Updated Version-Diploma in Child Development Module 1: Understanding Child Development 00:25:00 Module 2: Care for Children 00:26:00 Module 3: Healthy Food, Healthy living 00:25:00 Module 04: Keeping Children Healthy and Safe 00:34:00 Module 5: Child Protection 00:24:00 Module 6: Play, Imagination and Creativity 00:26:00 Factors that Influence Development! 00:38:00 Cognitive Development 00:27:00 Social and Emotional Development 00:15:00 Personality and Intellectual Development in Children 00:36:00 Language Development in Children 00:32:00 Problems in Childhood & Adolescence 00:41:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00 Old Version-Diploma in Child Development Development Basics 00:30:00 Expected Milestones For Your Child's Age 01:00:00 Gross Motor Skills 01:00:00 Fine Motor Skills 00:30:00 Cognitive Skills 00:30:00 Speech 00:30:00 Social Skills 01:00:00 Developmental Delays 00:30:00 Wrapping Up 00:15:00 Reference Book ELEMENTS OF CHILD DEVELOPMENT 00:00:00 Mock Exam Mock Exam- Diploma in Child Development 00:20:00 Final Exam Final Exam- Diploma in Child Development 00:20:00

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 Additional course details: Nexus Humans Oracle 12c PL/SQL Fundamentals training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Oracle 12c PL/SQL Fundamentals course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 5 Days 30 CPD hours This course is intended for This course is for all Oracle Professionals. Specifically Database Administrators, Web Server Administrators, System Administrators, CIOs and other IT Management Professionals. Overview Upon successful completion of this course, students will be able to perform many of the day-to-day administration tasks required of an Oracle database administrator. This course introduces many of the powerful capabilities of the Oracle database. In this course, students will learn about day-to-day administration tasks. It will also address administration sub-specialties. Introduction: Managing the Database Instance The Database Management Tools EM Database Express EM Cloud Control SQL Developer Database Administrator Introduction: Database Architecture Review Database Instance Configurations Memory Structures Process Structures Storage Architecture Introduction: Starting & Stopping Databse Services Start & Stop the Database Listener ABOUT DATABASE STARTUP/SHUTDOWN SYSOPER SYSDBA DATABASE STATE & STAGES STARTUP WITH EM CLOUD CONTROL STARTUP WITH SQL*PLUS SHUTDOWN WITH EM CLOUD CONTROL SHUTDOWN WITH SQL*PLUS USING MS WINDOWS SERVICES Introduction: Oracle Network Environment Oracle Net Services Architecture ORACLE NET CONFIGURATION ASSISTANT ORACLE NET MANAGER USING EM CLOUD CONTROL ADVANCED NETWORK COMPRESSION TROUBLESHOOTING NETWORK PROBLEMS Introduction: Diagnostics & Oracle Support About Database Diagnostics Fault Diagnosability Infrastructure DATABASE INSTANCE HEALTH SNAPSHOT THE SUPPORT WORKBENCH PROACTIVE DATABASE HEALTH CHECKS PACKAGE DIAGNOSTIC DATA WORKING WITH THE KNOWLEDGE BASE Storage: Tablespace Management Starter Tablespaces CREATE TABLESPACE WITH EM CC CREATE TABLESPACE WITH SQL MANAGE TABLESPACES WITH EM CC MANAGE TABLESPACES WITH EM DE MANAGE TABLESPACES WITH SQL DROP TABLESPACE ALTER TABLESPACE Storage: Advanced Tablespace Management Managing Temporary Tablespaces TEMP TABLESPACE GROUPS WITH EM TEMP TABLESPACE GROUPS WITH SQL DEFAULT PERMANENT TABLESPACES BIGFILE TABLESPACES MANAGING THE SYSAUX TABLESPACE Storage: Data Files & Temp Files Management Manage Data Files with EM ACCESS METADATA WITH SQL MANAGE DATA FILES WITH SQL MANAGE TEMP FILES ORACLE-MANAGED FILES (OMF) Storage: UNDO Data & UNDO Tablespaces About UNDO Space Management GUARANTEE UNDO RETENTION MONITOR UNDO SPACE WITH SQL USE THE EM UNDO ADVISOR Security & Schemas: Security Overview & Database Privileges Database Security Principles DATABASE SYSTEM PRIVILEGES DATABASE OBJECT PRIVILEGES SUPER ADMINISTRATOR ROLES PRIVILEGE ANALYSIS Security & Schemas: User Security Create & Manage User Accounts MANAGE USERS WITH EM MANAGE USERS WITH SQL CREATE USER ALTER USER DROP USER GRANT & REVOKE PRIVILEGES RESOURCE LIMITS VIA PROFILES ALTER PROFILE DROP PROFILE PASSWORD MANAGEMENT VIA PROFILES ROLE-BASED SECURITY MANAGEMENT ALTER USER...DEFAULT ROLE SET ROLE DELEGATING PRIVILEGE AUTHORIZATION WITH ADMIN OPTION & System Privileges WITH GRANT OPTION & Object Privileges PRINCIPLE OF LEAST PRIVILEGE CHECKLIST Security & Schemas: Database Auditing Auditing Database Activity Traditional Auditing Unified Auditing Create Audit Policy Security & Schemas: SQL Loader Loader Concepts Loader From the Command Line control File Options Load Methods Loader Express Mode Loader From EM Security & Schemas: Export & Import Manage Directory Objects The Data Pump Architecture Data Pump Export Data Pump Import Data Pump Dictionary Views Using the EM CC Interface Performance & Availability: Managing Performance & SQL Tuning Management Advisory Framework Performance Monitoring & AWR The SQL Tuning Advisor Monitoring Exceptions with Metrics Performance & Availability: Data Concurrency About System & User Locks Monitor & Manage User Locks Moitor Locks with Data Dictionary Manage Locks with EM Performance & Availability: Backup & Recovery Concepts Backup & Recovery Structures Managing REDO Data Configuring for Recoverability Instance Recovery Recoverability Checklist Additional course details: Nexus Humans Oracle 12c Administration II training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Oracle 12c Administration II course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.