|
Configuring SQL Server 2005
(Duration: 3:00:00)
Price: $38.00
Course Code:
234633_eng
Course Catalog(s):
Course Provider:
SkillSoft
12 months
Description:
To configure a SQL Server instance and create a database, configure logins, users, and schemas for a database, and set up a linked server configuration
Sections:
- • SQL Server Configuration
- - use SQL Server Surface Area Configuration to configure a SQL Server 2005 installation.
- • Creating SQL Server Databases
- - create a SQL Server database in a given scenario.
- • Creating a Database in SQL Server 2005
- - create a database in SQL Server 2005.
- • Securing Database Resources
- - recognize the security functionality of the SQL Server 2005 Database Engine.
- • Creating Logins and Granting Permissions
- - create logins and grant permissions in a given scenario.
- • Creating Logins, Users, and Schemas
- - create logins, users, and schemas in SQL Server 2005.
- • Additional Security Considerations
- - recognize the security mechanisms provided by encryption, the TRUSTWORTHY database property, and execution context in SQL Server 2005.
- • Using a Linked Server Configuration
- - recognize how SQL Server 2005 can access data from OLE DB data sources on remote servers using a linked server configuration.
- • Linked Server Configuration Options
- - use SQL Server Management Studio to configure a linked server in a given scenario.
- • Configuring a Linked Server
- - configure a linked server using SQL Server Management Studio.
|