70-461 Session 6: Querying Microsoft SQL Server (SQL code)
Using SQL, correlated subqueries, CTEs, Pivots, UDFs and Sequences. SQL Server 2012 to 2017 (inc. 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
Learn all about subqueries, using them in the SELECT, FROM and WHERE clauses.
Learning Outcome 2
Learn about correlated subqueries, where the results of the subquery depends on the main query.
Learning Outcome 3
Learn about Common Table Expressions (CTE), using the WITH statement.
Learning Outcome 4
Use ROW_NUMBER, LAG and CTEs to group consecutive numbers.
Learning Outcome 5
Learn about PIVOT and UNPIVOT to spread data across columns.
Skills You'll Develop
This comprehensive 70-461 Session 6: Querying Microsoft SQL Server (SQL code) 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 6: Querying Microsoft SQL Server (SQL code) course:
- You need to know about data types and functions, SELECT queries, and ranking functions.
- 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
- 5.5 hours on-demand video
- 3 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
Security Operations Centre (SOC)
A security operations centre is the team, tooling and process that monitors an organisation's systems for security events around the clock, triages alerts, and starts the response to those that are real.
Security Risk Assessment
A security risk assessment identifies the threats to an organisation's assets, estimates how likely each is and how much harm it would do, and ranks them so that limited effort goes where it reduces the most harm.
Zero Trust
Zero trust is a security model in which no request is trusted because of where it comes from, so every access to a resource is authenticated, authorised and checked against policy each time.
DHCP (Dynamic Host Configuration Protocol)
DHCP is the protocol by which a device joining a network asks for and receives an address, a subnet mask, a default gateway and DNS servers from a server, for a limited lease period, so that nobody has to configure addresses by hand.
Wireless LAN (Wi-Fi)
A wireless LAN connects devices to a network over radio using the 802.11 family of standards, through access points that bridge the wireless medium onto the wired network and enforce the authentication and encryption that the shared airwaves demand.
TCP/IP
TCP/IP is the family of protocols on which the internet runs: IP moves packets between addresses without guarantees, and TCP or UDP ride on top to deliver either a reliable ordered stream or fast unordered messages.
Serverless Computing
Serverless computing runs your code only while an event is calling it: the provider conjures an execution environment on demand, throws it away afterwards, and charges for work performed instead of for capacity sitting idle.
Containers
A container is an application packaged together with the libraries and configuration it needs, run as an isolated process on a host that is already switched on, so the same package behaves the same way on a laptop, in a build pipeline and in production.
Object Storage
Object storage keeps every file as a self-contained object (the bytes, a unique key and some metadata) inside a flat bucket you read and write over HTTP, with no drive to mount and no directory tree underneath it.
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.