SQLConfigurationSQLConfiguration





DB Web Applications  «Prev  Next»
Lesson 1

Introduction to Database Web Applications

Welcome to Creating Database Web Applications using web technologies.
The most popular Web sites are data-driven.
E-commerce, membership sites, and corporate intranets all depend on databases.
This course introduces you to database functionality for your Web pages.
You will learn how to integrate databases into your sites using
  1. SQL,
  2. design-time controls, and
  3. server-side data access objects.
Microsoft Visual InterDev was part of Microsoft Visual Studio 97 and 6.0. Visual InterDev was an IDE used to create web applications using Microsoft Active Server Pages (ASP) technologies. It used code completion, database server management tools, and an integrated debugger. The extensive InterDev IDE was shared with Microsoft Visual J++, and was the precursor to the Visual Studio .NET IDE. InterDev IDE can also be found in Microsoft Office 2000 as Microsoft Script Editor. Visual Web Developer (integrated into Visual Studio) and Visual Web Developer Express have replaced InterDev in the Visual Studio suite of tools.

When it comes to Web browsing on Windows 10, Microsoft's developers are cleaning house. Among the relics is ActiveX.
Since the new Microsoft Edge browser is more than a reskinned version of Internet Explorer (IE), Edge program managers took to the company's new Microsoft Edge Dev Blog to announce that their group had removed
  1. more than 220,000 lines of code,
  2. more than 300 application programming interfaces and
  3. six document modes from IE's rendering engine
while developing the new browser. In their place, Microsoft's coders have added over 300,000 new lines of code, 4,200 interoperability fixes and 49 major features.



Course goals

After completing this course, you will be able to:
  1. Utilize relational databases in Web pages
  2. Prepare SQL statements to query, update, and insert data via the Web
  3. Use design-time controls to display database information
  4. Use recordsets to manipulate data
  5. Take advantage of advanced query features including outer joins, computed columns, and stored procedures
  6. Use indices to improve database performance
In the next lesson, the prerequisites for this course will be discussed.