• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

43119 Courses delivered Online

Teaching Good Decision Making Skills

4.3(43)

By John Academy

Description: Decision making is one of the important skills your children need to develop as it helps them view thing in a better broader light and also makes them more thinking individuals as the experience becomes easier each time. Decision making is critical in light of the fact that the choices your children make manage the way that their lives take. Showing your kids to settle on their own choices has a few advantages. This course will guide you to help your child look at problems that need decision making from various different angles unless until the child is satisfied and is able to make the right decision on its own. Who is the course for? Parents who want to encourage their children to make their own yet right decisions Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment:  At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Good Decision Making Good Decision Basics 00:30:00 Make Your Child Aware Of What Decision Making Is 00:15:00 Teach Your Child How To Come Up With Possibilities 00:15:00 Teach Your Child To Weigh Consequences 00:15:00 Supply The Skills To Weigh Possibilities and Consequences Against Family Values 00:15:00 Appreciate When Your Child Makes A Good Decision 00:15:00 The Denouement Of Not Teaching Your Child Good Decision Making 00:15:00 Wrapping Up 00:15:00 Problem Solving & Decision Making Definitions of Problem Solving & Decision Making 00:30:00 Making Decisions 00:30:00 The Problem Solving Model 00:15:00 The Problem Solving Toolkit 00:30:00 Aspirinia 00:15:00 Swotting Up 00:15:00 Making Good Group Decisions 00:30:00 Analyzing and Selecting Solutions 00:15:00 Planning and Organizing 00:15:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Teaching Good Decision Making Skills
Delivered Online On Demand5 hours 30 minutes
£18

Negotiation Skills Training

By Compete High

Overview   With the ever-increasing demand for Negotiation Skills in personal & professional settings, this online training aims at educating, nurturing, and upskilling individuals to stay ahead of the curve - whatever their level of expertise in Negotiation Skills may be.   Learning about Negotiation Skills or keeping up to date on it can be confusing at times, and maybe even daunting! But that's not the case with this course from Compete High. We understand the different requirements coming with a wide variety of demographics looking to get skilled in Negotiation Skills. That's why we've developed this online training in a way that caters to learners with different goals in mind. The course materials are prepared with consultation from the experts of this field and all the information on Negotiation Skills is kept up to date on a regular basis so that learners don't get left behind on the current trends/updates.   The self-paced online learning methodology by Compete High in this Negotiation Skills course helps you learn whenever or however you wish, keeping in mind the busy schedule or possible inconveniences that come with physical classes. The easy-to-grasp, bite-sized lessons are proven to be most effective in memorising and learning the lessons by heart. On top of that, you have the opportunity to receive a certificate after successfully completing the course!   Instead of searching for hours, enrol right away on this Negotiation Skills course from Compete High and accelerate your career in the right path with expert-outlined lessons and a guarantee of success in the long run.   Who is this course for?   While we refrain from discouraging anyone wanting to do this Negotiation Skills course or impose any sort of restrictions on doing this online training, people meeting any of the following criteria will benefit the most from it: Anyone looking for the basics of Negotiation Skills, Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in Negotiation Skills, Anyone looking for a certificate of completion on doing an online training on this topic, Students of Negotiation Skills, or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity   Career Path   This Negotiation Skills course smoothens the way up your career ladder with all the relevant information, skills, and online certificate of achievements. After successfully completing the course, you can expect to move one significant step closer to achieving your professional goals - whether it's securing that job you desire, getting the promotion you deserve, or setting up that business of your dreams. Course Curriculum Module 1 - Introduction to Negotiation Skills Introduction to Negotiation Skills 00:00 Module 2 - The Successful Negotiator The Successful Negotiator 00:00 Module 3 - Types of Negotiation Types of Negotiation 00:00 Module 4 - Important Negotiation Skills Important Negotiation Skills 00:00 Module 5 - Preparing for Negotiation Preparing for Negotiation 00:00 Module 6 - Communication in Negotiation Communication in Negotiation 00:00 Module 7 - Salary Negotiation Salary Negotiation 00:00 Module 8 - Negotiate at Every Stage of Your Career Negotiate at Every Stage of Your Career 00:00

Negotiation Skills Training
Delivered Online On Demand8 hours
£25

Technical Report Writing and Presentation Skills for Oil & Gas Engineers and Technical Professionals

By EnergyEdge - Training for a Sustainable Energy Future

Develop your technical report writing and presentation skills with EnergyEdge's course designed for oil & gas professionals. Sign up now!

Technical Report Writing and Presentation Skills for Oil & Gas Engineers and Technical Professionals
Delivered in Internationally or OnlineFlexible Dates
£1,399 to £1,499

