Vid 10: What is SQL Self JOIN? Check this video for the answer with demonstrated practical examples. youtube.com/watch?v=1aouTV… #SQLOnBirdApp

Vid 9: SQL JOINS I took my time to explain the concepts of SQL JOINS from Set Theorem and connect the dots together. with practical demonstrations. youtube.com/watch?v=-eixnd… #SQLOnBirdApp

Vid 8: How to filter text in MS SQL using Wildcard I have taken live SQL coding tests and they all assess my knowledge of SQL Wildcard. This video demonstrates how to filter text using Wildcards youtube.com/watch?v=4wpK8p… #SQLOnBirdApp

Vid 7: Let's Explore together, the AND,IN,BETWEEN commands. I shared use cases where they are applied using the Adventureworks database. youtube.com/watch?v=FVdogf… #SQLOnBirdApp

Vid 6: How do you query and handle NULL in MS SQL? Check this video for the answer with demonstrated examples. youtube.com/watch?v=hWSml7… #SQLOnBirdApp

Vid 5: The CASE command can be very confusing if you don't understand their use cases and how to logically write one. I address this concern in this video. youtube.com/watch?v=jV-eJr… #SQLOnBirdApp

Vid4: Now unto DISTINCT and WHERE Command. Why do you need them and when to use them? I answered these questions with demonstrated examples. youtube.com/watch?v=bCJBbT… #SQLOnBirdApp

Vid 3: It's finally time to start writing queries. but before that, I shared the SQL Anatomy and we then proceed to write our first set of queries against the Adventureworks database youtube.com/watch?v=V9OFNu… #SQLOnBirdApp

Vid2: You should not miss this video for anything. A proper understanding of the database is required to effectively work with it. I did an exploration of the Adventureworks database and the business that generates the data. youtube.com/watch?v=AnfWWa… #SQLOnBirdApp

Vid1: This is the first video in the series. I did a walkthrough on how to Install MS SQL Server on your computer and restore the Adventureworks database. This is the first step to getting your hands dirty with SQL youtube.com/watch?v=VpY0Q_… #SQLOnBirdApp

This is the Intro video. In this video, I shared what will be covered in the entire playlist. It is a Living Playlist hence new content will be added frequently. youtube.com/watch?v=oLnf1G… #SQLOnBirdApp

SQL is not difficult. the challenge is how to comprehend business needs. If you know what you want to achieve and can visualize it, learning the queries can come easier. The thought process to solving SQL challenges is as important as the queries. #SQLOnBirdApp

7. Advanced SQL JOINs and Query Performance Tuning Writing Optimal queries is powerful. This is what different interview test cases are testing. Beyond having a query that runs successfully, it will be exposed to several use cases to validate if it's optimal. #SQLOnBirdApp

6. Now moving to the advance stage "SQL Windows Functions" Windows Functions allow you to compare one row to another without doing any joins. This concept is powerful. #SQLOnBirdApp

5. Data Cleaning in SQL Leveraging on what you've learnt from 1-4 above, you can combine this to clean data better, converting and transforming Date Value, Missing Data analysis, etc.. #SQLOnBirdApp

4. SQL SubQueries & Temporary Tables SubQuery can be complex and difficult to understand but if you see the entire output as a table and picture every Subquery as a table that needs to be brought together to get a single table, you might just have an easy ride #SQLOnBirdApp