39017 Courses in Cardiff delivered Online

Autism: Autism Training Around one out of every 100 children has been diagnosed with autism, so teachers must educate themselves with the skills and knowledge needed to properly support autistic children. This Autism Training course will teach you about the various signs of autism and the difficulties people with autism encounter in education, communication, socialization, and developing relationships. Furthermore, this Autism Training course will teach you how to assist others facing similar difficulties in improving their lives. Enrol in our Autism Spectrum Disorder (ASD) today to pursue your dreams and gain the experience, skills, and knowledge required to advance your career development in the field. Special Offers of this Autism: Autism Training Course This Autism: Autism Training Course includes a FREE PDF Certificate. Lifetime access to this Autism: Autism Training Course Instant access to this Autism: Autism Training Course Get FREE Tutor Support from Monday to Friday in this Autism: Autism Training Course Autism: Autism Training This comprehensive Autism Spectrum course will guide you through the numerous obstacles that autistic children encounter, as well as how to provide the appropriate support and help. After you have gained a better understanding of the disorder, this Autism Training course will show you how to approach children and adults with autism and make them feel at ease in your presence. "Empower your team with our cutting-edge Autism Training course! Gain invaluable insights into understanding Autism spectrum disorders. Our expert instructors provide comprehensive strategies for supporting individuals with Autism in various settings. Equip your staff with essential skills and knowledge to create inclusive environments with our Autism Training course today!" Certificate of Completion You will receive a Autism Spectrum Disorder (ASD) course completion certificate for free as soon as you complete the Autism Training course. Module 01: Introduction to Autism Spectrum Disorder (ASD) 13:56 1: Introduction to Autism Spectrum Disorder (ASD) Preview 10:56 2: Quiz: Introduction to Autism Spectrum Disorder (ASD) 03:00 Module 02: Approaches to Helping People and Children with Autism 33:15 3: Approaches to Helping People and Children with Autism 29:15 4: Quiz: Approaches to Helping People and Children with Autism 04:00 Module 03: Diagnosis of Autism 12:38 5: Diagnosis of Autism 10:38 6: Quiz: Diagnosis of Autism 02:00 Module 04: Communication 16:45 7: Communication 14:45 8: Quiz: Communication 02:00 Module 05: Cognitive Styles and Functions in Autism 13:26 9: Cognitive Styles and Functions in Autism 11:26 10: Quiz: Cognitive Styles and Functions in Autism 02:00 Module 06: Autistic Behaviour 20:48 11: Autistic Behaviour 17:48 12: Quiz: Autistic Behaviour 03:00 Module 07: Organisation Systems with Autistic Individuals 14:19 13: Organisation Systems with Autistic Individuals 12:19 14: Quiz: Organisation Systems with Autistic Individuals 02:00 Module 08: Autism Awareness 08:37 15: Autism Awareness 05:37 16: Quiz: Autism Awareness 03:00 Module 09: Government Policies on Autism in England 13:08 17: Government Policies on Autism in England 10:08 18: Quiz: Government Policies on Autism in England 03:00 Who is this course for? Autism: Autism Training This Autism Training course is ideal for Everyone. Special Note: Our Autism Training Diploma Course is not a regulated course. To get Qualified, you may choose the following options: Level 2 Certificate in Understanding Autism (RQF) NCFE Level 2 Certificate in Understanding Autism Level 3 Certificate in Understanding Autism (RQF) Certificate in understanding autism (QCF) Level 3 Certificate in Understanding Autism (QCF) Understanding Autism Level 2 Course (RQF) Level 2 Certificate in Understanding Autism (QCF) Level 3 Certificate in Understanding Autism (NCFE) Requirements Autism: Autism Training Students who intend to enrol in this Autism: Autism Training course must meet the following requirements: Autism: Autism Training: Good command of the English language Autism: Autism Training: Must be vivacious and self-driven Autism: Autism Training: Basic computer knowledge Autism: Autism Training: A minimum of 16 years of age is required Career path Autism: Autism Training Certificates Reed courses certificate of completion Digital certificate - Included Will be downloadable when all lectures have been completed

