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.

VERSION

The course is equally applicable to SQL Server 7.0 and SQL Server 2000, and to Visual FoxPro 6.0 and 7.0.

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.

VERSION

The course is equally applicable to SQL Server 7.0 and SQL Server 2000, and to Visual FoxPro 6.0 and 7.0.

E-Mail  us to check availability of places and to make a booking.

 

 

 

 

 

 

 

 

 

tool for foxpro, tools for foxpro, tools for visual foxpro, tool for visual foxpro, report engine, report writer,

query and report engine, third Party Tools, Visual FoxPro Addons, report generation, query generation,

report and query generator, foxpro query generation, cold fusion, cold fusion development, cold fusion web hosting,

cold fusion ecommerce, cold fusion consulting, cold fusion custom development, visual foxpro development,     

visual foxpro tool, visual foxpro tools, tool for foxpro and visual foxpro, tools for foxpro and visual foxpro,

visual foxpro report writer, visual foxpro report engine, visual foxpro query engine, foxpro query engine,

foxpro programming tools, FoxPro programming tool, oracle report writer, oracle reporting tool,

ms sql reporting tool, ms access reporting tool, ms access report writer, ms access reporting tools,

ms sql reporting tools, oracle reporting tools, oracle query engine, ms sql query engine, ms access query engine,

visual foxpro development, custom applications, database applications, visual foxpro report tools, visual foxpro report tool,

vpm, visual promatrix, dbcx data dictionary, pdf report generation, html report generation, xml report generation,

xml report engine, data dictionary for foxpro, foxpro database, visual foxpro database, visual foxpro dbc, web tools,

web tool, visual foxpro web tool, visual foxpro web tools, visual foxpro report framework, foxpro report framework,

foxpro web tool, foxpro web tools, foxpro development, visual foxpro development, foxpro web site development,

foxpro custom software, visual foxpro custom software, ms access custom software, microsoft visual foxpro,

ms access development, accounting software development, foxpro programming, visual foxpro programming,

ms access programming, visual basic programming, client server databases, client server database,

foxpro consulting services, visual foxpro consulting services, ms access consulting services,

visual basic consulting services, VFP Support, vfp support, foxpro support, visual foxpro support,

foxbase programming, foxpro articles, visual foxpro articles, database development, microsoft sql server,

ecommerce web site development, oracle back end, ms sql back end, visual foxpro front end, foxpro front end,

foxgang, computer services, computer consulting, computer consulting services, foxpro training,

visual foxpro training, accounting system, accountmate, accpac, foxpro consultant, quicken, quickbooks,

collage tracking system, collage software, purchase department software, bidstar software, high school tracking,

accounting software development, tools for accounting, reporting tool for accounting, tool for accounting,

database design, relational database, purchasing department, custom accounting, point of sale, web based accounting,

dos conversion, rbase development, dot net, .net, dotnet, custom programming, custom made applications,

custom made application, quality assurance, visual foxpro, web hosting, web page, crystal reports, programming resource,

vfp training, vfp programming, visual foxpro consultant