• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

2379 Courses delivered Online

VBA with Microsoft Excel

By Nexus Human

Duration 1 Days 6 CPD hours This course is intended for This course is primarily designed for students who want to gain the skills necessary to use VBA to automate tasks in Excel such as collecting data from external sources, cleaning, and manipulating data. The target student may also want to learn how to create custom worksheet functions to streamline worksheet formulas and make complex worksheets easier to support, maintain, and understand. Overview Identify general components of VBA and their appropriate use in solving business solutions. Record VBA macros to automate repetitive tasks. Write VBA code to create VBA subroutines and functions. Use various programming elements to solve problems through code, including variables,objects, conditional statements, and loops. Eliminate, avoid, or handle errors in VBA code, and optimize its performance. VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft Excel and other applications in the Microsoft 365 application suite. You can use VBA to perform tasks that would be difficult or impossible to do using only worksheet functions, and you can automate a wide range of tasks so they can be performed faster, more consistently, and with less effort than performing them manually. This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks. You will learn how to use the macro recorder effectively, as well as how to write your own VBA code from scratch. You will use tools built into Excel to explore and learn VBA's capabilities and to optimize and debug your code. Prerequisites To ensure your success in this course, you should be an experienced Excel user who is comfortable creating and working with Excel workbooks, including tasks such as entering worksheet formulas, using absolute and relative addressing, formatting cells, and creating pivot tables and charts. This level of skill could be acquired by taking the Microsoft Excel for Office 365 (Desktop or Online) courses, Parts 1, 2, and 3. 1. Using VBA to Solve Business Problems Use Macros to Automate Tasks in Excel Identify Components of Macro-Enabled Workbooks Configure the Excel VBA Environment 2. Recording a Macro Use the Macro Recorder to Create a VBA Macro Record a Macro with Relative Addressing Delete Macros and Modules Identify Strategies for Using the Macro Recorder 3. Writing VBA Code Directly Write VBA Code Discover Objects You Can Use Create a Custom Function 4. Solving Problems through Code Make Decisions in Code Work with Variables Perform Repetitive Tasks 5. Improving Your VBA Code Debug VBA Errors Deal with Errors Improve Macro Performance 6. Controlling How and When Macros Run Prompt the User for Information Configure Macros to Run Automatically Additional course details: Nexus Humans VBA with Microsoft Excel (v1.2) 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 VBA with Microsoft Excel (v1.2) 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.

VBA with Microsoft Excel
Delivered OnlineFlexible Dates
£655

JavaScript DOM - Interactive and Dynamic Web Pages

By Packt

JavaScript can interface with the Document Object Model and help make webpage elements come to life! Interact with web users through event listeners to make your web pages respond to users and code. This practical course will help you build modern, interactive, and dynamic web pages. You need to have previous experience with JavaScript and HTML to get started.

JavaScript DOM - Interactive and Dynamic Web Pages
Delivered Online On Demand12 hours 20 minutes
£67.99

Web Development Diploma - CPD Certified

4.9(27)

By Apex Learning

Give a compliment to your career and take it to the next level. This Web Development will provide you with the essential knowledge to shine in your professional career. Whether you want to develop skills for your next job or elevate your skills for your next promotion, this Web Development bundle will help you stay ahead of the pack. Throughout the Web Development programme, it stresses how to improve your competency as a person in your chosen field while also outlining essential career insights in the relevant job sector. Along with this Web Development course, you will get 11 premium courses, an original Hardcopy, 11 PDF Certificates (Main Course + Additional Courses) Student ID card as gifts. This Web Development Bundle Consists of the following Premium courses: Courses are included in this Web Development Bundle? Course 01: Ultimate PHP & MySQL Web Development Course & OOP Coding Course 02: HTML Web Development for Beginners Course 03: Ionic & Angular JS: Principles Of Mobile and Web Development Course 04: WordPress Website Creation and Hosting System with Affiliate Marketing! Course 05 Computer Science With Python Course 06: Python Programming for Everybody Course 07: Complete Web Application Penetration Testing & Security Course 08: Cloud Computing / CompTIA Cloud+ (CV0-002) Course 09: Web Design in Affinity Designer Course 10: Advanced Diploma in User Experience UI/UX Design Course 11: Cyber Security Incident Handling and Incident Response Enrol now in Web Development to advance your career, and use the premium study materials from Apex Learning. The Web Development bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Web Development expertise and essential knowledge, which will assist you in reaching your goal. Course Curriculum : Ultimate PHP & MySQL Web Development Course & OOP Coding Section 01: Introduction & Setup Section 02: Basics Section 03: Control Structures Section 04: Functions Section 05: Forms Section 06: File Handling Section 07: MySQL Section 08: XML Section 09: AJAX Section 10: Emails Section 11: Object Oriented Programming Section 12: Error Handling Section 13: Advanced Section 14 : Resource CPD 120 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Web Development bundle. Requirements This Web Development course has been designed to be fully compatible with tablets and smartphones. Career path Having Web Development expertise will increase the value of your CV and open you up to multiple tech-based job sectors. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included Hard Copy Certificate is Free, only for the title course. You can also purchase hardcopy certificates for other 10 courses, but it will cost you £10 each.

