816 Courses delivered Live 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.

For those who are working towards GCSE maths exam confidence Save Your Child’s Spot in the GCSE Foundation maths Paper 1 Workshop Concerned about your child’s struggle with math concepts and word problems? Worried about them answering complex problems under time pressure? Want them to be exposed to the type of exam-style questions they'll need to master? Our engaging course doesn’t just teach numbers; Our Maths courses build confidence. Meet Shola, our GCSE Maths Expert! I specialise in tutoring students of all abilities in the following areas: foundation to higher GCSE maths, and general maths tuition for key stages 3 and 4. Lessons are tailored to my students by further developing their understanding of mathematical concepts as well as delivering lessons based on current needs and upcoming course materials. My role as Head of Year means that I oversee the pastoral support of students in my year group so that learning at every level of the individual is supported. I am a qualified Designating Safeguarding Lead Level 3 which means that I have practical knowledge and skills to protect the welfare of students and to take action when necessary. Course Objectives: - Revision techniques so there's less cramming + more confidence - Main concepts are reviewed for Number, Algebra, Geometry, and Data Handling - Review of past papers for Paper 1 to gain exposure to exam terminology + formating - Exam techniques to ensure no stress in a time pressure situation and top tips to avoid common errors that students fall into! We transform GCSE Maths exam prep from a challenge to an exciting adventure, helping your child become a resilient and prepared student. Mathematics can be a battleground for many students, especially when faced with word problems. We understand the fear of numbers, the confusion with algebra, and the frustration of not being able to solve real-world math challenges. Key Details: Duration: 3 hours Official Lesson Start Date:TBD during Feb Half term Maths Focus Areas: Paper 1 Foundation Group Size: Max 15 Recorded! For Just £97  Students who work with Bettering Youth tutors improve by a minimum of 2 grades; we have a 100% pass rate! What our families have to say: "Think it all went very well today. Shola seems very nice. Spoke with her briefly at the end of the lesson." "Sarahlynn has been nothing but a source of strength and encouragement for my daughter Ella. After struggling with confidence at school and feeling embarrassed to put her hand up in class, she was falling behind. Since Sarahlynn has been working with her, she has gone up a Math set and has become noticeably more relaxed in social settings. We couldn’t be more proud."

Our Team Leader Programme is designed specifically for new & existing Team Leads & Managers in Healthcare, such as General Practice, Primary & Secondary Care. This programme gives delegates the opportunity to spend time with peers, gain new tools & techniques that enable them to develop & support their team effectively. Building confidence to be able to have more proactive & challenging conversations with team members, supporting managers and reducing escalation.

Tea 'N Chat free event - Talk with Textile Artist and Teacher LINDA HARVEY

Understand the needs of children who have a parent with a mental illness in this DfE-assured course for Senior Mental Health Leads.

Elevate Your Learning Journey with HRB Education - Where Potential Meets Excellence

This course provides the delegate with the theoretical and practical skills to undertake non-licensed works with ACM's. Persons requiring this type of training would include trade operatives undertaking tasks with ACM's as defined in HSG210 and in accordance with CAR 2012 Reg 3(2). In addition to the Asbestos Awareness, those employees whose work will knowingly disturb ACMs, and which is defined as non-licensable work or NNLW, should receive additional task-specific information, instruction and training.

We are delighted to share that we are now running our GP Admin Development Programmes Live Online! If your team have had enough of pre-recorded courses then this is perfect!  We are delivering the content online - Live!  Teams can get involved, interact with each other, and have great discussions. We deliver a suite of programmes to support the development pathway of GP admin staff.  Just £79+vat pp for a half day workshop with resources. The first in the series is: Positive & Proactive Communication for Effective Call Handling This workshop will provide an opportunity to look at how we positively communicate with others - taking into account patients expectations, stereotypes, our role, and how to have the best interactions! We add value by discussing the importance of their roles, exploring how change impacts us and patients, and how we can choose to respond. We couple this with a deeper exploration of communication techniques that leads to a greater understanding of how we can communicate using positive intention & language. It's suitable for all staff (new and more experienced). We also encourage the line manager to participate so that they can follow up on the content using our manager support pack - enabling staff to sustain and embed the learning. The programme will cover the following: The Heart Of The Surgery Changes & Choices Patient Experience Effective Communication Managing Other’s Emotions & Challenging Patients Importance of Signposting Keeping Motivated Creating New Habits We will be running multiple dates so that you can enrol small groups of staff any one time, leaving you enough people to man the helm!If you have any questions then please do get in touch,lucy@thedevelopmentpeople.co.uk

Building High-Performance Teams: In-House Training This course pulls together the most current and popular theories and writings on this complex topic and presents this amalgamated view in a highly interactive workshop and activity-based approach. Students will understand and have the skills required to build and participate in high-performance project teams and will possess the insight to proactively affect change within their respective organizations by guiding the existing culture to one that promotes high performance. What you will Learn At the end of this program, you will be able to: Define a team and describe the optimum team size for effective performance Describe characteristics and guiding behaviors of high-performance teams Describe the major elements of each development stage in two distinct models Recognize cultural barriers in achieving high performance List the attributes of a high-performing corporate culture Assess your own corporate culture Discuss corporate leadership as a factor in building high-performance project teams Describe the three A's of selecting team members State three leadership responsibilities Describe leadership responsibilities, styles, and roles List and describe the eight components of the team charter model for building high-performance teams Foundation Concepts The Nature of Teams Characteristics of High-Performance Teams Understanding Team Development Stages of Team Development - Model 1 Stages of Team Development - Model 2 Designing a High-Performance Culture Corporate Cultures Corporate Leadership Establishing the Attributes of High Performance Choosing the Right People Team Effectiveness Team Leadership The Team Charter Model

Have you always been intrigued by dreamcatchers and want to learn the art of weaving your own, or do you know someone who loves them and want to gift them one? This ancient art is has gone through a lot of morphism and yet the old techniques are still here as always. Learn to weave a traditional dreamcatcher.