Microsoft® Windows® SharePoint® Designer 2010: Level 2
Part Number: 084700

About This Course

If you are enrolling in this course, you most likely are already using SharePoint Designer to create customized SharePoint sites matching your branding. However, you may want to go further than this, and extend your sites to include more functionality. With SharePoint Designer 2010, you can extend your sites more easily than before. In this course, you will use SharePoint Designer 2010 to enhance site functionality by incorporating forms and data sources and administer SharePoint sites.

Most websites are designed to cater to various business needs and require you to provide features beyond document sharing and collaboration. With SharePoint Designer 2010, you can add a number of server-side controls, customize workflows, and administer your site, providing your SharePoint site the level of customization required by your company.

Course Description

Target Student

This course is intended for entry-level SharePoint solution developers who are currently capable of creating basic SharePoint sites using the out-of-the-box functionality provided by the built-in SharePoint Designer templates, and who now want to extend or create SharePoint sites with functionality by incorporating server web controls, data controls, customized workflows, and administration.

Course Prerequisites

To ensure your success in this course, you should be able to create basic SharePoint sites using existing SharePoint Designer templates. You can attain this level of skill and knowledge by taking the Microsoft® Windows® SharePoint® Designer 2010Level 1 course prior to this course.

Course Objective

In this course, you will extend a SharePoint site by including server-side controls and administer a SharePoint site.

You will:

Course Requirements

Hardware:

You will need two servers for the classroom, plus one client computer for each student in the class, plus one client computer for the instructor. For each of these machines, the following hardware requirements are the minimum suggested for this course:

Instructor Note: You can use the instructions provided in the class setup section in the course setup document (enus_084700_course_setup.htm) to set up the live environment for students to practice in class. Since the class setup requirements for this course are very steep, we have also provided simulations for all the guided activities in the course. If you choose to, you can run the simulations provided in the Data\Interactives folder on the CD-ROM that shipped with this course to practice the activities.
Instructor Note: Please note that an actual production environment would require at least twice as much available RAM and additional free disk space for day-to-day operations. 

Platform:

Software:

Domain Controller/Mail Server

The following software is required for the server that will be used as the classroom domain controller and mail server.

Instructor Note: You can use the detailed instructions provided in the class setup section in the course setup document (enus_084700_course_setup.htm) to set up the live environment for students to practice the activities in class. Since the class setup requirements for this course are very steep, we have also provided simulations for all the guided activities in the course on the CD-ROM that shipped with this course. You can run the simulations on any Windows computer to review the activity after class or as an alternative to performing the activity as a group in class. The activity simulation can be launched directly from the CD-ROM by clicking the Interactives button and navigating to the appropriate one, or from the default installed datafile location by opening the C:\084700Data\Simulations folder and double-clicking the appropriate executable (EXE) file located in the appropriate activity folder.
Instructor Note: If you choose to, you can evaluate your understanding of a particular lesson by taking the assessment provided in the CD-ROM. To launch the assessment, on the screen, click the Assessment button and choose the respective lesson.
Instructor Note: This setup uses Windows Server 2003 as the operating system for the Domain Controller/Mail Server because with Windows Server 2003 you can use the built-in POP3 service for your mailboxes. You can also set up the Domain Controller/Mail Server on a Windows Server 2008 machine, but in that case you will also need to install and configure Exchange Server as well.

Software:

SharePoint Foundations Server

The following software is required for the computer that will be used as the SharePoint Foundations server.

Software:

Student and Instructor Client Computers

The following software is required for the client computers:

Instructor Note: Although this course was developed with Windows XP Professional, client computers with Windows Vista Business and Windows 7 installed will work similarly.

Class Setup

Since the class setup requirements for this course are complex, simulations are provided for all the activities in the course. If you choose to, you can run the simulations provided to perform the activities in class or to review after class. A detailed description of the required setup is also provided for your reference, and for your use if you prefer to create a live environment for the class. The classroom environment consists of two Windows Servers: a domain controller/mail server and a SharePoint server, and one workstation for the instructor and one for each person in the class.

Create the Domain Controller/Mail Server

Complete the following steps to create the domain controller and mail server.

