Unlock the secrets of successful digital marketing with our comprehensive Digital Marketing Masterclass. From social media strategies to SEO techniques, this course empowers you with the knowledge and skills needed to thrive in the ever-evolving online landscape. Join now to gain expert insights, hands-on experience, and stay ahead in the competitive world of digital marketing. Elevate your career with our cutting-edge Masterclass today!
Are you looking for a course which will help you to advance your career in childcare setting then this course is perfect for you. Learn everything about childcare and their psychology with this Child Care! This Child Care covers everything from the fundamentals of child attachment to the complexities of children's mental health. You'll learn everything you need to know to become an expert in Childcare and thrive in your career! What else? You will also gain the ability to nurture a responsive relationship with children, thereby contributing to their cognitive and physical development, simply by recognizing your child caring skills, as provided by our Child Care that has been specifically designed for you. Training Tale is dedicated to providing you with the best Childcare skills possible. With this Child Care, you will get 8 courses! It means you will get 8 different certificates of achievement once you complete all the courses successfully. Imagine how your CV will be enriched. And the PDF certificates are completely free. At Training Tale, we provide more than just courses, we also provide a rich learning experience. When you purchase a course from Training Tale, you get unlimited access to the course with tutor support. Our expert instructors are always available to answer any questions you may have and make your learning experience unforgettable. This self-paced Child Care is ideal for all aspiring Childcare professionals because it is packed with up-to-date Child Care knowledge. Enrol in our Child Care now to take your Childcare eLearning experience to the next level! Let's see what are those 6 courses included in this Child Care- Dyslexia Autism Diploma ADHD Awareness Course Level 3 Designated Safeguarding Lead Training Course Level 2 Certificate in Behaviour that Challenges in Children Advanced Diploma in Child Care Learning Outcomes By the end of this Child Care, you will be able to - Understand the fundamentals of child attachment training to secure the best chance of many years of Childcare employment Understand trauma treatments in children to be the best in the Childcare setting Understand the development of a child. Gain a solid understanding of all the Childcare factors that influence the development of a child Understand immunisation in children Gain a thorough understanding of infancy in Childcare Gain in-depth knowledge about mental health in children and much more! Why Choose Child Care - Bundle from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials. Course developed by industry experts. MCQ quiz after each module to assess your learning. Automated and instant assessment results. 24/7 support via live chat, phone call or email. Free PDF certificate as soon as completing the course. Other Benefits of Child Care Bundle Course 6 PDF Certificate Free Expert Tutor Support Lifetime Access Unlimited Retake Child Care Course 01: Dyslexia Course Curriculum Module 01: An Overview of Dyslexia Module 02: Learning Difficulties Due to Dyslexia Module 03: Impact of Dyslexia in the Educational Setting Module 04: Helping Adults with Dyslexia Module 05: Dyslexia in the Workplace Module 06: Approaches in Dyslexia Module 07: Dyslexia Strengths and Rewards Module 08: Assessment and Evaluation of Dyslexia Module 09: Dyslexia Friendly Learning Environment Module 10: Relevant Laws for Dyslexia Course 02: Autism Diploma Course Curriculum Module 01: Introduction to Autism Spectrum Disorder (ASD) Module 02: Approaches to Helping People and Children with Autism Module 03: Diagnosis of Autism Module 04: Communication Module 05: Cognitive Styles and Functions in Autism Module 06: Autistic Behaviour Module 07: Organisation Systems with Autistic Individuals Module 08: Autism Awareness Module 09: Government Policies on Autism in England Course 03: ADHD Awareness Course Course Curriculum Module 01: Overview of ADHD Module 02: The Experience of Treatment and Care for ADHD Module 03: Families and ADHD Module 04: Psychological Interventions for Children with ADHD in Educational Settings and Parent Training Module 05: ADHD and Attention Difficulties Module 06: Cognitive Approaches in ADHD Module 07: The Organisation of Care for ADHD Course 04: Level 3 Designated Safeguarding Lead Training Course Course Curriculum Module 01: Introduction Module 02: Safeguarding Structure and Guidance Module 03: Recognising and Responding to Abuse Module 04: Responses Under the Safeguarding Structure Module 05: Working Together and Sharing Information Module 06: Recording Information Course 05: Level 2 Certificate in Behaviour that Challenges in Children Course Curriculum Module 1: Understand Behaviour That Challenges Module 2: Understand How to Support Positive Behaviour Module 3: Understand the Importance of Effective Communication and the Management of Behaviour That Challenges Module 4: Understand the Role of Reflection and Support for Those Involved in Incidents of Behaviour That Challenges Advanced Diploma in Child Care Course Curriculum Module 01: An Overview of Early Childhood Education Module 02: Empowering Children to Learn in the Early Years Module 03: The Process of Caring for Child's Development Module 04: Developing Socially and Emotionally Module 05: Aspects That Influence the Development Process Module 06: Stages of Language Development Module 07: The Process of Moral Development Module 08: Personality Development of Children Module 09: Problems During Infancy and Childhood Period Module 10: Adolescence's Problems Explained Module 11: Safeguarding Children Assessment Method After completing each module of Child Care, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Once you complete all the modules in this manner, you will be qualified to request your certification. Certification After completing the MCQ/Assignment assessment for this course, you will be entitled to a Certificate of Completion from Training Tale. It will act as proof of your extensive professional development. The certificate is in PDF format, which is completely free to download. A printed version is also available upon request. It will also be sent to you through a courier for £13.99. Who is this course for? Child Care This Child Care is ideal for anyone who wants to work or is already working in a child care setting. Requirements Child Care There is no specific requirement to enrol for this Child Care. However, you need to be over 16. Career path Child Care After completing this Child Care, you may be able to pursue a variety of career opportunities. Such as - Child Protection Officer (Average Annual Salary in the UK: £25,000 to £40,000) Psychological Wellbeing Practitioner (Average Annual Salary in the UK: £24,907 to £44,503) Child Carer Certificates Certificate of completion Digital certificate - Included
Many project managers are not able to successfully lead projects due to a lack of the necessary management skills. The Project Management Skills For Non-Project Managers course highlights the must-have skills for project managers to lead complex projects to successful completion. Each well-structured module will assist you to manage any size of projects in a very cost-effective way and making it simple to grasp the functions and liabilities of project managers. Why choose this course Earn an e-certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £69.00. Please note that overseas students may be charged an additional £10 for postage. CPD Certificate of Achievement from Janets Upon successful completion of the course, you will be able to obtain your course completion e-certificate. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Endorsement This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website. Method of Assessment In order to ensure the Quality Licensing scheme endorsed and CPD accredited certificate, learners need to score at least 60% pass marks on the assessment process. After submitting assignments, our expert tutors will evaluate the assignments and give feedback based on the performance. After passing the assessment, one can apply for a certificate. Course Content Planning the Project Define the Project Requirements 00:28:00 Create Your Project Plan 00:38:00 Implementing the Project Plan Execute the Project Plan 00:13:00 Monitor the Progress of the Project 00:20:00 Negotiate for Success 00:16:00 Evaluate the Process 00:19:00 Assignment Assignment - Project Management Skills For Non-Project Managers 6 days, 4 hours Order Your Certificate Order your Certificate QLS 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.
Content Management System is now the most popular computer software that is used to create and modify digital contents. This course has been illustrated to educate you on how it functions. It discusses the fundamental aspects of CMS. Hit the course to enter into the digital world. Start learning Concierge Course : Customer Service that will give you enough knowledge and skills to build your dream career. About this course This Concierge Course : Customer Service helps to grow your skills faster through the power of relevant content and world-class tutors. In this industry-leading bite-sized course, you will learn up-to-date knowledge in the relevant field within a few hours and get certified immediately. The modules of this course are very easy to understand and all of the topics are split into different sections. You will easily grasp and use the knowledge gained from this course in your career and go one step ahead of your competitors. The course is designed to improve your employability and provide you with the tools you need to succeed. Enrol today and start learning your essential skills. Why choose this course Earn a digital Certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Get 24/7 help or advice from our email and live chat teams Get full tutor support on weekdays (Monday to Friday) Course Design The Concierge Course : Customer Service is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Who Is This Course For: This Concierge Course : Customer Service is ideal for those who want to be skilled in this field or who wish to learn a new skill to build their dream career. If you want to gain extensive knowledge, potential experience, and be an expert in the related field then this is a great course for you to grow your career. Requirements This course is for anyone who would like to learn Concierge Course : Customer Service related skills to aid his/her career path. No formal entry prerequisites are required Certification Upon successful completion of the course, you will be able to obtain your course completion e-certificate. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Course Content Module 01: Getting To Know The Service. Module 02: Delivering Customer Service Module 03: Concierge: Etiquettes and the Workplace Module 04:Hotel Concierge Emergency Measures. Course Content Concierge Course : Customer Service Module 01: Getting To Know The Service 00:08:00 Module 02: Delivering Customer Service 00:07:00 Module 03: Concierge : Etiquettes and the Workplace 00:10:00 Module 04:Hotel Concierge Emergency Measures 00:08:00 Order your Certificates & Transcripts Order your Certificates & Transcripts 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.
Welcome to our Basic Cardiac (Heart) Care course, where we embark on a journey of understanding and compassionate care for the most vital organ in your body-your heart. This course is designed to provide essential knowledge and skills to those interested in cardiac health and well-being. Delve into the world of heart health, where you'll learn about the anatomy and functions of the heart, recognize the signs of a heart attack, and understand its potential complications. We'll guide you through emergency care procedures, and you'll gain valuable insights into risk factors, lifestyle choices, and heart remedies to keep your heart in its best shape. Join us in this educational endeavor to make a significant difference in heart care. Learning Outcomes Gain a profound understanding of cardiac health, including the structure and functionality of the heart. Acquire the knowledge and skills to recognize the signs and symptoms of a Cardiac Care Technician, as well as potential complications. Be well-prepared to provide emergency care for individuals facing a heart attack. Explore the critical aspects of risk factors related to heart health and the impact of lifestyle choices. Learn about effective heart remedies and receive valuable tips and suggestions for maintaining heart health. Why choose this Basic Cardiac (Heart) Care course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Basic Cardiac (Heart) Care course for? Individuals interested in acquiring life-saving skills for responding to heart emergencies. Healthcare professionals eager to enhance their knowledge in Emergency Medical Technician (EMT). Those looking to improve their own heart health and well-being. Caregivers, parents, and family members seeking preparation for heart-related emergencies. First responders and individuals entrusted with the well-being of others in critical situations. Career path Cardiac Care Technician: £20,000 - £40,000 Emergency Medical Technician (EMT): £22,000 - £33,000 Healthcare Educator: £30,000 - £55,000 Wellness Coach: £25,000 - £45,000 Cardiac Rehabilitation Specialist: £25,000 - £45,000 Clinical Research Coordinator: £27,000 - £50,000 Prerequisites This Basic Cardiac (Heart) Care does not require you to have any prior qualifications or experience. You can just enrol and start learning. This Basic Cardiac (Heart) Care was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Introduction & First Concepts Introduction 00:03:00 What is A Heart Attack & Complications What Is A Heart Attack 00:14:00 Complications Of A Heart Attack 00:11:00 Emergency Care For A Heart Attack Emergency Care For A Heart Attack 00:10:00 Risk Factors & Lifestyle Choices Risk Factors For Heart Disease 00:07:00 Lifestyle Choices For Your Heart 00:06:00 Heart Remedies Remedies For A Healthy Heart 00:15:00 Final Tips & Suggestions Conclusion - Final Tips & Suggestions 00:01:00 Assignment Assignment - Basic Cardiac (Heart) Care 00:00:00
Duration 5 Days 30 CPD hours This course is intended for Experienced security administrators or network administrators Overview By the end of the course, you should be able to meet the following objectives: Describe the architecture and main components of NSX-T Data Center Explain the features and benefits of NSX-T Data Center Deploy the NSX Management cluster and VMware NSX Edge⢠nodes Prepare VMware ESXi⢠and KVM hosts to participate in NSX-T Data Center networking Create and configure segments for layer 2 forwarding Create and configure Tier-0 and Tier-1 gateways for logical routing Use distributed and gateway firewall policies to filter east-west and north-south traffic in NSX-T Data Center Configure Advanced Threat Prevention features Configure network services on NSX Edge nodes Use VMware Identity Manager and LDAP to manage users and access Explain the use cases, importance, and architecture of Federation This five-day, fast-paced course provides comprehensive training on how to install, configure, and manage a VMware NSX-T? Data Center environment. This course covers key NSX-T Data Center features and functionality offered in the NSX-T Data Center 3.2 release, including the overall infrastructure, logical switching, logical routing, networking and security services, firewalls and advanced threat prevention, and more. Course Introduction Introductions and course logistics Course objectives VMware Virtual Cloud Network and NSX-T Data Center Introduce the VMware Virtual Cloud Network vision Discuss NSX-T Data Center solutions, use cases, and benefits Explain NSX-T Data Center architecture and components Describe the VMware NSXTM product portfolio and features Explain the management, control, data, and consumption planes and function Preparing the NSX-T Data Center Infrastructure Describe NSX Management Cluster Deploy VMware NSXTM ManagerTM nodes on VMware ESXi and KVM hypervisors Navigate through the NSX Manager UI Explain data-plane components such as N-VDS/VDS, transport nodes, transport zones, profiles, and more Perform transport node preparation and establish the data center infrastructure Verify transport node status and connectivity NSX-T Data Center Logical Switching Introduce key components and terminology in logical switching Describe the function and types of L2 segments Explain tunneling and the GENEVE encapsulation Configure logical segments and attach hosts using NSX Manager UI Describe the function and types of segment profiles Create segment profiles and apply them to segments and ports Explain the function of MAC, ARP, and TEP tables used in packet forwarding Demonstrate L2 unicast packet flow Explain ARP suppression and BUM traffic handling NSX-T Data Center Logical Routing Describe the logical routing function and use cases Introduce the two-tier routing architecture, topologies, and components Explain the Tier-0 and Tier-1 Gateway functions Describe the logical router components: Service Router and Distributed Router Discuss the architecture and function of NSX Edge nodes Discuss deployment options of NSX Edge nodes Configure NSX Edge nodes and create NSX Edge clusters Configure Tier-0 and Tier-1 Gateways Examine the single-tier and multitier packet flow Configure static routing and dynamic routing, including BGP and OSPF Enable ECMP on Tier-0 Gateway Describe NSX Edge HA, failure detection, and failback modes Configure VRF Lite NSX-T Data Center Bridging Describe the function of logical bridging Discuss the logical bridging use cases Compare routing and bridging solutions Explain the components of logical bridging Create bridge clusters and bridge profiles NSX-T Data Center Firewalls Describe NSX segmentation Identify the steps to enforce Zero-Trust with NSX segmentation Describe the Distributed Firewall architecture, components, and function Configure Distributed Firewall sections and rules Configure the Distributed Firewall on VDS Describe the Gateway Firewall architecture, components, and function Configure Gateway Firewall sections and rules NSX-T Data Center Advanced Threat Prevention Explain NSX IDS/IPS and its use cases Configure NSX IDS/IPS Deploy the NSX Application Platform Identify the components and architecture of NSX Malware Prevention Configure NSX Malware Prevention for east-west and north-south traffic Describe the use cases and architecture of NSX Intelligence Identify the components and architecture of VMware NSX© Network Detection and Response? Use NSX Network Detection and Response to analyze network traffic events. NSX-T Data Center Services Describe NSX-T Data Center services Explain and configure Network Address Translation (NAT) Explain and configure DNS and DHCP services Describe VMware NSX© Advanced Load Balancer? architecture, components, topologies, and use cases. Configure NSX Advanced Load Balancer Discuss the IPSec VPN and L2 VPN function and use cases Configure IPSec VPN and L2 VPN using the NSX Manager UI NSX-T Data Center User and Role Management Describe the function and benefits of VMware Identity Manager? in NSX-T Data Center Integrate VMware Identity Manager with NSX-T Data Center Integrate LDAP with NSX-T Data Center Identify the various types of users, authentication policies, and permissions Use role-based access control to restrict user access NSX-T Data Center Federation Introduce the NSX-T Data Center Federation key concepts, terminology, and use-cases. Explain the onboarding process of NSX-T Data Center Federation Describe the NSX-T Data Center Federation switching and routing functions. Describe the NSX-T Data Center Federation security concepts.
48-Hour Knowledge Knockdown! Prices Reduced Like Never Before! Being a trained and certified therapist or SEN teaching assistant can increase your exposure within your organisation and credibility with patients, students, and their parents, among other things. Our SEN - Special Educational Needs Teaching Assistant Diploma is now more comprehensive than ever, and it is appropriate for anyone interested in working in this field or simply learning more about SEN education. Special Educational Needs (SEN) capability assists children who might need additional assistance with their education due to a learning, behavioural or physical disability or another issue. It refers to the additional educational support that a student may require if they have a disability or learning difficulty. The main goal of our SEN - Special Educational Needs Teaching Assistant Diploma is to assist you in making a difference in the lives of special needs children and their families. With the right knowledge and skills, you can contribute to the development of an inclusive and supportive learning environment in which everyone can bloom. Learn how to provide exceptional support to children and infants while also gaining a thorough understanding of child development and growth in just a short time span! So why wait any longer? Enrol Now! Learning outcome Upon successful completion of this SEN - Special Educational Needs Teaching Assistant Diploma, you will be able To learn the ins and outs of SEN ( Special Educational Needs) Teaching To familiarise with the Statutory and Regulatory Context for SEN To understand how SEN and disabilities affect pupils' participation and learning Equipped with the strategies for improving the performance of the pupils with SEN To draw up inclusive whole-school policies and procedures for SEN Why Prefer Us? Opportunity to earn a certificate accredited by CPDQS. Get a free student ID card!(£10 postal charge will be applicable for international delivery) Innovative and Engaging Content. Free Assessments 24/7 Tutor Support. Take a step toward a brighter future! *** Course Curriculum of SEN - Special Educational Needs Teaching Assistant Diploma *** Here is the curriculum breakdown of the SEN - Special Educational Needs Teaching Assistant Diploma course: Module 1: Special Needs Education Teacher Module 2: Statutory and Regulatory Context for SEN Module 3: Principles and Practice of Leadership in Different Contexts Module 4: How SEN and Disabilities Affect Pupils' Participation and Learning Module 5: Strategies for Improving the Performance of the Pupils with SEN Module 6: Whole-School Planning and Organisation Module 7: Assessment Module 8: Teamwork for SEN: Roles and Functions Module 9: Planning for Individual Students with SEN Module 10: Teaching and Learning in the Inclusive School Assessment Process Once you have completed all the modules in the SEN - Special Educational Needs Teaching Assistant Diploma course, you can assess your skills and knowledge with an optional assignment. Certificate of Completion The learners have to complete the assessment of this SEN - Special Educational Needs Teaching Assistant Diploma course to achieve the CPDQS accredited certificate. Digital Certificate: £10 Hard Copy Certificate: £29 (Inside UK) Hard Copy Certificate: £39 (for international students) CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Everyone can benefit from being able to communicate better with people who have special educational needs People considering a career as a SEN teaching assistant Anyone who has a desire to work in the health and/or education field Anyone considering a career in the field of child psychology Everyone who works with or volunteers with children People who work with adults with special needs Family and friends who know someone with learning or speech difficulties so they understand the best ways to communicate with them Requirements You will not need any prior background or expertise to enrol in this course. Career path SEN - Special Educational Needs Teaching Assistant Diploma could potentially benefit several roles but would particularly enhance careers as a- Teaching Assistant Classroom Assistant SEN Teachers SEN Teaching Assistant Teacher Social care worker Child psychiatrist or therapist Certificates CPD Accredited Certificate Digital certificate - £10 CPD Accredited Certificate Hard copy certificate - £29 If you are an international student, then you have to pay an additional 10 GBP as an international delivery charge.
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