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 training was to target a team of developers, with a mix of Java, C# and some C++. The team made heavy use of Java SE with some elements of...
The Graduate Programme provided a gateway into technology within investment banking. Graduates (Computer Science, Engineering, Maths, Physics...
This organisation needed their Supply Chain department to get fully involved with Microsoft’s Power BI reporting product as soon as possible....
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"
Microsoft recently released the public road map that gives the holistic approach to Integration and the key product offerings that contribute...
Scrum is one of the most popular frameworks for implementing agile development, and many people are doing a scrum course to understand how to...