1011 Design courses in Swanscombe

Oracle SQL Advanced training course description The Oracle SQL Advanced course is designed to give delegates practical experience in using some of the more advanced features of Oracle SQL. Additional datatypes and the use of advanced SQL functions and expressions are covered together with enhanced table handling features. What will you learn Retrieve data using correlated subqueries, in-line views and multi-column subqueries. Use the WITH Clause. Inserting and Updating Rows Using Complex Subqueries Create Hierarchical Queries. Use ROLLUP, CUBE and GROUPING SETS group by enhancements. Implement the GROUPING and GROUPING_ID functions. Manage large data sets. Insert data conditionally and unconditionally. Merge Rows in a Table. Create TIMESTAMP and INTERVAL Datatypes. Use TIMESTAMP, TIMEZONE and INTERVAL functions and literals. Use regular expressions and implement related functions. Manage objects with the data dictionary. Manage schema objects. Perform flashback operations. Create and using external tables. Control user access to database objects. Oracle SQL Advanced training course details Who will benefit: Anyone who needs to use the more advanced features of SQL to improve their productivity in querying and updating an Oracle database. Prerequisites: Delegates should have attended the Oracle SQL course or have a similar level of experience. Duration 2 days Oracle SQL Advanced training course contents Retrieve data using subqueries ANY, ALL or SOME operators, Correlated subqueries, In-Line views, The Exists operator, The WITH clause, Multi-Column subqueries, Insert and update using a query, Correlated update and delete. Hierarchical queries Hierarchical data, The START WITH and CONNECT BY clauses, The LEVEL pseudo-column, Sequencing the output, Eliminating nodes and branches. Enhanced grouping features Review of basic grouping concepts, The ROLLUP and CUBE extensions, The GROUPING SETS extension, Using the GROUPING and GROUPING_ID functions. Manage large data sets Multi-table Inserts, Conditional and unconditional Inserts, Merging data into a table, Table and view based merge, A sub query based merge. Flashback technology Flashback query, The AS clause, Flashback table, Flashback drop. Date, time and time zone support Date, Timestamp and Interval datatypes, Handling dates and times, Handling intervals, Date, timestamp and interval functions and literals, Related NLS parameters. Regular expression support Regular expression notation, Character matching, Repetition operators, Sub expression grouping, Regular expression functions. Manage objects with the Data Dictionary The Data Dictionary, Useful Data Dictionary tables, Using the Data Dictionary. Manage schema objects Column operations, Constraint operations, Creating and dropping Indexes, B-Tree indexes, Function based indexes, Descending indexes, Creating and using external tables. Access control System privileges and roles, Create users, Alter user details, Grant and revoke object privileges.

Black CSCS Card NVQ Level 6 Diploma in Construction Contracting Operations Management This qualification is designed for technical learners working in a wide range of job roles, for example estimator, quantity surveyor, buyer or planner. You will have responsibility for other people in their area of occupation. You could be site-based and have responsibility for functions such as dimensional control, surveys, physical testing and work planning. You may work across one or more of the following pathways: Estimating Buying Planning Surveying General Furthermore, this NVQ provides your recognition as a Construction Site Manager and offers you a route to professional memberships such as MCIOB. Induction - As soon as you register you will be given a dedicated assessor. They will arrange an induction and together with your assessor, you will decide on the pathway which best proves your competency. The induction is used to plan out how you will gather the relevant evidence to complete the course. During the course - The assessor will work with you to build a portfolio of evidence that allows you to showcase your knowledge, skills and experience. The assessor will also regularly review and provide you with feedback. This will allow you to keep on track to progress quickly. You will be assessed through various methods such as observations, written questions, evidence generated from the workplace, professional discussion and witness testimonials. On completion - Once all feedback has been agreed, the Internal Quality Assurer will review your portfolio and in agreement with your assessor the certificate will be claimed. To download our PDF for this course then please click here.

The three-day IOSH Managing Safely course is the most popular training of its type in the world. 

Gain expertise in IFRS accounting for the oil and gas sector with our industry-focused training course. Enroll today with EnergyEdge.

Gain comprehensive understanding of caring for individuals with psychosis and schizophrenia. Enhance knowledge and skills to provide effective care and support. Designed for caregivers, family members, support workers, and healthcare professionals.

The Buccal (Oromucosal) Midazolam Competent Reviewer / Assessor Training is designed to provide participants with comprehensive knowledge and skills necessary to assess and review the administration of buccal (oromucosal) midazolam for the management of acute prolonged and repetitive seizures.

