SQL Server 7 Level 1 Course

Course Code: RT 378
Course Abstract: This course is for developers coming from Microsoft Access or Visual Basic development backgrounds who have applications that they’re hoping to upsize to SQL Server. Participants learn some of the issues with installation and configuration, database design issues, how to import non-Jet data, and how to either share data between SQL Server and Jet, or completely upsize data to SQL Server.
Audience: This course is designed for developers.
Duration: 2 days
Learning Outcomes: Upon completion of this course, the participant will be able to:
> Learn to install and configure Microsoft SQL Server 7.0
> Set up and normalize your database
> Import and link data to Microsoft SQL Server
> Convert databases from Microsoft SQL Server 6.5 to Microsoft Server 7.0
> Migrate your Microsoft Access databases into Microsoft SQL Server 7.0
Course Topics:

SQL Server Tour
SQL Server Components
Management Tools
Overview of SQL Server Security
Using Books Online

Installation and Configuration of SQL Server
Prerequisites
Installing SQL Server
Upgrading from Previous Versions of SQL Server
Uninstalling SQL Server
Configuring the Server

Setting Up a Database
Creating Databases
Creating, Dropping, and Altering Tables
Modifying Tables
Creating Indexes

Database Design
What Is Data Normalization?
Tools for Enforcing Data Integrity

Importing Data
Data Transformation Services (DTS)
Using BCP (Bulk Copy Program)
Alternative Ways of Importing Data

Migrating from Access to SQL Server
Introduction to Client/Server
Upsizing Access to SQL Server

Prerequisites: To get the most out of the Introduction to Microsoft SQL Server 7.0 course, participants should have a solid understanding of relational databases. No particular programming experience is required, but the course is taught from a developer's perspective.
Note: All fields are required
At the present time we do not offer training for individuals or groups less then 6 individuals. We apologize for any inconvenience.


We Value Your Privacy!

Ready to get started or in need of more information? Contact us today.

Go To Blog Virtual Learning

Testimonials

Alot of information was exchanged in a short period of time, but the instructor did a good job of highlighting and scaling down the information.

Student- Implementing and Administering Windows Vista