Sams Teach Yourself SQL in 24 Hours, Third Edition By Ronald R. Plew, Ryan K. Stephens
Table of Contents
Hour 18. Managing Database Users
Some people say that you do not need to know SQL to perform database queries. In a sense, they may be correct; however, knowing SQL definitely helps querying a database, even when using GUI tools. Even though GUI tools are good and should be used when available, it is most beneficial to understand what is happening behind the scenes, so that you can maximize the efficiency of utilizing these user -friendly tools.
Many GUI tools that aid the database user automatically generate SQL code by navigating through windows , responding to prompts, and selecting options. There are reporting tools that generate reports . Forms can be created for users to query, update, insert, or delete data from a database. There are tools that convert data into graphs and charts . There are database administration tools that are used to monitor database performance, and some that allow remote connectivity to a database. Database vendors provide some of these tools, whereas others are provided as third-party tools from other vendors .