Web Development Diploma - CPD Certified
Delivered Online On Demand
£39

C++, Javascript, HTML, Web Development, Web Design & SQL Training - 30 Courses Bundle!

By NextGen Learning

Get ready for an exceptional online learning experience with the C++, Javascript, HTML, Web Development, Web Design & SQL Trainingbundle! This carefully curated collection of 30 premium courses is designed to cater to a variety of interests and disciplines. Dive into a sea of knowledge and skills, tailoring your learning journey to suit your unique aspirations. The C++, Javascript, HTML, Web Development, Design & SQL Training is a dynamic package, blending the expertise of industry professionals with the flexibility of digital learning. It offers the perfect balance of foundational understanding and advanced insights. Whether you're looking to break into a new field or deepen your existing knowledge, the C++, Javascript, HTML, Web Development, Web Design & SQL Training package has something for everyone. As part of the C++, Javascript, HTML, Web Development, Design & SQL Training package, you will receive complimentary PDF certificates for all courses in this bundle at no extra cost. Equip yourself with the C++, Javascript, HTML, Web Development, Design & SQL Training bundle to confidently navigate your career path or personal development journey. Enrol today and start your career growth! This Bundle Comprises the Following C++, Javascript, HTML, Web Development, Web Design & SQL TrainingCPD Accredited Courses: Course 01: C++ Programming for Absolute Beginners Course 02: Computer Vision By Using C++ and OpenCV with GPU support Course 03: Basic C# Coding Course 04: Refactor Javascript Course 05: Basic Asynchronous JavaScript Course 06: Javascript for Data Structures Course 07: Basic HTML 5 Course 08: HTML Web Development Crash Course Course 09: Microsoft SQL Server Development for Everyone Course 10: Learn to Build Complete CMS Blog in PHP MySQL Bootstrap & PDO Course 11: PHP and MySQL Training 2022: Build 5 Real World Projects Course 12: PHP for Beginners 2023 Guide: Develop a ECommerce Store Course 13: PHP and MySQL Training Masterclass 2023 Course 14: Easy to Advanced Data Structures Course 15: jQuery: JavaScript and AJAX Coding Bible Course 16: AutoCAD Programming using C# with Windows Forms Course 17: C# Console and Windows Forms Development with LINQ & ADO.NET Course 18: Programming AutoCAD with SQL Server Database Using C# Course 19: Web GIS Application Development with C# ASP.NET CORE MVC and Leaflet Course 20: Creative Web Design with HTML5, CSS3 and Bootstrap Course 21: Beginners Course on ESP32 and IoT Course 22: Learn DOM Manipulation with JavaScript Course 23: Ultimate PHP & MySQL Web Development & OOP Coding Course 24: Internet of Things Course 25: Excel Add-in with C# VSTO and Web Course 26: Career Development Plan Fundamentals Course 27: CV Writing and Job Searching Course 28: Networking Skills for Personal Success Course 29: Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! Course 30: Decision Making and Critical Thinking What will make you stand out? Upon completion of this online C++, Javascript, HTML, Web Development, Web Design & SQL Training bundle, you will gain the following: CPD QS Accredited Proficiency with this C++, Javascript, HTML, Web Development, Design & SQL Training bundle After successfully completing the C++, Javascript, HTML, Web Development, Design & SQL Training bundle, you will receive a FREE CPD PDF Certificates as evidence of your newly acquired abilities. Lifetime access to the whole collection of learning materials of this C++, Javascript, HTML, Web Development, Design & SQL Training bundle The online test with immediate results You can study and complete the C++, Javascript, HTML, Web Development, Design & SQL Training bundle at your own pace. Study for the C++, Javascript, HTML, Web Development, Design & SQL Training bundle using any internet-connected device, such as a computer, tablet, or mobile device. Each course in this C++, Javascript, HTML, Web Development, Web Design & SQL Training bundle holds a prestigious CPD accreditation, symbolising exceptional quality. The materials, brimming with knowledge, are regularly updated, ensuring their relevance. This bundle promises not just education but an evolving learning experience. Engage with this extraordinary collection, and prepare to enrich your personal and professional development. Embrace the future of learning with the C++, Javascript, HTML, Web Development, Design & SQL Training, a rich anthology of 30 diverse courses. Each course in the C++, Javascript, HTML, Web Development, Design & SQL Training bundle is handpicked by our experts to ensure a wide spectrum of learning opportunities. ThisC++, Javascript, HTML, Web Development, Design & SQL Training bundle will take you on a unique and enriching educational journey. The bundle encapsulates our mission to provide quality, accessible education for all. Whether you are just starting your career, looking to switch industries, or hoping to enhance your professional skill set, the C++, Javascript, HTML, Web Development, Web Design & SQL Training bundle offers you the flexibility and convenience to learn at your own pace. Make the C++, Javascript, HTML, Web Development, Design & SQL Training package your trusted companion in your lifelong learning journey. CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The C++, Javascript, HTML, Web Development, Web Design & SQL Training bundle is perfect for: Lifelong learners looking to expand their knowledge and skills. Professionals seeking to enhance their career with CPD certification. Individuals wanting to explore new fields and disciplines. Anyone who values flexible, self-paced learning from the comfort of home. Requirements You are cordially invited to enroll in this bundle; please note that there are no formal prerequisites or qualifications required. We've designed this curriculum to be accessible to all, irrespective of prior experience or educational background. Career path Unleash your potential with the C++, Javascript, HTML, Web Development, Web Design & SQL Training bundle. Acquire versatile skills across multiple fields, foster problem-solving abilities, and stay ahead of industry trends. Ideal for those seeking career advancement, a new professional path, or personal growth. Embrace the journey with the C++, Javascript, HTML, Web Developmentbundle package. Certificates CPD Quality Standard Certificate Digital certificate - Included 30 CPD Quality Standard Certificates - Free

