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.
SQL Training Audience:
Database developers and administrators.
SQL Training Prerequisites
A solid understanding of relational databases. Programming experience is helpful.
SQL Training Course duration
2 days
SQL Training Course outline
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
