Save for later

Advanced SQL

Heads up! This course may be archived and/or unavailable.

Master SQL Development,

Without an understanding of the underlying concepts behind SQL, developers will encounter a number of challenges that slow down their workflow. This course—the second installment in a series—was designed to help you avoid these common pitfalls and understand SQL's processing limitations. Join instructor Ami Levin as he continues to delve into logical query processing. Learn how expression, table, and row subqueries are processed. Discover self joins, their unique requirements, and when you might use them. Plus, learn how to use lateral joins, recursive WITH clauses, and more.

Contents:

  • Introduction
  • 1. Subqueries and Set Operators
  • 2. Advanced Joins
  • 3. More on Grouping
  • 4. Recursions and Cursors
  • Conclusion
Get Details and Enroll Now

OpenCourser is an affiliate partner of LinkedIn Learning and may earn a commission when you buy through our links.

Get a Reminder

Send to:
Rating Not enough ratings
Length 2h 2m
Starts On Demand (Start anytime)
Cost $29/month (Access to entire library- free trial available)
From LinkedIn Learning
Instructor Ami Levin
Download Videos Only via the LinkedIn Learning mobile app
Language English
Subjects Data Science
Tags SQL Database Queries

Get a Reminder

Send to:

Similar Courses

Careers

An overview of related careers and their average salaries in the US. Bars indicate income percentile.

Adjunct Professor - Petroleum Processing and Natural Gas Processing $33k

Processing Specialist 1 $37k

Dietician -On-Call - Rehab Without Walls $40k

Licensed Clinical Social Worker - Rehab Without Walls $41k

Supervisor Processing $51k

Clinical Neuropsychologist - Rehab Without Walls Per Diem $61k

Clinical Neuropsychologist Per Diem - Rehab Without Walls $65k

Processing Engineer $66k

Clinical Neuropsychologist - Rehab Without Walls - Per Diem $70k

Payment Processing $77k

Transaction Processing $78k

Research Scientist - Advanced Concepts Group $110k

Write a review

Your opinion matters. Tell us what you think.

Rating Not enough ratings
Length 2h 2m
Starts On Demand (Start anytime)
Cost $29/month (Access to entire library- free trial available)
From LinkedIn Learning
Instructor Ami Levin
Download Videos Only via the LinkedIn Learning mobile app
Language English
Subjects Data Science
Tags SQL Database Queries

Similar Courses

Sorted by relevance

Like this course?

Here's what to do next:

  • Save this course for later
  • Get more details from the course provider
  • Enroll in this course
Enroll Now