Lab Answer Key: Module 1: Introduction to SQL Server 2014 Database

Sep 26, 2016 - the query is created,. BackupDB.sql. 6. In Object previously, point to Tasks. 7. In the Back drop-down list, select Script. 8. Paste the. 9. Edit the.
Télécharger le PDF
3MB taille 156 téléchargements 311 vues
commentaire
Report
Lab Answer Key: Module 1: Introduction to SQL Server 2014 Databa...

1 of 12

Lab Answer 2014 Database

https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

Server

Lab: Using Exercise

Task 1: Prepare

1.

Ensure running,

are both ADVENTUREWORKS\Student

with the 2.

In the D:

click Run as

administrator 3.

Click Yes

file, and then

wait for

Task 2: Use

1.

On the

2.

When prompted, authentication.

3.

If Object

4.

In Object

databases that are

hosted 5.

Right-click

click Server

Dashboard

26/09/2016 15:58

Lab Answer Key: Module 1: Introduction to SQL Server 2014 Databa...

2 of 12

https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

Task 3: Create

1.

Under MI

2.

In the New

Database. Then click

OK. 3.

View the

database

has been

Task 4: Run

1.

In SQL

2.

Enter the EXEC

3.

Click Execute

AWDatabase

you created 4.

Save the

folder.

Task 5: Create

1.

In SQL

2.

In the New

click Project. the project as

AWProject 3.

If Solution

4.

In Solution

Explorer. Then connect

to the MIA-SQL

26/09/2016 15:58

Lab Answer Key: Module 1: Introduction to SQL Server 2014 Databa...

3 of 12

5.

In Solution created,

6.

In Object

https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

the query is BackupDB.sql previously, point

to Tasks 7.

In the Back

drop-down list,

select Script 8.

Paste the

9.

Edit the

\Labfiles\Lab01

\Starter\AWDatabase. 10. On the 11.

Solution.

Minimize

Result: At Studio project

Management

Exercise

Task 1: Use

1.

Right-click

2.

In the command

details of all

sqlcmd sqlcmd

3.

Enter the

using Windows

authentication:

26/09/2016 15:58

Lab Answer Key: Module 1: Introduction to SQL Server 2014 Databa...

4 of 12

https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

sqlcmd

4.

In the sqlcmd MIA-SQL.

databases on in the

previous SELECT GO

5.

Enter the

Exit

Task 2: Use

1.

In the command

sqlcmd to run the

GetDBInfo sqlcmd \GetDBInfo.

2.

Note that

command

prompt 3.

Enter the sqlcmd \GetDBinfo.

26/09/2016 15:58

Lab Answer Key: Module 1: Introduction to SQL Server 2014 Databa...

5 of 12

4.

Enter the

https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

sqlcmd:

Notepad

5.

View the

6.

Close the

Result: At

database.

Exercise

Task 1: Use

1.

On the

2.

At the Windows Get-Process

3.

Review

4.

Enter the

services. “SQL”,:

Get-Process

5.

To find Get-Help

26/09/2016 15:58

Lab Answer Key: Module 1: Introduction to SQL Server 2014 Databa...

6 of 12

6.

https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

Review Get-Process

7.

Verify that

8.

Close Windows

Task 2: Using

26/09/2016 15:58

Lab Answer Key: Module 1: Introduction to SQL Server 2014 Databa...

7 of 12

1.

In SQL

https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

MIA-SQL, and then

click Start 2.

At the PowerShell Get-Module

3.

Verify that

4.

At the Windows Set-location

5.

At the Windows

display the SQL

Server Get-ChildItem

6.

At the Windows Set-location

7.

At the Windows

display the

databases Get-ChildItem

8.

At the Windows Invoke-Sqlcmd

26/09/2016 15:58

Lab Answer Key: Module 1: Introduction to SQL Server 2014 Databa...

8 of 12

9.

https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

Review

10. Close the

Management Studio

without

Task 3: Create

1.

On the

Windows

PowerShell 2.

In the PowerShell Get-Module

3.

Verify that

command to load

it: Import-Module

4.

Enter the

loaded.

Get-Module

5.

If the Commands

Command

Add-on 6.

View the

tasks such

as backing 7.

If the Script

8.

In the Script

IntelliSense feature.)

Import-Module

26/09/2016 15:58

Lab Answer Key: Module 1: Introduction to SQL Server 2014 Databa...

9 of 12

https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

Set-location

Get-Childitem IndexSpaceUsage

9.

Click Run

script may

take a few 10. Close the

example:

Import-Module Set-location

Get-Childitem IndexSpaceUsage \Database

11.

Save the

folder. Then close

the PowerShell 12. In the D:

click Run

with PowerShell 13. When the

results.

14. Close Notepad.

Result: At about databases

information

26/09/2016 15:58

Lab Answer Key: Module 1: Introduction to SQL Server 2014 Databa...

10 of 12

https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

26/09/2016 15:58

Lab Answer Key: Module 1: Introduction to SQL Server 2014 Databa...

11 of 12

https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

26/09/2016 15:58

Lab Answer Key: Module 1: Introduction to SQL Server 2014 Databa...

12 of 12

https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

26/09/2016 15:58