• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

2837 Administrator courses

Nursing Psychology

By Compete High

🌟 Unlock the Secrets of Nursing Psychology: Elevate Your Career Today! 🌟 Are you ready to embark on a transformative journey that will deepen your understanding of the human psyche within the context of nursing? Look no further than our groundbreaking course, 'Nursing Psychology'! 🎓 🔍 Discover the Intersection of Nursing and Psychology In this cutting-edge course, you'll explore the fascinating interplay between nursing and psychology, gaining invaluable insights into the mental and emotional aspects of patient care. From understanding the psychological factors influencing patient behavior to mastering effective communication techniques, you'll develop a holistic approach to healthcare that sets you apart as a compassionate and competent nursing professional. 💡 🚀 Benefits of Taking 'Nursing Psychology' 🔹 Enhanced Patient Care: By delving into the principles of psychology, you'll learn to provide more empathetic and personalized care tailored to each patient's unique needs and psychological state. 🔹 Improved Communication Skills: Effective communication is at the heart of nursing practice. Through our course, you'll refine your communication skills, enabling you to establish rapport with patients, alleviate anxiety, and foster trust and cooperation. 🔹 Critical Thinking and Problem-Solving: Nursing psychology equips you with the critical thinking skills necessary to assess complex situations, identify underlying psychological factors, and devise appropriate interventions for optimal patient outcomes. 🔹 Career Advancement Opportunities: Whether you're a seasoned nurse looking to expand your skill set or a nursing student eager to stand out in a competitive job market, 'Nursing Psychology' provides you with a valuable edge in your career trajectory. 💼 🎯 Who is this for? Our course is designed for nurses at all stages of their careers, from aspiring nursing students to seasoned professionals seeking to enhance their skills. Whether you're working in a hospital setting, a community health clinic, or a long-term care facility, the principles of nursing psychology are universally applicable and will empower you to excel in your role. 💼 Career Path Upon completing our 'Nursing Psychology' course, you'll be equipped with a diverse skill set that opens doors to various career paths within the nursing field. Whether you choose to specialize in psychiatric nursing, pursue advanced practice roles such as nurse practitioner or nurse educator, or explore opportunities in research and academia, the knowledge and expertise you gain will serve as a solid foundation for your professional journey. Don't miss out on this unparalleled opportunity to elevate your nursing practice and make a meaningful difference in the lives of your patients. Enroll in 'Nursing Psychology' today and take the first step towards a brighter, more fulfilling career in nursing! 🌟   FAQ (Frequently Asked Questions) for Nursing Psychology Course Q1: What is Nursing Psychology? A: Nursing Psychology is a specialized field that combines principles of psychology with nursing practice. It focuses on understanding the psychological aspects of healthcare, including how mental health influences physical well-being, how patients cope with illness and stress, and how healthcare professionals can support patients in managing their psychological needs alongside their physical health. Q2: What topics are covered in a Nursing Psychology course? A: A Nursing Psychology course typically covers a range of topics including but not limited to: Introduction to psychology and its relevance in nursing practice Psychological theories and models applicable to healthcare settings Assessment and intervention strategies for patients with mental health issues Coping mechanisms and stress management techniques for patients and healthcare providers Communication skills and therapeutic approaches for effective patient care Ethical considerations and legal issues in nursing psychology practice Q3: Who can benefit from studying Nursing Psychology? A: Nursing Psychology is beneficial for a wide range of individuals including nursing students, practicing nurses, healthcare professionals, psychologists, and anyone interested in the intersection of psychology and healthcare. It equips individuals with valuable insights and skills to provide holistic care to patients, addressing both their physical and psychological needs. Q4: How does Nursing Psychology contribute to patient care? A: Nursing Psychology contributes to patient care by: Recognizing and addressing the psychological factors influencing patients' health outcomes Providing emotional support and coping strategies to patients facing illness, trauma, or stress Enhancing communication between healthcare providers and patients to improve treatment adherence and patient satisfaction Collaborating with interdisciplinary teams to develop comprehensive care plans that consider patients' psychological well-being alongside their physical health. Q5: What career opportunities are available in Nursing Psychology? A: Graduates with expertise in Nursing Psychology can pursue various career paths including: Clinical nurse specialists in mental health settings Nurse educators or consultants specializing in psychological aspects of healthcare Researchers exploring the intersection of nursing and psychology Administrators or managers in healthcare organizations advocating for holistic patient care Mental health counselors or therapists working in collaboration with healthcare teams. Course Curriculum Module 1 What Is Psychology What Is Psychology 00:00 Module 2 Consciousness Consciousness 00:00 Module 3 Organs Of Consciousness Organs Of Consciousness 00:00 Module 4 The Normal Mind The Normal Mind 00:00 Module 5 Aspects Of The Normal Mind Aspects Of The Normal Mind 00:00 Module 6 Psychology and Health Psychology and Health 00:00 Module 7 Variations From Normal Mental Processes Variations From Normal Mental Processes 00:00 Module 8 Psychology Of The Nurse Psychology Of The Nurse 00:00

