20359 Addition courses

We deliver CSCS approved courses from the Base Business Space in Hull throughout the week. We also have access to a onsite CITB Test Centre! We have been supporting clients gain a CSCS Labourers and Skilled cards for over 10 years!

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.

#cpc #cpcexam #driver_training #drivertraining #grantham #hgv #lincolnshire #training_course #transport #transportmanager

#cpc #cpcexam #driver_training #drivertraining #grantham #hgv #lincolnshire #training_course #transport #transportmanager

Self-help and relaxation skills and exercises for stressed, burned out SEN parents and carers

LOOKING FOR: ADULT FICTION Sarah Williams is a Director of the Sophie Hicks Agency which she joined in 2014 and she has worked as a literary agent for over 10 years. Sarah represents a wide range of adult fiction and non-fiction and as she runs the film and television side of the agency, she is particularly interested in books that have screen potential. She is looking for literary fiction, reading group fiction, memoir and lifestyle/personal development - basically any book that can surprise, change and challenge a reader. Recent favourites are Tides by Sara Freeman, The Paper Palace by Miranda Cowley Heller, Early Morning Riser by Katherine Heiney and In The Dream House by Carmen Maria Machado. Sarah would like you to submit a covering letter, 1 page synopsis and the first 20 - 30 pages of your manuscript in a single word document. (In addition to the paid sessions, Sarah is kindly offering one free session for low income/under-represented writers. Please email agent121@iaminprint.co.uk to apply, outlining your case for this option which is offered at the discretion of I Am In Print).  By booking you understand you need to conduct an internet connection test with I Am In Print prior to the event. You also agree to email your material in one document to reach I Am In Print by the stated submission deadline and note that I Am In Print take no responsibility for the advice received during your agent meeting. The submission deadline is: Tuesday 19 November 2024

Want to make electric lamps, but not sure about the wiring, regulations and so on? If you can make the lamp base (in clay, wood, glass metal or whatever), then this course tells you how to do the rest.

Duration 1 Days 6 CPD hours This course is intended for This course is intended for people who use PowerPoint for their business communication needs. Overview To ensure your success in this course, you should have end-user skills with any current version of Windows, including being able to open and close applications, navigate basic file structures, and manage files and folders. This course is intended for those who wish to take advantage of the application for high quality business presentations and reports. Presentations Create Attractive Presentations from Existing PowerPoint Templates Creating Presentations Quickly using Outline to build a Structure Incorporating and reusing slides from other presentations into your own Templates and Customization Using Slide Layouts Using the Slide Master Creating Custom Slide Layout Working with Charts and Tables Create and Modify Tables Create Charts and Graphs Copying Charts into PowerPoint Link Vs Embed Add Visual Elements to a Presentation Create and Modify Shapes Add Images Create SmartArt to Make Easily Modifiable graphics Use SmartArt to Give Dull Text a More Visual Appeal Working with Media and Animation Add Audio to A Presentation Add Video to A Presentation Add and Customize Animations Add and Customize Transitions Preparing to Present Add Notes to A Presentation Presenter View And Slide Show Controls Create A Custom Slide Show Saving and Sharing the Presentation Printing Options and Handouts Additional course details: Nexus Humans Microsoft PowerPoint for the Business User 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 Microsoft PowerPoint for the Business User 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.

Best MS (Microsoft) Project Beginners Courses in London, England! This one-day Microsoft Project Beginners Course is designed to cover the concepts of creating, scheduling, baselining and tracking projects using Microsoft Project. We cover all versions of Microsoft Project, instructor-led, classroom-based, practical, and hands-on. We offer the classes on a one-to-one basis, but group sessions are scheduled on request.

The WSET Level 2 Award in Wines has full accreditation from OfQual as a Level 2 Vocational Qualification. Through a combination of tasting and theory you will explore the factors that impact the style and quality of wine and learn how to describe wines with confidence. Course Schedule: The 8 x 2-hour online sessions on -  What the course covers Wine tasting: You will learn how to taste and describe wines using the WSET Systematic Approach to Tasting (SAT) Food and wine pairing: You will learn the principles of food and wine pairing Wine service and storage: You will learn the correct way to store and serve wine and how to recognise common faults found in wine Labelling: You will learn how to decode and understand wine labels Factors influencing the style of wine: You will explore how environmental factors, grape-growing, vineyard and maturation options influence the style and quality of the wines made all over the world Grape varieties: You'll learn about the styles of wines produced by the key international red and white grape varieties (Chardonnay, Pinot Grigio, Sauvignon Blanc, Riesling, Cabernet Sauvignon, Pinot Noir, Merlot and Syrah/Shiraz) as well as the styles of wines made with 22 regionally important grape varieties grown in 70 wine regions (GI's) around the world Sparkling and Fortified wines: You will be taught how grape varieties and winemaking processes influence the style of wines in these two key wine categories. No prior wine knowledge is required however the course builds upon the WSET Level 1 Award in Wines course. It is not essential to complete Level 1 to join the Level 2 course but if you are a complete begineer you may wish to consider this option. We recommend you read the course specification document HERE for full details of the content, structure and assesment criteria. Any questions please get in touch. Course delivery The Level 2 Award in Wines online course covers the same syllabus as the classroom course and is delivered in LIVE interactive online lessons by one of our certified wine educators This course includes 16 hours online tuition in 8 x 2hr sessions and we recommend a minimum of 12 hours additional study Your tutor will give you a guided tasting of 12 wines on this course (for details of how to order the wines see below) You will receive access to practice multiple-choice revision questions specific to this course - FREE OF CHARGE Please note a reliable broadband connection is essential for the completion of this online course as are basic computer skills. Examination To obtain the WSET Level 2 Award in Wines Qualification, you will need to successfully pass the exam. The exam is made up of 50 multiple-choice questions to be completed in 1 hour. A mark of 55% is required to pass the exam. The exam is taken online via a Remote Invigilation service giving you the flexibility to take the exam at a time and date of your choice. More details will be sent upon registration. Please ensure you read the information HERE if you wish to take the exam online.  Whats included All WSET course materials posted to you at no extra charge including: Looking Behind the Label course manual, Study Guide, specification and SAT Tasting Card LIVE virtual interactive sessions taught by a Local Wine School WSET Certified Tutor Exclusive access to practice multiple choice questions provided FREE OF CHARGE WSET exam fee Remote Invigilation service Internationally recognised WSET qualification, certificate and pin for those who pass the exam VAT at 20% (VAT receipt can be provided on request) Course Wines It is recommended that at least 12 wines are tasted as part of this course, although this is optional and the cost of wines is not included in the course fee above. Our wine experts have specially selected wines for this course designed to demonstrate specific learning outcomes. We have negotiated a discounted price only available to our online students. Details of how to order your case of wines will be provided when you book your place. The cost is approx £150 including VAT and delivery.  Wine preservation advice is give so that after each tasting exercise you can reseal and return to the wines over the coming days. Special Educational Needs Please make the school aware if you have a condition which may mean that you will qualify for additional help during the exam such as dyslexia. Important dates Registration deadline: please book at least 5 days before the start of the course, to allow time to send materials and order the tasting wines.