Sign-up now and get instant access
Leave a comment
Customized training to master new skills and grow your business.
Beginner to advanced classes taught by Microsoft MVPs and Authors.
In-depth boot camps take you from a novice to mastery in less than a week.
Season Learning Pass
Get access to our very best training offerings for successful up-skilling.
Stream Pro Plus
Combine On-Demand Learning platform with face-to-face Virtual Mentoring.
A new horizon in technical exam preparation
Quick references for when you need a little guidance.
Summaries developed in conjunction with our Learn with the Nerds sessions.
Digital goodies - code samples, student files, and other must have files.
Stay up-to-date on all things Power BI, Power Apps, Microsoft 365 and Azure.
Earn money by driving sales through the Pragmatic Works' Training Affiliate Program.
It's time to address your client's training needs.
Learn how to get into IT with free training and mentorship.
Discover the faces behind our success: Meet our dedicated team
How can we help? Connect with Our Team Today!
Find all the information you’re looking for. We’re happy to help.
Pragmatic Works new course, Data Modeling, is designed for individuals who are in the process of designing new databases, particularly transactional databases and data warehouse systems. This course is taught by one of our experts on data modeling, Mitchell Pearson. Here, Mitchell answers a few questions about the course:
Data modeling is important to learn so you will know about consequences that you may run into when designing both transactional systems and dimensional warehouses. For example, maybe the dimensional model doesn’t provide all the answers to questions you wanted to ask the data when you had the design in mind.
This course will specifically go through the 4 steps of dimensional modeling, so you’ll know how to avoid these problems and not have to go back and redesign the model.
This six-and-a-half-hour course will start with the basics and then dive deep into more advanced concepts by the end.
Most people struggle with defining the granularity at the start of the design phase. When you don’t design the granularity properly from the beginning, then you realize it’s not correct as you get to the next steps. This will send you back to the drawing board.
As with all Pragmatic Works courses, the Data Modeling course offers a depth that most courses do not. This course runs over 6 hours; allowing time to go into more detail and more in depth into concepts.
If data modeling is new to you or maybe you’re self-taught and need to affirm the concepts you’re implementing are correct, then this course is for you. Click below to sign up for a free trial.
Join other Azure, Power Platform and SQL Server pros by subscribing to our blog.