• SQL Developing Databases on Microsoft SQL Server
  • Scroll here for more courses

SQL Developing Databases on Microsoft SQL Server

View full course

Private course options:

At your office or a third party location -
At our training venues -

Virtual course -
Get full course options and prices sent to you via email
Get an answer to a question via email

Course Duration

3 Days

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.

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

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.
Get full course options and prices sent to you via email
Get an answer to a question via email
Recommending to everyone!
Sheard Packaging
M.C., Excel Level 1
Looking forward to putting what I've learnt into practice!
Northumbria University
C.G., Microsoft Power BI Desktop
One of the best courses I have ever attended. The pace was good and there were not any questions that the trainer could not answer
LDEUTC
K.H, Microsoft Power BI Desktop

Course Overviews at a Glance

SQL Developing Databases on Microsoft SQL Server Course


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.

View Course

We provide private, scheduled and virtual courses
Some of our clients include:
More information

Courses

We provide courses , our Courses can be available as scheduled or private courses, meaning that you can benefit from training that fits your exact requirements. If you are unsure which Courses would suit you, or if you would like help deciding, please give us a call on 0191 377 8377 or contact us online, we will be happy to help.


Private Courses

Private Courses the ultimate in flexible training. You choose the timescale, you choose the location, you choose the delegate(s) and you choose the content.


Public Scheduled Courses

Scheduled Courses, easy to book - we set the date, location and outline, so all you need to do is let us know which course you would like to attend. If a public scheduled course is not available for , we can provide private, onsite or virtual courses for you . One way or another, contact us to let us know how we can help or to book your courses.