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

44482 Courses in Cardiff delivered Online

Job Search Skills

4.9(27)

By Apex Learning

Overview This comprehensive course on Job Search Skills will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Job Search Skills comes with accredited certification which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this Job Search Skills. It is available to all students, of all academic backgrounds. Requirements Our Job Search Skills is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 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 qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 9 sections • 9 lectures • 02:34:00 total length •Job Search Skills: Getting Started: 00:18:00 •CV Writing: 00:31:00 •Cover Letter: 00:21:00 •Personal Development: 00:22:00 •Fundamental Skills: 00:14:00 •Job Market Research: 00:12:00 •Networking: 00:15:00 •The Interview: 00:21:00 •Assignment - Job Search Skills: 00:00:00

Job Search Skills
Delivered Online On Demand2 hours 34 minutes
£12

Academic and Research Skills for Business

By SkillWise

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents, and interests with our special Academic and Research Skills for Business Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides the professional training that employers are looking for in today's workplaces. The Academic and Research Skills for Business Course is one of the most prestigious training offered at Skillwise and is highly valued by employers for good reason. This Academic and Research Skills for Business Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Academic and Research Skills for Business Course, like every one of Skillwise's courses, is meticulously developed and well-researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At Skillwise, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from Skillwise, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Academic and Research Skills for Business ? Lifetime access to the course forever Digital Certificate, Transcript, and student ID are all included in the price Absolutely no hidden fees Directly receive CPD Quality Standard-accredited qualifications after course completion Receive one-to-one assistance every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Academic and Research Skills for Business there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the PDF certificate for free. Original Hard Copy certificates need to be ordered at an additional cost of £8. Who is this course for? This Academic and Research Skills for Business course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already work in relevant fields and want to polish their knowledge and skills. Prerequisites This Academic and Research Skills for Business does not require you to have any prior qualifications or experience. You can just enrol and start learning. This Academic and Research Skills for Business was made by professionals and it is compatible with all PCs, Macs, tablets, and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as a bonus, you will be able to pursue multiple occupations. This Academic and Research Skills for Business is a great way for you to gain multiple skills from the comfort of your home. Module 01: Assessing Own Academic Competence Assessing Own Academic Competence 00:18:00 Module 02: Primary and Secondary Methods Primary and Secondary Methods 00:19:00 Module 03: Taking Notes From Various Sources Taking Notes From Various Sources 00:17:00 Module 04: Planning and Drafting Research Planning and Drafting Research 00:14:00 Module 05: Developing Business Plan Developing Business Plan 00:15:00 Module 06: Data Analysis Data Analysis 00:17:00 Module 07: Market Research Report Market Research Report 00:16:00

Academic and Research Skills for Business
Delivered Online On Demand
£39

Mastering Management Fundamentals

5.0(12)

By DCo - The Development Company UK Ltd

The ‘Mastering Management Fundamentals Open Programme’ is a 5 module online course that is designed to improve your management success and performance. It will give you the practical tools and insight to be able to make changes and directly improve your management skills over a 5-6 month period.

Mastering Management Fundamentals
Delivered OnlineFlexible Dates
£3,000

Functional Skills Maths (Updated 2023)

4.7(47)

By Academy for Health and Fitness

