7936 Courses

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.

Understand the Mental Toughness model and look at how to improve your mental toughness with the 4c’s. Course overview Duration: 1 day (6.5 hours) Mental toughness is the ability to resist, manage and overcome doubts, worries, concerns and circumstances that prevent you from succeeding, or excelling at a task or towards an objective or a performance outcome that you set out to achieve. Our one day programme can help you to achieve this by using tools and techniques to help you perform under pressure and ensure your wellbeing. Objectives  By the end of the course you will to: Identify the causes of stress and how to prevent them Assess your mental toughness using the MTQ48 measure Use tools and techniques to develop your mental toughness Content Understanding Stress, Pressure and Challenge The causes of stress How stress can manifest itself Threat response The Stress performance curve Stress, challenge and pressure Positive stress Mental Toughness, Stress Management and Resilience Defining stress management, resilience and mental toughness How they differ and how they affect each other Mental Toughness Understanding mental toughness The importance of mental toughness The benefits of developing your mental toughness The 4 Cs of Mental Toughness How we approach Challenge Control our emotions Develop Confidence Create Commitment MTQ48 Profile Understanding your MTQ48 profile Looking at your mental toughness Areas for development Developing Mental Toughness Managing physical energy to deal with stress Developing healthy habits for managing stress Multitasking and the ability to focus Identifying unhelpful thought patterns Positive and pragmatic thinking approaches Managing your approach to change and challenge Ways of developing mental toughness

Overview: Traffic Engineering and Management   Welcome to the cutting-edge solution for mastering the intricacies of Traffic Engineering and Management. Our comprehensive product offers a structured approach to understanding and optimizing traffic flow, ensuring safer and more efficient transportation systems. Let's delve into the modules:   Module 1: Introduction to Traffic Engineering and Management Embark on your journey with a solid foundation. Explore the fundamental principles, theories, and practices of traffic engineering and management. Gain insights into the historical evolution and current challenges in transportation systems.   Module 2: Traffic Control Devices and Signals Unlock the secrets behind effective traffic control. Dive into the world of traffic signals, signs, markings, and other devices crucial for regulating traffic flow and ensuring road safety. Learn how to design and implement these systems efficiently.   Module 3: Traffic Operations and Capacity Analysis Master the art of optimizing traffic operations. Delve into advanced techniques for analyzing traffic flow, capacity, and performance. Discover strategies for alleviating congestion, improving throughput, and enhancing overall system efficiency.   Module 4: Intersection Design and Control Navigate through the complexities of intersection design and control. Explore various intersection types, geometries, and signalization methods. Acquire skills to design safe, efficient, and sustainable intersections tailored to specific traffic demands.   Module 5: Pedestrian and Bicycle Facilities Embrace the inclusive approach to transportation planning. Learn how to integrate pedestrian and bicycle facilities seamlessly into transportation networks. Explore design principles, safety considerations, and best practices for accommodating non-motorized modes of transportation.   Module 6: Parking Management Unleash the potential of efficient parking management. Understand the significance of parking policies, regulations, and design standards. Learn how to optimize parking supply, enhance accessibility, and mitigate the negative impacts of parking on traffic flow and urban environments.   Why Choose Us? Comprehensive Coverage: Our product covers all essential aspects of traffic engineering and management, providing a holistic understanding of the subject. Practical Insights: Gain real-world insights and practical skills from industry experts to tackle complex transportation challenges effectively. Interactive Learning: Engage in interactive learning experiences, including case studies, simulations, and hands-on exercises, to reinforce your understanding and skills. Flexible Learning: Access the course materials anytime, anywhere, and at your own pace, ensuring maximum flexibility to accommodate your schedule and learning preferences.   Elevate your expertise in traffic engineering and management with our unparalleled product. Join us today and pave the way for safer, smoother, and smarter transportation systems. Course Curriculum Module 1_ Introduction to Traffic Engineering and Management Introduction to Traffic Engineering and Management 00:00 Module 2_ Traffic Control Devices and Signals Traffic Control Devices and Signals 00:00 Module 3_ Traffic Operations and Capacity Analysis Traffic Operations and Capacity Analysis 00:00 Module 4_ Intersection Design and Control Intersection Design and Control 00:00 Module 5_ Pedestrian and Bicycle Facilities Pedestrian and Bicycle Facilities 00:00 Module 6_ Parking Management Parking Management 00:00

Our renowned Cleaning Level 7 is the ideal course for anybody who wants to work in the cleaning industry. This is the most popular cleaning course in the UK, with bite-sized modules allowing you to learn all you need to know to succeed in the profession. The course teaches you about cleaning and its processes and covers cleaning offices, carpets, entryways and lobbies, as well as techniques in maintaining hard floors. After this, you will also learn about cleaning restrooms, pest management, cleaning products, staffing and so much more. Finally, you'll be offered tips for establishing and maintaining your own cleaning business. Why choose this course Earn a digital Certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Mock exams Multiple-choice assessment Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £119. Please note that overseas students may be charged an additional £10 for postage. CPD Certificate of Achievement from Janets Upon successful completion of the course, you will be able to obtain your course completion e-certificate. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Endorsement This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website. Method of Assessment To successfully complete the course, students will have to take an automated multiple-choice exam. This exam will be online and you will need to score 60% or above to pass the course. After successfully passing the exam, you will be able to apply for Quality Licence Scheme endorsed certificate of achievement. To verify your enhanced skills in the subject, we recommend that you also complete the assignment questions. These can be completed at any time which is convenient for yourself and will be assessed by our in-house specialised tutors. Full feedback will then be given on your current performance, along with any further advice or support.

