• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

59728 Courses

FILM PRODUCTION COURSE

5.0(1)

By In2Drama

“Filmmaking is a chance to live many lifetimes” - Robert Altman Our Film Production Course is led by highly experienced videographer and cinematographer Max Jewell-Smith, and award-winning actor and producer Henry Hereford, who has been working in the industry for more than 20 years in the UK, Australia and the US. Henry is a producer with the production company, Fluffy Cat, who have worked on films such as For The Love Of George, To Leslie, and Well Behaved Woman, so he has plenty of unique insight to share with students. With a mix of technical skills, script writing and acting, students on our Film Production course will work together to create a short film that they will showcase on Friday. ‍ WHEN AND WHERE? The Film Production Course takes place in Cranleigh Arts Centre, around 20 minutes from Guildford. The venue has a professional theatre, a sprung dance floor for choreography sessions, dressing rooms, and lots of great areas for filming and multimedia activities, so it's the perfect spot for our aspiring performers to learn in. ‍ Monday 22nd - Friday 26th July 2023 In2Drama is split into two groups for age related focus 11-15 year olds: 1pm - 4:00pm 16-21 year olds: 9am - 12:00pm

FILM PRODUCTION COURSE
Delivered In-PersonFlexible Dates
£295

Heat Press Techniques for Textiles (COVENTRY)

5.0(4)

By Textiles Skills Centre

An Exciting Practical Face to Face Course working with a heat press, for anyone wanting to learn new textile skills and techniques.

Heat Press Techniques for Textiles (COVENTRY)
Delivered In-Person in Coventry
£215

L 3: Teacher Training (PTLLS) Course

5.0(2)

By Learn More Academy Ltd

PTLLS is a teacher training qualification for those new to teaching / training industry or wanting to start out as associate teachers, or currently teaching. Learn More Academy has been delivering the Level 3 Preparing to Teach in the Lifelong Learning Sector (PTLLS) or newly branded AET course. Level 3 Award in Education and Training (AET) course is designed to contribute towards the knowledge and understanding for Further Education National Training Organisation (FENTO) or the Employment National Training Organisation (EMPNTO) occupational standards in the United Kingdom. This course is designed for anyone wishing to enter in the adult training and teaching industry in this country and even some other country too. ABOUT THIS COURSE: The Level 3 Award in Education and Training AET (formerly known as PTLLS) is an introductory, knowledge based teaching qualification. It can be undertaken by individuals who are not yet in a teaching or training role (pre-service), or are currently teaching or training (in-service). This qualification is delivered on our online or classroom based learning platform with full tutor support throughout the course. UNITS COVERED: Chapter 1: The roles and responsibilities of a teacher / Trainer in education & Training Chapter 2: Relationships between education and training Chapter 3: Inclusive teaching approaches to meet the needs of learners Chapter 4: Principle of assessment in Education and Training Chapter 5: How to create a safe and supportive learning environment Chapter 6: How to motivate learners Chapter 7: Planning, delivery and evaluation of inclusive teaching and training Chapter 8: Different assessment methods Chapter 9: How to recognise and deal with potential problems Chapter 10: Teaching equipment and aids Chapter 11: Practical teaching sessions (Teaching concept and Technique) CAREER OPPORTUNITY: With this qualification you will be able in teaching any adult in the industry of varieties sectors such as Health Industry, Beauty Industry, NHS Trusts, various Police forces, Midwives, Librarians, Laboratory Technicians, HM Forces, Teaching Assistants, Higher Education Teaching Professional, Further Education Teaching Professionals, Secondary Education Teaching Professionals, Primary and Nursery Education Teaching Professionals, Special Needs Education Teaching Professionals, Security Industry, Teaching/Training, Educational Support Assistants, Education Advisers and School Inspectors, Veterinarians, Nurses, Care sector, First Aid sector, Care Instructor, Driving Instructors and many more. STUDY METHOD: You can complete this course either through Distance Learning / Online, Face to Face or Live zoom class. Level 3 AET distance learning course is done at your own pace with a Tutor’s support & guidance. All necessary materials will be sent to you with login details with student portal access, once you book the course. The entry requirement for this course are the basic functional skills (Numeracy, Literacy, ICT). You will be given up to 3 months to complete the assignments, however if you finish earlier, you will be awarded early, you do not need to wait for last minute. Within the 12 weeks, you need to do your micro-teach. FACE TO FACE OR LIVE ZOOM CLASS: We have 3 days Live Zoom or Face to Face classroom session from 10am to 5pm around the country. This course will be taught and trained by an experienced teachers, who will use a wide range of teaching activities; including lectures, group work, discussion, demonstrations, candidates presentations and many more activities that help learning. Micro Teaching session will be held on last day of the course where trainee teachers prepare and deliver a short teaching and learning session to their peers. After 3 days session you are required to complete the coursework/assignment and send them for marking, it takes 7-8 day to get the result and certificate. COURSE ASSESSMENT: There is no formal examination is required, but at the end of the course you need to submit a portfolio assignment. HOW MUCH THIS COURSE COST? Level 3 PTLLS/AET course will cost for Online Distance Learning £190.00, for Webinar Live Class £249.99, Classroom based course in London £269.99 and Classroom based in Outside London £299.99. There is no any hidden fees/cost.

