3139 Development courses in Coventry 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

Learning Outcomes for 'Minor Illness Update' Day for Experienced Registered Healthcare Professionals   By catering to experienced registered healthcare professionals already practicing in the area of minor illness, this 'Minor Illness Update' Day equips participants to elevate their existing skills, apply the latest insights, and enhance patient care through informed, compassionate, and effective practices. Agenda: 09.15Coffee and registration 09.30Introduction and course objectives 09.40Perspective on changes and safe practice within primary care 10.00Respiratory Tract infections 10.45Coffee 11.00Ears, Nose and Throat 13.00Lunch 14.00Abdominal pain and UTIs 14.30Head, Neck and Back Pain 14.30Eye infections 15.00Skin Rashes 15.30Injuries 15.45Evaluations and Close Learning Outcomes: Upon completion of the 'Minor Illness Update' Day, aimed at registered and experienced healthcare professionals already practicing in the field of minor illness, participants will be able to: 1. Stay Current in Minor Illness Management: - Demonstrate an updated and well-informed understanding of the latest developments in minor illness management within the primary care context. - Stay informed about current prescribing guidelines and adjustments in the field of minor illness treatment. 2. Critical Analysis of Consultation Dynamics: - Exhibit a critical comprehension of the significant dynamics at play during patient consultations related to minor illness cases. - Apply analytical skills to assess the complexities of patient presentations and prioritize appropriate diagnostic and treatment strategies. 3. Effective Problem-Solving in Practice: - Discuss and analyse practical challenges that arise during minor illness consultations, and propose effective solutions tailored to individual patient needs. - Employ problem-solving abilities to navigate diverse patient scenarios, enhancing overall patient care. 4. Integration of Attitudes and Values: - Develop an understanding of how personal attitudes and values may influence patient interactions and treatment decisions. - Apply self-awareness to ensure professional conduct aligns with ethical and patient-centred principles. 5. Awareness of Professional Growth: - Recognize the ongoing nature of professional development and the importance of staying updated in the rapidly evolving field of minor illness management. - Acknowledge the responsibility for continuous growth, embracing opportunities for learning and improvement. 6. CPD Contribution and Revalidation: - Identify the applicability of these study days as part of Continuing Professional Development (CPD) requirements for experienced registered healthcare professionals already practicing in minor illness. - Understand how participation contributes to professional revalidation, ensuring compliance with professional standards. 7. Virtual Engagement for Learning: - Leverage virtual learning environments effectively to enhance knowledge and skills related to minor illness management. - Demonstrate adaptability in engaging with virtual platforms for professional development and learning. 8. Holistic Patient Care Approach: - Integrate the acquired knowledge to provide holistic care to patients presenting with minor illness, recognizing the interconnectedness of physical and psychosocial aspects. - Foster a patient-centred approach by considering patients' needs, preferences, and well-being.  

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.

Overview With the change in the density of enterprise risk, new risks have emerged, and managing it has become everyone's responsibility. The new Enterprise Risk Management course offers you the exclusive opportunity to learn the concepts and principles of the newly updated ERM framework and to integrate the framework into your organisation's strategy. The course is designed with all the modules to provide you with the knowledge necessary to understand and apply Enterprise Risk Management - Integrating with Strategy and Performance. The ERM framework assists management and boards of directors with their respective duties for managing risk.

Overview This course will help you manage project risk effectively by identifying, analyzing, and communicating inevitable changes to project scope and objectives. You will understand and practice the elements needed to measure and report on project scope, schedule, and cost performance. You will be equipped with the tools to manage change in the least disruptive way possible for your team and other project stakeholders.

Overview Competitor Analysis is a key area every professional does to understand their business presence. It gives your insight into your business standings and also knowledge of your competitors and their strength and weakness. Analysing your competitors helps you understand the market and your power to deal with the competitors.  It is an essential marketing and strategic tool. It provides both an offensive and defensive strategic tool to analyse opportunities and threats.