40670 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 workshop seeks to demystify the intricate world of business funding, equipping you with the knowledge and strategies needed to secure the resources your established and growing business needs and deserves.

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)

A standalone 10-week quilling course - 2 hours per week online with daytime and evening options - that will introduce you to the materials, tools, and techniques used in quilling and to Craft4Smiles C.I.C and our tutors. At the end of each session you will have a lovely quilled item to show family and friends or to display on your shelf! All materials and equipment needed will be supplied and are yours to keep. This course is helpful for those for whom English is not their native tongue as there is a lot of repetition of basic terms including numbers, colours and directions.

This expert-led training course will provide you with a comprehensive understanding of the role of the designated governor for mental health and wellbeing.

Each week, participants will have the opportunity to gain invaluable insights, and hone their craft through immersive learning experiences.

Bristol Fencing Club Adult (14+) Beginner Course

This module aims to develop knowledge and understanding of the importance of customs documentation in the world of international trade to ensure both parties clearly understand the documentation that will be required in the import or export of goods or services.

QA Level 3 Award In First Aid At Work (RQF) Three-day course Gives learners the knowledge and skills to be a first aider Recommended by HSE for high risk workplaces Course Contents: The Roles and Responsibilities of an Emergency First Aider Assessing an Incident Minor Injuries Cuts, Grazes and Bruises Minor Burns and Scalds Managing an Unresponsive Casualty CPR Safe Use of an AED (Automated External Defibrillator) Choking Seizures Wounds and Bleeding Shock Eye Injuries Angina Heart Attack Stroke Asthma Diabetes Anaphylaxis Head Injuries Spinal Injuries Chest Injuries Fractures Sprains, Strains and Dislocations Poisoning Benefits of this course: 1.1 million workers in Britain had an accident at work in 2014/2015 Of those, 2,700 were from the East Midlands On average, one out of every 370 people received an injury at work The estimated cost of injuries and ill health last year was £15 billion The Health and Safety (First Aid) Regulations 1981 require all employers to make arrangements to ensure their employees receive immediate attention if they are injured or taken ill at work. This includes carrying out a risk assessment, appointing a suitable amount of first aiders and providing adequate first aid training Typically, first aiders will hold a valid certificate in either First Aid at Work (FAW) or Emergency First Aid at Work (EFAW) Our QA Level 3 Award in First Aid at Work (RQF) - FAW - training course is the one recommended for first aiders in a high risk workplace Having the correct first aid provision in the workplace is not just a legal requirement, it is incredibly important for the safety of all members of staff! As this is a Regulated Qualification, employers can book this course for their employees in the safe knowledge that they have fulfilled their legal responsibilities for providing quality first aid training, without having to undertake any lengthy due diligence checks Accredited, Ofqual regulated qualification: Our First Aid at Work (FAW) course is a nationally recognised, Ofqual regulated qualification accredited by Qualsafe Awards.This means that you can be rest assured that your First Aid at Work Certificate fulfills the legal requirements and is a very good way to make sure you and your employees are trained in First Aid, having the ability to save lives should the situation occur.The Ofqual Register number for this course is 603/2384/X

Learners will be introduced to the design, installation, commissioning, and maintenance of Access Control systems.