GET 20% OFF full price courses (T&Cs). Enter this promo code during booking: EASTER
Short course on Microsoft SQL Server Database Designing Course Price: £330.00 excl. VAT (£396.00 incl. VAT)
Total Duration: 15 Hours
Course level: Beginner
Delivery Method: Instructor Led Classroom Training
Certification: Certificate of Completion will be provided after completing the course

Course Overview:

This course is designed for beginners who wish to design and implement database with Microsoft SQL Server. It is a classroom based course that covers relational database fundamentals, database design, Structured Query Language (SQL) and database administration.

This course will prepare you for the Microsoft Technology Associate (MTA) certification exam. It also leads to our SSIS, SSRS and SSAS courses.

Following topics are included in this course:

  • Database Concepts and Introduction of MS SQL Server
  • Planning and Creating Databases
  • Constraints and Data Integrity
  • Structured Query Language (SQL) and T-SQL
  • Retrieving Data with SQL and T-SQL
  • Creating Views, Stored Procedures and UDF
  • T-SQL Programming
  • Database Normalisation
  • Understanding Indexes
  • Migrating, Importing and Exporting
  • Database security
  • Backing Up and Restoring


Skills Required

No existing knowledge on Microsoft SQL Server is required. You should have basic computing knowledge. Familiarity with relational database concepts is helpful but not required.

Course Dates, Prices & Enrolment

Training MethodDatesPrice (incl. VAT) 
Classroom Training 12 May 2019 - 26 May 2019
3 Sundays
£280 (normal price £396)Full
Classroom Training 13 May 2019 - 17 May 2019
Mon, Wed & Fri
£280 (normal price £396)Full
Classroom Training 04 Jun 2019 - 20 Jun 2019
3 Tuesdays & 3 Thursdays
£396Enrol Now
Classroom Training 17 Jun 2019 - 21 Jun 2019
Mon, Wed & Fri
£396Enrol Now
Classroom Training 06 Jul 2019 - 20 Jul 2019
3 Saturdays
£396Enrol Now
Classroom Training 23 Jul 2019 - 08 Aug 2019
3 Tuesdays & 3 Thursdays
£396Enrol Now
Classroom Training 29 Jul 2019 - 02 Aug 2019
Mon, Wed & Fri
£396Enrol Now
Classroom Training 24 Aug 2019 - 07 Sep 2019
3 Saturdays
£396Enrol Now
Classroom Training 09 Sep 2019 - 13 Sep 2019
Mon, Wed & Fri
£396Enrol Now
Classroom Training 10 Sep 2019 - 26 Sep 2019
3 Tuesdays & 3 Thursdays
£396Enrol Now

Day 1

  1. Database Concepts and Introduction of MS SQL Server
  2. Planning and Creating Databases
    • Planning Your Database
    • Creating a SQL Server database
    • Creating tables
    • Data types in SQL Server
    • Defining Primary keys and Identity Specification
    • Inserting, Updating and Deleting records
    • Creating default values
  3. Constraints and Data Integrity
    • Introduction of Database Constraints
    • Unique Key Constraint
    • Primary and Foreign Key Constraint
    • Relationships in a Database
    • Composite Primary Keys
    • Creating Database Diagram
    • Referential Integrity
    • Setting Cascade Update and Delete
  4. Structured Query Language (SQL) and T-SQL
    • Introduction of SQL and Transact-SQL (T-SQL)
    • Introduction of Data Definition Language (DDL)
    • USE Command
    • Create Databases using T-SQL
    • Drop Databases using T-SQL
    • Creating, Altering and Removing Tables using T-SQL
    • TRUNCATE TABLE Command to delete data
    • Commenting and Saving T-SQL
    • Introduction of Data Manipulation Language (DML)
    • INSERT statements
    • UPDATE statements
    • DELETE statements
    • Difference between DELETE and TRUNCATE
  5. Quiz 1

Day 2

  1. Retrieving Data with SQL and T-SQL (Part-1)
    • Using SELECT statements
    • Using WHERE for filtering
    • Using the NOT operator
    • Using the LIKE operator
    • Using IS NULL and IS NOT NULL
    • Using ORDER BY for sorting
    • Using DISTINCT to find unique values
    • Concatenating Columns
    • Creating Calculated Field
    • Limiting Results by using TOP Clause
  2. Retrieving Data with SQL and T-SQL (Part-2)
    • Using SQL Server Built-in Functions
    • Using Scalar Functions
    • Using Aggregate functions: AVG, MIN, MAX, SUM and COUNT
    • Using GROUP BY clause
    • SQL HAVING Clause
    • SQL UNION and UNION ALL Operators
    • SQL EXCEPT and INTERSECT Operators
    • Using Subqueries
    • Joining multiple tables together
      • Inner Joins
      • Outer Joins: LEFT, RIGHT & FULL
      • Joining More Than Two Tables
  3. Creating Views, Stored Procedures and UDF
    • Introduction of Views
    • Creating Views using T-SQL
    • Using View Designer Tools
    • Creating User Defined Functions
    • Creating Stored Procedures
  4. Quiz 2

Day 3

  1. T-SQL Programming
    • Variables
    • Control Flow - IF…ELSE
    • CASE Statement/Expression
  2. Database Normalisation
    • First Normal Form (1NF)
    • Second Normal Form (2NF)
    • Third Normal Form (3NF)
  3. Understanding Indexes
    • Introduction of Indexes
    • Clustered Indexes
    • Non-clustered Indexes
    • Creating Indexes
  4. Migrating, Importing and Exporting
    • Generate SQL Scripts
    • Import and Export Wizard
    • Import Data into SQL Server
    • Exporting Data
  5. Database security
    • Introduction of Database Security
    • Authentication Methods
    • Creating and Managing Logins
    • Creating and Managing Database Users
    • Using SQL Server Roles
    • Managing Object Permissions
  6. Backing Up and Restoring
  7. Quiz 3

“Recommend for all levels of ability. Great course”

David 07/03/2019

“The class was one of the best educational experiences I have experienced”.

Mohammad 11/02/2019

“Very good course. Good pace and balance between theory and practical, with content clearly explained along the way. Would recommend to anyone not quite understanding the aspects of db design from online sources”.

Laura 11/02/2019

“The Database Design course is well structured and easy to comprehend from the start. The teacher is clearly knowledgeable and makes a great effort to clear all your doubts along the way. I highly recommend this course”

Katherine 25/01/2019

"Highly recommended intro to SQL - perfect for starting your MS SQL Server education."

Catherine McGahey, 22/09/2015

"Value for money. Lesson was well paced and explained so that each student could catch up and understand session. Very supportive teacher."

Claudia Adele, 15/09/2015

"Very informative class, teacher was very knowledgeable about his subject. Highly recommend."

Keely Cooper, 01/09/2015

"This course is essential for a beginner, it will give you fundamental tools to become competent working with SQL."

10/11/2014

Course Tutor

The course instructor is a .NET developer with 15 years of experience in software and web development. He is a Microsoft Certified Application Developer and skilled on C#, ASP.NET, Microsoft SQL Server, Ajax, HTML, and CSS.

Newsletter Sign-up

Have a Question?