32720 Courses

Mastering the landscape beneath our feet is more than just marking boundaries—it’s about understanding the maths, methods, and measurements that shape infrastructure from the ground up. This CPD-accredited Land Surveying and Cost Estimation course is tailored for learners keen to gain essential theoretical insights into surveying principles, cost projection techniques, and the broader world of construction-based assessments. Whether you're new to the subject or brushing up your knowledge, the course presents everything in a straightforward, learner-friendly style without any fluff. You’ll explore topics like topographical data analysis, contour mapping, estimation strategies, and survey methodologies—guided through structured modules that keep your progress on track. From basic definitions to applied formulas, each section is designed to ensure clarity and relevance. There’s no jargon to wade through, just focused content with real applicability for those with an eye on roles in planning, design, or project estimation. No need for hard hats or fieldwork—this learning happens entirely online, on your schedule, from wherever you choose to log in. A sound choice for those looking to grow their expertise with confidence and without complication. Furthermore, just to ensure that you are getting what you are paying for and there's no room for disappointment, you get a full 100% money-back guarantee, so there's nothing to worry about. You can enrol in the course with complete confidence. Course Curriculum: Module 01: Introduction to Land Surveying Module 02: Land Surveying Basics Module 03: Land Surveying Instrumentation Module 04: Land Surveying Methods and Techniques Module 05: Topographic Surveying and Mapping Module 06: Boundary Surveying Module 07: Cost Estimation Module 08: Role of Cost Estimator and New Aspects of Cost Estimation Module 09: Elements and Factors influencing Cost Estimation Module 10: Cost Estimation in Construction Industry Module 11: Cost Management Module 12: Surveying Health and Safety Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing an online module. For each test, the pass mark will be set to 60%. CPD 10 CPD hours / points Accredited by The CPD Certification Service Who is this course for? The Land Surveying and Cost Estimation - CPD Accredited training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our Land Surveying and Cost Estimation - CPD Accredited training.

15 in 1 Petroleum Engineering Bundle The UK oil and gas industry generates over 200,000 jobs, with an average annual salary of £50,000 for a petroleum engineer. If you aim to enhance your Petroleum Engineering skills, our comprehensive Petroleum Engineering course is perfect for you. Designed for success, this Petroleum Engineering course covers everything from basics to advanced topics in Petroleum Engineering. Each lesson in this Petroleum Engineering course is crafted for easy understanding, enabling you to become proficient in Petroleum Engineering. Whether you are a beginner or looking to sharpen your existing skills, this Petroleum Engineering is the ideal choice. With our Petroleum Engineering exclusive bundle you will get PDF Certificate, PDF Transcript and Digital Student ID Card (worth £50) Absolutely FREE. This Petroleum Engineering bundle consists of 20 courses. Course 01: Introduction to Petroleum Engineering and Exploration Course 02: Oil and Gas Industry Course 03: Petroleum Products : Specifications Properties Market Demand Course 04: Oil & Gas : Markets Trading Pricing & Economic Framework Course 05: Logistics of Crude Oil and Petroleum Products Course 06: Petroleum Refining Demystified Course 07: Diploma in Sustainable Energy Course 08: Gas Safety Course 09: COSHH Training and Safety - Level 2 Course 10: DSEAR Training Course 11: Gas Safety Course 12: Fire Safety | Online Course Course 13: Carbon Literacy Knowledge | Course Course 14: Environmental Law Course 15: Logistics of Crude Oil and Petroleum Products Learning Outcome of this Bundle Petroleum refining insights and processes. Effective oil and gas management strategies. Understanding specifications and market demands for petroleum products. Analyzing oil and gas markets, trading, and pricing. Interpreting P&IDs for piping and instrumentation. Foundational chemistry principles for engineering. Geology essentials for petroleum exploration. Safety protocols, COSHH, DSEAR, and gas safety. Why Choose Our Bundle Course? FREE Petroleum Engineering certificate accredited Get a free student ID card with Petroleum Engineering Training Get instant access to this Petroleum Engineering course. Learn Petroleum Engineering from anywhere in the world The Petroleum Engineering is affordable and simple to understand The Petroleum Engineering is an entirely online, interactive lesson with voiceover audio Lifetime access to the Petroleum Engineering course materials The Petroleum Engineering comes with 24/7 tutor support So enrol now in this Petroleum Engineering Today to advance your career! Elevate your prowess with the Petroleum Engineering Bundle, a treasure trove of 20 courses designed to cultivate your expertise in the oil and gas domain. From refining the raw to mastering logistics, this bundle unveils the intricacies of the industry, equipping you with skills to thrive in a competitive landscape. Whether you're an aspiring engineer or a seasoned professional, this bundle accelerates your journey towards excellence. CPD 200 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Petroleum Engineering Bundle is ideal for: Aspiring petroleum engineers seeking expertise. Oil and gas professionals aiming for advancement. Individuals desiring multidisciplinary petroleum knowledge. Requirements You will not need any prior background or expertise in this Petroleum Engineering bundle. Career path This Petroleum Engineering bundle will allow you to kickstart or take your career to the next stage in the related sector such as: Petroleum Engineer (£35,000 - £70,000). Oil and Gas Manager (£40,000 - £80,000). Health and Safety Specialist (£30,000 - £60,000). Environmental Compliance Officer (£25,000 - £50,000). Geologist (£35,000 - £70,000). Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included

