EXCEPTIONAL TRAINING COURSES FOR IT PROFESSIONALS
LONDON UK | ONSITE | ONLINE
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.
What you will learn
Relational Data Model
Entity types and occurrences
Integrating views into a single model
First Normal Form
Second Normal Form
Third Normal Form
Attributes and Validation
CREATE and DROP
Tables (permanent and temporary), columns, keys
Course database layout
SELECT (including multi-table)
Comparison, range and list operators
ORDER BY clause
GROUP BY and HAVING clauses
Inner and Outer joins
IN / NOT IN
EXISTS / NOT EXISTS
Presenting, saving and manipulating your data queries
See why people choose JBI
Call our Tech Team : 0800 028 6400 request info
Bring a JBI course to your office
and train a whole team onsite
0800 028 6400 or request quote
Get in touch
0800 028 6400
The Graduate Programme provided a gateway into technology within investment banking. Graduates (Computer Science, Engineering, Maths, Physics...
The BBC, who have a very substantial investment in technology, were keen to improve the quality of software development: to instil developers...
Nowadays, there is a significant business advantage in being able analyse, process and visualize "big data". While there is no agreed...
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"
Traditionally Cyber security has been associated mainly with penetrating networks and infrastructure. Now a more subtle level of attack needs...
Back in March 2014, the Angular team dropped a bomb by announcing Angular 2 and everyone started yelling. Instead of an evolutionary step forward,...
Python has taken the world of software development by storm. Here are the reasons why: Python is simple enough to be used to teach young children...