1173 Design courses in Potters Bar

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.

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

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.

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

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

Intuitive anatomy - theta healing course in London - in person/online

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.

We would like to welcome you to a creative Saturday afternoon with our team and hand build up to three pieces in our creative studio in Angel. No prior knowledge or skills are required.  What is included:  Instructions and guidance by our team members Sculpting kit and tools A variety of flowers and greenery to choose from for your creative imprints Glass of bubbly or floral lemonade and light refreshments Fun and relaxing start to your weekend It is a small class so we can pay attention and guide you all the way through the class. We will fire your pieces and they will be ready for collection in about three weeks after the class.