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

104 Courses in Bristol

Foundation level Anti Wrinkle and Dermal Fillers Course -Choose your own dates .

By Sassthetics Training Academy

One-2 one training in Aesthetics -Anti Wrinkle and Dermal fillers . Choose your own dates

Foundation level Anti Wrinkle and Dermal Fillers Course -Choose your own dates .
Delivered In-Person in Blackpool or UK WideFlexible Dates
FREE

Body Piercing Training Course 1 or 2 Days-choose your own dates .

By Sassthetics Training Academy

One -2- One Body Piercing Training Course . 1 or 2 days depending on the level of mentorship you require. Blackpool based

Body Piercing Training Course 1 or 2 Days-choose your own dates .
Delivered In-Person in Blackpool or UK WideFlexible Dates
FREE

AI support for your compliance

5.0(27)

By PETM

Transport Compliance, Audits, Health and Safety, HGV compliance, PSV compliance, Compliance, Templates, Toolbox Talk, Professional Development, Assistance, Operator Licence assistance,

AI support for your compliance
Delivered in ELY + 1 more or UK Wide or OnlineFlexible Dates
Price on Enquiry

Our team of Construction industry experts provide business management training for leaders and business owners across England and Scotland CONSTRUCTION INDUSTRY SPECIFIC Construction Business Growth Academy The Power Within Training is dedicated to helping construction-based business owners and construction management throughout England, Scotland, and Wales achieve more than they believed possible. Our construction business training is designed to develop owner-managers and help them create the future they want. To ensure business growth, we have a dedicated team of industry professionals to give unique support specific to the skills, traits, and challenges found within Construction. This programme was created to help you push and elevate your business to the next level. Contact us to register for our construction business training. Explore Our Construction Business Growth Course We created the Business Growth Academy for business owners like you to grow and develop their businesses in a more controlled and sustainable way. To ensure growth, our construction business training is a series of six training modules focused on business growth, leadership, and financial management. Most of our participants are business owners looking to get the tools needed to spend more time working on their business while generating more profitability to ensure consistent business growth. The Power Within Training uses the latest business growth strategies, which allow you to identify, modify and quickly implement our easy-to-follow business-building tools and techniques designed around the construction and property development industry. Whether you are a business owner or an aspiring construction and property development entrepreneur, our Construction Management Course will provide the tools and techniques to drive your business forward and achieve sustainable growth. Join us at the Business Growth Academy and unlock your full potential. The Goal of Our Construction Management Training Our goal with this training is to provide you with the tools you need to take control of your business. This allows you to use the latest strategies and ensure the smooth growth of your construction business. The construction management training we offer is a three-month course with new modules available twice monthly, delivered via Zoom or in person. These modules are designed to work around your schedule. After, you’ll have a 39-hour CPD certification thanks to our CITB skills & training courses. Overall, our fully funded construction management training will help you place the proper foundation, allowing you to build a more substantial and focused business that’s centred around constant growth and profits while future-proofing your business. BUSINESS GROWTH ACADEMY The Benefit of Our Business Growth Academy As you go through our training, you’ll delve into each module and the critical steps and tools. These include how to plan, organize, and control construction operations, all designed to provide you with a well-rounded view of your business. Not only will you get the tools you need to ensure your construction business growth, but you’ll also get access to benefits such as lifetime access to your online interactive training portal, entrance into a private social and professional networking group, pro bono coaching, and mentoring from industry experts and leaders. Here are some additional benefits of our construction management training: Register your interest today You’ll build a personalised 12-month business development plan that keeps you focused on high-value activities, ensuring you remain on track to grow. Tools and techniques to not only measure but also increase your profitability within your business. These tools help you ensure that you’re never leaving money on the table again. Learn, develop, and nurture self-management and leadership strategies that you can work on and in your business to help you from chasing your tail or burning out. You’ll develop unshakeable confidence in your business’s ability to grow and become the kind of entrepreneur that chooses the customers they want to work with, meaning customers who are driven by value, not by price. Gain valuable leadership and self-development skills, which encourage learning for life. Lastly, you’ll no longer wonder, “what if?” You’ll have the knowledge and understanding to keep unlocking and growing your business’s true potential. WHAT'S INCLUDED IN THE PROGRAMME Course Overview As we’ve mentioned, our business management course is designed to be completed over three months, with two courses being released monthly. These are designed to be done on Zoom or in person and are flexible around your busy schedule. Our modules were created to be easy to understand while providing the resources needed to elevate your construction business. Here is a more in-depth look at what to expect from our modules: Module 1: The C.O.D.E Breaker: The Business FundamentalsThis module will encourage you to deep dive into your why and break the business C.O.D.E. You’ll be shown the importance of knowing why you started the business, how you can build a business while remaining authentic, and what needs to be done to ensure you create and support a solid foundation moving forward. During this module, you’ll discover how to successfully build a business in the construction industry, from the fundamentals and foundations to the growth. Lastly, we’ll review your vision, values, and purpose, show why these are critical areas, and allow you to establish a real business for you and your customers. Module 2: Your M.E.N.T.A.L Agility: The Entrepreneurial Mindset With this module, we’ll focus on self-leadership and how you should constantly be developing the ‘inner game’ or minder and the ‘outer game’ or action. The inner game consists of intention, self-awareness, self-confidence, and self-efficacy. These must be used to achieve personal mastery, while the outer game consists of influence and impact. M.E.N.T.A.L. agility is your key to all success and failure, meaning that without leading yourself, you’ll never find business success. For us, your M.E.N.T.A.L. agility is made of five key components that enable you to transition from owning a business to thinking and planning like an entrepreneurial business owner. Module 3: The T.I.M.E Multiple: Working ON or Working IN The point of this module is to help you understand that you can’t manage your time; you can only manage your use of time or your self-management skills. It’s vital to have strong self-management skills to be more successful at work. We’ll explore ways to help maximise your time and identify your High Payoff Activities. The T.I.M.E. multiplier is about accepting that you cannot do everything yourself. Instead, it would be best if you focused on your high-payoff activities. Our goal is to teach you to say it’s okay to say no. We’ll show you the importance of recognising the significance of all your decisions. Along with that, we focus on unique planning and defining processes to bring the future into the present. Module 4: The Business P.R.O.B.E: The Numbers Game Understanding your finances is essential as it allows you to make informed decisions that have the potential to make significant impacts on your business, growth, and even your bottom line. We want you never to leave money on the table again. When you know the difference between markup and margin, fixed and variable costs can make the difference between owning a business and the business owning you. Understanding your business numbers will increase your revenue and profitability and even grow your business. Module 5: High-Performance T.E.A.M.S: The Well-Oiled High-performing teams are more than a group that works together. A high-performing team has clear priorities and purposes and shares an understanding of how each team member or subcontractor prefers to approach work. The foundation of a high-performing team or business starts with trust. The development starts with creating an environment where leaders and team members can openly disclose which strengths they feel they bring to a team and what support they need to be their best selves. Truth is that all people’s problems directly reflect the business owner’s leadership and management. When a team doesn’t do things your way, they probably have no idea what your way is. Module 6: G.O.A.L.S: Setting & Defining the Accountability System Everyone works best with clearly defined goals, from completing a refurb on a budget or growing your construction business to over 10M annual profit. Remember the old saying, through a goal with a plan, is just a wish! We’ll teach you our tried and tested process for setting and achieving your objectives by focusing on what matters most. Reviewing your daily, weekly, and monthly goals, we can help you make high performance a habit. Best of all, you’ll create a detailed 12-month business development plan to get your personal and professional goals moving in the right direction. Meet the Construction Business Training Presenters Derrick Matheson: Training and Development Director and Trainer of Business Growth Academy A seasoned business owner, Derrick understands the challenges UK construction and property development professionals face. We have crafted a targeted program that simplifies growth, empowering entrepreneurs with easy-to-implement strategies.  Derrick’s mission is simple: to empower and equip ambitious entrepreneurs and professionals with the tools and knowledge necessary to thrive in today’s competitive market. The Business Growth Academy is a testament to his dedication, offering an innovative, step-by-step business-building process that demystifies the complexities of growth and unlocks the full potential of your enterprise. Stuart Mason: BGA’s Bold Training Manager, Lead Trainer, and Author of “How To Wreck Your Business Stuart, the fearless BGA Training Manager and Lead Trainer has turned his business failures into powerful lessons for others. As the author of “How To Wreck Your Business,” Stuart shares his hard-earned wisdom to help business owners avert the same pitfalls that led to the demise of his own company on its 20th anniversary. Stuart’s approach is refreshingly direct and unapologetically abrupt, cutting through the noise to deliver real-world insights that make a difference. Don’t expect a dry lecture on business theory from a dusty textbook; instead, Stuart offers a ‘streetwise’ perspective that is both practical and actionable, pushing you to uncover the answers that will make your business shine in a competitive market.

