41318 Courses in Cardiff delivered Online

Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified Facilities Management and Organizational Skills bundle will keep you up to date with the relevant knowledge and most recent matters of this emerging field. So, invest your money and effort in our 37 course mega bundle that will exceed your expectations within your budget. The Facilities Management and Organizational Skills related fields are thriving across the UK, and recruiters are hiring the most knowledgeable and proficient candidates. It's a demanding field with magnitudes of lucrative choices. If you need more guidance to specialise in this area and need help knowing where to start, then StudyHub proposes a preparatory bundle. This comprehensive Facilities Management and Organizational Skills bundle will help you build a solid foundation to become a proficient worker in the sector. This Facilities Management and Organizational Skills Bundle consists of the following 30 CPD Accredited Premium courses - Course 1: Land Surveying and Cost Estimation Course 2: Multiplex Building Cost Estimation Using Xactimate Course 3: Construction Estimation using RSMeans Course 4: Construction Cost Estimation Using Xactimate Course 5: Quantity Surveying & Cost Estimation Course 6: Surveying Basics Course 7: Building Surveying Course 8: Residential Surveyor Course 9: Construction Industry Scheme (CIS) Course 10: Construction Management Level 3 Course 11: Site Safety Plus Course 12: CSCS Health and Safety in a Construction Environment (Leading to CSCS Green Card) Course 13: Construction Risk Assessment Course 14: Operations and Supply Chain Management Course 15: Environmental Engineering Course 16: Advanced Electrical Safety Course 17: Emergency First Aid at Work (EFAW) Course 18: Asbestos Surveying Course 19: COSHH Awareness Course 20: Gas Safety Course 21: Construction Project Management Course 22: Site Management Safety Training Scheme Course 23: CDM Regulations Course 24: Purchasing and Procurement Diploma Course 25: LOLER Regulations and LOLER Inspection Training Course 26: Manual Handling Interactive Training Course 27: Noise and Hearing Protection Course 28: PUWER Course 29: Supervisor Training Course 30: Logistic Maangement 7 Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques- Course 1: Career Development Plan Fundamentals Course 2: CV Writing and Job Searching Course 3: Interview Skills: Ace the Interview Course 4: Video Job Interview for Job Seekers Course 5:Create a Professional LinkedIn Profile Course 6:Business English Perfection Course Course 7:Networking Skills for Personal Success Learning Outcome This tailor-made Facilities Management and Organizational Skills bundle will allow you to- Uncover your skills and aptitudes to break new ground in the related fields Deep dive into the fundamental knowledge Acquire some hard and soft skills in this area Gain some transferable skills to elevate your performance Maintain good report with your clients and staff Gain necessary office skills and be tech savvy utilising relevant software Keep records of your work and make a report Know the regulations around this area Reinforce your career with specific knowledge of this field Know your legal and ethical responsibility as a professional in the related field This Facilities Management and Organizational Skills Bundle resources were created with the help of industry experts, and all subject-related information is kept updated on a regular basis to avoid learners from falling behind on the latest developments. Certification After studying the complete training you will be able to take the assessment. After successfully passing the assessment you will be able to claim all courses pdf certificates and 1 hardcopy certificate for the Title Course completely free. Other Hard Copy certificates need to be ordered at an additional cost of •8. CPD 370 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Ambitious learners who want to strengthen their CV for their desired job should take advantage of the Facilities Management and Organizational Skills bundle! This bundle is also ideal for professionals looking for career advancement. Requirements To participate in this course, all you need is - A smart device A secure internet connection And a keen interest in Facilities Management and Organizational Skills Career path Upon completing this essential Bundle, you will discover a new world of endless possibilities. These courses will help you to get a cut above the rest and allow you to be more efficient in the relevant fields.

This qualification provides a comprehensive overview of risk and risk management. It is a great way for health and safety professionals to expand their knowledge of risk beyond health and safety.

