This course is aimed at those who need to extract information from a relational database system. Although it provides an overview of relational database design principals it does not cover the teaching of formal database design processes and database/table creation. The course assumes no previous knowledge of SQL and SELECT statements, and takes delegates from simple queries, through to complex queries involving multiple tables, introducing the vast collection of built-in functions along the way. Covers SQL Server 2005, SQL Server 2008, SQL Server 2012 and SQL Server 2014
Delegates would benefit from a basic understanding of what a relational database is a familiarity with the terms tables, columns, and relationships, these concepts will be overviewed at the start of the course.
A comprehensive set of reference notes covering course topics and follow-up telephone support.
Location: just outside London
|All our courses can be tailored to requirements at your own offices. For alternative dates, please email or call us on 0208 269 4260|
|All prices are per person and are subject to VAT|
15% discount for groups of four delegates.
10% discount for groups of three delegates.
(This offer applies for delegates on the same public scheduled course on the same date.)
"Our trainer worked at a great pace and was very easy to understand."
"I just wanted to let you know that I've managed to replicate the steps you showed me in FileMaker on my organisation's database and have managed to get my invoicing layouts to work perfectly. Thank you very much! I've also been able to use some of the other things you showed me to good effect too so the course has already helped enormously. Just thought you should know :-)"
"Very helpful, knowledgeable and responsive trainer."