C++, Javascript, HTML, Web Development, Web Design & SQL Training - 30 Courses Bundle!
Delivered Online On Demand5 days
£199

The Ultimate Microsoft Excel Bundle - 4 Courses

By OnlineCoursesLearning.com

Introduction: Unlock the power of Microsoft Excel with this comprehensive four-course bundle. Gaining mastery of Macros, you'll move through beginner, intermediate, and advanced levels. Solidify your knowledge and refine your skills with each step, and become an Excel expert. This Microsoft Excel course caters to beginner, intermediate, and advanced levels. It aims to provide students with a comprehensive understanding of Excel, a powerful spreadsheet software that is widely used in business and other industries. For Beginners, the course covers the basics of Excel, including creating and formatting worksheets, entering data, and performing calculations using formulas and functions. Students will also learn how to create charts and graphs to display data visually. For Intermediate learners, the course delves deeper into Excel's functionalities, including sorting and filtering data, conditional formatting, and basic data analysis using PivotTable and PivotChart. They will also learn how to use macros to automate repetitive tasks and increase productivity. For Advanced learners, the course covers advanced Excel features such as complex formulas, array functions, and advanced charting techniques. Students will also learn how to use Excel's VBA (Visual Basic for Applications) programming language to create custom macros and automate complex tasks. Overall, this course is designed to provide students with a solid foundation in using Microsoft Excel at all levels. Whether a beginner, intermediate or advanced user, the course will equip them with the necessary skills to manage and analyze data effectively, increasing their productivity and efficiency.

