[95% Off Awesome Offer] 70-461 Session 5: Querying Microsoft SQL Server (write SQL)

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

What you’ll learn
  1. Apply the ranking functions ROW_NUMBER, RANK, DENSE_RANK and NTILE
  2. Use the analytic functions new to SQL Server 2012, such as LAG, LEAD, FIRST_VALUE and LAST_VALUE

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

  4. 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.
Take This Course Now

 

Who 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.
Take This Course Now

Also published on Medium.

PresidentsDay-EN-728x90

Leave a Comment: