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

1223 Logic courses in Sheffield delivered Online

Build Performant GraphQL Backends in Days Using Hasura

By Packt

This course covers all the basics to more advanced features and dives into all the little details about Hasura. Hasura provides a platform to create your GraphQL backends easier and faster than you ever thought possible without writing a single line of code!

Build Performant GraphQL Backends in Days Using Hasura
Delivered Online On Demand7 hours 1 minutes
£74.99

Advanced Mathematics Training

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 Advanced Mathematics Training 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 Advanced Mathematics Training Course is one of the most prestigious training offered at Skillwise and is highly valued by employers for good reason. This Advanced Mathematics Training 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 Advanced Mathematics Training 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 Advanced Mathematics Training ? 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 Advanced Mathematics Training 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 Advanced Mathematics Training 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 Advanced Mathematics Training does not require you to have any prior qualifications or experience. You can just enrol and start learning. This Advanced Mathematics Training 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 Advanced Mathematics Training is a great way for you to gain multiple skills from the comfort of your home. Introduction Introduction 00:01:00 Mathematical Logic Introduction to Mathematical Logic, What is Sentence,Statements and their Types 00:02:00 Intro to Logical Connectivity,Tautology,Contradiction,Contingency,Pattern 00:06:00 Quantitative and Quantified Statement and types and example 00:03:00 Dual : Replacing of Connections and Symbols 00:02:00 Negations of Compound Statement , Converse, Inverse , & Contrapositive 00:03:00 Algebra of Statements and Law 00:05:00 Real Life application of Logic to Switching Electric Circuit 00:05:00 Matrices Intro to Matrices , Multiplication and Addition using Matrix 00:06:00 Inverse of Matrix Uniqueness of Inverse,Elementary Transformation 00:08:00 Method of REDUCTION AND INVERSION with real life example how we can implement 00:17:00 Trigonometric Functions Introduction to Trigonometric Function 00:03:00 General Solutions And Theorem 00:10:00 Solution of Triangle : Polar Co-ordinates 00:21:00 Rules and Theorems of SIn Cosine and TAN 00:22:00 Inverse Trigonometric Function 00:25:00 Pair Of Straight Line Introduction & Combined Equations 00:07:00 Degrees and Types 00:12:00 Some Theorem 00:17:00 Lines & Planes Introduction - vector cartesian theorem 00:02:00 Cartesian Equation & 2 Point Theorem 00:03:00 Theorems & Problem Solving 00:05:00 Distance of Point Line 00:05:00 Skew Lines 00:01:00 Distance of skew lines 00:03:00 Distance between parallel lines 00:02:00 Equation of Plane and Cartesian Form 00:10:00 Linear Programming Linear Programming Introduction 00:08:00 Introduction to LPP (Linear Programming Problem) 00:05:00 LPP PROBLEM SOLVING 00:07:00 Order Your Certificate Order Your Certificate QLS

Advanced Mathematics Training
Delivered Online On Demand
£29

C&G 2392-10 – Level 2 Certificate in Fundamental Inspection, Testing & Initial Verification

4.7(1243)

By Technique Learning Solutions

City & Guilds 2392 10 level 2 is a short course aimed at newcomers to inspection and testing of electrical installations, and also the logical route towards 2391-50, 2391-51, or 2391-52. City & Guilds 2392 10 level 2 Certification is achieved on successful completion of both the practical assessment and PC based examination. A four day course for a student possessing a working knowledge of the wiring regulations, to the level of City and Guilds 2382. We strongly recommend City and Guilds 2382 is achieved prior to sitting this City & Guilds 2392 10 level 2 course, though this is NOT an entry requirement. The City & Guilds 2392 10 level 2 exam is a PC based multiple choice examination has 50 questions, is 1 hour 40 mins long and is closed book, with instant result. To further support this City & Guilds 2392 10 level 2 course, we offer a 1 day practical workshop available to candidates who have completed the course and require further ‘hands on’ practical experience prior to their practical examination. Most students who take this option, elect to complete this the day before their practical assessment. The practical assessment takes approximately 2 hours, this can, if available, be taken on the day following the on-line examination or at a later date at a time which is mutually convenient to both student and centre. The City & Guilds 2392 10 level 2 course costs include examination entry fees, a buffet lunch and refreshments throughout the day. The course costs include examination entry fees.

C&G 2392-10 – Level 2 Certificate in Fundamental Inspection, Testing & Initial Verification
Delivered in Clay Cross + 1 more or Online + more
£500

