Training Course

SQL Developing Databases on Microsoft SQL Server

PDF
3 Days
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.

Public Scheduled Course Dates

Prices per delegate. All prices exclude VAT.
14 Apr - 16 Apr 2025
Virtual Course
£2795
11 Aug - 13 Aug 2025
Virtual Course
£2795
15 Dec - 17 Dec 2025
Virtual Course
£2795

Private Training

Flexible dates, location and content. All prices exclude VAT.

Course 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.

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.

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.

Included with this course

    • Comprehensive course materials and exercises

SQL Developing Databases on Microsoft SQL Server 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

 

Public Scheduled Course Dates

Prices per delegate. All prices exclude VAT.
14 Apr - 16 Apr 2025
Virtual Course
£2795
11 Aug - 13 Aug 2025
Virtual Course
£2795
15 Dec - 17 Dec 2025
Virtual Course
£2795

Private Training

Flexible dates, location and content. All prices exclude VAT.
  • Call us on
    0191 377 8377
    to discuss your requirements.
    Mon-Fri 9am-5pm.
    Have a Question?
    Keep me up to date with offers and news
    By submitting this form, you consent to IT Training Solutions Ltd storing your information in order to respond to your request.
  • SQL Developing Databases on Microsoft SQL Server Course Options
    Private
    Private
    Flexible 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 Scheduled
    Public Scheduled
    Fixed 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!
    Virtual
    Virtual
    These courses can be attended from anywhere.
  • Virtual Training

Course Reviews
Which part of the course did you find particularly valuable "All of it, but mostly use of formula and tables"

S.H. GSK, Excel Level 2

"Training was all relevant and met expectations"

T.W. Watmos, Outlook Overview and MS Teams for Attendees

"[The trainer] was very patient with us and was always interested in how we have done things in the past and gave a very honest opinion and honest feedback. Thank you very much."

P. , Computers for Beginners and Getting Started with MS Office

"Great course, engaging trainer and a good pace. Just what I was looking for."

G.H. Capstone Foster Care, Excel Level 1

"All of it was good value to me"

D.M. CMR UK Ltd, Excel Analysing and Presenting Data with Dashboards and Pivot Tables

Which part of the course did you find particularly valuable "Being shown around the interface and what things do was very helpful"

A.S. Wescott Medical Ltd, Google Ads Introduction

"It's improved my overall perception of Power BI, and has given me a good foundation to explore further, as well as hopefully help others."

C.B. PX Limited, Microsoft Power BI Desktop

"Very well presented course with good information, materials and exercises provided."

A. Demeter Ltd, Excel Level 3

 

Public Scheduled Course Dates

Prices per delegate. All prices exclude VAT.
14 Apr - 16 Apr 2025
Virtual Course
£2795
11 Aug - 13 Aug 2025
Virtual Course
£2795
15 Dec - 17 Dec 2025
Virtual Course
£2795

Private Training

Flexible dates, location and content. All prices exclude VAT.

 

Please contact us to discuss your SQL Developing Databases on Microsoft SQL Server course, we have many solutions available to ensure you receive the best training possible.
Your SQL Server course can be delivered online or in-person.  You can choose your learning path and delivery style.  Learn in-person or online with our virtual classrooms.  Your course can be delivered online, at your office or at one of our training venues, it's your choice. Small course sizes. Course materials included. Flexible SQL Developing Databases on Microsoft SQL Server course content. Expert trainers and tried & tested training methods. Many course materials available online using your personal training account.  You can master SQL Server, please contact us to book a place or request a quote for your SQL Developing Databases on Microsoft SQL Server course.
IT Training Solutions Ltd
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk
Printed:3/27/2025 2:54:56 AM