Advanced SQL
Logical Query Processing, Part 1
SQL has been the dominant data processing language for the past five decades. This course takes you beyond the syntax fundamentals, and into a new world of understanding how relational database management systems process SQL queries, and how that impacts your coding practices. Learn about logical query processing, and avoid most common pitfalls and processing limitations. Discover advanced JOIN techniques and how to deal with missing data. Understand the subtleties of ternary logic, SELECT expression evaluation, grouping logic, and how to implement efficient paging and ordering. By the end of the course, you’ll be able to take advantage of the nuances of logical query processing to easily troubleshoot and solve daunting SQL challenges elegantly and efficiently.
Contents:
- Introduction
- 1. Constructing Query Source Data Sets
- 2. Row Filters
- 3. Grouping
- 4. Ordering and Paging
- Conclusion
Get a Reminder
| Rating | Not enough ratings |
|---|---|
| Length | 1h 40m |
| 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 RDBMS Database Queries |
Get a Reminder
Similar Courses
Careers
An overview of related careers and their average salaries in the US. Bars indicate income percentile.
DATA PROCESSING AND DATA ENTRY $30k
Data Processing/WinMaster Coordinator $42k
Data Entry/Processing Specialist $51k
Data Processing Analyst 4 $61k
Data Processing Analyst 2 $81k
Logical Access Administrator $107k
SQL Data Architect $108k
Senior Data Processing Analyst $110k
Software Engineer, Query Processing $114k
Software Engineer, Query Processing $114k
Senior Data Processing Specialist $115k
SQL Data Analyst 2 $123k
Write a review
Your opinion matters. Tell us what you think.
Please login to leave a review
| Rating | Not enough ratings |
|---|---|
| Length | 1h 40m |
| 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 RDBMS 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
