2017 Louis Davidson - Exam Ref 70-762 Developing SQL Databases.pdf

(6842 KB) Pobierz
Exam Ref 70-762
Developing SQL
Databases
Louis Davidson
Stacia Varga
Exam Ref 70-762 Developing SQL Databases
Published with the authorization of Microsoft Corporation by:
Pearson Education, Inc.
Copyright © 2017 by Pearson Education Inc.
All rights reserved. Printed in the United States of America. This publication is protected by copyright, and permission must
be obtained from the publisher prior to any prohibited reproduction, storage in a retrieval system, or transmission in any
form or by any means, electronic, mechanical, photocopying, recording, or likewise. For information regarding permissions,
request forms, and the appropriate contacts within the Pearson Education Global Rights & Permissions Department, please visit
www.pearsoned.com/permissions/. No patent liability is assumed with respect to the use of the information contained herein.
Although every precaution has been taken in the preparation of this book, the publisher and author assume no responsibility for
errors or omissions. Nor is any liability assumed for damages resulting from the use of the information contained herein.
ISBN-13: 978-1-5093-0491-2
ISBN-10: 1-5093-0491-6
Library of Congress Control Number: 2016962647
First Printing January 2017
Trademarks
Microsoft and the trademarks listed at https://www.microsoft.com on the “Trademarks” webpage are trademarks of the
Microsoft group of companies. All other marks are property of their respective owners.
Warning and Disclaimer
Every effort has been made to make this book as complete and as accurate as possible, but no warranty or fitness is
implied. The information provided is on an “as is” basis. The authors, the publisher, and Microsoft Corporation shall have
neither liability nor responsibility to any person or entity with respect to any loss or damages arising from the information
contained in this book or programs accompanying it.
Special Sales
For information about buying this title in bulk quantities, or for special sales opportunities (which may include electronic
versions; custom cover designs; and content particular to your business, training goals, marketing focus, or branding
interests), please contact our corporate sales department at corpsales@pearsoned.com or (800) 382-3419.
For government sales inquiries, please contact governmentsales@pearsoned.com.
For questions about sales outside the U.S., please contact intlcs@pearson.com.
Editor-in-Chief
Acquisitions Editor
Development Editor
Managing Editor
Senior Project Editor
Editorial Production
Copy Editor
Indexer
Proofreader
Technical Editor
Cover Designer
Greg Wiegand
Trina MacDonald
Rick Kughen
Sandra Schroeder
Tracey Croom
Backstop Media
Jordan Severns
Julie Grady
Christina Rudloff
Christopher Ford
Twist Creative, Seattle
Contents at a glance
Introduction
Preparing for the exam
CHAPTER 1
CHAPTER 2
CHAPTER 3
CHAPTER 4
xi
xv
1
101
195
265
Design and implement database objects
Implement programmability objects
Manage database concurrency
Optimize database objects and SQL infrastructure
Index
369
This page intentionally left blank
Zgłoś jeśli naruszono regulamin