L 3: Teacher Training (PTLLS) Course
Delivered Online & In-PersonFlexible Dates
£249.99 to £299.99

10 High Income Skills You Must Learn for Sustainable Passive Income Course

5.0(14)

By Training Express

10 High-income & Passive Income Skills Courses - Learn the Skills to Earn More Money Are you looking to learn the skills that will help you earn more money? If so, then the 10 High-income & Passive Income Skills Courses is for you. This bundle course includes 10 in-depth courses that will teach you the skills you need to succeed in today's economy. The courses included in this bundle are: Course 01: Digital Marketing Learn how to use digital marketing to reach your target audience and grow your business. Course 02: Cryptocurrency Learn how to invest in cryptocurrency and make money from the blockchain revolution. Course 03: Copywriting Learn how to write persuasive copy that will sell your products or services. Course 04: ChatGPT Learn how to use ChatGPT to create chatbots that can automate your customer service and marketing. Course 05: Content Marketing Learn how to create content that attracts and engages your target audience. Course 06: SEO - Search Engine Optimisation for Business Learn how to optimize your website for search engines so that more people can find you online. Course 07: Power BI Learn how to use Power BI to analyze data and make better business decisions. Course 08: Microsoft Exce Learn how to use Microsoft Excel to create spreadsheets, charts, and graphs. Course 09: Graphic Design Learn how to use graphic design software to create professional-looking designs. Course 10: Data Analysis Learn how to use data analysis techniques to extract insights from data. Key Features CPD Accredited Free PDF Certificates Lifetime Access No Hidden Fees This bundle course is perfect for anyone who wants to learn the skills they need to earn more money. Whether you're looking to start a new career, grow your business, or simply make more money on the side, this course has something for you. The courses are taught by experienced instructors who are experts in their field. They will teach you the latest techniques and strategies so that you can start using these skills right away. The course is also self-paced, so you can learn at your own pace. You can take the courses in any order that you like, and you can access them from anywhere in the world. Learning Outcomes: By the end of this bundle course, you will be able to: Use digital marketing to reach your target audience and grow your business. Invest in cryptocurrency and make money from the blockchain revolution. Write persuasive copy that will sell your products or services. Use ChatGPT to create chatbots that can automate your customer service and marketing. Create content that attracts and engages your target audience. Optimize your website for search engines so that more people can find you online. Use Power BI to analyze data and make better business decisions. Use Microsoft Excel to create spreadsheets, charts, and graphs. Use graphic design software to create professional-looking designs. Use data analysis techniques to extract insights from data. If you're looking to learn the skills that will help you earn more money, then the 10 High-income & Passive Income Skills Courses is for you. Sign up today and start learning! CPD 100 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course is for anyone who wants to learn the skills they need to earn more money. This includes: Digital marketers Cryptocurrency investors Copywriters ChatGPT developers Content marketers SEO experts Power BI users Microsoft Excel users Graphic designers Data analysts Career path Data Analyst Graphic Designer Blockchain Developer Copywriter Content Marketing SEO Executive Certificates Certificate of completion Digital certificate - Included