Business Growth Academy
Delivered in Motherwell or UK Wide or OnlineFlexible Dates
Price on Enquiry

Online Options

Show all 31570

Advanced Phlebotomy - Skills & Techniques (GPT005)

4.6(39)

By Geopace Training

The UK's first and only Level 4 qualification in Phlebotomy (equivalent to Ireland Level 6) FDSc (Foundation Degree Level) qualification Nationally Recognised certificate Dually accredited: Open College Network and CPD Covers both aspirated and evacuated systems Covers specialised blood collection systems & methods Classroom or Virtual Classroom learning options Comprehensive Training Kit is provided when booking our Virtual Classroom option (yours to keep) Complete your training from beginner to advanced level This course either follows on from our Introduction to Phlebotomy Course or can be combined with our introductory course as part of a course package (see below) Available to candidates who have completed (or are currently enrolled to complete) our Introduction to Phlebotomy Course or have previous phlebotomy practical experience.

Advanced Phlebotomy - Skills & Techniques (GPT005)
Delivered in Nottingham + 20 more or Online + more
£195

Real Estate Financial Modelling School

4.3(5)

By Bayfield Training

This week long CPD accredited training is ideal for those Real Estate professionals, who are looking to bolster the DCF modelling skills. This course covers Real Estate Investment, Development, Finance & Risk.

