Latest Courses
ISTQB Artificial Intelligence Tester Sample ExamsCheck course
JAVA Programming Online Practice ExamCheck course
Programming for Kids and Beginners: Learn to Code in PythonCheck course
Practice Exams | Codeigniter 4 developer certificationCheck course
WordPress Practice Tests & Interview Questions (Basic/Adv)Check course
Git &Github Practice Tests & Interview Questions (Basic/Adv)Check course
Machine Learning and Deep Learning for Interviews & ResearchCheck course
Laravel | Build Pizza E-commerce WebsiteCheck course
101 - F5 CERTIFICATION EXAMCheck course
Master Python by Practicing 100 QuestionCheck course
ISTQB Artificial Intelligence Tester Sample ExamsCheck course
JAVA Programming Online Practice ExamCheck course
Programming for Kids and Beginners: Learn to Code in PythonCheck course
Practice Exams | Codeigniter 4 developer certificationCheck course
WordPress Practice Tests & Interview Questions (Basic/Adv)Check course
- 74% SQL Server the Fun Way: Architect a Movie Theater

SQL Server the Fun Way: Architect a Movie Theater

$12.99Track price

Add your review
Add to wishlistAdded to wishlistRemoved from wishlist 0
Add to compare
8.0/10 (Our Score)
Product is rated as #30 in category NoSQL

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

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.

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

Duration

1.5 hours

Year

2016

Level

Beginner

Certificate

Yes

Quizzes

Yes

8 reviews for SQL Server the Fun Way: Architect a Movie Theater

4.4 out of 5
5
1
2
0
0
Write a review
Show all Most Helpful Highest Rating Lowest Rating
  1. Darwin

    I like all of his courses!

    Helpful(0) Unhelpful(0)You have already voted this
  2. William Mendoza

    Great instructor. Explains clearly.

    Helpful(0) Unhelpful(0)You have already voted this
  3. Andrew McLaughlin

    Good course. Major focus is on data types and creating keys among tables.

    Helpful(0) Unhelpful(0)You have already voted this
  4. 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.

    Helpful(0) Unhelpful(0)You have already voted this
  5. Gaurav Singh

    I learned what this course is intended for. Instructor is very good.

    Helpful(0) Unhelpful(0)You have already voted this
  6. AKTAR

    It is very good if you are new to database designing and creating table

    Helpful(0) Unhelpful(0)You have already voted this
  7. 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.

    Helpful(0) Unhelpful(0)You have already voted this
  8. Carmelo L pez

    A great course to learn the concepts of creating and designing database.

    Helpful(0) Unhelpful(0)You have already voted this

    Add a review

    Your email address will not be published. Required fields are marked *

    This site uses Akismet to reduce spam. Learn how your comment data is processed.

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

    $12.99

    Price tracking

    Java Code Geeks
    Logo
    Register New Account
    Compare items
    • Total (0)
    Compare