24-Hour Knowledge Knockdown! Prices Reduced Like Never Before Did you know that in the UK, over 1 million people experience a medical emergency each year, and paramedics are often the first line of defense? If you're passionate about helping others in critical situations and making a real difference in lives, then a career in paramedicine could be your calling. But before you can embark on this rewarding journey, you'll need the proper Paramedic Training and knowledge. Our Bundle Contains 8 of Our Premium Courses for One Discounted Price: Course 01: Paramedicine Study Course 02: Public Health Course 03: Anatomy and Physiology of Human Body Course 04: Workplace First Aid Level 3 Course 05: Phlebotomy Technician Training Course 06: Emergency Care Assistant Course 07: Personal Hygiene Course Course 08: Medical Law This Paramedic Training for Paramedics bundle empowers you to pursue a fulfilling career as a paramedic, equipped with the knowledge, skills, and confidence to make a lasting impact in emergency healthcare. Whether you're a recent high school graduate, seeking a career change, or aiming for professional advancement, this comprehensive paramedic training program sets you on the path to success. Learning Outcomes of Paramedic Training for Paramedics Master emergency assessment, treatment, and life support techniques. Gain in-depth knowledge of public health and prevention strategies. Comprehend the human body's anatomy and physiology for informed decision-making. Develop advanced first aid skills for diverse workplace settings. Learn safe and effective phlebotomy techniques for blood collection. Assist paramedics in providing immediate care to patients in emergencies. Enrolling on the Paramedic Training for Paramedics Bundle will ensure that you land your dream career faster than you thought possible. Stand out from the crowd and train for the job you want with the Paramedic Training Bundle. Why Choose Our Paramedic Training for Paramedics Course? Get a Free CPD Accredited Certificate upon completion of Paramedic Training Get a free student ID card with Paramedic Training Training Get instant access to this Paramedic Training course. Learn Paramedic Training from anywhere in the world The Paramedic Training is affordable and simple to understand The Paramedic Training is an entirely online, interactive lesson with voiceover audio Lifetime access to the Paramedic Training course materials The Paramedic Training comes with 24/7 tutor support Paramedicine for Paramedics Start your learning journey straight away with this Bundle and take a step toward a brighter future! *** Course Curriculum of Paramedicine for Paramedics*** Our Bundle Courses consist of the following learning modules: Course 01: Paramedicine Study Module 01: Introduction to Paramedicine Study Module 02: Basic Human Anatomy Module 03: Basic First Aid Module 04: Paediatric First Aid Module 05: Common Injuries Module 06: Infection Control Module 07: Other Medical Emergency Module 08: Initial Assessment Module 09: Fluid and Electrolyte Balance Module 10: Ambulance Maintenance Module 11: Medical and Legal Issues Assessment Process of Paramedicine for Paramedics Once you have completed all the modules in the Bundle, you can assess your skills and knowledge with an optional assignment. Our expert trainers will assess your assignment and give you feedback afterwards. CPD 95 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Is This Paramedicine Study Bundle Right for You? This Paramedicine for Paramedics Bundle is ideal for anyone interested in this topic and who wants to learn more about it. Disclaimer The Paramedic Training course is not accredited by the GPhC therefore students completing the Paramedic Training course(s) will not be eligible for registration with the GPhC as a Paramedic nor will they meet the GPhC's training requirements to work as Paramedic staff. Requirements You will not need any prior background or expertise to enrol on Paramedicine for Paramedics Bundle! Career path Enrolling on this Paramedicine for Paramedics bundle package can lead you to the following career paths: Paramedic Paramedic Practitioner Prison Nurse Peripatetic Nurse Trainee Critical Care Paramedic Paramedic Advisor Clinical Nurse Clinical Assessor These job prospects generally pay between £15,000- £35,000 a year. Certificates CPD QS Accredited PDF Certificate Digital certificate - Included CPDQS Accredited Hard copy Certificate Hard copy certificate - £29