***24 Hour Limited Time Flash Sale*** Construction Management, Cost Estimation and Safety Training Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Set the cornerstone for your career in construction with our "Construction Management, Cost Estimation and Safety Training" eight-course bundle. Consisting of three Quality Licence Scheme-endorsed courses in Construction Management, Construction Cost Estimation, and Construction Safety, you will receive a hardcopy certificate for each to showcase your theoretical knowledge and dedication. This bundle is also fortified with five CPD QS accredited courses. Key Features of the Construction Management, Cost Estimation and Safety Training Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our Construction Management, Cost Estimation and Safety Training bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: Construction Management QLS Course 02: Construction Cost Estimation QLS Course 03: Construction Safety 5 CPD QS Accredited Courses: Additionally, our bundle includes 5 relevant CPD QS accredited courses, ensuring that you stay up-to-date with the latest industry standards and practices. Course 01: Construction Industry Scheme (CIS) Course 02: LEED V4 - Building Design and Construction Course 03: WELL Building Standard Course 04: Construction Estimation using RSMeans Course Course 05: AutoCAD VBA Programming - Beginner course In Addition, you'll get Five Career Boosting Courses absolutely FREE with this Bundle. Course 01: Professional CV Writing Course 02: Job Search Skills Course 03: Self-Esteem & Confidence Building Course 04: Professional Diploma in Stress Management Course 05: Complete Communication Skills Master Class Convenient Online Learning: Our Construction Management, Cost Estimation and Safety Training courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home. Learning Outcomes: Understand the theoretical principles of Construction Management. Learn the essentials of Construction Cost Estimation. Gain knowledge about Construction Safety protocols. Get familiar with the Construction Industry Scheme (CIS). Understand LEED V4 Building Design and WELL Building Standard. Learn to estimate construction costs using RSMeans. Get introduced to AutoCAD VBA Programming. Discover the world of construction with our expertly designed eight-course bundle, tailored to provide a comprehensive theoretical understanding of construction management, cost estimation, and safety. From getting acquainted with CIS, LEED V4 and WELL standards to using RSMeans for estimation and introduction to AutoCAD VBA programming, this bundle is your gateway to the construction industry. CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals aiming for a theoretical understanding of Construction Management. Aspiring professionals looking for comprehensive knowledge in Cost Estimation and Construction Safety. Anyone keen to understand the Construction Industry Scheme (CIS) and LEED V4 & WELL Building Standards. Career path Construction Manager - Avg. salary: £44,000 per year. Cost Estimator in construction - Avg. salary: £38,000 per year. LEED Consultant - Avg. salary: £42,000 per year. WELL Building Standard Consultant - Avg. salary: £45,000 per year. AutoCAD Programmer - Avg. salary: £39,000 per year. Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included

For over 30 years, the National Academy of Sports Medicine has developed the most successful personal trainers in the fitness industry. The NCCA-accredited personal trainer certification provides you with the most scientifically accurate information, all delivered in a revolutionary digital learning platform. If you want to become one of the best, most respected, and highest-paid fitness trainers, it’s as simple as getting certified online with NASM.

