2974 Design courses in Leeds delivered Live Online

Duration 3 Days 18 CPD hours This course is intended for This course is geared for anyone needing to interface with an Oracle database such as end users, business analysts, application developers and database administrators / DBAs. Overview Working within in a hands-on learning environment, guided by our expert team, attendees will develop a practical approach to Oracle Database Technology. Throughout the course participants will explore: Using PL/SQL programming language for database applications and development incorporating PL/SQL modules within the application architecture from the initial design and planning phase The essentials of building executable PL/SQL program units Each of the major segments of a working program and how these interact with each other during program execution Important error or exception handling capabilities of the language. How database-resident program units can be used as part of the overall database application architecture Applying these new skills to the development of PL/SQL packages. Advanced database programming capabilities and benefits How database triggers can be used as part of an advanced database application design Oracle 19c PL/SQL Fundamentals is a three-day, hands-on course that introduces Oracle database programming using the PL/SQL programming language. Throughout the course students will explore the core syntax, structure and features of the language. This course will also lay the foundation for the entire Oracle PL/SQL programming series, allowing one to progress from introductory topics to advanced application design and programming and finally onto writing complex high-performance applications. The course also explores applying the newly learned skills to the development of database applications. Participants will learn how to use database-resident stored program units such as procedures, functions, packages and database triggers. Students will also learn about the latest features in Oracle 19c. Selection & Setup of the Database Interface Considering Available Tools Selecting the Appropriate Tool Oracle Net Database Connections Oracle PAAS Database Connections Setup SQL Developer Setup SQL *Plus Setup JDeveloper About BIND and Substitution Variables Using SQL Developer Using SQL *Plus Choosing a Database Programming Language What is Database Programming PL/SQL Programming PL/SQL Performance Advantages Integration with Other Languages PL/SQL Language Essentials PL/SQL Program Structure Language Syntax Rules Embedding SQL Writing Readable Code Generating Readable Code Generating Database Output SQL * Plus Input of Program Block DECLARE Section About the Declare Section Declare Primitive Types Declaration Options Not Null Constant Data Dictionary Integration % Type Declare Simple User-Defined Types Type ? Table Type ? Record Extended User Defined Types BEGIN Section About the Begin Section Manipulating Program Data Logic Control & Braching GOTO LOOP IF-THEN-ELSE CASE EXCEPTION Section About the Exception Section Isolating the Specific Exception Pragma Exception_INIT SQLCODE &SQLERRM Example SQL%ROWCOUNT & Select ? Into Beyond the Basics : Explicit Cursors About Explicit Cursors Extend Cursor Techniques For Update of Clause Where Current of Clause Using for ? Loop Cursors Introduction Database Resident Programming Units About Database ? Resident Programs Physical Storage & Execution Types of Stored Program Units Stored Program Unit Advantages Modular Design Principles Creating Stored Procedures and Functions Stored Procedures & Functions Create Procedure / Create Function Creating Procedures & Functions Raise_Salary() Procedure Salary_Valid() function The Parameter Specification Default Clause System & Object Privileges Using the Development Tools Executing Stored Procedures and Functions Calling Procedures & Functions Unit Testing with Execute Anonymous Block Unit Testing Specifying a Parameter Notation SQL Worksheet Unit Testing Calling Functions from SQL Maintaining Stored Programming Units Recompiling Programs Mass Recompilation Using UTL_RECOMP() Dropping Procedures & Functions Drop Procedures & Functions Drop Procedure / Function Data Dictionary Metadata Using USER_OBJECTS Using USER_SOURCE Using USER_ERRORS Using USER_OBJECT_SIZE Using USER_DEPENDENCIES Managing Dependencies Dependency Internals Tracking Dependencies The Dependency Tracking Utility SQL Developer Dependency Info Dependency Strategy Checklists Creating & Maintaining About Packages Creating Packages Maintaining Packages Performance Considerations Advanced Package Capabilities Definer & Invoker Rights White Lists & Accessible By Persistent Global Objects Defining Initilization Logic Object Orientation Support Advanced Cursor Techniques Using Cursor Variables Using SYS_REFCURSOR Using Cursor Expressions Using System Supplied Packages DBMS_OUTPUT() UTL_FILE() FOPEN() Example Database Trigger Concepts About Database Triggers DML Event Trigger Sub-Types Database Trigger Scenario Trigger Exhaustion Mechanisms Trigger within SQL Worksheet Creating Database Triggers Statement Level Triggers Using Raise Application_Error() Row-Level Triggers Examples of Triggers Employee_Salary_Check Example Employee_Journal Example Budget_Event Example Instead of Triggers Triggers within and Application Maintaining Database Triggers Call Syntax Trigger Maintenance Tasks Show Errors Trigger Drop Trigger Alter Trigger Multiple Triggers for a Table Handling Mutating Table Issues Implementing System Event Triggers What are System Event Triggers Defining the Scope Available System Events System Event Attributes

