Skip to main content

IT Courses – Microsoft SQL Server 2016 and 2017 Relational Database Design and Querying Fundamentals

This course provides a foundation for designing, building and working with relational databases.

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: 1
Interview Required?: N
Weeks: 1
Hours: 14.00
Start: Flexible
Days/Times:
Tuition: £400
Ilkeston

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

Course Information for Students

This course provides a foundation for designing, building and working with relational databases. The training focuses on the fundamentals of relational database design to deliver a better understanding of how data is stored, queried and manipulated.

Delegates will have the opportunity to design a practical working database, with plenty of hands-on exercises to implement their design. They will also write some basic queries so they are acquainted with the foundations of the Structured Query Language (SQL). No previous knowledge of the SQL language is assumed. Knowledge of basic programming concepts would be helpful but not essential.


• How to analyse business requirements

• Map a database design to business requirements

• Design and build a relational database

• Entity relationships

• Primary and foreign keys

• Understand and implement constraints

• Normalise data to improve data management

• The purpose of the SQL Server Database Engine

• Work with the SQL Server Management Studio (SSMS) Client Tool

• Create a database

• Create and manage tables and columns

• Write basic SELECT queries to retrieve data from a database

• Write basic data modification statements

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:57 pm