Buying for a Team? Gift This Course
Wishlisted Wishlist

Please confirm that you want to add SQL Server the Fun Way: Architect a Movie Theater to your Wishlist.

Add to Wishlist

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.
43 students enrolled
Last updated 2/2016
English
$10 $80 88% off
4 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1 hour on-demand video
  • 1 Article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
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.

Who is the target audience?
  • Professionals looking to get an introduction into database design
Students Who Viewed This Course Also Viewed
What Will I Learn?
Understand the basic concepts that go into database design
Create their own database for their projects
View Curriculum
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
Curriculum For This Course
Expand All 20 Lectures Collapse All 20 Lectures 01:16:34
+
Introduction and Requirements
2 Lectures 03:13

This is the introduction lecture for this course.

Preview 01:35

This explains the basic requirements the Movie Theater wants.

Preview 01:38
+
Introduction to Datatypes
2 Lectures 05:54

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

Preview 03:31

Explaining char, varchar, nchar, and nvarchar datatypes.

Explaining Text Datatypes
02:23

Integer Datatypes
1 question
+
Introduction to Keys
2 Lectures 13:19

Discussing and implementing Primary Keys in tables.

Learning About Primary Keys
07:46

Discussing and implementing Foreign Keys in tables.

Learning About Foreign Keys
05:33

Primary Key
1 question
+
Date Datatypes
1 Lecture 05:28

Explaining the Date, Time, DateTime and DateTime2 datatypes.

Explaing Date and Time Datatypes
05:28
+
Organizing Movies and Actors
3 Lectures 09:15

This table stores a list of our Movies.

Creating the Movies Table
03:25

This table stores a list of our Actors.

Creating the Actors Table
02:04

This table stores links between our Movies and Actors tables.

Combining the Actors and Movies Tables
03:46
+
Floating Point Datatypes
1 Lecture 05:52

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

Explaining Floating Point Datatypes
05:52
+
Advanced Table Types
6 Lectures 23:09

Creating the table that stores our ticket prices.

Creating the Ticket Prices Table
02:53

Working with the Food Tables
06:01

Creating our Employee table and our Employee History table.

Employee Tables and History
07:49

Creating the table to store our Customer details.

Creating the Customers Table
02:30

Creating the table for our Loyalty Program.

Creating the Loyalty Program Table
02:30

Creating the table to store our attendance.

Creating the Attendance Table
01:26
+
Bonus DIM Date Table
1 Lecture 04:11

Showing an extra table that is useful in most databases.

Preview 04:11
+
Conclusion
1 Lecture 02:41

Walking through our finished product.

Exploring the Database Diagram
02:41
+
Source Code
1 Lecture 03:55
Database Schema
03:55
About the Instructor
4.5 Average rating
149 Reviews
1,539 Students
2 Courses
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.

Report Abuse