Using SQL, create analytical functions, grouping sets, ranking functions, spatial aggregates. SQL Server 12-17 (70-761)
Master key concepts and practical skills through structured learning modules. By completing this curriculum, you'll gain valuable expertise applicable to real-world scenarios.
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.
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.
Understand what you need to succeed in this course and determine if it's the right fit for your learning goals
What you need before starting this 70-461 Session 5: Querying Microsoft SQL Server (write SQL) course:
This course is perfect for:
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
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.
View Current Pricing
Check provider for latest offers
Pricing may vary. Check the course provider for current promotions and exact pricing.
70-461 Session 5: Querying Microsoft SQL Server (write SQL) isn't for you? Don't worry, explore these courses and advance your skills or learn something totally new.