Enhance Skills in Spoken English

5.0(10)

By GBA Corporate

Overview Improve your knowledge of the English language and pronunciation and practice your speaking and vocabulary with our video lessons and with live face to face with the trainer online and In-Class. Choose your English course level from our wide range of english courses and start learning online today. Take any of our high quality online English lessons with the highlu experienced trainer and improve your English speaking skills along with your grammar, reading and writing. Start by taking our English lessons to help you find your level and increase your communication skills also find lessons and resources to improve your English skills. Throuh this course you will get more practice to improve your general English with our extended listening and reading materials and online trainer led training. Improve your the grammar and vocabulary and support your learning.

Enhance Skills in Spoken English
Delivered in Internationally or OnlineFlexible Dates
FREE to £382

Functional Skills Maths And English

4.3(43)

By John Academy

Embark on a transformative journey with our Functional Skills Maths And English! Explore the world of numbers, conquer algebraic challenges, and refine your language prowess. From mastering financial literacy to crafting compelling compositions, this course is your gateway to a world of practical skills. Unleash your potential, navigate real-world scenarios, and emerge confident in both mathematics and English proficiency. Elevate your learning experience—join us on this dynamic quest for knowledge and empowerment!

Functional Skills Maths And English
Delivered Online On Demand
£24.99

Essential Study Skills: Strategies for Ultimate Success

By iStudy UK

Do you want to Master essential study & learning strategies for ultimate exam success? Join this Essential Study Skills: Strategies for Ultimate Success to get an expert on it! Through the course you will learn how and why you learn, multiple study skills methods, how to read, take notes and study from books, prioritisation, visual and auditory methods, ensuring you don't miss anything out, how to preempt exam questions as well as a general study approach and a list of apps and web-based systems. This will all combine to produce a system which enables you to learn & recall faster and smarter. You will learn choose the right study technique for you, appreciate the types of study you may undertake. You will be able to identify what reading style best matches your type of study and more. The course offers you a complete learning and study system that can be adapted to you & your topic. What you'll learn choose the right study technique for you appreciate the types study you may undertake understand that there are three main ways that you learn identify what reading style best matches your type of study practice and appreciate the different types of condensing and summarising methods understand how cue cards work acquire note-taking skills that will aid studying know how to study from books in an effective and efficient way understand how to prioritise your studying Know how to preempt what questions you may be asked appreciate how visual methods can aid information assimilation understand the benefit of auditory methods and techniques understand methods to ensuring you don't miss anything out when practicing / answering questions learn the ASPIRE strategy undertake a critical reflective learning exercise Requirements you may wish to take notes as you along please complete the baseline/pre course questions. This will be re-visited at the end of the course as part of your critical reflective learning Essential Study Skills Introductory video FREE 00:04:00 Types of study Why do you study? 00:05:00 How do you learn? How do you learn? 00:04:00 Acrostics, Acronyms, Analogies and Mnemonics Acrostics 00:03:00 Acronyms 00:02:00 Analogies 00:01:00 Mnemonics 00:04:00 Reading Reading video - styles & methods 00:06:00 Condensing and Summarising Keywords 00:03:00 Tree structures/diagrams 00:01:00 Spider diagrams 00:02:00 Mind maps 00:01:00 Concept maps 00:02:00 Cue Methods Flash cards 00:02:00 Note taking Skeleton prose 00:04:00 The Cornell Note Taking System 00:03:00 Studying from books PQRST & SQ3R methods 00:07:00 Prioritisation The traffic light approach 00:03:00 Visual methods Method of Loci 00:06:00 The peg or hook system 00:01:00 Auditory Auditory approaches 00:02:00 Don't miss anything out! BRG 00:01:00 PEE 00:02:00 A general strategy The ASPIRE approach 00:03:00 Summary Summary video 1 00:10:00 Summary video 2 00:08:00 Course Certification

Essential Study Skills: Strategies for Ultimate Success
Delivered Online On Demand1 hour 30 minutes
£25

Diploma in Negotiating Skills

By iStudy UK

