SQL Developing Databases on Microsoft SQL Server
Course Overview
This three-day instructor-led course provides students who wish to develop and maintain SQL Server databases Additionally, it will be of use to individuals who administer applications that deliver content from SQL Server databases.
Course Objectives
-
- Design and Implement Tables.
- Describe advanced table designs
- Ensure Data Integrity through Constraints.
- Describe indexes, including Optimized and Columnstore indexes
- Design and Implement Views.
- Design and Implement Stored Procedures.
- Design and Implement User Defined Functions.
- Respond to data manipulation using triggers.
Prerequisites
-
- In addition to their professional experience, delegates who attend this training should already have the following technical knowledge:
Essential:
Basic knowledge of the Microsoft Windows operating system and its core functionality.
Working knowledge of Transact-SQL. (equivalent knowledge to QATSQL and QATSQLPLUS)
Nice to have:
Working knowledge of relational databases.
Some experience with database design.
- In addition to their professional experience, delegates who attend this training should already have the following technical knowledge:
Target Audience for this Course
-
- The primary audience for this course is individuals who will develop and maintain SQL Server databases as their primary area of responsibility, or work in environments where databases play a key role in their primary job.
Course Content
-
Key Topics
Module 1 : SQL Development Overview
Module 2: Designing and Implementing tables
Module 3: Advanced table design
Module 4: Constraints
Module 5: Indexes
Module 6: Views
Module 7: Stored procedures
Module 8: User defined functions
Module 9: Triggers
Included with this course
-
- Comprehensive course materials and exercises
Private Training
-
Course Options
Private courses:Private courseFlexible date and locationPlease quote for prices -
SQL Developing Databases on Microsoft SQL Server Course Options
Please contact us to discuss options for this coursePrivatePrivateFlexible course content, flexible training date(s), flexible location(s), variable course length, private to your organisation - Courses can be held at one of our training venues or at another location convenient to you. Training can be set over a number of days or weeks to allow for practice time between training sessions.Public ScheduledPublic ScheduledFixed course content, fixed date, fixed location, fixed length, multiple organisations - All you need to do is choose which course you would like to attend and contact us to book!VirtualVirtualThese courses can be attended from anywhere.
- Virtual Training
G.A. Karbon Homes, Adobe Illustrator Level 2
M.W. Murray Plate Group Ltd, Stepping up to Managementltbrgt
J.R. Yorwaste, Excel Level 3
A.B. Umi Commercial Ltd, Google Analytics Essentials
J.B. Primula, Excel Level 3
J.F. London Borough Of Merton, SharePoint and Teams Overview
N.D. Leeds and Yorkshire Houisng Association, OneDrive Essentials
O. , Excel Level 3
Other Courses In This Training Series
SQL Querying SQL Databases using T-SQL Course Course Overview: This course will provide you with the basic knowledge and skills to create queries using Transact-SQL. It will teach you how to select, filter and sort data from multiple tables and how to use views and stored procedures.
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk
Printed:6/23/2026 1:45:19 PM