USING SQL SERVER
Introduction -- 2 Days
What is SQL Server
What does SQL Server do?
Components of SQL Server
SQL Server and it's Databases
SQL Server Administration Tasks
Common Administrative Components
Designing & Implementing Databases
What is a Relational Database?
Developing a Strategy for Implementing a Database
Creating a Database
Filegroups
Fault Tolerance
Managing Databases
SQL Server
& Data Transformation
Importing VS Linking
DTS Import and Export Wizards
Creating a DTS Package: Using a Wizard
Creating & Managing Tables
Table Properties
Creating a Table with Enterprise Manager
Working with Tables using Query Analyzer
Basic Understanding of SQL
The SELECT Statement
Inserting Data
Updating Tables
Deleting Data
Using Data
stored by SQL Server via Microsoft Office Programs
Defining the Data Source
Building the Query for Word with MS Query
Analysing Numeric Data with Microsoft Excel
Working with SQL Server Data via Microsoft Access
Linking a Remote database to SQL Server
Automating SQL Server Administration
Registering a SQL Server
Web Assistant Wizard
The Backup Wizard
Maintenance Plan Wizard
Troubleshooting SQL Server