EXCEPTIONAL TRAINING COURSES FOR IT PROFESSIONALS
LONDON UK | ONSITE | ONLINE


SQL Training Course

NEXT COURSE
22 Jan London
request info

Capita Marks and Spencer Telefonica Cisco BBC Lloyds Sony

SQL training course (code: SQLDESIGN)

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


SEE MORE COURSES IN THIS CATEGORY

TRAINING COURSE OVERVIEW

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

To facilitate this type of event, 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 be able to bring their own practical requirements and work to the course if the subjects and course topics are suitable.  


AUDIENCE

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



DETAILHIGHLIGHTS

Introduction

What you will learn

Data Models

Flat file

Hierarchical

Network

Entity-Relationship Concepts

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

Data Integrity and Normalization

Keys

Integrity rules

Normalization

First Normal Form

Second Normal Form

Third Normal Form

Denormalizing

Preparing for Implementation

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

Subqueries

Operators

IN / NOT IN

EXISTS / NOT EXISTS

Updates

INSERT

UPDATE

DELETE

Reports

Presenting, saving and manipulating your data queries

  • Databases Overview
  • Database Design
  • Database Tables & Structure
  • SQL Language
  • Querying Database
  • Data Retrieval
  • Reporting
Receive the latest version of this course into your inbox


See why people choose JBI

"At jbi even the sales team are technical so you are able to ask questions before the course"

Garima Aon

Call our Tech Team :  0800 028 6400  request info

 



PUBLIC COURSES (LONDON, UK)
 

22nd Jan 2018 - 2 days £1195
Book

see all dates


X

Show Discount for this course



PRIVATE COURSES


  Bring a JBI course to your office
  and train a whole team onsite
  0800 028 6400
or request quote


  You can customise this course to
  suit your exact needs here
  0800 028 6400 or request quote


 

 

 

 

Get in touch
0800 028 6400




 

You may also be interested in ...

view all case studies

 

 

Our inspiring and up-to-date courses gain exceptional feedback

►"great tips to help reduce build times"
► "we got access to exclusive content"
► "intensive course meant less time off"

►"what an inspiring trainer !"
► "colleagues at 2 sites joined via web"
► "I passed my exam the next day"

Newsletter ! Get exclusive news about upcoming programs, technical insights & special offers