| |
.................................................................................................................................................................................................................... |
|
| |
COURSE CONTENT |
|
| |
SQL SERVER 2008 INSTALLATION AND FEATURES
INSTALLING SQL SERVER |
| |
|
|
|
| |
...................................................................................................................................................................................................................... |
| |
- Choosing installation options
- Upgrading from previous versions
- Employing multiple instances
|
| |
.................................................................................................................................................................................................................... |
| |
ESSENTIAL TOOLS |
| |
.................................................................................................................................................................................................................... |
| |
- SQL Server Management Studio
- Transact-SQL
- Intellisense
- SQL Server Configuration Manager
- SQLCMD
- PowerShell
- Books Online
|
| |
.................................................................................................................................................................................................................... |
| |
CREATING AND MANAGING DATABASES
STORAGE STRUCTURES |
| |
.................................................................................................................................................................................................................... |
| |
- Examining disk structures
- Creating databases and transaction logs
- Defining file groups
- Controlling file placement
- Shrinking databases
|
| |
.................................................................................................................................................................................................................... |
| |
MANAGING DATABASE SPACE |
| |
.................................................................................................................................................................................................................... |
| |
- Permitting automatic database growth
- Expanding databases by adding files
- Specifying database options
|
| |
.................................................................................................................................................................................................................... |
| |
MOVING DATABASES |
| |
................................................................................................................................................................................................................... |
| |
- Scripting objects and moving data with Transact-SQL
- Migrating data with Transact-SQL
- Detaching and attaching databases
|
| |
.................................................................................................................................................................................................................... |
| |
IMPLEMENTING SERVER AND DATABASE SECURITY
CREATING LOGINS |
| |
..................................................................................................................................................................................................................... |
| |
- Contrasting Windows and SQL Server authentication
- Allowing server access
- Investigating fixed server roles
- Making logins members of server roles
- Enforcing password policy
|
| |
..................................................................................................................................................................................................................... |
| |
AUTHORIZING DATABASE ACCESS |
| |
.................................................................................................................................................................................................................... |
| |
- Adding users
- Delegating privileges with pre-defined roles
- Defining new roles
- Assigning users to roles
- Handling mismapped logins
|
| |
.................................................................................................................................................................................................................... |
| |
MANAGING PERMISSIONS
GRANTING DATABASE-SCOPED PRIVILEGES |
| |
.................................................................................................................................................................................................................... |
| |
- Permitting object creation
- Granting blanket permissions
|
| |
..................................................................................................................................................................................................................... |
| |
SCHEMAS |
| |
...................................................................................................................................................................................................................... |
| |
- Designing schemas
- Assigning a default schema
|
| |
..................................................................................................................................................................................................................... |
| |
HANDLING OBJECT-LEVEL PERMISSIONS |
| |
.................................................................................................................................................................................................................... |
| |
- Limiting object access
- Meeting complex permission requirements with roles
- Examining permission hierarchies
|
| |
.................................................................................................................................................................................................................... |
| |
RECOVERING FROM DISASTERS
SQL SERVER BACKUP FUNDAMENTALS |
| |
.................................................................................................................................................................................................................... |
| |
- Selecting a recovery model
- Studying available backup types
- Exploring transaction log architecture
- Reclaiming transaction log space
- Managing backup file retention
|
| |
.................................................................................................................................................................................................................... |
| |
BACKING UP DATABASES |
| |
..................................................................................................................................................................................................................... |
| |
- Performing full, log and differential backups
- Making file group backups
- Backing up system databases
|
| |
..................................................................................................................................................................................................................... |
| |
RESTORING DATABASES |
| |
..................................................................................................................................................................................................................... |
| |
- Recovering user databases
- Restoring a damaged master database
- Performing a piecemeal restore
- Diagnosing the problem
|
| |
..................................................................................................................................................................................................................... |
| |
MIGRATING DATA
SQL SERVER INTEGRATION SERVICES |
| |
..................................................................................................................................................................................................................... |
| |
- Packages
- Control flows
- Connections
- Data flows
- Business Intelligence Development Studio
- Solutions
- Projects
|
| |
..................................................................................................................................................................................................................... |
| |
BUILDING SIMPLE PACKAGES |
| |
.................................................................................................................................................................................................................... |
| |
- Importing data from various data sources
- Exporting data to different data stores
- Opening Integration Services connections
- Storing SSIS packages in msdb
|
| |
.................................................................................................................................................................................................................... |
|
