Database Design for Relational Databases using SQL Server

Database Design for Relational Databases using SQL Server, available at $59.99, has an average rating of 4.55, with 71 lectures, 2 quizzes, based on 200 reviews, and has 845 subscribers.

You will learn about 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 This course is ideal for individuals who are Anyone who wants to learn Database Design or Students studying Relational Theory or Database Professionals or Anyone looking to get into a database role or Anyone looking to enhance their Data Science or Data Analytics career or Software Developers and Web Developers looking to enhance their careers It is particularly useful for Anyone who wants to learn Database Design or Students studying Relational Theory or Database Professionals or Anyone looking to get into a database role or Anyone looking to enhance their Data Science or Data Analytics career or Software Developers and Web Developers looking to enhance their careers.

Enroll now: Database Design for Relational Databases using SQL Server

Summary

Title: Database Design for Relational Databases using SQL Server

Price: $59.99

Average Rating: 4.55

Number of Lectures: 71

Number of Quizzes: 2

Number of Published Lectures: 71

Number of Published Quizzes: 1

Number of Curriculum Items: 73

Number of Published Curriculum Objects: 72

Original Price: $19.99

Quality Status: approved

Status: Live

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

Who Should Attend

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

Target Audiences

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

Start learning Database Design Today!

A lot of IT professionals have a good working knowledge of SQL yet lack the foundational knowledge of relational database design. Learning database design and the relational model will put you ahead of the game. This course covers all the essential aspects of relational database design with practical demos given in SQL Server. You will learn how to spot un-normalized data structures and how to correct them. You will learn all about the process of data normalization and why it is important. This includes the various normal forms such as Boyce-Codd normal form and fourth normal form. This course also covers tips on how to identify relationships between entities and how to correctly model them in a relational database.

You will be able to understand advanced database design concepts with the aid of intuitive diagrams and practical examples. You will learn how to identify functional dependencies and transitive dependencies in your data. You will learn the different types of keys and when to use them. In addition, you will learn the different types of relationships such as one-to-one, one-to-many, many-to-many, and self-referencing relationships. More importantly, the end of the course you will know how to enforce these relationships by using integrity constraints.

Note that you will need either a Windows or Linux computer to install SQL Server.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Welcome to the Course

Chapter 2: Database Basics

Lecture 1: What is a Database

Lecture 2: Types of Databases

Lecture 3: Flat Files

Lecture 4: NoSQL Databases

Lecture 5: Data Warehouses

Lecture 6: Relational Databases

Lecture 7: Logical and Physical Design

Lecture 8: Common Table Terminology

Chapter 3: Getting Started with SQL Server

Lecture 1: What you will need for the demos

Lecture 2: How to install SQL Server and SSMS

Lecture 3: Create and Query a Table (demo)

Chapter 4: Data Integrity Constraints

Lecture 1: Data Integrity

Lecture 2: Null Values

Lecture 3: Handling Nulls

Lecture 4: Handling Nulls (demo)

Lecture 5: Primary Key Constraint

Lecture 6: Composite Primary Key

Lecture 7: Natural Keys

Lecture 8: Surrogate Keys

Lecture 9: Main Benefit of Surrogate Keys

Lecture 10: Primary Key Recommendations

Lecture 11: Primary Key vs Unique Constraint

Lecture 12: CHECK Constraints

Lecture 13: Indexes

Lecture 14: Unique Indexes

Lecture 15: Primary Key and Unique Constraints (demo)

Chapter 5: Types of Relationships

Lecture 1: Types of Relationships between Entities

Lecture 2: Identifying Relationships between Entities

Lecture 3: One-to-Many Relationships Part 1

Lecture 4: One-to-Many Relationships Part 2

Lecture 5: One-to-Many Relationships Part 3

Lecture 6: Foreign Key Constraint Summary

Lecture 7: One-to-Many Relationships (demo)

Lecture 8: One-to-One Relationships

Lecture 9: One-to-One Relationships (demo)

Lecture 10: Many-to-Many Relationships

Lecture 11: Self-Referencing Relationships

Lecture 12: Self-Referencing Relationships (demo)

Chapter 6: Data Normalization

Lecture 1: Introduction to Data Normalization

Lecture 2: Why Normalize Data?

Lecture 3: Update, Insert and Delete Anomalies

Lecture 4: Introduction to the Normal Forms

Lecture 5: Functional Dependencies

Lecture 6: Trivial Functional Dependencies

Lecture 7: Functional Dependencies Exercise

Lecture 8: Candidate Keys

Lecture 9: Candidate keys vs Super Keys

Lecture 10: Key and Non-key Attributes

Lecture 11: First Normal Form

Lecture 12: Multi-value and Multi-type Fields

Lecture 13: First Normal Form (demo)

Lecture 14: Second Normal Form

Lecture 15: Second Normal Form (demo)

Lecture 16: Transitive Dependencies

Lecture 17: Third Normal Form

Lecture 18: Third Normal Form (demo)

Lecture 19: Boyce-Codd Normal Form

Lecture 20: Remembering the Normal Forms

Lecture 21: Fourth Normal Form and Multivalued Dependencies

Lecture 22: Fourth Normal Form (demo)

Chapter 7: Helpful Practice Activities

Lecture 1: Library Database Exercise

Lecture 2: Library Database Exercise Solution

Lecture 3: Decomposition Exercise

Lecture 4: Decomposition Exercise Solution

Chapter 8: Other Considerations

Lecture 1: Data Types

Lecture 2: Naming Conventions

Lecture 3: Naming Conventions (demo)

Chapter 9: BONUS Section: Indexing in Depth

Lecture 1: Introduction to Indexes

Lecture 2: Index Types and Indexing Guidelines

Lecture 3: Index Types Part 2 – Composite vs Included Columns

Instructors

Daniel Tait
Database Instructor

Rating Distribution

1 stars: 0 votes

2 stars: 4 votes

3 stars: 24 votes

4 stars: 73 votes

5 stars: 99 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!