CUSTOMISED
Expert-led training for your team

Dismiss

SQL training course

Learn SQL Language Essentials - Query & Produce Meaningful Reports On Your Corporate SQL Server Database

"Our tailored course provided a well rounded introduction and also covered some intermediate level topics that we needed to know. Clive gave us some best practice ideas and tips to take away. Fast paced but the instructor never lost any of the delegates"

Brian Leek, Data Analyst, May 2022

Public Courses

23/09/24 - 2 days

£1195 +VAT

Enrol

04/11/24 - 2 days

£1195 +VAT

Enrol

16/12/24 - 2 days

£1195 +VAT

Enrol

Customised Courses

* Train a team
* Tailor content
* Flex dates

From £1200 / day

Highlights Details Audience Feedback Prices/Dates

Public Courses

Highlights

Gain an introduction to SQL, databases and data models
Learn SQL language essentials
Understand how databases are constructed and how to query and extract the data stored in them using SQL language
Explore database design and prepare for implementation
Understand database tables & structure
Learn how to define tables and import your data
Use SQL language and practice implementation
Become familiar with querying databases and sub-querying
Acquire skills in data retrieval, data integrity and normalisation
Explore reporting techniques to present, save and manipulate your data queries

Course Details

Introduction

What you will learn
Data Models
Flat file
Hierarchical
Network
Data Models
Flat file
Hierarchical
Network

Entity-Relationship Concepts

Relational Data Model
Terminology
Entity types and occurrences
Attributes
Keys
Relationships
Entity-Relationship diagrams
Relational Data Model
Terminology
Entity types and occurrences
Attributes
Keys
Relationships
Entity-Relationship diagrams

Entity-Relationship Modelling

Gathering Information
Entity-Relationship modelling
Integrating views into a single model
Complex Relationships
Gathering Information
Entity-Relationship modelling
Integrating views into a single model
Complex Relationships

Data Integrity and Normalization

Keys
Integrity rules
Normalization
First Normal Form
Second Normal Form
Third Normal Form
Denormalizing
Keys
Integrity rules
Normalization
First Normal Form
Second Normal Form
Third Normal Form
Denormalizing

Preparing for Implementation

Attributes and Validation

Attributes and Validation

SQL for Implementation

CREATE and DROP
Table
Index
Foreign Key
ALTER
Security
GRANT
REVOKE

Implementing a design

Defining tables
Defining Relationships
Importing data
Summary

Introduction to Relational Databases

Relational Databases
Tables (permanent and temporary), columns, keys
Relationships
Course database layout

Projections, Selections and Joins

Projections
SELECT (including multi-table)
Selections
WHERE clause
Comparison, range and list operators
String matching
ORDER BY clause
GROUP BY and HAVING clauses
Joins
Equijoins
Inner and Outer joins
Self joins
Views
Projections
SELECT (including multi-table)
Selections
WHERE clause
Comparison, range and list operators
String matching
ORDER BY clause
GROUP BY and HAVING clauses
Joins
Equijoins
Inner and Outer joins
Self joins
Views

Subqueries

Operators
IN / NOT IN
EXISTS / NOT EXISTS
Operators
IN / NOT IN
EXISTS / NOT EXISTS

Updates

INSERT
UPDATE
DELETE
INSERT
UPDATE
DELETE

Reports

Presenting, saving and manipulating your data queries
Presenting, saving and manipulating your data queries

Who should attend

IT and other professionals who need to learn how to access, query and report on information stored on relational databases using SQL.

Feedback

4.8 out of 5 average

Brian Leek, Data Analyst, May 2022

“JBI did a great job of customizing their syllabus to suit our business needs and also bringing our team up to speed on the current best practices. Our teams varied widely in terms of experience and the Instructor handled this particularly well - very impressive”

Brian F, Team Lead, RBS, Data Analysis Course, 20 April 2022

Big Data Introduction

Hadoop Administration

Power Automate

Top 20 "Pain Points" for Data Analysts

Problem 11 : You have a very complex Excel spreadsheet and you want to reproduce EXACTLY the same spreadsheet in Power BI
Solution: Power BI is not Excel, it works differently and it has different strengths. In order to tackle this issue the best way is going back to the source and try to...

All 20 points are in our latest Newsletter - Delivered directly to your inbox

More about this course

This course has been running at JBI Training since 1995 and "hits the spot" every time. It enables people with little or no database knowledge to understand how databases are constructed, and how to query and extract the data stored in them using SQL language. You also learn to present this data in meaningful reports.

To facilitate learning, a subject matter expert leads the training, hands-on labs and discussions to ensure course topics are covered in a meaningful, relevant and timely manner.

Delegates may bring their own practical requirements and work to the course if the subjects and course topics are suitable.