Step 1.
Install Microsoft Windows Server 2003, Standard or Enterprise Edition, with the following parameters:
Parameter Value
Computer Name DC
Administrator Password !Pass1234
Workgroup Name WORKGROUP
Step 2.
Install Windows Server 2003 Service Pack 2. When prompted, restart the computer and log on as Administrator.
Step 3.
Configure the network settings.
  • Choose Start→Control Panel→Network Connections→Local Area Connection.
  • Click Properties, select Internet Protocol (TCP/IP), and click Properties.
  • Configure the network settings as follows:
    • IP Address: 192.168.1.200
    • Subnet Mask: 255.255.255.0
    • Default Gateway: 192.168.1.200
    • Preferred DNS Server: 192.168.1.200
  • Click OK twice, and then click Close.
Step 4.
Install additional Windows components.
  • Choose Start→Control Panel→Add Or Remove Programs.
  • Click Add/Remove Windows Components.
  • Verify that Application Server is checked, and check Email Services.
  • Check Networking Services, and click Details.
  • Check Domain Name System (DNS) and Windows Internet Name Service (WINS), and click OK.
  • Click Next.
  • If prompted, provide the system files.
  • When the installation is complete, click Finish, and then close the Add Or Remove Programs control panel.
Step 5.
Promote the server to a domain controller.
  • Choose Start→Run.
  • Type dcpromo and press Enter.
  • In the Active Directory Installation wizard, click Next twice.
  • Verify that Domain Controller For A New Domain is selected and click Next.
  • Verify that Domain In A New Forest is selected and click Next.
  • For Domain Name, type ourglobalcompany.com and click Next.
  • For Domain Default NetBIOS Name, type GLOBAL and click Next.
  • To accept the default database locations and Shared System Volume, click Next twice.
  • Verify that Install And Configure The DNS Server On This Computer And Set This Computer To Use This DNS Server As Its Preferred DNS Server is selected, and click Next.
  • Verify that Permissions Compatible Only With Windows 2000 Or Windows Server 2003 Operating Systems is selected, and click Next.
  • For the Restore Mode Password, enter and confirm !Pass1234 and click Next.
  • Review the settings, and click Next.
  • Click Finish and then click Restart Now.
  • When the computer restarts, log on as Administrator.
Step 6.
Configure DNS.
  • Choose Start→Administrative Tools→DNS.
  • Expand DC→Forward Lookup Zones→ourglobalcompany.com.
  • Choose Action→New Mail Exchanger.
  • For Fully Qualified Domain Name Of The Mail Server, type dc.ourglobalcompany.com and click OK.
  • Choose Action→New Alias.
  • For Alias, type mail.
  • For Fully Qualified Domain Name Of The Target Host, type dc.ourglobalcompany.com and click OK.
  • Close the DNS Management Console.
Step 7.
Configure mail services.
  • Choose Start→Administrative Tools→POP3 Service.
  • Right-click DC and choose Properties.
  • Verify that Authentication Method is set to Active Directory Integrated.
  • Uncheck Always Create An Associated User For New Mailboxes and click OK.
  • Select DC and click New Domain.
  • For Domain Name, type ourglobalcompany.com and click OK.
  • Expand DC, and click ourglobalcompany.com.
  • Click Add Mailbox, type administrator and click OK.
  • If necessary, in the POP3 Service information box, check Do Not Show This Message Again, and click OK.
  • Close the POP3 Service Management Console.
Step 8.
Create Active Directory user accounts. You can use several different tools to accomplish this including the Active Directory Users And Computers Administrative Tool and the
net user
command in a command prompt.
User's Display Name Password Email Address
central !Pass1234 central@ourglobalcompany.com
user01 through user12 (or as many as required) !Pass1234 user01@ourglobalcompany.com through user12@ourglobalcompany.com (or as many as required)
Step 9.
Create mailboxes for all users.
  • Open the POP3 Service control panel.
  • Expand DC and select ourglobalcompany.com.
  • Click Add Mailbox.
  • For Mailbox Name, type central
  • If necessary, in the POP3 Service information box, check Do Not Show This Message Again, and click OK.
  • Click OK.
  • Repeat steps “c” to “f” for all other user names that you added in the previous step using the Display Name as the Mailbox Name.
  • Close the POP3 Service control panel.

Install Windows Server 2008

Follow these steps to install Windows Server 2008 on the computer that will be used as the SharePoint Foundations server.

