TIMELY SOLUTIONS
- Understand the underlying concepts of SQL
- Write serviceable code that is easy to maintain
- Ensure the accuracy of all query results
- Test, scrub, and control data in a SQL environment
- Control access to database objects using privileges, roles, and views
- Secure data from unwanted intrusions
- Avoid common errors that occur during multiple table data retrieval
- Optimize multiple table query performance
- Save time using SQL to automatically generate code
- Combine output from similar tables using set operators
- Explore complex conditions and operators
- Learn to effectively control transactions
- Customize the appearance of tables using views
- Solve the problem of denormalized data
EXPERT SOFTWARE
- Over 600 listings of author's source code and examples that will help you perform many tasks, including
- Retrieving rows using nested conditions
- Activating an deactivating rows
- Adding and subtracting time
- Grouping data by more than one column (see inside front cover for more examples)
- From Embaracadero Technologies:
- Rapid SQL
- TeamSQL/Project for PVCS
TeamSQL/Project
- ER/Studio
- Concentric Data Systems' Report Writer SQL Edition
- Brio Technology's Brio Query
- Sunbelt Software Distribution's Diskeeper and Quota Manager
- Platinum's InfoPump and Report Facility
- HotSQL shareware version
- Additional third-party tools and utilities
- Understand the underlying concepts of SQL
- Write serviceable code that is easy to maintain
- Ensure the accuracy of all query results
- Test, scrub, and control data in a SQL environment
- Control access to database objects using privileges, roles, and views
- Secure data from unwanted intrusions
- Avoid common errors that occur during multiple table data retrieval
- Optimize multiple table query performance
- Save time using SQL to automatically generate code
- Combine output from similar tables using set operators
- Explore complex conditions and operators
- Learn to effectively control transactions
- Customize the appearance of tables using views
- Solve the problem of denormalized data
EXPERT SOFTWARE
- Over 600 listings of author's source code and examples that will help you perform many tasks, including
- Retrieving rows using nested conditions
- Activating an deactivating rows
- Adding and subtracting time
- Grouping data by more than one column (see inside front cover for more examples)
- From Embaracadero Technologies:
- Rapid SQL
- TeamSQL/Project for PVCS
TeamSQL/Project
- ER/Studio
- Concentric Data Systems' Report Writer SQL Edition
- Brio Technology's Brio Query
- Sunbelt Software Distribution's Diskeeper and Quota Manager
- Platinum's InfoPump and Report Facility
- HotSQL shareware version
- Additional third-party tools and utilities