• SQL Server Database Modelling and Design

SQL Server Database Modelling and Design

The SQL Server Database Modelling and Relational Database Design course provides step-by-step instructions on how to develop an understanding of the data modeling and database development process, as well as the models used in each phase of the development lifecycle. You'll develop the skills to model and understand the database development lifecycle based on real life examples, while mapping the objects and engineer the logical model to a relational model.

On successful Completion of this course you will be able to:


  • Understand Relational Database Concepts
  • Understand Types of Databases Models
  • Understand Gathering Requirements for Database Design
  • Create an Entity Relationship Diagram by identifying entities, attributes, relationships and constraints from a set of requirements
  • Normalize the Entity Relationship Diagram to third Normal form
  • Enhance the Entity Relationship Diagram to utilize several data modeling techniques
  • Create a Data Flow Diagram by identifying processes, external agents, information stores
  • Create information flows that show how the information flows and how it is being transformed
  • Engineer the Entity Relationship Model into an initial relational database design
  • Optimize the Relational Database Design
  • Complete the Physical Model and generate the DDL
Course Requirements
Prerequisites Some knowledge of Database Management Systems
Target Audience
Audience Systems Analyst Database Developers Application Developers Software Architects

Write a review

Please login or register to review

SQL Server Database Modelling and Design

  • Brand: Weblearning Publishing
  • Product Code: SQL Server Database Modelling and Design
  • Reward Points: 100
  • Availability: In Stock
  • £89.99
  • £64.99

  • Price in reward points: 1200

  • 2 or more £59.99
  • 4 or more £51.99

Available Options


Related Products

Oracle Database SQL Workshop

Oracle Database SQL Workshop

Oracle Database SQL Workshop  This course is a combination of Oracle Database: SQL Workshop ..

£72.99 £89.99

Oracle Database Design and Programming with SQL CBT

Oracle Database Design and Programming with SQL CBT

Oracle Database Design and Programming with SQL This covers the Data Modelling and Database Devel..

£59.99 £79.99

Foundations of Machine Learning with R

Foundations of Machine Learning with R

Foundations of Machine Learning with R  The Foundations of Machine Learning with R cour..

£59.99 £79.99

Oracle Database Design and Programming with SQL eLearning

Oracle Database Design and Programming with SQL eLearning

Oracle Database Design and Programming with SQL This covers the Data Modelling and Database Devel..

£59.99 £79.99

Oracle Database Design and Programming with SQL Training Guide

Oracle Database Design and Programming with SQL Training Guide

Oracle Database Design and Programming with SQL This covers the Data Modelling and Database Devel..

£23.99 £29.99

Oracle Database 12c Performance Management and Tuning

Oracle Database 12c Performance Management and Tuning

Oracle Database 12c Performance Management and Tuning The Oracle Database 19c: Performance Manage..

£79.99 £99.99

Oracle Database 12/19c Essentials Certified Implementation

Oracle Database 12/19c Essentials Certified Implementation

Oracle Database 12/19c Essentials Certified Implementation The Oracle Database 12/19c Essentials ..

£169.99 £329.99

SQL Server Database Design and Development

SQL Server Database Design and Development

SQL Server Database Design and Development The SQL Server Database Design and Development course ..

£64.99 £94.99

Oracle and SQL Server Data Warehousing Boot Camp CBT

Oracle and SQL Server Data Warehousing Boot Camp CBT

Oracle and SQL Server Data Warehousing Boot Camp The Oracle and SQL Server Data Warehousing Boot ..

£84.99 £99.99

Oracle and SQL Server Data Warehousing Boot Camp eLearning

Oracle and SQL Server Data Warehousing Boot Camp eLearning

Oracle and SQL Server Data Warehousing Boot Camp The Oracle and SQL Server Data Warehousing Boot ..

£84.99 £99.99

Oracle Business Intelligence and Data Warehousing

Oracle Business Intelligence and Data Warehousing

Oracle Business Intelligence and Data Warehousing The Oracle Business Intelligence, Analytics and..

£69.99 £84.99

Oracle Data Warehousing Fundamentals

Oracle Data Warehousing Fundamentals

Oracle Data Warehousing Fundamentals The Oracle Data Warehousing course provides step-by-step ins..

£79.99 £89.99

Data Science and Machine Learning with Azure ML

Data Science and Machine Learning with Azure ML

Data Science and Machine Learning with Azure ML eLearning The Data Science and Machine Learn..

£69.99 £89.99

Foundations of Data Science, AI and Machine Learning

Foundations of Data Science, AI and Machine Learning

Foundations of Data Science, AI and Machine Learning  The Foundations of Data Science and Ma..

£69.99 £89.99

Foundations of Data Science with Python

Foundations of Data Science with Python

Foundations of Data Science with Python The Foundations of Data Science with Python course provid..

£59.99 £79.99

Hyperion EPM Planning 11.1.2 Certified Implementation Specialist

