NHS SQL Foundation Course
The foundation course will benefit those who would describe themselves as SQL novices, after completing the course they should consider the advanced course.
This is a three day course which will give delegates a broad understanding of data analysis using SQL. A solid foundation for any one who needs to use SQL. It covers the contents of the Starter, Information Analyst and Data Quality Courses over 3 days:
Please inform us, at the point of booking, which days you would like to attend.
| Day 1 - Starter - Intro & Basics | |
|
Module 1 - Introduction
to RDMS and SQL Server 2008 To gain an understanding of what a Relational Database Management System is. To learn how to navigate the tools available in the RDMS SQL Server 2008. |
|
| Workshop |
Navigating and returning data from databases. |
| What's Covered? | SQL Server Management Studio Object Explorer, SQL Server Management Studio Queries, SELECT |
|
Module 2 - The Client
Server Model Gain an understanding of what a Client Server Model is and how it works. |
|
| Workshop | N/A |
| What's Covered? | What a client server model is, why it’s used, advantages and disadvantages, how this impacts SQL Server 2008 |
|
Module 3 - Creating
Tables Understand how to create suitable tables from a file definition. |
|
| Workshop |
Creating an Accident and Emergency Patient
Registration table. |
| What's Covered? | CREATE TABLE, INT, CHAR, VARCHAR, DATE TIME, NUMERIC, Accent/Case Insensitive/Sensitive, SQL Create Table wizard, SQL Create Table Design, Good Database practice, Naming Conventions |
|
Module 4 - Basic
Structured Query Language How to return the rows and columns of data you require using filters and restrictions. Also covering how to check your results. |
|
|
Workshop |
Querying Provider Spell data and calculating key statistics. |
| What's Covered? | SELECT *, SELECT <column1>,<column2>, SELECT DISTINCT, FROM, WHERE, =, !=, >,!>, !<, >=, <=, BETWEEN, LIKE, IS NULL, IN, NOT, ORDER BY |
| Day 2 - Info Analyst - Join Tables & Modify Data | |
|
Module 5 - Entity modelling Learn the theory of how different entities within a RDMS relate to each other and how this can be shown in a structured methodology. |
|
| Workshop |
Resolving Patient GP reporting issues through entity
modelling. |
| What's Covered? | Entities, Relationships, One to Many, Many to Many, One to One, Entity Model, Checking Models |
|
Module 6 - Joining tables Learn how write SQL that will join different tables together from the RDMS. Covering how to check your results and why different joins produce different results. |
|
| Workshop |
Querying across Patient, Episodic and Consultant
tables. |
| What's Covered? | INNER JOIN, OUTER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN, CROSS JOIN (Cartesian) |
|
Module 7 - Manipulating
Data Learn how/why to check data before modifying it, the different ways to add data into a table and how to remove data from a table. You will be shown how to create a safe environment to do this data manipulation with safety nets in place. |
|
| Workshop |
Controlled updating of GP lookup data. |
| What's Covered? | INSERT, UPDATE, DELETE, TRUNCATE, BEGIN TRANSACTION, COMMIT, ROLLBACK |
| Day 3 - Data Quality - Data Analysis & Management | |
|
Module 8 - Transforming data into
information Learn how to take raw data and using Number, String, Aggregate and Date Functions to transform the data into useful information. |
|
| Workshop |
Aggregate reporting and integrity of population data. |
| What's Covered? | Number Functions: COUNT, SUM, MAX, CEILING, FLOOR, ROUND. Aggregate Functions: GROUP BY, HAVING, SUMMARIZATION. String Functions: RIGHT, LEFT, SUBSTRING, LEN, RTRIM, LTRIM, REPLACE, UPPER, LOWER, UNION. Date Functions: DATEPART, DATEADD, DATEDIFF, DATENAME, GETDATE ( ), Date conversions, Initialising Null Values, ISNULL |
|
Module 9 - SQL Management Learn how to create more advanced stored objects than tables, including Views and Stored Procedures. Then learn how to put these into Scheduled Jobs to run whenever you like. |
|
| Workshop |
Scheduled back-ups of changing population data. |
| What's Covered? | CREATE VIEW, ALTER VIEW, DROP VIEW, CREATE STORED PROCEDURE, ALTER STORED PROCEDURE, DROP STORED PROCEDURE, INITIALISING PARAMETERS, SETTING PARAMETRS, SET JOBS, START JOBS, SCHEDULE JOBS, ERROR REPORTS |
Book Now and receive special offers.
