This project demostrates tools and processes for data modeling in Relational Database Management Systems (RDBMS) using Microsoft SQL Server. Topics include SQL data definition language (DDL), SQL data manipulation language (DML), views, security, transaction management, triggers and stored procedures.
This project focuses on two databases, BookStore database and Supplychain database, that are used to study SQL fundamental design concepts and industry standards.
This database contains 11 tables, the Entity Relational Diagram (ERD) as following:
To explore the SQL techniques and the characteristics of relational models in database design and transaction management in MS SQL Server, this project covers four main sections:
PART-I: Basic SQL Statements and Functions
PART-II: Table Manipulations
PART-III: Case, Views, Subqueries, Indexes
PART-IV: Variables, Sequence Control, Stored Procedures, Triggers
N/A