30971 Courses

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.

This 18 weeks Virtual Airline Cabin Crew course delivered via Zoom. Lessons scheduled for once a week, evenings from 6:30pm to 9pm. 98% Employment rate after completion of the course. Virtual Airline Cabin Crew which is also known as Air Hostess, Flight Attendant and Stewardess course – Join your lesson from wherever you are.  This intensive 18 weeks Virtual Airline Cabin Crew course designed for candidates who wish to: Travel the world and be paid for it Work in a friendly, collaborative atmosphere, 5000 metres above the sea level Build a global network This glamourous and exciting job requires lots of training and energy. Behind the beautiful smile of each flight attendant, stands a highly trained and skilled person who can deal with unforeseen situations on board.  98% Employment rate after completion of the course. How will you learn? Apart of our traditional class-based tuition, we also offer Virtual Learning courses. On our Virtual (live stream via Zoom) lessons, we provide the same quality of tuition as in the classroom. You only need a laptop, PC or tablet with either built in (or external) camera and microphone. The virtual platform is very interactive with a sense of real classroom at the Academy. You will study from the comfort of your own home and communicate with your tutor and classmates via video chat (by using your phone or computer camera) and you will receive outstanding tuition, qualification, and certification. We provide A-Z guidance starting from before and after the course. Your tutor will guide you through the online course to graduation which you will be welcome to attend. What a joy it would be to meet your tutor and classmates in real life!! You will have: According to the timetable- 1 lesson per week for 18 consecutive weeks. Exams and final exam based on which the certificate will be issued. On successful completion you will hold: Airline Cabin Crew certificate in Current Airline Training Standards and Equipment. Individual support on the journey from the course to a job placement Receive constant updates on recruitment and news from Aviation the world We will enhance your CV Full support on your job application process Gain an insight into the airline selection process and final one-to-one interview What is Flight Attendant? Flight attendant/Airline Cabin Crew/Stewardess/Air Hostess are the most visible, glamorous jobs of all airline employees. A Flight Attendant is someone whose primary duty is to ensure the safety and comfort of passengers during a flight. They are members of an aircrew team , who operate a commercial, business or even military aircraft while travelling domestically or internationally.  Flight Attendant benefits: Getting paid for travelling the world Lifestyle Flexible Work Schedules Meeting Interesting People Free Food & Accommodation Excellent Compensation The uniforms Working Environment How to become successful Flight Attendant job candidate?Our Aviation Team understands each candidate who wish to become Airline Cabin Crew or start a career in Aviation. Airline companies look for individuals who share their values and can act as ambassadors for the company’s brand. Cabin Crew are the face of the airline company which means they deliver a fantastic service that makes airline world famous. Airline companies prefer candidates with knowledge of Cabin Crew role. Airline companies have selection day or online tests as a first stage of recruitment, after which, they will take a closer look at applicants CV, skills and experience. If you completed Airline Cabin Crew course, your application will stand out and you can get an offer from the first round.  Student – Cabin Crew Flying Support Group As a market leading Airline Cabin Crew Training Company with a wealth of experience in Aviation and recruitment, we constantly upgrading our course and going extra nautical mile to guide and support all our students to ensure they can reach their goals. Graduates who are already flying, offer their full support to us and new students. They share an insight of the airline they already fly with, and help new students through the process of joining them at that airline. It gives a flying start to a career to new learners.  Why London Waterloo Academy? Top Airline Cabin Crew course provider in London 98% Employment rate after completion of the course With years of experience in Airline Cabin Crew industry, London Waterloo Academy has been recognised by major TV, radio channels who have invited our Aviation Team for expert advice or interview. We are recognised by major airline companies in Europe and overseas who have approached London Waterloo Academy to deliver internal cabin crew training, corporate training and to recruit our graduates as a result of their high qualification standards and knowledge. Our graduates are now flying with Etihad, Saudi Air, Hainan Airlines, Small Planet, British Airways, Qatar, EasyJet, Thomas Cook, Ryanair, Cubana de Aviación, Air France,Titan, Norwegian B737 Short Haul and many more. The vast global experience of our instructors This course has been developed in accordance with EASA PART-CC Working together – Starting a new career isn’t easy and often it can seem like a lonely and impossible process. Our Aviation Department stays behind each learner, supporting every step of the way, we give you all the tools, skills and assistance you need to succeed. Our success, built on the success of our students and a long list of graduates with successful stories. Course Entry Requirements: English Language at B2 (CEFR) level or above. There are no other special requirements for this Airline Cabin Crew course. We will teach you from scratch and support after the course when applying for the job. This course has been developed for all candidates, independent of their background, wishing to start a new career.  Dates (choose one for your course): 14 March 2024 – 11 July 2024, Thursday classes 10 June 2024 – 7 October 2024, Monday classes 17 September 2024 – 14 January 2025, Tuesday classes 18 November 2024 – 17 March 2025, Monday classes Course duration – 18 weeks Classes – once a week Lesson Time – 6:30pm to 9pm – GMT (London time) Course fee – £529 (we offer flexible payment plan and accept weekly instalments) Registration fee – £300 (includes: examination, Airline Cabin Crew certificate in Current Airline Training Standards and Equipment)