10 High Income Skills You Must Learn for Sustainable Passive Income Course
Delivered Online On Demand1 hour
£49

Flow Assurance for Offshore Production

By EnergyEdge - Training for a Sustainable Energy Future

About this training course This 5-days comprehensive training not only an introduction into the issue associated with the development of oil and gas fields but also provides an in depth understanding of the issues to be considered in the development of these fields. The theme throughout this training course is Flow Assurance and Innovative Technologies. Each day consists of lectures in the morning and a hands-on workshop in the afternoon. The workshop allows the participants to appreciate the design process associated with field developments. Various software will be available during the workshop to predict Multiphase flows through wells, pipelines and risers, as well as evaluating reservoir production profiles using alternative technologies to develop reservoirs. Further software to assess Surge and environmental safety will also be available. The field design approach will consider an integrated solution through modelling the reservoir decline, wells, flowlines, risers and the host facility. The participants will have a total appreciation of the methodology required to develop offshore oil and gas fields and have an understanding of all of the Flow Assurance issues and technology requirements. Training Objectives After the completion of this training course, participants will be able to: Understand the process required and identify data to analyse Flow Assurance for oil and gas fields. Examine and Identify the Flow Assurance issues required to be evaluated for oil and gas fields design. These include; Wax, Hydrates, Slugging, Corrosion, Sand Erosion, Scaling and Surge. Establish the studies to be undertaken for each area of Flow Assurance including 'Rules of Thumb' and software to be used. Prioritize the need for innovative methods and the technologies to solve Flow Assurance issues and the need for economics considerations. Appreciate the need for an integrated analysis of the oil and fields from the reservoir to the host processing facility. Gain an appreciation of the emerging and enabling technologies for offshore fields application. Dive deeper into the operational strategies requirements to mitigate Flow Assurance issues. Target Audience This training course is suitable and will greatly benefit the following specific groups: Reservoir Engineers Flow Assurance Engineers Thermodynamics Engineers Process and Chemical Engineers Pipeline Engineers Facilities Engineers Control and Subsea Engineers working in the Oil and Gas industries Engineers in other disciplines may attend that require an appreciation of Flow Assurance Course Level Intermediate Training Methods The training instructor relies on a highly interactive training method to enhance the learning process. This method ensures that all participants gain a complete understanding of all the topics covered. The training environment is highly stimulating, challenging, and effective because the participants will learn by case studies which will allow them to apply the material taught in their own organization. Course Duration: 5 days in total (35 hours). Training Schedule 0830 - Registration 0900 - Start of training 1030 - Morning Break 1045 - Training recommences 1230 - Lunch Break 1330 - Training recommences 1515 - Evening break 1530 - Training recommences 1700 - End of Training Course delivery: This course is limited to a maximum of 20 participants only. A basic understanding of thermo-hydraulics would be advantageous. Morning Lectures and afternoon hands-on practical workshop. Special features: PC-based simulation software demonstration Workshop for hands-on training Course References & Additional resources: 'Flow Assurance for Oil and Gas Fields Production Transport', 1st Edition Handouts Pre & Post Assessment Trainer Your expert course leader is a renowned specialist in flow assurance management for the oil & gas field developments. His expertise enables him to support the operating and contracting companies as well as financial institutions regarding due diligence on offshore development investment decisions and associated operational system risks. Technical assessment of fields for acquisition and production enhancement opportunity. He possesses specialist expertise in evaluating difficult pipeline fluids transport such as Ethylene, Carbon Dioxide and Hydrogen through feasibility studies and technical reviews for clients. He has an exceptional academic background and natural leadership abilities are supported by practical experience of diverse projects worldwide, along with numerous publications at key conferences and publication of four books. Particular interests in developing novel and innovative technologies for subsea applications to solve difficult flow assurance problem areas and improve field development economics. He has worked on major industry projects including; Concorde aircraft fuelling system, the Channel Tunnel aerodynamics and the first deep water oil field development (Foinaven) in the West of Shetland. He is also currently developing a renewable energy solar farm and carbon neutral energy crop (Miscanthus) for domestic and commercial power generation application. He has developed in-house resources including specialist oil & gas field development evaluation software for subsea and onshore field infrastructure development options including; costing and financial analysis, reservoir viability, flow assurance assessment, subsea processing and boosting technologies, flow induced vibrations, surge analysis, heat transfer and chemical injection systems.

