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

51158 Courses

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

Social Skills & Build Strong Connections Course

4.8(9)

By Skill Up

Unlock the potential to transform your social interactions and build meaningful relationships with our 'Master Social Skills and Build Strong Connections' course.

Social Skills & Build Strong Connections Course
Delivered Online On Demand2 hours 12 minutes
£25

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

Diploma in Effective Writing Skills

4.7(160)

By Janets

Register on the Diploma in Effective Writing 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 a digital certificate as a proof of your course completion. The Diploma in Effective Writing 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 Diploma in Effective Writing Skills Receive an 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. 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 Diploma in Effective Writing 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 Module 01: Introduction to Effective Writing Introduction to Effective Writing 00:09:00 Module 02: Essentials of Effective Writing Essentials of Effective Writing 00:18:00 Module 03: Writing Process Writing Process 00:18:00 Module 04: Writing for Different Purposes Writing for Different Purposes 00:17:00 Module 05: Editing and Proofreading Editing and Proofreading 00:11:00 Module 06: Advanced Writing Techniques Advanced Writing Techniques 00:13: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.

Diploma in Effective Writing Skills
Delivered Online On Demand1 hour 26 minutes
£25

Communication Skills

5.0(50)

By First Safety Training Services

For all staff members.

Communication Skills
Delivered In-PersonFlexible Dates
£140

Mental Skills Training

4.3(43)

By John Academy

Description: If you are facing some common mental health problems or interested to support someone who does, this Mental Skills Training can help you. It will provide the methods and techniques to not only develop skills such as concentration and positive body language, but also to foster personal characteristics such as self-esteem and positive competitive skills and behaviors. It will help you cope with issues of anxiety, stress low mood and other mild to moderate mental health problems through learning and skill development. So, get this course to learn more about yourself, gain confidence and develop skills in a welcoming, supportive and safe environment. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Mental Skills Training is certified by CPD Qualifications Standards and CiQ. 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 background. Requirements Our Mental Skills Training 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 After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Module One: Getting Started 00:05:00 Module Two: Bloom's Taxonomy 00:10:00 Module Three: Knowledge 00:15:00 Module Four: Comprehension 00:15:00 Module Five: Application 00:15:00 Module Six: Analysis 00:15:00 Module Seven: Synthesis 00:15:00 Module Eight: Evaluation 00:15:00 Module Nine: Updated Version 00:15:00 Module Ten: Types of Knowledge 00:15:00 Module Eleven: Training 00:15:00 Module Twelve: Wrapping Up 00:05:00 Mock Exam Mock Exam- Mental Skills Training 00:20:00 Final Exam Final Exam- Mental Skills Training 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Mental Skills Training
Delivered Online On Demand3 hours 15 minutes
£18

Reiki Level 2 Practitioner Online Course

By Margaret Driscoll Cook - Learn More About Reiki

I am a Reiki Teacher in Manchester and one of the few traditionally trained Reiki Masters in the UK who have been trained by international best-selling Reiki author Penelope Quest. My teaching methods use traditional Reiki techniques perfected over many years and you can be assured of my support during and after your course. I teach all three levels of Reiki courses, level 1 reiki. level 2 reiki and reiki master level 3

Reiki Level 2 Practitioner Online Course
Delivered Online + more
£297

Facilitation Skills Training

4.3(43)

By John Academy

Do you wish to know the facilitation adequetely and what tools are needed to facilitate and organize? This course will truly help you discover the tools and skills you need for facilitation. Description: Facilitation skill has to be learned and developed to be able to demonstrate it effectively to any organisation. You will learn these skills when you understand its definition, purpose, and benefits that are the main purpose of this module. Through this course, you will learn differentiation process and content. The importance of group discussions and how to prepare for it will be emphasised. Also, you will be provided with the guidelines in dealing with challenges in groups. They know what and how interventions work to be able to facilitate it well. Who is the course for? Facilitators or anyone from the management team that needs to learn about facilitation skills training. People who need to know how to facilitate and train people in their organisation. 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 hardcopy at the cost of £39 or in PDF format at the 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. Career Path: The Facilitation Skill Training Course would be beneficial for the following careers: Businessmen Executive Management Members Team Facilitator Team Leader. Facilitation Skills Training Module One - Getting Started 01:00:00 Module Two - Understanding Facilitation 00:30:00 Module Three - Process vs. Content 01:00:00 Module Four - Laying the Groundwork 00:30:00 Module Five - Tuckman and Jensen's Model of Team Development 01:00:00 Module Six - Building Consensus 00:30:00 Module Seven - Reaching a Decision Point 01:00:00 Module Eight - Dealing with Difficult People 01:00:00 Module Nine - Addressing Group Dysfunction 01:00:00 Module Ten - About Intervention 00:30:00 Module Eleven - Intervention Techniques 00:30:00 Module Twelve - Wrapping Up 01:00:00 Activities Facilitation Skills Training- Activities 00:00:00 Mock Exam Mock Exam- Facilitation Skills Training 00:20:00 Final Exam Final Exam- Facilitation Skills Training 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Facilitation Skills Training
Delivered Online On Demand10 hours 10 minutes
£16.99

Foundation in Business Skills

By OnlineCoursesLearning.com

Establishment in Business Skills The Foundation in Business Skills course is the ideal decision, in the event that you have staff individuals who are right off the bat in their vocation and wish to acquire a sweeping information on the stuff to maintain a fruitful business. Spread across 16, simple to-follow modules, understudies will acquire abilities in a huge number of business-related regions, including funds, methodologies and advertising, giving them the devices that they need, to truly contribute towards the achievement of your business. What's Covered in the Course? The very much organized modules of this course cover in detail the accompanying territories: The essentials of beginning a business - from thought age and business wanting to building a procedure and recognizing the objective market; The monetary parts of a business, including beginning set-up expenses and financing alternatives, just as continuous monetary necessities and prerequisites, for example, income, estimating, keeping accounts and planning; How promoting can profit a business by drawing in and holding clients; this module likewise incorporates helpful data with respect to web-based media publicizing; Step by step instructions to successfully make a brand for your business, to guarantee that it is alluring inside the commercial center; What to consider when utilizing staff, like enrollment, preparing, lawful contemplations and getting the best from your workers; Basic business managerial prerequisites, for example, the sort of protection that the business may profit by, what assessments are required and how to pay them and the significance of staying informed concerning proper legitimate and administrative issues that influence the business; Step by step instructions to viably utilize innovation in your business, remembering the significance of a very much planned site for pulling in clients. What are the Benefits of the Course? There are an entire host of advantages of taking the Foundation in Business Skills course: The organized certificate can assist with speeding up the understudy's profession; Your business will profit by having representatives who are proficient about the stuff to run a fruitful venture, and you will be compensated by realizing that you are putting resources into the fate of your colleagues; There are no section prerequisites, so your representatives needn't stress over having the correct capabilities, to apply; The course content is on the web and organized in a secluded style, so understudies can learn at their own speed, in a spot and during a period that suits them.

Foundation in Business Skills
Delivered Online On Demand
£50

Summer Schools in St Andrews, Cambridge & Yale

4.8(6)

By Issos - International Summer Schools

International Summer School for 13-18 year olds from all over the world at St Andrews, Cambridge and Yale Universities.

Summer Schools in St Andrews, Cambridge & Yale
Delivered In-PersonFlexible Dates
£500 to £7,100