6443 Courses

Duration 3 Days 18 CPD hours This course is intended for This course is geared for anyone needing to interface with an Oracle database such as end users, business analysts, application developers and database administrators / DBAs. Overview Working within in a hands-on learning environment, guided by our expert team, attendees will develop a practical approach to Oracle Database Technology. Throughout the course participants will explore: Using PL/SQL programming language for database applications and development incorporating PL/SQL modules within the application architecture from the initial design and planning phase The essentials of building executable PL/SQL program units Each of the major segments of a working program and how these interact with each other during program execution Important error or exception handling capabilities of the language. How database-resident program units can be used as part of the overall database application architecture Applying these new skills to the development of PL/SQL packages. Advanced database programming capabilities and benefits How database triggers can be used as part of an advanced database application design Oracle 19c PL/SQL Fundamentals is a three-day, hands-on course that introduces Oracle database programming using the PL/SQL programming language. Throughout the course students will explore the core syntax, structure and features of the language. This course will also lay the foundation for the entire Oracle PL/SQL programming series, allowing one to progress from introductory topics to advanced application design and programming and finally onto writing complex high-performance applications. The course also explores applying the newly learned skills to the development of database applications. Participants will learn how to use database-resident stored program units such as procedures, functions, packages and database triggers. Students will also learn about the latest features in Oracle 19c. 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 and Substitution Variables Using SQL Developer Using SQL *Plus Choosing a Database Programming Language What is Database Programming PL/SQL Programming PL/SQL Performance Advantages Integration with Other Languages PL/SQL Language Essentials PL/SQL Program Structure Language Syntax Rules Embedding SQL Writing Readable Code Generating Readable Code Generating Database Output SQL * Plus Input of 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 & Braching 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 Extend Cursor Techniques For Update of Clause Where Current of Clause Using for ? Loop Cursors Introduction Database Resident Programming Units About Database ? Resident Programs Physical Storage & Execution Types of Stored Program Units Stored Program Unit Advantages Modular Design Principles Creating Stored Procedures and 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 and 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 Programming Units Recompiling Programs Mass Recompilation Using UTL_RECOMP() Dropping Procedures & Functions Drop 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 About Packages Creating Packages Maintaining Packages Performance Considerations Advanced Package Capabilities Definer & Invoker Rights White Lists & Accessible By Persistent Global Objects Defining Initilization Logic Object Orientation Support Advanced Cursor Techniques Using Cursor Variables Using SYS_REFCURSOR Using Cursor Expressions Using System Supplied Packages DBMS_OUTPUT() UTL_FILE() FOPEN() Example Database Trigger Concepts About Database Triggers DML Event Trigger Sub-Types Database Trigger Scenario Trigger Exhaustion Mechanisms Trigger 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 and 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 Defining the Scope Available System Events System Event Attributes

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