Any organisation's main expenses are its labour, and that is why there is a need to find the perfect match in order to minimize costs. This part of the job falls under the Human Resources team of the given company, where the HR managers have to match skills against the job available. If these things interest you then you are in luck, as this UK Employment Law Diploma can teach you more about the subject. The UK Employment Law Diploma course is divided into two sections, one focusing on Human Resource Management and the other on employment laws. In the first section you will learn about how modern day human resource management works, recruiting, interviewing, retention and orientation. You will discover more about following up with new employees, health and safety, discrimination and much more. Next you look into employment law by learning about immigration, rights, termination, transfers and such. The course covers multiple disciplines as you learn about management and UK employment law, which in turn could be extremely useful for you since you will stand out from the competition in your employer's eyes. Along with thiscourse, you will get 10 other related premium courses. Also, you will get an original hardcopy certificate, transcript and a student ID card. Courses are included with this Employment Law UK Bundle: Course 1: Employment Law UK Course 2: Payroll Management Course Course 3: Pension UK Course 4: Contract Law UK Level 3 Course 5: Level 3 Tax Accounting Course 6: Recruitment Consultant - Level 4 Course 7: Certificate in CV Writing and Interview Skills Course 8: HR Management Level 3 Course 9: Virtual Interviewing for HR Course 10: GDPR Data Protection Level 5 Course 11: Leadership & Management Diploma Curriculum of Employment Law UK Bundle ***UK Employment Law and Employee Rights Diploma*** Module 01: Basic of Employment Law Module 02: Legal Recruitment Process Module 03: Employment Contracts Module 04: Employee Handbook Module 05: Disciplinary Procedure Module 06: National Minimum Wage & National Living Wage Module 07: Parental Right, Sick Pay & Pension Scheme Module 08: Discrimination in the Workplace Module 09: Health & Safety at Work Module 10: Dismissal, Grievances and Employment Tribunals Workplace Monitoring & Data Protection ***Course 1: Payroll Management Course*** Module 01: Payroll System in the UK Module 02: Payroll Basics Module 03: Company Settings Module 04: Legislation Settings Module 05: Pension Scheme Basics Module 06: Pay Elements Module 07: The Processing Date Module 08: Adding Existing Employees Module 09: Adding New Employees Module 10: Payroll Processing Basics Module 11: Entering Payments Module 12: Pre-Update Reports Module 13: Updating Records Module 14: e-Submissions Basics Module 15: Process Payroll (November) Module 16: Employee Records and Reports Module 17: Editing Employee Records Module 18: Process Payroll (December) Module 19: Resetting Payments Module 20: Quick SSP Module 21: An Employee Leaves Module 22: Final Payroll Run Module 23: Reports and Historical Data Module 24: Year-End Procedures ***Pension UK*** Module 01: Overview of the UK Pension system Module 02: Type of Pension Schemes Module 03: Pension Regulation Module 04: Pension Fund Governance Module 05: Law and Regulation of Pensions in the UK Module 06: Key Challenges in UK Pension System ***Contract Law UK Level 3*** Module 01: Introduction to UK Laws Module 02: Ministry of Justice Module 03: Agreements and Contractual Intention Module 04: Considerations and Capacities of Contact Laws Module 05: Terms within a Contract Module 06: Misinterpretations and Mistakes Module 07: Consumer Protection Module 08: Privity of Contract Module 09: Insurance Contract Laws Module 10: Contracts for Employees Module 11: Considerations in International Trade Contracts Module 12: Laws and Regulations for International Trade Module 13: Remedies for Any Contract Breach ***Level 3 Tax Accounting*** Module 01: Tax System and Administration in the UK Module 02: Tax on Individuals Module 03: National Insurance Module 04: How to Submit a Self-Assessment Tax Return Module 05: Fundamentals of Income Tax Module 06: Payee, Payroll and Wages Module 07: Value Added Tax Module 08: Corporation Tax Module 09: Double Entry Accounting Module 10: Management Accounting and Financial Analysis Module 11: Career as a Tax Accountant in the UK ***Recruitment Consultant - Level 4*** Module 01 - Introduction to Recruitment: Importance and Implications Module 02 - An Overview of the Recruitment Industry Module 03 - The UK Recruitment Legislation Module 04 - Sales and Selling in the Recruitment Industry Module 05 - The Recruitment Process Module 06 - Key Performance Indicators for the Recruitment Industry Module 07 - Candidate Attraction for Recruitment Module 08 - Candidate Management Module 09 - Candidate Interview Processes Module 10 - Client Acquisition Module 11 - Client Strategy in the Recruitment Sector Module 12 - Client Management Module 13 - Steps to Starting and Running a Successful Recruiting Service ***Certificate in CV Writing and Interview Skills*** AN OVERVIEW AND INTRODUCTION Why take this course? Introduction to the course. SECTION 2 THE MAIN LECTURES Your CV - the interviewer's reason to eliminate you! Your CV needs to work harder than you think The three missing 'Traits' You've got the interview - NOW WHAT? What are my 'Tangibles'? Proof Positive!! The 'Missing Ingredient' to virtually guarantee selection! Why does this work so well? The final hurdle Bringing it all together ***HR Management Level 3*** Module 01: Introduction to Human Resource Module 02: Employee Recruitment and Selection Procedure Module 03: Employee Training and Development Process Module 04: Performance Appraisal Management Module 05: Employee Relations Module 06: Motivation and Counselling Module 07: Ensuring Health and safety at the Workplace Module 08 : Employee Termination Module 09: Employer Record and Statistics Module 10: Essential UK Employment Law ***Virtual Interviewing for HR*** Module 1: An Introduction to Virtual Interviewing Module 2: Interviewer's Perspective Module 3: Interview Preparation Module 4: Picking a Tech to Use Module 5: Attract and Hire the Best Talents Module 6: Final Thoughts and Onboarding ***GDPR Data Protection Level 5*** Module 01: GDPR Basics Module 02: GDPR Explained Module 03: Lawful Basis for Preparation Module 04: Rights and Breaches Module 05: Responsibilities and Obligations ***Preventing Workplace Violence and Harassment Level 3*** Workplace Management: Violence Workplace Management: Harassment How will I get my certificate? After successfully completing the course, you will get your CPD Accredited Certificate (PDF + Hardcopy) as proof of your achievement. PDF Certificate: Free (Previously it was £10) Hardcopy Certificate: Free (Previously it was £20) CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol this Employment Law UK. Persons with similar professions can also refresh or strengthen their skills by enrolling in this course. Students can take this course to gather professional knowledge besides their study or for the future. Requirements Our Employment Law UK is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various Employment Law certifications will increase the value of your CV and open you up to multiple job sectors: HR Manager: £35,000 - £70,000 Recruitment Consultant: £25,000 - £55,000 Employment Law Solicitor £40,000 - £100,000 Payroll Manager: £30,000 - £55,000 Pensions Advisor: £25,000 - £50,000 Training and Development Manager: £40,000 - £65,000 Certificates CPDQS Accredited e-Certificate Digital certificate - Included CPDQS Accredited Hard-Copy Certificate Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Employment Law UK) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

