Introduction to Database Architecture

Creating a database for a movie theater chain 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.

What are the requirements?

• A familiarity with Microsoft SQL Server is nice to have
• Students can follow along with the videos or if you want to experiment with your own database, download and install the free version of Microsoft SQL Server

What am I going to get from this course?

• Over 19 lectures and 1 hour of content!
• Understand the basic concepts that go into database design
• Create their own database for their projects

What is the target audience?

• Professionals looking to get an introduction into database design

Curriculum
Section 1: Introduction and Requirements
Lecture 1 Introduction 01:35
This is the introduction lecture for this course.

Lecture 2 Requirements From the Movie Theater 01:38
This explains the basic requirements the Movie Theater wants.

Section 2: Introduction to Datatypes
Lecture 3 Explaining Integer Datatypes 03:31
Explaining the TinyInt, SmallInt, Int, and BigInt datatypes.

Lecture 4 Explaining Text Datatypes 02:23
Explaining char, varchar, nchar, and nvarchar datatypes.

Quiz 1 Integer Datatypes 1 question
Section 3: Introduction to Keys
Lecture 5 Learning About Primary Keys 07:46
Discussing and implementing Primary Keys in tables.

Lecture 6 Learning About Foreign Keys 05:33
Discussing and implementing Foreign Keys in tables.

Quiz 2 Primary Key 1 question
Section 4: Date Datatypes
Lecture 7 Explaing Date and Time Datatypes 05:28
Explaining the Date, Time, DateTime and DateTime2 datatypes.

Section 5: Organizing Movies and Actors
Lecture 8 Creating the Movies Table 03:25
This table stores a list of our Movies.

Lecture 9 Creating the Actors Table 02:04
This table stores a list of our Actors.

Lecture 10 Combining the Actors and Movies Tables 03:46
This table stores links between our Movies and Actors tables.

Section 6: Floating Point Datatypes
Lecture 11 Explaining Floating Point Datatypes 05:52
Explaining the Float, Numeric, Decimal, Money, and SmallMoney datatypes.

Section 7: Advanced Table Types
Lecture 12 Creating the Ticket Prices Table 02:53
Creating the table that stores our ticket prices.

Lecture 13 Working with the Food Tables 06:01
Lecture 14 Employee Tables and History 07:49
Creating our Employee table and our Employee History table.

Lecture 15 Creating the Customers Table 02:30
Creating the table to store our Customer details.

Lecture 16 Creating the Loyalty Program Table 02:30
Creating the table for our Loyalty Program.

Lecture 17 Creating the Attendance Table 01:26
Creating the table to store our attendance.

Section 8: Bonus DIM Date Table
Lecture 18 Bonus DIM Date Table 04:11
Showing an extra table that is useful in most databases.

Section 9: Conclusion
Lecture 19 Exploring the Database Diagram 02:41
Walking through our finished product.







For More Rare Movies Check out my blog!

No Mirrors Please