***24 Hour Limited Time Flash Sale*** Health & Social Care, Consent Training and Liberty Safeguards Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter In the ever-evolving landscape of healthcare, staying updated is not an option but a necessity. Introducing our meticulously crafted bundle "Health & Social Care, Consent Training, and Liberty Safeguards," designed to serve you the theoretical knowledge in the most digestible format. Our package includes three QLS-endorsed courses: Health and Social Care Management, Consent Training in Healthcare, and Deprivation of Liberty Safeguards. Not only these courses offer valuable insights, but they also reward you with a hardcopy certificate upon completion, which could be an excellent addition to your professional profile. In addition, this comprehensive bundle caters five CPD QS accredited courses: Care Assistant, End of Life Care Course, Social Care, Maternity Care Assistant Course, and Medical Terminology Training. Each of these courses could be a stepping stone towards enhancing your understanding of healthcare practices, legal considerations, and medical terminology, all essential for Health & Social Care, Consent Training, and Liberty Safeguards. Key Features of the Health & Social Care, Consent Training and Liberty Safeguards Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our [Course_Title] bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: Health and Social Care Management QLS Course 02: Consent Training in Healthcare Course QLS Course 03: Deprivation of Liberty Safeguards 5 CPD QS Accredited Courses: Additionally, our bundle includes 5 relevant CPD QS accredited courses, ensuring that you stay up-to-date with the latest industry standards and practices. Course 01: Care Assistant Course 02: End of Life Care Course Course 03: Social Care Course 04: Maternity Care Assistant Course Course 05: Medical Terminology Training In Addition, you'll get Five Career Boosting Courses absolutely FREE with this Bundle. Course 01: Professional CV Writing Course 02: Job Search Skills Course 03: Self Esteem & Confidence Building Course 04: Professional Diploma in Stress Management Course 05: Complete Communication Skills Master Class Convenient Online Learning: Our Health & Social Care, Consent Training and Liberty Safeguards courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home. Learning Outcomes: Understand the importance and nuances of Health and Social Care Management. Gain theoretical knowledge on Consent Training in Healthcare. Learn about Deprivation of Liberty Safeguards and its implications. Develop a foundational understanding of the roles and responsibilities of a Care Assistant. Acquire knowledge on End of Life Care practices and Social Care. Understand the roles and considerations of a Maternity Care Assistant. Become familiar with vital Medical Terminology. The "Health & Social Care, Consent Training, and Liberty Safeguards" bundle aims to provide a comprehensive understanding of critical aspects of healthcare. With three QLS-endorsed and five CPD QS accredited courses, the bundle promises to equip you with the theoretical knowledge needed in today's healthcare landscape. CPD 260 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals keen on learning about Health and Social Care Management. Healthcare professionals looking to understand Consent Training and Deprivation of Liberty Safeguards. Those interested in roles related to Care Assistant, Maternity Care Assistant, and Social Care. Anyone keen on enriching their knowledge about Medical Terminology. Career path Health and Social Care Manager: £35,000 - £40,000 Healthcare Consultant: £40,000 - £60,000 Care Coordinator: £20,000 - £25,000 Maternity Care Assistant: £19,000 - £22,000 Medical Secretary (with knowledge of medical terminology): £20,000 - £25,000 End of Life Care Practitioner: £25,000 - £30,000 Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included

Overview Unruly behaviour from a student can have a serious impact on the learning and well-being of others. This kind of attitude and action should be taken seriously and handled properly. Learn how you can manage disobedient pupils with a positive approach with our exclusive Positive Handling in Schools Training course.  Through this informative course you will get an overall understanding of positive handling. The course will show you the strategies to handle volatile situations on the school premises. You will gain an in-depth understanding of the aggressive curve, the SCARF Model and trauma and disability management. In addition, the course will educate you on physical intervention, searching and confiscation. Upon successful completion of this course, you will receive a certificate of achievement. This certificate will help you prove your expertise in this area. So, join now and start working on your skills! Course Preview Learning Outcomes Develop the ability to handle a sensitive situation relating to a young person or children. Enhance your understanding of the aggressive curve Understand the principles of the SCARF Model Build your expertise in physical intervention and restraint Grasp the procedure for searching and confiscation Learn about the government advice and guidance Why Take This Course From John Academy? Affordable, well-structured and high-quality e-learning study materials Meticulously crafted engaging and informative tutorial videos and materials Efficient exam systems for the assessment and instant result Earn UK & internationally recognised accredited qualification Easily access the course content on mobile, tablet, or desktop from anywhere, anytime Excellent career advancement opportunities Get 24/7 student support via email What Skills Will You Learn from This Course? Aggression management Handling unruly attitude Who Should Take This Positive Handling in Schools Training? Whether you're an existing practitioner or an aspiring professional, this course is an ideal training opportunity. It will elevate your expertise and boost your CV with key skills and a recognised qualification attesting to your knowledge. Are There Any Entry Requirements? This Positive Handling in Schools Training is available to all learners of all academic backgrounds. But learners should be aged 16 or over to undertake the qualification. And a good understanding of the English language, numeracy, and ICT will be helpful. Positive Handling in Schools Training Certification After completing and passing the Positive Handling in Schools Training successfully, you will be able to obtain a Recognised Certificate of Achievement. Learners can obtain the certificate in hard copy at £14.99 or PDF format at £11.99. Career Path​ This exclusive Positive Handling in Schools Training will equip you with effective skills and abilities and help you explore career paths such as  Teacher School Administrator Principal Module 01: Introduction to Positive Handling in School Introduction to Positive Handling 00:23:00 Module 02: A Serious Business A Serious Business 00:27:00 Module 03: The Aggression Curve The Aggression Curve 00:21:00 Module 04: Trauma and Disability Management Trauma and Disability Management 00:25:00 Module 05: The SCARF Model The SCARF Model 00:28:00 Module 06: Government Advice and Guidance Government Advice and Guidance 00:23:00 Module 07: Making Decisions: Duty of Care Making Decisions Duty of Care 00:25:00 Module 08: The Law The Law 00:22:00 Module 09: Physical Intervention and Restraint Physical Intervention and Restraint 00:22:00 Module 10: Screening, Searching and Confiscation Screening, Searching and Confiscation 00:23:00 Assignment Assignment - Positive Handling in Schools 00:00:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

