105 Courses delivered Online

Highlights of the Course Course Type: Online Learning Duration: 4 Hours 26 Minutes Tutor Support: Tutor support is included Customer Support: 24/7 customer support is available Quality Training: The course is designed by an industry expert Recognised Credential: Recognised and Valuable Certification Completion Certificate: Free Course Completion Certificate Included Instalment: 3 Installment Plan on checkout What you will learn from this course? Gain comprehensive knowledge about Italian language Understand the core competencies and principles of Italian language Explore the various areas of Italian language Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert Italian language speaker Italian Language - Verbs Course Master the skills you need to propel your career forward in Italian language. This course will equip you with the essential knowledge and skillset that will make you a confident Italian language speaker and take your career to the next level. This comprehensive Italian language - verbs course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this Italian language - verbs course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This comprehensive course will teach you the theory of effective Italian language practice and equip you with the essential skills, confidence and competence to assist you in the Italian language industry. You'll gain a solid understanding of the core competencies required to drive a successful career in Italian language. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for Italian language speaker or for people who are aspiring to specialise in Italian language. Enrol in this Italian language - verbs course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. Who is this Course for? This comprehensive Italian language - verbs course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this Italian language can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. Entry Requirements This Italian language - verbs course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. Assessment This Italian language - verbs 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 could grasp from each section. In the assessment pass mark is 60%. Advance Your Career This Italian language - verbs course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. 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. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. 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. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Introduction Introduction 00:02:00 Lesson 1 - Infinitives Lesson 1a 00:03:00 Lesson 1b 00:03:00 Lesson 1c 00:03:00 Lesson 1d 00:03:00 Lesson 2 - Impersonal verb "si puo" Lesson 2a 00:02:00 Lesson 2b 00:03:00 The "going" future Tense Lesson 3a 00:03:00 Lesson 3b 00:03:00 Lesson 3c 00:04:00 Lesson 3d 00:03:00 Lesson 3e 00:03:00 Lesson 3f 00:03:00 Lesson 3g 00:03:00 Lesson 3h 00:03:00 Lesson 3i 00:03:00 Lesson 3j 00:03:00 Lesson 3k 00:03:00 Mock Assessment Mock Assessment 00:10:00 Lesson 4 - The Present Perfect Tense(aka the past tense) Lesson 4a 00:03:00 Lesson 4b 00:03:00 Lesson 4c 00:03:00 Lesson 4d 00:03:00 Lesson 4e 00:03:00 Lesson 4f 00:03:00 Lesson 4g 00:03:00 Lesson 4h 00:03:00 Lesson 4i 00:03:00 Lesson 4j 00:03:00 Lesson 4k 00:03:00 Lesson 4l 00:03:00 Lesson 4m 00:03:00 Lesson 4n 00:02:00 Lesson 4o 00:03:00 Lesson 4p 00:03:00 Lesson 4q 00:03:00 Lesson 4r 00:02:00 Lesson 5 - The Present tense Lesson 5a 00:03:00 Lesson 5b 00:03:00 Lesson 5c 00:04:00 Lesson 5d 00:03:00 Lesson 5e 00:03:00 Lesson 5f 00:04:00 Lesson 5g 00:03:00 Lesson 5h 00:03:00 Lesson 5i 00:04:00 Lesson 5j 00:03:00 Lesson 5k 00:03:00 Lesson 5l 00:03:00 Lesson 5m 00:03:00 Lesson 5n 00:03:00 Lesson 5o 00:03:00 Lesson 5p 00:04:00 Lesson 5q 00:03:00 Lesson 5r 00:03:00 Lesson 5s 00:03:00 Lesson 5t 00:03:00 Lesson 5u 00:03:00 Lesson 5v 00:04:00 Lesson 5w 00:03:00 Lesson 5x 00:03:00 Lesson 5y 00:03:00 Lesson 5z 00:03:00 Lesson 5za 00:03:00 Lesson 5zb 00:03:00 Lesson 5zc 00:03:00 Lesson 5zd 00:03:00 Lesson 5ze 00:03:00 Lesson 5zf 00:03:00 Lesson 5zg 00:03:00 Lesson 5zh 00:03:00 Lesson 5zi 00:03:00 Lesson 5zj 00:03:00 Lesson 6 - Recap Lesson 6a 00:03:00 Lesson 6b 00:05:00 Lesson 6c 00:03:00 Lesson 6d 00:03:00 Lesson 6e 00:03:00 Final Assessment Final Assessment 00:10:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Audience This is an intermediate course for system and database administrators, application developers, and other individuals who need a technical introduction to selected new features of Db2 13 for z/OS. Prerequisites You should have practical experience with Db2 for z/OS Duration 2 days.  Course Objectives Learn about the new features and enhancements of Db2 for z/OS (v13), including the technical detail of the functional enhancements of this significant new version of Db2 for z/OS. Course Content Unit 1: Db2 v12 Function Levels: Selected Highlights Unit 2: Migrating to Db2 13 Unit 3: Availability & Scalability Unit 4: Performance Unit 5: Application Management and SQL Changes Unit 6: SQL Data Insights Unit 7: Security Unit 8: IBM Db2 Utilities Unit 9: Instrumentation and Serviceability

