img

Database Design with Microsoft SQL Server Training Course

Database Design with Microsoft SQL Server

  • £200.00
  • 5 hours
  • Beginner
  • Instructor Led Online Training
  • Database Design with Microsoft SQL Server training 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.

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
  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
  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. 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
  6. 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
    • Using Subqueries
    • Joining multiple tables together
      • Inner Joins
      • Outer Joins: LEFT, RIGHT & FULL
      • Joining More Than Two Tables
  7. 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
  8. Migrating, Importing and Exporting
    • Generate SQL Scripts
    • Import and Export Wizard
    • Import Data into SQL Server
    • Exporting Data
  9. Backing Up and Restoring
A photo of Younus

Younus Kazi

Younus has over 18 years experiences in working and teaching IT in both public and private organisations. His specialities include Web design, development, software development and project management. He graduated from London Metropolitan University in Computing and Information Systems. He is also a Microsoft Certified Application Developer (MCAD).

A photo of Jayan

Jayan Karmacharya

Jayan is an Experienced Web Developer and IT tutor with over 10 years of experience in Server side programming, front-end development, database design, web server management and, IT instruction. Having Master of Science in Information Technology Degree and Microsoft certified Programming in HTML5 with JavaScript and CSS3.

Shares

Customers Also Bought

Subscribe To Our Onlinesletter

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor

Copyright © 2021 LAIT.training. Owned by the E4Academy Ltd. All rights reserved.