Hi Experts,
I am learning and when I want to practice Subqueries and Joins from the database say Adventureworks or T-SQL Information Schema, I am not able to know how to join and how to create an ERD.
My challenge in any system is that I need to know the data model before I practice and how do we create it ?
How do I know which column should be linked to which column in the ERD
Example: Is there a ERD and data model explanation for Information Schema of SQL server ? I can test the solution with solutions from google.
Any advice on how to approach when you are given this task of the system one is not aware of ?
Thanks in Advance
January 15, 2022 at 11:27 pm
Look at the database diagram?
January 16, 2022 at 6:12 am
No I don't see them for the sample database I have restored or the built-in INFORMATION SCHEMA
January 16, 2022 at 3:14 pm
@pietlinden Thank you very much. I will work on this. Is my thought process correct that I understand the ERD before working on these database-related questions on joins, sub querries, CTEs and Window Functions
January 16, 2022 at 4:18 pm
Understanding what the different tables describe helps a lot. You don't necessarily have to understand the entire diagram, just the part(s) you're going to use.
January 17, 2022 at 9:13 am
Ask for "view definition" to be granted to you, so you can seed an objects composition.
GRANT view definition TO [user_or_role]
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply