3129 Development courses in Edinburgh delivered Live Online

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

Mental Health and Wellbeing Training Courses Building resilience CPD Accredited, Interactive Workshops Enquire about this course 2-5 hour workshops Suitable for anyone who'd like to improve their mental wellbeing and resilience Giving them the chance to cope with life's challenges

This one day online course will assist candidates in preparing for the forthcoming initial Senior Caseworker exam.

Course Information Join us for a comprehensive refresher focusing on crucial Good Laboratory Practice (GLP) requirements, including an emphasis on data integrity, recent developments, and emerging trends gleaned from MHRA inspections. The programme dives into specific domains such as risk assessment, OECD guidance on sponsor influence, and the advisory from OECD on QA. Additionally, delegates can benefit from a dedicated GLP clinic, facilitating discussions on understanding and upholding GLP compliance. Is this course for you? This course is tailored for study directors, principal investigators, test facility management, and QA professionals seeking to refresh their knowledge and responsibilities within the GLP framework. Tutors Tutors will be comprised of (click the photos for biographies): Vanessa Grant -, - Tim Stiles Consultant, Qualogy Ltd Programme Please note timings may be subject to alteration. Day 1 09:00 Registration, Welcome and Introduction 09:20 Development of Good Laboratory Practice A reminder of the history of GLP, its current scope and application, with a synopsis of current UK, European and international standards. 09:50 Roles and Responsibilities of Study Director, Test Facility Management, Principal Investigator, Test Site Management, Study Staff and QA A reminder of the roles and responsibilities with regard to the GLP management and oversight of the Test Facility and the management and control of the study, as defined by GLP. 10:30 Break 10:45 Workshop 1 Workshop 1 Roles and responsibilities 11:15 Influence of Sponsors The published OECD Position Paper No. 21 regarding Possible Influence of Sponsors on conclusions of GLP Studies is reviewed and discussed. 11:45 Data Integrity The fundamentals of data integrity according to the OECD Guidance No. 22 on Data Integrity is discussed along with the responsibilities of Study Director, Test Facility Management, and study staff in ensuring the integrity of the GLP study data. 12:30 Lunch 13:15 Quality Assurance and GLP OECD Advisory No. 23 (Revision of OECD No.4)- A walk through of the changes to the OECD Guidance on the role and activities of Quality Assurance 13:45 Quality Improvement Tools and GLP The tools that might be considered for GLP and their role and operation when used in Test Facilities- OECD Position Paper No.24 published July 2022 14:15 Workshop 2 Workshop 2 Change control 14:30 Risk Assessment How should we assess risk and how can we use the process to assist in evaluation audit findings? 15:00 Break 15:15 Current hot topics in GLP Explore the current issues in Industry and trends /types of Regulatory inspection findings 15:50 GLP Clinic An opportunity to discuss any other issues regarding understanding and maintaining GLP Compliance. 16:30 Close of Course Extra Information Course Material This course will be run completely online. You will receive an email with a link to our online system, which will house your licensed course materials and access to the remote event. Please note this course will run in UK timezone. The advantages of this include: Ability for delegates to keep material on a mobile device Ability to review material at any time pre and post course Environmental benefits – less paper being used per course Access to an online course group to enhance networking. You will need a stable internet connection, a microphone and a webcam. CPD Points 7 Points   Development Level Learn

Learners will develop knowledge from the FD&FA foundation courses (C01 modules 1 and 2) and/or industry experience with specific regard to more complex system design considerations.

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.