HTML5 development training course description This three-day MTA Training course helps you prepare for Microsoft Technology Associate Exam 98-375, and build an understanding of these topics: Manage the Application Life Cycle, Build the User Interface by Using HTML5, Format the User Interface by Using CSS, Code by Using JavaScript. This course leverages the same content as found in the Microsoft Official Academic Course (MOAC) for this exam. What will you learn Manage the Application Life Cycle. Build the User Interface by Using HTML5. Format the User Interface by Using CSS. Code by Using JavaScript. HTML5 development training course details Who will benefit: Anyone working with HTML5. Prerequisites: None. Duration 3 days HTML5 development training course contents Managing the Application Life Cycle Platform fundamentals Packaging and the runtime environment: app package, app container, credentials/permission sets, host process, leverage existing HTML5 skills and content for slate/tablet applications. Manage the state of an application Manage session state, app state and persist state information; understand states of an application; understand the differences between local and session storage. Debug and test a HTML5 touch-enabled application Touch gestures; gestures you test on a device. HTML5 UI: Text, Graphics, and Media HTML5 tags for text content and graphics. When, why and how to use Canvas; when, why and how to use scalable vector graphics (SVG). HTML5 tags to play media. Video and audio tags. HTML5 UI: Organization, Input, and Validation HTML5 tags to organise content and forms Tables, lists, sections; semantic HTML. HTML5 tags for input and validation CSS Essentials: Content Flow, Positioning, styling Core CSS concepts Separate presentation from content (create content with HTML and style content with CSS); manage content flow (inline versus block flow); manage positioning of individual elements( float versus absolute positioning); manage content overflow (scrolling, visible and hidden); basic CSS styling. CSS Essentials: Layouts Arrange UI content by using CSS Use flexible box and grid layouts to establish content alignment, direction and orientation; proportional scaling and use of "free scale" for elements within a flexible box or grid; order and arrange content; concepts for using flex box for simple layouts and grid for complex layouts; grid content properties for rows and columns; use application templates. Managing Text Flow by Using CSS Regions and using regions to flow text content between multiple sections (content source, content container, dynamic flow, flow-into, flow-from, msRegionUpdate, msRegionOverflow, msGetRegionContent); columns and hyphenation and using these CSS settings to optimise the readability of text; use "positioned floats" to create text flow around a floating object Managing the Graphical Interface by Using CSS Graphics effects (rounded edges, shadows, transparency, background gradients, typography and Web Open Font Format); 2-D 3-D transformations (translate, scale, rotate, skew and 3-D perspective transitions and animations); SVG filter effects; Canvas. JavaScript and coding essentials Manage and maintain JavaScript, Create and use functions; jQuery and other third-party libraries. Update the UI by using JavaScript Locate/access elements; listen and respond to events; show and hide elements; update the content of elements. Animations, Graphics, and Accessing Data Code animations with JavaScript animation; manipulate the canvas; work with images, shapes and other graphics. Access data access by using JavaScript Send and receive data; transmit complex objects and parsing; load and save files; App Cache; datatypes; forms; cookies; localStorage JavaScript coding for Touch Interface, Device and Operating System Resources, and More Respond to the touch interface, Gestures, how to capture and respond to gestures, Code additional HTML5 APIs, GeoLocation, Web Workers, WebSocket; File API, Access device and operating system resources, In- memory resources, such as contact lists and calendar; hardware capabilities, such as GPS, accelerometer and camera.