Have you ever felt overwhelmed or stressed when faced with everyday mathematical challenges? Whether it's working out your monthly budget, understanding taxes, or planning a home renovation, the importance of functional maths skills cannot be overstated. Our Functional Skills Maths course is here to empower you with the essential knowledge and tools to overcome these obstacles and excel in all aspects of daily life. By enrolling in our carefully crafted course, you will gain the confidence to tackle real-world mathematical problems head-on. From mastering fractions, decimals, and percentages to navigating the complexities of ratios and proportions, our curriculum offers a comprehensive approach to functional maths. Develop your skills in areas such as money management, unit conversions, and 2-D and 3-D shape calculations, all while discovering the fascinating world of statistics and probability. Not only will you be equipped to handle everyday mathematical situations, but your newfound expertise will also open doors to a variety of career opportunities. Employers across numerous industries value strong numeracy skills, and our course can serve as a stepping stone to roles in retail management, financial administration, construction estimation, bookkeeping, and more. So why wait? Enrol in our Functional Skills Maths course and start unlocking your true potential. Experience the satisfaction and sense of accomplishment that comes with mastering essential mathematical skills, and watch as new opportunities unfold before your eyes. Invest in your future and gain the confidence to excel in all aspects of your daily life. This Advanced Diploma in Functional Skills Maths at QLS Level 2 course is endorsed by The Quality Licence Scheme and accredited by CPDQS (with 60 CPD points) to make your skill development & career progression more accessible than ever! Learning Outcomes: Develop numeracy skills through reading, writing, and comparing numbers. Apply substitution techniques to solve formulas in various contexts. Master fractions, decimals, and percentages and understand their interrelations. Gain proficiency in calculating ratio, proportion, profit, and loss. Acquire knowledge of simple and compound interest, discounts, taxes, and money concepts. Confidently convert between metric and imperial units and work with compound measures. Calculate perimeters, areas, volumes, and surface areas of 2-D and 3-D shapes. Interpret and analyse statistical data and calculate probabilities. Why Prefer This Functional Skills Maths (Updated 2023) Course? Opportunity to earn certificate a certificate endorsed by the Quality Licence Scheme & another accredited by CPD QS after completing the Functional Skills Maths (Updated 2023) course Get a free student ID card! (£10 postal charge will be applicable for international delivery) Innovative and engaging content. Free assessments 24/7 tutor support. ****Course Curriculum**** Here is the curriculum breakdown of this Functional Skills Maths (Updated 2023) Section 01: Introduction Section 02: Read, Write, Compare and Order Numbers of any size Section 03: Substitution in Given Formula Section 04: Fractions Section 05: Decimal Numbers Section 06: Percentages Section 07: Equivalence between fractions, decimals and percentages Section 08: Ratio and Proportion Section 09: Profit & Loss Section 10: Discounts and Taxes Section 11: Simple Interest and Compound Interest Section 12: Money Section 13: Convert between metric and imperial units Section 14: Compound Measures including speed, density & rates of pay Section 15: Perimeters and Areas of 2-D shapes Section 16: Volumes and Surface Areas of 3-D shapes Section 17: Scale Drawings Section 18: Statistics Section 19: Probability Section 20 Bonus Section (Time Topic 11 Video Lectures) Assessment Process You have to complete the assignment questions given at the end of the course and score a minimum of 60% to pass each exam.Our expert trainers will assess your assignment and give you feedback after you submit the assignment. After passing the Advanced Diploma in Functional Skills Maths at QLS Level 2 course exam, you will be able to request a certificate at an additional cost that has been endorsed by the Quality Licence Scheme. CPD 60 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course is designed for individuals seeking to improve their functional maths skills for personal, educational, or professional purposes. By focusing on practical applications of maths, learners will gain a solid foundation in numeracy and problem-solving. The course is suitable for individuals who may be returning to education, preparing for exams, or looking to enhance their skills for the workplace. It is ideal for those who need a refresher in maths or are aiming to develop confidence in working with numbers. Career path Retail Manager - £22-35k/year Financial Administrator - £18-30k/year Construction Estimator - £25-50k/year Bookkeeper - £18-30k/year Teaching Assistant - £14-20k/year Certificates Certificate of completion Digital certificate - £10 Advanced Diploma in Functional Skills Maths at QLS Level 2 Hard copy certificate - £79 Show off Your New Skills with a Certificate of Completion After successfully completing the Advanced Diploma in Functional Skills Maths at QLS Level 2, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme. The certificate will be home-delivered, with a pricing scheme of - £79 inside the UK £10 (including postal fees) for International Delivery Certificate Accredited by CPDQS £29 for Printed Hard Copy Certificate inside the UK £39 for Printed Hard Copy Certificate outside the UK (International Delivery)

Functional Skills Maths (Updated 2023)
Delivered Online On Demand4 weeks
£12