Highlights of the Course Course Type: Online Learning Duration: 5 Hours 15 Minutes Tutor Support: Tutor support is included Customer Support: 24/7 customer support is available Quality Training: The course is designed by an industry expert Recognised Credential: Recognised and Valuable Certification Completion Certificate: Free Course Completion Certificate Included Instalment: 3 Installment Plan on checkout What you will learn from this course? Gain comprehensive knowledge about Spanish language Understand the core competencies and principles of Spanish language Explore the various areas of Spanish language Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert Spanish language speaker Spanish Lessons for Beginners Online Course Master the skills you need to propel your career forward in Spanish language. This course will equip you with the essential knowledge and skillset that will make you a confident Spanish language speaker and take your career to the next level. This comprehensive Spanish lessons for beginners course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this Spanish lessons for beginners course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This comprehensive course will teach you the theory of effective Spanish language practice and equip you with the essential skills, confidence and competence to assist you in the Spanish language industry. You'll gain a solid understanding of the core competencies required to drive a successful career in Spanish language. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for Spanish language speakers or for people who are aspiring to specialise in Spanish language. Enrol in this Spanish lessons for beginners course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. Who is this Course for? This comprehensive Spanish lessons for beginners course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this Spanish language can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. Entry Requirements This Spanish lessons for beginners course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. Assessment This Spanish lessons for beginners 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 could grasp from each section. In the assessment pass mark is 60%. Advance Your Career This Spanish lessons for beginners course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. 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. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. 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. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Spanish Language for Beginner Introduction: How To Learn Spanish In 3-Minute Chunks 00:05:00 Lesson 1 Spanish Lesson 1a | Your First Few Words In Spanish Plus, What Is That Line 00:03:00 Spanish Lesson 1b | How To Make Your Sentences Negative 00:03:00 Spanish Lesson 1c | Let's Practice 00:03:00 Spanish Lesson 1d | Reverse Translations 00:03:00 Spanish Lesson 1e | What Else 00:02:00 Lesson 2 Spanish Lesson 2a | A New Word That Looks English 00:03:00 Spanish Lesson 2b | Some More Adjectives 00:03:00 Spanish Lesson 2c | A Useful Phrase With Two Meanings 00:04:00 Spanish Lesson 2d | Let's Practice 00:03:00 Spanish Lesson 2e | Reverse Translations 00:02:00 Spanish Lesson 2f | Recap Translations 00:03:00 Spanish Lesson 2g | Reverse Recap Translations 00:03:00 Lesson 3 Spanish Lesson 3a | Let's Start Being Polite In Spanish 00:03:00 Spanish Lesson 3b | Always A Perfect Adjective 00:03:00 Spanish Lesson 3c | How Do You Say “That” 00:03:00 Spanish Lesson 3d | Let's Practise 00:03:00 Spanish Lesson 3e | Reverse Translations 00:03:00 Spanish Lesson 3f |Recap Translations 00:03:00 Spanish Lesson 3g | Reverse Recap Translations 00:04:00 Lesson 4 Spanish Lesson 4a | Pronouncing The Double L 00:03:00 Spanish Lesson 4b | The Opposite Of Sí And Bueno 00:03:00 Spanish Lesson 4c | Your First Spanish Noun 00:03:00 Spanish Lesson 4d | Another Useful Adverb 00:04:00 Spanish Lesson 4e | Let's Practise 00:03:00 Spanish Lesson 4f | Reverse Translations 00:03:00 Spanish Lesson 4g | Recap Translations 00:02:00 Spanish Lesson 4h | Reverse Recap Translations 00:02:00 Spanish Lesson 4i | Vocabulary Recap 00:02:00 Lesson 5 Spanish Lesson 5a | More Nouns 00:03:00 Spanish Lesson 5b | How To Say “The” In Spanish 00:04:00 Spanish Lesson 5c | What Is A Noun 00:03:00 Spanish Lesson 5d | What's An Adjective 00:03:00 Spanish Lesson 5e | Masculine And Feminine Adjectives 00:03:00 Spanish Lesson 5f | A Terrible Adjective 00:03:00 Spanish Lesson 5g | Vocabulary Expansion Sheet: Food 00:04:00 Spanish Lesson 5h | Let's Practise 00:03:00 Spanish Lesson 5i | Reverse Translations 00:03:00 Spanish Lesson 5j | Recap Translations 00:03:00 Spanish Lesson 5k | Reverse Recap Translations 00:03:00 Spanish Lesson 5l | Vocabulary Recap 00:02:00 Lesson 6 Spanish Lesson 6a | “My” And The Letter H 00:03:00 Spanish Lesson 6b | Everybody Is Nice 00:03:00 Spanish Lesson 6c | Some Practice Sentences 00:03:00 Spanish Lesson 6d | Let's Practise 00:03:00 Spanish Lesson 6e | Reverse Translations 00:02:00 Spanish Lesson 6f | Recap Translations 00:03:00 Spanish Lesson 6g | Reverse Recap Translations 00:03:00 Spanish Lesson 6h | Vocabulary Recap 00:03:00 Lesson 7 Spanish Lesson 7a | “A” In Spanish 00:03:00 Spanish Lesson 7b | A Tea And A Coffee, Please 00:03:00 Spanish Lesson 7c | I Would Like… 00:03:00 Spanish Lesson 7d | A Table For Two 00:03:00 Spanish Lesson 7e | Vocabulary Expansion Sheet: Numbers 00:02:00 Spanish Lesson 7f | Let's Practise 00:03:00 Spanish Lesson 7g | Reverse Translations 00:03:00 Spanish Lesson 7h | Recap Translations 00:03:00 Spanish Lesson 7i | Reverse Recap Translations 00:03:00 Spanish Lesson 7j | Vocabulary Recap 00:03:00 Lesson 8 Spanish Lesson 8a | …And The Food 00:03:00 Spanish Lesson 8b | Two More Words 00:03:00 Spanish Lesson 8c | Plural Nouns 00:03:00 Spanish Lesson 8d | Practising Plurals: Part 1 00:03:00 Spanish Lesson 8e | Practising Plurals: Part 2 00:03:00 Spanish Lesson 8f | Plural Adjectives 00:04:00 Spanish Lesson 8g | Four Forms For Each Adjective 00:03:00 Spanish Lesson 8h | Some More Nouns 00:03:00 Spanish Lesson 8i | Plural “My” 00:03:00 Spanish Lesson 8j | Don't Lose Sleep 00:02:00 Spanish Lesson 8k | Let's Practise 00:03:00 Spanish Lesson 8l | Reverse Translations 00:03:00 Spanish Lesson 8m | Recap Translations 00:03:00 Spanish Lesson 8n | Reverse Recap Translations 00:03:00 Spanish Lesson 8o | Vocabulary Recap 00:05:00 Lesson 9 Spanish Lesson 9a | The Greetings Lesson 00:03:00 Spanish Lesson 9b | Good Evening 00:03:00 Spanish Lesson 9c | See You Soon 00:04:00 Spanish Lesson 9d | Let's Practise 00:02:00 Spanish Lesson 9e | Reverse Translations 00:02:00 Spanish Lesson 9f | Recap Translations 00:03:00 Spanish Lesson 9g | Reverse Recap Translations 00:03:00 Spanish Lesson 9h | Vocabulary Recap 00:05:00 Recap Notes Al Restaurante - Salad 00:01:00 Al Restaurante - Vegetables 00:02:00 Al Restaurante - Fish and Seafood 00:01:00 Al Restaurante - Meat 00:02:00 Al Restaurante - Other Things 00:02:00 Al Restaurante - Condiments 00:02:00 Al Restaurante - Spanish Cuisine 00:01:00 Al Restaurante - Dessert 00:02:00 Al Restaurante - Fruit 00:04:00 Al Restaurante - Drinks 00:03:00 Al Restaurante - Cutlery 00:01:00 Numbers 0-100 00:05:00 Numbers 101-1000 00:02:00 Masculine Or Feminine 00:03:00 Ready For Course 2? The Happy Linguist - Hints And Tips For Learning Spanish 00:01:00 Vocabulary Expansion Sheets - Where Are They 00:01:00 Assessment Assessment - Spanish For Beginners 00:10:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Join us for a masterclass in bi-directional charging for electric vehicles. Otherwise known as Vehicle-to-Grid (V2G) or Vehicle-to-Anything (V2X), and learn about this potentially game-changing technology which brings together the transport and energy systems.

