LIN | Advanced SQL: Logical Query Processing (2020 EN)

Discussion in 'Information Technology' started by Kanka, Apr 5, 2020.

  1. Kanka

    Kanka Well-Known Member Loyal User

    Likes Received:
    Trophy Points:

    Company: Linkedin Learning
    Author: Amihai Levin
    Full Title: Advanced SQL: Logical Query Processing
    Year: 2020
    Language: English
    Genre: Educational: Databases
    Skill Level: Advanced
    Price: €34.99
    Files: MP4 (+ Exercise Files, Subtitles .SRT)
    Time: 01:40:00
    Video: AVC, 1280 x 720 (1.778) at 30.000 fps, 250 kbps
    Audio: AAC at 128 Kbps, 2 channels, 48.0 KHz

    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.

    Topics include:
    01. Query logical processing order
    02. Advanced join processing
    03. Filtering rows with ternary logic predicates
    04. Grouping and aggregating data efficiently
    05. Advanced group filtering
    06. Ordering and paging result cursors