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

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

70-461 Session 5: Querying Microsoft SQL Server 2012 (T-SQL). With the help of this course you can Using T-SQL, create analytical functions, grouping sets, ranking functions, spatial aggregates. SQL 2012-2016 (70-761).

This course was created by Phillip Burton. It was rated 4.8 out of 5 by approx 6855 ratings. There are approx 80795 users enrolled with this course, so don’t wait to download yours now. This course also includes 3.5 hours on-demand video, 2 Articles, 4 Supplemental Resources, Full lifetime access, Access on mobile and TV & Certificate of Completion.

What Will You Learn?

  • Apply the ranking functions ROW_NUMBER, RANK, DENSE_RANK and NTILE

  • Use the analytic functions new to SQL Server 2012, such as LAG, LEAD, FIRST_VALUE and LAST_VALUE

  • Use different ways to group, such as ROLLUP, CUBE, GROUPING SETS, and related functions such as GROUPING_ID.

  • Understand the geography and geometry data types, add points, line, polygons and circles, query these tables, find where lines and shapes intersect, and aggregate them.

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.

Rating:
4.2

Download Links

Get Download Link

Related Courses

Microsoft 70-464 Developing Microsoft SQL Server 2012 Da…

Querying Microsoft SQL Server Databases using T-SQL

Administering Microsoft SQL Server 2012 Databases – 70-462

Microsoft 70-462: Administering SQL Server 2012 Databases

Microsoft SQL Server 2012 Certification Training Exam 70-463

Microsoft SQL Server 2012 Certification Training Exam 70-462

Writing Advanced SQL Queries on Microsoft SQL Server

SQL Server 101 : Microsoft SQL Server for Absolute Beginners

Sub Query Magic: Write T-SQL Subqueries Using SQL Server

T-SQL For Beginners: Learn to Query SQL Server Databases

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

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

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

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

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

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

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

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

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

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

70-461 Session 1: Querying Microsoft SQL Server ’12-16 T-SQL

70-461 Session 1: Querying Microsoft SQL Server ’12-16 T-SQL

Microsoft 70-461: Querying SQL Server 2012

Microsoft 70-461: Querying SQL Server 2012

Querying Microsoft SQL Server 2012 – (Exam No. 70-461)

Querying Microsoft SQL Server 2012 – (Exam No. 70-461)

Microsoft MCSA 70-461 Querying Microsoft SQL Server Test

Microsoft MCSA 70-461 Querying Microsoft SQL Server Test

Microsoft SQL Server 2012 Certification Training Exam 70-461

Microsoft SQL Server 2012 Certification Training Exam 70-461
Go To Top