Learn how to deliver powerful database solutions using SQL Server 2000 Enterprise Edition—and prepare for the Microsoft Certified Professional (MCP) exam—with this official Microsoft study guide. Work at your own pace through the lessons and hands-on exercises. And use the special exam-prep section and testing tool to measure what you know and where to focus your studies—before taking the actual exam. As you build the real-world expertise for designing data-driven business solutions, you’re also preparing for MCP Exam 70-229—a core exam for MCDBA certification and a key elective on the MCSE, MCAD, and MCSD tracks.
Build the skills to:
Develop a logical data model
Create the physical database—files, objects, space management, and growth strategy
Use Transact-SQL and Data Transformation Services (DTS) to manipulate data; extract data in XML format
Program business logic using stored procedures, transactions, triggers, user-defined functions, and views
Optimize database performance by using SQL Profiler and the Index Tuning Wizard
Design security enhancements—including managing data access, object-level security, and application roles
The New Stock Market: Law, Economics, and Policy
The U.S. stock market has been transformed over the last twenty-five years. Once a market in which human beings traded at human speeds, it is now an electronic market pervaded by algorithmic trading, conducted at speeds nearing that of light. High-frequency traders participate in a large portion of all transactions, and a significant...
The Ultimate CSS Reference A complete and thorough and up-to-date reference guide for CSS.
Stop wasting time doing Internet searches only to find inaccurate, out-of-date, or incomplete information. CSS: The Ultimate Reference includes all the ins-and-outs you need to know including compatability information for all major browsers, lists of useful hacks, known...
Encyclopedia of Pharmaceutical Technology, Third Edition (Print) (Volume 2)
Presenting authoritative and engaging articles on all aspects of drug development, dosage, manufacturing, and regulation, this Third Edition enables the pharmaceutical specialist and novice alike to keep abreast of developments in this rapidly evolving and highly competitive field. A dependable reference tool and constant companion for years...
Carbon Dioxide and Organometallics (Topics in Organometallic Chemistry)
The series Topics in Organometallic Chemistry presents critical overviews of research results in organometallic chemistry. As our understanding of organometallic structure, properties and mechanisms increases, new ways are opened for the design of organometallic compounds and reactions tailored to the needs of such diverse areas as organic...
Computer Viruses For Dummies
Build up your defenses against online germ warfare
Discover how viruses work and how to outsmart the cyber-thugs who create them
Viruses, worms, and Trojan horses create a serious health problem for your PC, but this handy little book has the antidote! It’ll help you exterminate those nasty bugs and protect your...
Game Design, Second Edition Game design is a highly collaborative art. Each of us who works in the industry is
a game designer, whether he knows it or not. From testers and producers to programmers,
artists, marketers, and executives, we all shape the games that pass
through our hands. The product that appears on the shelves is the sum of all our efforts.