Advanced SQL Analyst Course
The three day Foundation Course can be used as a prerequisite for this, but if your SQL is proficient enough, you could start on this two day Advanced Course. The course covers topics such as existence checks, CASE statements and variables. This course would be useful for delegates who have a requirement for knowing how to construct complex queries involving joins to many tables whilst considering different types of data.
| Day 1 - Advanced SQL Scripting | |
| Module 1 – Combining Query Results – Understand how to combine query results, create temporary tables of data and achieve advanced outcomes with string functions. | |
| Workshop | Advanced Demographic reporting with duplicate patients and column splitting. |
| What's Covered? | UNION, UNION ALL, INTERSECT, EXCEPT, temporary tables, common table expressions, subqueries, EXISTS, CHARINDEX, PATINDEX, REVERSE |
| Module 2 – Advanced SQL Functions –Make use of the meta-data for SQL Server Objects, build logic into column values, rank results and gain the efficiencies of dynamic SQL. | |
| Workshop | Advanced Address reporting with historic address ranking and parameterised filters. |
| What's Covered? | System catalogues, CASE, COALESCE, ISNULL, NULLIF, OVER, PARTITION BY, ranking, functions to join, variables, EXEC, flattening results into text strings |
| Day 2 - Advanced SQL Concepts | |
| Module 3 – Solving complex problems – Analyse a problem and break it into components. Create queries for source data. Build a base query, Filter the results, and present the results in an understandable format. | |
| Workshop | Solve a complex logic problem |
| What's Covered? | Managing complex query logic, analysing a problem, breaking a task into components, structuring base queries, filtering results, making results understandable. |
Andy used his NHS experience to develop the Advanced NHS SQL Training course:
Book Now and receive special offers.