Nursing Psychology
Delivered Online On Demand8 hours
£25

The Complete Guide To Getting A Teaching Job

By The Teachers Training

Overview The Complete Guide To Getting A Teaching Job Course is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this The Complete Guide To Getting A Teaching Job Course and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 05 Hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification CPD Certification from The Teachers Training After you have successfully completed your assignment, you will be qualified to apply for a CPD Certification from The Teachers Training. The PDF certificate can be downloaded after you have completed your course. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Introduction Course Introduction 00:05:00 Who Am I? 00:03:00 Job Search Where to Look for a Teaching Job 00:06:00 Researching the District and School 00:02:00 Teaching Portfolio 00:03:00 Application: Things to Avoid 00:05:00 A Winning Resume and Cover Letter The Cover Letter 00:09:00 The Resume 00:05:00 Interviews How to Get the Interview 00:08:00 How to Prepare for the Interview 00:06:00 How to Make a Good First Impression 00:08:00 What Administrators are Looking for 00:09:00 Questions You Should Ask 00:03:00 The Telephone Interview 00:03:00 The Demonstration Lesson 00:09:00 Closing the Interview and Follow-up 00:03:00 Conclusion Last Minute Tips 00:06:00 Bonus Lecture: Course Wrap Up 00:01:00

The Complete Guide To Getting A Teaching Job
Delivered Online On Demand1 hour 34 minutes
£25

Consent Training in Healthcare Course Part - 1

By iStudy UK

Course Description Get instant knowledge from this bite-sized Consent Training in Healthcare Course Part - 1 course. This course is very short and you can complete it within a very short time. In this Consent Training in Healthcare Course Part - 1 course you will get fundamental ideas of consent in the healthcare sector, the key understanding of information regarding consent, consenting for someone else and so on. Enrol in this course today and start your instant first step towards learning about consent. Learn faster for instant implementation. Learning Outcome Familiarise with consent Understand information regarding consent Gain in-depth knowledge of consenting for someone else Deepen your understanding of best interest decision making How Much Do Healthcare Administrators Earn? Senior - £58,000 (Apprx.) Average - £35,000 (Apprx.) Starting - £21,000 (Apprx.) Requirement Our Consent Training in Healthcare Course Part - 1 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. Consent Training in Healthcare Course Part - 1 Module 01: An Introduction to Consent 00:12:00 Module 02: Information Regarding Consent 00:11:00 Module 03: Consenting for Someone Else 00:15:00 Module 04: Best Interest Decision Making 00:20:00 Assignment Assignment - Consent Training in Healthcare Course Part - 1 00:00:00

Consent Training in Healthcare Course Part - 1
Delivered Online On Demand58 minutes
£25

Consent Training in Healthcare Course Part - 2

By iStudy UK

Course Description Get instant knowledge from this bite-sized Consent Training in Healthcare Course Part - 2 course. This course is very short and you can complete it within a very short time. In this Consent Training in Healthcare Course Part - 2 course you will get fundamental ideas of consent in the healthcare sector, the key understanding of the MCA Act 2005, providing treatment to people who lack capacity and so on. Enrol in this course today and start your instant first step towards learning about assessing capacity. Learn faster for instant implementation. Learning Outcome Understand how to assess capacity Gain in-depth knowledge of providing care or treatment to people who lack capacity Deepen your understanding of public bodies and services created by MCA Act 2005 Understand the UK acts in relation to consent Learn about handling complaints regarding consent How Much Do Healthcare Administrators Earn? Senior - £58,000 (Apprx.) Average - £35,000 (Apprx.) Starting - £21,000 (Apprx.) Requirement Our Consent Training in Healthcare Course Part - 2 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. Consent Training in Healthcare Course Part - 2 Module 01: Assessing Capacity 00:13:00 Module 02: Providing Care or Treatment to People Who Lack Capacity 00:12:00 Module 03: Public Bodies and Services Created by MCA Act 2005 00:09:00 Module 04: UK Acts in Relation to Consent 00:26:00 Module 05: Handling Complaints Regarding Consent 00:20:00 Assignment Assignment - Consent Training in Healthcare Course Part - 2 00:00:00

Consent Training in Healthcare Course Part - 2
Delivered Online On Demand1 hour 20 minutes
£25

Complete Office Administration Online Course

By iStudy UK

