Explore

70-461 Session 5: Querying Microsoft SQL Server (write SQL)

3.5 hours on-demand video

$ 12.99

Save Course

Go to Course

Brief Introduction

Using SQL, create analytical functions, grouping sets, ranking functions, spatial aggregates. SQL Server 12-17 (70-761)

Description

If you are in UfB, welcome.

If you are not, don't buy this course. Instead, please look at my 70-461 Session 1-7: Querying Microsoft SQL Server (SQL code) course instead, which includes this course and 6 other courses.

This course is the foundation for the Microsoft Certificate 70-461: "Querying Microsoft SQL Server 2012".

In Sessions 1 and 2, we learned all about dates, strings and number data types and DML statements. In sessions 3 and 4, we created views, procedures, triggers, constraints and combining datasets.

We'll will now be creating aggregate queries, working through objective 9 of the exam 70-461. We'll be reviewing the ranking functions ROW_NUMBER, RANK, DENSE_RANK and NTILE. We'll look at the 8 analytic functions news to SQL Server 2012, such as LAG, LEAD, FIRST_VALUE and LAST_VALUE.

We'll look at alternative ways of grouping and adding totals, using ROLLUP, CUBE, GROUPING SETS and GROUPING_ID. We'll also look at the geometry and geography data types, plotting locations on a grid, together with functions and aggregates.

No prior knowledge other than what we covered in Sessions 1 to 4 is required. This course builds on the knowledge previously gained in those previous sessions.

There are regular quizzes to help you remember the information.

Once finished, you will know what how to write ranking functions, analytic functions, grouping sets and spatial aggregates, and we'll have expanded on our current knowledge of T-SQL.

Requirements

Requirements
You need to know about data types and functions, DML and DDL statements, creating views, triggers, constraints and procedures, and use UNION.
If you don't, then you should take my earlier Sessions first.
There is a 30-day money back guarantee of this Udemy course.
Why not have a look at the curriculum below and see what you can learn?

Recommended for you

70-461, 761: Querying Microsoft SQL Server with Transact-SQL

From Tables and SELECT queries to advanced SQL. SQL Server 2012, 2014, 2016, 2017, 2019, exams 70-461 and 70-761 Reviews "The instructor explain the things in great details....

Save Course

70-461 Session 3: Querying Microsoft SQL Server (T-SQL)

Using T-SQL in SSMS, add constraints, store queries in views, add triggers. SQL Server 2012, 2014, 2016, 2017 (70-761) If you are in UfB, welcome....

Save Course

70-461 Session 5: Querying Microsoft SQL Server (write SQL)

Using SQL, create analytical functions, grouping sets, ranking functions, spatial aggregates. SQL Server 12-17 (70-761) If you are in UfB, welcome....

Save Course