The Oracle 11g PL/SQL Part 1 course will focus on giving you the best knowledge of coding and designing PL/SQL and SQL scripts. Initially, you'll learn how to start programming in Oracle PL/SQL. You'll understand the history of PL/SQL, installing Oracle Express Edition, connecting to Database, Relational Database, Oracle SQL in an easy-to-grasp method. This course includes mostly practical examples with explanations which makes it more valuable. Upon successful completion of this course, you can have the pleasure to code in PL/SQL which further help to boost your career. From beginners to expert learner can benefit from this course. So enrol today and see what else is in the Oracle 11g PL/SQL Part 1 course. What Will I Learn? Prepare your environment Work with Oracle database tools Understand and work with language features Work with the DECLARE clause Work with the BEGIN clause Work with the EXCEPTION clause Use explicit cursors Understand and use nested blocks Understand the difference between nested blocks and subprograms 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 FREE 00:03:00 Preparing Your Environment Course Setup 00:37:00 Working with Oracle Database Tools Selecting the Appropriate Database Tool 00:31:00 Language Features Understanding PL/SQL 00:18:00 PL/SQL Blocks 00:15:00 Working with SQL Plus 00:11:00 The DECLARE Clause DECLARE Clause Objects 00:16:00 PL/SQL Available Data Types 00:17:00 Declaring Simple Data Types and Assignments 00:12:00 Declaring Complex Data Types and Assignments 00:11:00 Declaring Complex RowTypes and Assignments 00:07:00 Declaring Complex Tables 00:08:00 Declaring Complex Records 00:08:00 Creating and Declaring User-Defined Types 00:09:00 The BEGIN Clause What Can Be Included in the BEGIN Clause 00:07:00 Working with CHAR and VARCHAR2 Variables 00:08:00 Handling String Literals 00:08:00 Working with Numeric Variables 00:07:00 Working with Date Variables 00:06:00 Assigning and Using Boolean Variables 00:08:00 Using Comparison Operators 00:07:00 Using SQL Functions 00:06:00 SQL DML within PL/SQL 00:15:00 Using SELECT 00:07:00 Exceptions and Embedded SQL 00:11:00 Using Sequences 00:14:00 Logic Control and Branching 00:07:00 Using GOTO 00:06:00 Working with LOOPS 00:19:00 Creating and Using the Indefinite Loop 00:07:00 Creating and Using the Conditional Loop 00:08:00 Using Nested Loops 00:12:00 Using the If-Then-Else 00:19:00 Using the CASE Statement 00:18:00 The EXCEPTION Clause What Are the Types of Exceptions 00:06:00 Trapping Exceptions 00:06:00 Identify Exception Details 00:11:00 Creating User-Defined Exceptions 00:11:00 Using SQLCODE and SQLERRM Objects 00:09:00 Understand the Implicit Cursor 00:15:00 Creating User-Defined Events 00:12:00 Explicit Cursors Understanding the Concept and Purpose of Explicit Cursors 00:18:00 Learn about Cursor Attributes 00:10:00 Using the Continue Statement 00:06:00 Working with Updateable Cursors 00:19:00 Creating and Using Cursor Parameters 00:15:00 FOR...LOOP Cursors 00:07:00 Nested Blocks Understanding Nested Blocks 00:11:00 Difference between Global vs Local Objects and Exceptions 00:13:00 Declared Subprograms Subprograms: How They Differ from Nested Blocks 00:18:00 Conclusion Conclusion 00:04:00 Course Certification

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