🌟 Unleash the Power of Your Imagination with the Narrative Mastery Certification Course! 🌟 Are you ready to embark on a transformative journey that will elevate your storytelling skills to new heights? Introducing the Narrative Mastery Certification Course - your gateway to becoming a master storyteller!   🚀 Why Choose Narrative Mastery Certification? ✨ Craft Compelling Narratives: Learn the art and science behind creating narratives that captivate, inspire, and resonate with your audience. From gripping beginnings to unforgettable endings, discover the secrets to crafting stories that leave a lasting impact. ✨ Unlock Your Creative Potential: Unleash the power of your imagination! Our course provides a dynamic blend of theory and hands-on exercises designed to fuel your creativity and push the boundaries of your storytelling capabilities. ✨ Versatility Across Mediums: Whether you're a writer, filmmaker, content creator, or business professional, our comprehensive curriculum is tailored to suit various mediums. Adapt your storytelling skills to excel in any platform or industry. ✨ Guidance from Industry Experts: Benefit from the wisdom of seasoned storytellers who have excelled in their respective fields. Gain insights, tips, and tricks that will set you apart and accelerate your journey towards narrative excellence. ✨ Interactive Learning Experience: Engage in interactive sessions, peer reviews, and real-world projects that bring the learning to life. Our community-driven approach ensures you not only learn from the best but also grow alongside a network of like-minded individuals. ✨ Earn Your Narrative Mastery Certification: Upon completion of the course, you'll receive a prestigious certification that validates your expertise in narrative storytelling. Showcase your skills proudly and open doors to new opportunities in your chosen field.   🔥 Don't Miss Out - Join the Narrative Mastery Revolution Today! Invest in your future, invest in your narrative mastery! 🚀📖✨ Course Curriculum Introduction to Storytelling Programme Overview - Storytelling 00:00 Introduction to Story and Storytelling 00:00 Foundations of Practical Storytelling Storytelling Styles 00:00 The Five Natural Storytelling Style 00:00 Understanding Audience 00:00 Deciding Which Story to Tell the Audience 00:00 Core of a Story 00:00 Setting Up Perspective 00:00 The Stories of the Audience's Potential Future 00:00 Scripting a Story The Elements and Structure of Stories 00:00 Step-by-Step Process of Weaving a Story 00:00 Techniques to Create a Breath-taking Plot 00:00 Techniques to Create a Vivid Setting 00:00 Using Anecdote 00:00 Using Analogy and Allegory 00:00 Scenic Details and Narrative Summary 00:00 Techniques to Create Characters 00:00 Storytelling - The Show Time Techniques to Start a Story 00:00 Techniques to Engage the Audience in a Story 00:00 Audience Participation 00:00 Techniques to put twists_ suspense_ and surprises in a story 00:00 Techniques to create and release tension 00:00 The World-building 00:00 Creating body details 00:00 Creating sights_ taste_ and smells in storytelling 00:00 Techniques to add humour 00:00 Making Fun of Yourself 00:00 Techniques to finish a story 00:00 Voice modulation during storytelling 00:00 Body language during storytelling 00:00 Using the Stanislavsky System 00:00 Specialized Storytelling Storytelling with data and statistics 00:00 Storytelling for Influencing People 00:00 Storytelling for Entrepreneurship and Business 00:00 Storytelling for Marketing 00:00 Brand Storytelling 00:00 Storytelling for Kids 00:00 Digital Storytelling 00:00 Visual Storytelling 00:00 Video Storytelling 00:00

Learn Flutter - Google's mobile development framework - and build Flutter iOS and Android apps using a single codebase

This ultimate course to kickstart your Python journey from scratch. This comprehensive course covers all the essential concepts of Python, providing explanations, examples, and practical implementations. Designed with beginners in mind, our goal is to help you learn and master Python by building a variety of projects.