This Advanced Diploma in Real Estate aims to provide you with the expert knowledge for real estate services. You will gain the skills needed to be a successful and expert real estate agent, exploring best practices from across the industry. Developed in partnership with industry experts , this course covers an array of topics, such as agent specializations, holding open houses and networking skills. Why choose this course Earn an e-certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Online study materials Mock exams Multiple-choice assessment Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £99. Please note that overseas students may be charged an additional £10 for postage. CPD Certificate of Achievement from Janets Upon successful completion of the course, you will be able to obtain your course completion e-certificate. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Endorsement This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website. Method of Assessment To successfully complete the course, students will have to take an automated multiple-choice exam. This exam will be online and you will need to score 60% or above to pass the course. After successfully passing the exam, you will be able to apply for Quality Licence Scheme endorsed certificate of achievement. To verify your enhanced skills in the subject, we recommend that you also complete the assignment questions. These can be completed at any time which is convenient for yourself and will be assessed by our in-house specialised tutors. Full feedback will then be given on your current performance, along with any further advice or support. Who is this course for? Advanced Diploma in Real Estate is suitable for anyone who want to gain extensive knowledge, potential experience and expert skills in the related field. This is a great opportunity for all student from any academic backgrounds to learn more on this subject.

🚀 Elevate Your Marketing Game with 'Digital Advertising with Microsoft: A Comprehensive Guide' 🚀 Are you ready to revolutionize your digital advertising strategy and unlock the full potential of Microsoft's powerful advertising platforms? Look no further! Introducing our groundbreaking online course: 'Digital Advertising with Microsoft.' 🌐 Why Microsoft? 🌐 Microsoft is more than just a tech giant - it's a game-changer in the digital advertising landscape. With platforms like Microsoft Advertising and LinkedIn, you have access to a vast audience of engaged users ready to connect with your brand. Whether you're a seasoned marketer or a budding entrepreneur, this course is your ticket to mastering the art and science of digital advertising with Microsoft.   🚀 What You'll Gain from this Course 🚀 ✅ Comprehensive Insights: Dive deep into the intricacies of Microsoft Advertising and understand how to leverage its unique features for maximum impact. ✅ Strategic Campaign Planning: Learn the art of crafting targeted, high-converting campaigns that resonate with your audience and drive results. ✅ Optimization Techniques: Discover insider tips and tricks to optimize your ad performance, ensuring you get the most bang for your advertising buck. ✅ Mastering LinkedIn Advertising: Unleash the power of LinkedIn advertising with strategies tailored to the platform's professional audience. ✅ Data-Driven Decision-Making: Harness the potential of data analytics to make informed decisions, continuously refining your campaigns for success. ✅ Exclusive Industry Insights: Stay ahead of the curve with the latest trends, updates, and best practices in the ever-evolving world of digital advertising.   🔥 Bonuses to Supercharge Your Learning Experience 🔥 🎁 Interactive Quizzes and Assignments: Reinforce your knowledge with hands-on activities that solidify your understanding. 📈 Real-world Case Studies: Gain inspiration from successful campaigns and apply those insights to your unique business challenges. 🤝 Community Support: Connect with like-minded professionals, share experiences, and get personalized advice from our expert instructors. 🔒 Lifetime Access: Enjoy unlimited access to course materials, updates, and a dedicated community to support your ongoing success.   💡 Ready to Transform Your Digital Advertising Game? 💡   Enroll now in 'Digital Advertising with Microsoft: A Comprehensive Guide' and take the first step towards becoming a digital advertising maestro. Don't miss out on this opportunity to boost your brand's visibility, drive conversions, and elevate your marketing ROI. 🌟 Join the digital advertising revolution with Microsoft - because your success is just a click away! 🌟 Course Curriculum Digital Advertising with Microsoft: A Comprehensive Guide Microsoft Ads dashboard 00:00 Campaign home overview 00:00 How to edit campaign name and change campaign budget 00:00 Ad Campaigns 00:00 Ad Bids & Optimization 00:00 Spy on Your Competitors 00:00 Set Your Budget & Automate Extensions 00:00 Ad Extension Overview & How Tos #1 00:00 How To Add Different Types of Extensions 00:00 Microsoft Ad Editor 00:00 Reports 00:00

Enroll in our Basic Computer Literacy Training course to gain essential skills in operating systems, software, hardware, and troubleshooting. Perfect for beginners, students, professionals, and anyone looking to improve their computer literacy.

Soft skills are the intangible forces that drive successful communication, collaboration, and leadership. They are the undercurrents that can propel a team to excellence or hold it back from achieving its full potential. This course is designed to help participants understand and harness these skills to create a positive impact in their professional roles.

You will learn how to develop the best affiliate marketing strategy in detail.

The course covers Facebook Ads guidance from beginner to expert levels.