Description Master the use of Google G Suite to boost your productivity and enjoy the benefits of business email, video conferencing, online storage and file sharing with the intensive Google G Suite Essential Training course. Google G Suite, formerly known as Google Apps, is a collection of applications or collaborative productivity apps, especially for email that includes Google Drive, Google Docs, Slides, and Drawings, Google Sheets and Forms, Google Hangouts, Google Calendar, and Google sites. A G suit email looks like any Gmail account. The only difference is G Suit email will be like example@yourdomail.com instead of the Gmail account like example@gmail.com. Google G Suit provides business professional email, shared calendars, online document editing and storage, video meetings, and much more. Throughout the course, you will learn the essential features of Google G suits such as navigating in the G-Suite (Google Apps) environment, storing documents by using Google Drive, communicating using Google Hangouts, and collaborating by using Google Sites. Then the course shows you how to manage your schedules using Google calendar. Finally, the course teaches you how to collaborate and share files with Google Docs, Slides, and Drawings, Google Sheets and Forms. In short, the course covers all the essential features and functions of the Productivity app Google G Suite. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Google G Suite Essential Training is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Google G Suite Essential Training is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Lesson 1: About G Suite TOPIC A Overview 00:05:00 TOPIC B Signing In 00:15:00 Lesson 2: Google Drive TOPIC A Getting Started with Google Drive 00:15:00 TOPIC B Work with Files 00:15:00 TOPIC C Organize and Search Google Drive 00:15:00 Lesson 3: Google Docs (Part 1) TOPIC A Getting Started with Google Docs 00:15:00 TOPIC B Composing and Editing Google Docs (Part 1) 00:15:00 TOPIC C Composing and Editing Google Docs (Part 2) 00:15:00 Lesson 4: Google Docs (Part 2) TOPIC A Working with Images and Tables 00:15:00 TOPIC B Collaborate with Google Docs 00:15:00 TOPIC C Reviewing and Distributing Documents 00:15:00 Lesson 5: Google Sheets TOPIC A Getting Started with Google Sheets 00:15:00 TOPIC B Editing Spreadsheets 00:15:00 TOPIC C Working with Spreadsheet Data 00:15:00 TOPIC D Formatting and Finalizing Spreadsheets 00:15:00 Lesson 6: Google Slides TOPIC A Getting Started with Google Slides 00:15:00 TOPIC B Formatting a Presentation 00:15:00 TOPIC C Editing Google Slides 00:15:00 TOPIC D Presenting and Sharing Google Slides 00:15:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