Soft Skills: The 11 Essential Career Soft Skills

By IOMH - Institute of Mental Health

Overview In order to stand out from the crowd in a competitive job market and get on your desired career path, soft skills are more important than ever!  Soft skills generally refer to the qualities, characteristics, habits and abilities required to survive and thrive in the modern workplaces. In short, the soft skills are what set you apart from your competitors who have similar expertise to you. This Soft Skills: The 11 Essential Career Soft Skills course gives you a comprehensive understanding of what soft skills are and why these skills are more challenging to develop. Throughout the course, you will learn what it takes to develop your soft skills and how to communicate more effectively with colleagues, clients or customers. This comprehensive course also shares how developing soft skills can provide a confident, satisfied workforce and a positive work environment that will sustain your organisation and benefit your overall experience, not just your career. Essential Career Soft Skills: 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 Mock exams Multiple-choice assessment How is the course assessed? To successfully complete the course you must pass an automated, multiple-choice assessment. The assessment is delivered through our online learning platform. You will receive the results of your assessment immediately upon completion. Will I receive a certificate of completion? Upon successful completion, you will qualify for the UK and internationally-recognised certificate and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £9 and Hardcopy Certificate for £15. Why study this course Whether you're an existing practitioner or aspiring professional, this course will enhance your expertise and boost your CV with key skills and an accredited qualification attesting to your knowledge. The Soft Skills: The 11 Essential Career Soft Skills is open to all, with no formal entry requirements. All you need is a passion for learning, a good understanding of the English language, numeracy and IT, and to be over the age of 16. Course Curriculum Soft Skills: The 11 Essential Career Soft Skills Module One: Getting Started 00:05:00 Module Two: What are Soft Skills? 00:15:00 Module Three: Communication 00:15:00 Module Four: Teamwork 00:15:00 Module Five: Problem-Solving 00:15:00 Module Six: Time Management 00:15:00 Module Seven: Attitude and Work Ethic 00:15:00 Module Eight: Adaptability/Flexibility 00:15:00 Module Nine: Self-Confidence (Owning It) 00:15:00 Module Ten: Ability to Learn from 00:15:00 Module Eleven: Networking 00:15:00 Module Twelve: Wrapping Up 00:05:00

Soft Skills: The 11 Essential Career Soft Skills
Delivered Online On Demand2 hours 40 minutes
£11.99

Audio Typing & Touch Typing with Office Skills Diploma

4.9(27)

By Apex Learning