Duration 5 Days 30 CPD hours This course is intended for The primary audience for this course is any IT, facilities or data centre professional, who are involved in the design/build, renovation or relocation of a mission-critical data centre. Overview This 5-day course is designed to prepare participants to analyse a given business case and perform technical evaluation for a project plan and a set of designs for the implementation of a mission critical data centre. The course also engages participants in product evaluations and demonstrates how to select equipment and develop equipment test scripts (IET) and integrated performance and validation testing (IPVT). CDCE© builds upon knowledge gained in CDCP and CDCS courses. Participants who pass the exam will join the industry's elite data centre project design experts. CDCE© is the highest level training in the EPI Design and Build training track under the EPI Data Centre Training Framework. Participants must hold a valid CDCS certificate in order to be able to register for the CDCE class. CDCE© is the premier certification for data centre professionals in the data centre design/build and related fields. Data Centre Life Cycle Data centre lifecycle stages and phases Exercise: Stage/Phase/Milestone/Document mapping Design Preparation Creation of a SON ? Statement Of Need Technology review Conceptual sizing How to calculate for computer room space How to calculate facility space How to calculate incoming power Exercise: Conceptual sizing building and power Analysing capacity of existing facility Analysing investment options Site selection Permits and approvals Exercise: Site selection Conceptual design Budget and project timeline Business case preparation Project delivery structure Project management options Project manager and team Design Planning OSRA?Operational Systems Requirement Analysis TFRA?Technical Facilities Requirement Analysis Operations and maintenance review RFP?Request For Proposal process Vendor selection Design Development Project planning Design development PDR ? Preliminary Design Review Equipment selection FDR/V ? Final Design Review/Validation Exercise: Full design validation of power, cooling, floor plans, fire suppression Design freeze and LLTI Creation of construction documents BOM/BOQ ? Bill Of Material/Bill Of Quantity Exercise: Equipment selection Acquire Requirements of purchase orders Shipping terms FWT/FAT ? Factory Witness Test/Factory Acceptance Test Sequencing Incoming goods inspection and handling Asset management Construct Temporary essential services Erection of the building Permanent essential services Building inspection Snag list COF?Certificate Of Fitness Fit-Out Fit-Out Builders cleaning As-Built Drawings Test & Commissioning IET?Individual Equipment Test IPVT/IST?Integrated Performance Verification Test/Integrated Systems Test Common mistakes with IET/IPVT Deep cleaning Exercise: IET/IPVT scripting Hand-Over Facility hand-over requirements and documents PCC?Practical Completion Certificate DLP?Defect Liability Period Defect Management ICT Systems Installation ICT Systems Testing Hand-Over/DLP Expiry FCC?Final Completion Certificate Retirement Reasons and definitions of retirement Building the business case and project plan Sequencing Transfer of site Demolishing of site Legal matters FCC?Final Completion Certificate Exam: Certified Data Centre Expert (CDCE©) The CDCE© exam is in two parts: Part A is a 90-minute closed book exam, with 60 multiple-choice questions. For Part A, the candidate requires a minimum of 45 correct answers to pass the exam. Part B is a 90-minute closed book exam, with 25 open questions. For Part B the candidate needs to obtain a minimum of 75% to pass. Additional course details: Nexus Humans Certified Data Centre Expert (CDCE) 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 Certified Data Centre Expert (CDCE) 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.

