Transcript DBC-e06-Appendix-A-PPT

DAVID M. KROENKE and DAVID J. AUER
DATABASE CONCEPTS, 6th Edition
Appendix A
Getting Started with
Microsoft SQL Server 2012 Express Edition
All rights reserved. No part of this publication may be reproduced,
stored in a retrieval system, or transmitted, in any form or by any
means, electronic, mechanical, photocopying, recording, or otherwise,
without the prior written permission of the publisher. Printed in the
United States of America.
Copyright © 2013 Pearson Education, Inc.
Publishing as Prentice Hall
KROENKE and AUER - DATABASE CONCEPTS (6th Edition)
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
A-2
Appendix Objectives
• Learn how to create a database in SQL
Server 2012.
• Learn how to submit SQL commands to
create table structures.
• Learn how to submit SQL commands to
insert database data.
• Learn how to submit SQL commands to
query a database.
• Learn how to install the Microsoft SQL
Server 2012 ODBC Client.
KROENKE and AUER - DATABASE CONCEPTS (6th Edition)
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
A-3
The Connect to Server Dialog Box
SQL Server 2012
Figure A-1: The Connect to Server Dialog Box
KROENKE and AUER - DATABASE CONCEPTS (6th Edition)
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
A-4
Microsoft SQL Server Management Studio
SQL Server 2012
Figure A-2:
The Microsoft SQL Server Management Studio in Windows 7
KROENKE and AUER - DATABASE CONCEPTS (6th Edition)
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
A-5
The New Database Command
Figure A-3: The New Database Command
KROENKE and AUER - DATABASE CONCEPTS (6th Edition)
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
A-6
Naming the New Database
Figure A-4: Naming the New Database
KROENKE and AUER - DATABASE CONCEPTS (6th Edition)
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
A-7
The New Database in Object Explorer
Figure A-5: The New Database in the Object Explorer
KROENKE and AUER - DATABASE CONCEPTS (6th Edition)
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
A-8
The Microsoft SQL Server
Management Studio Folder
Figure A-6:
The Microsoft SQL Server Management Studio Folder in Windows Explorer
KROENKE and AUER - DATABASE CONCEPTS (6th Edition)
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
A-9
WPC SQL Statements
(Partial)
Figure A-7:
The Figure 3-7 SQL Statements to Create the WPC Database Tables
KROENKE and AUER - DATABASE CONCEPTS (6th Edition)
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
A-10
The SQLQuery1.sql
Tabbed Document Window
Figure A-8: The SQLQuery1.sql Tabbed Document Window
KROENKE and AUER - DATABASE CONCEPTS (6th Edition)
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
A-11
The SQL Script to
Create the WPC Database Tables
Figure A-9: The SQL Script to Create the WPC Database Tables
KROENKE and AUER - DATABASE CONCEPTS (6th Edition)
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
A-12
The SQL Script Results —
The WPC Tables
Figure A-10: The SQL Script Results—The WPC Tables
KROENKE and AUER - DATABASE CONCEPTS (6th Edition)
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
A-13
Creating and Running an
SQL Query
Figure A-11: The SQL Query Results
KROENKE and AUER - DATABASE CONCEPTS (6th Edition)
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
A-14
Installing the SQL Server 2012
ODBC Client
The ODBC client is automatically installed as part of the SQL Server
2012 installation, and is available as the SQL Server Native Client 11.0
in the ODBC Data Source Administrator.
KROENKE and AUER - DATABASE CONCEPTS (6th Edition)
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
A-15
DAVID M. KROENKE and DAVID J. AUER
DATABASE CONCEPTS, 5th Edition
End of Presentation on Appendix A
Getting Started with
Microsoft SQL Server 2012 Express Edition