SQL Server 2008 Database Administration
SQL
Training
Provided by Microsys Technologies and Solutions Pvt. Ltd.,
You Will Learn How To
Administer SQL Server 2008 with SQL Server Management Studio and Transact-
SQL
Build databases and upgrade from prior versions
Secure the server through logins and database permissions management
Implement backup and recovery strategies and manage transaction logs
Automate administrative activities with SQL Server Agent multistep jobs
Perform routine maintenance to correct fragmentation and database corruption
Course Benefits
SQL Server 2008 provides a robust platform that enables organizations to run their most demanding, mission-critical applications. It is essential that database administrators know how to manage this complex platform correctly. This hands-on course provides you with the knowledge and skills you need to install SQL Server, create and modify storage structures, manage security and back up and recover databases.
Related Software Programs or Products: Microsoft SQL Server 2008
|
|
||||||||||
SQL Server 2008 Database Administration
SQL Server 2008 Database Administration
Duration: 4 Days
You Will Learn How To
Administer SQL Server 2008 with SQL Server Management Studio and Transact-
SQL
Build databases and upgrade from prior versions
Secure the server through logins and database permissions management
Implement backup and recovery strategies and manage transaction logs
Automate administrative activities with SQL Server Agent multistep jobs
Perform routine maintenance to correct fragmentation and database corruption
Course Benefits
SQL Server 2008 provides a robust platform that enables organizations to run their most demanding, mission-critical applications. It is essential that database administrators know how to manage this complex platform correctly. This hands-on course provides you with the knowledge and skills you need to install SQL Server, create and modify storage structures, manage security and back up and recover databases.
Who Should Attend
Experienced SQL Server 2005 administrators
Throughout this course, a series of extensive hands-on exercises provides you with practical experience administering SQL Server 2008. Exercises include:
Administering SQL Server 2008 with graphical tools and Transact-SQL
Creating databases
Implementing security for logins, databases and objects
Importing and exporting data
Backing up and restoring databases
Configuring Database Mail
Carrying out routine database maintenance
Monitoring server health
Course Content
Day 1
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
SQL Server Configuration Manager
Configuration Servers
Policy-Based Management Framework
Creating and Managing Databases
Storage structures
Examining disk structures
Creating databases and transaction logs
Managing database space
Permitting automatic database growth
Adding database files to expand databases
Specifying database options
Moving databases
Scripting objects and moving data with Transact-SQL
Detaching and attaching databases
Copying databases with the Copy Database Wizard
Day 2
Implementing Server and Database Security
Creating logins
Contrasting Windows and SQL Server authentications
Authorizing logins
Making logins members of server roles
Enforcing password policy
Authorizing database access
Designing schemas
Adding users
Defining new roles
Delegating privileges with pre-defined roles
Assigning users to roles
Handling mismapped logins
Granting permissions
Allowing server, database, schema and object access
Interaction of roles and permissions
Securing Common Language Runtime (CLR) objects
Overcoming broken ownership chains
Recovering from Disasters
Backing up databases
Choosing a recovery model
Transaction log architecture
Performing full, log and differential backups
Reclaiming transaction log space
Restoring databases
Recovering user databases
Testing recovery scenarios
Day 3
Automating Tasks with Jobs and Alerts
The SQL Server Agent
Configuring the Agent
Setting up Database Mail
Multistep jobs
Defining jobs to handle routine tasks
Creating alerts and operators
Associating alerts with jobs
Performing Database Maintenance
Fragmentation and database corruption
Identifying and curing fragmentation
Finding and repairing database corruption
Database Maintenance Plan Wizard
Choosing maintenance tasks
Scheduling plan execution
Day 4
Monitoring SQL Server
Ad hoc monitoring
Identifying problems with Activity Monitor
Querying Dynamic Management Objects
Checking server status with Performance Studio
Introducing the Resource Governor
Identifying priority workloads
Balancing diverse workloads
Duration: 4 Days
You Will Learn How To
Administer SQL Server 2008 with SQL Server Management Studio and Transact-
SQL
Build databases and upgrade from prior versions
Secure the server through logins and database permissions management
Implement backup and recovery strategies and manage transaction logs
Automate administrative activities with SQL Server Agent multistep jobs
Perform routine maintenance to correct fragmentation and database corruption
Course Benefits
SQL Server 2008 provides a robust platform that enables organizations to run their most demanding, mission-critical applications. It is essential that database administrators know how to manage this complex platform correctly. This hands-on course provides you with the knowledge and skills you need to install SQL Server, create and modify storage structures, manage security and back up and recover databases.
Who Should Attend
Experienced SQL Server 2005 administrators
Throughout this course, a series of extensive hands-on exercises provides you with practical experience administering SQL Server 2008. Exercises include:
Administering SQL Server 2008 with graphical tools and Transact-SQL
Creating databases
Implementing security for logins, databases and objects
Importing and exporting data
Backing up and restoring databases
Configuring Database Mail
Carrying out routine database maintenance
Monitoring server health
Course Content
Day 1
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
SQL Server Configuration Manager
Configuration Servers
Policy-Based Management Framework
Creating and Managing Databases
Storage structures
Examining disk structures
Creating databases and transaction logs
Managing database space
Permitting automatic database growth
Adding database files to expand databases
Specifying database options
Moving databases
Scripting objects and moving data with Transact-SQL
Detaching and attaching databases
Copying databases with the Copy Database Wizard
Day 2
Implementing Server and Database Security
Creating logins
Contrasting Windows and SQL Server authentications
Authorizing logins
Making logins members of server roles
Enforcing password policy
Authorizing database access
Designing schemas
Adding users
Defining new roles
Delegating privileges with pre-defined roles
Assigning users to roles
Handling mismapped logins
Granting permissions
Allowing server, database, schema and object access
Interaction of roles and permissions
Securing Common Language Runtime (CLR) objects
Overcoming broken ownership chains
Recovering from Disasters
Backing up databases
Choosing a recovery model
Transaction log architecture
Performing full, log and differential backups
Reclaiming transaction log space
Restoring databases
Recovering user databases
Testing recovery scenarios
Day 3
Automating Tasks with Jobs and Alerts
The SQL Server Agent
Configuring the Agent
Setting up Database Mail
Multistep jobs
Defining jobs to handle routine tasks
Creating alerts and operators
Associating alerts with jobs
Performing Database Maintenance
Fragmentation and database corruption
Identifying and curing fragmentation
Finding and repairing database corruption
Database Maintenance Plan Wizard
Choosing maintenance tasks
Scheduling plan execution
Day 4
Monitoring SQL Server
Ad hoc monitoring
Identifying problems with Activity Monitor
Querying Dynamic Management Objects
Checking server status with Performance Studio
Introducing the Resource Governor
Identifying priority workloads
Balancing diverse workloads
About The Training Provider: Microsys Technologies and Solutions Pvt. Ltd.,
Microsys Technologies and Solutions Pvt. Ltd., - Microsys Technologies & Solutions Pvt. Ltd is a proactive organization headquartered in Pune with its branches across Mumbai & Bangalore. In the last few years of our existence we have successfully offered value propositions to our clientele across the country and overseas.
Customized Software Development
Corporate Training & IT Education
leadership and management skill programs
...
