Short course on Microsoft SQL Server Database Designing Regular Course Price: £200.00   
Total Duration: 5 Hours
Course level: Beginner
Delivery Method: Instructor Led Online 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 databases with Microsoft SQL Server. It is a virtual online 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 Querying Data with SQL and T-SQL, SSIS and SSRS 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
  • Migrating, Importing and Exporting
  • 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.

If you do not have basic computer and Internet skills then we highly recommend you to attend our Computer Basics for Absolute Beginners course before attending this course.

Course Dates, Prices & Enrolment

Training
Method
Dates and Times
(in the UK)
Dates and Times
(if not in the UK)
Price 
One-to-one Remote Training 18 May 2021 - 19 May 2021
Tuesday & Wednesday
11am - 1:30pm
Start Date & Time
End Date & Time
£150 £200
Enrol Now
One-to-one Remote Training 25 May 2021 - 26 May 2021
Tuesday & Wednesday
5:30pm - 8pm
Start Date & Time
End Date & Time
£150 £200
Enrol Now
One-to-one Remote Training 01 Jun 2021 - 02 Jun 2021
Tuesday & Wednesday
11am - 1:30pm
Start Date & Time
End Date & Time
£200
Full
One-to-one Remote Training 08 Jun 2021 - 09 Jun 2021
Tuesday & Wednesday
5:30pm - 8pm
Start Date & Time
End Date & Time
£200
Enrol Now
One-to-one Remote Training 15 Jun 2021 - 16 Jun 2021
Tuesday & Wednesday
11am - 1:30pm
Start Date & Time
End Date & Time
£200
Enrol Now
One-to-one Remote Training 06 Jul 2021 - 07 Jul 2021
Tuesday & Wednesday
5:30pm - 8pm
Start Date & Time
End Date & Time
£200
Enrol Now
One-to-one Remote Training 13 Jul 2021 - 14 Jul 2021
Tuesday & Wednesday
11am - 1:30pm
Start Date & Time
End Date & Time
£200
Enrol Now

Full Course Outline

  1. Database Concepts and Introduction of MS SQL Server
    • Database and DBMS
    • Editions of MS SQL Server
    • Downloading and Installing Microsoft 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
  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
    • Commenting and Saving T-SQL
    • Introduction of Data Manipulation Language (DML)
    • INSERT statements
    • UPDATE statements
    • DELETE statements
  5. Using SELECT statements
    • Introduction to the 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
  6. Creating Views
    • Introduction of Views
    • Creating Views using T-SQL
    • Using View Designer Tools
  7. Importing and Exporting Data
    • Import and Export Wizard
    • Import Data into SQL Server
    • Exporting Data
  8. Backing Up and Restoring

Booking Request

Do you have a special training requirement or unable to find any suitable training date? Please complete and submit the booking request form, if you want to:

  • book a course on different dates
  • book for a group of delegates
  • book corporate training
  • book a customised training
  • book a one-on-one training

The price person is less when you book a course for more people. You can find the price per person and the total cost by changing the values of the training hours and the number of people below:

You must need to Register / Sign In first to submit this booking request form.

Study Path

These are some suggested study paths, but you may book the courses according to your requirements.

Please contact us us if you need any help to choose your study path.


Career Path

These are some possible career paths after completing this course:

  • Junior Database Designer/Developer > Database Designer/Developer > Senior Database Designer/Developer
  • Junior Database Designer/Developer > Report Developer
  • Data Analyst

Participant Reviews

“The Database Design with Microsoft SQL Server course was excellent value for money and well taught. It took us from very basic what is SQL questions through to more complicated coding in a short period and although our group had differing levels of experience we still all learnt something. I would recommend this course to anyone wanting to jump in to SQL.”

Tom 01/12/2020

“Well structured course, covering a huge content of information. The class was conducted in a way that each subject matter logically followed to the next, so that the subject was clear to understand, and enjoyable. The trainer was clearly an expert in the area and willing to answer all questions and ensure that all members understood the current topic before moving on. Will be attending more classes in the future”

Melanie 31/10/2019

“Hands on training”

Roberta 10/06/2019

“I highly recommend this SQL course by London Academy of IT for beginners and intermediate users”

Rebecca 30/05/2019

“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 Tutors

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.

Save Money with Packages

SAVE more than 15% by booking this course with other related courses as shown below:

Newsletter Sign-up

Have a Question?