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.
Course Information for Students
Who is this course for?
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.
What will you learn?
• 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
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 firstname.lastname@example.org
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:57 pm