Exam Ref 70-762 Developing SQL Databases.pdf

(29612 KB) Pobierz
Exam Ref 70-762 Developing SQL
Databases
Louis Davidson
Stacia Varga
2
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.
3
For questions about sales outside the U.S., please contact
intlcs@pearson.com.
Editor-in-Chief
Greg Wiegand
Acquisitions Editor
Trina MacDonald
Development Editor
Rick Kughen
Managing Editor
Sandra Schroeder
Senior Project Editor
Tracey Croom
Editorial Production
Backstop Media
Copy Editor
Jordan Severns
Indexer
Julie Grady
Proofreader
Christina Rudloff
Technical Editor
Christopher Ford
Cover Designer
Twist Creative, Seattle
4
Contents at a glance
Introduction
Preparing for the exam
CHAPTER 1
Design and implement database objects
CHAPTER 2
Implement programmability objects
CHAPTER 3
Manage database concurrency
CHAPTER 4
Optimize database objects and SQL infrastructure
Index
5
Zgłoś jeśli naruszono regulamin