Database Design for Relational Databases using SQL Server

Learn Database Design Fundamentals and sharpen your SQL in under 5 hours. SQL Database Design explained for Beginners
4.48 (206 reviews)
Udemy
platform
English
language
Databases
category
instructor
Database Design for Relational Databases using SQL Server
877
students
5.5 hours
content
Sep 2021
last update
$54.99
regular price

What you will learn

Learn Best Practices for Relational Database Design

Understand Relational Theory

Learn the data normalization process

Understand the First, Second, Third and Fourth Normal Forms

Understand Boyce-Codd normal form

Identify relationship types between entities

How to enforce database relationships including one-to-one, one-to-many, and many-to-many

Learn functional dependencies

Learn multivalued dependencies

Learn what Update, Insert and Delete anomalies are

Surrogate keys vs Natural keys

Learn the difference Candidate keys and Super Keys

Learn how to implement physical design using SQL Server

Create database tables and alter existing tables

Create SQL Queries and Views

Screenshots

Database Design for Relational Databases using SQL Server - Screenshot_01Database Design for Relational Databases using SQL Server - Screenshot_02Database Design for Relational Databases using SQL Server - Screenshot_03Database Design for Relational Databases using SQL Server - Screenshot_04
2793146
udemy ID
2/3/2020
course created date
2/23/2020
course indexed date
Bot
course submited by