Plus any other tables which are joined to it through foreign keys. Now, the ER diagram, which I've already opened down here, shows me the table I selected, which is the customer's table. If I right-click a table, if I want to have a look and see how this table relates to other tables, then I can use the ER diagram to do that. And So, in Toad, there's a couple of features which are designed to alleviate that problem, both of which you can get from the Schema Browser window. Or they'll go and make changes to certain objects or code without really understanding the potential impact that might have on other objects in the schema. And what I want to start off with first of all is, we see a lot of problems sometimes with developers not understanding the environment they're in. And then finally, I'll take a look at the various Toad additions that the are for developers and where to go to find more information. So, it's making sure that the application is ready to go live, in terms of how it scales, where there are more users and more data. maintaining code, testing code, functional testing code, finding performance bottlenecks, how to optimize SQL statements efficiently, and finally, performance testing for production. So first of all, understanding the objects in a schema, so that developers know the environment in which they're working. First of all, problems that we see in a lot of development shops are to do with the following areas. In this video, I want to talk more about the development process and the problems that we generally encounter when we speak to development teams.
0 Comments
Leave a Reply. |