Intro to Database Concepts for Power Apps People
ฝัง
- เผยแพร่เมื่อ 1 ส.ค. 2024
- Dive deep into the core of database management within Power Apps! This video unravels the complexities of database concepts such as normalization, relationships, primary keys, and more. Whether you're utilizing SharePoint, Excel, SQL, Dataverse, or any other data source, understanding how to structure your data is crucial for optimizing performance, scalability, and the longevity of your application. We start from a basic list of data and progressively break it down, explaining every concept with diagrams and demos. This video is a snippet from the Power Platform University, offering a glimpse into the detailed lessons provided in the program.
What You Will Learn:
Database Basics: Uncover the fundamentals of database management, focusing on tables, rows, and columns.
Normalization: Learn how to minimize redundancy in your database for improved efficiency.
Key Concepts: Understand primary keys, foreign keys, and their significance in database relationships.
Data Structuring: Discover how to structure your data correctly for various data sources like SharePoint, Excel, SQL, and Dataverse.
Relationships Explained: Get a clear explanation of one-to-many and many-to-one relationships and how they apply to your data.
Practical Demonstrations: See real-life applications of these concepts within Power Apps through detailed demonstrations.
Who Should Watch:
This video is perfect for Power Apps developers, database administrators, and anyone interested in database management and application development. Whether you're a beginner confused by database terminology or an experienced developer looking to refine your data structuring skills, this video has valuable insights for you.
Join Us at Power Platform University:
Interested in mastering Power Platform? Join our comprehensive six-month program at Power Platform University, featuring live sessions, hands-on projects, and a personal mentor to guide your learning journey. Learn more at PowerApps911.com.
Tags:
#PowerApps #DatabaseManagement #Normalization #DataStructuring #PowerPlatform #ApplicationDevelopment #PowerPlatformUniversity #DatabaseConcepts
Up your Power Apps Skills Today!
www.powerapps911.com/up-your-...
0:00 PowerApps Database Concepts
0:53 Start with a Table
2:40 Normalization
4:39 Many-to-one
6:09 Demo: SharePoint LookUp Column
8:04 One-to-Many
9:16 Demo: Parent Child in an App
12:23 More Complex Normalization
17:17 Demo: A Better Data Model
18:43 Many-to-Many
Do you need some help with something that you are working on, contact us!
www.powerapps911.com/contact
Join this channel to get access to perks:
/ @shanescows
PowerApps911
www.powerapps911.com/
Let's connect on social!
Twitter: / shanescows
Facebook: / powerapps911
Instagram: / shaneyoung911
LinkedIn: / cincyshane - วิทยาศาสตร์และเทคโนโลยี
![หมานแต่ผัวเขา - แสตมป์ โตเกียวมิวสิค [ OFFICIAL MUSIC VIDEO ]](http://i.ytimg.com/vi/m0g1TSBJPgo/mqdefault.jpg)
Normalize until it hurts, de-normalize until it works : ) I sure wish data modeling was still taught/required prior to development!
Never heard it put that way but I like it! 🤩
I appreciate these videos focusing on the fundamental concepts instead of just the applications. This video, along with the API video, was truly enjoyable.
Thanks for the comment. That means a lot to me. Glad it helped. 🤩
I really like your plain-language approach to discussing Normalization of data. It's often hard for newbies to wrap their heads around concepts expressed in formal, technical terms. Huzzah.
Thanks George. That was what I was going for. Relatable instead of fancy. 🥰
Just what I was looking for. This is a great video. So many questions answered!
I learned this concept in one of your videos, the one you reference to here... Since then it feels for me as if I had gained a super power. REALLY! I can't thank you enough for what you do for the community!
Excellent! Love to hear when people do awesome stuff with the content. 😎
Thank you for sharing more light on database Shane
Happy to help. 🐶
This was really really good, Shane. Not a novice I would say but it did deepen my understanding in certain areas so thoroughly enjoyed it. I think you should do more of these "concept understanding" videos and Data Modelling is one area I would like to see more of so happy if you can go into a bit more depth. Generally through, we understanding more of the concepts will be great as that will help us build more robust apps. Thanks for sharing
Thanks for the kind words. 😎 More core skills to come.
Good video Shane. I see questions that this video will answer asked all the time on the reddit. Hopefully it finds the right ears!
Thanks. I am with you, database concepts are confusing for new makers, so hopefully we can help more of them feel less overwhelmed.
Such a great video!
Thanks. 😊 Database concepts are so foundational
Great review. The hardest thing for me happens when if i have to create several tables or 1 table ( grouping all data ). I dont have the knowledge for. The only thing i consider is the 2000 rows sharepoint limit ( no concatenation wide database method ) when i use a lookup function with powerapps.
Did you check out this video? th-cam.com/video/7XXo9wjnJvc/w-d-xo.html on making the multiple table approach? It might help.
@@ShanesCows I will. Thx you Shane.
You used to say your apps where not nice looking. This looks like a nice app. But lookup in SP does have some limits when item count increase, where do you set the limit regarding items and lookup.?
Thanks Carsten. I rarely use SharePoint lookup columns. They have so many little gotchas, if I want a relationship I usually make it myself.
In the first example you have both Employee and Manager, but only the employees are normalized, while managers are still stored fully, and not by ID. I've always wondered how this is supposed to be handled, because it's like a second 1 to many relationship between the same tables. Any advice?
You don't store manager. Manager come from Departments. So by mapping to Executive department you get the manager.
Or do you mean the fact that Managers are an employee. Yes, you could create a many-to-one for Managers back to Employees. That wouldn't be uncommon, but that is super confusing so I tried not to go that far in the video. :)
PMFJI here. You can handle Managers as a Self-Join on the Employee table.
You can add a field called "ManagerID" to the Employee table. ManagerID contains the EmployeeID of the Employee (i.e. Manager) to whom that employee reports. A query which includes the Employee table twice, once aliased as "Manager" to distinguish it from the "Employee". Join on the ManagerID to EmployeeID and the resulting query can show each employee with their current manager.
Hey Shane, have you noticed that the Enhanced component properties have changed? They wiped out the property type option. All of my Event type custom properties are wiped out. I’m so angry now.
I had not noticed that :( I will ahve to look around. Sorry
@@ShanesCowsAuthoring version 3.24032.26 (NOT yet recommended) corrects the error but doesn’t fix the other error the previous version introduced.
On the Power Apps Community > Forums > Get Help with Power Apps > Building Power Apps there is the topic discussion titled: Problem with Event Type property on Components.
@@ShanesCowsAnother thread is labeled: Components triggering when editing code
@@ShanesCowsThey just pushed authoring version 3.24031.27.
So In a nutshell; A choice column in a parent table, should become a child table if and when... The choice requires more than 1 column of data to be represented. For example, foods can be a choice so long as you're just tracking foods. Once you begin to track quantity, or price, or size, color, weight. then you need a child table. Period.