Humanity's future is digital, and the skills you'll learn in this Audio Typing & Touch Typing with Office Skills Diploma will prepare you to thrive in it. Did you know that the average human typing speed is 38 words per minute (WPM)? But with touch typing, you can easily achieve speeds of 60 WPM or more. And with audio typing, you can transcribe audio files even faster. This Audio Typing & Touch Typing with Office Skills Diploma Bundle will teach you everything you need to know to become a touch typist, as well as the essential office skills you need to succeed in your career. Along with this Audio Typing & Touch Typing with Office Skills course, you will get 10 premium courses, an original hard copy, 11 PDF Certificates (Main Course + Additional Courses), and a Student ID card as gifts. Learning Outcomes of Audio Typing & Touch Typing with Office Skills Diploma Bundle: Master touch typing and audio typing skills. Improve your English spelling, punctuation, grammar, and pronunciation. Develop your creative writing skills. Learn the fundamentals of copywriting and proofreading. Gain expertise in document control and content management. Master the essential skills of MS Word and time management. This Audio Typing & Touch Typing with Office Skills Diploma Bundle Consists of the following Premium courses: Course 01: Touch Typing Essentials Course 02: Transcription Course 03: Improve English Spelling, Punctuation, Grammar and Pronunciation Course 04: Creative Writing Complete Course Course 05: Advanced Diploma in Copywriting Course 06: Proofreading & Copyediting Course 07: Document Control Course 08: Content Management Course 09: Ultimate Transcription and Captioning Course Course 10: MS Word Diploma Course 11: Time Management Enrol in the Audio Typing & Touch Typing with Office Skills Diploma today and launch your career as a highly sought-after audio typist, transcriptionist, or office professional! In today's competitive job market, it's more important than ever to have the skills and knowledge that employers are looking for. One of the most in-demand skills is audio typing. Audio typists are responsible for transcribing audio recordings into text documents. This is a valuable skill in a variety of industries, including law, healthcare, business, and education. The Audio Typing & Touch Typing with Office Skills Diploma Bundle will teach you everything you need to know to become a successful audio typist. You will learn how to touch type quickly and accurately, transcribe audio recordings with ease, and improve your English spelling, punctuation, grammar, and pronunciation. In addition to audio typing skills, you will also learn the essential office skills you need to succeed in your career. This includes document control, content management, and time management. Course 01: Touch Typing Essentials Introduction How to Set up Your Computer How to type the letters F and J How to type the letters D and K How to type the letters S and L How to type the letter A and ; (semicolon) How to type the letters E and I How to type the letters R and U How to type the letters T and O How to type CAPITAL letters How to type the letter C and , (Comma) How to type the letters G and H How to type the letters N and V How to type the letters W and M How to type the letters Q and P How to type the letters B and Y How to type the letters Z and X How to type Colon and Semicolon How to type Full Stop and Comma How to type Question Mark and Exclamation Mark How to type Dash, Parentheses and Quotation Marks =========>>>>> And 10 More Courses <<<<<========= How will I get my Certificate? After successfully completing the Audio Typing & Touch Typing with Office Skills Diploma course, you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously, it was £10 * 11 = £110) Hard Copy Certificate: Free (For The Title Course) Enrol in the Audio Typing & Touch Typing with Office Skills Diploma course today and start your journey to a successful career! CPD 125 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Audio Typing & Touch Typing with Office Skills Diploma: Individuals who want to start a new career in audio typing, touch typing, or office administration Existing office professionals who want to advance their careers Students who want to develop marketable skills Anyone who wants to learn how to touch type quickly and accurately Requirements Our Audio Typing & Touch Typing with Office Skills Diploma is fully compatible with PCs, Macs, laptops, tablets 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 Audio Typing & Touch Typing with Office Skills Diploma Course. It can be studied in your own time at your own pace. Career path By completing the Audio Typing & Touch Typing with Office Skills Diploma Bundle, you will be well-positioned for a successful career in a variety of industries: Transcriptionist: £20,000-£30,000 Copywriter: £25,000-£40,000 Content Writer: £25,000-£35,000 Proofreader: £25,000-£35,000 Document Controller: £25,000-£35,000 Content Manager: £30,000-£45,000 Office Administrator: £20,000-£30,000 Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Touch Typing Essentials) 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.

Audio Typing & Touch Typing with Office Skills Diploma
Delivered Online On Demand
£39

Functional Skills English Level 2

By Compliance Central

Are you looking to enhance your Functional Skills English skills? If yes, then you have come to the right place. Our comprehensive course on Functional Skills English will assist you in producing the best possible outcome by mastering the Functional Skills English skills. The Functional Skills English course is for those who want to be successful. In the Functional Skills English course, you will learn the essential knowledge needed to become well versed in Functional Skills English. Our Functional Skills English course starts with the basics of Functional Skills English and gradually progresses towards advanced topics. Therefore, each lesson of this Functional Skills English course is intuitive and easy to understand. Why would you choose the Functional Skills English course from Compliance Central: Lifetime access to Functional Skills English course materials Full tutor support is available from Monday to Friday with the Functional Skills English course Learn Functional Skills English skills at your own pace from the comfort of your home Gain a complete understanding of Functional Skills English course Accessible, informative Functional Skills English learning modules designed by expert instructors Get 24/7 help or advice from our email and live chat teams with the Functional Skills English bundle Study Functional Skills English in your own time through your computer, tablet or mobile device. A 100% learning satisfaction guarantee with your Functional Skills English Course Improve your chance of gaining in demand skills and better earning potential by completing the Functional Skills English Functional Skills English Curriculum Breakdown of the Functional Skills English Course Module 01: Basics of Grammar Module 02: The Basics of Sentence Module 03: Structure of Sentence Module 04: Punctuation & Capitalisation Module 05: Spelling CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Functional Skills English course helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career in Functional Skills English. It is also great for professionals who are already working in Functional Skills English and want to get promoted at work. Requirements To enrol in this Functional Skills English course, all you need is a basic understanding of the English Language and an internet connection. Career path The Functional Skills English course will enhance your knowledge and improve your confidence in exploring opportunities in various sectors related to Functional Skills English. Certificates CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99