Immerse yourself in the fascinating world of botanical sciences with our enticing bundle: "Reproduction in Flowering, Hydroponics and Kitchen Gardening." This curated package encompasses two highly sought-after QLS-endorsed courses: "Reproduction in Flowering Plants" and "Hydroponics Gardening Online Course." Following successful completion of these courses, you'll be rewarded with hardcopy certificates to showcase your accomplishments. But the knowledge journey doesn't stop there. Alongside the QLS-endorsed offerings, the bundle includes an additional five CPD QS accredited courses: "The Basics of Reproduction," "Forestry," "Horticulture," "Arboriculture," and "Environmental Law 2021." The fusion of these courses provides a holistic insight into the green sciences, equipping you with theoretical knowledge and an essential understanding of the field. Key Features of the Reproduction in Flowering, Hydroponics and Kitchen Gardening Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our Reproduction in Flowering, Hydroponics and Kitchen Gardening bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: Reproduction in Flowering Plants QLS Course 02: Hydroponics Gardening Online Course QLS Course 03: Kitchen Gardening 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: The Basics of Reproduction Course 02: Forestry Course 03: Horticulture Course 04: Arboriculture Course 05: Environmental Law 2021 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 Reproduction in Flowering, Hydroponics and Kitchen Gardening courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home. Learning Outcomes: Understand the reproductive process of flowering plants. Learn the principles and applications of hydroponics. Gain a basic understanding of plant reproduction and its significance in horticulture. Learn about various types of forestry and its effects on the environment. Develop a clear understanding of horticultural practices and their importance. Discover the different facets of arboriculture. Understand the latest developments in environmental law and its implications for plant life. Discover the magic of botany with the "Reproduction in Flowering, Hydroponics and Kitchen Gardening" bundle. Enrich your understanding of plant reproduction, hydroponic practices, and the joys of kitchen gardening. These interactive courses, infused with quality content, offer a well-rounded perspective on various facets of horticultural studies and environmental law. CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals keen to explore the science behind plant reproduction. Aspiring gardeners interested in hydroponics and kitchen gardening. Environmental science students seeking a comprehensive understanding of environmental law. Horticultural enthusiasts wanting to dive deeper into forestry and arboriculture. Career path Plant Scientist - Average salary: £35,000 - £50,000 Hydroponics Specialist - Average salary: £27,000 - £35,000 Horticulturist - Average salary: £20,000 - £30,000 Arborist - Average salary: £20,000 - £35,000 Environmental Lawyer - Average salary: £70,000 - £120,000 Kitchen Gardener - Average salary: £15,000 - £25,000 (Note: Salaries are averages and can vary based on experience and location.) Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included

