Free Basic SQL Training for NHS Analysts
Training over MS Teams:
https://future.nhs.uk/DataAnalytics/v...
Training in person, in London:
https://www.snowflake.com/nhs-sql-tra...
Are you working in the NHS and need to improve your SQL skills. Facts and Dimensions in partnership with Snowflake, KeyAnalytics and Analyst X are pleased to bring this in-person course to NHS users. In this session you will learn basic SQL functions such as:
1. LEFT JOIN
2. INNER JOIN
3. Using a CASE statement to handle DQ issues in your join (eg where the codes in your fact table end in 00, but the code in your lookup table don’t)
4. WHERE
Using CASE statement in your SELECT list
Ensuring you don’t end up with duplicates or missing records.
5. IFNULL
6. IS NULL
7. LIKE _ and %
8. DISTINCT