Real Estate Financial Modelling School
Delivered in person or Online + more
£4,600

Real Estate Analyst (Investment Cash Flow Modelling in Excel)

4.3(5)

By Bayfield Training

The Real Estate Analyst course has been taught non-stop to global real estate firms over the last 25 years, and is without doubt the core financial modelling training in your career portfolio. Whether you have an upcoming financial modelling test for a new job or an APC exam, the Real Estate Analyst course is the choice for you.

Real Estate Analyst (Investment Cash Flow Modelling in Excel)
Delivered in person or Online + more
£1,750

DEI Masterclass - Bringing The DEI Playbook To Life!

By Starling

This one day masterclass is designed to provide a practical application of the content that is covered within The DEI Playbook and is aimed at anyone tasked with launching and implementing diversity and inclusion within their organisation.

DEI Masterclass - Bringing The DEI Playbook To Life!
Delivered in Nottingham + 1 more or Online + more
£495

CertNexus Certified Cyber Secure Coder (CSC-210)

By Nexus Human

Duration 3 Days 18 CPD hours This course is intended for This course is designed for software developers, testers, and architects who design and develop software in various programming languages and platforms, including desktop, web, cloud, and mobile, and who want to improve their ability to deliver software that is of high quality, particularly regarding security and privacy. This course is also designed for students who are seeking the CertNexus Cyber Secure Coder (CSC) Exam CSC-210 certification Overview In this course, you will employ best practices in software development to develop secure software.You will: Identify the need for security in your software projects. Eliminate vulnerabilities within software. Use a Security by Design approach to design a secure architecture for your software. Implement common protections to protect users and data. Apply various testing methods to find and correct security defects in your software. Maintain deployed software to ensure ongoing security... The stakes for software security are very high, and yet many development teams deal with software security only after the code has been developed and the software is being prepared for delivery. As with any aspect of software quality, to ensure successful implementation, security and privacy issues should be managed throughout the entire software development lifecycle. This course presents an approach for dealing with security and privacy throughout the entire software development lifecycle. You will learn about vulnerabilities that undermine security, and how to identify and remediate them in your own projects. You will learn general strategies for dealing with security defects and misconfiguration, how to design software to deal with the human element in security, and how to incorporate security into all phases of development. Identifying the Need for Security in Your Software Projects Identify Security Requirements and Expectations Identify Factors That Undermine Software Security Find Vulnerabilities in Your Software Gather Intelligence on Vulnerabilities and Exploits Handling Vulnerabilities Handle Vulnerabilities Due to Software Defects and Misconfiguration Handle Vulnerabilities Due to Human Factors Handle Vulnerabilities Due to Process Shortcomings Designing for Security Apply General Principles for Secure Design Design Software to Counter Specific Threats Developing Secure Code Follow Best Practices for Secure Coding Prevent Platform Vulnerabilities Prevent Privacy Vulnerabilities Implementing Common Protections Limit Access Using Login and User Roles Protect Data in Transit and At Rest Implement Error Handling and Logging Protect Sensitive Data and Functions Protect Database Access Testing Software Security Perform Security Testing Analyze Code to find Security Problems Use Automated Testing Tools to Find Security Problems Maintaining Security in Deployed Software Monitor and Log Applications to Support Security Maintain Security after Deployment

