For database management courses and courses devoted exclusively to Microsoft's SQL Server 2005.
Students need a big-picture introduction to SQL Server 2005 and they need specific examples and steps. This concise book covers all of the topics students need in a course covering SQL Server 2005 while using numerous step-by-step techniques with a rich set of databases to provide students with practical experience.
Sprache
Verlagsort
Verlagsgruppe
Zielgruppe
Maße
Höhe: 276 mm
Breite: 210 mm
ISBN-13
978-0-13-229750-9 (9780132297509)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Klassifikation
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.
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