The Emergency Fist Aid at Work is an accredited 1 day, instructor led course in a fully equipped training room. We use a mixture of training methods such as hands on activities, role play, group discussion, games and the use of equipment / technology to cover the different learning styles of the individual. All learners will have the skills and knowledge to provide the organisation with Emergency First Aider’s that can provide treatment to their casualties in a prompt, safe and effective manner. A range of subjects are covered including:- • Responsibilities and reporting • Resuscitation and AED awareness • Burns • Assessment of the situation • Anatomy • Choking • Dealing with an unresponsive casualty • Minor injuries • Epilepsy • Basic hygiene in First Aid • Bleeding control • Shock Certification Practical assessment is ongoing by the instructor, and a three year qualification will be issued to those who satisfy the criteria. In addition, the HSE strongly recommend that all students undergo an annual refresher programme of three hours. Instructions Please can learners ensure they wear trousers and a full shoe. Learners need to be physically fit and well to undertake the activities for First Aid Training, which requires learners to carryout CPR on the floor. Directions Complete Training Somerset House, Sandal Castle Centre Asdale Road Wakefield WF2 7JE All training is carried out at our office (Somerset House, map is attached). Please note that we do not provide lunch so you will have to bring your own. Please do not park in the office car park as not all spaces belong to us. There is available parking in Asda and Aldi next door, or the public car park at either side of Square Pizza Amenities Rest Room Fridge on site Parking Toilets

An exciting 10-week course to build your Spanish skills from scratch. Practical applications for travel & conversation. Enlarge your vocabulary, improve your grammar in a pain-free, step-by-step way, working with a tutor with 10+ years' experience & a small group of learners.

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.

From propaganda to advertising, posters are a ubiquitous, powerful vehicle to take a message to the masses. Over four weeks, learn how to approach poster design in a creative and practical way. Although some computer work will be introduced, it will only be used as another production tool, participants will be encouraged to experiment with analogue techniques such as collage and hand-generated type. You will learn about the history of poster design; learn to use aspects of Adobe InDesign, Illustrator and Photoshop; develop approaches to letterform and layout. The emphasis of this course is on the development of a set of posters from research and design through to output. Week 1: History History of Poster Design: Looking at significant and famous posters from around the globe and their impact on society. Practical activity: After a quick introduction to InDesign we will recreate one of these posters, studying the component parts and their relationships to one another. Homework: Think of a concept for your design. What is it for? Who is your target audience? Where and how will it be displayed? Select a favourite poster to bring in or discuss with the group in week 2. Week 2: Image We will begin by discussing participant posters they have brought in to share and look at positives and potential negatives within the designs. Image selection can be a key factor to the success of your poster campaign. We will think about the choices between photography and illustration looking at examples of how this is done successfully. Think about the different ways we can generate and use images. Practical activity: Consider what medium the image might be and how it can be created. Learn about flatbed/film scanner for potential use in image creation. Week 3: Fonts We will look at how typography impacts designs and the messages that it can convey by itself. Consider various approaches to how we can generate type. How typographic selections work alongside selected images. Practical activity: Work through a few typographic workshops thinking about how typographic choices will alter the message you are trying to convey. We will consider various ways and techniques of creating type for our poster. Homework: Developing your typographic solution further, if required. Work through variations of layout. Week 4: Output Continue working on our posters making final tweaks and selecting the poster that is our most successful design for output. We will look at the various formats for output and how we prepare our posters for print. Look at usage of different poster sizes – why use one over the other?? Practical activity: Size your final poster and get it ready for output (if working analogue, scan final poster and upscale).   Courses are subject to minimum enrolment. Please register early, within five days of the start date, to reduce the likelihood of course cancellation. Please read our cancellation policy before booking. Students, anyone over the age of 65, and those in receipt of any form of benefits can claim the concessionary price, offering a 10% discount on the full course price. Valid proof of eligibility must be produced on the first day of the course. Please use the code CONCESSION when prompted at checkout.

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.

