Skip to main content

IT Courses – Microsoft SQL Server 2016 and 2017 Querying Data for Report Developers

This course is designed from the ground up – starting with basic queries and advancing to more complex querying methods – so you do not need previous knowledge of the SQL language.

Book Now

Course Summary

Subject Area: IT, Digital Skills and Computer Science
Adult and Community
Location: Ilkeston
Full Time or Part Time: PT
Level: 2
Number Of Years:
Interview Required?: N
Weeks:
Hours: 21.00
Start: Flexible
Days/Times:
Tuition: £1050
Ilkeston

Apply now at: https://www.derby-college.ac.uk/course/it-courses-microsoft-sql-server-2016-and-2017-querying-data-for-report-developers
QR Code

Course Information for Students

This course is designed from the ground up – starting with basic queries and advancing to more complex querying methods – so you do not need
previous knowledge of the SQL language. It helps delegates build the skills to retrieve data from a Microsoft SQL Server database in a report
authoring environment, whether that be through Microsoft SQL Server Reporting Services or a similar reporting tool. The last module, which is
optional, will also give students the opportunity to put their SQL skills into practice by creating a simple report.

Delegates should ideally be familiar with basic programming concepts and should also understand the fundamental design of relational
databases – knowledge which you can gain by taking our two-day Microsoft SQL Server 2016 and 2017 Relational Database Design and
Querying Fundamentals course. On completing this programme, you will be able to retrieve data using the SQL language and write effective
queries for reporting purposes.

• Understand SQL syntax

• Retrieve, filter and sort data

• Work with the SQL Server date and time data types

• Query data from multiple tables by using joins

• Summarise and rank grouped data

• Combine and limit result sets

• Work with subqueries

• Understand basic common table expressions

• Implement stored procedures

• Implement SQL code to create a simple report

For more information contact the Roundhouse Thinking team on 01332 836 638 or enquiries@roundhousethinking.co.uk

Course Information for Employers

If you are an employer and would like to know more about the apprenticeships and professional training we deliver or how you can get involved in co-creating and co-delivering curriculum, please contact us via email on businessenquiries@derby-college.ac.uk, call us on 01332 387 421 or visit our employer pages here.

Career Information

Sorry - no lmi data
More Careers Information at: https://www.derby-college.ac.uk/career-pathways
QR Code

DCG Success Stories

Discover how our students have achieved success. Their hard work and dedication to learning has enabled them to succeed in rewarding careers or progress onto higher education.

role model

We encourage progress and aspirational outcomes by guiding people onto learning pathways that lead to positive destinations. Our students have gone on to achieve great things since leaving the College. We would like to share some of their inspiring success stories with you.

View Role Models

online application form

Get Started...

Check availibility and book now on this course.

Book Now

Course Information Last Updated On: November 22, 2021 3:58 pm