  
                     
|
| |
 |
MICROSOFT SQL SERVER 7.0 - LEVEL 1
| Course Description |
|
Level 1 is for developers coming from Microsoft Access or Visual Basic development backgrounds who have applications that they’re hoping to upsize to SQL Server. 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. This introductory course teaches you the fundamentals and gives you a taste of the potential of Microsoft SQL Server 7.0.
Course Length: 2 Days
Course Tuition: $790 (US)
|
| Prerequisites |
|
| A solid understanding of relational databases. Programming experience is helpful.
|
• 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
Contact us for course schedules or more
information.
|
|
|
|
|
|
|