Negotiation is a skill that can be learned by putting some simple techniques into practice. During your life, you will come across many situations that will put your negotiation skills to the test. Whether buying a house or land, considering contracts for your business, or discussing your salary with your boss, your success in these activities is highly dependent on your ability to negotiate. Enrol in this negotiation course today, and learn to negotiate masterfully, to give yourself a considerably better chance of personal and financial success. You will be acquainted with everything you need to know about negotiation, from preparing and planning, creating win/win situations, and ending the deal having got a brilliant price. Course Highlights Diploma in Negotiating Skills is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Diploma in Negotiating Skills into 31 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 1 day, 5 hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Diploma in Negotiating Skills Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Diploma in Negotiating Skills is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Diploma in Negotiating Skills is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. How to Negotiate With Your Landlord About Problems FREE 01:00:00 How to Negotiate With Your Family Members, and Keep the Peace FREE 01:00:00 What is Involved When A Labor Negotiation Takes Place? 01:00:00 What is involved when negotiating a car lease? 01:00:00 What is involved when negotiating a car purchase? 01:00:00 What is involved when negotiating a real estate purchase? 01:00:00 How to use Negotiating Skills 01:00:00 How to practice negotiating skills 01:00:00 How to put your negotiating skills to work for your business 01:00:00 How to find negotiating skills that you can really use 01:00:00 How to make negotiating a habit 00:30:00 How to avoid negotiating too much 01:00:00 How you use words when negotiating 00:15:00 How to use body language when negotiating contracts 00:30:00 How to use eye contact when negotiating sales 01:00:00 How to ask for a raise, negotiation for your career 01:00:00 How to ask for better benefits, how to negotiate 01:00:00 What is the art of negotiating 01:00:00 How to negotiate your way out of paying your bill all at one time 01:00:00 How to avoid raising your voice when negotiating a problem 00:30:00 How to be a leader with better negotiation skills 02:00:00 Three methods of getting someone to do what you want S10 02:00:00 Three Methods of avoiding a conflict while negotiating 00:30:00 Three Methods of avoiding a fight with your co-workers with negotiation skills 00:30:00 Three methods of getting someone to do what you want with the negotiation skills 01:00:00 How to realize your own negotiation skills and put them to work in your career 00:30:00 What is the top three negotiation skills needed by managers? 01:00:00 How to negotiate when trading in a car 01:00:00 How to negotiate with your boss, about anything 01:00:00 How to negotiate with your creditor about debts 00:30:00 How to negotiate when opening a new investment account 01:00:00 Mock Exam Mock Exam- Diploma in Negotiating Skills 00:20:00 Final Exam Final Exam- Diploma in Negotiating Skills 00:20:00

Diploma in Negotiating Skills
Delivered Online On Demand29 hours
£25

Strategic & Communication Skills

4.7(160)

By Janets

