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
This organisation needed their Supply Chain department to get fully involved with Microsoft’s Power BI reporting product as soon as possible....
When a leading High Street Retailer (and purveyor of fine foods) recognised that teams of software engineers were writing overcomplicated and...
This client was expanding its capability to deliver technical training across EMEA. It had recently acquired a large technology company which...
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...
Debates on the present state of C++ in the programming world divide the participants into two camps: some dislike C++ and predict it's imminent...
MVC The Model View Controller (MVC) architectural pattern has a long history (together with its variants) and has been used in many languages...