***24 Hour Limited Time Flash Sale*** Dog Grooming (Agility, Leash and Pet Sitting) - Endorsed Training Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Unleash your passion for canines with our unique course bundle: Dog Grooming (Agility, Leash and Pet Sitting) - Endorsed Training! Our bundle boasts three Quality Licence Scheme-endorsed courses to guide you into the thrilling world of dog agility, leash training, and professional pet sitting. Each QLS-endorsed course completion rewards you with a hardcopy certificate, commemorating your hard work and dedication. To ensure you have a well-rounded knowledge base, we've added five additional courses, all CPD QS-accredited. These cover a vast spectrum from dog breeds and basic anatomy, canine communication, wildlife rescue and rehabilitation, to stopping dog barking and dog care and grooming. Together, these courses will give you the comprehensive theoretical understanding you need to excel in the field. Don't let this amazing opportunity slip away! Embrace your love for dogs, enhance your skills, and kick-start a rewarding journey today with our unique course bundle. Key Features of the Dog Grooming (Agility, Leash and Pet Sitting) - Endorsed Training Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our Dog Grooming (Agility, Leash and Pet Sitting) - Endorsed Training bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: Dog Training: Dog Agility QLS Course 02: Dog Leash Training QLS Course 03: Pet Sitting and Dog Walking Diploma 5 CPD QS Accredited Courses: Additionally, our bundle includes 5 relevant CPD QS accredited courses, ensuring that you stay up-to-date with the latest industry standards and practices. Course 01: Introduction to Dog Breeds and Basic Anatomy Course 02: Canine Communication Course 03: Wildlife Rescue and Rehabilitation Course 04: Dog Training - Stop Dog Barking Course 05: Dog Care and Grooming Course In Addition, you'll get Five Career Boosting Courses absolutely FREE with this Bundle. Course 01: Professional CV Writing Course 02: Job Search Skills Course 03: Self-Esteem & Confidence Building Course 04: Professional Diploma in Stress Management Course 05: Complete Communication Skills Master Class Convenient Online Learning: Our Dog Grooming (Agility, Leash and Pet Sitting) - Endorsed Training courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home. Learning Outcomes: Understand various dog breeds, their anatomy and specific care needs. Learn about dog agility and leash training techniques. Gain knowledge on pet sitting and dog walking essentials. Acquire an understanding of canine communication and behaviour. Learn effective methods to control dog barking. Develop skills in wildlife rescue and rehabilitation. Master comprehensive dog grooming and care procedures. Embark on a fascinating journey into the world of dogs with our Dog Grooming (Agility, Leash and Pet Sitting) - Endorsed Training bundle. This unique course compilation provides a comprehensive theoretical understanding of dog grooming, agility training, leash training, and pet sitting. It's supplemented by additional courses on canine anatomy, behaviour, wildlife rescue, and more, accredited by CPD QS. This bundle offers an all-round understanding of dogs, equipping you for a promising career in the field. CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals passionate about dogs and looking to turn this passion into a profession. Dog owners keen on understanding and training their pets better. Aspiring pet sitters and dog walkers. Current professionals in the pet care industry seeking to expand their knowledge. Career path Dog Trainer: Typical earning of £20,000 to £30,000 annually. Pet Sitter: Potential earning between £15,000 and £25,000 per year. Dog Groomer: Can earn around £16,000 to £25,000 per year. Dog Care Specialist: On average, can earn between £20,000 and £30,000 per year. Dog Agility Instructor: Earnings can vary, ranging from £20,000 to £35,000 per year, depending on experience and clientele. Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