Step 1.
Install Microsoft Windows Server 2008, Standard or Enterprise Edition.
Step 2.
Install Windows Server 2008 Service Pack 2. When prompted, restart the computer and log on as GLOBAL\Administrator.
Step 3.
Choose Start→Control Panel→Network and Sharing Center.
Step 4.
In the Tasks section, click the Manage network connection link.
Step 5.
Right-click Local Area Connection and choose Properties.
Step 6.
Select Internet Protocol Version 4 (TCP/IPv4).
Step 7.
Click Properties.
Step 8.
Select the Use the following IP address radio button.
Step 9.
Enter the following in the respective text boxes.
  • IP Address: 192.168.1.201
  • Subnet Mask: 255.255.255.0
  • Default Gateway: 192.168.1.200
  • Preferred DNS Server: 192.168.1.200
Step 10.
Click OK.
Step 11.
Click Close.
Step 12.
Close the window.
Step 13.
Right-click My Computer and choose Properties.
Step 14.
In the Computer name, domain and workgroup settings section, click the change settings link.
Step 15.
In the System Properties dialog box, click Change.
Step 16.
In the Computer Name / Domain Changes dialog box, in the Computer Name text box, type OGC
Step 17.
Click More.
Step 18.
In the Primary DNS suffix of this computer text box, type ourglobalcompany.com and click OK.
Step 19.
In the Computer Name / Domain Changes dialog box, in the Member of section, select the Domain radio button and, in the text box, type ourglobalcompany.com
Step 20.
Click OK.
Step 21.
In the Windows Security dialog box, type the username as GLOBAL\Administrator and the password as !Pass1234
Step 22.
Click OK.
Step 23.
In the Computer Name / Domain Changes message box, click OK.
Step 24.
In the Computer Name / Domain Changes message box, click OK.
Step 25.
Close all the windows.
Step 26.
In the Microsoft Windows message box, click Restart Now.

Install SQL Server 2008 on Windows Server 2008

Follow these steps to install SQL Server 2008 on Windows Server 2008.

Step 1.
Insert the SQL Server installation CD.
Step 2.
In the SQL Server Installation Center wizard, click the Installation link.
Step 3.
Click the New SQL Server stand-alone installation or add features to an existing installation link.
Step 4.
In the Setup Support Rules page, click OK.
Step 5.
In the Product key page, select the Enter the product key radio button and enter the product key.
Step 6.
Click Next.
Step 7.
In the Setup Support files page, click Install.
Step 8.
In the Setup Support Rules page, click Next.
Step 9.
In the Feature Selection page, in the Features Section, select the following options.
  • Database Engine Services
  • SQL Server Replication
  • Full Text Search
  • Analysis Services
  • Business Intelligence Development Studio
  • Clients Tools Connectivity
  • Integration Services
  • Client Tools Backward Compatibility
  • Client Tools SDK
  • Management Tools — Basic Management Tools — Complete
  • SQL Client Connectivity SDK
  • Microsoft Sync Framework
Step 10.
In the Instance Configuration page, verify whether the Default instance radio button is selected and click Next.
Step 11.
In the Instance Configuration page, verify whether the Default instance radio button is selected and click Next.
Step 12.
In the Disk Space Requirements page, click Next.
Step 13.
In the Server Configuration page, in the Service Accounts tab, in the SQL Server Agent row, in the Account Name column, from the drop-down list, select <<Browse>>.
Step 14.
In the Select User, Computer or Group dialog box, click Advanced.
Step 15.
In the Windows Security message box, type the username as GLOBAL\Administrator and password as !Pass1234and click OK.
Step 16.
In the Select User, Computer or Group dialog box, click Find Now.
Step 17.
From the search results, select Administrator and click OK.
Step 18.
Click OK.
Step 19.
In the Server Configuration page, in the Password column, type the domain administrator password.
Step 20.
In the SQL Server Database Engine row, in the Account Name column, select Global\Administrator and type the domain administrator password.
Step 21.
In the SQL Server Analysis Service row, in the Account Name column, select Global\Administrator and type the domain administrator password.
Step 22.
In the SQL Server Integration Services 10.0 row, in the Account Name column, select Global\Administrator and type the domain administrator password.
Step 23.
Click Next.
Step 24.
In the Database Engine Configuration page, in the Authentication Mode section, select the Mixed Mode radio button.
Step 25.
Enter and confirm the domain password.
Step 26.
Click Add.
Step 27.
In the Select User, Computer or Group dialog box, click Advanced.
Step 28.
In the Windows Security message box, type the domain administrator username and password and click OK.
Step 29.
In the Select User, Computer or Group dialog box, click Find Now.
Step 30.
From the search results, select Administrator and click OK.
Step 31.
Click OK.
Step 32.
Click Next.
Step 33.
In the Analysis Service Configuration page, click Add.
Step 34.
In the Select User, Computer or Group dialog box, click Advanced.
Step 35.
In the Windows Security message box, type the domain administrator username and password and click OK.
Step 36.
In the Select User, Computer or Group dialog box, click Find Now.
Step 37.
From the search results, select Administrator and click OK.
Step 38.
Click OK.
Step 39.
Click Next.
Step 40.
In the Error and Usage Reporting page, click Next.
Step 41.
In the Installation Rules page, click Next.
Step 42.
In the Ready to Install page, click Install.
Step 43.
In the Installation Progress page, click Next.
Step 44.
In the Complete page, click Close.
Step 45.
Close the SQL Server Installation Center window.

