|
|
|
|
|
|
SQL Server Programming For Visual Foxpro: Three Days
|
|
|
|
A fast-paced course aimed at Visual FoxPro programmers who want to
use SQL Server as a back-end database.
|
|
This course provides a rapid introduction to SQL
Server programming for VFP developers. It covers the practical aspects
of designing and building efficient SQL Server databases and integrating
them with VFP applications.
|
What you will achieve
At the end of the course, delegates who meet the pre-requisites will be able to plan, design and create
robust VFP applications that fully exploit the power of a SQL Server back end.
|
Pre-Requisites
To benefit from the course, you should have experience of developing applications in Visual FoxPro and be fully
familiar with VFP's data-handling and querying features. You do not need any previous knowledge of SQL Server.
|
|
Course Contents
|
|
Introduction to SQL Server
|
- How SQL Server and VFP fit together.
- SQL Server tools: Enterprise Manager, Query Analyzer.
- Introducing the T-SQL language.
|
|
Designing and building a database
|
- Principles of efficient database design and deployment.
- Creating databases and tables.
- SQL Server data types.
- Indexes and constraints.
|
|
Migrating Visual FoxPro data to SQL Server
|
- The VFP Upsizing Wizard.
- Data Transformation Services.
|
|
Using VFP as a front-end to SQL Server
|
- Configuring data sources and connections.
- Using remote views to access back-end data.
- Modifying server data from within VFP.
- Using SQL Pass-Through to control the server.
- Error-handling.
- Designing an efficient client-server application.
|
|
Programming for SQL Server
|
- T-SQL as a procedural language.
- Batches, transactions and triggers.
- Using T-SQL to write stored procedures.
- Executing stored procedures from within VFP; parameter passing; returned values.
- Understanding system procedures.
|
|
Note
that the course concentrates on database design and programming, and
does not cover administration issues such as backup, security and user accounts.
|
|
|
|
|
|
|
|
