51166 Courses

Advanced Level workshop that introduces you to the basic Techniques of Academic English that will help you to: i)  Read and Write Academic tests more effectively, and ii)  give effective Academic Presentations. 

CRRUK equips professionals with the concepts, skills and tools to build conscious, intentional relationships, and to coach relationship systems of any size.

Advanced Level workshop that introduces you to the basic Techniques of Academic English that will help you to: i)  Read and Write Academic tests more effectively, and ii)  give effective Academic Presentations. 

Advanced Level workshop that introduces you to the basic Techniques of Academic English that will help you to: i)  Read and Write Academic tests more effectively, and ii)  give effective Academic Presentations. 

Advanced Level workshop that introduces you to the basic Techniques of Academic English that will help you to: i)  Read and Write Academic tests more effectively, and ii)  give effective Academic Presentations. 

Advanced Level workshop that introduces you to the basic Techniques of Academic English that will help you to: i)  Read and Write Academic tests more effectively, and ii)  give effective Academic Presentations. 

Aimed at those wanting to be work-ready upon completion, this Beginners Hairdressing Course is the perfect way to start your new career. You’ll be cutting hair on day 2! You’ll also have training on roller-setting, long hair, colouring, perming, client care, shampooing, blow-drying and salon protocol.

Give a compliment to your career and take it to the next level. This Practical Leadership Skills bundle will provide you with the essential knowledge to shine in your professional career. Whether you want to develop skills for your next job or elevate your skills for your next promotion, this Practical Leadership Skills bundle will help you stay ahead of the pack. Throughout the Practical Leadership Skills programme, it stresses how to improve your competency as a person in your chosen field while also outlining essential career insights in the relevant job sector. Along with this Practical Leadership Skills course, you will get 10 premium courses, an original hardcopy, 11 PDF certificates (Main Course + Additional Courses) Student ID card as gifts. This Practical Leadership Skills Bundle Consists of the following Premium courses: Course 01: Leadership & Management Diploma Course 02: Diploma in Lean Leadership and Change Management Course 03: Motivation Skills Course 04: Delegation Skills Course 05: Giving and Receiving Feedback Course 06: People Management Skills Level 3 Course 07: Performance Management Course 08: Coaching Leaders for Success Course 09: Dealing With Difficult People Training Course Course 10: Decision Making and Critical Thinking Course 11: Decision Making and Critical Thinking Enrol now in Practical Leadership Skills to advance your career, and use the premium study materials from Apex Learning. How will I get my Certificate? After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Practical Leadership Skills expertise and essential knowledge, which will assist you in reaching your goal. Moreover, you can learn from any place in your own time without travelling for classes. Curriculum of Bundle Course 01: Personal Leadership and Influencing Skills Getting Started The Evolution of Leadership Situational Leadership A Personal Inventory Modelling the Way Inspiring a Shared Vision Challenging the Process Enabling Others to Act Encouraging the Heart Basic Influencing Skills Setting Goals CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Practical Leadership Skills bundle. Requirements This Practical Leadership Skills course has been designed to be fully compatible with tablets and smartphones. Career path Having this expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Leadership: Practical Leadership Skills) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

Duration 2 Days 12 CPD hours This course is intended for This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer. It can also be useful for others peripherally involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers. This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics. 1 - Introduction to Transact-SQL Work with schemas Explore the structure of SQL statements Examine the SELECT statement Work with data types Handle NULLs 2 - Sort and filter results in T-SQL Sort your results Limit the sorted results Page results Remove duplicates Filter data with predicates 3 - Combine multiple tables with JOINs in T-SQL Understand joins concepts and syntax Use inner joins Use outer joins Use cross joins Use self joins 4 - Write Subqueries in T-SQL Understand subqueries Use scalar or multi-valued subqueries Use self-contained or correlated subqueries 5 - Use built-in functions and GROUP BY in Transact-SQL Categorize built-in functions Use scalar functions Use ranking and rowset functions Use aggregate functions Summarize data with GROUP BY Filter groups with HAVING 6 - Modify data with T-SQL Insert data Generate automatic values Update data Delete data Merge data based on multiple tables Additional course details: Nexus Humans DP-080T00 Querying Data with Microsoft Transact-SQL training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the DP-080T00 Querying Data with Microsoft Transact-SQL course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Master the art of negotiation and transform your professional and personal interactions with our comprehensive Negotiation Skills Professional Diploma. Designed for individuals seeking to enhance their ability to negotiate effectively in various settings, this course will provide you with the essential skills and strategies to succeed. Key Features: CPD Certified Free Certificate Developed by Specialist Lifetime Access In this course on negotiation skills, learners will gain essential abilities to prepare effectively for negotiations, laying a strong foundation for success. They will understand the core principles of negotiation, including how to find mutual benefits and create win-win outcomes. The course will also teach strategies to handle challenging issues and difficult negotiators. Participants will learn techniques for negotiating in various settings beyond the boardroom, and how to represent others in negotiations. Additionally, the course will guide learners through the critical phases of bargaining and closing deals, ensuring they can secure the best possible agreements. By the end of the course, learners will be equipped with practical skills and confidence to navigate any negotiation scenario professionally and effectively. Course Curriculum Module 01: Getting Prepared Module 02: Laying the Groundwork Module 03: Understanding Negotiation Module 04: About Mutual Gain Module 05: Dealing with Difficult Issues Module 06: Negotiating Outside the Boardroom Module 07: Negotiating on Behalf of Someone Else Module 08: Phase Two - Bargaining Module 09: Phase Three - Closing Learning Outcomes: Develop strategic preparation techniques for effective negotiation scenarios. Master foundational groundwork for successful negotiation engagements. Grasp key principles of negotiation dynamics and strategies. Foster mutual gain through collaborative negotiation tactics. Address and resolve difficult negotiation issues effectively. Navigate negotiations beyond the boardroom setting confidently. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Business managers seeking enhanced negotiation capabilities. Team leaders aiming to improve negotiation outcomes. Sales professionals looking to close better deals. Entrepreneurs negotiating with partners and stakeholders. Consultants representing clients in various negotiations. Career path Corporate Negotiator Sales Manager Business Development Manager Procurement Specialist Contract Manager Mediation Consultant Certificates Digital certificate Digital certificate - Included Will be downloadable when all lectures have been completed.