Description A spirited yoga practise to boost your energy, uplift your soul, and leave you feeling lit up from the inside out! Move better, breath better, and feel better for LIFE! This is an invigorating and energising mixed-ability yoga class designed to challenge you physically, make you sweat, and leave you with that blissed out post-yoga feeling! Options given to suit all levels of yoga experience - both beginner's and advanced students will find something to work on, from down-dog to handstands! Get strong, retrain habits, and get moving! Every class contains structured flowing movements interwoven with guided breath work. Challenge your strength, mobility, and fitness. Classes always end with svanasana - mindfulness-based guided relaxation, meditation, and massage to leave you feeling calm, grounded, and blissful. Carry that feeling over into your life, as you enjoy more energy, feeling more centred, and finding more strength and balance both on and off the mat. - Fantastic stress relief! - Improve your posture - Great mobility, strength, and balance training - Learn to move with confidence and prowess - Boost your energy! - Increase body-awareness, coordination, and mental focus - Feel more awake, more powerful, and more alive! Taught at the Hub on the Green - a beautiful calm and clean setting in the heart of Bournville. What style of yoga is it? Not all yoga is created equal! Roo teaches a modern style of yoga that has been developed by a physiotherapist and neurologist, providing movement education for both your body and your brain. This innovative method provides a smarter, safer, and more effective approach to yoga and movement. Working from the ground up with intelligent sequencing and emotional awareness, this movement practise is designed to retrain your habits, correct postural imbalances, and teach you how to hold yourself and move through space - so that you can stand tall, move with confidence, and feel empowered for LIFE! Come and feel the difference! First time? Use code TRYFOR5 to get your first drop-in class for only £5 🙂 Discounts for yoga teachers - get in touch to find out more! Option to drop-in (£11 per class) or book a 6 week block (£54). These are 6 consecutive classes, starting from the week you book them on. When there is a break (for example, over the summer), your 6 week block will be "paused" for the duration of the break, and start again when classes resume. There will be no refunds given for any classes missed within your block. Mats and yoga blocks are provided. Spaces are limited - pre-booking is strongly advised! Any remaining spaces will be allocated to walk-ins on the day on a first-come-first-served basis. If the room is full, I'm really sorry but you will be unable to join the class. So make sure you book! :D See you on the mat! Roo x

Description A spirited yoga practise to boost your energy, uplift your soul, and leave you feeling lit up from the inside out! Move better, breath better, and feel better for LIFE! This is an invigorating and energising mixed-ability yoga class designed to challenge you physically, make you sweat, and leave you with that blissed out post-yoga feeling! Options given to suit all levels of yoga experience - both beginner's and advanced students will find something to work on, from down-dog to handstands! Get strong, retrain habits, and get moving! Every class contains structured flowing movements interwoven with guided breath work. Challenge your strength, mobility, and fitness. Classes always end with svanasana - mindfulness-based guided relaxation, meditation, and massage to leave you feeling calm, grounded, and blissful. Carry that feeling over into your life, as you enjoy more energy, feeling more centred, and finding more strength and balance both on and off the mat. - Fantastic stress relief! - Improve your posture - Great mobility, strength, and balance training - Learn to move with confidence and prowess - Boost your energy! - Increase body-awareness, coordination, and mental focus - Feel more awake, more powerful, and more alive! Taught at the Hub on the Green - a beautiful calm and clean setting in the heart of Bournville. What style of yoga is it? Not all yoga is created equal! Roo teaches a modern style of yoga that has been developed by a physiotherapist and neurologist, providing movement education for both your body and your brain. This innovative method provides a smarter, safer, and more effective approach to yoga and movement. Working from the ground up with intelligent sequencing and emotional awareness, this movement practise is designed to retrain your habits, correct postural imbalances, and teach you how to hold yourself and move through space - so that you can stand tall, move with confidence, and feel empowered for LIFE! Come and feel the difference! First time? Use code TRYFOR5 to get your first drop-in class for only £5 🙂 Discounts for yoga teachers - get in touch to find out more! Option to drop-in (£11 per class) or book a 6 week block (£54). These are 6 consecutive classes, starting from the week you book them on. When there is a break (for example, over the summer), your 6 week block will be "paused" for the duration of the break, and start again when classes resume. There will be no refunds given for any classes missed within your block. Mats and yoga blocks are provided. Spaces are limited - pre-booking is strongly advised! Any remaining spaces will be allocated to walk-ins on the day on a first-come-first-served basis. If the room is full, I'm really sorry but you will be unable to join the class. So make sure you book! :D See you on the mat! Roo x

The NEBOSH National Diploma is designed to provide the underpinning knowledge for a professional career in health and safety. The course is suitable for both newly appointed safety practitioners and those with substantial experience who wish to obtain Chartered Membership of IOSH. It equips holders to advise on effective management of risk across the range of employment sectors.