Udemy_70-461_Session_5_Querying_Microsoft_SQL_Server_2012

در این آموزش تصویری با کوئری نویسی در SQL Server 2012 آشنا می شوید.

مباحث این دوره شش جلسه ای مخصوص آزمون 70-461 است.

در این قسمت جلسه 5 را می توانید دانلود نمایید.

این دوره آموزشی محصول موسسه Udemy است.

سرفصل های این دوره آموزشی:

  • مقدمه
  • پیاده سازی querie ها
  • PARTITION BY و ORDER BY
  • RANGE در مقابل ROWS
  • رتبه بندی توابع
  • ROW_NUMBER, RANK و DENSE_RANK
  • توابع تحلیلی جدید
  • FIRST_VALUE و LAST_VALUE
  • CUME_DIST و PERCENT_RANK
  • PERCENTILE_CONT و PERCENTILE_DISC
  • مجموعه ها
  • اضافه کردن مجموعه
  • ROLLUP, GROUPING و GROUPING_ID
  • خط, POLYGON و دایره ها
  • کوئری های خطی
  • Spatial aggregates

عنوان دوره:Udemy 70-461 Session 5: Querying Microsoft SQL Server 2012

سطح: مقدماتی

نویسنده: Phillip Burton

مدت دوره: 3.5 ساعت

 توضیحات:

Udemy 70-461 Session 5: Querying Microsoft SQL Server 2012
Building on Sessions 1-4, we'll look at analytical functions, grouping sets, ranking functions and spatial aggregates.

Phillip Burton
3.5 hours
Intermediate Level

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.

What are the 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?
What am I going to get from this course?
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.
What is the target audience?
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.

Section 1: Introduction
Lecture 1
Introduction

02:24
Lecture 2
Resources
Article
Section 2: Objective 9: Implement aggregate queries
Lecture 3
Introduction

06:55
Lecture 4
OVER()
09:01
Lecture 5
PARTITION BY and ORDER BY
08:18
Lecture 6
RANGE
04:09
Lecture 7
CURRENT ROW and UNBOUNDED
04:30
Lecture 8
RANGE versus ROWS
09:03
Lecture 9
Omitting RANGE/ROW?
07:23
Section 3: Objective 9d: Ranking functions
Lecture 10
ROW_NUMBER, RANK and DENSE_RANK
06:15
Lecture 11
NTILE
06:24
Section 4: Objective 9a: New analytic functions
Lecture 12
FIRST_VALUE and LAST_VALUE
08:30
Lecture 13
LAG and LEAD
06:15
Lecture 14
CUME_DIST and PERCENT_RANK
08:06
Lecture 15
PERCENTILE_CONT and PERCENTILE_DISC
09:57
Section 5: Objective 9b: Grouping sets
Lecture 16
Adding Totals
10:21
Lecture 17
ROLLUP, GROUPING and GROUPING_ID
05:03
Lecture 18
GROUPING SETS
10:52
Section 6: Objective 9c: Spatial aggregates
Lecture 19
Introduction
06:24
Lecture 20
POINT
09:14
Lecture 21
POINT queries
13:28
Lecture 22
Line, POLYGON and Circles
08:55
Lecture 23
Line queries

07:54
Lecture 24
Geography
09:22
Lecture 25
Spatial Aggregates
12:55
Lecture 26
Summary
02:30
Section 7: End of Session 5
Lecture 27
Bonus Lecture
05:55
Lecture 28
Well done!
01:59