The "Emergency Response for Care Homes" course is designed to provide care home staff with essential knowledge and skills to effectively respond to a wide range of emergency situations. This course aims to reinforce and update the participants' understanding of emergency protocols, procedures, and best practices, ensuring a safe and coordinated response in times of crisis.

Disciplined Agile Value Stream Consultant (DAVSC) Training Workshop The Disciplined Agile Value Stream Consultant workshop teaches you how to use value stream management to create a tailored approach for any organization to accelerate delivery of value to their customers. It provides a combination of Lean, Flow, Theory of Constraints and Organizational Development theories and practices. The workshop integrates with the Disciplined Agile tool kit to provide those practices that will be most effective for where it is applied, whether it be a new Agile transition or continuing a stagnated SAFe® or Spotify one. What You Will Learn After the completion of this course, you will be able to: Learn to determine the best place for an organization to start - portfolio management, product management or development area Be equipped to tailor an organization's improvement plan based on their unique needs, while also attending to the culture of the organization to evolve at their proper pace Be able to train an organization to continue to improve on their own Know how to accelerate value delivery at scale Be prepared to take the Disciplined Agile Value Stream Consultant (DAVSC) exam and earn valuable, credible certification. Your exam fee is included in tuition. The course is comprised of an introduction and 14 lessons and supplemental materials provided electronically: Introduction: The Disciplined Agile Mindset Lesson 1: Value Stream Consultant: Role and Work Lesson 2: The Idealized Value Stream Lesson 3: Removing Delays in the Workflow Lesson 4: The Minimum Business Increment Lesson 5: The Discovery Workflow and the Development Intake Process Lesson 6: Value Flow Planning and Coordination Lesson 7: Working with a Common Cadence and Synchronization Lesson 8: End of Increment Activities and Reducing, Not Accommodating Dependencies Lesson 9: Factors for Effective Value Streams Lesson 10: Value Creation Structure Lesson 11: Agile Budgeting and Lean Funding Lesson 12: Creating Visibility Across the Organization Lesson 13: Key Roles Lesson 14: The Disciplined Agile Playbook

Agile Sprint Planning The goal of the course is to provide you and your team with the ability to develop effective and realistic Sprint plans. Without effective Sprint Plans, iterations are set up for failure. But Sprint Planning cannot be improved on its own, in isolation. The Scrum processes are highly intertwined and influence each other. The surrounding artifacts, events, and roles must be examined closely, and enhanced, in order to improve Sprint Planning. This course will remind you of the theory to reinforce the principles, but will concentrate on next-level skills, so that you and the team are able to create realistic and usable Sprint Plans. This course is not introductory. You are already aware of the Scrum framework and have been implementing Scrum on your projects. Now is the time to improve efficiency and effectiveness, to facilitate successful Agile projects. What you will Learn You'll learn how to: Identify and correlate the key symptoms and root causes of ineffective sprint plans Improve key Product Backlog elements Evaluate Agile roles in sprint planning Appraise key product practices Enhance project transparency The Product Backlog User stories Acceptance Criteria Backlog Refinement Supporting Roles Product Owner (the Backlog) Development Team Stakeholders and SMEs Supporting Product Practices Roadmaps and release plans and story maps Definition of Done Technical Debt Transparency Daily Scrums Information radiators Retrospectives Sprint Planning Capacity and Velocity Sprint Planning Meetings The Sprint Backlog Summary What did we learn, and how can we implement this in our work environments?

The VTCT (ITEC) Level 4 Award in Dermaplaning is an advanced and exclusive qualification specifically designed for those who wish to expand their expertise in advanced aesthetic procedures. The Level 4 Dermaplaning course is also ideal for medical professionals seeking to enhance their skill set by incorporating advanced aesthetic treatments into their repertoire. This advanced qualification is uniquely designed for those who want to upgrade their professional skin capabilities. With a focus on national standards, you'll learn the safety concerns surrounding dermaplaning treatments and refresh your knowledge of relevant anatomy and physiology for level 4 aesthetic treatments. Through the Level 4 Dermaplaning course, you'll perfect your customer service and client communication skills, increasing your employability prospects. With both practical and theoretical learning, you'll gain the knowledge and experience necessary to confidently provide cosmetic skin treatments. From preparing clients safely and ethically to choosing the correct equipment and monitoring client reactions, you'll be fully equipped to deliver professional dermaplaning treatments upon completion of the course. Enrol now in the VTCT (ITEC) Level Award 4 in Dermaplaning and upgrade your career!