Client/server developers are shown how to use Microsoft SQL Server 7 to build business applications that can run on both traditional networks and Intranets with this book, which provides a tutorial on how to use this tool to create applications, taking readers through each major development phase, including planning, database design, prototyping, coding and reporting. Techniques are explained with sample code and resulting output shown. The book covers: the new architecture of SQL Server 7, which is very different from earlier versions; a guide to installing the product; a review of product features, including database objects, data functions and formats; server-side database programming using stored procedures, triggers, views and other techniques; developed distributed, three-tier, client-server applications; specialized topics, such as data warehousing and replication; and systems management.
Sprache
Verlagsort
Verlagsgruppe
Zielgruppe
Für höhere Schule und Studium
Für Beruf und Forschung
Illustrationen
Maße
Höhe: 23.5 cm
Breite: 19.2 cm
Gewicht
ISBN-13
978-0-471-19233-6 (9780471192336)
Schweitzer Klassifikation
QUICK START; Getting Started; Learning the Basics of N-Tier Applications and COM; Primer for Building an Application: Part A; Primer for Building an Application: Part B; Leveraging the Project Life Cycle for Build N-TIER, COM Database Applications; BUILDING THE APPLICATION FRAMEWORK; Getting Physical; Defining and Validating Your Data; Using the Data Definition Language; Using the Data Manipulation Language; Using the Data Control Language Controlling Access to SQL Server; INCORPORATING ADVANCED FEATURES; Writing Stored Procedures (Transact-SQL Programs); Leveraging SQL Server Functions; Triggering Events; Using Advanced Data Manipulation Techniques; BUILD ADVANCED APPLICATION USING COM, INTERNET/INTRANET, VISUAL BASIC, AND MTS; Building a COM-Based, N-Tier Application; Developing the User Interface; Connecting SQL Server to the Internet; DEPLOYING PRODUCTION-READY N-TIER APPLICATIONS AND SYSTEM ADMINISTRATION; Testing, Optimization, Debugging, and Implementation; System Administration Through the Visual Tools and Wizards; Maintaining Your N-Tier COM Applications; Appendix; Bibliography; Index.