Flow Assurance for Offshore Production
Delivered in Internationally or OnlineFlexible Dates
£3,255 to £3,785

Create an Online Course

4.7(160)

By Janets

Register on the Create an Online Course today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get an e-certificate as proof of your course completion. The Create an Online Course is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Create an Online Course Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certification Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the Create an Online Course, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16.  Course Content Section 01: Preplanning for Your Course Preplan Ahead 00:07:00 What Makes a Course Have Impact 00:08:00 Folder Structure and Overall Layout 00:07:00 Section 02: How to Record Yourself How to Record Yourself 00:02:00 What Type of Camera Do You Need 00:06:00 Don't Forget About Lighting 00:03:00 My Current Lighting Setup 00:01:00 Getting High-Quality Audio 00:04:00 Setting Up a Camera for High Quality Audio 00:04:00 Seeing Yourself While Recording 00:03:00 Setting Up Your Camera's Settings 00:04:00 Why a Tripod is Crucial 00:02:00 How I Record Myself with a DSLR 00:03:00 How to Fix Mistakes While Recording 00:04:00 How to Get Your Point Across in Videos 00:04:00 What's in My Camera Bags 00:03:00 Section 03: Recording Your Computer Screen Introduction to OBS Screen Capture Software 00:04:00 Setting Up Scenes in OBS 00:07:00 Audio Settings in OBS 00:08:00 Using High Quality Microphones with Your Computer 00:05:00 Webcam and Videocam Recommendations for OBS 00:06:00 Final Suggestions before Recording in OBS 00:05:00 Section 04: How to Edit Your Videos Editing Videos - Introduction 00:03:00 How to Set Up a Video Editor Template 00:15:00 How to Edit Your Videos 00:12:00 Setting Voice and Music Levels 00:15:00 How to Overdub a Screwup! 00:01:00 Exporting Your Course Videos 00:04:00 Getting Better Performance When Video Editing 00:07:00 Tricks and Tips When Editing 00:02:00 Recap of the Video Editor Template 00:03:00 Section 05: Creating Your Course Artwork Creating Your Course Artwork 00:07:00 Section 06: Creating a High Quality Slideshow Creating Your Slideshow 00:02:00 Creating Your Slideshow 00:12:00 Setting Up Your Slideshow Bullet Points 00:17:00 Section 07: How to Release Your Course How to Release Your Course 00:13:00 Section 08: Conclusion Conclusion 00:03:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Create an Online Course
Delivered Online On Demand3 hours 36 minutes
£25

Level 4 Dental Practice Management

By Cavity Dental Training

