"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
This course provides an intensive hands-on introduction to SQL and relational databases in a commercial environment. The course initially focuses on the design and structure of relational databases and then, with the design concepts in place, how to efficiently access, update and retrieve information from the database using SQL.
This course also serves as an excellent primer for IT professionals looking to move into SQL Server programming and administration, and MS Business Intlligence
This course has been developed for real-world, commercial scenarios by our expert instructors. See below for detailed syllabus. If you have a technical question, please email [email protected]
This course has been developed for real-world, commercial scenarios by our expert instructors. See below for detailed syllabus. If you have a technical question, please email [email protected]
What you will learn
Data Models
Flat file
Hierarchical
Network
Relational Data Model
Terminology
Entity types and occurrences
Attributes
Keys
Relationships
Entity-Relationship diagrams
Gathering Information
Entity-Relationship modelling
Integrating views into a single model
Complex Relationships
Keys
Integrity rules
Normalization
First Normal Form
Second Normal Form
Third Normal Form
Denormalizing
Attributes and Validation
CREATE and DROP
Table
Index
Foreign Key
ALTER
Security
GRANT
REVOKE
Defining tables
Defining Relationships
Importing data
Summary
Relational Databases
Tables, columns, keys
Relationships
Course database layout
Projections
SELECT
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
Operators
IN / NOT IN
EXISTS / NOT EXISTS
INSERT
UPDATE
DELETE
"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
“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
Sign up for the JBI Training newsletter to receive technology tips directly from our instructors - Analytics, AI, ML, DevOps, Web, Backend and Security.
CONTACT
+44 (0)20 8446 7555
Copyright © 2025 JBI Training. All Rights Reserved.
JB International Training Ltd - Company Registration Number: 08458005
Registered Address: Wohl Enterprise Hub, 2B Redbourne Avenue, London, N3 2BS
Modern Slavery Statement & Corporate Policies | Terms & Conditions | Contact Us
POPULAR
AI training courses CoPilot training course
Threat modelling training course Python for data analysts training course
Power BI training course Machine Learning training course
Spring Boot Microservices training course Terraform training course