Create a simple needle felt picture on a Spring theme. A snowdrop, tulip or daffodil flower, an Easter egg  or a duckling design. Images are created on a 10cm embroidery hoop.

Learn the art of tambour beading in this class

City & Guilds Level 3 Certificate in Assessing Vocational Achievement This qualification is for anyone working in or looking to enter an assessment role. It is designed for use in England, Wales and Northern Ireland – alternative arrangements exist in Scotland. Learn about the Cavity Training Dental Nurse Assessor Course The units and qualification will provide people who carry out assessment in their organisation with the opportunity to develop and improve their practice as well as achieving a professional qualification for the role. They are available to anyone working in: accredited learning; non accredited learning (where people may assess performance but do not assess for a qualification) and the NQF. Achievers will understand the principles of assessment and have the knowledge to develop and improve systems at their centre. You will gain access to our unique E library of text books. We also have special discounted rates for hard copy text books for our students. Frequently Asked Questions How long is the course? The course duration is 4 to 6 months. When are the classes held? You will attend a live webinar class every Thursday for 16 weeks. Is there an exam at the end? There is no exam at the end, you need to successfully complete 8 assessments and a final professional discussion with your tutor. What if I don’t have student nurses in my practice? We may be able to support you by providing you with learners to assess. Please get in touch. What qualifications do I need to start the course? Preferable English and Maths level 4 and above, you must also be GDC registered. What opportunities for progression is there? This qualification allows candidates to further progress onto various post registration qualifications or career opportunities, such as: – Dental Nurse Teaching – Internal Quality Assurer (IQA) Course Dates 11th April 2024 9:00am - 4:00pm 29th August 2024 9:00am - 4:00pm 2nd January 2025 9:00am - 4:00pm 8th May 2025 9:00am - 4:00pm Costs £800.00 per person (inc. VAT) Other payment options Deposit - £267.00 with 2 further payments Please choose from one of the course start dates above. Each course includes 16 weeks of lessons and up to two months to complete a portfolio and professional discussion.

Rhino Basic to Intermediate Training Course

This session is a quick fire session into designing your vision and aligning your life. 90 minutes dedicated to your own development to ignite your reticular activator into setting yourself up for success in 2024.

Coaching, Workplace coaching, Floor walking coaching, Organisational coaching,

Practical MySQL Course Intermediate, to leave you fully conversant with queries, DML and DDL statements. Hands-on, Practical MySQL Course Intermediate. PCWorkshops MySQL Course Intermediate Certificate. Max 4 people per course, we keep it personalised.

The 3-day course is designed to deliver a complete knowledge of the PRINCE2® 7th Edition methodology to the participants. The course prepares you for the exam to obtain the international PRINCE2® 7th Edition Foundation certificate issued by the accrediting organization. PRINCE2® 7th Edition Foundation course offered by Advised Skills Ltd is accredited by PeopleCert, on behalf of AXELOS, based upon Partner's Agreement and complies with the accreditation requirements.

Duration 2 Days 12 CPD hours This course is intended for The primary audience for this course are Application Consultants, Business Analysts, and Business Process Owner/Team Lead/Power Users. Overview Create Web Intelligence documents for your reporting needsRetrieve data by building queries using SAP BusinessObjects universesUse Web Intelligence to enhance documents for easier analysisOrganize, manage and distribute documents using the BI launch pad This course is designed to give students the comprehensive skills and in-depth knowledge needed to access, analyze and share data using SAP BusinessObjects BI launch pad and SAP BusinessObjects Web Intelligence. Web Intelligence Describing Web Intelligence Concepts Explaining Web Intelligence Core Functions Describing Web Intelligence and the SAP BusinessObjects Business Intelligence Platform Web Intelligence Documents with Queries Creating Queries Creating a Document Modifying a Document?s Query Modify the Query Panel Data Return Restrictions from Queries Restricting Data with Query Filters Modifying a Query with a Predefined Query Filter Applying a Single-Value Query Filter Using Wildcards in Query Filters Using Prompts to Restrict Data Using Complex Filters Web Intelligence Document Design Modifying Web Intelligence Documents Displaying Data in Tables Using Tables Presenting Data in Free-standing Cells Presenting Data in Charts Presentation of Data in Documents Using Breaks and Calculations Using Sorts and Hiding Data Formatting Breaks and Cross Tables Filtering Report Data Ranking Data Highlighting Information with Formatting Rules Organizing a Report into Sections Web Intelligence Document Formatting Formatting Documents Formatting Charts Data Calculation Applying Formulas and Variables Using Formulas and Variables Drilling Functionality Analyzing the Data Cube Drilling in an Web Intelligence Document Web Intelligence Documentation Management Publishing Documents to the Corporate Repository Logging In to the BI Launch Pad Managing Documents in BI Launch Pad Viewing a Web Intelligence Document in the BI Launch Pad Sharing Web Intelligence Documents Setting BI Launch Pad Preferences Logging Off From the BI Launch Pad