Install SQL Server SP1 and Cumulative Update 2

Step 1.
Download and install Microsoft SQL Server Compact 3.5 SP1 (Service Pack 1) (32 bit or 64 bit).
Step 2.
Download and install Cumulative Update 2 for SQL Server 2008 Service Pack 1 (32 bit or 64 bit).

Install Microsoft® Windows® SharePoint® Foundation 2010 on Windows Server 2008

Follow these steps to install Microsoft® Windows® SharePoint® Foundation 2010 on Windows Server 2008.

Step 1.
Download the Microsoft SharePoint Foundation 2010 setup file to Microsoft Windows SharePoint Foundation.
Step 2.
Run the SharePoint Foundation 2010 setup file.
Step 3.
On the Microsoft SharePoint Foundation 2010 Start page, under Install, click the Install Software Prerequisites hyperlink.
Step 4.
On the Welcome to the Microsoft SharePoint Foundation 2010 Products Preparation Tool page, click Next.
Step 5.
The Microsoft SharePoint Products Preparation Tool installs the following prerequisites:
  • Windows Server 2008 Service Pack 2
  • Web Server (IIS) role
  • Application Server role
  • Microsoft .NET Framework version 3.5 SP1
  • Microsoft Sync Framework Runtime v1.0 (x64)
  • Microsoft Filter Pack 2.0
  • Microsoft Chart Controls for the Microsoft .NET Framework 3.5
  • SQL 2008 R2 Reporting Services
  • SharePoint 2010 Add-in
  • Windows PowerShell 2.0
  • SQL Server 2008 Native Client
  • Microsoft SQL Server 2008 Analysis Services ADOMD.NET
  • ADO.NET Data Services Update for .NET Framework 3.5 SP1
  • A hotfix for the .NET Framework 3.5 SP1 that provides a method to support token authentication without transport security or message encryption in WCF.
  • Windows Identity Foundation (WIF)
  • Hot fix for Microsoft Windows (KB976394)
Step 6.
On the License terms for software products page, check the I accept the terms of the License Agreement(s) check box and click Continue.
Step 7.
On the Installation Complete page, click Finish.
Step 8.
Run the SharePoint Foundation 2010 setup file.
Step 9.
On the Microsoft SharePoint Foundation 2010 page, under Install, click the Install SharePoint Foundation hyperlink.
Step 10.
On the Read the Microsoft Software License terms page, check the I agree the terms of the agreement check box and click Continue.
Step 11.
In the choose the installation you want page, click Server Farm.
Step 12.
In the Select the type of installation you want to install on the server section, select the Complete - Install all components. Can add servers to form a SharePoint farm option and click Install Now.
Step 13.
In the Run Configuration Wizard page, click Close.
Step 14.
In the Welcome to SharePoint Products page, click Next.
Step 15.
In the SharePoint Products Configuration Wizard message box, click Yes.
Step 16.
In the Connect to a server from page, select the Create a new server farm option and click Next.
Step 17.
In the Specify Configuration Database Settings page, in the Database server text box, type OGC
Step 18.
In the Database name text box, type SharePoint_Config
Step 19.
In the Specify Database Access Account section, in the Username text box, type global\administrator
Step 20.
In the Password text box, type the administrator password and click Next.
Step 21.
In the Specify Farm Settings page, in the Pass phrase text box, type the desired password.
Step 22.
In the Confirm pass phrase text box, retype the password.
Step 23.
In the Configure SharePoint Central Administration Web Application page, verify that NTLM is selected and click Next.
Step 24.
Check the Specify port number check box and type 9001
Step 25.
In the Completing the SharePoint Products Configuration Wizard, click Next.
Step 26.
In the Configuration Successful page, click Finish.