Course Overview An office administrator's role includes organising meetings, managing databases, receiving and directing visitors, and more. It requires a great deal of expertise to carry out this long list of responsibilities. But don't worry, the Complete Office Administration Online Course is here to equip you with all the essential skills to prosper as an office admin.  In this extensive Complete Office Administration Online Course, you will be able to improve your communication skills. You will acquire excellent organisational skills. This curriculum includes lessons on bookkeeping and payroll management. It will enrich your skills in financial planning and budgeting. Step-by-step, you will be able to conquer all the skills to provide adequate admin support.  Whether you are already a professional or wishing to pursue a career in the admin sector, this course is the perfect package to learn how to balance your responsibilities. Join the course to gear up with all the admin skills and prepare for a cherishable career. What You Will Learn You'll learn about: Admin Support Managing Time Verbal and Non-verbal Communication Skills Business Writing Writing Business Reports, E-mails, Letters and Meeting Agendas Bookkeeping & Payroll Management Financial Planning, Budgeting and Control Auditing Customer Service and Telephone Handling MS Office and many more Why You Should Choose This Course From iStudy Study at your own pace Full Tutor support on weekdays (Monday - Friday) Fully compatible with any device Free Printable PDF Certificate immediately after completion No prior qualifications are needed to take this course No hidden fees or exam charges CPD Qualification Standards and IAO accredited Efficient exam system, assessment, and instant results Our customer support team is always ready to help you Gain professional skills and better earning potential Certification After completing the course you'll receive a free printable CPD accredited PDF certificate. Hard Copy certificate is also available, and you can get one for just £9! Accreditation This course is accredited by Continuing Professional Development (CPD). It is a recognised independent accreditation service. Enrol today and learn something new with iStudy. You'll find a full breakdown of the course curriculum down below, take a look and see just how much this course offers. We're sure you'll be satisfied with this course.

Complete Office Administration Online Course
Delivered Online On Demand5 days
£25

Health and Safety Diploma

By Compliance Central

The MOST DEMANDED PATHWAY Are WAITING for YOU... < Take an Offer, Get Started with Unlimited Access & Claim a BIGGER Saving > Are you looking to enhance your Health and Safety skills? If yes, then you have come to the right place. Our comprehensive course on Health and Safety will assist you in producing the best possible outcome by mastering the Health and Safety skills. Learning Outcomes: Upon successful completion of this highly appreciated Health and Safety course, you'll be a skilled professional, besides- You can provide services related to Health and Safety with complete knowledge and confidence. You'll be competent and proficient enough to start a Health and Safety related business on your own. Furthermore, you can train up others and grow an efficient peer community on your locality and serve people. It will enhance your portfolio, you can use the certificate as proof of your efficiency to the employer. It will boost up your productivity, you can use the skill and credentials, and become more competent in your vocation with increased earning! Exclusive Bonus Courses: Course 01: Homeworker's Risk Assessment, Health and Safety Course 02: Health and Safety Policy for School Administrators Course 03: Personal Hygiene Course 04: Occupational Health and Safety Course 05: Workplace First Aid Level 4 Along with the Health and Safety courses, you also get: Lifetime Access. Unlimited Retake Exam & Tutor Support. Easy Accessibility to the Course Materials- Anytime, Anywhere - From Any Smart Device (Laptop, Tablet, Smartphone Etc.) 100% Learning Satisfaction Guarantee. Curriculum Breakdown of the Course:- Health and Safety at Work and the Laws Managing for Health and Safety Risk Assessment and Common Risks Accidents and Ill Health at Work Incident Management at Work Electrical, Fire and Gas Safety Measures of Fire Safety Fire Emergency: Evacuation Procedures The Fire Plan and Safety Arrangements Manual Handling Hazards and Injuries Manual Handling Risk Control Safe Lifting Techniques Working at Height Working at Height Equipment Working in Confined Spaces and the Law Control Measures for Working in Confined Spaces Emergency Procedures for Working in Confined Spaces Different Work Settings Work Equipment Hazards and Risk Control Other Health and Safety Hazards at Work Basic First-Aid Techniques Dealing with Minor Injuries at the Workplace Call for an Emergency Problems Related to Hazardous Substances Identifying Hazardous Substances Control Measures and Monitoring Implementing Control Measures CPD 60 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Health and Safety bundle. Requirements To enrol in this Health and Safety course, all you need is a basic understanding of the English Language and an internet connection. Career path After completing this course, you can explore trendy and in-demand jobs, such as- Safety Engineer Safety Consultant Coordinator of Loss Control Safety Manager Risk Manager Loss Control Manager Safety Director Certificates CPD Accredited PDF Certificate Digital certificate - Included 6 CPD Accredited PDF Certificates for Free CPD Accredited Hard Copy Certificate Hard copy certificate - £9.99 CPD Accredited Hard Copy Certificate for £9.99 each. Delivery Charge: Inside the UK: Free Outside of the UK: £9.99

