Microsoft SQL Server 20052008
MS SQL Server
Training
Provided by Microcomputing Solutions ltd
The topics covered are as follows:
1 Introduction
a Versions of SQL Server 2005
a Hardware Requirements
a Software Requirements
a SQL Server Components
a Licensing Modes
2 Installing SQL Server
a Pre-installation Planning
a Setting up the Service Accounts
a Authentication Modes
a Performing the Installation
3 Upgrading from Previous Versions
a Supported Upgrade Paths
a SQL Server Upgrade Advisor
a Running the Upgrade
4 Working with SQL Server
a Server Management Studio
a Transact SQL
a System Databases
5 Understanding Database Structure
a Files and Filegroups
a Data and Log File
a Choosing a Recovery Model
6 Creating User Databases
a Tables / Views / Indexes
a Enforcing Data Integrity
a Upsizing from Access
7 About Transactions
a ACID Properties
a Committing Transactions
a Transaction Rollbacks
8 Backing up Databases
a Purpose of the Transaction Log
a Simple/ Full/ Bulk Logged Models
a Data/ Differential/ Log/ Copy-Only
a Backup Media Fundamentals
9 Restoring Databases
a Restore and Recovery Concepts
a Complete Restore
a Restoring to a Point in Time
10 User and Security Management
a Logins/ Users/ Roles
a Schemas
a Permissions
11 Overview of Business Intelligence
a Replication
a Integration Services
a Analysis Services
a Reporting Services
a Notification Services
12 Performance Tuning
a Troubleshooting and Tuning
a Overview of SQL Tools
a Dynamic Management Views
|
|
||||||||||
Microsoft SQL Server 20052008
The topics covered are as follows:
1 Introduction
Versions of SQL Server 2005
Hardware Requirements
Software Requirements
SQL Server Components
Licensing Modes
2 Installing SQL Server
Pre-installation Planning
Setting up the Service Accounts
Authentication Modes
Performing the Installation
3 Upgrading from Previous Versions
Supported Upgrade Paths
SQL Server Upgrade Advisor
Running the Upgrade
4 Working with SQL Server
Server Management Studio
Transact SQL
System Databases
5 Understanding Database Structure
Files and Filegroups
Data and Log File
Choosing a Recovery Model
6 Creating User Databases
Tables / Views / Indexes
Enforcing Data Integrity
Upsizing from Access
7 About Transactions
ACID Properties
Committing Transactions
Transaction Rollbacks
8 Backing up Databases
Purpose of the Transaction Log
Simple/ Full/ Bulk Logged Models
Data/ Differential/ Log/ Copy-Only
Backup Media Fundamentals
9 Restoring Databases
Restore and Recovery Concepts
Complete Restore
Restoring to a Point in Time
10 User and Security Management
Logins/ Users/ Roles
Schemas
Permissions
11 Overview of Business Intelligence
Replication
Integration Services
Analysis Services
Reporting Services
Notification Services
12 Performance Tuning
Troubleshooting and Tuning
Overview of SQL Tools
Dynamic Management Views
1 Introduction
Versions of SQL Server 2005
Hardware Requirements
Software Requirements
SQL Server Components
Licensing Modes
2 Installing SQL Server
Pre-installation Planning
Setting up the Service Accounts
Authentication Modes
Performing the Installation
3 Upgrading from Previous Versions
Supported Upgrade Paths
SQL Server Upgrade Advisor
Running the Upgrade
4 Working with SQL Server
Server Management Studio
Transact SQL
System Databases
5 Understanding Database Structure
Files and Filegroups
Data and Log File
Choosing a Recovery Model
6 Creating User Databases
Tables / Views / Indexes
Enforcing Data Integrity
Upsizing from Access
7 About Transactions
ACID Properties
Committing Transactions
Transaction Rollbacks
8 Backing up Databases
Purpose of the Transaction Log
Simple/ Full/ Bulk Logged Models
Data/ Differential/ Log/ Copy-Only
Backup Media Fundamentals
9 Restoring Databases
Restore and Recovery Concepts
Complete Restore
Restoring to a Point in Time
10 User and Security Management
Logins/ Users/ Roles
Schemas
Permissions
11 Overview of Business Intelligence
Replication
Integration Services
Analysis Services
Reporting Services
Notification Services
12 Performance Tuning
Troubleshooting and Tuning
Overview of SQL Tools
Dynamic Management Views
About The Training Provider: Microcomputing Solutions ltd
Microcomputing Solutions ltd - microcomputing has been providing comprehensive IT solutions to businesses throughout the North East since 1981.
microcomputing provides a comprehensive IT solution for businesses including computer software training, technical support for SMEs and hardware and software solutions focusing on maximum efficiency, at a reduced cost for your business.
Our policy of providing a local personal...
