Sorry, I haven't needed to work with SQL since the late 1990s. At that time, I just used the Microsoft book that came with MS-SQL.
That particular project had a full-time dedicated database architect who constructed all the ERDs, models, schemas, and stored procedure APIs. And he co-ordinated with the database administrators so everything would scale to the needs of the project.
He was awesome. I wish I knew what tools he used, because the output was very nice. But because of that, all the gory details were already ironed-out and given to us developers on a silver platter.
At some point after I left the project (and the DBA had also moved on), the project moved from MS-SQL to IBM DB2. I've always wondered how well that transitioned.
In general, I think the publisher Addison-Wesley produces top-notch books. Rarely do they ever print a stinker. My next favorite publisher is O'Reilly, but sometimes they have mediocre or stinkers so you need to be a little more careful.
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
Sorry, I haven't needed to work with SQL since the late 1990s. At that time, I just used the Microsoft book that came with MS-SQL.
That particular project had a full-time dedicated database architect who constructed all the ERDs, models, schemas, and stored procedure APIs. And he co-ordinated with the database administrators so everything would scale to the needs of the project.
He was awesome. I wish I knew what tools he used, because the output was very nice. But because of that, all the gory details were already ironed-out and given to us developers on a silver platter.
At some point after I left the project (and the DBA had also moved on), the project moved from MS-SQL to IBM DB2. I've always wondered how well that transitioned.
In general, I think the publisher Addison-Wesley produces top-notch books. Rarely do they ever print a stinker. My next favorite publisher is O'Reilly, but sometimes they have mediocre or stinkers so you need to be a little more careful.