« Go Back

IT Courses - Microsoft SQL Server 2016 and 2017 Advanced Querying More Information »

Course Image


Location: Broomfield Hall

Weeks: 1

Hours: 14.00

Interview: N

Course Summary

Take your querying skills to the next level on this advanced course
featuring plenty of illustrated examples and practical hands-on exercises.
You will gain a deeper insight into your data, understand how SQL Server
internally handles the data you query, and learn how to manipulate data
in new and meaningful ways for the purposes of analysis and reporting.
There are useful techniques for querying temporal data, such as working
with date intervals and data islands, and we look at best practices for
writing efficient queries and avoiding common pitfalls.
 
Delegates should ideally be familiar with basic programming concepts
and understand the fundamental design of relational databases –
as taught on our Microsoft SQL Server 2016 and 2017 Relational
Database Design and Querying Fundamentals course. Additionally,
you should have attended the Introduction to Querying course or
possess equivalent knowledge.

Please Note: This course is run by Roundhouse Thinking. Visit the Roundhouse Thinking website for further information

Did you find the course information on this page useful?

 

* Tuition - This figure is the fee to be paid if you are not entitled to any concessions.
*** Co-Tuition - This figure is the fee to be paid if you are entitled to any partial concessions.

This course is run at the Broomfield Hall Campus

broomfiled hall campus

About Broomfield Hall »

Aimee Woore

Aimee Woore

New qualification is “massive help” for assessor Aimee

Business Administration assessor Aimee Woore has found that taking the Level 4 Preparing to Deliver Apprenticeship Standards course at Derby College is helping her massively in her daily work.
Aimee, a sales and marketing co-ordinator for Kettering Borough Council, also delivers business admin training to staff across the borough via the ETF, the Education & Training Foundation.
And, since completing her course at Derby College's Academy of Professional Education, Training and Development, she has taken on an additional role – heading up a work experience programme for 16 to 18 year olds in Kettering – and has found her new qualification invaluable.
Aimee, who found the course online via the ETF, opted to take it at Derby College, rather than at another centre in London, and is pleased with her decision.
She also welcomed the opportunity to be in a roomful of people in similar roles to her own but from a variety of different sectors and providers.

Taking the Derby College course has helped me massively in my job. The course was well structured, the facilities and materials were good and our tutors were excellent. The biggest thing I learned while on the course was teaching strategies, including hints and tips on the different options available. It was interesting to see our tutors demonstrate these options in their own teaching.


The techniques and strategies we were taught have been very helpful, both in my work and on a personal level. I thoroughly enjoyed the course and would like to use the credits to continue studying.

Go to top