SQL Server the Fun Way: Architect a Movie Theater

SQL Server the Fun Way: Architect a Movie Theater, available at $44.99, has an average rating of 4.15, with 20 lectures, 2 quizzes, based on 18 reviews, and has 106 subscribers.

You will learn about Understand the basic concepts that go into database design Create their own database for their projects This course is ideal for individuals who are Professionals looking to get an introduction into database design It is particularly useful for Professionals looking to get an introduction into database design.

Enroll now: SQL Server the Fun Way: Architect a Movie Theater

Summary

Title: SQL Server the Fun Way: Architect a Movie Theater

Price: $44.99

Average Rating: 4.15

Number of Lectures: 20

Number of Quizzes: 2

Number of Published Lectures: 20

Number of Published Quizzes: 2

Number of Curriculum Items: 22

Number of Published Curriculum Objects: 22

Original Price: $39.99

Quality Status: approved

Status: Live

What You Will Learn

Understand the basic concepts that go into database design
Create their own database for their projects

Who Should Attend

Professionals looking to get an introduction into database design

Target Audiences

Professionals looking to get an introduction into database design

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.

Course Curriculum

Chapter 1: Introduction and Requirements

Lecture 1: Introduction

Lecture 2: Requirements From the Movie Theater

Chapter 2: Introduction to Datatypes

Lecture 1: Explaining Integer Datatypes

Lecture 2: Explaining Text Datatypes

Chapter 3: Introduction to Keys

Lecture 1: Learning About Primary Keys

Lecture 2: Learning About Foreign Keys

Chapter 4: Date Datatypes

Lecture 1: Explaing Date and Time Datatypes

Chapter 5: Organizing Movies and Actors

Lecture 1: Creating the Movies Table

Lecture 2: Creating the Actors Table

Lecture 3: Combining the Actors and Movies Tables

Chapter 6: Floating Point Datatypes

Lecture 1: Explaining Floating Point Datatypes

Chapter 7: Advanced Table Types

Lecture 1: Creating the Ticket Prices Table

Lecture 2: Working with the Food Tables

Lecture 3: Employee Tables and History

Lecture 4: Creating the Customers Table

Lecture 5: Creating the Loyalty Program Table

Lecture 6: Creating the Attendance Table

Chapter 8: Bonus DIM Date Table

Lecture 1: Bonus DIM Date Table

Chapter 9: Conclusion

Lecture 1: Exploring the Database Diagram

Chapter 10: Source Code

Lecture 1: Database Schema

Instructors

William Belisle
Business Intelligence Master

Rating Distribution

1 stars: 1 votes
2 stars: 0 votes
3 stars: 2 votes
4 stars: 6 votes
5 stars: 9 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!

Menu