Functional Skills English Level 2
Delivered Online On Demand1 hour
£12

Enhance Skills in Spoken English

5.0(10)

By GBA Corporate

Overview Improve your knowledge of the English language and pronunciation and practice your speaking and vocabulary with our video lessons and with live face to face with the trainer online and In-Class. Choose your English course level from our wide range of english courses and start learning online today. Take any of our high quality online English lessons with the highlu experienced trainer and improve your English speaking skills along with your grammar, reading and writing. Start by taking our English lessons to help you find your level and increase your communication skills also find lessons and resources to improve your English skills. Throuh this course you will get more practice to improve your general English with our extended listening and reading materials and online trainer led training. Improve your the grammar and vocabulary and support your learning.

Enhance Skills in Spoken English
Delivered in Internationally or OnlineFlexible Dates
FREE to £382

Sales Skills & Negotiation Skills - Sales Training

By iStudy UK

Course Overview Master the art of selling with this Sales Skills & Negotiation Skills - Sales Training course! There's no denying that sales and negotiating skills are a must in today's world. If you want to succeed, then you must get good at selling and negotiating. When you get good at selling, your life becomes much easier.  This course will teach you how you can master the art of selling and negotiating. You'll learn how the mind of a master negotiator works, how you can sell anything by using the right techniques. You'll also learn how you can get the upper hand in negotiations, how to gain control of the room, how to read body language and many more. This sales training course is a goldmine for people who want to get better at selling. Enrol today and get certified with valuable professional skills.  Learn how you can sell anything and become a fantastic negotiator! What You Will Learn This is one of the best courses on sales and negotiation you'll find, and it'll teach you everything that you need to know about this topic. How To Become a Successful Sales Consultant Understand How the Sales Process Works From Start to Finish The Skills You Need to Get the Best From Any Negotiation and Sales Situation How to Negotiate Successfully How to Handle Objections How to Read Your Customers in a Sales Meeting How to Find Prospects to Sell to To Develop a Sales Strategy How to Manage Your Emotions in a Sales Situation How to Close a Sale How to Leverage Your Prospect for Multiple Sales Opportunities Why You Should Choose This Course From iStudy Study at your own pace Full Tutor support on weekdays (Monday - Friday) Fully compatible with any device Free Printable PDF Certificate immediately after completion No prior qualifications are needed to take this course No hidden fees or exam charges CPD Qualification Standards and IAO accredited Efficient exam system, assessment, and instant results Our customer support team is always ready to help you Gain professional skills and better earning potential Certification After completing the course you'll receive a free printable CPD accredited PDF certificate. Hard Copy certificate is also available, and you can get one for just £9! Accreditation This course is accredited by Continuing Professional Development (CPD). It is a recognised independent accreditation service. Enrol today and learn something new with iStudy. You'll find a full breakdown of the course curriculum down below, take a look and see just how much this course offers. We're sure you'll be satisfied with this course.

Sales Skills & Negotiation Skills - Sales Training
Delivered Online On Demand12 hours 31 minutes
£25

Querying Microsoft SQL Server

5.0(3)

By Systems & Network Training