Introduction to DAX for Power BI

By Nexus Human

Duration 2 Days 12 CPD hours This course is intended for This course is intended for business users who have been using Power BI to build analytic solutions and are ready to take advantage of the power and flexibility that DAX provides. Learning DAX is a very common 'next step' for experienced Power BI users. Overview At course completion, you should be able to describe DAX syntax, data types, and errors use DAX to create calculated columns, measures, and tables explain how DAX calculations are evaluated, along with the differences between row context and filter context configure and use Time Intelligence to perform common time-based calculations, for example to-date calculations, year-over-year analysis, moving averages, etc. create calculated columns and measures that use data from multiple tables in the data model write measures that handle error conditions gracefully use DAX to enhance the Power BI user experience use DAX Studio to connect to a Power BI data model and execute simple queries Welcome to Introduction to DAX for Power BI. This two-day instructor-led course is intended for business users who have been using Power BI and want to use DAX to create custom calculations in their data models. In this class, you will be introduced to using Data Analysis Expressions (DAX), which is the expression language that is used to create custom calculations in the Power BI Data model. The course covers some of the theoretical underpinnings of the data model and the DAX language, but the emphasis is on using DAX to solve common business problems. You will learn how to write your own calculated columns, measures, and tables, how to visualize the way Power BI computes DAX calculations, and how to troubleshoot custom code. MODULE 1: GETTING STARTED WITH DAX INTRODUCTION TODAX CREATING OBJECTS WITHDAX CONTEXT AND RULES OF EVALUATION VARIABLES,COMMENTS,AND TESTING MODULE 2: PERFORMING BASIC CALCULATIONS GETTING STARTED IMPLICIT MEASURES ADDING QUICK MEASURES WORKING WITH DAX DATA TYPES . DOING BASIC MATH USING LOGIC IN YOUR CALCULATIONS USING THE IF() FUNCTION NESTED IF() USING THE SWITCH() FUNCTION ADVANCED SWITCH() LOGICAL OPERATORS & FUNCTIONS: ||, OR(), &&, AND(), NOT() AGGREGATING AND SUMMARIZING DATA THE SUM() FUNCTION MODULE 3: WORKING WITH CONTEXT IN THE DATA MODEL CONTEXT DEFINED DATA MODELING BASICS INTRODUCTION TO DIMENSIONAL MODELING RELATIONSHIPS AND THEIR EFFECT ON THE EVALUATION CONTEXT GETTING DATA FROM OTHER TABLES USING RELATED() AND RELATEDTABLE LOOKING UP DATA WITHOUT USING RELATIONSHIPS MODIFYING THE CONTEXT USING CALCULATE() MODULE 4: PERFORMING MORE ADVANCED CALCULATIONS THE DAX ITERATOR FUNCTIONS USING TABLE MANIPULATION FUNCTIONS MODULE 5: WORKING WITH TIME PERFORMING DATE CALCULATIONS WORKING WITH DATE TABLES GENERATING A DATE TABLE WITH THE CALENDAR() FUNCTION DEFINING CUSTOM OPERATING PERIODS YTD, QTD, AND MTD CALCULATIONS CUSTOM TO-DATE CALCULATIONS FINDING YEAR-OVER-YEAR CHANGE FINDING MOVING AVERAGES MODULE 6: ENHANCING THE USER EXPERIENCE CONTROLLING VISIBILITYOF YOUR MEASURES USING WHAT-IF PARAMETERS ADDING BANDING USING DAX TO PROVIDE ROW-LEVEL SECURITY

Introduction to DAX for Power BI
Delivered OnlineFlexible Dates
£900

Software Security Testing

By Packt

Learn how to perform security audits, penetration testing, and code auditing for modern software in the web/cloud, mobile, and desktop. This course will help you master industry standards and enable you to carry out professional assessments to secure technologies as well as communicate risks to high-level executives, management, and technical staff.

Software Security Testing
Delivered Online On Demand7 hours 59 minutes
£149.99

ASP.NET Core Identity - Authentication and Authorization

By Packt

Authorization, authentication and user management are the mainstay features in real world applications. Identity core is the flagship library packaged with ASP.NET Core projects to help us get the most security possible out of the box. Getting authentication and authorization done right in your website can help keep your users and their data safe from attacks.

ASP.NET Core Identity - Authentication and Authorization
Delivered Online On Demand4 hours 52 minutes
£41.99