Register on the Strategic & Communication Skills today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get an e-certificate as proof of your course completion. The Strategic & Communication Skills is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Strategic & Communication Skills Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certification Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the Strategic & Communication Skills, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Course Content Section 01: Basic Communication Skills Definition of Communication 00:03:00 Elements of Communication 00:04:00 Communication Styles 00:03:00 Steps in Communication Process 00:01:00 Step 1 of Communication Process 00:02:00 Step 1 Explained - Goal and preparation 00:05:00 Step 1 Explained - Practicing Positive Intent 00:02:00 Step 1 Explained - Understanding Assumptions 00:06:00 Step 2 of Communication Process 00:08:00 Characteristics of Clear Message 00:04:00 Three Different Communication Styles 00:06:00 Assertive Communication Style 00:02:00 Body Language and Signals 00:03:00 Third Step in Communication - Seeing Feedback 00:04:00 Listening Skills - Listen with Compassion 00:04:00 Listening Skills - Meaning of Paraphrasing 00:02:00 Ways to Improve Communication and Knowledge Check 00:05:00 Increase Effectiveness of Communication 00:08:00 8 Guidelines for Giving Praise and Feedback 00:05:00 Additional Tips for Effective Communications 00:09:00 Section 02: Communication in Organisations & Strategic Communications Communication Requirements in Business 00:08:00 Skills required in corporate communication 00:06:00 Interactive Communications 00:08:00 Reason why Communication Fails 00:03:00 Communication Channels and Their Problems 00:06:00 Indications of Incompetent Communication 00:06:00 Other reasons for Communication failure 00:04:00 Strategic Communication Liner Model 00:05:00 Strategic Communication Adaptive Model 00:04:00 Strategic Communication Interpretive Model 00:04:00 Strategic Communication in Public Communication 00:09:00 Resources and Audience for Strategic Public Communication 00:07:00 Source of Strategic Communication 00:05:00 Strategic Communication - Summary of three models 00:12:00 Strategic Communication - Guidelines for Interpretative Models 00:05:00 Strategic Communication - Public Communications 00:11:00 Internal Communication - Orientation 00:09:00 Internal Communication - Moral Compansation and Benefits 00:07:00 Internal Communication - Organisation Change 00:07:00 External Communication - Issues Management 00:06:00 External Communication and PR 00:05:00 External Communication - Issue Management - Organisation Response 00:13:00 External Communication - Image Management and Issue Advocacy 00:06:00 External Communication - Risk and Crisis Communication 00:10:00 Case Study on Corporate Strategic Communication 00:09:00 Section 03: How to Make Strategic Communication Plans What is Strategy? 00:06:00 What is Communication Strategy? 00:05:00 When Communication Strategy is required 00:04:00 Why Communication Strategy is required 00:03:00 Information we need before making strategy 00:08:00 Setting Goals and Identify Audience 00:08:00 Catagorise your Audience to help draft right message 00:04:00 Drafting Message to cater your audience 00:04:00 Channels and Timing of Communication 00:05:00 Resources risk and Evaluation of communication strategy 00:04:00 Summary of Communication Strategy 00:03:00 Strategic Communication Plan Template 00:04:00 Strategic Communication Plan 00:04:00 Difference between Strategic and Tactical Communication 00:03:00 Traditional Planning and why Refreshed Approached 00:05:00 Change Management - What are concerns? 00:03:00 Refreshed Approach to Communication Planning 00:07:00 Possible Problems in Communication Plan, Success measurement 00:06:00 Measure, Feedback and Manage Cynics 00:03:00 Social Aspects of Communication Strategy 00:12:00 Additional Planning on Social Aspects of Communication Strategy 00:04:00 Strategic Communication - American Airlines Case Study 00:33:00 Section 04: Group Discussions Skills How to Succeed in Group Communication 00:10:00 Defining Group Communication 00:08:00 Elements of Group Communication and Types of Group 00:08:00 Advantages and Disadvantages of Group Discussion 00:08:00 How to prepare for group Discussion 00:07:00 Practice for group Discussion and other aspects 00:08:00 Dos and Don't group Discussion 00:08:00 Section 05: Communication Skills for Conflict Resolution Summary of previous class 00:05:00 What is conflict - class discussion? 00:07:00 Communication in Conflict 00:08:00 Meaning of Positive intent in difficult situations 00:09:00 Positive Intent - Example 00:05:00 De-escalating Emotions as a method to communicate in Conflicts 00:06:00 Detached Responsibility method in resolving conflicts 00:13:00 Keys to handle Angry Peoples 00:06:00 Keys to deal with denial 00:04:00 Uncovering Hidden Agendas 00:06:00 Giving Negative Feedback 00:09:00 Receiving Negative Feedback and Exercise 00:08:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Strategic & Communication Skills
Delivered Online On Demand9 hours 2 minutes
£25

Querying Microsoft SQL Server

5.0(3)

By Systems & Network Training

