876 Operator courses delivered Online

Our Food Hygiene and Safety Training for Catering Management Bundle Course provides a comprehensive theoretical foundation in food safety principles, equipping you with the knowledge to excel in leadership roles.

Expedite your journey with the Jq command, which is used to transform JSON data into a more readable format. Print it to the standard output on Linux with the help of this comprehensive hands-on course. This course is for anyone who works with JSON on the command line or uses Bash Shell Scripts.

Description: Programming is the language used by computer programmers to define relationship, semantics, and grammar to be able to make the computer and other digital machines work. In web development, it is used to allow new interactive applications and software to have a control through accessing different system resources. Learn the basics of Programming and Database by enrolling in this course. Who is the course for? Beginner to advanced level users can want to acquire or upgrade their programming skills People who have an interest in learning about programming and database Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The Programming and Database Course will be very helpful to have especially for these careers: Computer Maintenance Staff IT Department Manager IT Specialists Computer Engineer Computer Specialist Programmers. Beginners Programming Introduction To Programming 01:00:00 How To Write A Program 01:00:00 The List Of Programming Languages 00:30:00 Selecting The Right Compiler 00:30:00 What Is An Interpreter 00:30:00 How To Write A Program With An Editor 01:00:00 The Functions Of A Debugger 01:00:00 Build Strong Components For Programming 00:15:00 Profiling And Optimizing Your Program 01:00:00 Installing Your Program 00:15:00 BASIC Programming Language 01:00:00 Getting Started with BASIC Programming Language 01:00:00 BASIC Overview of BASIC Components 01:00:00 BASIC Special Variables 01:00:00 BASIC Probability Functions 01:00:00 Filtering the Data Set or Splitting the Data Set 01:00:00 DATA Blocks 01:00:00 DELETE Statement 01:00:00 FORNEXT Statement 01:00:00 IF. . . THEN Statement 01:00:00 Wrapping Up 00:30:00 Database Basics What is a Database 01:00:00 Definition of Terms 01:00:00 Database Users and Languages 01:00:00 Components of a Database System 01:00:00 Basic Set Concepts 01:00:00 Relations as a Database 01:00:00 Relational Database Operators 01:00:00 Database keys 01:00:00 Mock Exam Mock Exam- Programming and Database Course 00:30:00 Final Exam Final Exam- Programming and Database Course 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Get up to speed with automating repetitive tasks with Python

Using Ansible to automate local and cloud configuration management tasks with Playbooks

A photographer needs sharp eyes and excellent skills to capture a special moment perfectly. The Advanced Diploma in Photography course is designed to arm you with the skills and expertise to identify and capture the best shot. Within no time, this course will equip you with high-quality photography skills and give you the confidence to pursue a career in this industry. The Advanced Diploma in Photography course is an excellent place to build your photography skills. The course will begin with detailed introductions to different types of cameras and lenses. Then the highly informative modules will educate you on exposure, rule of thirds, aperture, shutter speed and ISO. You will learn the techniques to capture beautiful landscapes and portrait photographs. The course will also provide you with the ability to take pictures in low light. Through this course, you will learn about different types of editing tools and software to enhance the photographs.  This Advanced Diploma in Photography course will also help you understand the steps of opening your own photography business. This course will open many doors of opportunities for you. Enrol now! Learning Outcomes  Learn about different types of cameras and lenses Enrich your knowledge of exposure, aperture, shutter speed and ISO Understand how the rule of thirds Develop the essential skills for landscape and portrait photography Familiarise yourself with the tools and software used in photo editing Grasp a wide range of techniques for wedding photography Increase the ability and build confidence to start your own photography business Who is the Course for? Photographers and other hobbyists who want to upgrade their photography skills People who have an interest in photography and want to acquire photography skills Entry Requirement This course is available to all learners of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. A good understanding of the English language, numeracy and ICT are required to attend this course. Assessment At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can, however, also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why Choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet, or desktop from anywhere, anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path The Advanced Diploma in Photography course will be beneficial, especially to the following careers: Camera Operators Film and Video Editors Graphic Designers Photography Editor Professional Photographer [/vc_column_text][/vc_column][/vc_row] Photography Skills Choosing Areas of Specialization in Digital Photography FREE 00:30:00 What Makes A Good Photographer? 01:00:00 Types of Cameras for Photography 00:45:00 How Does a Camera Capture an Image? 00:15:00 Which Digital Camera Features Do You Really Need? 00:30:00 Know The Basic Elements Of Your Digital Camera 00:45:00 RAW vs JPEG 00:15:00 Photographic Lenses 00:45:00 Rule of Thirds 00:15:00 Understanding Digital Camera Modes 00:45:00 Using Automatic Camera Modes 00:30:00 Exposure 00:30:00 Introduction to Aperture 00:45:00 Introduction to Shutter Speed 00:45:00 Introduction to ISO 00:45:00 Compositional Rules in Photography 00:30:00 Semi-Automatic Shooting Modes 01:00:00 Flash Photography 01:00:00 Understanding Color in Photography 00:45:00 How to Edit Photos in Adobe Lightroom 00:45:00 Photo Editing Workflow Tutorial 01:00:00 Post Production Considerations 00:45:00 Shooting Landscapes 00:45:00 Landscape Photography Tips 01:00:00 Camera & Photography Photography Basics 00:30:00 The Art of Photography 01:00:00 How to Get the Most Out of Your Digital Camera Purchase 00:30:00 Why Having a DSLR is Like Having a Second Camera 00:30:00 What You Should Look for in a Digital Camera 01:00:00 The Benefits of Purchasing a DSLR Camera 01:00:00 Are You Getting the Most Out of Your Digital Camera? 00:30:00 Learning to Use Your Flash Properly on Your Digital Camera 00:30:00 Learn to Use Your Presets on Your Digital Camera 00:30:00 What Brand of Digital Camera is Best? 00:30:00 Understanding Shooting Speed on Your DSLR 00:30:00 Become a Good Photographer Before Buying Expensive Equipment 01:00:00 8 Digital Camera Brands You Should Know About 00:30:00 Do You Know the Best Digital Cameras to Buy? 00:30:00 Digital Camera and the Role of ISO 00:30:00 Digital Cameras Have Revolutionized Photography 00:30:00 Low Light Photography Tips 01:00:00 5 Rules of Buying a Point and Shoot Camera 00:30:00 4 Digital Camera Features You Should Understand 01:00:00 Nikon D5200 or Sony Alpha NEX-6 - Which is the Best Buy? 00:30:00 3 Basics to Consider While Buying a Digital Camera 00:15:00 Professional Photography Basics How to Become a Digital Photographer? 02:00:00 Getting into the Scene 02:00:00 Choosing the Right Camera 02:00:00 Making Pictures for a Living 03:00:00 The Tools and Software for Editing the Images 02:00:00 The Most Commonly Asked Questions 01:00:00 Starting your own Photography Business FREELANCE PHOTOGRAPHY AND YOU 00:30:00 SHOULD YOU BE IN THIS BUSINESS FOR YOURSELF? 01:00:00 WEDDINGS 01:00:00 PORTRAITS 01:00:00 CARDS 01:00:00 NEWSPAPERS 01:30:00 SPECIALTY PHOTOGRAPHY 01:00:00 COPYRIGHTING YOUR WORK 01:00:00 ESTABLISHING YOUR BUSINESS 00:30:00 Freelancing Photography Introduction 00:30:00 Photographs Everywhere You Look 00:30:00 Do You Have What It Takes? 01:00:00 Choosing a Camera 00:30:00 Get 'Get Rich Quick' Out of Your Head 00:15:00 Like Winning the Lottery 01:00:00 Microstock Photography 01:00:00 Sites That Pay for Your Photos 01:00:00 Posting Your Photos Online 00:30:00 Who Buys Photos? 00:15:00 For The Truly Ambitious 00:30:00 Wedding Photography Techniques Know Why A Professional Wedding Photographer Is Best 01:00:00 The Importance Of A Wedding Photography Shot List 00:30:00 Mistakes First Time Wedding Photographers Make 00:30:00 A Wedding Photographer Cannot Be Timid 00:30:00 Are You Using RAW? 00:30:00 Getting Great Detail Wedding Shots 00:30:00 Make The Most Of The Unexpected With Wedding Photography 01:00:00 Problems On The Site For Wedding Photographers 01:00:00 Use Continuous Shooting Features 00:30:00 Wedding Photographer Gets Up High 01:00:00 Showcase Your Photos At The Wedding Reception 00:15:00 Wedding Photography With Two Cameras? 00:30:00 Selecting Property Wedding Photo Backgrounds 00:30:00 Wedding Photographer Tips For Changing Things Up 01:00:00 Wedding Photographers Should Check Out The Location 00:05:00 Wedding Photography And Diffused Light 00:30:00 Wedding Photographer Tips For Back Up Support 00:30:00 Wedding Photographer Tip For What Couples Expect From You 00:30:00 Wedding Photography: Handling The Family Photo 00:30:00 Wedding Photography Tip For Deleting As You Go 00:15:00 Wedding Photography Is Profitable 01:00:00 Refer A Friend Refer A Friend 00:00:00 Mock Exam Mock Exam- Advanced Diploma in Photography 00:20:00 Final Exam Final Exam- Advanced Diploma in Photography 00:20:00