Become a confident early years and phonics teacher with this comprehensive bundle. Master the EYFS framework, effective phonics strategies, supporting SEN children, and lesson planning. Gain insights into child psychology and school administration. Ideal for aspiring and current early years educators.

QA Level 7 in Eyebrow Artistry provides knowledge and practical competence in health & safety within the salon and eyebrow artistry and is regulated by the SQA. The strategy for delivery of this unit is based upon a combination of online theory, and autonomous learning, workshops and practical sessions. This is delivered over 6 sessions. The final stage is an assessment which is submitted to SQA and finally your certificate will be issued. This award is aimed at equipping therapists with skills required for work in salons, destination/day spas and cruise ships. The units have been identified by employers as the most appropriate for working as a beauty therapist and going on to work as a brow artist however, there are many CPD courses that can enhance the skills learnt and provide new techniques to ensure that the qualified therapist remains current and at the forefront of the industry

6 in 1 Audio Typing & Touch Typing Bundle Did you know that the UK Office Skills Association reports that 95% of employers consider typing skills essential for office-based roles, and 90% seek candidates with strong typing skills? Mastering touch typing can increase typing speed and accuracy, boost productivity, and make you a valuable asset to any organisation, according to a recent study. This Audio Typing & Touch Typing bundle is an all-encompassing package designed to enhance key administrative skills, crucial in today's fast-paced professional environment. This Audio Typing & Touch Typing bundle will teach you how to touch type quickly and accurately, which will make you a more valuable asset to any employer. In addition to touch typing, this Audio Typing & Touch Typing bundle will also teach you a variety of other essential skills, such as how to take minutes, use Microsoft Word, and provide excellent customer service. Embrace the opportunity to transform your professional life with our Audio Typing & Touch Typing bundle. Enrol now! This Audio Typing & Touch Typing Bundle Contains 6 of Our Premium Courses for One Discounted Price: Course 01: Touch Typing Masterclass Course 02: Admin, Secretarial & PA Course 03: Transcription Level 3 Course 04: Minute Taking Course 05: Proofreading & Copyediting Course 06: Complete Microsoft Word Learning Outcomes of this Bundle Master efficient touch typing techniques for enhanced workplace productivity. Acquire advanced Microsoft Word skills for professional document management. Develop effective customer service strategies for improved client relations. Gain comprehensive knowledge in administrative and secretarial practises. Learn efficient minute-taking for accurate meeting documentation. Understand facilities management essentials for operational efficiency. Why Choose Our Bundle? FREE Audio Typing & Touch Typing certificate accredited Get a free student ID card with Audio Typing & Touch Typing Training Get instant access to this Audio Typing & Touch Typing course. Learn Audio Typing & Touch Typing from anywhere in the world The Audio Typing & Touch Typing is affordable and simple to understand The Audio Typing & Touch Typing is an entirely online, interactive lesson with voiceover audio Lifetime access to the Audio Typing & Touch Typing course materials The Audio Typing & Touch Typing comes with 24/7 tutor support Start your learning journey straightaway with Audio Typing & Touch Typing This comprehensive Audio Typing & Touch Typing bundle encompasses six in-depth courses that will equip you with the skills and knowledge you need to excel in the workplace. Learn touch typing techniques to enhance your productivity, master administrative and secretarial duties, hone your minute-taking skills, become a Microsoft Word expert, provide exceptional customer service, and gain a solid understanding of facilities management principles. Assessment Process Once you have completed all the courses in the Audio Typing & Touch Typing bundle, you can assess your skills and knowledge with an optional assignment. Our expert trainers will assess your assignment and give you feedback afterwards. CPD 260 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Audio Typing & Touch Typing bundle is suitable for everyone. Requirements Audio Typing & Touch Typing You will not need any prior background or expertise in this Audio Typing & Touch Typing Bundle. Career path Audio Typing & Touch Typing This Audio Typing & Touch Typing bundle will allow you to kickstart or take your career to the next stage in the related sector such as: Executive Assistant Office Manager Customer Service Admin Coordinator Facilities Supervisor Secretarial Role Certificates CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited Hard copy certificate Hard copy certificate - £29 If you are an international student, you will be required to pay an additional fee of 10 GBP for international delivery, and 4.99 GBP for delivery within the UK, for each certificate

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

SUMMER SALE !!! | UP to 95% Discount !!! | **FREE Downloadable PDF Resources** | CPD Accredited | Lifetime Access