Relational Data Modelling | Schema Design Using Linkedin | Exclusive Tips & Tricks 2023
Our first video in our System Design Series. If you are a software engineer who often struggles in converting product description/interview requirements into low-level schema design, this video is the right one to get started with System Design. Attend a free masterclass by industry-leading experts here: https://www.scaler.com/events?utm_sou...
🔹About our System Design Series:
Our System Design Series will help you become better at the skills required to transition from an entry-level engineer to Senior Engineer and eventually become a software architect. We cover a series of topics ranging from schema design, basics like CAP Theorem, Consistent Hashing, overall system design like Facebook Messenger. When you cover these topics, you will be able to intuitively come up with practical solutions to real-life problem statements at your workplace. Our exclusive video will also be able to crack system design interviews at top tech companies like Facebook and Google.
🔹About Relational Data Modelling
The relational model in DBMS is an abstract model used to organize and manage the data stored in a database. It stores data in two-dimensional inter-related tables, also known as relations in which each row represents an entity and each column represents the properties of the entity.
🔹About Schema Design
Schema design is the process of creating a blueprint for a database, specifying the tables, fields, data types, and relationships between them. It defines the structure of the database and provides guidelines for creating and maintaining the database. It helps to ensure data integrity, consistency, and performance, and allows for efficient querying and data retrieval.
🔹About the instructor:
Mohit Yadav (ex- Nutanix, Hotstar) is an instructor at Scaler and has built systems that handle 10M concurrent users and ingest more than 1 TB of data per day. Having cleared interviews for Senior Engineer roles at companies like Facebook, Amazon, Google, and after interviewing more than 200 candidates at Hotstar and Nutanix, Mohit decided to make this video covering the #1 skill-gap that he observed in most engineers.
You can check his LinkedIn profile here: / mohityadav1991
The following topics are covered in this video 👇🏼
0:00 Introduction
1:14 Steps for designing Schema for Relational Database
1:50 Creating our 1st entity
3:19 Modeling Many to Many relationships
5:40 Splitting similar entities into two tables
9:01 Modeling One to Many relationships
10:00 Modelling bi-directional relationships
11:51 Combining two entities into one
13:58 Conclusion
--------------------------------------- About Scaler -------------------------------------------------
We are a tech-focused upskilling and reskilling platform catering to tech enthusiasts in universities and working professionals. There are more Scaler graduates working at Amazon than all of the IITs combined!
Know More about Scaler: https://bit.ly/3HOlI5K
📌 Follow us on Social and be a part of an amazing tech community📌
👉 Meet like-minded coder folks on Discord - / discord
👉 Tweets you cannot afford to miss out on - / scaler_official
👉 Check out student success stories, expert opinions, and live classes on Linkedin - / scalerofficial
👉 Explore relatable memes and get access to exclusive updates on Instagram - / scaler_official
📢 Be a part of our one of a kind telegram community: https://t.me/Scalercommunity
🔔 Hit that bell icon to get notified of all our new videos 🔔
If you liked this video, please don't forget to like and comment. Never miss out on our exclusive videos to help boost your coding career! Subscribe to Scaler now!
https://www.youtube.com/Scaler?sub_co...
#relationalschema #schemadesign
Watch video Relational Data Modelling | Schema Design Using Linkedin | Exclusive Tips & Tricks 2023 online without registration, duration hours minute second in high quality. This video was added by user SCALER 01 January 1970, don't forget to share it with your friends and acquaintances, it has been viewed on our site 58,66 once and liked it 1.1 thousand people.