Stars, Flakes, Vaults and the Sins of Denormalisation

Providing both performance and flexibility are often seen as contradictory goals in designing large scale data implementations. In this talk we will discuss techniques for denormalisation and provide a framework for understanding the performance and flexibility implications of various design options. We will examine a variety of logical and physical design approaches and evaluate the trade offs between them. Specific recommendations are made for guiding the translation from a normalised logical data model to an engineered-for-performance physical data model. The role of dimensional modeling and various physical design approaches are discussed in detail. Best practices in the use of surrogate keys is also discussed. The focus is on understanding the benefit (or not) of various denormalisation approaches commonly taken in analytic database designs.

Discounts

Face to face public courses: early bird pricing is available until 2 weeks prior. Group discounts: 5% for 2–4 people, 10% for 5–6 people, 15% for 7–8 people, and 20% for 9 or more people. Discounts are calculated during checkout.

Online public courses: available at a 25% off the face-to-face courses as a special introductory price. to groups or to individuals who want to follow a curriculum program and attend multiple courses:

  • 2-4 courses/attendees 10% off
  • 5+ courses/attendees 20% off

Hurry as bookings will close 1 week before each course. Group discounts are calculated during checkout on individual courses. Individuals can book multiple courses at a discount – please enquire.

Course Booking Terms and Conditions

Additional Information

AudienceExperts, management, architects, BI analysts, and data scientists interested in learning to use advanced analytic techniques to find insights in data and who has at least some scripting experience, although there’s no scripting involved.
PrerequisitesStudents should have completed or have equivalent knowledge to the course Data Literacy for Everyone.
Objectives
  • Learn how to apply engineering principles to physical database design decisions.
  • Learn about the trade offs when making denormalisation decisions.
  • Learn best practices in the use of logical, physical, and semantic data modeling principles.
Workshop
Duration3hrs – 1 day, depending on your organisation’s requirements
TrainerStephen Brobst
Delivery MethodIn-person at AlphaZetta Academy locations or on-premise for corporate groups

Our online courses run as live online meetings using Zoom for the video meeting part and Microsoft virtual computers for the practical components. The benefit of having a live trainer for online training is you can ask questions, obtain mentoring from the trainer and interact with classmates.

Course participants will require the following technologies and online accounts. Please check that your setup satisfies these requirements:

  • Course participants will require the following technologies and online accounts:
  • Reliable computer (Windows, Mac or Linux)
  • Webcam (to help facilitate the mentoring aspect of our training)
  • Reliable internet access
  • A quiet space
  • Zoom video conferencing software and Zoom account (register and pre-install the software at zoom.us)
  • Microsoft account in order to access the virtual lab PCs (Existing or new account. There’s nothing to be installed, you just need an account to sign-in with.)

Meals and refreshments

Face-to-face courses: Catered morning tea and lunch are provided on both days of the course. Please notify us at least a week ahead if you have any special dietary requirements.

Feedback

Use academy@alphazetta.ai to email us any questions about the course, including requests for more detail, or for specific content you would like to see covered, or queries regarding prerequisites and suitability.
If you would like to attend but for any reason cannot, please also let us know.

Variation

Course material may vary from advertised due to demands and learning pace of attendees. Additional material may be presented, along with or in place of advertised.

Cancellations and refunds

You can get a full refund if you cancel 14 days or more before the course starts. No refunds will be issued for cancellations made less than 14 days before the course starts.

Frequently asked questions (FAQ)

Do I need to bring my own computer?
This is dependent on the venue. Please check the course event page.

Why do I need to provide a shipping address?
For online courses, we need an address to send you the course notes that you need for the course.

Private and Corporate Training

In addition to our public seminars, workshops and courses, AlphaZetta Academy can provide this training for your organisation in a private setting at your location or ours, or online. Please enquire to discuss your needs.

Scheduled Public Courses

[fusion_events cat_slug=”stars-flakes-vaults-and-sins-of-denormalisation” past_events=”no” number_posts=”” columns=”1″ column_spacing=”” picture_size=”auto” padding_top=”” padding_right=”” padding_bottom=”” padding_left=”” content_length=”” excerpt_length=”” strip_html=”” pagination=”no” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” class=”academy_events” id=”” /]

Private and Corporate Training

In addition to our public seminars, workshops and courses, AlphaZetta Academy can provide this training for your organisation in a private setting at your location or ours, or online. Please enquire to discuss your needs.

Other Data Management Courses & Workshops

2021-07-23T01:03:47+00:00May 13th, 2019|Tags: , , , |

Share This Training, Choose Your Platform!

Go to Top