The Ultimate Microsoft Excel Bundle - 4 Courses
Delivered Online On Demand
£129

The Complete iOS 14 / iOS 13 Developer Course - and SwiftUI

By Packt

If you are searching for the right course to learn about iOS Development from scratch, you've just found it. This course will take you from a complete beginner to a confident practitioner, as we focus on practical iOS development without neglecting the theory.

The Complete iOS 14 / iOS 13 Developer Course - and SwiftUI
Delivered Online On Demand37 hours 17 minutes
£128.99

NLP Core Skills Training Course

By Lead Academy

Quality Guarantee: Promising training excellence, satisfaction gurantee Accredited by CPD UK & Quality License Scheme Tutor Support Unlimited support via email, till you complete the course Recognised Certification: Accepted by thousands of professional bodies Start Anytime With 1 year access to the course materials Online Learning Learn from anywhere, whenever you want With this NLP core skills course, you can reprogram your mind, and change the pattern of your emotional behaviour and thoughts by learning various essential skills to understand and influence human behaviour and communication. This course at a glance Accredited by CPD UK Endorsed by Quality Licence Scheme Know the history and definition of NLP Learn five principles of success using NLP Understand meta programs Know reframing techniques Learn different satir categories Understand the role of sensory acuity in NLP Know the model, strategy and techniques of NLP Understand various submodality techniques Get acquainted with the four pillars of NLP Know the framework for improving your judgment Learn the objective evaluation of NLP Understand the neuro-logical flexibility and rigidity Why NLP Core Skills Training Course right for you? This comprehensive online course is designed for those who want to understand NLP modelling, its benefits, four pillars, and representational systems. You will have a strong understanding of meta programs, reframing techniques, mirroring and matching techniques of NLP. In addition, this extensive course will give you a broad knowledge of anchoring, various stages of learning, and the process to handle criticism with NLP. In addition, this extensive course will help you understand different satir categories and the role of sensory acuity in NLP. By the end of the course, you will gain deep knowledge of NLP, its SMART goals, modelling, various submodality techniques, and meta programs. NLP Core Skills Training Course Details Accredited by CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field.   The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Course Curriculum NLP Core Skills - Introduction NLP Core Skills - Introduction What is NLP What is NLP Benefits of NLP Benefits of NLP Four Pillars of NLP Four Pillars of NLP Model, Strategy & Technique Model, Strategy & Technique NLP Modeling NLP Modeling What are Representational Systems What are Representational Systems Various Submodality Techniques Various Submodality Techniques What are Meta Programs What are Meta Programs Reframing Technique Reframing Technique Mirroring & Matching Techniques Mirroring & Matching Techniques Different Satir Categories Different Satir Categories Role of Sensory Acuity in NLP Role of Sensory Acuity in NLP What is Anchoring What is Anchoring Various Stages of Learning Various Stages of Learning Handling Criticism With NLP Handling Criticism With NLP Who should take this course? This interactive online course is beneficial for those who want to understand Neuro-Linguistic Programming in detail, its advantages, and the presuppositions of NLP. It is suitable for those who want to advance their career in the field of NLP. Entry Requirements There are no academic entry requirements for this NLP core skills training course, and it is open to students of all academic backgrounds. However, you are required to have a laptop/desktop/tablet or smartphone and a good internet connection. Assessment Method This NLP core skills training course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner can grasp from each section. In the assessment pass mark is 60%. Certification Endorsed Certificate from Quality Licence Scheme After successfully passing the MCQ exam you will be eligible to order the Endorsed Certificate by Quality Licence Scheme. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees. There is a Quality Licence Scheme endorsement fee to obtain an endorsed certificate which is £65. Certificate of Achievement from Lead Academy After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35. FAQs Is CPD a recognised qualification in the UK? CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Are QLS courses recognised? Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. When will I receive my certificate? For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. Can I pay by invoice? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. Can I pay via instalment? Yes, you can pay via instalments at checkout. How to take online classes from home? Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. Does age matter in online learning? No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. When I will get the login details for my course? After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org

NLP Core Skills Training Course
Delivered Online On Demand
£25