Create the BCS Service in Microsoft® Windows® SharePoint® Foundation 2010

Step 1.
Choose Start→All Programs→Microsoft SharePoint 2010 Products→SharePoint 2010 Central Administration.
Step 2.
In the Central Administration page, in the Application Management section, click Manage service applications.
Step 3.
On the Service Applications tab, in the Create group, click the New drop-down list and choose Business Data Connectivity Service.
Step 4.
In the Create New Business Data Connectivity Service Application page, in the Service Application Name text box, type Business Data Connectivity Services
Step 5.
In the Database Server text box, verify that the server name is OGC.
Step 6.
In the Database authentication section, verify that the Windows authentication option is selected.
Step 7.
In the Application Pool section, in the Application pool name text box, type APP and click OK.
Step 8.
Click OK.

Configure the SharePoint Farm

To configure the SharePoint Farm:

Step 1.
In the left pane, click the Configuration Wizards link.
Step 2.
In the Farm Configuration page, click the Launch the Farm Configuration Wizard link.
Step 3.
In the Help Make SharePoint Better page, select the No, I dont wish to participate option and click OK.
Step 4.
In the How do you want to configure your SharePoint farm page, click Start the Wizard.
Step 5.
In the Service Account section, select the Use existing managed account option and click Next.
Step 6.
In the Title text box, type OGC and click OK.
Step 7.
Click Finish.

Start the Business Data Connectivity Service

To start the Business Data Connectivity service:

Step 1.
In the Central Administration page, click the Manage services on server link.
Step 2.
In the Services on Server page, next to the Business Data Connectivity Service, click the Start link.

Delete the Existing Site

To delete the existing site:

Step 1.
In the Central Administration page, click the Manage web applications link.
Step 2.
On the Web Application tab, select SharePoint - 80 and, in the Contribute group, click the Delete drop-down list and choose Delete Web Application.
Step 3.
In the Delete Web Application page, in the Delete content databases section, select the Yes option.
Step 4.
In the Delete IIS web sites section, select the Yes option.
Step 5.
In the Windows Internet Explorer message box, click Yes.

Create a Web Application and Site Collection for the Instructor

To create a web application and site collection for the instructor:

Step 1.
Choose Start→All Programs→Microsoft SharePoint 2010 Products→SharePoint 2010 Central Administration.
Step 2.
In the Application Management section, click Manage Web Applications.
Step 3.
To create a new web application, in the Web Applications tab, in the Contribute group, click New.
Step 4.
In the Create New Web Application page, in the IIS Web Site section, in the Name text box, select the existing text and type OGC
Step 5.
In the Application Pool section, in the Select a security account for this application pool section, select the Predefined radio button.
Step 6.
Click OK.
Step 7.
In the Application Created message box, click the Create Site Collection link.
Step 8.
In the Title text box, type Our Global Company
Step 9.
In the Primary Site Collection Administrator section, next to the User name text box, click Browse.
Step 10.
In the Select People dialog box, in the Find text box, type Administrator and click Search.
Step 11.
Select Global\administrator and click OK.
Step 12.
In the Secondary Site Collection Administrator section, next to the User name text box, click Browse.
Step 13.
In the Select People dialog box, in the Find text box, type central and click Search.
Step 14.
Select Global\central and click OK.
Step 15.
In the Create Site Collection page, click OK.
Step 16.
In the Top Level Site Successfully Created message box, click OK.
Student Note: Link to Top Level Site In the Top Level Site Successfully Created message box, observe that the URL to the top level site appears. Make a note of the URL to the top level site that appears in the message box. This URL will be needed in the course activities to access the site.

Create a Web Application and Site Collection for Each Student

To create a web application and site collection for each student:

