در این آموزش تصویری با کوئری نویسی در 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