Careervira Logo
Careervira Logo

USD $

Courses

Roles & Skills

Lists

Learn Paths

Career Paths

Artificial Intelligence & Data Science
Hands on Training icon
Hands On Training
Hands on Training icon

Advanced SQL Queries in Oracle and SQL Server

Course Cover
Pluralsight
compare button icon

Course Features

icon

Duration

4.42 hours

icon

Delivery Method

Online

icon

Available on

Downloadable Courses

icon

Accessibility

Mobile, Desktop, Laptop

icon

Language

English

icon

Subtitles

English

icon

Level

Intermediate

icon

Effort

4 hours per week

icon

Teaching Type

Self Paced

icon

Video Content

4.42 hours

Course Description

This course will give you an overview of recent additions to SQL language over the past few years. We'll explain. If you don't know much about Oracle or Oracle databases, we recommend that you take a class before you start.

Course Overview

projects-img

International Faculty

projects-img

Case Based Learning

projects-img

Post Course Interactions

projects-img

Case Studies,Instructor-Moderated Discussions

projects-img

Case Studies, Captstone Projects

Skills You Will Gain

What You Will Learn

Analytic Functions

Extensions to GROUP BY

The WITH Clause

The PIVOT and UNPIVOT Features

The MERGE Statement

PARTITION BY/RIGHT OUTER JOIN

Course Instructors

Author Image

Scott Hecht

Instructor

Scott is a statistical computer programmer specializing in SAS and SQL, but has learned many other languages such as Java, Android, C#, C, PL/SQL, R, and SPSS to name a few. His personal website, she...
Read More

Course FAQs

What are advanced SQL queries used for?

Who is this advanced SQL course for?

What advanced SQL queries will I learn in this course?

What software is required for this advanced SQL course?

Course Cover
Home
Search
Wishlist