28377 Development courses delivered Online

Empower yourself with essential coping skills through our comprehensive training course. Learn practical techniques to manage stress, anxiety, and challenges effectively. Gain resilience and improve your overall well-being. Enroll now and take control of your mental health journey.

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

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

Description Learn how to provision Azure SQL with the intensive course MS Azure - SQL. Microsoft Azure SQL is Microsoft's cloud database service, based on SQL Server database technology. It enables organizations to store relational data in the cloud and helps to quickly scale the size of their databases up or down as business needs change. Using Azure SQL, you can create, scale and extend applications into the cloud. Throughout the course, you will understand various databases that are available in Azure. The course teaches you how to provision, configure and manage Azure SQL. You will learn the procedures for working with SQL security metrics. You will know how to connect to Azure SQL DB and how to migrate DB to SQL. The course also shows you how to copy and export a database, and also how to manage data recovery and availability using DB Self-Service Restore. The system of configuring SQL DB auditing will also be discussed in the course. Lastly, the course focuses on SQL DB Geo-Replication. 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? MS Azure - SQL 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 MS Azure - SQL 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:02:00 Azure SQL Azure SQL 00:02:00 Provisioning Azure SQL 00:06:00 Connecting to Azure SQL DB 00:08:00 Migrating to Azure DB 00:06:00 Understanding SQL Security 00:03:00 Understanding SQL DB Metrics and Auditing 00:05:00 Backing Up and Protecting your Database 00:05:00 Using SQL DB Geo-Replication 00:03:00 Conclusion Course Recap 00:02:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Delve into big data streaming with Azure using Event Hubs, Data Lake, and Azure Stream Analytics

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

Photography: Photography Course Online Are you interested in becoming a Photography specialist? This online course on photography is ideal for you to learn the foundations of the Photography right away. This Photography: Photography class will assist you in understanding how to concentrate and manage your exposure controls. Understanding the Photography features, benefits, lenses, and lighting settings of the DSLR is another benefit of taking this Photography: Photography course. The Photography: Photography course covers describing live views, movies, landscapes, animal Photography, and natural photography. In this Photography: Photography course, you will also learn how to take close-up and mirrorless photos. To learn all the techniques needed to take amazing photos, sign up for this Photography: Photography course! Main Course: Photography Course Free Courses included with Photography: Photography Course: Along with Photography: Photography Course you will get free Personal Development Along with Photography: Photography Course you will get free Anger Management Along with Photography: Photography Course you will get free Negotiation Skills Along with Photography: Photography Course you will get free Communication Skills Special Offers of this Photography: Photography Course; This Photography: Photography Course includes a FREE PDF Certificate. Lifetime access to this Photography: Photography Course Instant access to this Photography: Photography Course 24/7 Support Available to this Photography: Photography Course Photography: Photography Course Online You will learn how to focus and regulate your exposure in this photography course. The understanding of the DSLR's features, benefits and various lenses used for Photography. Also, the lighting configurations are elaborated in this photography course. The Photography course explains how to take live views, movies, landscapes, animal photographs, and nature photography. This photography course will also teach you how to use a mirrorless camera and take close-up shots. Who is this course for? Photography: Photography Course Online This Photography: Photography Course is open to everyone. Requirements Photography: Photography Course Online To enrol in this Photography: Photography Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Photography: Photography Course. Be energetic and self-motivated to complete our Photography: Photography Course. Basic computer Skill is required to complete our Photography: Photography Course. If you want to enrol in our Photography: Photography Course, you must be at least 15 years old. Career path Photography: Photography Course Online This Photography: Photography Course will prepare you for many exciting career opportunities in this field of photography.

Communication Skills & Networking Skills Course - CPD Accredited Are you looking to strengthen your communication skills? This communication skills course is precisely planned and developed. You will receive simple-to-understand lessons as well as insightful information on the field of communication skills courses. This communication skills course aimed at providing participants a thorough understanding of communication skills with an emphasis on best practices and the underlying expertise. The Communication Skills Course will help you by teaching you about various forms, processes, and styles of communication. The Communication Skills Course also discusses communication barriers. In this specialised Communication Skills Course, you will learn the Main Seven Steps for Successful Communication in short. You will learn about the Dos and Don'ts of Successful Communication from the Communication Skills course. Hence, enrol as soon as possible in this communication skills course to maximise your potential. Learning Outcome of Communication Skills & Networking Skills Course Communication Skills Course will describe about types of Communication Different Barriers to Communication will be briefly explain in Communication Skills Course How to access in Communication Competence and its process are a part of this Communication Skills Course You will know about Seven Actions for Effective Communication Communication Skills Course explain Do's and Don'ts of Effective Communication Communication Skills & Networking Skills Course - CPD Accredited Course This Communication Skills: Communication Skills Course includes a FREE PDF Certificate. Lifetime Communication Skills: Communication Skills Course Instant access to this Communication Skills: Communication Skills Course Get FREE Tutor Support to this Communication Skills: Communication Skills Course Communication Skills & Networking Skills Course - CPD Accredited Unlock your full potential with our Communication Skills: Communication Skills course! Designed to strengthen your understanding of Communication Skills: Communication Skills, this course offers easy-to-follow lessons and essential insights into effective communication. Master the Communication Skills: Communication Skills fundamentals, covering various communication styles, processes, and strategies. Learn to overcome communication barriers and apply the main seven steps for success. Our Communication Skills: Communication Skills course also covers the Dos and Don’ts to ensure impactful interactions. Enroll today to enhance your Communication Skills: Communication Skills and open doors to new opportunities! Who is this course for? Communication Skills & Networking Skills Course - CPD Accredited The Communication Skills course is the perfect fit for anyone interested in or working in this industry. Requirements Communication Skills & Networking Skills Course - CPD Accredited To enrol in this Communication Skills: Communication Skills Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Communication Skills: Communication Skills Course. Be energetic and self-motivated to complete our Communication Skills: Communication Skills Course. Basic computer Skill is required to complete our Communication Skills: Communication Skills Course. If you want to enrol in our Communication Skills: Communication Skills Course, you must be at least 15 years old. Career path Communication Skills & Networking Skills Course - CPD Accredited If you do the Communication Skills Course, the worth of your resume will increase and you'll be more qualified.

