45258 Courses delivered Online

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.

This Level 3 Apprenticeship has been designed for individuals wishing to start or advance their skills in first-line management, and will equip them with the knowledge and understanding needed to effectively provide direction, instructions and guidance to ensure the achievement of set goals.

Duration 5 Days 30 CPD hours This course is intended for Students in this course are interested in Azure development or in passing the Microsoft Azure Developer Associate certification exam. This course teaches developers how to create end-to-end solutions in Microsoft Azure. Students will learn how to implement Azure compute solutions, create Azure Functions, implement and manage web apps, develop solutions utilizing Azure storage, implement authentication and authorization, and secure their solutions by using KeyVault and Managed Identities. Students will also learn how to connect to and consume Azure services and third-party services, and include event- and message-based models in their solutions. The course also covers monitoring, troubleshooting, and optimizing Azure solutions. Prerequisites To be successful in this course, learners should have the following: Hands-on experience with Azure IaaS and PaaS solutions, and the Azure Portal. Experience writing in an Azure supported language at the intermediate level. (C#, JavaScript, Python, or Java) Ability to write code to connect and perform operations on, a SQL or NoSQL database product. (SQL Server, Oracle, MongoDB, Cassandra or similar) Experience writing code to handle authentication, authorization, and other security principles at the intermediate level. A general understanding of HTML, the HTTP protocol and REST API interfaces. 1 - Explore Azure App Service Examine Azure App Service Examine Azure App Service plans Deploy to App Service Explore authentication and authorization in App Service Discover App Service networking features 2 - Configure web app settings Configure application settings Configure general settings Configure path mappings Enable diagnostic logging Configure security certificates 3 - Scale apps in Azure App Service Examine autoscale factors Identify autoscale factors Enable autoscale in App Service Explore autoscale best practices 4 - Explore Azure App Service deployment slots Explore staging environments Examine slot swapping Swap deployment slots Route traffic in App Service 5 - Explore Azure Functions Discover Azure Functions Compare Azure Functions hosting options Scale Azure Functions 6 - Develop Azure Functions Explore Azure Functions development Create triggers and bindings Connect functions to Azure services 7 - Explore Azure Blob storage Explore Azure Blob storage Discover Azure Blob storage resource types Explore Azure Storage security features Discover static website hosting in Azure Storage 8 - Manage the Azure Blob storage lifecycle Explore the Azure Blob storage lifecycle Discover Blob storage lifecycle policies Implement Blob storage lifecycle policies Rehydrate blob data from the archive tier 9 - Work with Azure Blob storage Explore Azure Blob storage client library Create a client object Manage container properties and metadata by using .NET Set and retrieve properties and metadata for blob resources by using REST 10 - Explore Azure Cosmos DB Identify key benefits of Azure Cosmos DB Explore the resource hierarchy Explore consistency levels Choose the right consistency level Explore supported APIs Discover request units 11 - Work with Azure Cosmos DB Explore Microsoft .NET SDK v3 for Azure Cosmos DB Create stored procedures Create triggers and user-defined functions Explore change feed in Azure Cosmos DB 12 - Manage container images in Azure Container Registry Discover the Azure Container Registry Explore storage capabilities Build and manage containers with tasks Explore elements of a Dockerfile 13 - Run container images in Azure Container Instances Explore Azure Container Instances Run containerized tasks with restart policies Set environment variables in container instances Mount an Azure file share in Azure Container Instances 14 - Implement Azure Container Apps Explore Azure Container Apps Explore containers in Azure Container Apps Implement authentication and authorization in Azure Container Apps Manage revisions and secrets in Azure Container Apps Explore Dapr integration with Azure Container Apps 15 - Explore the Microsoft identity platform Explore the Microsoft identity platform Explore service principals Discover permissions and consent Discover conditional access 16 - Implement authentication by using the Microsoft Authentication Library Explore the Microsoft Authentication Library Initialize client applications 17 - Implement shared access signatures Discover shared access signatures Choose when to use shared access signatures Explore stored access policies 18 - Explore Microsoft Graph Discover Microsoft Graph Query Microsoft Graph by using REST Query Microsoft Graph by using SDKs Apply best practices to Microsoft Graph 19 - Implement Azure Key Vault Explore Azure Key Vault Discover Azure Key Vault best practices Authenticate to Azure Key Vault 20 - Implement managed identities Explore managed identities Discover the managed identities authentication flow Configure managed identities Acquire an access token 21 - Implement Azure App Configuration Explore the Azure App Configuration service Create paired keys and values Manage application features Secure app configuration data 22 - Explore API Management Discover the API Management service Explore API gateways Explore API Management policies Create advanced policies Secure APIs by using subscriptions Secure APIs by using certificates 23 - Explore Azure Event Grid Explore Azure Event Grid Discover event schemas Explore event delivery durability Control access to events Receive events by using webhooks Filter events 24 - Explore Azure Event Hubs Discover Azure Event Hubs Explore Event Hubs Capture Scale your processing application Control access to events Perform common operations with the Event Hubs client library 25 - Discover Azure message queues Choose a message queue solution Explore Azure Service Bus Discover Service Bus queues, topics, and subscriptions Explore Service Bus message payloads and serialization Explore Azure Queue Storage Create and manage Azure Queue Storage and messages by using .NET 26 - Monitor app performance Explore Application Insights Discover log-based metrics Instrument an app for monitoring Select an availability test Troubleshoot app performance by using Application Map 27 - Develop for Azure Cache for Redis Explore Azure Cache for Redis Configure Azure Cache for Redis Interact with Azure Cache for Redis by using .NET 28 - Develop for storage on CDNs Explore Azure Content Delivery Networks Control cache behavior on Azure Content Delivery Networks Interact with Azure Content Delivery Networks by using .NET

Duration 5 Days 30 CPD hours This course is intended for This course is intended for professional web developers who use Microsoft Visual Studio in an individual-based or team-based, small-sized to large development environment. Candidates for this course are interested in developing advanced web applications and want to manage the rendered HTML comprehensively. They want to create websites that separate the user interface, data access, and application logic. Overview Describe the Microsoft Web Technologies stack and select an appropriate technology to use to develop any given application. Design the architecture and implementation of a web application that will meet a set of functional requirements, user interface requirements, and address business models. Configure the pipeline of ASP.NET Core web applications using middleware, and leverage dependency injection across applications. Develop a web application that uses the ASP.NET Core routing engine to present friendly URLs and a logical navigation hierarchy to users. Create Views in an application that display and edit data and interact with Models and Controllers. Connect an ASP.NET Core application to a database using Entity Framework Core. Implement a consistent look and feel across an entire web application. Write JavaScript code that runs on the client-side and utilizes the jQuery script library to optimize the responsiveness of an web application. Add client side packages and configure Task Runners. Run unit tests and debugging tools against a web application in Visual Studio 2022. Write an application that authenticates and authorizes users to access content securely using Identity. Build an application that resists malicious attacks. Use caching to accelerate responses to user requests. Use SignalR to enable two-way communication between client and server. Describe what a Web API is and why developers might add a Web API to an application. Describe how to package and deploy an ASP.NET Core web application from a development computer to a web server. In this 5-day course, professional web developers will learn to develop advanced ASP.NET Core applications using .NET tools and technologies. The focus will be on coding activities that enhance the performance and scalability of the Web site application. Module 1: Exploring ASP.NET Core Introducing of Microsoft Web Technologies Getting Started with Razor Pages in ASP.NET Core Introducing ASP.NET Core MVC Module 2: Designing ASP.NET Core MVC Web Applications Planning in the Project Design Phase Designing Models, Controllers and Views Module 3: Configure Middleware and Services in ASP.NET Core Configuring Middlewares Configuring Services Module 4: Developing Controllers Writing Controllers and Actions Configuring Routes Writing Action Filters Module 5: Developing Views Creating Views with Razor Syntax Using HTML Helpers and Tag Helpers Reusing Code in Views Module 6: Developing Models Creating MVC Models Working with Forms Validating User Input Module 7: Using Entity Framework Core in ASP.NET Core Introduction to Entity Framework Core Working with Entity Framework Core Use Entity Framework Core to connect to Microsoft SQL Server Module 8: Using Layouts, CSS and JavaScript in ASP.NET Core Using Layouts Using CSS and JavaScript Using JavaScript Libraries Module 9: Client-Side Development Applying Styles and Responsive Design Using Task Runners Looking at ASP.NET Core Blazor Module 10: Testing and Troubleshooting Testing ASP.NET Core Applications Implementing an Exception Handling Strategy Logging ASP.NET Core Applications Module 11: Managing Security Authentication in ASP.NET Core Authorization in ASP.NET Core Defending from Common Attack Module 12: Performance and Communication Implementing a Caching Strategy Managing State Supporting Two-way Communication Module 13: Implementing Web APIs Introducing Web APIs Developing a Web API Calling a Web API Module 14: Hosting and Deployment Hosting and Deploying On-premises Deploying to Microsoft Azure Looking at Microsoft Azure Fundamentals

Historical Association webinar series: Making GCSE history accessible: supporting all learners at Key Stage 4 Presenters: Catherine Priggs   This session explores the essential literacy skills required to engage effectively with history at Key Stage 4. Participants will examine the unique demands of historical reading and writing and learn strategies to scaffold tasks that develop pupils’ ability to analyse sources, construct arguments, and communicate historical ideas clearly. Key topics: • Understanding the literacy challenges specific to historical texts and tasks • Strategies to enhance comprehension of complex historical sources and narratives • Scaffolding writing skills to support the construction of clear and persuasive historical arguments To use your corporate recording offer on this webinar please fill in this form: https://forms.office.com/e/bdNUSwLNrL Image: A Squire "Old English" padlock on a gate latch in Devon (Image: Partonez/Wikimedia Commons)

Embrace the stunning medium of watercolour and master a range of contemporary techniques to create modern artwork that incorporates both traditional and contemporary approaches. This course is perfect for beginners who want to learn how to develop their skills in watercolour painting, with tips for both canvas work and Photoshop imagery. Under the guidance of expert freelance designer and illustrator Cat Coquilette, who has sold over 100,000 products worldwide, you will familiarise with a range of professional art supplies, learning how to inject texture, depth and detail. From perfecting your brushstroke to creating unique colour blends, this course covers essential skills required to create standout on-trend art. Also included is a special bonus video for working with gold textures to create beautiful metallic accents. Course Highlights The Modern Watercolour Techniques: Explore Skills to Create On-Trend Paintings course is an award-winning and best-selling course that has been awarded CPD Certification & IAO accreditation. It is the most suitable course for anyone looking to work in this field or relevant sector. This training program is considered one of the top-trending courses in the UK, helping students to familiarise with the topic and gain the necessary skills to perform well in this field. We have organised the course into several specific modules, teaching you everything you need to become successful in this profession. To provide you with ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 20/30 hours, with the freedom 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 recognise your qualification by checking the validity from our dedicated website. Why You Should Choose the Modern Watercolour Techniques Course 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, dispatched the next working day for as little as £9. Improve your earning potential and gain valuable career skills. What you'll learn Art supplies I recommend, including paint brands, paper, and brush types Tips for sketching out the perfect composition Mixing vibrant color palettes Brush control techniques so you can create the perfect stroke Painting with whitespace in mind Blending hues together on paper Creating beautiful watercolor blooms and ombré gradient washes Fixing mistakes as you paint, like splattered paint or wayward brushstrokes Adding in tiny details to your painting Who is this Course for? This step-by-step training course is for both beginners and those with some experience with watercolour painting who wish to master modern techniques to create on-trend artwork. There are no specific entry requirements for this course. To provide you with ease of access, this course is designed for both part-time and full-time students. Requirements The Modern Watercolour Techniques: Explore Skills to Create On-Trend Paintings course is fully compatible with any kind of device. Whether you are using a Windows computer, Mac, smartphone 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 On successful completion, you will have the practical knowledge, skills and credentials to pursue a career in one of the following fields: Professional Painter Watercolour Artist Multimedia Artist Modern Watercolor Techniques: Explore Skills to Create On-Trend Paintings 1. Intro FREE 00:03:00 2. Art Supplies 00:06:00 3. Sketching the Motif 00:11:00 4. Color Palettes 00:04:00 5. Brush Control 00:06:00 6. Whitespace 00:02:00 7. Blending Colors on Paper 00:12:00 8. Making Watercolor Blooms 00:03:00 9. Paper: Wet vs Dry 00:04:00 10. Ombré Gradient Washes 00:06:00 11. Fixing Mistakes 00:05:00 12. Adding Details 00:03:00 13. Metallic Accents 00:12:00 14. Final Tips 00:02:00

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

This one day course will support teachers and RSE leads in special colleges and special schools with post 16 learners to deliver a meaningful curriculum through the Preparing for Adulthood outcomes. The course will explore key issues for older learners, including how to teach about practical aspects of relationships such as attraction and fancying people, starting relationships, negotiation and consent discussions, and how to keep yourself safe. Participants will leave with increased confidence to develop and deliver a skills-based, rights focused curriculum that will empower learners to be able to navigate their personal lives and relationships with autonomy.   Aim: To develop confidence to create and deliver an age-appropriate, rights based RSE curriculum for young adults with learning disabilities.   Outcomes: Participants will develop understanding of requirements for RSE for older learners, including the statutory guidance and preparation for adulthood outcomes, and how RSE can support independent living consider specific challenges young people with SEND may face in developing relationships and explore practical and creative ways to support relationship skill development explore strategies to address sexualised behaviour, and what to do if a learner begins or wants to masturbate in college   Who is this course for? This one day course is ideal for teachers and RSE leads working in special schools and tutors in colleges with older learners, up to age 25, and beyond.

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