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.
Course Information for Students
Who is this course for?
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.
What will you learn?
• 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
How will you learn?
What will you need to bring with you?
How will you be assessed?
Who do you contact for more information?
For more information contact the Roundhouse Thinking team on 01332 836 638 or email@example.com
Course Information for Employers
Information for Employers
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.
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.
Check availibility and book now on this course.
Course Information Last Updated On: November 22, 2021 3:58 pm