Unlock Your Potential as a Dental Practice Manager with Our Level 4 Course The Level 4 Diploma in Dental Practice Management qualification delivered by Cavity Training has been designed as a standalone qualification or as an apprenticeship qualification for anyone wishing to become a qualified practice manager. Candidates are required to be in a work placement in order to be able to commence the qualification. Learn about the Cavity Training Dental Practice Management course This qualification allows candidates to learn, develop and practice the skills required for employment and a career in Dental Practice Management. The content covers all essential areas of Management and is mapped to the GDC Learning Outcomes for Dental Nurses and relevant National Occupational Standards. This qualification is approved by the GDC. This qualification allows candidates to go on to higher level 5 management courses and expand their management career. Fees This course can be completed as an government funded apprenticeship, through Cavity Training, or as a privately funded course for £3500. You can either pay as a lump sum or alternatively, you can split into 12 instalments. Entry requirements The minimum requirements are level 2 in English and Maths. Structure To achieve the Level 4 Diploma in Dental Practice Management, candidates will need to also successfully complete a final online Knowledge Test. This is a 24 month course, with a final end point assessment. Knowledge Our course is delivered via live training webinars with specialist tutors. Skills and Behaviours You will be appointed a designated Assessor, who will coach you through your qualification and complete regular assessments with you to support you to complete your qualification. You will have weekly contact from your Assessor. How we compare with our competitors? Don't just take our word for it, here is what our staff think Bridget I did my course years ago. It was classroom based one night per week. I think I would prefer to be more ‘hands on’ like it is now. Cavity really are a great company to work for. I truly believe that there expertise will ensure the next generation are amazing! Gina I did mine over an apprenticeship but the company my employer used wasn’t great and I didn’t get much support. Although I passed I can only imagine the length that Cavity have gone to to ensure that the students feel supported. As an employee, its super! Enquire Today

Level 4 Dental Practice Management
Delivered OnlineFlexible Dates
£292 to £3,500

Health & Social Care, Consent Training and Liberty Safeguards

4.7(47)

By Academy for Health and Fitness

***24 Hour Limited Time Flash Sale*** Health & Social Care, Consent Training and Liberty Safeguards Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter In the ever-evolving landscape of healthcare, staying updated is not an option but a necessity. Introducing our meticulously crafted bundle "Health & Social Care, Consent Training, and Liberty Safeguards," designed to serve you the theoretical knowledge in the most digestible format. Our package includes three QLS-endorsed courses: Health and Social Care Management, Consent Training in Healthcare, and Deprivation of Liberty Safeguards. Not only these courses offer valuable insights, but they also reward you with a hardcopy certificate upon completion, which could be an excellent addition to your professional profile. In addition, this comprehensive bundle caters five CPD QS accredited courses: Care Assistant, End of Life Care Course, Social Care, Maternity Care Assistant Course, and Medical Terminology Training. Each of these courses could be a stepping stone towards enhancing your understanding of healthcare practices, legal considerations, and medical terminology, all essential for Health & Social Care, Consent Training, and Liberty Safeguards. Key Features of the Health & Social Care, Consent Training and Liberty Safeguards Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our [Course_Title] bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: Health and Social Care Management QLS Course 02: Consent Training in Healthcare Course QLS Course 03: Deprivation of Liberty Safeguards 5 CPD QS Accredited Courses: Additionally, our bundle includes 5 relevant CPD QS accredited courses, ensuring that you stay up-to-date with the latest industry standards and practices. Course 01: Care Assistant Course 02: End of Life Care Course Course 03: Social Care Course 04: Maternity Care Assistant Course Course 05: Medical Terminology Training In Addition, you'll get Five Career Boosting Courses absolutely FREE with this Bundle. Course 01: Professional CV Writing Course 02: Job Search Skills Course 03: Self Esteem & Confidence Building Course 04: Professional Diploma in Stress Management Course 05: Complete Communication Skills Master Class Convenient Online Learning: Our Health & Social Care, Consent Training and Liberty Safeguards courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home. Learning Outcomes: Understand the importance and nuances of Health and Social Care Management. Gain theoretical knowledge on Consent Training in Healthcare. Learn about Deprivation of Liberty Safeguards and its implications. Develop a foundational understanding of the roles and responsibilities of a Care Assistant. Acquire knowledge on End of Life Care practices and Social Care. Understand the roles and considerations of a Maternity Care Assistant. Become familiar with vital Medical Terminology. The "Health & Social Care, Consent Training, and Liberty Safeguards" bundle aims to provide a comprehensive understanding of critical aspects of healthcare. With three QLS-endorsed and five CPD QS accredited courses, the bundle promises to equip you with the theoretical knowledge needed in today's healthcare landscape. CPD 260 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals keen on learning about Health and Social Care Management. Healthcare professionals looking to understand Consent Training and Deprivation of Liberty Safeguards. Those interested in roles related to Care Assistant, Maternity Care Assistant, and Social Care. Anyone keen on enriching their knowledge about Medical Terminology. Career path Health and Social Care Manager: £35,000 - £40,000 Healthcare Consultant: £40,000 - £60,000 Care Coordinator: £20,000 - £25,000 Maternity Care Assistant: £19,000 - £22,000 Medical Secretary (with knowledge of medical terminology): £20,000 - £25,000 End of Life Care Practitioner: £25,000 - £30,000 Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included