An Agile Approach to Employee Engagement Investing in people who enable an organization's success is paramount to gaining their loyalty. Engaged employees produce great results and need to be recognized for their contributions. In this presentation you'll learn how to celebrate employee success with cost-effective tools that encourage employee engagement through an Agile approach. This and other IIL Learning in Minutes presentations qualify for PDUs. Some titles, such as Agile-related topics may qualify for other continuing education credits such as SEUs, or CEUs. Each professional development activity yields one PDU for one hour spent engaged in the activity. Some limitations apply and can be found in the Ways to Earn PDUs section that discusses PDU activities and associated policies. Fractions of PDUs may also be reported. The smallest increment of a PDU that can be reported is 0.25. This means that if you spent 15 minutes participating in a qualifying PDU activity, you may report 0.25 PDU. If you spend 30 minutes in a qualifying PDU activity, you may report 0.50 PDU.

Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified Construction Industry Scheme & Site Safety Management bundle will keep you up to date with the relevant knowledge and most recent matters of this emerging field. So, invest your money and effort in our 40 course mega bundle that will exceed your expectations within your budget. The Construction Industry Scheme & Site Safety Management related fields are thriving across the UK, and recruiters are hiring the most knowledgeable and proficient candidates. It's a demanding field with magnitudes of lucrative choices. If you need more guidance to specialise in this area and need help knowing where to start, then StudyHub proposes a preparatory bundle. This comprehensive Construction Industry Scheme & Site Safety Management bundle will help you build a solid foundation to become a proficient worker in the sector. This Construction Industry Scheme & Site Safety Management Bundle consists of the following 30 CPD Accredited Premium courses - Course 1: Quantity Surveying Course 2: Surveying Basics Course 3: Building Surveying Course 4: Land Surveying and Cost Estimation Course 5: Residential Surveyor Course 6: Construction Industry Scheme (CIS) Course 7: Construction Management Level 3 Course 8: Construction Project Management Course 9: Site Management Safety Training Scheme Course 10: CDM Regulations Course 11: Environmental Health Course 12: Abrasive Wheels Course 13: Purchasing and Procurement Diploma Course 14: LOLER Regulations and LOLER Inspection Training Course 15: Manual Handling Interactive Training Course 16: Fire Safety Course 17: Noise and Hearing Protection Course 18: PUWER Course 19: Supervisor Training Course 20: Logistic Maangement Course 21: Advanced Electrical Safety Course 22: Emergency First Aid at Work (EFAW) Course 23: Asbestos Surveying Course 24: COSHH Awareness Course 25: Gas Safety Course 26: Site Safety Plus Course 27: CSCS Health and Safety in a Construction Environment (Leading to CSCS Green Card) Course 28: Construction Risk Assessment Course 29: Operations and Supply Chain Management Course 30: Environmental Engineering 10 Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques- Course 1: Career Development Plan Fundamentals Course 2: CV Writing and Job Searching Course 3: Interview Skills: Ace the Interview Course 4: Video Job Interview for Job Seekers Course 5: Create a Professional LinkedIn Profile Course 6: Business English Perfection Course Course 7: Networking Skills for Personal Success Course 8: Boost Your Confidence and Self-Esteem Course 9: Public Speaking Training Course 10: Learn to Fight Procrastination Learning Outcome This tailor-made Construction Industry Scheme & Site Safety Management bundle will allow you to- Uncover your skills and aptitudes to break new ground in the related fields Deep dive into the fundamental knowledge Acquire some hard and soft skills in this area Gain some transferable skills to elevate your performance Maintain good report with your clients and staff Gain necessary office skills and be tech savvy utilising relevant software Keep records of your work and make a report Know the regulations around this area Reinforce your career with specific knowledge of this field Know your legal and ethical responsibility as a professional in the related field This Construction Industry Scheme & Site Safety Management Bundle resources were created with the help of industry experts, and all subject-related information is kept updated on a regular basis to avoid learners from falling behind on the latest developments. Certification After studying the complete training you will be able to take the assessment. After successfully passing the assessment you will be able to claim all courses pdf certificates and 1 hardcopy certificate for the Title Course completely free. Other Hard Copy certificates need to be ordered at an additional cost of •8. CPD 400 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Ambitious learners who want to strengthen their CV for their desired job should take advantage of the Construction Industry Scheme & Site Safety Management bundle! This bundle is also ideal for professionals looking for career advancement. Requirements To participate in this course, all you need is - A smart device A secure internet connection And a keen interest in Construction Industry Scheme & Site Safety Management Career path Upon completing this essential Bundle, you will discover a new world of endless possibilities. These courses will help you to get a cut above the rest and allow you to be more efficient in the relevant fields.

Ready to explore the limitless universe of words and the incredible journey of creativity? Then grab our superb 'Travel Blogger, Screenwriting and Blogger at QLS Level 5' course bundle! This collection of 8 top-notch courses combines the finest QLS-endorsed and CPD QS-accredited programmes for a learning journey that'll send your skills soaring into new horizons. Three QLS-endorsed courses are the heart of this bundle: Travel Blogger, Screenwriting & Scriptwriting, and Blogger for Beginners. Craft tantalising travel tales, weave engrossing scripts, and build blogs that beguile and inspire. Each QLS-endorsed course comes complete with a hardcopy certificate to display your theoretical mastery! Five complementary CPD QS accredited courses complete the bundle: Leisure Management, Advanced Certificate in Content Writing, Creative Writing Course - Novel, Copywriting Level 4 Diploma, and Creative Writing Course - Short Stories. Explore captivating realms of creativity, from exhilarating novels to succinct short stories, and supercharge your content writing prowess. Dive into this comprehensive bundle and ascend the heights of the literary world! Key Features of the Travel Blogger, Screenwriting and Blogger at QLS Level 5 Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our Travel Blogger, Screenwriting and Blogger at QLS Level 5 bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: Travel Blogger QLS Course 02: Screenwriting & Scriptwriting QLS Course 03: Blogger for Beginners 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: Leisure Management Course 02: Advanced Certificate in Content Writing Course 03: Creative Writing Course - Novel Course 04: Copywriting Level 4 Diploma Course 05: Creative Writing Course - Short Stories 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 Travel Blogger, Screenwriting and Blogger at QLS Level 5 courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home. Learning Outcomes: Mastery of the art and theory of travel blogging, screenwriting, and blogging. Advanced knowledge of content creation, covering diverse formats and genres. Proficiency in leisure management theory. Ability to construct engaging novels and short stories. Enhanced copywriting skills for persuasive and effective communication. Comprehensive understanding of QLS-endorsed course material, validated by hardcopy certificates. Deep understanding and implementation of CPD QS accredited course content. Step into an enchanting journey of creativity with the 'Travel Blogger, Screenwriting and Blogger at QLS Level 5' course bundle. Explore the thrilling world of travel blogging, craft magnetic screenplays, and shape compelling blogs that draw readers into your world. You'll traverse the diverse landscapes of content creation, moving through the luscious valleys of novel writing to the sharp, succinct peaks of copywriting. With three QLS-endorsed courses validated by hardcopy certificates, and five CPD QS accredited courses expanding your theoretical insights, this bundle is your portal to the ever-evolving universe of creative writing and content creation. So, don your writing cap and embark on this mesmerising journey! CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring writers and bloggers who wish to delve deep into the world of travel writing, screenwriting, and blogging. Individuals seeking to enhance their content creation abilities across a range of formats and genres. Professionals in the writing field looking to validate and expand their theoretical knowledge. Lifelong learners interested in understanding the art and theory behind captivating storytelling, from travel tales to gripping screenplays. Career path This course opens up an array of career opportunities, including Travel bloggers, screenwriters, Content writers, copywriters, and more. With your enhanced writing skills, you can find your voice and make it heard in the world of literature and beyond. Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included