CertNexus Certified Cyber Secure Coder (CSC-210)
Delivered Online
£2,085

ITIL© 4 Foundation

By Nexus Human

Duration 3 Days 18 CPD hours This course is intended for This course is designed for anyone who needs an understanding of IT Service Management to help deliver better value to customers. It is appropriate for all IT staff and management, as well as customers who work closely with IT to support business requirements. This course is also designed for students who are seeking the ITIL© 4 Foundation certification and who want to prepare for ITIL© 4 Foundation exam. Overview By the completion of this course, you will have a deep understanding of the 7 Guiding Principles, 4 Dimensions of Service Management, 34 ITIL© Practices, and the new Service Value Chain that incorporate the core of ITIL© version 4. ITIL© is the world?s leading best practice framework for implementing IT Service Management. ITIL version 4 introduces IT Service Management through the lens of a Service Value System (SVS), which provides a holistic end-to-end view of how to successfully contribute to business value, and also how to leverage concepts from models such as Lean IT, Agile, DevOps and Organizational Change Management. This foundational course immerses you in the guiding principles, dimensions, and practices of ITIL© 4. This course will earn you 21 PDUs. This class includes an exam voucher. 1 - ITIL 4 OVERVIEW Introduction to ITIL Key Concepts of ITIL 2 - The ITIL Framework The Four Dimensions of Service Management The ITIL Service Value System 3 - The ITIL Guiding Principles Focus on Value Start Where You Are Progress Iteratively with Feedback Collaborate and Promote Visibility Think and Work Holistically Keep It Simple and Practical Optimize and Automate 4 - THE ITIL SERVICE VALUE SYSTEM (SVS) Governance The Service Value Chain Continual Improvement 5 - Key ITIL Practices Continual Improvement Service Level Management Change Control Incident Management Service Request Management Service Desk Problem Management 6 - Other ITIL Practices General Management Practices Service Management Practices Technical Management Practices

ITIL© 4 Foundation
Delivered Online + more
£1,695

55399 Implementing and Managing Microsoft Intune

By Nexus Human

Duration 3 Days 18 CPD hours This three-day instructor-led course is aimed at modern device management professionals looking to manage their enterprise devices using Microsoft Intune. This course will cover Enrolment, Application Management, Endpoint Security and Windows Autopilot as well as Azure Active Directory Conditional Access and Identity Protection. The delegates will learn how to enroll devices, deploy applications and manage them to maximize user productivity and device security. 1: Introduction to Microsoft Intune Mobile Device Management Microsoft Intune Azure Active Directory AAD Identity Protection AAD Conditional Access 2: Microsoft Intune Device Management Enrolling Devices Device Compliance Device Profiles Device Updates 3: Microsoft Intune Application Management Application Management Deploying Applications Application Configuration Managing Applications Policy Sets and Guided Scenarios 4: Microsoft Intune Endpoint Security Security Baselines and tasks Antivirus Disk Encryption Firewall Atack Surface reduction Endpoint detection and response Account Protection 5: Deploying Windows with Windows Autopilot Windows Autopilot overview Preparing for Windows Autopilot deployment Deploying Windows 11 using Windows Autopilot 6: Microsoft Intune Additional and Premium Features Remote Help Tunnel for Mobile Application Management Endpoint Privilege Management Advanced Endpoint Analytics Additional course details: Nexus Humans 55399 Implementing and Managing Microsoft Intune 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 55399 Implementing and Managing Microsoft Intune 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.

