Synopses & Reviews
Students need a big-picture overview of Introduction to SQL Server 2005 and they need specific examples and steps. This concise book presents a mix of both database theory and application tools that illustrate the theory. Students learn the reason particular statements are required for the activities they are about to perform, followed by step-by-step sequences using a rich set of databases to provide students with practical experience – all in one book.
About the Author
James T. Perry is a Professor of Information Systems in the School of Business at the University of San Diego. He holds a Ph.D. in computer science from the Pennsylvania State University and a Bachelor of Science in mathematics from Purdue University. He is the co-author of over 80 textbooks and trade books covering topics such as database management systems, the Internet, accounting information systems, Microsoft Office, electronic commerce, and the Oracle database management system. Some of his most popular books have been translated into Chinese, Dutch, French, and Korean.
Jim’s prior teaching appointments, spanning over 30 years, include the Information Systems Department at San Diego State University and the Computer Science Department at the University of Nebraska. He has also worked as a computer security consultant to various private and governmental organizations including the Jet Propulsion Laboratory. He was a consultant on the Strategic Defense Initiative (“Star Wars”) project and served as a member of the computer security oversight committee. When he is not writing or teaching, Jim can be found refereeing rowing regattas throughout California.
Gerald V. Post is a Professor of management information systems at the University of the Pacific. He has a Ph.D. in economics and statistics from Iowa State University and a Bachelor degree in mathematics and economics from the University of Wisconsin-Eau Claire. He is the author of textbooks in Database Management and Management Information Systems. He has published dozens of professional papers in many journals including Communications of the ACM, Management Information Systems Quarterly, and Decision Sciences.
Jerry has taught MIS and Database classes for over twenty years. He has developed several database applications for commercial businesses. When he is not writing, you can find him riding his bike or chasing his dogs through the hills.
Table of Contents
1. Introduction Relational Database Systems and SQL Server 2005
2. Overview of SQL and Interfacing with SQL Server
3. Creating, Modifying, Renaming, and Deleting Database Tables
4. Modifying Data and Auditing Table Operations
5. Querying a Database
6. Creating Multiple Queries and Views
7. Using SQL Extensions and Stored Procedures
8. Creating Database Forms with Visual Studio
9. Customizing Forms
10. Creating and Modifying Reports
11. Building an Integrated Application
12. Maintaining Database Security
13. Database Administration
14. Creating Web-based Forms with Microsoft ASP.NET