SQL Scripting


Course Description

This one day course provides an introduction to SQL (Structured Query Language) for non IT developers. It is aimed at anyone who needs to know how to extract finance and non-finance data from databases within their organisation. SQL is a fundamental tool used to interrogate databases and is a core component of data analytics. The course goes through the language that queries these databases, looking at its syntax and structure in order to return the relavent data. The last few topics are short examples of the use of SQL in modern Data Analysis, which would form a bridge to further learning with Power BI etc. The course will be hands-on with scripts being executed on a SQL Server database, but the skills learned can be applied to any SQL based database.

Duration: 1 days


Prerequisites

No specific pre-requisites. The course is aimed at professionals at all levels who are required to analyse and interpret data as part of their role.

Designing and Creating a Database

Relational Database Design Principles
The Origins of Relational Design
Data Normalization
Understanding the Referential Integrity
Beyond Normalization
Implementing the Design
Database Storage
Creating Databases
Modifying Database Options
Creating Tables
Creating Constraints
Using Database Diagrams

Data Selection Queries

Understanding SQL
The SELECT Statement
Selecting All Columns
Concatenating Columns
Naming Columns
Using DISTINCT to Limit Values
The WHERE Clause
Transact-SQL Comparison Operators
The LIKE Operator
The BETWEEN Operator
Using IS NULL to Test for Nulls
Multiple Conditions with AND, OR, and NOT
Operator Precedence
Using the IN Operator
Using ORDER BY to Sort Data
Sorting on a Single Column
Sorting by Multiple Columns
Sorting with Expression
The GROUP BY Clause
Aggregate Functions
Counting Rows
Counting Columns
Counting with a WHERE Clause
Using GROUP BY
Using GROUP BY with GROUP BY
Using HAVING with GROUP BY
TOP Values Queries
Joining Tables
Cross Joins (Cartesian Products)
The Use of Keys in Joining
Join Notation
Inner Joins
Outer Joins
Self Joins

Modifying Data

Modifying Data
Inserting Data
Inserting a Single Value
Inserting Multiple Values
Inserting Multiple Rows
Creating a New Table Using SELECT INTO
Temporary Tables
Using Bulk Copy to Insert Data
Updating Data
Updating a Single Row
Updating Multiple Rows and Columns
Updating from Another Table
Updating with TOP
Deleting Data
Deleting a Single Row
Deleting Multiple Rows

Data analysis

Data import and data export.
Using Power Bi to analyze data
Using Excel to analyze data
Pivot Tables and Charts


Schedule

NameDateLocation 
SQL Scripting 2024-04-11 Online
SQL Scripting 2024-05-23 Online

SQL SQL Scripting Structured Query Language SQL Server