William Belisle
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.
Instructor Details
Courses : 2
Specification: SQL Server the Fun Way: Architect a Movie Theater
|
8 reviews for SQL Server the Fun Way: Architect a Movie Theater
Add a review
| Price | $12.99 |
|---|---|
| Provider | |
| Duration | 1.5 hours |
| Year | 2016 |
| Level | Beginner |
| Language | English |
| Certificate | Yes |
| Quizzes | Yes |
$12.99
Darwin –
I like all of his courses!
William Mendoza –
Great instructor. Explains clearly.
Andrew McLaughlin –
Good course. Major focus is on data types and creating keys among tables.
Glen Taylor –
I think the course was good until the end. Additional time should have been taken to include a set of a few modules to actually populate the tables with some data to demonstrate functionality. In addition, the instructor could have demonstrated the usability of the database by walking through some useful queries that the fictional theater company might have used. Finally, the section on the EmployeeHistory and DimDate tables could have used further explanation to make the course more complete.
Gaurav Singh –
I learned what this course is intended for. Instructor is very good.
AKTAR –
It is very good if you are new to database designing and creating table
Patrick Schieffer –
Moves fast and the instructor missed mentioning some key things right off the bat that would have been helpful. So far from what i’v seen, this is not a beginners course but made for those who’ve had some training already.
Carmelo L pez –
A great course to learn the concepts of creating and designing database.