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.

Develop different CAD Programs and Different Management Software

Develop MS Access Application to this Chemical Company.

Develop Accounting Modules for the accounting department

Develop Buying Power Membership Software to reduce the buying cost

Student Loan Management - No interest Loan Management at glance:

Car Rental Software - Contract manager for the Avis Car Rental Company. It has 30 different locations in North NJ USA.

Case Management Software to Manage the Law Firm Cases

Develop Inventory Control System for an Order Fulfillment Center

Develop a Search Engine and Inventory Control System for Truck Parts Distributor