Overview

Introduction

The Understand Relational Database Management System module provides you with the instructions and devices to develop your hands on skills in the following topics.

  • Creating a ER Diagram for Customer, Order and Product.
  • Creating SQL Database, Tables for the ER diagram.
  • Inserting, Selecting and Updating Data in the SQL Table.
  • Creating Stored Procedure in SQL.

Exercise 1 - Creating ER Diagram for Customer, Order and Product in Visio

In this exercise, you will learn to create an Entity Relationship diagram using visio.

Exercise 2 - Converting ER Diagram into SQL Database in SQL Server 2012

In this exercise, you will learn to create an SQL Database from an ER Diagram using SQL Server 2012.

Exercise 3 - Inserting, Updating and Selecting Data in Tables using SQL Server 2012

In this exercise, you will learn to insert,update and select data to and from the Tables using SQL Server 2012.

Exercise 4 - Creating Stored Procedure in SQL Server 2012

In this exercise, you will learn to create a Stored Procedure (Parameterised) using SQL Server 2012.

Comprehensive Learning

See the full benefits of our immersive learning experience with interactive courses and guided career paths.