4.55 out of 5
4.55
11 reviews on Udemy

SQL Server the Fun Way: Architect a Movie Theater

Datatypes, table structures, and best practices presented in a fun, relateable way
Instructor:
William Belisle
86 students enrolled
English [Auto-generated]
Understand the basic concepts that go into database design
Create their own database for their projects

This course will provide you with an introduction to Database Architecture. To do this, we will build a database step-by-step for a fictional movie theater. This theater needs to keep track of ticket sales, concession sales, and their own special loyalty program. By the end of this course we will have discussed many topics, including Primary Keys, Foreign Keys, Identity columns, several datatypes and much more.

This course will use Microsoft SQL Server but the core concepts apply to any SQL-based database system.

You should take this course if you are interested in learning Database Architecture concepts. We’ll cover several datatypes and go over when and when not to use them. We’ll cover many different types of tables, including dimension table and history tables.

After you’ve taken this course you will have a basic understanding of how databases fit together and how to think about creating your own database for your future projects.

Introduction and Requirements

1
Introduction

This is the introduction lecture for this course.

2
Requirements From the Movie Theater

This explains the basic requirements the Movie Theater wants.

Introduction to Datatypes

1
Explaining Integer Datatypes

Explaining the TinyInt, SmallInt, Int, and BigInt datatypes.

2
Explaining Text Datatypes

Explaining char, varchar, nchar, and nvarchar datatypes.

3
Integer Datatypes

Introduction to Keys

1
Learning About Primary Keys

Discussing and implementing Primary Keys in tables.

2
Learning About Foreign Keys

Discussing and implementing Foreign Keys in tables.

3
Primary Key

Date Datatypes

1
Explaing Date and Time Datatypes

Explaining the Date, Time, DateTime and DateTime2 datatypes.

Organizing Movies and Actors

1
Creating the Movies Table

This table stores a list of our Movies.

2
Creating the Actors Table

This table stores a list of our Actors.

3
Combining the Actors and Movies Tables

This table stores links between our Movies and Actors tables.

Floating Point Datatypes

1
Explaining Floating Point Datatypes

Explaining the Float, Numeric, Decimal, Money, and SmallMoney datatypes.

Advanced Table Types

1
Creating the Ticket Prices Table

Creating the table that stores our ticket prices.

2
Working with the Food Tables
3
Employee Tables and History

Creating our Employee table and our Employee History table.

4
Creating the Customers Table

Creating the table to store our Customer details.

5
Creating the Loyalty Program Table

Creating the table for our Loyalty Program.

6
Creating the Attendance Table

Creating the table to store our attendance.

Bonus DIM Date Table

1
Bonus DIM Date Table

Showing an extra table that is useful in most databases.

Conclusion

1
Exploring the Database Diagram

Walking through our finished product.

Source Code

1
Database Schema
You can view and review the lecture materials indefinitely, like an on-demand channel.
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!
4.6
4.6 out of 5
11 Ratings

Detailed Rating

Stars 5
7
Stars 4
3
Stars 3
1
Stars 2
0
Stars 1
0
c10a3efba0382d810b30b267e66540b4
30-Day Money-Back Guarantee

Includes

1 hours on-demand video
1 article
Full lifetime access
Access on mobile and TV
Certificate of Completion