O'Reilly logo

Visual Basic® .NET Database Programming by Rod Stephens

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Building a Database with SQL

Access, SQL Server, Oracle, and other database design tools build databases for you. When you design tables and relationships in Access, Access modifies the database accordingly.

One problem with these design tools is that they are all different. You need to use different methods to define tables and relationships.

Another potentially more important problem is that to use these tools you need to own them. If you want to build a small database using MSDE, you may not want to spend a few hundred dollars buying Access.

Fortunately, relational databases support SQL (Structured Query Language), an industry standard language for building and manipulating relational databases and their content. SQL includes statements ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required