Quantity Surveying with AutoCAD - CPD Certified

4.7(47)

By Academy for Health and Fitness

***24 Hour Limited Time Flash Sale*** Quantity Surveying with AutoCAD - CPD Certified Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Are you a professional feeling stuck in your career, struggling to keep up with the ever-changing demands of the industry? Or perhaps you're a beginner, unsure of where to start or how to break into your desired field. Whichever stage you're in, our exclusive Quantity Surveying with AutoCAD Bundle provides unique insights and tools that can help you achieve your goals. Designed to cater to the needs of both seasoned professionals and aspiring newcomers, our Quantity Surveying with AutoCAD bundle is a comprehensive program that will equip you with the essential skills and knowledge you need to succeed. Whether you're looking to advance in your current role or embark on a new career journey, this bundle has everything you need to take your professional life to the next level. But that's not all. When you enrol in Quantity Surveying with AutoCAD Online Training, you'll receive 25 CPD-Accredited PDF Certificates, Hard Copy Certificates, and our exclusive student ID card, all absolutely free. Courses Are Included In this Quantity Surveying with AutoCAD Career Bundle: Course 01: Quantity Surveyor Training Course 02: Building Surveyor Training Course 03: Land Surveying Course 04: Construction Site Planning and Management Course 05: Construction Cost Estimation Diploma Course 06: AutoCAD VBA Programming for Beginners Course 07: AutoCAD Programming using C# with Windows Forms Course 08: Property Law Course 09: Construction Industry Scheme (CIS) Course 10: Property Management Training Course 11: Residential Property Sales Course 12: Public Housing Management Course 13: WELL Building Standard Course 14: Building Design And Construction With LEED V4.1 Course 15: Construction Safety Diploma Course 16: Cost Control and Management Training Course 17: Effective Communication Skills for Technical People Course 18: Leadership & Management Course 19: Level 3 Workplace First Aid Course 20: COSHH Training for Assessors Course 21: Level 2 LOLER Training Course 22: Working at Height Course 23: RIDDOR Training Course 24: Workplace Management: Personal Hygiene Course 25: Property Development Diploma With Quantity Surveying with AutoCAD, you'll embark on an immersive learning experience that combines interactive lessons with voice-over audio, ensuring that you can learn from anywhere in the world, at your own pace. And with 24/7 tutor support, you'll never feel alone in your journey, whether you're a seasoned professional or a beginner. Don't let this opportunity pass you by. Enrol in Quantity Surveying with AutoCAD today and take the first step towards achieving your goals and dreams. Why buy this Quantity Surveying with AutoCAD? Free CPD Accredited Certificate upon completion of Quantity Surveying with AutoCAD Get a free student ID card with Quantity Surveying with AutoCAD Lifetime access to the Quantity Surveying with AutoCAD course materials Get instant access to this Quantity Surveying with AutoCAD course Learn Quantity Surveying with AutoCAD from anywhere in the world 24/7 tutor support with the Quantity Surveying with AutoCAD course. Start your learning journey straightaway with our Quantity Surveying with AutoCAD Training! Quantity Surveying with AutoCAD premium bundle consists of 25 precisely chosen courses on a wide range of topics essential for anyone looking to excel in this field. Each segment of Quantity Surveying with AutoCAD is meticulously designed to maximise learning and engagement, blending interactive content and audio-visual modules for a truly immersive experience. Certification You have to complete the assignment given at the end of the Quantity Surveying with AutoCAD course. After passing the Quantity Surveying with AutoCAD exam You will be entitled to claim a PDF & Hardcopy certificate accredited by CPD Quality standards completely free. CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Quantity Surveying with AutoCAD course is ideal for: Students seeking mastery in Quantity Surveying with AutoCAD Professionals seeking to enhance Quantity Surveying with AutoCAD skills Individuals looking for a Quantity Surveying with AutoCAD-related career. Anyone passionate about Quantity Surveying with AutoCAD Requirements This Quantity Surveying with AutoCAD doesn't require prior experience and is suitable for diverse learners. Career path This Quantity Surveying with AutoCAD bundle will allow you to kickstart or take your career in the related sector to the next stage. Certificates CPD Accredited Digital certificate Digital certificate - Included CPD Accredited Hard copy certificate Hard copy certificate - Included If you are an international student, then you have to pay an additional 10 GBP for each certificate as an international delivery charge.

