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
08/02/2018: Power BI is an excellent visualization tool, released by Microsoft in June 2015 and updated every month since then. It’s relatively cheap compared...
31/07/2018: Happy 3rd birthday PowerBI!!! A note from a user/trainer... PowerBi, after 3 years from its initial release, is a mature and rich tool for data...
27/02/2018: Mariella has put together this short briefing on the bookmarks functionality in Power BI... "I love it!" she says.. Bookmarks has been available...
18/12/2017: The Client A leading developer and manufacturer of sophisticated industrial products, abatement solutions and related value-added services. Their...
19/10/2017: A leading Financial Services organisation was keen to get several of its teams working consistently in an "Agile" way. Agile is an iterative...
13/10/2017: This organisation needed their Supply Chain department to get fully involved with Microsoft’s Power BI reporting product as soon as possible....
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
Excellent feedback, consistently !
"great tips help reduce build times"
"we got access to exclusive content"
"Short course meant less time off"
"what an inspiring trainer !"
"colleagues at 2 sites joined via web"
"I passed my exam the next day"