Embark on a captivating journey through the realms of Medieval Literature with our immersive course, 'Medieval Literature: Chaucer and More.' Unveiling the rich tapestry of literary masterpieces, this course is a literary odyssey that transcends time. Dive into the enchanting world of Chaucer, Beowulf, Chrétien de Troyes, and other luminaries, as we decode the intricacies of their works. Our carefully curated modules, each a gateway to a different epoch, promise not just knowledge but an exploration of the cultural and historical landscapes that shaped these masterpieces. This course is not merely an academic pursuit; it's an invitation to traverse the corridors of imagination and witness the evolution of storytelling from the medieval era to the present day. Join us on this literary sojourn, where words weave tales that echo across centuries. Learning Outcomes Gain a profound understanding of key Medieval literary works, including Beowulf, The Romance of the Rose, and Dante Alighieri's divine epic. Analyze the cultural and historical contexts that influenced Medieval literature, enhancing your ability to appreciate the nuances of each work. Develop critical thinking skills by exploring the perspectives of diverse writers, from Norse sagas to the contributions of Medieval women writers. Acquire a comprehensive knowledge of the literary techniques employed by Geoffrey Chaucer and other prominent figures of the Medieval period. Hone your analytical writing skills through assignments that delve into the themes, characters, and societal reflections found in these timeless works. Why choose this Medieval Literature: Chaucer and More course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Medieval Literature: Chaucer and More course for? Literature enthusiasts eager to explore the roots of Western literary traditions. History buffs intrigued by the intersection of culture and storytelling in the Medieval era. Students of English literature seeking a comprehensive study of Chaucer and his contemporaries. Educators aiming to incorporate diverse perspectives into their teaching of classic literature. Anyone with a passion for uncovering the mysteries and beauty of Medieval storytelling. Career path Literary Historian: £30,000 - £40,000 per annum Curator of Rare Manuscripts: £25,000 - £35,000 per annum Educational Consultant in Literature: £35,000 - £45,000 per annum Content Editor for Historical Publications: £28,000 - £38,000 per annum Museum Archivist: £26,000 - £36,000 per annum Prerequisites This Medieval Literature: Chaucer and More does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Medieval Literature: Chaucer and More was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Module 01: Introduction to Mediaeval Literature Introduction to Mediaeval Literature 00:13:00 Module 02: Beowulf Beowulf 00:12:00 Module 03: Chrétien de Troyes Chrétien de Troyes 00:10:00 Module 04: Mediaeval Women Writers Mediaeval Women Writers 00:17:00 Module 05: The Romance of the Rose The Romance of the Rose 00:14:00 Module 06: The Tale of Genji The Tale of Genji 00:13:00 Module 07: Norse Sagas Norse Sagas 00:14:00 Module 08: Dante Alighieri Dante Alighieri 00:13:00 Module 09: Pearl and Sir Gawain and the Green Knight Pearl and Sir Gawain and the Green Knight 00:17:00 Module 10: Geoffrey Chaucer Geoffrey Chaucer 00:12:00

Embark on a journey to master the intricacies of Asynchronous JavaScript and open doors to web development techniques that will set you apart in the tech world. The 'Asynchronous JavaScript Basics' course is a treasure trove of knowledge, meticulously designed for those who yearn to wield the power of non-blocking code with finesse. Begin with a gripping scenario that sets the stage, introducing you to the dynamic realms of synchronous and asynchronous operations. With each module, unlock a deeper understanding of how JavaScript engines handle tasks behind the scenes, enabling websites to perform efficiently and responsively. As you delve into the course, witness the magic of asynchronous JavaScript unfold through engaging workshops and demos. The curriculum promises to transform your coding approach, allowing you to implement features such as 'setTimeout' and 'setInterval', manage 'Promises', and gracefully orchestrate asynchronous flows with 'Async/Await'. The carefully structured roadmap and hands-on demonstrations are not just lessons but stepping stones to becoming proficient in creating smoother user experiences and robust web applications. Learning Outcomes Comprehend the distinction between synchronous and asynchronous JavaScript and the scenarios for their use. Utilize 'setTimeout' and 'setInterval' functions to manage time-controlled scripting tasks. Implement 'Promises' to handle future events and asynchronous operations efficiently. Apply 'Async/Await' syntax for writing cleaner and more readable asynchronous code. Understand and use JavaScript Generator Functions to control the execution flow of functions. Why choose this Asynchronous JavaScript Basics course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Asynchronous JavaScript Basics Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Who is this Asynchronous JavaScript Basics course for? Individuals keen on enhancing their JavaScript knowledge for advanced web development. Developers seeking to improve site responsiveness and user experience. Programmers looking to upskill in modern JavaScript practices. Web enthusiasts curious about the execution of non-blocking code. Students or hobbyists interested in the mechanics of JavaScript engines. Career path Front-End Developer: £25,000 - £50,000 Back-End Developer: £30,000 - £60,000 Full Stack Developer: £35,000 - £70,000 Web Application Developer: £28,000 - £55,000 JavaScript Developer: £30,000 - £65,000 UI/UX Developer: £27,000 - £50,000 Prerequisites This Asynchronous JavaScript Basics does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Asynchronous JavaScript Basics was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Basic Asynchronous JavaScript An Async Javascript Scenario 00:02:00 Defining Asynchronous / What is Synchronous code? 00:04:00 WORKSHOP -Exploring Synchronicity in JavaScript 00:09:00 All About Asynchronous Code 00:06:00 Course Roadmap 00:01:00 What is setTimeout? 00:05:00 DEMO - Delaying Code Execution with setTimeout 00:10:00 What is setInterval? 00:02:00 DEMO - Repeating Tasks with setInterval 00:07:00 Chapter Summary 00:01:00 What is Async / Await? 00:03:00 What are Promises? 00:02:00 DEMO - Wrapping setTimeout with a Promise 00:05:00 All About Async 00:02:00 DEMO - Performing Asynchronous Tasks Concisely with Async / Await 00:12:00 What are JavaScript Generator Functions? 00:02:00 Demo - Asynchronous JavaScript via generators 00:08:00 Course Summary 00:02:00 Assignment Assignment - Asynchronous JavaScript Basics 00:00:00