55399 Implementing and Managing Microsoft Intune
Delivered Online + more
£1,785

55133 PowerShell for System Center Configuration Manager Administrators

By Nexus Human

Duration 3 Days 18 CPD hours This course is intended for This course is intended for IT professionals who need to manage the day-to-day environment of an SCCM 2012 SP1 or newer environment. Knowledge of the workings of a standalone primary SCCM site and basic PowerShell experience is recommended. Overview Create additional site system roles on existing or new servers. Modify high level site settings. Create and modify Discovery Methods, Boundaries and Boundary Groups. Create Collections using any of the membership rules available. Delegate authority through Roles and Scopes. Install the Configuration Manager client, modify client settings and restrict access to site systems. Deploy software to clients. Deploy software updates to clients. Configure compliance settings targeted against collections. Modify settings that govern monitoring functions such as Alerts and Status Settings. Work with Task Sequences for Operating System Deployment. Write basic PowerShell scripts using cmdlets learned and scripting constructs to accomplish configuration tasks. This course provides students with the knowledge and skills needed to use PowerShell for System Center Configuration Manager (SCCM) administration. In this course, students learn how to access the PowerShell cmdlets included with SCCM 2012 R2 and use them to perform configuration tasks for a primary site. Individual cmdlets will be used in working with objects such as Boundaries, Boundary Groups, Collections, Software Deployment, Patching, Compliance Settings, OSD Task Sequences, and many others. Basic scripting will also be covered so that students can learn how to put PowerShell to use when working with large sets of objects. Prerequisites Basic Windows and Active Directory knowledge. Conceptual knowledge of Configuration Manager objects and how they interact. Basic experience performing configuration tasks in ECM using the graphical console. Experience working from a command prompt. Basic knowledge of the fundamentals of Windows PowerShell. 1 - REVIEW OF SYSTEM CENTER CONFIGURATION MANAGER CONCEPTS Architecture of an System Center 2012 Configuration Manager Installation Managing Assets Content Delivery and Management Security, Monitoring, and Remote Management 2 - MANAGING RESOURCES Implementing Discovery Organizing Resources with Collections Working with Boundaries 3 - WORKING WITH CLIENTS Installing the Configuration Manager Client Managing Client Settings Managing Client Operations Monitoring Client Status 4 - DISTRIBUTING SOFTWARE Configure the Software Distribution Components Working with Distribution Points Creating Content for Distribution Deploying Software Applications 5 - UPDATING SYSTEMS WITH WSUS AND SCCM Integrating Configuration Manager and WSUS Managing Updates through Software Update Groups Creating and Deploying Update Packages Working with Automatic Deployment Rules 6 - HOW POWERSHELL CAN MANAGE COMPLIANCE SETTINGS Creating Compliance Settings Objects Deploying and Monitor the Baseline 7 - CONFIGURING OPERATING SYSTEM DEPLOYMENT OBJECTS Preparing the OSD Environment Working with Task Sequences 8 - WORKING AT THE SITE LEVEL Modify the Site Adding Site System Roles Adding a Secondary Site 9 - SECURITY AND MONITORING Configuring Role Based Administration Implementing Endpoint Protection Configuring Monitoring Options 10 - USING POWERSHELL SCRIPTING TO AUTOMATE SCCM TASKS Review of Scripting Constructs Introduction to the Configuration Manager WMI Classes

55133 PowerShell for System Center Configuration Manager Administrators
Delivered Online
£1,785

CompTIA Cloud Essentials+

By Nexus Human