Health and Safety Diploma
Delivered Online On Demand33 hours
£25

Facilities Management Diploma

By iStudy UK

Facilities Management Diploma Overview The entire training course for facilities managers, coordinators, and administrators is called the Facilities Management Diploma. It looks at the obligations, basic competencies, and tasks necessary to succeed in the workplace. With the knowledge and skills you get from our diploma programme in facilities management, you will be able to manage the operations and productivity of services, improve workplace safety and health, and much more. In addition, it offers training in quality project management and detailed instructions for drafting a quality management plan. Your comprehension of sustainable facility management, business development, succession planning, lease purchase and vendor management, and HR management will also grow as a result of this. Why You Should Choose Facilities Management Diploma Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Facilities Management Diploma is CPD certified and IAO accredited. 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 backgrounds. Requirements Our Facilities Management Diploma 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 You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Facilities Management Diploma Module 01: Introduction to Facility Management Introduction to Facility Management 00:25:00 Module 02: Space Management Space Management 00:21:00 Module 03: Managing Workplace Services Managing Workplace Services 00:30:00 Module 04: Human Resource and Contract Management Human Resource and Contract Management 00:22:00 Module 05: Lease Purchase and Vendor Management Lease Purchase and Vendor Management 00:24:00 Module 06: Health and Safety at Work Health and Safety at Work 00:22:00 Module 07: Sustainable Facility Management Sustainable Facility Management 00:15:00 Module 08: Maintenance and Repairs Maintenance and Repairs 00:18:00 Module 09: Project Management Project Management 00:19:00 Module 10: Business Development and Succession Planning Business Development and Succession Planning 00:25:00

Facilities Management Diploma
Delivered Online On Demand3 hours 41 minutes
£25

The Complete Guide To Getting A Teaching Job

By iStudy UK

The Complete Guide To Getting A Teaching Job online course is for anyone looking for a teaching job. It will also be a great refresher course for any teacher who wants to change teaching jobs. Teaching is a challenging job and you'll always need to keep updating your resume by networking and enhancing interviewing skills. If you ever get downsized, or change teaching positions or want to leave your district for another district, you need these skills to get the teaching job you want. What you'll learn Use unconventional job search techniques to find teaching jobs ahead of the competition and land interviews Confidently walk into any teacher interview with knowledge of the top questions interviewers ask and the best answers Teach a demonstration lesson that will impress Who is this Course for? The Complete Guide To Getting A Teaching Job course is designed for aspiring teachers looking to get into the teaching profession. The course will be a great fit for you if you are enthusiastic about learning the methods and teaching. This course is designed for anyone looking to land a teaching job or change teaching positions. All teachers would benefit from the curriculum, but it is intended for 4th-8th grade teachers who want easy to implement solutions that work for successful classroom and behaviour management. Teachers who really want to make a difference in the lives of their students. Requirements  This course requires no qualifications. Teaching prerequisites for the area you desire to teach in is extremely helpful but is not required. These requirements can also be fulfilled later or during the course. The Complete Guide To Getting A Teaching Job course is fully compatible with any kind of device. Whether you are using a Windows computer, Mac, smartphone or tablet, 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 You will be ready to enter the job market as a teacher after completing this course, you will be very well-equipped with the necessary knowledge and skills required to succeed as a teacher. All of our courses are CPD and IAO accredited, so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Introduction Course Introduction FREE 00:05:00 Who Am I? FREE 00:03:00 Job Search Where to Look for a Teaching Job 00:06:00 Researching the District and School 00:02:00 Teaching Portfolio 00:03:00 Application: Things to Avoid 00:05:00 A Winning Resume and Cover Letter The Cover Letter 00:09:00 The Resume 00:05:00 Interviews How to Get the Interview 00:08:00 How to Prepare for the Interview 00:06:00 How to Make a Good First Impression 00:08:00 What Administrators are Looking for 00:09:00 Questions You Should Ask 00:03:00 The Telephone Interview 00:03:00 The Demonstration Lesson 00:09:00 Closing the Interview and Follow-up 00:03:00 Conclusion Last Minute Tips 00:06:00 Bonus Lecture: Course Wrap Up 00:01:00

The Complete Guide To Getting A Teaching Job
Delivered Online On Demand1 hour 34 minutes
£25

Oracle 11g PL/SQL Part 2

By iStudy UK

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

Oracle 11g PL/SQL Part 2
Delivered Online On Demand9 hours 47 minutes
£25

Oracle 11g PL/SQL Part 1

By iStudy UK

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

Oracle 11g PL/SQL Part 1
Delivered Online On Demand9 hours 54 minutes
£25