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

Highlights Details Audience Feedback Prices/Dates

TAILOR-MADE
Enquire & get a quote

PUBLIC COURSES
Next on 18 Jul - see prices

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

Enquiries & Bookings

Live courses - face-to-face or remote

PUBLIC COURSES

18 Jul 2022 - 2 days

£1195 +VAT

ENROL

ENQUIRE

29 Aug 2022 - 2 days

SEE PRICES £1195 +VAT

ENROL

ENQUIRE

10 Oct 2022 - 2 days

£1195 +VAT

ENROL

ENQUIRE

TAILOR-MADE COURSES

* Train your entire team
* Tailored course content & duration
* Free taster sessions

GET A QUOTE

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