Quantity Surveying with AutoCAD - CPD Certified
Delivered Online On Demand5 days
£149

Oracle 11g PL/SQL Part 2

By iStudy UK

This Oracle 11g PL/SQL Part 2 course will be very advantageous for you to learn about developing database server-side PL/SQL program units within an Oracle database. This course covers a variety of topics which include understanding the basic form and structure of program units stored within the database, building and maintaining stored procedures, functions, packaged programs, and database triggers. In addition to that, you'll take the support of advanced programming techniques such as cursor variables and cursor expressions, which broadly discussed in the course. This course is ideal to prepare yourself for the Oracle certification exams (OCP). Upon successful completion of this course, you'll stand out from your competition while you're chasing your dream job! What Will I Learn? Prepare your environment Introducing Database Program Units Creating and Maintaining Stored Procedures & Functions Creating and Maintaining Packages Advanced Cursor Techniques Using System-Supplied Packages Creating and Maintaining Database Triggers Implementing System Event Triggers Requirements Familiarity with database and programming principles Who is the target audience? Application designers and developers Database administrators Business users and non-technical senior end users Introduction Introduction 00:03:00 Install Oracle XE 00:11:00 SQL Developer Installation 00:00:00 Workstation Setup 00:12:00 Database Program Units Introducing the Database Program Unit 00:19:00 Working with Stored Procedures and Functions Creating Stored Procedures and Functions 00:19:00 Understanding the Parameter Specification 00:23:00 Executing Procedures and Functions 00:26:00 Calling Functions from within SQL 00:13:00 Handling Compilation Errors 00:08:00 Maintaining Stored Procedures and Functions Recompiling and Dropping Programs 00:16:00 Data Dictionary Storage 00:25:00 Managing Dependencies 00:13:00 Tracking Dependencies 00:08:00 Using the Dependency Tracking Utility 00:09:00 Creating and Maintaining Packages What Is a Package? 00:10:00 Creating a Package 00:19:00 Package Definition Information 00:08:00 Advanced Programming Techniques 00:06:00 Using Persistent Global Objects 00:04:00 Including Initialization Logic 00:15:00 Object Oriented Support within Packages 00:14:00 Package Maintenance 00:18:00 Advanced Cursor Techniques Learning to Use Cursor Variables 00:24:00 Advanced Cursor Techniques Weak Cursor Definitions 00:16:00 REFCURSOR Cursor Definition 00:05:00 Using Cursor Expression 00:14:00 Using System Supplied Packages Using the DBMS OUTPUT() Package 00:12:00 Using the UTL FILE() Package 00:30:00 Creating Database Triggers Understanding the Database Trigger 00:23:00 Statement-Level Triggers 00:23:00 Row-Level Triggers 00:12:00 Row Level Trigger Example 1 00:11:00 Row Level Trigger Example 2 00:07:00 Row Level Trigger Example 3 00:08:00 Working with the INSTEAD OF Trigger 00:11:00 Using Triggers within an Application 00:09:00 Trigger Maintenance Using the CALL Statement 00:09:00 Trigger Maintenance Tasks 00:12:00 Work with Multiple Triggers for a Single Table 00:11:00 Handling Mutating Table Issues 00:22:00 Using the Compound Trigger 00:06:00 Working with System Event Triggers What Is a System Event Trigger 00:05:00 Defining Scope 00:04:00 Identifying Available System Events 00:12:00 Conclusion Conclusion 00:02:00 Course Certification

Oracle 11g PL/SQL Part 2
Delivered Online On Demand9 hours 47 minutes
£25

A Complete jQuery Course from Beginners to Advanced

By Packt

This course is designed to demonstrate and help you learn the core concepts of working with jQuery. jQuery can help you develop web projects more quickly. jQuery makes creating dynamic and interactive web content easy! Learn the fundamentals of jQuery and find out why it's so amazing to work with. You can do so many great things with jQuery.

A Complete jQuery Course from Beginners to Advanced
Delivered Online On Demand6 hours 30 minutes
£82.99