Querying Microsoft SQL Server course description This course covers the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server and provides the foundation for all SQL Server-related disciplines; namely, database administration, database development and business intelligence. This course helps prepare for exam 70-761. Note: This course is designed for SQL Server 2014or SQL Server 2016. What will you learn Write SELECT statements. Create and implement views and table-valued functions. Transform data by implementing pivot, unpivot, rollup and cube. Create and implement stored procedures. Add programming constructs such as variables, conditions, and loops to T-SQL code. Querying Microsoft SQL Server course details Who will benefit: Database administrators, database developers, and business intelligence professionals. SQL power users, namely, report writers, business analysts and client application developers. Prerequisites: Database fundamentals Duration 5 days Querying Microsoft SQL Server course contents Introduction to Microsoft SQL Server Management studio, creating and organizing T-SQL scripts, using books online. Hands on working with SQL Server tools. T-SQL querying Introducing T-SQL, sets, predicate logic, logical order of operations in SELECT statements, basic SELECT statements, queries that filter data using predicates, queries that sort data using ORDER BY. Hands on introduction to T-SQL querying. Writing SELECT queries Writing simple SELECT statements, eliminating duplicates with DISTINCT, column and table aliases, simple CASE expressions. Hands on writing basic SELECT statements. Querying multiple tables cross joins and self joins, write queries that use Inner joins, write queries that use multiple-table inner joins, write queries that use self-joins, write queries that use outer joins, write queries that use cross joins. Hands on querying multiple tables. Sorting and filtering data Sorting data, filtering data with predicates, filtering data with TOP and OFFSET-FETCH, working with unknown values, WHERE clause, ORDER BY clause, TOP option, OFFSET-FETCH clause. Hands on sorting and filtering data. SQL Server data types Introducing SQL Server data types, Character data, date and time data, queries that return date and time data, write queries that use date and time functions, write queries that return character data, write queries that return character functions. Hands on working with SQL Server data types. DML Adding data to tables, modifying and removing data, generating automatic column values, Inserting records with DML, updating and deleting records using DML. Hands on using DML to modify data. Built-in functions Queries with built-in functions, conversion functions, logical functions, functions with NULL, queries that use conversion functions, queries that use logical functions, queries that test for nullability. Hands on built-in functions Grouping and aggregating data Aggregate functions, the GROUP BY clause, filtering groups with HAVING, queries that use the GROUP BY clause, queries that use aggregate functions, queries that use distinct aggregate functions, queries that filter groups with the HAVING clause. Hands on grouping and aggregating data. Subqueries Self-contained subqueries, correlated subqueries, EXISTS predicate with subqueries, scalar and multi-result subqueries. Hands on subqueries. Table expressions Views, inline table-valued functions, derived tables, common table expressions. queries that use views, write queries that use derived tables, Common Table Expressions (CTEs), write queries that se inline Table valued expressions (TVFs). Hands on table expressions. Set operators The UNION operator, EXCEPT and INTERSECT, APPLY, queries that use UNION set operators and UNION ALL, CROSS APPLY and OUTER APPLY operators. Hands on set operators. Windows ranking, offset, and aggregate functions OVER, window functions, ranking functions, offset functions, window aggregate functions. Hands on; windows ranking, offset, and aggregate functions. Pivoting and grouping sets PIVOT and UNPIVOT, grouping sets, queries that use the PIVOT operator, queries that use the UNPIVOT operator, queries that use the GROUPING SETS CUBE and ROLLUP subclauses. Hands on pivoting and grouping sets Executing stored procedures Querying data with stored procedures, passing parameters to stored procedures, simple stored procedures, dynamic SQL, the EXECUTE statement to invoke stored procedures. Hands on executing stored procedures. Programming with T-SQL T-SQL programming elements, controlling program flow, declaring variables and delimiting batches, control-of-flow elements, variables in a dynamic SQL statement, synonyms. Hands on programming with T-SQL Error handling T-SQL error handling, structured exception handling, redirect errors with TRY/CATCH, THROW to pass an error message back to a client. Hands on implementing error handling. Implementing transactions Transactions and the database engines, controlling transactions, BEGIN, COMMIT, and ROLLBACK, adding error handling to a CATCH block. Hands on implementing transactions.

Querying Microsoft SQL Server
Delivered in Internationally or OnlineFlexible Dates
£2,797