The 'Microcontroller Simulation' course provides a comprehensive introduction to microcontroller simulation using various software tools. Participants will learn how to simulate code examples, board schematics, and practical applications for different components, such as LCD, relay, 7-segment displays, buzzer, temperature fan, and heater, using PIC microcontrollers. Learning Outcomes: Understand the fundamentals of microcontroller simulation and its applications. Gain proficiency in using simulation software to test and debug code examples and board schematics. Learn to interface and simulate various components like LCD, relay, 7-segment displays, buzzer, temperature fan, and heater with PIC microcontrollers. Develop practical skills in programming and simulating microcontroller-based projects. Explore different compiler options for coding microcontrollers in simulations. Acquire the ability to design and test electronic circuits virtually through simulation interfaces. Master the art of LCD interfacing and simulation to display data accurately. Learn how to interface relays with microcontrollers and simulate their operations. Gain hands-on experience in simulating 7-segment displays and controlling them with PIC microcontrollers. Understand the principles of PWM (Pulse Width Modulation) and its application in simulating temperature control with fans and heaters. Why buy this Microcontroller Simulation? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Microcontroller Simulation there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Microcontroller Simulation course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Microcontroller Simulation does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Microcontroller Simulation was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Microcontroller Simulation is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Section 1: Introduction and Getting Started Unit 1: Introduction 00:04:00 Unit 2: Instructor's Introduction 00:03:00 Section 2: Simulation Software + Code Examples and Board Schematics Unit 1: Download and Install Simulation Software 00:05:00 Section 3: Simulation Interface Unit 1: Interface Explained 00:07:00 Unit 2: Interface Menu Explained in Details 00:11:00 Unit 3: Main Window Commands 00:04:00 Section 4: Simulation Boards Unit 1: MCLab1 for PIC16F84, PIC16F628 or PIC16F648 00:10:00 Unit 2: MCLab2 for PIC16F and PIC18F 00:06:00 Unit 3: PIC Genios Board and Arduino Board 00:09:00 Section 5: Coding Examples Using Different Compilers Unit 1: Coding Examples Using Different Compilers 00:12:00 Section 6: Practical Simulation Unit 1: Buttons and LEDs Reading Input and Writing Output 00:07:00 Section 7: LCD Interfacing and Simulation Unit 1: LCD Interfacing and Simulation 00:06:00 Section 8: Relay Interfacing with PIC Microcontroller Unit 1: Relay Interfacing with PIC Microcontroller 00:06:00 Section 9: 7 Segment Interfacing and Simulation Unit 1: 7 Segment Simulation 00:10:00 Section 10: Buzzer Temperature Fan Heater and PWM Simulation Components Unit 1: Buzzer Temperature Fan Heater and PWM Simulation Components 00:08:00 Assignment Assignment - Microcontroller Simulation 00:00:00

CPD Accredited | Career Oriented Learning Modules | 24x7 Tutor Support | Lifetime Access

Take your Spanish language skills to the next level with our Intermediate Level Course. Perfect for learners with some basic knowledge, this course helps you enhance your vocabulary, grammar, and conversational abilities. Ideal for students, professionals, and enthusiasts alike.