19138 Basic courses

Enhance your clients natural lashes lasting up to 6 weeks!  Suitable for: Complete beginners TIME: 10am - 4pm Models: Minimum of 2 live models What's covered: Introduction to lash lift & tint Health & safety & hygiene Skin analysis Anatomy of the eye Lash mites Hair growth & anatomy Check list Contraindications Pre/post treatment advice Equipment and products Consultation Application Trouble shooting And so much more! Extra's: Follow up call to find out how your getting on and any questions you may have Small classes (4 maximum) Basic business start up support Social media tips Ongoing support

This Practical SQL course, is designed make you fully conversant with queries, DML and DDL statements. Hands-on, Practical SQL course. You will get the PCWorkshops SQL Course Certificate. Max 4 people per course, to keep it personalised.

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.

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.

Duration 5 Days Certificate Validity 3 years Course Overview Embark on the journey towards the QA Level 3 Certificate in First Response Emergency Care (RQF), a nationally recognised qualification meticulously crafted for individuals carving a path in emergency services, ambulance operations, event and security medical sectors, or high-risk workplaces. Endorsed by The Faculty of Pre-Hospital Care – The Royal College of Surgeons of Edinburgh and meticulously aligned with the PHEM skills framework at descriptor level D, this qualification serves as a cornerstone for diverse roles in emergency care. Whether you aspire to be an Event Medical Responder, Emergency Care Support Worker, or beyond, this qualification opens doors to a realm of possibilities. Furthermore, the QA Level 3 Certificate in First Response Emergency Care (RQF) seamlessly integrates into a progressive suite of prehospital care qualifications, paving the way towards the esteemed QA Level 6 Diploma in Paramedic Practice (RQF). What’s Covered Delve into the roles and responsibilities of a first responder Navigate through diverse medical emergencies Master the art of patient assessment Acquire proficiency in airway management Learn adult, child, and infant CPR & AED usage Understand Return of Spontaneous Circulation (ROSC) procedures Gain insights into emergency oxygen administration Handle traumatic injuries with confidence Manage catastrophic bleeding scenarios Address cases of shock effectively Navigate through incidents involving poisoning and intoxicating substances Tackle both external and internal bleeding situations Learn techniques for helmet removal Master neck, spine, and pelvic immobilisation procedures Understand and manage environmental exposure cases Address burns and scalds efficiently Learn to handle minor injuries Grasp the essentials of incident reporting Entry Requirements Participants must be at least 17 years old on the first day of training. No additional formal entry requirements exist; however, learners are advised to possess a minimum Level 2 proficiency in literacy and numeracy or equivalent, along with a basic understanding of first aid concepts Course Information Venue: All our 'Open' courses are delivered from our dedicated training venue: Pulse South Coast Ltd, Bentley Wildfowl, Harveys Lane, Ringmer, BN8 5AF On occasion we may use a separate venue, this will be advised on the course booking. Facilities: On your course you will be provided with tea & coffee making facilities and biscuits. We are in a rural location so we recommend brining lunch with you on the day. There is a microwave & fridge on site for your use. There is a garage that is approximately a 10 minute drive from our venue. Parking: We have a dedicated car park that is approximately a 300m walk to the training venue. There is no additional cost to use this parking. We accept no responsibility for any personal loss or theft while you are on our training courses or premises. Please ensure to keep your personal belongings safe at all times. What is required from you: All courses are delivered in English, you must have a basic understanding of the English language to attend. There is a requirement for you to show that you are capable of performing the skills you are taught on the course, due to this you will need to be physically able to demonstrate all practical elements of the course. Dress: As a company we pride ourselves on running immersive & practical training courses. You will often be expected to kneel & work outdoors, please dress appropriately. Identification: As we deliver Ofqual accredited courses, there is a requirement for you to show a form of ID on the first day of the course. This could be; a driving license, passport or something that clearly shows who you are. Timings: All of our courses have a minimum training time of six hours a day, we will often advertise a course as seven hours to include break times. On occasion it is required to go over the scheduled times, however this will always be discussed with the group on the day. Trainer: During your course you will have a designated trainer for the duration. They are there not only to assess for the qualification, but to offer you guidance and support throughout. Security: We accept no responsibility for any personal loss or theft while you are on our training courses or premises. Please ensure to keep your personal belongings safe at all times.

As a qualified homeopath of 5yrs, I've put together a brilliant offer for newly-qualified homeopaths who know all about remedies but almost nothing about running a successful, busy homeopathy practice. Very limited spaces, and the last time it will be this cheap before prices go up. You'll get a mix of group learning and direct access to me (learning from my mistakes so you don't have to waste time and money on making the same!).

Basic Python syntax and principles of Object Orientated Programming. Most attendees are in-work IT Professional. Private individuals are also very welcome. Evening courses also running. Our Style: Hands-on, Practical Location: Online, Instructor-led Download: anaconda.com Duration: 6 weeks, 1 evening per week, 6pm - 8pm Times: arrange a time for your time zone

This Excel Introduction course is a very good introduction to essential fundamental programming concepts using Excel as programming language. These concepts are daily used by professionals and are essential in most jobs. By the end, you'll be comfortable with Excel concepts, ribbons, formulas, and the Functions Wizard. You will gain hands-on practical experience creating a spreadsheet from scratch on your own.

Online webinar aimed at newcomers and beginners to road rallying helping to learn the basics.

SQL Queries Course, 1-Day. Basic SQL syntax. This course is good for any database, covering standard SQL. Most attendees are in-work IT Professional. Private individuals are also very welcome.