Step 1.
In the SharePoint 2010 Central Administration page, in the Application Management section, click Manage Web Applications.
Step 2.
To create a new web application, in the Web Applications tab, in the Contribute group, click New.
Step 3.
In the Create New Web Application page, in the IIS Web Site section, in the Name text box, select the existing text and type OGC1
Student Note: Web Application NameThe web application name should be unique for each student. While creating individual web applications for the students, use the web application names ogc1 to ogc12 (or as many as required).
Step 4.
In the Application Pool section, in the Select a security account for this application pool section, verify whether the Configurable option is selected and in the drop-down list, GLOBAL\administrator is selected.
Step 5.
Click OK.
Step 6.
In the Application Created message box, click the Create Site Collection link.
Step 7.
In the Title text box, type Our Global Company
Step 8.
In the Primary Site Collection Administrator section, next to the User name text box, click Browse.
Step 9.
In the Select People dialog box, in the Find text box, type Administrator and click Search.
Step 10.
Select Global\administrator and click OK.
Step 11.
In the Secondary Site Collection Administrator section, next to the User name text box, click Browse.
Step 12.
In the Select People dialog box, in the Find text box, type user01 and click Search.
Step 13.
Select Global\user01 and click OK.
Step 14.
In the Create Site Collection page, click OK.
Step 15.
In the Top Level Site Successfully Created message box, click OK.
Student Note: Link to Top Level Site In the Top Level Site Successfully Created message box, observe that the URL to the top level site appears. Make a note of the URL to the top level site that appears in the message box. This URL will be needed in the course activities to access the site. These URL's should be provided to each student.
Step 16.
Follow steps 1–16 to create as many individual web applications and site collections as there are students in class.

Create the Report Database in SQL Server 2008

To create a database in SQL Server 2008:

Step 1.
Choose Start→All Programs→Microsoft SQL Server 2008→SQL Server Management Studio.
Step 2.
In the Connect to Server dialog box, in the Server type drop-down list, verify that Database Engine is selected.
Step 3.
From the Server name drop-down list, select OGC.
Step 4.
Verify that in the Authentication drop-down list, Windows Authentication is selected and click Connect.
Step 5.
In the Microsoft SQL Server Management Studio window, in the left object explorer pane, right-click on Databases and choose New Database.
Step 6.
In the New Database dialog box, in the Database name, type Report and click OK.
Step 7.
Expand Databases and then expand Report.
Step 8.
Right-click on Tables and choose New Table.
Step 9.
In the Column Name column, in the first row, click and type Date_Entering
Step 10.
In the Data Type column, from the drop-down list, select date.
Step 11.
In the Column Name column, in the second row, click and type Emp_ID
Step 12.
In the Data Type column, from the drop-down list, select nchar(10).
Step 13.
In the Column Name column, in the third row, click and type Emp_Name
Step 14.
In the Data Type column, from the drop-down list, select nvarchar(50).
Step 15.
In the Column Name column, in the fourth row, click and type Dept
Step 16.
In the Data Type column, from the drop-down list, select nvarchar(50).
Step 17.
In the Column Name column, in the fifth row, click and type Hours_Worked
Step 18.
In the Data Type column, from the drop-down list, select numeri(18,0).
Step 19.
Choose File→Save Table_1.
Step 20.
In the Choose Name dialog box, in the Enter a name for the table text box, type Employee details and click OK.
Step 21.
In the object explorer pane, expand Tables, right-click on dbo.Employee details and choose Script table as→Insert To→New Query Editor Window.
Step 22.
In the Query Editor Window, delete the existing text.
Step 23.
Enter the following code:
insert into [Report].[dbo].[Employee details](Date_Entering,Emp_ID,Emp_Name,Dept,Hours_Worked) 
values ('11/15/2010','A21','Jeff','ITS.',7)
insert into [Report].[dbo].[Employee details](Date_Entering,Emp_ID,Emp_Name,Dept,Hours_Worked) 
values ('11/15/2010','A22','Mark','Marketting',6)
insert into [Report].[dbo].[Employee details](Date_Entering,Emp_ID,Emp_Name,Dept,Hours_Worked) 
values ('11/15/2010','A23','Henry','Marketing',5)
insert into [Report].[dbo].[Employee details](Date_Entering,Emp_ID,Emp_Name,Dept,Hours_Worked) 
values ('11/15/2010','A24','Harry','Marketing',8)
insert into [Report].[dbo].[Employee details](Date_Entering,Emp_ID,Emp_Name,Dept,Hours_Worked) 
values ('11/16/2010','B23','Robert','Sales',8)
insert into [Report].[dbo].[Employee details](Date_Entering,Emp_ID,Emp_Name,Dept,Hours_Worked) 
values ('11/16/2010','B34','Tim','Sales',8)
insert into [Report].[dbo].[Employee details](Date_Entering,Emp_ID,Emp_Name,Dept,Hours_Worked) 
values ('11/16/2010','B45','Tom ','Sales',8)
insert into [Report].[dbo].[Employee details](Date_Entering,Emp_ID,Emp_Name,Dept,Hours_Worked) 
values ('11/16/2010','C32','John','ITS',6)
insert into [Report].[dbo].[Employee details](Date_Entering,Emp_ID,Emp_Name,Dept,Hours_Worked) 
values ('11/16/2010','C34','Cathy','ITS',5)
insert into [Report].[dbo].[Employee details](Date_Entering,Emp_ID,Emp_Name,Dept,Hours_Worked) 
values ('11/16/2010','C45','Chris','ITS',7)
insert into [Report].[dbo].[Employee details](Date_Entering,Emp_ID,Emp_Name,Dept,Hours_Worked) 
values ('11/16/2010','D34','Mike','ITS',8)
Step 24.
At the end of the Query, type GO
Step 25.
On the toolbar, click Execute.
Step 26.
Observe that 10 rows are inserted.