Excel: Top 50 Microsoft Excel Formulas in 50 Minutes!

4.7(160)

By Janets

The Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! is a wonderful learning opportunity for anyone who has a passion for this topic and is interested in enjoying a long career in the relevant industry. It's also for anyone who is already working in this field and looking to brush up their knowledge and boost their career with a recognised certification. This Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! consists of several modules that take around 1 hour to complete. The course is accompanied by instructional videos, helpful illustrations, how-to instructions and advice. The course is offered online at a very affordable price. That gives you the ability to study at your own pace in the comfort of your home. You can access the modules from anywhere and from any device. Why choose this course Earn an e-certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays 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 Certification Upon successful completion of the course, you will be able to obtain your course completion PDF Certificate at £9.99. Print copy by post is also available at an additional cost of £15.99 and the same for PDF and printed transcripts. Course Content Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! Have Microsoft Excel Problems? 00:01:00 How to Get the Most from this Course 00:01:00 Text Formulas In Excel 00:08:00 Text Formulas Exercise 00:01:00 Text Formulas Exercise - Answers 00:01:00 Mathematical Formulas In Excel 00:04:00 Mathematical Formulas Exercise 00:01:00 Mathematical Formulas Exercise - Answers 00:01:00 Date and Time Formulas In Excel 00:05:00 Date and Time Formulas Exercise 00:01:00 Date and Time Formulas Exercise - Answers 00:01:00 Logic Formulas In Excel 00:12:00 Logic Formulas Exercise 00:01:00 Logic Formulas Exercise - Answers 00:01:00 Financial Formulas In Excel 00:06:00 Financial Formulas Exercise 00:01:00 Financial Formulas Exercise - Answers 00:02:00 Informational Formulas In Excel 00:04:00 Informational Formulas Exercise 00:01:00 Informational Formulas Exercise - Answers 00:01:00 Order your Certificates & Transcripts Order your Certificates & Transcripts 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Excel: Top 50 Microsoft Excel Formulas in 50 Minutes!
Delivered Online On Demand54 minutes
£25

Criminology, Profiling & UK Justice System

4.5(3)

By Studyhub UK

Delve into the shadowy realms of criminal behaviour and the intricacies of the legal framework with our 'Criminology, Profiling & UK Justice System' course. This programme is an intellectual journey, guiding learners through the labyrinthine nature of criminal minds and societal responses to misconduct. Embark on a path that begins with the fundamental aspects of criminology and offender profiling, where each session is a stepping stone to a profound understanding of the forces that drive unlawful actions. The curriculum is meticulously sculpted to provide an immersive exploration from the initial contemplation of criminal acts to the delicate art of crime scene management. The chapters unfold, revealing the complexities of criminal psychology and the science behind forensic investigation. This course is a blueprint for those seeking to comprehend the strategic phases of profiling and the application of science, logic, and metacognition in understanding the criminal. It extends beyond theoretical knowledge, offering a comprehensive view of victimology and the mechanisms of the justice system in England and Wales. Such a course promises to transform your perception, equipping you with the acumen to decode the most enigmatic of cases. Learning Outcomes Discern the foundations and classifications of crime and criminal behaviour. Evaluate crime scenes and the methodology of dealing with various crimes. Comprehend the psychological underpinnings of criminal acts. Grasp the essentials of forensic science in criminal investigations. Understand the operational aspects of criminal profiling and the UK justice system. Why choose this Criminology, Profiling & UK Justice System course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Criminology, Profiling & UK Justice System Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Who is this Criminology, Profiling & UK Justice System course for? Individuals intrigued by the psychological aspects of crime. Legal professionals aspiring to augment their knowledge of criminal behaviour. Forensic science enthusiasts eager to understand crime scene intricacies. Law enforcement personnel aiming to enhance their profiling expertise. Students of psychology and criminal justice seeking a comprehensive education in criminology. Career path Criminologist: £25,000 - £40,000 Forensic Psychologist: £27,000 - £60,000 Police Detective: £29,000 - £39,000 Criminal Profiler: £30,000 - £50,000 Forensic Scientist: £20,000 - £45,000 Legal Consultant: £35,000 - £75,000 Prerequisites This Criminology, Profiling & UK Justice System does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Criminology, Profiling & UK Justice System was made by professionals and it is compatible with all PC's, Mac's, 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. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Module 01: Introduction to Criminology and Profiling Introduction to Criminology and Profiling 00:23:00 Module 02: Classification of Crime Classification of Crime 00:18:00 Module 03: Violent Crimes Violent Crimes 00:29:00 Module 04: The Crime Scene The Crime Scene 00:30:00 Module 05: Dealing with Crime Dealing with Crime 00:41:00 Module 06: Understanding Criminal Psychology Understanding Criminal Psychology 00:31:00 Module 07: Forensic Science Forensic Science 00:35:00 Module 08: Phases of Profiling Phases of Profiling 00:33:00 Module 09: Criminal Profiling: Science, Logic and Metacognition Criminal Profiling: Science, Logic and Metacognition 00:28:00 Module 10: Offender Profiling: Pragmatic Solution and Behavioural Investigative Advice Offender Profiling: Pragmatic Solution and Behavioural Investigative Advice 00:22:00 Module 11: Victimology Victimology 00:25:00 Module 12: The Criminal Justice System in England and Wales The Criminal Justice System in England and Wales 00:19:00

