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)
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.
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.
Course Enrollment
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
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.
- ✓Instant access after enrollment
- ✓Learn at your own pace
- ✓Direct enrollment with Udemy
Where this course fits
Certifications in this area
Concepts behind this area
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.
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.
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.
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.
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.
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.
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.
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.
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.