Course Overview Who doesn't love chocolate? A bar of tasty chocolate can lift your mood as well as give you strength. Learn how you can make delicious chocolate at home from this Homemade Chocolate Making & Baking course. This course will teach you the techniques and recipes for making different types of chocolate. In this Homemade Chocolate Making & Baking course, you will learn the journey of chocolate step by step. You'll learn how the chocolate beans are collected and processed into the chocolate bar. This course will also teach you how you can make delicious chocolate cakes. No matter in which level your cooking skill is, you can enroll on this course and learn to make desirable chocolate bars. The engaging course modules will teach you chocolate making process step by step. You will learn how to make different chocolates and make mouthwatering desserts for your family and friends. This Homemade Chocolate Making & Baking course is ideal for those who want to learn chocolate and cake making techniques from the comfort of their home. Learning Outcomes Learn about the fundamentals of chocolate making Familiarize with different tools you need to make chocolates Understand the step by step procedure of making chocolate Learn about the evolution of chocolate: from bean to bar Be able to create bake delicious chocolate cakes Make mouth-watering desserts using chocolate Who is this course for? This comprehensive Homemade Chocolate Making & Baking is ideal for those who want to learn chocolate making techniques at home. This course will give you the opportunity to learn amazing chocolate making strategies from home. Entry Requirement This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Certification After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path Homemade Chocolate Making & Baking is a useful qualification to possess and would be beneficial for any related profession or industry such as: Bakers Bakery Associates Dining Room Servers Doughnut Makers Candy Maker Helpers Candy Makers Dessert Makers Chocolate Deposit Operators Bakery Owners Module 01: Introduction to Chocolate Introduction to Chocolate 00:16:00 Module 02: Making Chocolate: From Bean to Bar Making Chocolate: From Bean to Bar 00:20:00 Module 03: Chocolate Cake Recipes Chocolate Cake Recipes 00:26:00 Module 04: More Recipes of Chocolate More Recipes of Chocolate 00:22:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Are you someone who wants to utilise the database and how it can be effectively used for your business? Do you have the plans to make your database but you are struggling since don't have the right skills to start it? Worry no more! This course is designed to help you in this dilemma. Description:  Have you ever heard about the database? Or have you heard about it and want to use it on your own? Then this course will be able to help you in that. There are a lot of people who do not like to deal with database, scripts and all the technical parts, this hinders them to start learning because they already have the mindset that it is difficult. Database creation might be difficult, but with correct attitude and practical database skills, you will surely avoid the difficulties! You have to keep in mind that the end goal should guarantee the creation of the database and to be able to make more whenever you need it. In this course, you will first know how to create your database and database users. You will then master how to import database tables since most new scripts come with a built-in installer, the scripts create all database, but when the time comes that there is no installer provided, then you have to create one manually. Who is the course for? Employees of the business industry and other businessmen who want to learn how to utilise and create their database. People who have an interest in setting up their database and learn to become an expert on it. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The Database Basics course will be very beneficial and helpful, especially to the following careers: Businessman Product Creators Programmers Sales Managers Top Executives Website Developer. Database Basics What is a Database 01:00:00 Definition of Terms 01:00:00 Database Users and Languages 01:00:00 Components of a Database System 01:00:00 Basic Set Concepts 01:00:00 Relations as a Database 01:00:00 Relational Database Operators 01:00:00 Database keys 01:00:00 Additional Supporting Material Database Basics 00:00:00 Refer A Friend Refer A Friend 00:00:00 Mock Exam Mock Exam- Database Basics 00:20:00 Final Exam Final Exam- Database Basics 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

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 Course Overview! 00:04:00 Installation And Getting Started The Final Milestone! 00:01:00 Installing and setting up PostgreSQL 00:09:00 Case Study : Demo Case Study Part 1 00:04:00 Case Study Part 2 00:06:00 Fundamental SQL statements CREATE 00:11:00 Exercise 1: Create DB and Table 00:01:00 INSERT 00:09:00 Import data from File 00:05:00 Exercise 2: Inserting and Importing 00:01:00 SELECT statement 00:03:00 SELECT DISTINCT 00:06:00 WHERE 00:04:00 Logical Operators 00:06:00 Exercise 3: SELECT & WHERE 00:01:00 UPDATE 00:05:00 DELETE 00:04:00 ALTER 00:17:00 Exercise 4: Updating Table 00:01:00 Restore And Back-Up Restore and Back-up 00:07:00 Exercise 5: Restore and Back-up 00:01:00 Selection Commands: Filtering IN 00:04:00 BETWEEN 00:05:00 LIKE 00:08:00 Exercise 6: In, Like & Between 00:01:00 Selection Commands: Ordering Side Lecture: Commenting in SQL 00:01:00 ORDER BY 00:07:00 LIMIT 00:03:00 Exercise 7: Sorting 00:01:00 Alias AS 00:03:00 Aggregate Commands COUNT 00:05:00 SUM 00:03:00 AVERAGE 00:03:00 MIN & MAX 00:04:00 Exercise 8: Aggregate functions 00:01:00 Group By Commands GROUP BY 00:12:00 HAVING 00:05:00 Exercise 9: Group By 00:01:00 Conditional Statement CASE WHEN 00:05:00 Joins Introduction to Joins 00:02:00 Inner Join 00:08:00 Left Join 00:07:00 Right Join 00:06:00 Full Outer Join 00:05:00 Cross Join 00:04:00 Except 00:03:00 Union 00:03:00 Exercise 10: Joins 00:01:00 Subqueries Subqueries 00:14:00 Exercise 11: Subqueries 00:01:00 Views And Indexes VIEWS 00:07:00 INDEX 00:06:00 Exercise 12: Views 00:01:00 String Functions LENGTH 00:03:00 Upper Lower 00:02:00 REPLACE 00:04:00 TRIM, LTRIM, RTRIM 00:07:00 CONCATENATION 00:03:00 SUBSTRING 00:06:00 LIST AGGREGATION 00:05:00 Exercise 13: String Functions 00:02:00 Mathematical Functions CEIL & FLOOR 00:03:00 RANDOM 00:05:00 SETSEED 00:04:00 ROUND 00:02:00 POWER 00:02:00 Exercise 14: Mathematical Functions 00:01:00 Date-Time Functions CURRENT DATE & TIME 00:04:00 AGE 00:03:00 EXTRACT 00:08:00 Exercise 15: Date-time functions 00:01:00 Pattern (String) Matching PATTERN MATCHING BASICS 00:07:00 ADVANCE PATTERN MATCHING (REGULAR EXPRESSIONS) 00:15:00 Exercise 16: Pattern Matching 00:01:00 Data Type Conversion Functions Converting Numbers/ Date to String 00:11:00 Converting String to Numbers/ Date 00:06:00 User Access Control Functions User Access Control 00:13:00 Bonus Section: Nail That Interview! Tablespace 00:05:00 PRIMARY KEY & FOREIGN KEY 00:05:00 ACID compliance 00:06:00 Truncate 00:04:00 Performance Tuning Tips TIP 1 (EXPLAIN) 00:04:00 TIP 2 00:01:00 TIP 3 00:02:00 TIP 4 (VACCUM) 00:01:00 TIP 5 00:02:00 TIP 6 (STRING FUNCTIONS) 00:02:00 TIP 7 (JOINS) 00:02:00 TIP 8 (SCHEMAS) 00:04:00 Bonus Section : Database Basics What is SQL 00:02:00 Tables and DBMS 00:03:00 Types of SQL commands 00:04:00 PostgreSQL 00:02:00 The Final Milestone! 00:01:00 Supplementary Resources Supplementary Resources - SQL Masterclass 00:00:00 Assessment Assessment - SQL Masterclass 00:10:00 Certificate of Achievement Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 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