Duration 3 Days 18 CPD hours This course is intended for The CompTIA Cloud Essentials+ Specialty certification is relevant to IT specialists, IT technical services specialists, IT relationship managers, IT architects, consultants, business and IT management, business process owners, and analysts. Overview Upon successful completion of this course, students will be able to: Learn the fundamental concepts of cloud computing. Learn the business aspects and impact of cloud computing. Differentiate the types of cloud solutions and the adoption measures needed for each. Identify the technical challenges and the mitigation measures involved in cloud computing. Identify the steps to successfully adopt cloud services. Identify the basic concepts of ITIL and describe how the ITIL framework is useful in the implementation of cloud computing in an organization. Identify the possible risks involved in cloud computing and the risk mitigation measures, and you will also identify the potential cost considerations for the implementation of cloud and its strategic benefits. Students will weigh the pros and cons of cloud computing to make effective decisions and meet IT challenges. 1 - Understanding Cloud Computing Concepts Topic A: Understand Basic Cloud Concepts and Terms Topic B: Identify Cloud Network and Cloud Storage Technologies Topic C: Recognize Cloud Design Aspects 2 - Applying Cloud Business Principles Topic A: Relate Cloud Concepts to Business Principles Topic B: Establish Cloud Vendor Relations Topic C: Distinguish the Financial Aspects of Engaging a Cloud Service Provider Topic D: Report Financial Expenditures 3 - Advising a Cloud Design and Migration Topic A: Relate Cloud Concepts to Cloud Design and Migration Topic B: Use Cloud Assessments Topic C: Manage Cloud Design Topic D: Compare Cloud Migration Approaches Topic E: Identify Benefits and Solutions of Cloud Services 4 - Operating in the Cloud Topic A: Relate Cloud Concepts to Technical Operations Topic B: Identify the Technical Aspects of Cloud Operations Topic C: Understand DevOps in the Cloud Topic D: Explain Cloud Security Concerns, Measures, and Concepts 5 - Managing Cloud Governance Topic A: Relate Cloud Concepts to Governance Topic B: Apply Risk Management Concepts Topic C: Understand Compliance and the Cloud Topic D: Manage Policies and Procedures for Cloud Services 6 - Appendix A: Mapping Course Content to the CompTIA Cloud Essentials+ (Exam CLO-002) 7 - Appendix B: CompTIA Cloud Essentials+ (Exam CLO-002) Acronyms 8 - Glossary 9 - Index Additional course details: Nexus Humans CompTIA Cloud Essentials Plus Certification (Exam CLO-002) 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 CompTIA Cloud Essentials Plus Certification (Exam CLO-002) 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.

CompTIA Cloud Essentials+
Delivered Online
£1,485

DP-080T00 Querying Data with Microsoft Transact-SQL

By Nexus Human

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.

DP-080T00 Querying Data with Microsoft Transact-SQL
Delivered Online
£1,190

Educators matching "CPD"

Show all 40
Fortius Pe

fortius pe

Bristol

Fortius PE offers an all-inclusive PE Consultancy programme to help you develop Physical Education and Sport in your school. Here are some of the areas we can help with: Bespoke CPD – For all your staff on your premises; staff meeting on implementing the new curriculum, AfL and any area of PE you need help with (e.g. SEN inclusion, challenging and identifying G&T), followed up with in-lesson support and ongoing observations/learning walks. Pre-Ofsted Subject Inspections – Impact analysis of PE funding; lesson observations; provision of PE and sport across the school; provision for all. Early Years Physical Development – Practical advice on how to embed physical development in the early years to ensure all your under five’s are getting the recommended* 180 minutes physical activity daily (*CMO Start Active, Stay Active 2010). Audit of PE Resources – Are your teaching resources up to date, on hand and useful? Or, do they need updating? We can recommend the newest and most up to date SOW which doesn’t need to cost a lot but will have a BIG impact on the teaching and learning in your school. Action Plans and Impact Analysis – What effect is the new PE funding having in your school? We will help you audit your provision and write a focused, meaningful & quantifiable action plan addressing the needs of your school. Swimming Provision – Are your pupils being well served in their lessons? We can accompany your teachers to the lesson and assess what if any, improvements need to be made to ensure ALL children attain 25m by the end of KS2. Intra School Competitive PE Programme – Help with designing a workable competitive programme on intra-school competition to enhance and extend your PE and school sport provision. Develop Healthy Lifestyles for All – Reaching out to provide healthy active lifestyles for all. We will help you set up a long-term programme of fun, physical interventions which will have a real impact on the disengaged children.