Create the ITS Data Database in SQL Server 2008

To create a database in SQL Server 2008:

Student Note: This database is used for the lesson labs in this course.
Step 1.
Choose Start→All Programs→Microsoft SQL Server 2008→SQL Server Management Studio.
Step 2.
In the Connect to Server dialog box, in the Server type drop-down list, verify that Database Engine is selected.
Step 3.
From the Server name drop-down list, select OGC.
Step 4.
Verify that in the Authentication drop-down list, Windows Authentication is selected and click Connect.
Step 5.
In the Microsoft SQL Server Management Studio window, in the left object explorer pane, right-click on Databases and choose New Database.
Step 6.
In the New Database dialog box, in the Database name, type ITS Data and click OK.
Step 7.
Expand Databases and then expand ITS Data.
Step 8.
Right-click on Tables and choose New Table.
Step 9.
In the Column Name column, in the first row, click and type Date
Step 10.
In the Data Type column, from the drop-down list, select date.
Step 11.
In the Column Name column, in the second row, click and type Request_Type
Step 12.
In the Data Type column, from the drop-down list, select nvarchar(50).
Step 13.
In the Column Name column, in the third row, click and type Description
Step 14.
In the Data Type column, from the drop-down list, select nvarchar(50).
Step 15.
In the Column Name column, in the fourth row, click and type Ticket_No
Step 16.
In the Data Type column, from the drop-down list, select nvarchar(50).
Step 17.
In the Column Name column, in the fifth row, click and type Status
Step 18.
In the Data Type column, from the drop-down list, select nvarchar(50)
Step 19.
Choose File→Save Table_1.
Step 20.
In the Choose Name dialog box, in the Enter a name for the table text box, type ITS_Request_Repository and click OK.
Step 21.
In the object explorer pane, expand Tables, right-click on dbo.ITS_Request_Repository and choose Script table as→Insert To→New Query Editor Window.
Step 22.
In the Query Editor Window, delete the existing text.
Step 23.
Enter the following code:
insert into [ITS Data].[dbo].[ITS_Request_Repository](Date,Request_Type,Description,Ticket_No,Status) 
values ('11/15/2010','Hardware','RAM upgrade','ITS111507','Pending')
insert into [ITS Data].[dbo].[ITS_Request_Repository](Date,Request_Type,Description,Ticket_No,Status) 
values ('11/15/2010','Hardware','Mouse not working','ITS111508.','Completed')
insert into [ITS Data].[dbo].[ITS_Request_Repository](Date,Request_Type,Description,Ticket_No,Status) 
values ('11/15/2010','Software','Flash Insallation','ITS111509.','Completed')
insert into [ITS Data].[dbo].[ITS_Request_Repository](Date,Request_Type,Description,Ticket_No,Status) 
values ('11/15/2010','Hardware','Mouse not working','ITS111511.','Completed')
insert into [ITS Data].[dbo].[ITS_Request_Repository](Date,Request_Type,Description,Ticket_No,Status) 
values ('11/17/2010','Software','Antivirus Insallation','ITS111514.','Completed')
insert into [ITS Data].[dbo].[ITS_Request_Repository](Date,Request_Type,Description,Ticket_No,Status) 
values ('11/16/2010','Hardware','Monitor not working','ITS111515.','Pending')
insert into [ITS Data].[dbo].[ITS_Request_Repository](Date,Request_Type,Description,Ticket_No,Status) 
values ('11/19/2010','Hardware','Keyboard not working ','ITS111516.','Pending')
insert into [ITS Data].[dbo].[ITS_Request_Repository](Date,Request_Type,Description,Ticket_No,Status) 
values ('11/21/2010','Software','OS Reinsallation','ITS111518.','Completed')
insert into [ITS Data].[dbo].[ITS_Request_Repository](Date,Request_Type,Description,Ticket_No,Status) 
values ('11/22/2010','Software','Antivirus Installation','ITS111519.','Completed')
insert into [ITS Data].[dbo].[ITS_Request_Repository](Date,Request_Type,Description,Ticket_No,Status) 
values ('11/24/2010','Hardware','RAM upgrade','ITS111520.','Pending')
insert into [ITS Data].[dbo].[ITS_Request_Repository](Date,Request_Type,Description,Ticket_No,Status) 
values ('11/25/2010','Hardware','Mouse not working','ITS111521.','Completed')
Step 24.
At the end of the Query, type GO
Step 25.
On the toolbar, click Execute.
Step 26.
Observe that 10 rows are inserted.