Querying Microsoft SQL Server course description This course covers the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server and provides the foundation for all SQL Server-related disciplines; namely, database administration, database development and business intelligence. This course helps prepare for exam 70-761. Note: This course is designed for SQL Server 2014or SQL Server 2016. What will you learn Write SELECT statements. Create and implement views and table-valued functions. Transform data by implementing pivot, unpivot, rollup and cube. Create and implement stored procedures. Add programming constructs such as variables, conditions, and loops to T-SQL code. Querying Microsoft SQL Server course details Who will benefit: Database administrators, database developers, and business intelligence professionals. SQL power users, namely, report writers, business analysts and client application developers. Prerequisites: Database fundamentals Duration 5 days Querying Microsoft SQL Server course contents Introduction to Microsoft SQL Server Management studio, creating and organizing T-SQL scripts, using books online. Hands on working with SQL Server tools. T-SQL querying Introducing T-SQL, sets, predicate logic, logical order of operations in SELECT statements, basic SELECT statements, queries that filter data using predicates, queries that sort data using ORDER BY. Hands on introduction to T-SQL querying. Writing SELECT queries Writing simple SELECT statements, eliminating duplicates with DISTINCT, column and table aliases, simple CASE expressions. Hands on writing basic SELECT statements. Querying multiple tables cross joins and self joins, write queries that use Inner joins, write queries that use multiple-table inner joins, write queries that use self-joins, write queries that use outer joins, write queries that use cross joins. Hands on querying multiple tables. Sorting and filtering data Sorting data, filtering data with predicates, filtering data with TOP and OFFSET-FETCH, working with unknown values, WHERE clause, ORDER BY clause, TOP option, OFFSET-FETCH clause. Hands on sorting and filtering data. SQL Server data types Introducing SQL Server data types, Character data, date and time data, queries that return date and time data, write queries that use date and time functions, write queries that return character data, write queries that return character functions. Hands on working with SQL Server data types. DML Adding data to tables, modifying and removing data, generating automatic column values, Inserting records with DML, updating and deleting records using DML. Hands on using DML to modify data. Built-in functions Queries with built-in functions, conversion functions, logical functions, functions with NULL, queries that use conversion functions, queries that use logical functions, queries that test for nullability. Hands on built-in functions Grouping and aggregating data Aggregate functions, the GROUP BY clause, filtering groups with HAVING, queries that use the GROUP BY clause, queries that use aggregate functions, queries that use distinct aggregate functions, queries that filter groups with the HAVING clause. Hands on grouping and aggregating data. Subqueries Self-contained subqueries, correlated subqueries, EXISTS predicate with subqueries, scalar and multi-result subqueries. Hands on subqueries. Table expressions Views, inline table-valued functions, derived tables, common table expressions. queries that use views, write queries that use derived tables, Common Table Expressions (CTEs), write queries that se inline Table valued expressions (TVFs). Hands on table expressions. Set operators The UNION operator, EXCEPT and INTERSECT, APPLY, queries that use UNION set operators and UNION ALL, CROSS APPLY and OUTER APPLY operators. Hands on set operators. Windows ranking, offset, and aggregate functions OVER, window functions, ranking functions, offset functions, window aggregate functions. Hands on; windows ranking, offset, and aggregate functions. Pivoting and grouping sets PIVOT and UNPIVOT, grouping sets, queries that use the PIVOT operator, queries that use the UNPIVOT operator, queries that use the GROUPING SETS CUBE and ROLLUP subclauses. Hands on pivoting and grouping sets Executing stored procedures Querying data with stored procedures, passing parameters to stored procedures, simple stored procedures, dynamic SQL, the EXECUTE statement to invoke stored procedures. Hands on executing stored procedures. Programming with T-SQL T-SQL programming elements, controlling program flow, declaring variables and delimiting batches, control-of-flow elements, variables in a dynamic SQL statement, synonyms. Hands on programming with T-SQL Error handling T-SQL error handling, structured exception handling, redirect errors with TRY/CATCH, THROW to pass an error message back to a client. Hands on implementing error handling. Implementing transactions Transactions and the database engines, controlling transactions, BEGIN, COMMIT, and ROLLBACK, adding error handling to a CATCH block. Hands on implementing transactions.

Querying Microsoft SQL Server
Delivered in Internationally or OnlineFlexible Dates
£2,797

Program Management Skills: On-Demand

By IIL Europe Ltd

Program Management Skills: On-Demand Program managers coordinate and give oversight to the efforts of marketing groups, project teams, product delivery, maintenance and support, operations and staff from various functional groups, including suppliers, business partners, and other external bodies. The goal is to ensure that proposed business transformation, through the delivery of complex products and processes, is implemented to realize the organization's strategic benefits and objectives, for which the program was selected. The goals of this course are twofold: To provide participants with key program management principles and techniques, recognized as best practices, to enable more effective program management; and to leverage core elements of the program management life cycle, processes, tools and techniques, to enable program management effectiveness. The participant will learn and apply the principles of program management through discussions, activities, and case study exercises. What You Will Learn At the end of this workshop, you will be able to: Maximize the transformational impact of a program according to the business needs Explain management principles and techniques and apply them within a program context Implement program governance and organization that will produce expected benefits Plan for and manage benefit realization, risks, issues, and quality Manage component projects' interdependencies that are linked to both program and strategic objectives Engage program stakeholders effectively. Improve communication and action planning effectiveness for programs in organizations Getting Started Introductions Course structure Course goals and objectives Foundation Concepts Fundamental definitions and concepts Program challenges and benefits Program best practices and success criterion Stakeholder management Governance: program management office and program boards Standard for Program Management overview Vision, Leadership, and the Business Case What is vision, why, and how? Leadership vs. Management Program business case Program Organization and Governance Program organization Program governance Program board roles and responsibilities Benefits Management Benefits explored Benefits management Benefits realization Program Management Planning Program management plan Program blueprint and roadmap Program component dossier Program tranches Program estimating Program scheduling Program Monitoring and Controlling Program Control - An Overview Program Monitoring and Controlling Monitoring and Controlling Transition Program Risk and Issue Management Risk and issue management overview Program risk management Program issue management Program Quality Management Program quality management overview Program quality management principles Program Stakeholder Management Stakeholder engagement overview Stakeholder engagement planning EI, trust, communication and stakeholder engagement Program Closure and Benefits Sustainment Program closure overview Closing the program Program benefits sustainment Summary What did we learn, and how can we implement this in our work environments?

Program Management Skills: On-Demand
Delivered Online On Demand14 hours
£1,250