Description The Oracle Database server composes PL/SQL units and stores it in the database. Mainly, PL/SQL functions to hold to hold SQL declaration within its sentence structure. Do you want to know more about SL/SQL function? How does it bring optimal proficiency in 'procedural language'? if so, take a look at the Oracle 11g PL/SQL Intermediate course. It will assist you in understanding all you need to know about Oracle 11g PL/SQL. The course designs to help the learners to know its function incorporation with different strings, numbers, table row record, and error management. The Oracle 11g PL/SQL Intermediate course teaches the fundamental form and structure of the program unit saved within database, creating and managing stored methods, functions, packaged programs, and database prompts. Its contents aim to take you further in your quest to teach the effective methods including variables and cursor expressions. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Oracle 11g PL/SQL Intermediate is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Oracle 11g PL/SQL Intermediate is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Introduction Introduction FREE 00:03:00 Preparing Your Environment Install Oracle XE 00:11:00 SQL Developer Installation 00:20: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 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description PL/SQL is program units which are composed by the Oracle Database server and stored in the database. The main function of PL/SQL is to hold SQL proclamation within its syntax. If you are interested to know more about SL/SQL function, and how it brings optimal competence in terms of 'procedural language', you may have a look at the Oracle 11g PL/SQL Beginner course. The course is designed in such a way that will assist the learners to know how it works with various strings, numbers, table row record, and error management. It also teaches the learner how to use different key data lexicon to synopsize and maintain the data. The learners will also be able to know about portability, productivity, and manageability of this most widely manipulative language. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Oracle 11g PL/SQL Beginner is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Oracle 11g PL/SQL Beginner is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Introduction Introduction FREE 00:03:00 Preparing Your Environment Course Setup 00:37:00 Working with Oracle Database Tools Selecting the Appropriate Database Tool 00:31:00 Language Features Understanding PL/SQL 00:18:00 PL/SQL Blocks 00:15:00 Working with SQL Plus 00:11:00 The DECLARE Clause DECLARE Clause Objects 00:16:00 PL/SQL Available Data Types 00:17:00 Declaring Simple Data Types and Assignments 00:12:00 Declaring Complex Data Types and Assignments 00:11:00 Declaring Complex RowTypes and Assignments 00:07:00 Declaring Complex Tables 00:08:00 Declaring Complex Records 00:08:00 Creating and Declaring User-Defined Types 00:09:00 The BEGIN Clause What Can Be Included in the BEGIN Clause 00:07:00 Working with CHAR and VARCHAR2 Variables 00:08:00 Handling String Literals 00:08:00 Working with Numeric Variables 00:07:00 Working with Date Variables 00:06:00 Assigning and Using Boolean Variables 00:08:00 Using Comparison Operators 00:07:00 Using SQL Functions 00:06:00 SQL DML within PL/SQL 00:15:00 Using SELECT 00:07:00 Exceptions and Embedded SQL 00:11:00 Using Sequences 00:14:00 Logic Control and Branching 00:07:00 Using GOTO 00:06:00 Working with LOOPS 00:19:00 Creating and Using the Indefinite Loop 00:07:00 Creating and Using the Conditional Loop 00:09:00 Using Nested Loops 00:12:00 Using the If-Then-Else 00:19:00 Using the CASE Statement 00:18:00 The EXCEPTION Clause What Are the Types of Exceptions 00:06:00 Trapping Exceptions 00:06:00 Identify Exception Details 00:11:00 Creating User-Defined Exceptions 00:11:00 Using SQLCODE and SQLERRM Objects 00:09:00 Understand the Implicit Cursor 00:15:00 Creating User-Defined Events 00:12:00 Explicit Cursors Understanding the Concept and Purpose of Explicit Cursors 00:18:00 Learn about Cursor Attributes 00:10:00 Using the Continue Statement 00:06:00 Working with Updateable Cursors 00:19:00 Creating and Using Cursor Parameters 00:15:00 FORLOOP Cursors 00:07:00 Nested Blocks Understanding Nested Blocks 00:11:00 Difference between Global vs Local Objects and Exceptions 00:13:00 Declared Subprograms Subprograms: How They Differ from Nested Blocks 00:18:00 Conclusion Conclusion 00:04:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

This video course is designed to prepare you to achieve the internationally recognized fundamental IT training certification, CompTIA Security+ Certification SY0-601 exam. The course covers all the major domains needed for the certification and will help you develop the basics of IT and computers with the help of examples and quizzes.