Rapid and complete tour of SqlDBM - online database modeling tool The latest version of the tool - as of August 2022 More information at sqldbm.com/Home/
I am really new (rookie) to DB management in general and in sqlDBM, but your software seems so full of capabilities, yet user friendly and easy to navigate. UI/UX is really helpful, I feel like all I may need can be found in one screen. I have that feeling. I will watch the long -video training for sure! Well done.
Hey there, god bless your efforts... I am a totally sql noob with a general enquiry.. Is a schema equivalent to a database..Why should i care about having multiple schemas when i can have multiple databases? Thanks for taking care of this...
Good question. A database object must exist within a database and schema. A both schema and db are levels of organization when grouping objects. Modern cloud databases like Snowflake make it easy to access objects across databases but this has not always been the case. There is no right answer here. Having objects divided across different databases and schemas gives more flexibility in administering access and permissions and grouping objects from similar areas. How many schemas and databases you create depends on the business needs.
I am really new (rookie) to DB management in general and in sqlDBM, but your software seems so full of capabilities, yet user friendly and easy to navigate. UI/UX is really helpful, I feel like all I may need can be found in one screen. I have that feeling. I will watch the long -video training for sure! Well done.
Hey, I wanted to connect with Amazon redshift directly, how we can do that?
Hey there, god bless your efforts...
I am a totally sql noob with a general enquiry..
Is a schema equivalent to a database..Why should i care about having multiple schemas when
i can have multiple databases?
Thanks for taking care of this...
Good question. A database object must exist within a database and schema. A both schema and db are levels of organization when grouping objects. Modern cloud databases like Snowflake make it easy to access objects across databases but this has not always been the case. There is no right answer here. Having objects divided across different databases and schemas gives more flexibility in administering access and permissions and grouping objects from similar areas. How many schemas and databases you create depends on the business needs.
that is a pretty stupid question LMAO. Go learn something about SQL before you watch on how to model it.