***24 Hour Limited Time Flash Sale*** Content Management (Copywriting, SEO, Email Writing) Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Elevate your content mastery with our exclusive Content Management bundle, a curated collection of 8 transformative courses. This bundle comes enriched with three QLS-endorsed courses: 'Content Management', 'SEO Masterclass', and 'Email Writing Training for Leadership Success.' With these, you receive prestigious hardcopy certificates to authenticate your competence and boost your profile. Moreover, we've added five more relevant CPD QS accredited courses to complete your content-centric education. Explore 'Content Writing & Copy Writing For SEO and Sales', delve into 'Content Creation and Content Marketing Certificate', augment your skills with 'Advanced Certificate in Content Writing', refine your email prowess with 'Certificate in Email Content Writing' and ignite your creativity through the 'Creative Writing Course - Short Stories.' This bundle is your passport to comprehensive content knowledge, refining your copywriting, SEO, and email writing abilities. Unleash your content potential, shape your future and redefine content management! Key Features of the Content Management (Copywriting, SEO, Email Writing) Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our Content Management (Copywriting, SEO, Email Writing) bundle, providing you with industry-recognised qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: Content Management QLS Course 02: SEO Masterclass QLS Course 03: Email Writing Training 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: Content Writing & Copy Writing For SEO and SalesCourse 02: Content Creation and Content Marketing CertificateCourse 03: Advanced Certificate in Content WritingCourse 04: Certificate in Email Content WritingCourse 05: Creative Writing Course - Short Stories 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 Content Management (Copywriting, SEO, Email Writing) courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home. Learning Outcomes: Gain comprehensive knowledge of effective content creation and management strategies. Master the art of SEO and understand how it influences content visibility. Develop advanced email writing skills to enhance leadership communication. Learn to create engaging, SEO-friendly, and sales-driven content. Discover strategies for successful content marketing. Understand the nuances of creative writing, particularly short stories. Develop the ability to write powerful content across different platforms. This distinctive bundle of eight courses focuses on providing theoretical knowledge on essential aspects of content creation, management, SEO, and email writing. Through the QLS-endorsed and CPD QS accredited courses, learners will delve deep into the art of crafting effective content that captures audience attention, promotes engagement, and drives sales. Each course is designed to augment your understanding of different facets of content, from SEO optimization to creative writing. These courses offer learners the opportunity to enhance their skill sets, increasing their marketability and employment prospects. The training provided in this bundle will help you understand the impact of well-written content, how to create it, and how to use it effectively for marketing, sales, and communication. With this bundle, you are well on your way to becoming a versatile content expert. CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring content creators seeking theoretical knowledge in content management. Professionals in marketing, sales, or leadership roles wanting to enhance their content creation and communication skills. Business owners aiming to leverage content for brand promotion and engagement. Individuals interested in exploring various aspects of content writing, from SEO to creative writing. Career path Content Manager: Oversee and manage a company's content creation (£35,000 - £50,000) SEO Specialist: Enhance website visibility using SEO strategies (£25,000 - £40,000) Email Marketing Manager: Drive business growth through email campaigns (£30,000 - £45,000) Content Marketing Strategist: Develop and implement content marketing plans (£30,000 - £55,000) Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included

