SQLServerCh02

Chapter 2 How to use the Management Studio Murach's SQL Server 2012, C2 © 2012, Mike Murach & Associates, Inc. Slide 1 Objectives Applied  Use the Management Studio to do any of the following management tasks: Start or stop an instance of SQL Server Express Enable a remote connection to a database Navigate through the objects of a database Attach, detach, back up, or restore a database Set the compatibility level for a database View the database diagrams for a database View the column definitions for a table in a database View or modify the data of a table in a database Modify the column definitions for a table in a database  Use the Management Studio to run, open, and save SQL queries.  Use the Query Designer to build and run queries.  Use Books Online to look up information about SQL Server. Murach's SQL Server 2012, C2 © 2012, Mike Murach & Associates, Inc. Slide 2 Objectives (cont.) Knowledge  Briefly describe the function of each of these client tools: the Management Studio, the Query Designer, and Books Online.  Distinguish between Windows authentication and SQL Server authentication for connecting to a SQL Server database.  Describe what “compatibility level” means when it is applied to SQL Server. Murach's SQL Server 2012, C2 © 2012, Mike Murach & Associates, Inc. Slide 3 The SQL Server Configuration Manager (Services) Murach's SQL Server 2012, C2 © 2012, Mike Murach & Associates, Inc. Slide 4 The SQL Server Configuration Manager (Network Configuration) Murach's SQL Server 2012, C2 © 2012, Mike Murach & Associates, Inc. Slide 5 How to connect using Windows authentication Murach's SQL Server 2012, C2 © 2012, Mike Murach & Associates, Inc. Slide 6 How to connect using SQL Server authentication Murach's SQL Server 2012, C2 © 2012, Mike Murach & Associates, Inc. Slide 7 The Management Studio and the Object Explorer Murach's SQL Server 2012, C2 © 2012, Mike Murach & Associates, Inc. Slide 8 The Attach Databases dialog box Murach's SQL Server 2012, C2 © 2012, Mike Murach & Associates, Inc. Slide 9 The default directory for SQL Server 2012 databases C:\Program Files\Microsoft SQL Server 2012\ MSSQL11.SQLEXPRESS\MSSQL\DATA Murach's SQL Server 2012, C2 © 2012, Mike Murach & Associates, Inc. Slide 10 The Back Up Database dialog box Murach's SQL Server 2012, C2 © 2012, Mike Murach & Associates, Inc. Slide 11 The default directory for SQL Server 2012 database backups C:\Program Files\Microsoft SQL Server 2012\ MSSQL11.SQLEXPRESS\MSSQL\Backup Murach's SQL Server 2012, C2 © 2012, Mike Murach & Associates, Inc. Slide 12 The compatibility level option Murach's SQL Server 2012, C2 © 2012, Mike Murach & Associates, Inc. Slide 13 The relationships in the AP database Murach's SQL Server 2012, C2 © 2012, Mike Murach & Associates, Inc. Slide 14 The columns in the Vendors table Murach's SQL Server 2012, C2 © 2012, Mike Murach & Associates, Inc. Slide 15 A row as it’s being modified Murach's SQL Server 2012, C2 © 2012, Mike Murach & Associates, Inc. Slide 16 A SELECT statement with a completion list Murach's SQL Server 2012, C2 © 2012, Mike Murach & Associates, Inc. Slide 17 The Management Studio with an error message Murach's SQL Server 2012, C2 © 2012, Mike Murach & Associates, Inc. Slide 18 Common causes of errors  Forgetting to select the correct database from the Available Databases combo box  Misspelling the name of a table or column  Misspelling a keyword  Omitting the closing quotation mark for a character string Murach's SQL Server 2012, C2 © 2012, Mike Murach & Associates, Inc. Slide 19 The Open File dialog box Murach's SQL Server 2012, C2 © 2012, Mike Murach & Associates, Inc. Slide 20 The Query Designer window Murach's SQL Server 2012, C2 © 2012, Mike Murach & Associates, Inc. Slide 21 Books Online information Murach's SQL Server 2012, C2 © 2012, Mike Murach & Associates, Inc. Slide 22