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

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

( 23 Reviews )

Created by: Phillip Burton

Produced in 2018

What you will 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.

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 86 / 100

Live Chat with CourseDuck's Co-Founder for Help

Need help deciding on a sql course? Or looking for more detail on Phillip Burton's 70-461 Session 5: Querying Microsoft SQL Server (write SQL)? Feel free to chat below.

Join CourseDuck's Online Learning Discord Community

Course 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.Who this course is for:

This course is for you if want a refresher course in SQL, or are learning SQL for the first time.
This course is for you if you are working towards the requirements for exam 70-461, or if you just want to expand your knowledge of T-SQL.
If you are starting from the beginning, then you should look at my sessions 1 to 4 courses before taking this session 5.
If you want more advanced topics, then please look at my later sessions.

Time: 3.5h

*Some courses are excluded from this sale. Coupon not working? If the link above doesn't drop prices, clear the cookies in your browser and then click this link here.
Also, you may need to apply the coupon code directly on the cart page to get the discount.

Coupon Code

Instructor Details

Phillip Burton

4.3 Rating
23 Reviews

Phillip is a Computing Consultant providing expert services in the development of computer systems and data analysis. He is a Microsoft Certified Technology Specialist. He has also been certified as a Microsoft Certified Solutions Expert for Business Intelligence, Microsoft Office 2010 Master, and as a Microsoft Project 2013 Specialist.
He enjoys investigating data, which allows him to maintain up to date and pro-active systems to help control and monitor day-to-day activities. He has also developed expertise and programmes to catalogue and process and control electronic data, large quantities of paper or electronic data for structured analysis and investigation.
He is one of 9 award winning Experts for Experts Exchange's 11th Annual Expert Awards and was one of Expert Exchange's top 10 experts for the first quarter of year 2015.
His interests are working with data, including Microsoft Excel, Access and SQL Server.

SQL in Motion (2017)

0.0 (0 Reviews)

Provider: Manning Publications
Time: 4h

$59.99

Introduction to SQL (2015)

0.0 (0 Reviews)

Provider: SQLBolt

Free

Intro to SQL: Querying and managing data (2015)

0.0 (0 Reviews)

Provider: Khan Academy
Time: 1h

Free

More Courses

Reviews

4.3

23 total reviews

5 star 4 star 3 star 2 star 1 star

Write a Review

By Renjith Joy on

The training session was very informative.

By James Vazquez on

Good job

By Wendy Weber on

The instructor is extremely thorough and his lectures are well prepared! He simplifies the process of learning SQL so anyone can learn it.

By Sithembiso Khawula on

Very informative. I have learned a lot of new information from, although I have experience in SQL

By Mary Holcombe on

This session was probably the most complex of all taken so far- gives in depth knowledge of analytics that may be used in SQL. Would really love to have the quizzes back as in earlier sessions but at least the instructor demonstrates many scenarios for us to see as examples. Materials are clear and easy to read on the screen. Phillip is very easy to understand.

By Gerald Weightman on

I am learning new concepts and functions with this video. It will be very helpful for me. I am sure that I will be able to apply these concepts in my work. The spacial and geometric data types are fascinating. Not sure how I will use them in my job, but good to know they exist, and can play around with them to see what they can produce.

By David Babayan on

Course is great. Goes through the MS Exam structure, so everything is covered, and maybe not in depth enough to pass (i assume), but at least you get a great introduction.

By Reza K Ghazi on

Here are some issues about the course:1) More sections were very slow paced.2) In some sections, there were environment noises such as bird songs, baby crying and so on. This issues also sometimes are existed in the past sessions.3) Voice will be disappeared in section 6, lecture 21 suddenly.4) It would be better if we can have the examples from the AdventureWorks DB.5) There were no quizzes or assignments.6) They are too much focus on spatial types and aggregates. I believe explaining each command and function, is not useful at all, we can read about them on the other sources if we need them. I actually believe nobody can remember too many details about everything.At the end, Instead of whatever I mentioned above, it was a good and useful course and I've learned a lot from it.Philip is a knowledgeable instructor and he has very respectful personality. I know we will have one of the best courses about the topic in the net, in the near future.I believe "The only unwritten dictation has no mistakes."Thank you, Philip, and I'm going to start Session 6 today.Best,

By Matt Livingston on

Instructor combines detailed description of the technology with questions for the student, and demonstration by writing the code to run the technology. The instructor builds on previous examples to build more elaborate solutions for real world examples. Very effective.

By David Clark on

Very informative and easy to follow. A bit slow-paced. Works best if you have some data sets of your own to experiment with as the training progresses.

By Nikhil B Pai on