3131 Development courses in London delivered Live Online

This half day online course will assist candidates in preparing for the forthcoming initial Casework Assistant exam.

Duration 5 Days 30 CPD hours This course is intended for This course is intended for novice database developers, database administrators, Business Intelligence developers, report creators, and application developers who have an understanding of relational database concepts and have basic Windows navigation skills. Overview Create single table SELECT queries Create multiple table SELECT queries Filter and sort data Insert, update, and delete data Query data using built-in functions Create queries that aggregate data Create subqueries Create queries that use table expressions Use UNION, INTERSECT, and EXCEPT on multiple sets of data Implement window functions in queries Use PIVOT and GROUPING SETS in queries Use stored procedures in queries Add error handling to queries Use transactions in queries This five-day instructor-led course is intended for IT professionals who wish to use the Transact-SQL language to query and configure Microsoft SQL Server. Students are typically database developers and database administrators, but might also be Business Intelligence developers, report creators, or application developers. In this course, students learn how to query single tables, join data from multiple tables, filter and sort data, modify data, use procedures and functions, and implement error handling. Prerequisites Basic understanding of relational databases. Basic Windows knowledge. Module 1: Introduction to Transact-SQL What is Transact-SQL The SELECT statement The WHERE clause Sorting results Calculations CASE expressions Module 2: Joining tables with Transact-SQL The JOIN clause Inner joins Outer joins Self joins and cross joins Module 3: Filtering and sorting results Implement the ORDER BY clause Filter data with the WHERE clause Limit the number of rows returned by a query Implement NULL logic Module 4: SQL Server data types Understand data types Implement string data types Implement temporal data types Module 5: Inserting, updating and deleting data Insert new records Update existing records Delete data Module 6: Using SQL Server functions with Transact-SQL Understand function types in SQL Server Convert data using functions Implement logical functions Work with NULL data using functions Module 7: Aggregating data with Transact-SQL Implement aggregation in SQL Server Group records in SQL Server Filter aggregated data Module 8: Implement subqueries with Transact-SQL Implement scalar and multi-valued sub-queries Implement correlated subqueries Implement existence checks with subqueries Module 9: Create queries that use table expressions Create views Create table-valued functions Implement derived tables Implement common table expressions Module 10: Use UNION, INTERSECT, EXCEPT and APPLY on multiple sets of data Write queries with the UNION operator Write queries with the INTERSECT and EXCEPT operators Write queries with the APPLY operator Module 11: Implement window functions in queries Understand window functions Impement window functions Module 12: Use PIVOT and grouping sets in queries Implement PIVOT in queries Implement grouping sets in queries Module 13: Use stored procedures in queries Query data with stored procedures Interact with stored procedures using input and output parameters Write simple stored procedures Pass dynamic SQL to SQL Server Module 14: Implement programming features in Transact-SQL Understand T-SQL programming elements Implement loops and conditions in T-SQL queries Module 15: Add error handling to queries Understand SQL Server error handling Implemet structured exception handling Module 16: Use transactions in queries Understand database transactions Implement transactions in T-SQL

CPD Accredited, Interactive Short Course 2 or 3.5 hour hr sessions What are the autistic spectrum disorder, autism and asperger's syndrome? How can you best understand, and thus help, those affected? Course Contents of the shorter course: What is ASD Autism and Asperger's Syndrome Understanding those on the Spectrum How to approach and help those on the Autistic Spectrum Great for teachers and TAs in schools, and for those working in care with older people with ASD Benefits of this Short Course: About 1% of the population is thought to be on the Autistic Spectrum That is several children per nursery and primary school and a significant amount of young people in secondary schools Many with Asperger's Syndrome will also go to university The way they experience the world is very different to 'neuro-typical' people Understanding their condition helps to support them and give them the best chance

Project Management for Non-Project Managers: Virtual In-House Training Individuals who are involved in projects (commissioning, supporting, sponsoring, etc.) may often be unfamiliar with project management. A basic understanding of project management is essential for non-project managers, who are critical stakeholders contributing to project success. This awareness course uses A Guide to the Project Management Body of Knowledge (PMBOK® Guide) and other sources to introduce you to project management vocabulary, concepts, and techniques. It also provides insights into the realities of being a project manager, and opportunities to explore how you can positively impact projects in your own role. What You Will Learn At the end of this program, you will be able to: Identify the benefits of project management Use standard project management terminology Describe characteristics of successful projects, project managers, and high-performing teams Explain various project stakeholder roles, their responsibilities, and the fundamental project management processes Recognize how agile / adaptive practices are useful for certain project life cycles Create a personal action plan for how to support real-world projects within a non-PM role Getting Started Introductions Course structure Course goals and objectives Foundation Concepts Project management overview Strategic value of project management Defining project success Project life-cycle models and governance Project roles and responsibilities Project Initiating and Planning Initiating the project Defining project requirements and scope Developing the project schedule and budget Project Risk Management, Executing, Monitoring, and Closing Understanding, evaluating, and adjusting for risk Honoring the baseline and executing the project Monitoring and controlling the project Closing the project Project Interpersonal Processes Project communication Project team development Conflict management

Prerequisite: PECS Level 1 Training This two-day training focuses on creating lessons and activities to promote communication throughout the day. Beginning with a review of the Pyramid Approach to Education as it relates to PECS, we guide you in refining your PECS implementation and discuss current challenges you have experienced within the six phases. As you acquire teaching strategies on expanding vocabulary and syntax combined with new ideas for materials, we will discuss how to increase communication opportunities for your learner. Throughout the training, you will be provided with presenter demonstrations, video examples and opportunities to role-play. With innovative ideas, increased confidence and renewed enthusiasm, you will leave the PECS Level 2 Training ready to move PECS users to more sophisticated levels of communication. WATCH VIDEO WHAT YOU WILL LEARN Identify the six phases of the PECS protocol Analyse common difficulties with PECS implementation Generate solutions to common challenges with implementing PECS Provide communication opportunities across the day in all activities Implement specific strategies for teaching advanced language concepts WORKSHOP DETAILS Agenda: 9:00 AM - 4:30 PM Registration Time: 8:30 AM - 9:00 AM CPD Points: Continued Professional Development Points CEUs: 7.5 BACB CEUs / 7.5 IBAO CEUs. Satisfactory completion of this course requires participants to be present for the duration of the course and to participate in all student responding activities (e.g. questions, role play, quizzes, and surveys). Tuition Includes: detailed handout with space for note taking, delegate practise bag and certificate of attendance. *Participants are encouraged to bring the PECS Training Manual (Frost and Bondy, 2002) that they received at their PECS Level 1 Training, as this workshop may reference some pages in the manual. This course is certified by the CPD certification service (the leading independent CPD accreditation institution) as conforming to continuing professional development principles. All delegates will receive a certificate of attendance detailing eligible CPD hours which can be used as verifiable documentary evidence when submitting CPD recording forms. Pyramid Educational Consultants is an approved BACB ACE Provider for Learning (Type 2) Continuing Education Credits. The BACB does not warrant, endorse, sponsor, approve, or partner with the event, organisation, or instructor. Pyramid Educational Consultants is an approved IBAO Provider for Continuing Education Credits.

Overview This course will define the scope of work, project goal, project plan, project phase, sequencing and phase relationship Project Planning & Budgeting will provide participants with a demonstrated set of methods, processes, tools and techniques to cultivate a systematic and dynamic project plan to certify progressive monitoring control and reporting of the project cost.

Overview Tendering is a process on which a lot of money relies. When a tender is issued and published, winning that contract is completely depended on how deeply you understand the tender, the key areas of the tender along with how much in-depth knowledge you have about the potential client's need and how you can provide your service to those needs.

Overview EPC (Engineering, Procurement and Construction) is a very challenging area and is very competitive as well. Companies dealing with large and complex EPC projects are more often get involved in mitigation by complex contract laws and management that lead to huge financial losses. It is very important to Know-how EPC contract laws, and their commercial and financial aspects to gain skills and the ability to deal with complex contract laws and reduces the risk. 

Overview The course focuses on topics such as the fundamental concepts of auditing and quality management, principles of internal and external audit, auditing processes and tools, principles and practice of root cause analysis, communication and people skills, and other related topics. Students who successfully complete this course will gain the essential knowledge and skills necessary to become successful auditors and work with confidence to improve the processes in their organizations.

Overview Strategic Financial Management and Effective Budget Execution also called Strategic Financial Management provide the important elements for attaining a comprehensive budget preparation and effective execution system. This course focuses on the risks and challenges likely to obstruct the operation of management and financial accounting processes and evaluates the techniques and tools needed to tackle them. It will highlight what constitutes strategic financial management and effective budget execution within the context of achieving their strategic and operational objectives.