Criminology, Profiling & UK Justice System
Delivered Online On Demand5 hours 34 minutes
£10.99

Criminal Procedure, Law and Psychology Diploma

4.5(3)

By Studyhub UK

The Criminal Procedure, Law and Psychology Diploma will teach you everything you need to know to kickstart a successful career in the field of criminal law. It covers fundamental procedures, the legal framework and codes of practice, equipping you with the core skills required to become a qualified Criminal Lawyer. This training program has been designed by experts in the industry to give you the best learning experience. Enrol in this comprehensive course today and gain the practical and theoretical knowledge of the basics of law and legal procedure! Please note that completing this online program does not qualify you to work as a licensed Practitioner Psychologists. Please contact with the HCPC or the RCSLT if you are looking for a course that meets the guideline of HCPC. Learning Outcomes Classify and understand various forms of crime, laying the foundation for criminal analysis. Navigate the complexities of the UK legal system, gaining insights into legal principles and practices. Explore the intricacies of criminal psychology, unraveling the motives and behavior patterns of offenders. Apply forensic science techniques to analyze evidence and contribute to crime resolution. Master the art of criminal profiling, combining science, logic, and metacognition for investigative excellence. Why choose this Criminal Procedure, Law and Psychology Diploma? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Criminal Procedure, Law and Psychology Diploma for? Aspiring legal professionals with an interest in criminal law and psychology. Psychology enthusiasts keen on understanding the behavioral aspects of criminal activity. Students pursuing careers in law enforcement, criminal justice, or forensic science. Individuals intrigued by the intersection of law, psychology, and crime prevention. Anyone looking to enhance their knowledge of the UK legal system and criminal profiling. Career path Criminal Psychologist: £30,000 - £60,000 Forensic Scientist: £25,000 - £45,000 Legal Consultant: £28,000 - £55,000 Crime Analyst: £20,000 - £40,000 Police Officer/Detective: £24,000 - £55,000 Legal Researcher: £22,000 - £45,000 Prerequisites This Criminal Procedure, Law and Psychology Diploma does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Criminal Procedure, Law and Psychology Diploma was made by professionals and it is compatible with all PC's, Mac's, 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. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Module 1: Classification of Crime Classification of Crime 00:18:00 Module 2: UK Law & Legal System UK Law & Legal System 00:34:00 Module 3: Understanding Criminal Psychology Understanding Criminal Psychology 00:31:00 Module 4: Dealing with Crime Dealing with Crime 00:41:00 Module 5: Forensic Science Forensic Science 00:35:00 Module 6: Criminal Profiling: Science, Logic and Metacognition Criminal Profiling: Science, Logic and Metacognition 00:28:00 Module 7: Offender Profiling: Pragmatic Solution and Behavioural Investigative Advice Offender Profiling: Pragmatic Solution and Behavioural Investigative Advice 00:22:00 Module 8: The Legal Workplace & Professionals The Legal Workplace & Professionals 00:46:00 Module 9: Criminal Law Criminal Law 00:24:00 Module 10: The Criminal Justice System in England and Wales The Criminal Justice System in England and Wales 00:19:00 Mock Exam Mock Exam - Criminal Procedure, Law and Psychology Diploma 00:20:00 Final Exam Final Exam - Criminal Procedure, Law and Psychology Diploma 00:20:00

Criminal Procedure, Law and Psychology Diploma
Delivered Online On Demand5 hours 38 minutes
£10.99

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