Learn how to successfully publish your ebooks, print books and audiobooks on Amazon and other major retailers within 30 days!

Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified Technical Report Writing bundle will keep you up to date with the relevant knowledge and most recent matters of this emerging field. So, invest your money and effort in our 40 course mega bundle that will exceed your expectations within your budget. The Technical Report Writing related fields are thriving across the UK, and recruiters are hiring the most knowledgeable and proficient candidates. It's a demanding field with magnitudes of lucrative choices. If you need more guidance to specialise in this area and need help knowing where to start, then StudyHub proposes a preparatory bundle. This comprehensive Technical Report Writing bundle will help you build a solid foundation to become a proficient worker in the sector. This Technical Report Writing Bundle consists of the following 30 CPD Accredited Premium courses - Course 1: Write and Publish a Research Paper: Complete Guide v6 Course 2: How to Write a Research Paper in Law and Humanities Course 3: Creative Writing Course 4: Copywriting Course Level 4 Course 5: Novel Writing and Publishing Course 6: News Writing: Journalism 101 Course 7: Blogger for Beginners Course 8: Medieval History Course 9: Military History Course 10: The History of the Industrial Revolution in Great Britain Course 11: Creative Writing Course: Writing Storybooks For Children Course 12: Diploma in Drama and Comedy Writing Course 13: Creative Writing Course - Short Stories Course 14: Creative Writing Course - Fiction Course 15: Creative Writing Course - Horror Course 16: Creative Writing Course - Novel Course 17: Creative Writing Course - Thriller Course 18: Creative Nonfiction Book Writing Course 19: Selling E-books: The Best Way of Earning Online Course 20: Business Writing Course 21: Business Writing - How You Can Become a Great Writer Course 22: Business Writing: Influence Your Readers Course 23: Freelance Masterclass - Become An Expert Copywriter Course 24: Content Writing & Copy Writing For SEO and Sales Course 25: Email Writing Training Course 26: English: Spelling, Punctuation, and Grammar Course 27: Creative Advertising and Graphic Design for Everyone Course 28: CV Writing and Job Searching Course 29: Foundations of Leadership and Negotiation Skills Development Course 30: Personal Development and Productivity Level 2 10 Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques- Course 1: Career Development Plan Fundamentals Course 2: CV Writing and Job Searching Course 3: Interview Skills: Ace the Interview Course 4: Video Job Interview for Job Seekers Course 5: Create a Professional LinkedIn Profile Course 6: Business English Perfection Course Course 7: Networking Skills for Personal Success Course 8: Boost Your Confidence and Self-Esteem Course 9: Public Speaking Training Course 10: Learn to Fight Procrastination Learning Outcome This tailor-made Technical Report Writing bundle will allow you to- Uncover your skills and aptitudes to break new ground in the related fields Deep dive into the fundamental knowledge Acquire some hard and soft skills in this area Gain some transferable skills to elevate your performance Maintain good report with your clients and staff Gain necessary office skills and be tech savvy utilising relevant software Keep records of your work and make a report Know the regulations around this area Reinforce your career with specific knowledge of this field Know your legal and ethical responsibility as a professional in the related field This Technical Report Writing Bundle resources were created with the help of industry experts, and all subject-related information is kept updated on a regular basis to avoid learners from falling behind on the latest developments. Certification After studying the complete training you will be able to take the assessment. After successfully passing the assessment you will be able to claim all courses pdf certificates and 1 hardcopy certificate for the Title Course completely free. Other Hard Copy certificates need to be ordered at an additional cost of •8. CPD 400 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Ambitious learners who want to strengthen their CV for their desired job should take advantage of the Technical Report Writing bundle! This bundle is also ideal for professionals looking for career advancement. Requirements To participate in this course, all you need is - A smart device A secure internet connection And a keen interest in Technical Report Writing Career path Upon completing this essential Bundle, you will discover a new world of endless possibilities. These courses will help you to get a cut above the rest and allow you to be more efficient in the relevant fields.

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