This course will help you qualify for the Microsoft SC 900 exam, and this certification is targeted at those looking to familiarize themselves with the fundamentals of security, compliance, and identity across cloud-based and related Microsoft services.

***24 Hour Limited Time Flash Sale*** Domestic Electrical Installer - CPD Certified Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Are you a professional feeling stuck in your career, struggling to keep up with the ever-changing demands of the industry? Or perhaps you're a beginner, unsure of where to start or how to break into your desired field. Whichever stage you're in, our exclusive Domestic Electrical Installer - CPD Certified Bundle provides unique insights and tools that can help you achieve your goals. Designed to cater to the needs of both seasoned professionals and aspiring newcomers, our Domestic Electrical Installer - CPD Certified bundle is a comprehensive program that will equip you with the essential skills and knowledge you need to succeed. Whether you're looking to advance in your current role or embark on a new career journey, this bundle has everything you need to take your professional life to the next level. But that's not all. When you enrol in Domestic Electrical Installer - CPD Certified Online Training, you'll receive 20 CPD-Accredited PDF Certificates, Hard Copy Certificates, and our exclusive student ID card, all absolutely free. Courses Are Included In this Domestic Electrical Installer - CPD Certified Career Bundle: Course 01: Domestic Electrical Installer Course 02: Domestic Appliance Repair Technician Training Course 03: Smart Meter Installer Course Course 04: Electronic & Electrical Devices Maintenance & Troubleshooting Course 05: PAT Training Course 06: Digital Electric Circuits & Intelligent Electrical Devices Course 07: Basic Electricity, Ohm's Law and Circuit Analysis Diploma Course 08: Short Circuit Analysis for HV Three Phase Systems Course 09: Electrical 3 Phase Power Transformers Fundamentals Course 10: Electrical Engineering - Light Current System Course 11: Electrical Power System and High Voltage Engineering Course 12: Energy Saving: Electric Motors Course 13: Handyperson Course 14: Heating, Ventilation & Air Conditioning (HVAC) Technician Course 15: Electrical Training Certificate, Fire Safety Measures and Legislation Course 16: Electrical Engineering for Electrical Substations Course 17: Distribution Station & Feeder Protection Course 18: PUWER Course 19: Electrical Safety Course 20: Lone Worker Safety & Protection With Domestic Electrical Installer, Electrical Wiring & Electrical Safety, you'll embark on an immersive learning experience that combines interactive lessons with voice-over audio, ensuring that you can learn from anywhere in the world, at your own pace. And with 24/7 tutor support, you'll never feel alone in your journey, whether you're a seasoned professional or a beginner. Don't let this opportunity pass you by. Enrol in Domestic Electrical Installer - CPD Certified today and take the first step towards achieving your goals and dreams. Why buy this Domestic Electrical Installer, Electrical Wiring & Electrical Safety? Free CPD Accredited Certificate upon completion of Domestic Electrical Installer, Electrical Wiring & Electrical Safety Get a free student ID card with Domestic Electrical Installer, Electrical Wiring & Electrical Safety Lifetime access to the Domestic Electrical Installer - CPD Certified course materials Get instant access to this Domestic Electrical Installer - CPD Certified course Learn Domestic Electrical Installer - CPD Certified from anywhere in the world 24/7 tutor support with the Domestic Electrical Installer - CPD Certified course. Start your learning journey straightaway with our Domestic Electrical Installer - CPD Certified Training! Domestic Electrical Installer - CPD Certified premium bundle consists of 20 precisely chosen courses on a wide range of topics essential for anyone looking to excel in this field. Each segment of the Domestic Electrical Installer - CPD Certified is meticulously designed to maximise learning and engagement, blending interactive content and audio-visual modules for a truly immersive experience. Certification You have to complete the assignment given at the end of the Domestic Electrical Installer - CPD Certified course. After passing the Domestic Electrical Installer - CPD Certified exam You will be entitled to claim a PDF & Hardcopy certificate accredited by CPD Quality standards completely free. CPD 200 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Domestic Electrical Installer - CPD Certified course is ideal for: Students seeking mastery in Domestic Electrical Installer, Electrical Wiring & Electrical Safety Professionals seeking to enhance Domestic Electrical Installer - CPD Certified skills Individuals looking for a Domestic Electrical Installer, Electrical Wiring & Electrical Safety-related career. Anyone passionate about Domestic Electrical Installer, Electrical Wiring & Electrical Safety Requirements This Domestic Electrical Installer - CPD Certified doesn't require prior experience and is suitable for diverse learners. Career path This Domestic Electrical Installer - CPD Certified bundle will allow you to kickstart or take your career in the related sector to the next stage. Certificates CPD Accredited Digital Certificate Digital certificate - Included CPD Accredited Hard Copy Certificate Hard copy certificate - Included If you are an international student, you will be required to pay an additional fee of 10 GBP for international delivery, and 4.99 GBP for delivery within the UK, for each certificate