QA Level 2 Award In Principles Of Risk Assessment (RQF) Face to Face: One-day course Virtual Classroom: Spread over 3 sessions of 2½ hr duration Don't run risks with the safety of your people - it will cost you a lot more when things start to go wrong... Risk Assessments are vital for Health and Safety, and vital for the whole process Course Contents: Main causes of Work-related Fatalities, Injuries and ill health Moral, Legal and Economic Reasons for Preventing Accidents and ill health at Work Key Terms associated with Risk Assessments in Health and Safety at Work:AccidentNear MissAccident TriangleHazardRiskRisk AssessmentSuitable and SufficientCompetence The Role of Risk Assessments in Accident and ill Health Prevention Legal Requirements for Risk Assessments Importance of Personal hygiene Basic Process for Undertaking a Risk Assessment The Five Steps of a Risk Assessment Benefits of this course: In 2020/21, a whopping 1.7 million people suffered from a work-related illness 441,000 of those sustained an injury 142 People, plus 60 members of the public, lost their lives... The estimated cost of injuries and ill health was £15 billion 28.2 million working days, or 108,045 working years, were lost due to work-related illnesses and injuries It is an employer's duty to protect the health, safety and welfare of their employees and other people who might be affected by their business. This includes providing sufficient information, instruction and training of employees, so they can work in a way that does not put themselves or others at risk Our QA Level 2 Award in Principles of Risk Assessment (RQF) course is ideal for all employees, helping them to create a better understanding of health and safety issues and risk assessments Accredited, Ofqual regulated qualification: QA Level 2 Award in Principles of Risk Assessment (RQF) training course is a nationally recognised, Ofqual regulated qualification accredited by Qualsafe Awards.This means that you can be rest assured that your Principles of Risk Assessment certificate fulfils the legal requirements and is a very good way to make sure you and your employees are trained appropriately.The Ofqual Register number for this course is 603/0857/9

Oracle SQL training course description The Oracle SQL course is designed to give delegates practical experience in writing SQL statements and scripts using Oracle SQL. The basic SELECT statement, the use of SQL functions and the basic table and view handling statements are introduced. What will you learn Create SQL statements to query database tables. Use standard aggregate functions and related SELECT statement clauses. Join Tables. Use basic subqueries and the set operators. Use numeric, character and date functions. Use conversion and other miscellaneous functions. Use SQL parameters. Use complex subqueries. Create and alter tables and views. Insert, update and delete rows in database tables. Manage sequences and synonyms. Oracle SQL training course details Who will benefit: Anyone who needs to use and understand Oracle SQL to query and update data in an Oracle database. Prerequisites: None. Duration 3 days Oracle SQL training course contents Retrieving data with the SELECT statement The SELECT statement, The SELECT and FROM clauses, Conditions and the WHERE clause, Other conditional operators, Logical operators, The ORDER BY clause, Column aliases, Arithmetic expressions, Precedence of operators. Aggregate functions Overview of built In aggregate functions, The GROUP BY clause, The HAVING clause. Joining tables Overview of table joins, Inner joins, Table aliases, Outer joins, Self joins, ANSI standard joins. Basic subqueries and set operators Overview of subqueries, Basic subqueries, Set operators, The union, intersect and ,minus operators. Numeric, character and data functions Function types, Using the table dual to try out functions, Numeric functions, Character functions, String concatenation, Date arithmetic and date functions. Conversion and miscellaneous functions Conversion functions, The NVL and NVL2 functions, The DECODE function, CASE expressions, The COALESCE and NULLIF functions. SQL parameters Command line substitution parameters, The accept command, The define and undefine commands. Complex subqueries Subqueries usage, In-line views, Top-N queries, Subqueries with joins, Multi column subqueries, Correlated subqueries, Subquery rules, Using the ANY, ALL and SOME operators. Managing data Inserting rows, Updating rows, Deleting rows, Verifying updates, Transaction control, Commit and rollback, Savepoints, Commits and constraints, Amending data in SQL developer. Managing tables Creating tables, Specifying constraints, Altering tables, columns and constraints, Dropping tables, columns and constraints, Recovering dropped tables, Copying tables. Managing indexes and views Creating indexes, Dropping indexes, Listing indexes, Creating and using views, Dropping views, Listing views. Managing sequences and synonyms Create a sequence, View sequence details, Create a synonym, List synonyms.