This sync session covered advanced SQL concepts and use-cases, including joins (inner, left, right, and full, filtering) and unions. Additionally, sub queries and view use-cases were covered.