Hyperion EPM Planning 11.1.2 Certified Implementation Specialist

Hyperion EPM Planning 11.1.2 Certified Implementation Specialist In this course, you learn how to..

£79.99 £99.99

Database Administration Unlimited

Database Administration Unlimited

Database Administration Unlimited Cloud Learning SubscriptionThe Database Administration Unlimited C..

£320.00 £355.00

Oracle Database 23ai Data Warehousing Fundamentals

Oracle Database 23ai Data Warehousing Fundamentals

Oracle 23ai Data Warehousing Fundamentals This course introduces students to the Oracle Database ..

£110.99 £129.99

Oracle Database 23ai SQL Workshop

Oracle Database 23ai SQL Workshop

Oracle Database 23ai: SQL Workshop This course is designed for Developers and Database Administra..

£84.99 £99.99

Oracle Database 19c Data Warehousing Fundamentals CBT

Oracle Database 19c Data Warehousing Fundamentals CBT

Oracle Database 19c Data Warehousing Fundamentals This course introduces students to the Oracle D..

£79.99 £99.99

Oracle Database 19c Data Warehousing Fundamentals eLearning

Oracle Database 19c Data Warehousing Fundamentals eLearning

Oracle Database 19c Data Warehousing Fundamentals This course introduces students to the Oracle D..

£79.99 £99.99

Oracle Business Intelligence 11g Administration

Oracle Business Intelligence 11g Administration

Oracle Business Intelligence 11g Administration The Oracle Business Intelligence 11g Administrati..

£49.99 £69.99

Oracle 19c Data Warehousing Fundamentals

Oracle 19c Data Warehousing Fundamentals

Oracle 19c Data Warehousing Fundamentals The Oracle 19c Data Warehousing course provides step-by-..

£69.99 £89.99

Oracle 21c Data Warehousing Fundamentals

Oracle 21c Data Warehousing Fundamentals

Oracle 21c Data Warehousing Fundamentals The Oracle 21c Data Warehousing course provides step-by-..

£69.99 £89.99

Oracle Analytics and Data warehousing

Oracle Analytics and Data warehousing

Oracle Analytics and Data warehousing The Oracle Analytics and Data Warehousing course provides s..

£72.99 £89.99

Oracle Advanced Analytics: Concepts and Techniques

Oracle Advanced Analytics: Concepts and Techniques

Oracle Advanced Analytics: Concepts and Techniques The Oracle Advanced Analytics: Concepts and Te..

£79.99 £99.99

Introduction to Machine Learning Algorithms

Introduction to Machine Learning Algorithms

Introduction to Machine Learning Algorithms This course introduces you to the most commonly used ..

£59.99 £89.99

Predictive Analytics using SQL Server Machine Learning

Predictive Analytics using SQL Server Machine Learning

Predictive Analytics using SQL Server Machine Learning The course begins with an introduction to ..

£69.99 £89.99

Hyperion EPM Planning & Essbase 11.1.2: Fundamentals

Hyperion EPM Planning & Essbase 11.1.2: Fundamentals

Hyperion EPM Planning & Essbase 11.1.2: Fundamentals In this course, you learn how to Configu..

£74.99 £99.99

Hyperion Financial Management 11.1.2 for Interactive Users

Hyperion Financial Management 11.1.2 for Interactive Users

Oracle Hyperion Financial Management 11.1.2 for Interactive Users This course teaches you how to ..

£71.99 £89.99

Hyperion Financial Management 11.1.2.4: Create & Manage Applications

Hyperion Financial Management 11.1.2.4: Create & Manage Applications

Oracle Hyperion Financial Management 11.1.2.4: Create & Manage Applications This course is de..

£71.99 £89.99

Data Science Unlimited

Data Science Unlimited

Data Science Unlimited Cloud Learning SubscriptionThe Data Science Unlimited Cloud Learning Sub..

£310.00 £348.00

AI & Machine Learning Unlimited

AI & Machine Learning Unlimited

AI & Machine Learning Unlimited Cloud Learning SubscriptionThe Machine Learning Unlimited C..

£310.00 £348.00

Big Data Unlimited

Big Data Unlimited

Big Data Unlimited Cloud Learning SubscriptionThe Big Data  Unlimited Cloud Learning Subsc..

£365.00 £399.00

Big Data & Data Science VM Training Appliance

Big Data & Data Science VM Training Appliance

Big Data & Data Science VM Training ApplianceThis Big Data & Data Science VM Training Applia..

£249.00 £279.00

Oracle Database 23ai SQL & PL/SQL Development Workshop - 1Z0-171

Oracle Database 23ai SQL & PL/SQL Development Workshop - 1Z0-171

Oracle Database 23ai SQL & PL/SQL Development Workshop - 1Z0-171 This course introduces stude..

£124.00 £149.99

Tags: Database Management, Oracle Database, DB2, SQL, DBA