Dismiss

SQL training course

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

Next 26 October (Remote)
2 days £1195 + VAT
BOOK NOW
See more dates …
Highlights Overview Audience Course Details Prices & Dates
JBI training course London UK
  • 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

FULL COURSE DETAILS

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.  

 


FULL COURSE DETAILS
JBI training course London UK
JBI training course London UK
IT and other professionals who need to learn how to access, query and report on information stored on relational databases using SQL.

FULL COURSE DETAILS

Related Courses

Big Data Introduction
Hadoop Administration
Apache Spark Development

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
 
Course Updates & Newsletter
 
 

Receive the latest version of this course by email & subscribe to our Newsletter



CONTACT
+44 (0)20 8446 7555

enquiries@jbinternational.co.uk

SHARE

Corporate Policies     Terms & Conditions
JB International Training Ltd  -  Company number 08458005

Registered address 1345 High Road, London, N20 9HR