SQL Server the Fun Way: Architect a Movie Theater
What you'll learn
- Understand the basic concepts that go into database design
- Create their own database for their projects
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
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 this course is for:
- Professionals looking to get an introduction into database design
Instructor
![William Belisle](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 4.4 Instructor Rating
- 1,099 Reviews
- 7,063 Students
- 4 Courses
William got his start in the Business Intelligence field at one of the largest banks in the US. He has since moved on to other companies and business sectors including Education, Healthcare, e-commerce, and Transportation. Now with over 10 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.