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

Venue: Ilkeston
Cost (£): 700.00

Course Overview

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.

Course Content

• 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
Check Available Course Dates & Book »