Module 2: Getting Started with SQL Server 2005 & Installing SQL Server- 1 Day (6 hours) |
Components
- Services
- Editions
- System and user database
Essential Tools
- SQL Server Management Studio
- Transact-SQL
- Surface Area Configuration
- SQL Server Configuration Manager
SQL Server 2005 Installation
- Choosing installation options
- Employing multiple instances
- Upgrading from previous version
- Applying a Service Pack
Practice Test
- Interview Questions and answer discussion
- Written Test
- Oral presentation Test
|
Module 3: Managing Database - 1 Day (6 hours) |
Disk Structures
- Examining storage structures
- Creating database and transaction logs
Space Management Strategies
- Handling dynamic database growth
- Reclaiming unused space
Moving Database
- Delaching and attaching databases
- Copying databases with the Copy Database Wizard
Practice Exam
- Interview questions and answers discussion
- Written test
- Oral presentation test
|
Module 4: Controlling Server & Database Security- 1 Day (6 hours) |
Login Security
- Contrasting Windows and SQL Server authentications
- Authorizing logins
- Making logins members of server roles
- Enforcing password policy
Database Security
- Designing schemas
- Adding users
- Defining NEW roles
- Delegating privileges with pre-defined roles
- Assigning users to roles
Permissions
- Granting server, database, schema-scoped and object permissions
- Interaction of roles and permissions
Wrap up and Closure
- Interview questions and answers discussion
- Written test
- Oral presentation test
|
|
|
SQL Server Integration Services
- Packages
- Control flows
- Data flows
- Connections
- Business Intelligence Development Studio
Building simple packages
- Importing data from Access
- Exporting a table to Excel
Practice Exam
- Interview questions and answers discussion
- Written test
- Oral presentation test
|
