Advanced SQL: Logical Query Processing, Part 1
With Ami Levin
Liked by 2,812 users
Duration: 1h 42m
Skill level: Advanced
Released: 3/30/2020
Course details
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.
This course was created by Ami Levin. We are pleased to offer this training in our library.
Skills you’ll gain
Earn a sharable certificate
Share what you’ve learned, and be a standout professional in your desired industry with a certificate showcasing your knowledge gained from the course.
LinkedIn Learning
Certificate of Completion
-
Showcase on your LinkedIn profile under “Licenses and Certificate” section
-
Download or print out as PDF to share with others
-
Share as image online to demonstrate your skill
Meet the instructor
Learner reviews
-
-
-
Wilman Pimentel
Wilman Pimentel
IT Technician | AWS CCP | SQL Analyst | Application Support| Business Analyst | Data Analyst
Contents
What’s included
- Practice while you learn 1 exercise file
- Test your knowledge 4 quizzes
- Learn on the go Access on tablet and phone