Skip to content
Getting Digital
All LevelsUdemy3.5 hours on-demand videoEnglish

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

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

Taught by Phillip Burton
Suitable for everyone
Enroll in This Course
✓ Instant access✓ Learn at your pace

Affiliate disclosure: if you enroll through links on this page, the course provider may pay us a commission. This comes at no extra cost to you and does not influence how we describe courses.

What You'll Learn in This Course

Master key concepts and practical skills through structured learning modules. By completing this curriculum, you'll gain valuable expertise applicable to real-world scenarios.

Learning Outcome 1

Apply the ranking functions ROW_NUMBER, RANK, DENSE_RANK and NTILE

Learning Outcome 2

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

Learning Outcome 3

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

Learning Outcome 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.

Skills You'll Develop

This comprehensive 70-461 Session 5: Querying Microsoft SQL Server (write SQL) curriculum is designed to take you from foundational concepts to advanced implementation. Each module builds upon the previous, ensuring a structured learning path that maximizes knowledge retention and practical application.

Hands-on LearningPractical ExercisesReal-World ProjectsIndustry Best Practices

Course Requirements & Target Audience

Understand what you need to succeed in this course and determine if it's the right fit for your learning goals

Prerequisites & Requirements

What you need before starting this 70-461 Session 5: Querying Microsoft SQL Server (write SQL) course:

  • 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?

Who This Course Is For

This course is perfect for:

  • Motivated learners at any level
  • Self-paced students
  • Anyone interested in the subject

This course might not be suitable if:

  • • You're looking for a quick tutorial rather than comprehensive learning
  • • You prefer learning without structured curriculum
  • • You need highly specialized or niche content

Course Information & Details

Everything you need to know about this online course, from duration to certification

Course Instructor

Phillip Burton

Expert instructor with industry experience

Course Language

English

All materials in English

Start Your Learning Journey Today

This online course offers comprehensive training with expert instruction, practical exercises, and a certificate of completion. Join thousands of students advancing their careers through quality online education.

Udemy Course

Course Enrollment

Get instant access to all course materials

Budget-Friendly Course

Typically around $49.99

Pricing may vary. Check the course provider for current promotions and exact pricing.

What's Included

  • 3.5 hours on-demand video
  • 4 downloadable resources
  • 2 articles
  • Access on mobile and TV
  • Certificate of Completion
  • Full lifetime access
View Course & Enroll

Affiliate disclosure: if you enroll through links on this page, the course provider may pay us a commission. This comes at no extra cost to you and does not influence how we describe courses.

Browse Udemy
  • Instant access after enrollment
  • Learn at your own pace
  • Direct enrollment with Udemy

Where this course fits

Concepts behind this area

Security

Public Key Infrastructure (PKI)

A public key infrastructure is the system of certificates, certificate authorities and revocation mechanisms that lets a party verify which identity a public key belongs to before trusting it.

Security

Authentication

Authentication is the process of confirming that a user, device or service is who it claims to be, typically by checking something it knows, has or is.

Security

Multi-Factor Authentication (MFA)

Multi-factor authentication requires proof from at least two different kinds of factor, such as a password and a device-generated code, so that stealing one is not enough to log in.

Networking

Subnetting

Subnetting divides an address block into smaller networks by choosing how many leading bits identify the network, written as a prefix length or a subnet mask, so that each subnet has its own range of host addresses and its own routing entry.

Networking

Routing

Routing is how packets move between networks: each router holds a table of known destinations and the next hop toward each, learned by configuration or by a protocol, and forwards each packet to the most specific match.

Networking

Switching

Switching is the forwarding of frames within a single network segment by a device that learns which hardware address sits on which port and sends each frame only where it needs to go.

Hosting & Cloud

Shared Hosting

Shared hosting puts your website on a machine that is simultaneously running hundreds of other people's, pooling its processor, memory and disk between all of you, which is both why it costs so little and why your speed partly depends on strangers.

Hosting & Cloud

VPS (Virtual Private Server)

A VPS is a software-defined slice of one physical machine that behaves as a server in its own right, with its own operating system, reserved CPU, memory and disk, and administrative access down to the kernel.

Hosting & Cloud

Dedicated Server

A dedicated server is an entire physical computer rented by a single customer, with no hypervisor taking a share and no other tenants on the hardware, chosen when consistent performance, specific components or provable isolation matter more than the ability to resize in seconds.

The field, explained: Hosting & Cloud

Wider context: the fields we cover, the glossary and certification exams, all written by us rather than pulled from a provider feed.