Skip to main content

IT Courses – Microsoft SQL Server 2016 and 2017 Introduction to Querying

This course provides a measured and relatively gentle introduction to querying data stored in a Microsoft SQL Server 2016 or 2017 database and could also prove beneficial to delegates who want to refresh their existing querying skills.

Book Now

Course Summary

Subject Area: IT, Digital Skills and Computer Science
Adult and Community
Location: Ilkeston
Full Time or Part Time: FT
Level: 2
Number Of Years:
Interview Required?: N
Ilkeston

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

Course Information for Students

This course provides a measured and relatively gentle introduction to querying data stored in a Microsoft SQL Server 2016 or 2017 database
and could also prove beneficial to delegates who want to refresh their existing querying skills. It is a comprehensive course, with plenty of
illustrated examples and practical hands-on exercises, paving the way to our Advanced Querying programme.

ldeally, students should be familiar with basic programming concepts as well as the fundamental design of relational databases, including
the purpose of primary and foreign keys, entity relationships and data normalisation. You can gain this knowledge on our two-day Microsoft
SQL Server 2016 and 2017 Relational Database Design and Querying Fundamentals course.

• Use SQL Server Management Studio for querying purposes

• Understand the basic structure of SQL Server databases

• Understand the components of Transact-SQL (T-SQL)

• Retrieve data from tables using the SELECT statement

• Filter data using the WHERE clause

• Sort data using the ORDER BY clause

• Query data from multiple tables by using joins

• Summarise and group data using aggregate functions

• Combine and limit result sets

• Work with simple nested subqueries

• Work with correlated subqueries

• Add rows of data to a table using the INSERT statement

• Remove rows from a table using the DELETE statement

• Modify existing rows using the UPDATE statement

N/A

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