SQL Server the Fun Way: Architect a Movie Theater

Datatypes, table structures, and best practices presented in a fun, relateable way
4.7 (3 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
39 students enrolled
$19
$80
76% off
Take This Course
  • Lectures 20
  • Length 1.5 hours
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 11/2015 English

Course Description

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?

  • 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

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction and Requirements
01:35

This is the introduction lecture for this course.

01:38

This explains the basic requirements the Movie Theater wants.

Section 2: Introduction to Datatypes
03:31

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

02:23

Explaining char, varchar, nchar, and nvarchar datatypes.

Integer Datatypes
1 question
Section 3: Introduction to Keys
07:46

Discussing and implementing Primary Keys in tables.

05:33

Discussing and implementing Foreign Keys in tables.

Primary Key
1 question
Section 4: Date Datatypes
05:28

Explaining the Date, Time, DateTime and DateTime2 datatypes.

Section 5: Organizing Movies and Actors
03:25

This table stores a list of our Movies.

02:04

This table stores a list of our Actors.

03:46

This table stores links between our Movies and Actors tables.

Section 6: Floating Point Datatypes
05:52

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

Section 7: Advanced Table Types
02:53

Creating the table that stores our ticket prices.

Working with the Food Tables
06:01
07:49

Creating our Employee table and our Employee History table.

02:30

Creating the table to store our Customer details.

02:30

Creating the table for our Loyalty Program.

01:26

Creating the table to store our attendance.

Section 8: Bonus DIM Date Table
04:11

Showing an extra table that is useful in most databases.

Section 9: Conclusion
02:41

Walking through our finished product.

Section 10: Source Code
Database Schema
Article

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

William Belisle, Business Intelligence Master

William got his start in the Business Intelligence field at one of the largest banks in the US. He has since moved on to another company but he continues to pursue his love of BI. Now with seven years of experience working with the Microsoft BI stack he knows how to get projects done.

William has made countless reports using SQL Server Reporting Services (SSRS). With his knowledge and creativity combined he is able to deliver great reporting that helps businesses make decisions. From simple dashboards to complex projects scaled out to 100s of users, William has a broad pool of experience to draw from.

Self taught and highly motivated, William brings his energy and expertise to every project.

Ready to start learning?
Take This Course