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

Created by: Daniel Tait
Database Instructor

What Will I 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

Requirements

• A basic knowledge of computers

Target audience

• Anyone who wants to learn Database Design
• Students studying Relational Theory
• Database Professionals
• Anyone looking to get into a database role
• Anyone looking to enhance their Data Science or Data Analytics career
• Software Developers and Web Developers looking to enhance their careers