Create the Training Schedule Database in SQL Server 2008

Step 1.
In the Microsoft SQL Server Management Studio window, in the left object explorer pane, right-click on Databases and choose New Database.
Step 2.
In the New Database dialog box, in the Database name, type Training Schedule and click OK.
Step 3.
Expand Databases and then expand Training Schedule.
Step 4.
Right-click on Tables and choose New Table.
Step 5.
In the Column Name column, in the first row, click and type Employee name
Step 6.
In the Data Type column, from the drop-down list, select text.
Step 7.
In the Column Name column, in the second row, click and type Employee ID
Step 8.
In the Data Type column, from the drop-down list, select numeri(18,0).
Step 9.
In the Column Name column, in the third row, click and type Job Title
Step 10.
In the Data Type column, from the drop-down list, select text.
Step 11.
In the Column Name column, in the fourth row, click and type Department
Step 12.
In the Data Type column, from the drop-down list, select text.
Step 13.
In the Column Name column, in the fifth row, click and type Training
Step 14.
In the Data Type column, from the drop-down list, select text.
Step 15.
Choose File→Save Table_1.
Step 16.
In the Choose Name dialog box, in the Enter a name for the table text box, type employee info and click OK.

Set Up the Instructor and Student Computers

Follow these steps to set up and configure the instructor and student computers:

Step 1.
Install Windows XP Professional with the following settings.
  • Computer Name:
    • Students: computer01 through computer12 (or more as required).
    • Instructor: central
  • Administrator Password: !Pass1234
  • Domain: ourglobalcompany.com
  • IP Address:
    • Students: 192.168.1.1 through 192.168.1.12 (or as required)
    • Instructor: 192.168.1.101
  • Subnet Mask: 255.255.255.0
  • Default Gateway: 192.168.1.200
  • Preferred DNS Server: 192.168.1.200
Step 2.
Install Windows XP Service Pack 2.
Step 3.
Assign the user as Administrator to the local machine.
  • Open the Computer Management console.
  • Expand Local Users And Groups.
  • Click Groups.
  • Double-click Administrators.
  • Click Add.
  • Click Advanced.
  • Click Find Now.
  • Select the user name for the computer.
  • Click OK three times.
  • Close the Computer Management console.
Step 4.
Install and activate Microsoft Office 2010 Professional or Professional Plus.
Step 5.
Install and activate Microsoft Windows® SharePoint Designer 2010.
Step 6.
Install Microsoft .NET Framework 3.5 SP1 (Service Pack 1).
Step 7.
On the course CD-ROM, run the 084700dd.exe self-extracting file located within. This will install a folder named 084700Data on your C drive. This folder contains all the setup and data files that you will use to complete this course.