Health & Social Care, Consent Training and Liberty Safeguards
Delivered Online On Demand48 hours
£309

Face to Face Course via Zoom - Positive & Proactive Communication for Effective Call Handling

By The Development People

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

Face to Face Course via Zoom -
Positive & Proactive Communication for Effective Call Handling
Delivered OnlineFlexible Dates
£69 to £79

55366 Querying Data with Transact-SQL

By Nexus Human

Duration 5 Days 30 CPD hours This course is intended for This course is intended for novice database developers, database administrators, Business Intelligence developers, report creators, and application developers who have an understanding of relational database concepts and have basic Windows navigation skills. Overview Create single table SELECT queries Create multiple table SELECT queries Filter and sort data Insert, update, and delete data Query data using built-in functions Create queries that aggregate data Create subqueries Create queries that use table expressions Use UNION, INTERSECT, and EXCEPT on multiple sets of data Implement window functions in queries Use PIVOT and GROUPING SETS in queries Use stored procedures in queries Add error handling to queries Use transactions in queries This five-day instructor-led course is intended for IT professionals who wish to use the Transact-SQL language to query and configure Microsoft SQL Server. Students are typically database developers and database administrators, but might also be Business Intelligence developers, report creators, or application developers. In this course, students learn how to query single tables, join data from multiple tables, filter and sort data, modify data, use procedures and functions, and implement error handling. Prerequisites Basic understanding of relational databases. Basic Windows knowledge. Module 1: Introduction to Transact-SQL What is Transact-SQL The SELECT statement The WHERE clause Sorting results Calculations CASE expressions Module 2: Joining tables with Transact-SQL The JOIN clause Inner joins Outer joins Self joins and cross joins Module 3: Filtering and sorting results Implement the ORDER BY clause Filter data with the WHERE clause Limit the number of rows returned by a query Implement NULL logic Module 4: SQL Server data types Understand data types Implement string data types Implement temporal data types Module 5: Inserting, updating and deleting data Insert new records Update existing records Delete data Module 6: Using SQL Server functions with Transact-SQL Understand function types in SQL Server Convert data using functions Implement logical functions Work with NULL data using functions Module 7: Aggregating data with Transact-SQL Implement aggregation in SQL Server Group records in SQL Server Filter aggregated data Module 8: Implement subqueries with Transact-SQL Implement scalar and multi-valued sub-queries Implement correlated subqueries Implement existence checks with subqueries Module 9: Create queries that use table expressions Create views Create table-valued functions Implement derived tables Implement common table expressions Module 10: Use UNION, INTERSECT, EXCEPT and APPLY on multiple sets of data Write queries with the UNION operator Write queries with the INTERSECT and EXCEPT operators Write queries with the APPLY operator Module 11: Implement window functions in queries Understand window functions Impement window functions Module 12: Use PIVOT and grouping sets in queries Implement PIVOT in queries Implement grouping sets in queries Module 13: Use stored procedures in queries Query data with stored procedures Interact with stored procedures using input and output parameters Write simple stored procedures Pass dynamic SQL to SQL Server Module 14: Implement programming features in Transact-SQL Understand T-SQL programming elements Implement loops and conditions in T-SQL queries Module 15: Add error handling to queries Understand SQL Server error handling Implemet structured exception handling Module 16: Use transactions in queries Understand database transactions Implement transactions in T-SQL

55366 Querying Data with Transact-SQL
Delivered OnlineFlexible Dates
£2,976